[MDEV-24747] MariaDB Crashes after transactions locked due to semasphore and subsequent attempted blocking transaction rollback (kill) Created: 2021-01-31 Updated: 2021-01-31 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Server, Storage Engine - InnoDB |
| Affects Version/s: | 10.5.6 |
| Fix Version/s: | 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Larry Adams | Assignee: | Marko Mäkelä |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | blocking, crash, semaphore | ||
| Environment: |
CentOS8.3, x86_64, 1.5TB memory, 91TB NVMe, 244 threads. |
||
| Attachments: |
|
| Description |
|
I have quite a few transations, inserts, update's etc. on one of our tables from multiple clusters. I was monitoring the server and noticed that it became unresponsive to transactions, so I checked the processlist and saw that transactions were backing up. I captured an 'show engine innodb status' and then attempted to kill (rollback) the blocking 'update' transaction. Within a minute the server crashed and rebooted. Server is currently participating in async replication with three additional servers. Been quite pleased with the performance. I will attach the mariadb.log and the show_engine_innodb_status output as separate files. I'm working at fixing those unsafe binary log transactions. Not sure if that has anything to do with the crash. |
| Comments |
| Comment by Larry Adams [ 2021-01-31 ] |
|
Just to be clear, the 'server' did not crash, but the MariaDB service did, and restarted. |