Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 11.0(EOL), 11.3(EOL), 11.5(EOL)
-
None
Description
SET storage_engine=InnoDB,default_storage_engine='MEMORY'; # Warning: 1287 | '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead |
CREATE TABLE t (c INT) ROW_FORMAT=FIXED; |
Works on the master (table is created as MEMORY) but fails on the slave with:
|
11.5.0 929c2e06aae47f2dabf51b843ac84911de95bc7f (Debug, Slave) |
2024-04-22 16:37:54 6 [ERROR] Slave SQL: Error 'Can't create table `test`.`t` (errno: 140 "Wrong create options")' on query. Default database: 'test'. Query: 'CREATE TABLE t (c INT) ROW_FORMAT=FIXED', Gtid 0-1-4, Internal MariaDB error code: 1005
|
2024-04-22 16:37:54 6 [Warning] Slave: InnoDB: invalid ROW_FORMAT specifier. Error_code: 1478
|
2024-04-22 16:37:54 6 [Warning] Slave: Can't create table `test`.`t` (errno: 140 "Wrong create options") Error_code: 1005
|
2024-04-22 16:37:54 6 [Warning] Slave: Got error 140 "Wrong create options" from storage engine InnoDB Error_code: 1030
|
2024-04-22 16:37:54 6 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.000001' position 959; GTID position '0-1-3'
|
2024-04-22 16:37:54 6 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.000001' at position 959; GTID position '0-1-3', master: 127.0.0.1:10082
|