[MDEV-26468] [ERROR] WSREP: invalid state ROLLED_BACK (FATAL) Created: 2021-08-24 Updated: 2022-01-10 Resolved: 2022-01-10 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, wsrep |
| Affects Version/s: | 10.3.31 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Victor Angelier | Assignee: | Jan Lindström (Inactive) |
| Resolution: | Incomplete | Votes: | 1 |
| Labels: | galera | ||
| Environment: |
CentOS 7 3.10.0-1160.36.2.el7.x86_64 |
||
| Attachments: |
|
| Description |
|
Cluster keeps crashing after random time period of time. Its been there for a while but now we added a third node and the problem increased. I am now at the point that there is something wrong with the MariaDB service as the crash report understates this. The table which is likely causing the crash is using InnoDB. Structure: Table: news Columns: According to the error message: 2021-08-21 14:27:19 1 [Note] WSREP: Victim thread: The 'views' are updates with Queued Jobs and therefor its impossible that this update event is executed by multiple instances by one user within x seconds. All nodes are clones of 1 master image, meaning; software wise they are the exact same VM's. I attached the logs of the other 2 nodes at the time of the crash. All connections to the DB are handled by Galera Load Balancer. At first this helped al lot, but now with new node added, the problem returned. #server.cnf attached. |
| Comments |
| Comment by Imre Jonk [ 2021-11-03 ] |
|
I think this is a duplicate of https://jira.mariadb.org/browse/MDEV-25114 |
| Comment by Victor Angelier [ 2021-11-03 ] |
|
Meh, not really. |
| Comment by Jan Lindström (Inactive) [ 2021-12-09 ] |
|
digitalhuman This does look much like |