Details
-
New Feature
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.x, Not 5.6.x, Not 5.7.x
-
None
Description
ALTER TABLE mytable ADD PARTITION (PARTITION p8 VALUES LESS THAN (8000000))’; from InnoDB master to MyRocks replica, I get: [ERROR] [MY-010584] [Repl] Slave SQL for channel ”: Error ‘Got error 10 ‘Operation aborted: Failed to acquire lock due to rocksdb_max_row_locks limit’ from ROCKSDB’ on query. Default database: ‘xyz’. Query: ‘ALTER TABLE xyz.mytable ADD PARTITION (PARTITION p8 VALUES LESS THAN (8000000))’, Error_code: MY-001296 [Warning] [MY-010584] [Repl] Slave: Inplace partition altering is not supported Error_code: MY-000138 1.) is there any chance to execute ALTER TABLE through replication? 2.) is there any plan to support ADD/DROP PARTITION without rebuilding the whole table? For us, this is a show stopper. I really wanted to use MyRocks, but I can’t