Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.5.4
-
CentOS Linux release 7.4.1708
Description
A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. In our configuration, all writes go to 1 node only. And we started facing deadlocks (gap locking) issue on that node. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.
Could you please advise on this and please let me know what additional information will you require for further investigation?
Thank you.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Component/s | Galera [ 10124 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Assignee | Jan Lindström [ jplindst ] |
Description |
A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. And we started facing deadlocks (gap locking) issue. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.
Could you please advise on this and please let me know what additional information will you require for further investigation? Thank you. |
A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. In our configuration, all writes go to 1 node only. And we started facing deadlocks (gap locking) issue on that node. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.
Could you please advise on this and please let me know what additional information will you require for further investigation? Thank you. |
Labels | upgrade | need_feedback upgrade |
Attachment | galera_error_log_part.log [ 52980 ] | |
Attachment | galera.cnf [ 52981 ] |
Labels | need_feedback upgrade | upgrade |
Fix Version/s | N/A [ 14700 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Resolution | Not a Bug [ 6 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Resolution | Not a Bug [ 6 ] | |
Status | Closed [ 6 ] | Stalled [ 10000 ] |
Attachment | galera_error.log_2node.gz [ 53241 ] | |
Attachment | galera_error.log_3node.gz [ 53242 ] |
Attachment | screenshot-1.png [ 53245 ] |
Labels | upgrade | need_feedback upgrade |
issue.field.resolutiondate | 2020-09-14 09:00:58.0 | 2020-09-14 09:00:58.59 |
Resolution | Cannot Reproduce [ 5 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 111722 ] | MariaDB v4 [ 158148 ] |
You could start sharing your config files and error logs but you must be aware that gap locks are normal on InnoDB and they are needed for consistency. 10.5 does not anymore support innobase_locks_unsafe_for_binlog so you may need to use READ COMMITTED transaction isolation level instead on some cases or you need to handle deadlocks because of gap locking in your application.