[MDEV-32239] [Warning] WSREP: ALTER SEQUENCES declared without `NOCACHE` will not behave correctly in galera cluster. Created: 2023-09-25 Updated: 2023-12-15 Resolved: 2023-09-25 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | William Wong | Assignee: | Jan Lindström |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
redhat 7 on VMware |
||
| Description |
|
Hi, One of our DB is using 2 DB nodes + 1 aribtrator architecture with HAProxy on top. Found below message several times per day in DB log.
Kindly advise the meaning of this message and anything to pay attention to. Regards, |
| Comments |
| Comment by Jan Lindström [ 2023-09-25 ] |
|
frelist This is warning, it means that if sequence is defined without NOCACHE keyword, they might not work correctly in multi-master Galera workload. You can change this by ALTER TABLE <seq_name> NOCACHE engine=INNODB; |
| Comment by William Wong [ 2023-12-15 ] |
|
Hi Jan, >> if sequence is defined without NOCACHE keyword, they might not work correctly in multi-master Galera workload We cannot find this message in MariaDB documentation In fact, we encountered performance issue and deadlock error when setting sequence nocache. Regards, |