[MDEV-24401] Deadlocks on Rocksdb when there should not be one Created: 2020-12-14  Updated: 2021-01-11

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.5.8
Fix Version/s: 10.5

Type: Bug Priority: Major
Reporter: Philip orleans Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Linux

Issue Links:
Relates
relates to MDEV-16428 Simple concurrent DML on RocksDB tabl... Confirmed

 Description   

I got this:
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
But the problem is, the updates were no overlapping. I controlled all the updates and the "where x-y and z=t" conditions made it impossible to overlap a single row. Also the message mentions "snapshot conflict" and that makes me think this an internal issue with RockDB. That's why I am reporting it as a bug.
Generated at Thu Feb 08 09:29:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.