errno: 140 "Wrong create options"
Description
Environment
Smart Checklist
Activity

Jira Bot August 3, 2020 at 8:56 AM
Hello ,
It's been 52 days since this issue went into Incomplete and we haven't heard
from you on this.
At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Jira Bot July 26, 2020 at 8:56 AM
Hello ,
It's jira-bot again. Your bug report is important to us, but we haven't heard
from you since the previous notification. If we don't hear from you on
this in 7 days, the issue will be automatically closed.

Jira Bot July 11, 2020 at 7:56 AM
Hello ,
I'm jira-bot, Percona's automated helper script. Your bug report is important
to us but we've been unable to reproduce it, and asked you for more
information. If we haven't heard from you on this in 3 more weeks, the issue
will be automatically closed.

Lalit Choudhary June 12, 2020 at 7:39 AM
Hi
Thank you for the report.
I'm not able to reproduce the described issue with MariaDB 10.4.13 and PT 3.2.
Let me know if you have a reproducible test case.
My Test:

nunop June 9, 2020 at 12:31 PM
Exporting with phpMyAdmin:
CREATE TABLE `my_table` (
{{ `mid` bigint(18) UNSIGNED NOT NULL,}}
{{ `msgid` bigint(18) UNSIGNED NOT NULL,}}
{{ `message` text COLLATE utf8mb4_unicode_ci NOT NULL,}}
{{ `from` bigint(18) UNSIGNED NOT NULL,}}
{{ `time` int(10) UNSIGNED NOT NULL,}}
{{ `edited` int(10) UNSIGNED DEFAULT NULL,}}
{{ `col1` enum('0','1') CHARACTER SET utf8 NOT NULL DEFAULT '0',}}
{{ `col2` int(10) UNSIGNED DEFAULT 0}}) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci KEY_BLOCK_SIZE=8 ROW_FORMAT=COMPRESSED;
ALTER TABLE `my_table`
{{ ADD PRIMARY KEY (`msgid`),}}
{{ ADD KEY `from` (`from`),}}
{{ ADD KEY `col2` (`col2`),}}
{{ ADD KEY `mid` (`mid`) USING BTREE,}}
{{ ADD KEY `time` (`time`);}}
ALTER TABLE `my_table`
{{ MODIFY `msgid` bigint(18) UNSIGNED NOT NULL AUTO_INCREMENT;}}
ALTER TABLE `my_table`
{{ ADD CONSTRAINT `_my_table_ibfk_1` FOREIGN KEY (`mid`) REFERENCES `my_parent_table` (`mid`) ON DELETE CASCADE ON UPDATE NO ACTION,}}
{{ ADD CONSTRAINT `_my_table_ibfk_2` FOREIGN KEY (`from`) REFERENCES `my_users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION;}}
Details
Assignee
Lalit ChoudharyLalit ChoudharyReporter
nunopnunopPriority
Medium
Details
Details
Assignee

Reporter

Priority
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

MariaDB 10.4
Trying to run:
pt-online-schema-change --alter "ENGINE=InnoDB ROW_FORMAT=DYNAMIC KEY_BLOCK_SIZE=0 PAGE_COMPRESSED=1 PAGE_COMPRESSION_LEVEL=9" --execute h=localhost,D=mydb,t=my_table
Getting "Wrong create options" when creating a copy of the existing table (which is currently COMPRESSED):