Bug #28048 High probability of crash when executing transactional tests several times
Submitted: 23 Apr 2007 21:33 Modified: 11 Jun 2008 18:57
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.0-alpha OS:Any
Assigned to: CPU Architecture:Any
Triage: D1 (Critical)

[23 Apr 2007 21:33] Hakan Küçükyılmaz
Description:
When I execute a small transactional test within a loop I get either
a hanging server with 100 % CPU consumption or a crash.

How to repeat:
Program received signal SIGSEGV, Segmentation fault.
0x086c7974 in Table::touched (this=0x9495b88) at Table.cpp:1445
1445 ageGroup = database->currentAgeGroup;
(gdb) where
0 0x086c7974 in Table::touched (this=0x9495b88) at Table.cpp:1445
1 0x08718b40 in RecordVersion::commit (this=0x9488c48)
    at RecordVersion.cpp:95
0000002 0x086cd6d2 in Transaction::commitRecords (this=0x94956a8)
    at Transaction.cpp:289
0000003 0x086cd125 in Transaction::commit (this=0x94973c8) at Transaction.cpp:154
0000004 0x086ddd96 in Connection::commit (this=0x94873b8) at Connection.cpp:267
0000005 0x086ba019 in StorageConnection::commit (this=0x94868e0)
    at StorageConnection.cpp:247
0000006 0x086b247b in NfsStorageTable::commit (thd=0x93fff98, all=true)
    at ha_falcon.cpp:595
0000007 0x083572a0 in ha_commit_one_phase (thd=0x93fff98, all=true)
    at handler.cc:718
0000008 0x08357121 in ha_commit_trans (thd=0x93fff98, all=true) at handler.cc:688
0000009 0x0828b0d4 in end_trans (thd=0x93fff98, completion=COMMIT)
    at sql_parse.cc:1441
0000010 0x08291cf8 in mysql_execute_command (thd=0x93fff98) at sql_parse.cc:4195
0000011 0x08296072 in mysql_parse (thd=0x93fff98, inBuf=0x94313c0 "commit",
    length=6) at sql_parse.cc:5947
0000012 0x0828bbfd in dispatch_command (command=COM_QUERY, thd=0x93fff98,
    packet=0x9429361 "commit", packet_length=7) at sql_parse.cc:1764
0000013 0x0828b46c in do_command (thd=0x93fff98) at sql_parse.cc:1550
0000014 0x0828a5ea in handle_one_connection (arg=0x93fff98) at sql_parse.cc:1190
---Type <return> to continue, or q <return> to quit---
0000015 0x40253aa7 in start_thread () from /lib/tls/libpthread.so.0
0000016 0x401e9c2e in clone () from /lib/tls/libc.so.6
[23 Apr 2007 21:33] Hakan Küçükyılmaz
Test case is falcon_bug_28048.test.
[15 Apr 2008 9:04] Rafal Somla
Re-opened per discussion with Hakan on IRC.
[15 Apr 2008 9:11] Hakan Küçükyılmaz
Verified via Pushbuild mysql-6.0-backup-merge tree result.
[28 Apr 2008 19:31] Kevin Lewis
May be related to 22165
[13 May 2008 16:07] Kevin Lewis
Hakan,  This test case is not failing anymore.  It was failing regularly on pushbuild before 4/15/2008.  But the failures stopped.  Please determine if this is still a problem.  If so, what is the current call stack.  The function Table::touched() listed in this bug does not even exist anymore.
[13 May 2008 18:49] Hakan Küçükyılmaz
Test case does not crash Falcon anymore. However running the test several times shows monotone increasing run time and memory usage. I will open a new bug with details about the new issue.
[14 Jul 2008 15:46] Hakan Küçükyılmaz
Related to Bug#36700.