Details
Description
CREATE SEQUENCE CHANGE_EVENTS_SID_SEQ START WITH 1577836800000000 INCREMENT BY 1;
ERROR 1235 (42000): This version of MariaDB doesn't yet support 'In Galera if you use CACHE you should set INCREMENT BY 0 to behave correctly in a cluster'
It also failed with other MariaDB releases using Galera starting. (Works without Galera enabled)
version = 10.6.16-11-MariaDB-enterprise-log
version = 10.5.22-16-MariaDB-enterprise-log
wsrep_provider_version = 26.4.14-1(ra480e94)
wsrep_provider_version = 26.4.16
wsrep_patch_version = wsrep_26.22
Workaround it by adding the NOCACHE option per example below:
CREATE SEQUENCE CHANGE_EVENTS_SID_SEQ START WITH 1577836800000000 INCREMENT BY 1 NOCACHE;
Query OK, 0 rows affected (1.417 sec)
Attachments
Issue Links
- is caused by
-
MDEV-30388 Assertion `!wsrep_has_changes(thd) || (thd->lex->sql_command == SQLCOM_CREATE_TABLE && !thd->is_current_stmt_binlog_format_row()) || thd->wsrep_cs().transaction().state() == wsrep::transaction::s_aborted' failed
- Closed
- relates to
-
MDEV-32024 Galera library 26.4.16 fails with every server version
- Closed