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)
• Status: Can't repeat
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 5.2.3-falcon-alpha-debug
• OS: Linux (suse9.3 x86)
• CPU Architecture: Any

[12 Feb 2007 22:43] Shane Bester

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:
.

[12 Feb 2007 22:48] MySQL Verification Team

some info regarding the hangup.

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

[12 Feb 2007 22:58] MySQL Verification Team

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.

[13 Feb 2007 8:22] MySQL Verification Team

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

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

[13 Feb 2007 8:24] MySQL Verification Team

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.

[17 Sep 2007 16:48] Hakan Küçükyılmaz

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