table import does not restart after mysql crash during import
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
My table import has just crashed:
https:/
Now I'm looking for a way to resume the import, but can't find it. I can read a part of the table that was being imported, but I get the following errors:
120516 4:55:36 InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 192:6615722, should be 34:6615722!
120516 4:55:36 InnoDB: Error: page 6615722 log sequence number 2516079028454
InnoDB: is in the future! Current system log sequence number 5488820.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://
InnoDB: for more information.
And it would crash if I dive too deep:
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://
InnoDB: for more information.
120516 4:53:21 InnoDB: Assertion failure in thread 140219101259520 in file btr0sea.c line 1549
InnoDB: Failing assertion: index->id == btr_page_
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f874db89e58 thread_stack 0x40000
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
Changed in percona-server: | |
importance: | Undecided → Medium |
Full backtrace of a crash when running SELECT MIN(id), MAX(id) FROM non-fully- imported- table;
#0 0x00007ffff6d9b885 in raise () from /lib64/libc.so.6 build_page_ hash_index (index= 0x7fe59c01f9e8, block=0x7fe65c7 71b00, n_fields=1, n_bytes=0, left_side=1) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0sea. c:1549 info_update_ slow (info=<value optimized out>, cursor=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0sea. c:695 info_update (index= 0x7fe59c01f9e8, level=0, tuple=0x7fe59c0 1c4e8, mode=3, latch_mode=35, cursor= 0x7fe59c017188, has_search_latch=0, jenkins/ workspace/ percona- server- 5.5-rpms/ label_exp/ centos6- 64/target/ BUILD/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ include/ btr0sea. ic:83 search_ to_nth_ level (index= 0x7fe59c01f9e8, level=0, tuple=0x7fe59c0 1c4e8, mode=3, latch_mode=35, cursor= 0x7fe59c017188, has_search_latch=0, jenkins/ workspace/ percona- server- 5.5-rpms/ label_exp/ centos6- 64/target/ BUILD/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c", line=490, mtr=0x7ffff7e4ba50) at /usr/src/ debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0cur. c:836 open_with_ no_init_ func (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ include/ btr0pcur. ic:482 restore_ position_ func (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:343 move_backward_ from_page (cursor= 0x7fe59c017188, mtr=0x7ffff7e4ba50) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:490 move_to_ prev (cursor= 0x7fe59c017188, mtr=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ btr/btr0pcur. c:546 for_mysql (buf=0x7fe59c010f50 "", mode=3, prebuilt=<value optimized out>, match_mode=0, direction=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ row/row0sel. c:4707 :index_ read (this=0x7fe59c0 0f320, buf=0x7fe59c010f50 "", key_ptr=0x0, key_len=0, find_flag=<value optimized out>) debug/Percona- Server- 5.5.21- rel25.1/ Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ handler/ ha_innodb. cc:6518 :index_ last (this=0x7fe59c0 0f320, buf=0x7fe59c010f50 "")
#1 0x00007ffff6d9d065 in abort () from /lib64/libc.so.6
#2 0x000000000087671e in btr_search_
at /usr/src/
#3 0x0000000000876efe in btr_search_
at /usr/src/
#4 0x000000000086c6d3 in btr_search_
file=0xa54fb0 "/home/
#5 btr_cur_
file=0xa54fb0 "/home/
#6 0x000000000086fd8d in btr_pcur_
at /usr/src/
#7 btr_pcur_
at /usr/src/
#8 btr_pcur_
at /usr/src/
#9 0x00000000008702ac in btr_pcur_
at /usr/src/
#10 0x000000000082124f in row_search_
at /usr/src/
#11 0x00000000007f5458 in ha_innobase:
at /usr/src/
#12 0x00000000007f28c9 in ha_innobase:
at /usr/s...