MySQL Bugs: #28048: High probability of crash when executing transactional tests several times

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

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

Test case is falcon_bug_28048.test.

Re-opened per discussion with Hakan on IRC.

Verified via Pushbuild mysql-6.0-backup-merge tree result.

May be related to 22165

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.

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.

Related to Bug#36700.