[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: File innodb_status_issues_locking.gz     File mariadb.log.ticket.gz    

 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.

Generated at Thu Feb 08 09:32:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.