| Bug #35991 | Falcon assertion on TRUNCATE in Section::getSectionPage Section.cpp line 198 | ||
|---|---|---|---|
| Submitted: | 11 Apr 2008 11:29 | Modified: | 5 Oct 2008 14:59 |
| Reporter: | Philip Stoev | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 6.0-falcon-team | OS: | Any |
| Assigned to: | Vladislav Vaintroub | CPU Architecture: | Any |
[11 Apr 2008 11:32]
Philip Stoev
test case for bug 35991
Attachment: bug35991.pl (text/plain), 923 bytes.
[11 Apr 2008 11:33]
Philip Stoev
Please find attached the test case. Crash will happen within 30 seconds. The test case is derived from bug #35322, with the addition of a TRUNCATE TABLE.
[11 Apr 2008 12:24]
Vladislav Vaintroub
The assertion is ASSERT(page->pageType == PAGE_sections || page->pageType == 0); the page type is 11 (==PAGE_free)
[22 Aug 2008 18:03]
Kevin Lewis
Fix is in version 6.0.7
[28 Aug 2008 20:15]
Bugs System
Pushed into 6.0.7-alpha (revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (version source revid:cbell@mysql.com-20080822132131-uveo6wiuecy6m2b8) (pib:3)
[28 Aug 2008 23:47]
Kevin Lewis
See Bug#22165 for other changes that helped to fix this including the addition of TransactionManager::waitForWriteComplete. http://lists.mysql.com/commits/51311 This bug is different than Bug#22165 in that this is about the truncate operation and 22165 is related to ALTER TABLE.
[14 Sep 2008 2:42]
Bugs System
Pushed into 6.0.7-alpha (revid:vvaintroub@mysql.com-20080804155352-071nj3gc85f1sbhc) (version source revid:sven@mysql.com-20080818175803-c1nutd5773r6b4gd) (pib:3)
[5 Oct 2008 14:59]
Jon Stephens
Documented in the 6.0.7 changelog as follows:
Executing TRUNCATE statements with interleaving transactions
could cause mysqld to crash.
Description: When running a DML workload, Falcon asserted as follows: #0 0x00110402 in __kernel_vsyscall () #1 0x00bdc617 in pthread_kill () from /lib/libpthread.so.0 #2 0x08449ed3 in write_core (sig=4) at stacktrace.c:305 #3 0x082a392b in handle_segfault (sig=4) at mysqld.cc:2621 #4 <signal handler called> #5 0x00110402 in __kernel_vsyscall () #6 0x00bdf891 in raise () from /lib/libpthread.so.0 #7 0x0851836c in Error::debugBreak () at Error.cpp:92 #8 0x085183c8 in Error::error (string=0x889cca4 "assertion failed at line %d in file %s\n") at Error.cpp:69 #9 0x08518466 in Error::assertionFailed (fileName=0x88a32bb "Section.cpp", line=198) at Error.cpp:76 #10 0x085627aa in Section::getSectionPage (dbb=0xb711b7f0, root=11, sequence=0, requestedLockType=Exclusive, transId=1902) at Section.cpp:198 #11 0x08563758 in Section::getSectionPage (this=0xb71247f0, sequence=0, lockType=Exclusive, transId=1902) at Section.cpp:1416 #12 0x08564457 in Section::insertStub (this=0xb71247f0, transId=1902) at Section.cpp:348 #13 0x0850df9a in Dbb::insertStub (this=0xb711b7f0, section=0xb71247f0, transaction=0xb725faf0) at Dbb.cpp:304 #14 0x084d23a8 in Table::insert (this=0xb744b3e0, transaction=0xb725faf0, stream=0xb74571e8) at Table.cpp:2987 #15 0x084bb245 in StorageDatabase::insert (this=0xb70e5128, connection=0xb71285e0, table=0xb744b3e0, stream=0xb74571e8) at StorageDatabase.cpp:226 #16 0x084c1036 in StorageTable::insert (this=0xb7451cc8) at StorageTable.cpp:122 #17 0x084b4de3 in StorageInterface::write_row (this=0x9880518, buff=0x98806d8 "Щ\001") at ha_falcon.cpp:1057 #18 0x083cf8e6 in handler::ha_write_row (this=0x9880518, buf=0x98806d8 "Щ\001") at handler.cc:5308 #19 0x08345adc in write_record (thd=0x9889b28, table=0x988fb80, info=0xa9d3e3c0) at sql_insert.cc:1566 #20 0x0834a9e4 in mysql_insert (thd=0x9889b28, table_list=0x989d0d0, fields=@0x988b160, values_list=@0x988b184, update_fields=@0x988b178, update_values=@0x988b16c, duplic=DUP_ERROR, ignore=true) at sql_insert.cc:819 #21 0x082b6e73 in mysql_execute_command (thd=0x9889b28) at sql_parse.cc:2864 #22 0x082bd358 in mysql_parse (thd=0x9889b28, inBuf=0x989d010 "INSERT IGNORE INTO t1 (f1) VALUES (1)", length=37, found_semicolon=0xa9d3f270) at sql_parse.cc:5623 #23 0x082bdd71 in dispatch_command (command=COM_QUERY, thd=0x9889b28, packet=0x9894fb1 "INSERT IGNORE INTO t1 (f1) VALUES (1);", packet_length=38) at sql_parse.cc:1031 #24 0x082befd0 in do_command (thd=0x9889b28) at sql_parse.cc:723 #25 0x082ac6e9 in handle_one_connection (arg=0x9889b28) at sql_connect.cc:1134 #26 0x00bd750b in start_thread () from /lib/libpthread.so.0 #27 0x00b18b2e in clone () from /lib/libc.so.6 How to repeat: Simplified test case will hopefully follow shortly.