percona server crash on table import
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.1 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
I'm importing gigabytes of InnoDB tables, 4 tables in parallel. Most tables import fine, but mysql crashed on some larger ones.
Percona Server (GPL), Release rel25.1, Revision 234
Here's the error:
InnoDB: Import: The extended import of db/table is being started.
InnoDB: Import: 10 indexes have been detected.
InnoDB: Progress in %: 35 82 36 78 37 38 83 39 40 84 41 42 85 43 44120515 11:11:13 InnoDB: Assertion failure in thread 140111167784704 in file rem0rec.c line 561
you see weird numbers here because multiple table imports are running at the same time. Backtrace:
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 = 7f6e2c627e58 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/
/lib64/
/lib64/
Some background information. Before importing these tables, they were in Percona Server 5.0, xtrabackup was taken, backup was then prepared, then I've started mysql on it, ran mysql_upgrade and the table in question was upgraded, only then it was prepared for import and imported. This is true for all tables.
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 29 lines (+4/-1)1 file modifiedPercona-Server/storage/innodb_plugin/fil/fil0fil.c (+4/-1)
- Laurynas Biveinis (community): Approve
-
Diff: 29 lines (+4/-1)1 file modifiedPercona-Server/storage/innobase/fil/fil0fil.c (+4/-1)
Changed in percona-server: | |
assignee: | nobody → Alexey Kopytov (akopytov) |
tags: | added: i21353 |
Apparently it is crashing with just one table import as well. Here's the backtrace:
Program received signal SIGABRT, Aborted. 12-1.47. el6_2.9. x86_64 libaio- 0.3.107- 10.el6. x86_64 libgcc- 4.4.6-3. el6.x86_ 64 nss-softokn- freebl- 3.12.9- 11.el6. x86_64 offsets_ func (rec=0x7fe5982bb157 "cket.com/ albums/ aa252/phiednate /scan0003. gif", index=0x7fe5980 87138, offsets= 0x7fe5a7f11d40, 22b0, file=<value optimized out>, line=3576) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ storage/ innobase/ rem/rem0rec. c:561 single_ table_tablespac e (check_ space_id= <value optimized out>, id=40, flags=0, name=0x7fe598033b70 "art159/ img_out159" , trx=0x7fe5982b0fd8) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ storage/ innobase/ fil/fil0fil. c:3575 tablespace_ for_mysql (name=0x7fe5980 33b70 "art159/ img_out159" , trx=0x7fe5982b0fd8) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ storage/ innobase/ row/row0mysql. c:2786 :discard_ or_import_ tablespace (this=0x7fe5982 aa0d0, discard=0 '\000') debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ storage/ innobase/ handler/ ha_innodb. cc:8094 or_import_ tablespace (thd=0xab486010, new_db= 0x7fe598004c30 "art159", new_name=0x0, create_ info=0x7fe5a7f1 4610, table_list= 0x7fe598004c80, info=0x7fe5a7f1 46f0, order_num=0, order=0x0, ignore=false) at /usr/src/ debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ sql/sql_ table.cc: 4754 0x7fe598004c30 "art159", new_name=0x0, create_ info=0x7fe5a7f1 4610, table_list= 0x7fe598004c80, alter_info= 0x7fe5a7f146f0, order_num=0, debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ sql/sql_ table.cc: 5945 statement: :execute (this=<value optimized out>, thd=0xab486010) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ sql/sql_ alter.cc: 106 command (thd=0xab486010) at /usr/src/ debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ sql/sql_ parse.cc: 4575 state=0x7fe5a7f 15bb0) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- 5.5.22- rel25.2/ sql/sql_ parse.cc: 5804 0x7fe598004b60 "ALTER TABLE art159.img_out159 IMPORT TABLESPACE", packet_ length= 2817612952) debug/Percona- Server- 5.5.22- rel25.2/ Percona- Server- ...
[Switching to Thread 0x7fe5a7f16700 (LWP 2780)]
0x000000318e232885 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.
(gdb)
(gdb)
(gdb)
(gdb) bt
#0 0x000000318e232885 in raise () from /lib64/libc.so.6
#1 0x000000318e234065 in abort () from /lib64/libc.so.6
#2 0x0000000000915a80 in rec_get_
n_fields=<value optimized out>, heap=0x7fe5a7f1
at /usr/src/
#3 0x00000000008bc20e in fil_open_
at /usr/src/
#4 0x00000000008193b2 in row_import_
at /usr/src/
#5 0x00000000007fa667 in ha_innobase:
at /usr/src/
#6 0x00000000005e7cf5 in mysql_discard_
alter_
#7 mysql_alter_table (thd=0xab486010, new_db=
order=0x0, ignore=false) at /usr/src/
#8 0x000000000078657f in Alter_table_
at /usr/src/
#9 0x0000000000586b00 in mysql_execute_
#10 0x000000000058a323 in mysql_parse (thd=0xab486010, rawbuf=<value optimized out>, length=2873654232, parser_
at /usr/src/
#11 0x000000000058b982 in dispatch_command (command=COM_QUERY, thd=0xab486010, packet=
at /usr/src/