Bug #33767 Falcon crash on thread creation
Submitted: 9 Jan 2008 13:31 Modified: 17 Jan 2008 22:14
Reporter: Philip Stoev Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: CPU Architecture:Any

[9 Jan 2008 13:31] Philip Stoev
Description:
When running the iuds2 systems test against falcon, the following crash occured 30 minutes after starting the test.

#0  0x00000033c040b002 in pthread_kill () from /lib64/libpthread.so.0
(gdb) bt
#0  0x00000033c040b002 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000660113 in handle_segfault (sig=4) at mysqld.cc:2313
#2  <signal handler called>
#3  0x00000033c040dc1d in raise () from /lib64/libpthread.so.0
#4  0x00000000008586bc in Error::error (string=<value optimized out>) at Error.cpp:92
#5  0x000000000083744d in Cache::ioThread (this=0x2aaaaacc2098) at Cache.cpp:984
#6  0x00000000008252b4 in Thread::thread (this=0x2aaaaacc25d0) at Thread.cpp:161
#7  0x0000000000825479 in Thread::thread (parameter=0xed3) at Thread.cpp:140
#8  0x00000033c04061b5 in start_thread () from /lib64/libpthread.so.0
#9  0x00000033bf8cd39d in clone () from /lib64/libc.so.6
#10 0x0000000000000000 in ?? ()

falcon_debug_mask=65535 shows this:

Stalled threads
  Thread 0x136e7208 (1197381952) sleep=0, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0x2aaaaad0b770
  Thread 0x13709510 (1198180672) sleep=1, grant=0, locks=1, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syncObject 0x2aaaaad0b770
  Thread 0x149365f8 (1203505472) sleep=1, grant=0, locks=2, who 0, parent=(nil)
    Pending Table::insert state 0 (1) syn080109 16:14:07 - mysqld got signal 4;

How to repeat:
run iuds2 systems test with iuds2.tst showing Falcon only, and not innodb and myisam. In run_systest with optimal Falcon settings, please also modify start_server()

--mysqld="--falcon_record_memory_max=2GB"
--mysqld="--max_connections=500"
--mysqld="--falcon-lock-wait-timeout=1"
--mysqld=--skip-innodb --mysqld=--log-output=TABLE
--mysqld=--falcon_debug_mask=65535
[17 Jan 2008 22:14] Philip Stoev
This has only happened once on a specific machine and on a pushbuild binary. Will reopen if it happens again.