MySQL Bugs: #26298: all threads deadlocked when accessing falcon table

Bug #26298	all threads deadlocked when accessing falcon table
Submitted:	12 Feb 2007 22:43	Modified:	17 Sep 2007 16:48
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	5.2.3-falcon-alpha-debug	OS:	Linux (suse9.3 x86)
Assigned to:		CPU Architecture:	Any

Description:
spawned 150 threads doing the following operations to a table;

set global thread_cache_size...
INSERT IGNORE INTO...
REPLACE INTO...
SHOW TABLE STATUS...
SELECT * FROM... ORDER BY .. LIMIT 10

Attached are the complete logs from the hang. SHOW ENGINE FALCON STATUS didn't show anything.

How to repeat:
no standalone testcase yet.

tester with parameters: --host=192.168.250.2:3306 --queryfile=falcon.query --threads=150 --duration=600 --shuffle-queries=1 --user=root --database=test --generate-queryfile=0

Suggested fix:
.

some info regarding the hangup.

Attachment: bug29268_info.txt (text/plain), 50.02 KiB.

mysqld had to be shutdown using kill -9.
kill <threadid> didn't work,
mysqladmin shutdown managed to close all ~100 connections, down to

Forcing close of thread 46  user: 'root'

then it hung.

see header of file for compile instructions + host,user,database,port

Attachment: testcase.c (text/plain), 11.14 KiB.

testcase is uploaded.  verified on 5.2.3-falcon-alpha-debug built using yesterdays BK source on suse 9.3 x86 with 2GB of ram.

Retested with latest Falcon code. I had to adjust the test case to use 150 concurrent threads.

Default run time is 10 hours and the testcase ran 10 hours without crash or hang.

Best regards,

Hakan