Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Cannot Reproduce
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
sysbench 0.4.12 with options:
--mysql-table-engine=innodb
--test=oltp --oltp-table-size=10000000 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0
--oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-non-index-updates=0
--max-requests=0 --max-time=300 --num-threads=2, 4, 8. 16, 32
for 2 threads get approx 1200 tps and 0 deadlocks, but for 4, 8, 16, 32 get ~200 tps and steadily increasing numbers of deadlocks (10 up to 297).
Innodb status for deadlocks shows:
------------------------
LATEST DETECTED DEADLOCK
------------------------
110915 18:30:47
-
-
- (1) TRANSACTION:
TRANSACTION 12F6E6, ACTIVE 28 sec, process no 5598, OS thread id 140207001040640 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
MySQL thread id 70, query id 3110358 localhost mysql updating
DELETE from sbtest where id=? - (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 54 n bits 144 index `PRIMARY` of table `bench`.`sbtest` trx id 12F6E6 lock_mode X waiting - (2) TRANSACTION:
TRANSACTION 12BBA9, ACTIVE 53 sec, process no 5598, OS thread id 140207769769728 fetching rows
mysql tables in use 1, locked 1
36824 lock struct(s), heap size 3586488, 2724783 row lock(s)
MySQL thread id 62, query id 3066651 localhost mysql Updating
UPDATE sbtest set k=k+1 where id=? - (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 54 n bits 144 index `PRIMARY` of table `bench`.`sbtest` trx id 12BBA9 lock_mode X - (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 39541 n bits 144 index `PRIMARY` of table `bench`.`sbtest` trx id 12BBA9 lock_mode X waiting - WE ROLL BACK TRANSACTION (1)
- (1) TRANSACTION:
-
A run with identically configured mariadb 5.2.7 elicits no deadlocks for any of the 2-> 32 threads.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Deadlocks occurring with sysbench against mariadb 5.3.1 beta + innodb
Platform is Ubuntu 11.04 64 bit.
Mariadb 5.3.1 built from source:
$ CFLAGS='-g -O2 -fno-strength-reduce' \
CXXFLAGS='-g -O2 -fno-rtti -fno-exceptions -felide-constructors -fno-strength-reduce' \
./configure --prefix=/usr/local/maria/5.3 --enable-local-infile \
--with-plugins=xtradb,pbxt,aria,partition
Non default options in my.cnf:
datadir = /data0/madata/5.3
default_storage_engine = innodb