Bug #37544 | crash with create table with large size index/rows | ||
---|---|---|---|
Submitted: | 20 Jun 2008 11:50 | Modified: | 12 Jul 2008 11:16 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Falcon storage engine | Severity: | S1 (Critical) |
Version: | 6.0.5 | OS: | Any |
Assigned to: | Hakan Küçükyılmaz | CPU Architecture: | Any |
[20 Jun 2008 11:50]
Shane Bester
[20 Jun 2008 11:55]
Hakan Küçükyılmaz
Shane, please try to get a reproducible case. Best regards, Hakan
[20 Jun 2008 12:19]
MySQL Verification Team
more info for the crash. still not repeated...
Attachment: bug37544_full_stack_trace.txt (text/plain), 4.55 KiB.
[20 Jun 2008 12:27]
Philip Stoev
Shane, My very wild guess would be that something from the previous queries you executed left Falcon data structures in a state that causes this bug to appear. It is not easily reproducible because Falcon does stuff in the background independent from the foreground queries. You may wish to try setting falcon_gopher_threads to zero or to one and also try to disable the various falcon_x_schedule options by setting them to an impossible crontab frequency, e.g. "1 1 1 1 1".
[20 Jun 2008 14:50]
Ann Harrison
The assert in question is that the page fetched is a section page. /* This is an intermediate page. Find child page to recurse. */ ASSERT (locatorPage->pageType == PAGE_sections); Assertions on page type tend to fail after a recovery problem. Was there a crash and recovery before the error?
[21 Jun 2008 7:39]
MySQL Verification Team
Ann, no crash before this one. Only thing i remember was I ran DROP DATABASE with a bunch of tables, few minutes before the crash. Now I re-run the test with parameters Philip recommended, no crash happens. I think rapid create/populate/drop tables will reproduce this. I'll try it and upload more info.
[9 Jul 2008 15:15]
Hakan Küçükyılmaz
Shane, any luck with reproducing this crash? Best regard, Hakan
[12 Jul 2008 11:16]
MySQL Verification Team
i've never been able to repeat this again.