Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34116

mariadb10.5.23 upgrade to mariadb10.6.17 ,remove partition error

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.17
    • None
    • None
    • None
    • windows

    Description

      MariaB [dsa]> ALTER TABLE h_picrecord_wanted_xs REMOVE partitioning;
      ERROR 1025 (HY000): Error on rename of '.\dsa#sql-alter-b128-189' to '.\dsa\h_picrecord_wanted_xs' (errno: 184 "Tablespace already exists")

      CREATE TABLE `h_picrecord_wanted_xs` (
      `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '??',
      `DEV_ID` varchar(50) NOT NULL COMMENT '??ID',
      `DEV_CHNNUM` int(11) NOT NULL COMMENT '????',
      `DEV_NAME` varchar(50) NOT NULL COMMENT '????',
      `DEV_CHNNAME` varchar(50) NOT NULL COMMENT '????',
      `CAR_NUM` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '???',
      `CAR_NUMTYPE` int(11) NOT NULL COMMENT '????',
      `CAR_NUMCOLOR` int(11) NOT NULL COMMENT '????',
      `CAR_SPEED` int(11) NOT NULL COMMENT '??',
      `CAR_TYPE` int(11) NOT NULL COMMENT '??',
      `CAR_COLOR` int(11) NOT NULL COMMENT '???',
      `CAR_LENGTH` int(11) DEFAULT NULL COMMENT '??',
      `CAR_DIRECT` varchar(8) NOT NULL COMMENT '????',
      `CAR_WAY_CODE` varchar(12) NOT NULL COMMENT '????',
      `CAP_TIME` int(11) DEFAULT NULL COMMENT '????',
      `CAP_DATE` datetime NOT NULL COMMENT '????',
      `WAN_ORG` varchar(50) DEFAULT NULL COMMENT '????',
      `OPT_ORG` varchar(50) DEFAULT NULL COMMENT '????',
      `OPT_USER` varchar(50) DEFAULT NULL COMMENT '????',
      `INF_NOTE` varchar(255) DEFAULT NULL COMMENT '????',
      `MAX_SPEED` int(11) DEFAULT NULL COMMENT '????',
      `MIN_SPEED` int(11) DEFAULT NULL COMMENT '??????',
      `CAR_IMG_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `CAR_IMG1_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `CAR_IMG2_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `CAR_IMG3_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `CAR_IMG4_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `CAR_IMG5_URL` varchar(255) DEFAULT NULL COMMENT '??????',
      `REC_STAT` tinyint(4) DEFAULT 0 COMMENT '????',
      `DEV_CHNID` varchar(50) NOT NULL COMMENT '??????',
      `SAVE_FLAG` tinyint(4) DEFAULT 0 COMMENT '???????????',
      `SURVEY_IMGURL` varchar(255) DEFAULT NULL COMMENT '??????',
      `DC_CLEANFLAG` tinyint(4) DEFAULT 0 COMMENT 'DATACLEAN??????????????',
      `SURVEY_TYPE` int(11) NOT NULL COMMENT '????',
      `CAR_IMG_PLATE_LEFT` int(11) DEFAULT NULL COMMENT '?????????LEFT',
      `CAR_IMG_PLATE_TOP` int(11) DEFAULT NULL COMMENT '?????????TOP',
      `CAR_IMG_PLATE_RIGHT` int(11) DEFAULT NULL COMMENT '?????????RIGHT',
      `CAR_IMG_PLATE_BOTTOM` int(11) DEFAULT NULL COMMENT '?????????BOTTOM',
      `CAR_NUM_PIC` varchar(255) DEFAULT NULL COMMENT '?????URL',
      `COMBINED_PIC_URL` varchar(255) DEFAULT NULL COMMENT '????????URL',
      `VERIFY_MEMO` varchar(255) DEFAULT NULL COMMENT '????????????',
      `CREATE_TIME` timestamp NOT NULL DEFAULT current_timestamp() COMMENT '????',
      `SERVICE_CODE` varchar(20) NOT NULL DEFAULT '0' COMMENT '???????',
      `SURVEY_ID` varchar(40) DEFAULT NULL,
      `PIC_RECORD_WANTED_IDX` varchar(60) DEFAULT NULL,
      `PIC_RECORD_IDX` varchar(60) DEFAULT NULL,
      `CROSSROAD_ID` varchar(30) DEFAULT NULL,
      `CHAN_CODE` varchar(30) DEFAULT NULL,
      `DATA_SOURCE` tinyint(4) NOT NULL DEFAULT 0 COMMENT '????????0?1-?2-?3???4-????',
      `CAP_DAY` date DEFAULT NULL COMMENT '????',
      `CAP_DATE_UTC` bigint(20) DEFAULT NULL COMMENT '????utc',
      KEY `PK_C_PICRECORD_WANTED` (`ID`),
      KEY `IDX_CPW_CAP_DATE` (`CAP_DAY`,`CAP_DATE_UTC`),
      KEY `IDX_CPW_COMBINE_UTC` (`CAR_NUM`,`CAP_DATE_UTC`),
      KEY `IDX_CPW_CAP_DATE_UTC` (`CAP_DATE_UTC`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='???????'
      PARTITION BY RANGE (to_days(`CAP_DAY`))
      (PARTITION `P20230519` VALUES LESS THAN (739025) ENGINE = InnoDB,
      PARTITION `p20230520` VALUES LESS THAN (739026) ENGINE = InnoDB,
      PARTITION `p20230521` VALUES LESS THAN (739027) ENGINE = InnoDB)

      Attachments

        Activity

          People

            Unassigned Unassigned
            kennyliao kennyliao
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.