| Bug #36169 | create innodb compressed table with too large row size crashed | ||
|---|---|---|---|
| Submitted: | 17 Apr 2008 9:22 | Modified: | 12 Mar 22:56 |
| Reporter: | Shane Bester | ||
| Status: | Closed | ||
| Category: | Server: InnoDB | Severity: | S1 (Critical) |
| Version: | innodb_plugin-1.0.0, standard innodb in 5.1 | OS: | Any |
| Assigned to: | Timothy Smith | Target Version: | 5.1+ |
| Triage: | Triaged: D1 (Critical) | ||
[17 Apr 2008 9:22]
Shane Bester
[17 Apr 2008 9:23]
Shane Bester
full stack in file to avoid untidy wrapping.
Attachment: bug36169_stack_trace.txt (text/plain), 2.00 KiB.
[17 Apr 2008 9:47]
Shane Bester
10 tables to import. create table table6 causes a crash..
Attachment: bug36169.sql (application/unknown, text), 35.66 KiB.
[17 Apr 2008 9:50]
Shane Bester
in row_create_index_for_mysql, the error_handling: code in invoked.
then, row_drop_table_for_mysql(index->table_name, trx, FALSE); is called but index struct
members have bogus/uninitialized values:
index 0x0bf26800 {id={...} heap=0xfeeefeee name=0xfeeefeee <Bad Ptr>
...} dict_index_struct *
id {high=4277075694 low=4277075694 } dulint_struct
heap 0xfeeefeee {magic_n=??? file_name=0xfeeefef2 <Bad Ptr> line=???
...} mem_block_info_struct *
name 0xfeeefeee <Bad Ptr> const char *
table_name 0xfeeefeee <Bad Ptr> const char *
table 0xfeeefeee {id={...} heap=??? name=??? ...} dict_table_struct *
space 4277075694 unsigned int
page 4277075694 unsigned int
type 14 unsigned int
trx_id_offset 1006 unsigned int
n_user_defined_cols 955 unsigned int
n_uniq 750 unsigned int
n_def 959 unsigned int
n_fields 1006 unsigned int
n_nullable 750 unsigned int
cached 1 unsigned int
to_be_dropped 1 unsigned int
fields 0xfeeefeee {col=??? name=??? prefix_len=??? ...} dict_field_struct *
indexes {prev=0xfeeefeee next=0xfeeefeee } dict_index_struct::<unnamed-tag>
search_info 0xfeeefeee {root_guess=??? hash_analysis=??? last_hash_succ=???
...} btr_search_struct *
stat_n_diff_key_vals 0xfeeefeee __int64 *
stat_index_size 4277075694 unsigned long
stat_n_leaf_pages 4277075694 unsigned long
lock {event=0xfeeefeee wait_ex_event=0xfeeefeee reader_count=4277075694
...} rw_lock_struct
[17 Apr 2008 12:01]
Shane Bester
setting as verified. I've reported this bug in the innodb forums also. http://forums.innodb.com/read.php?3,30,30#msg-30
[18 Apr 2008 9:07]
Shane Bester
I forgot to mention you should first run these to setup the file format: SET GLOBAL innodb_file_format=“Barracuda”; SET GLOBAL innodb_file_per_table=ON;
[21 Apr 2008 15:56]
Heikki Tuuri
Vasil, can you look at this. Probably easy to fix. --Heikki
[24 Apr 2008 14:44]
Vasil Dimov
It turns out that standard InnoDB in MySQL 5.1 is also subject to this bug. Fixed there too.
[14 May 2008 17:21]
Bugs System
Pushed into 5.1.25-rc
[15 May 2008 19:21]
Paul DuBois
Noted in 5.1.25 changelog. A potential rare crash in CREATE INDEX for InnoDB tables was fixed. Setting report to Need Doc Info pending push of fix into 6.0.x.
[19 May 2008 22:18]
Paul DuBois
Setting report to Patch queued pending re-push of this patch.
[22 May 2008 11:51]
Bugs System
Pushed into 6.0.6-alpha
[27 May 2008 20:33]
Paul DuBois
The push into 5.1 was reverted, so there is no 5.1.x changelog entry.
[27 May 2008 20:39]
Paul DuBois
The push into 6.0.x was a null merge that changed nothing. Resetting report to Patch Approved pending further push of patch into 6.0.x. The "parent" report for this set of bugs is Bug#32440.
[24 Jun 2008 23:53]
Calvin Sun
Merged into 6.0.6-alpha, according to Tim. But the patch has not been pushed into 5.1 yet.
[25 Jun 2008 3:48]
Paul DuBois
Noted in 6.0.6 changelog. Setting report to Need Doc Info pending push into 5.1.x.
[5 Oct 2008 18:49]
Jon Stephens
This fix appears to be present in 5.1.28, but we need confirmation of the correct 3-part version for the changelog so we can document and close. Thanks!
[11 Mar 22:35]
Timothy Smith
This was fixed in 5.1.31 (and 6.0.6), not 5.1.28 or 5.1.25.
[12 Mar 22:56]
Paul DuBois
Noted in 5.1.31 changelog.
