Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
One cannot update a MyRocks table when they have binlog_format=MIXED:
MariaDB [test]> create table t1 (pk int primary key) engine=rocksdb;
|
Query OK, 0 rows affected (0.15 sec)
|
 |
MariaDB [test]> insert into t1 values (1);
|
ERROR 4056 (HY000): Can't execute updates on master with binlog_format != ROW.
|
MariaDB [test]>
|
MariaDB [test]> select @@binlog_format;
|
+-----------------+
|
| @@binlog_format |
|
+-----------------+
|
| MIXED |
|
+-----------------+
|
1 row in set (0.00 sec)
|
This doesn't make sense from a user perspective:
- MyRocks supports RBR only
- binlog_format=MIXED means "try to use SBR but switch to RBR if required".
- I expect that I'm able to run MyRocks with binlog_format=mixed and get RBR logging for updates to MyRocks tables.