Description:
innodb_gis.rtree_split: crashes with InnoDB: Assertion failure in thread 19 in file ut0ut.cc line 916
innodb_gis.rtree_split : Testcase fails sporadically on Daily-trunk since 2015-01-23, you can find from the below mentioned
details. The failure log is so big and it could not pasted in the bug description details.below attached the core file and the log
file related to the failure.
The same kind of failure also seen in the Bug #20818481, but it looks the Assertion line is different .
How to repeat:
mysql-test-run.pl --force --timer --big-test --testcase-timeout=90 --parallel=auto --experimental=collections/default.experimental --comment=normal-big --vardir=/tmp/mtr-6615/var-normal-big --report-features --skip-test-list=collections/disabled-daily.list --unit-tests --parallel=8
Failure-history:
-----------------
http://pb2.no.oracle.com/?template=mysql_show_test_failure&test_failure_id=&test_output_id...
Here is the failure log:
innodb_fts.fulltext w6 [ pass ] 3524
innodb_gis.rtree_split w1 [ fail ]
Test ended at 2015-04-09 20:41:21
CURRENT_TEST: innodb_gis.rtree_split
mysqltest: At line 52: query 'insert into t1 select * from t1' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
insert into t1 select * from t1;
delete from t1;
137a6b1; asc m 7 E > m '0 ) infimum supremum , ? ? ? ? E -4 ? ? ? ? E ? ? ? ? E $ ( , ? ? ? ? E- 0, ? ? ? ? E6 8 ? ? ? ? E? $ @ X ? ? ? ? EZ & H* ? ? ? ? Ec P , ? ? ? ? El X,X ? ? ? ? Eu `( ? ? ? ? E~ $ h ? ? ? ? E p X ? ? ? ? E x ` ? ? ? ? E + ? ? ? ? E % $D ? ? ? ? E * ? ? ? ? E ' p ? ?
InnoDB: End of page dump
2015-04-09T18:41:04.156380Z 0 [Note] InnoDB: Uncompressed page, stored checksum in field1 4253211757, calculated checksums for field1: crc32 1792941501, innodb 3807389222, none 3735928559, stored checksum in field2 4253211757, calculated checksums for field2: crc32 1792941501, innodb 2157562449, none 3735928559, page LSN 0 20424369, low 4 bytes of LSN at page end 20424369, page number (if stored to page already) 8, space id (if created with >= MySQL-4.1.1 and stored already) 1037
InnoDB: Page may be an index page where index id is 1183
InnoDB: Dump of the parent page:
2015-04-09T18:41:04.156441Z 0 [Note] InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 7132c2fb00000004ffffffffffffffff000000000137a6b145be000
InnoDB: End of page dump
2015-04-09T18:41:04.315296Z 0 [Note] InnoDB: Uncompressed page, stored checksum in field1 1899152123, calculated checksums for field1: crc32 1899152123, innodb 1025349580, none 3735928559, stored checksum in field2 1899152123, calculated checksums for field2: crc32 1899152123, innodb 1703183624, none 3735928559, page LSN 0 20424369, low 4 bytes of LSN at page end 20424369, page number (if stored to page already) 4, space id (if created with >= MySQL-4.1.1 and stored already) 1037
InnoDB: Page may be an update undo log page
InnoDB: Page may be an index page where index id is 1183
2015-04-09T18:41:04.315402Z 0 [ERROR] InnoDB: Corruption of index `c2` of table `test`.`t1` parent page 8 child page 9
PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 30; hex 000000000000f03f000000000000f03f000000000000f03f000000000000; asc ? ? ? ; (total 32 bytes);
1: len 6; hex 000000004509; asc E ;;
2015-04-09T18:41:04.315730Z 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 170
PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 30; hex 000000000000f03f0000000000002240000000000000f03f000000000000; asc ? "@ ? ; (total 32 bytes);
1: len 4; hex 00000009; asc ;;
2015-04-09T18:41:04.316035Z 0 [Note] InnoDB: n_owned: 0; heap_no: 5; next rec: 112
2015-04-09T18:41:04.316062Z 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup, see http://dev.mysql.com/doc/refman/5.8/en/forcing-innodb-recovery.html about forcing recovery. Then dump + drop + reimport.
2015-04-09 21:41:04 0x13 InnoDB: Assertion failure in thread 19 in file ut0ut.cc line 916
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
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://dev.mysql.com/doc/refman/5.8/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
18:41:04 UTC - mysqld got signal 6 ;
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...
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'my_print_stacktrace+0x24 [0x100a557b8]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'handle_fatal_signal+0x478 [0x100404054]
/lib/sparcv9/libc.so.1'__sighndlr+0xc [0xffffffff7ece285c]
/lib/sparcv9/libc.so.1'call_user_handler+0x364 [0xffffffff7ecd5e90]
/lib/sparcv9/libc.so.1'sigacthandler+0x5c [0xffffffff7ecd60c0]
/lib/sparcv9/libc.so.1'_lwp_kill+0x8 [0xffffffff7ece76a0] [Signal 6 (ABRT)]
/lib/sparcv9/libc.so.1'abort+0xc4 [0xffffffff7ec6a13c]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z23ut_dbg_assertion_failedPKcS0_m+0xa8 [0x100f8d234]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_ZN2ib5fatalD1Ev+0xec [0x100ca4dbc]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z33rtr_page_get_father_node_ptr_funcPmP16mem_block_info_tP9btr_cur_tS3_PKcmP5mtr_t+0x66c [0x100db5828]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z12btr_compressP9btr_cur_tmP5mtr_t+0x244 [0x100cb837c]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z26btr_cur_compress_if_usefulP9btr_cur_tmP5mtr_t+0xe8 [0x100cc1ae8]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z26btr_cur_pessimistic_deleteP7dberr_tmP9btr_cur_tmbP5mtr_t+0x4a4 [0x100cc6c60]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_ZL33row_purge_remove_sec_if_poss_treeP12purge_node_tP12dict_index_tPK8dtuple_t+0x834 [0x100c1c370]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z14row_purge_stepP9que_thr_t+0x3f8 [0x100c1e0a4]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'_Z15que_run_threadsP9que_thr_t+0xa98 [0x100bd5000]
/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-solaris11-sparc-64bit-gcc/bin/mysqld'srv_worker_thread+0x5c4 [0x100c4df20]
/lib/sparcv9/libc.so.1'_lwp_start+0x0 [0xffffffff7ece2764]
Please read http://dev.mysql.com/doc/refman/5.8/en/resolve-stack-dump.html
and follow instructions on how to resolve the stack trace.
Resolved stack trace is much more helpful in diagnosing the
problem, so please do resolve it
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file
----------SERVER LOG END-------------
Core file :
Core was generated by `/export/home/pb2/test/sb_2-14953674-1428600261.73/mysql-advanced-5.8.0-m17-sola'.
Program terminated with signal 9, Killed.
#0 0xffffffff7ece72dc in __pollsys () from /lib/64/libc.so.1
#0 0xffffffff7ece72dc in __pollsys () from /lib/64/libc.so.1
#1 0xffffffff7ecd4434 in _pollsys () from /lib/64/libc.so.1
#2 0xffffffff7ec91784 in poll () from /lib/64/libc.so.1
#3 0x0000000100905ebc in Mysqld_socket_listener::listen_for_connection_event (this=0x1024e6200) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/sql/conn_handler/socket_connection.cc:850
#4 0x00000001003ff470 in connection_event_loop (argc=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_acceptor.h:67
#5 mysqld_main (argc=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/sql/mysqld.cc:5042
#6 0x00000001003f3e04 in _start ()
Thread 48 (Thread 26 ):
#0 0xffffffff7ece27e4 in __lwp_park () from /lib/64/libc.so.1
#1 0xffffffff7ecdbfb8 in cond_sleep_queue () from /lib/64/libc.so.1
#2 0xffffffff7ecdc234 in cond_wait_queue () from /lib/64/libc.so.1
#3 0xffffffff7ecdc828 in cond_wait () from /lib/64/libc.so.1
#4 0xffffffff7ecdc864 in pthread_cond_wait () from /lib/64/libc.so.1
#5 0x0000000100bb2d18 in wait (this=0x11754f3c8, reset_sig_count=<value optimized out>) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/os/os0event.cc:160
#6 os_event::wait_low (this=0x11754f3c8, reset_sig_count=<value optimized out>) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/os/os0event.cc:331
#7 0x0000000100c5d448 in sync_array_wait_event (arr=0x101c13a20, cell=@0xffffffff7933d438) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0arr.cc:440
#8 0x0000000100c600a4 in rw_lock_s_lock_spin (lock=0x11739dca8, pass=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/sync/sync0rw.cc:432
#9 0x0000000100bf9850 in mtr_t::s_lock(rw_lock_t*, char const*, unsigned long) ()
#10 0x0000000100cc4fe0 in btr_cur_search_to_nth_level (index=0x11739db60, level=0, tuple=0x11739c7e0, mode=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/btr/btr0cur.cc:997
#11 0x0000000100bf381c in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x11739db60, offsets_heap=0x1176f4690, heap=0x1176f56a0, entry=0x11739c7e0, trx_id=0, thr=0x117834770, dup_chk_only=false) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:2811
#12 0x0000000100bf8a74 in row_ins_sec_index_entry (index=0x11739db60, entry=0x11739c7e0, thr=0x117834770, dup_chk_only=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3253
#13 0x0000000100bf904c in row_ins_index_entry (thr=0x117834770) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3299
#14 row_ins_index_entry_step (thr=0x117834770) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3426
#15 row_ins (thr=0x117834770) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3568
#16 row_ins_step (thr=0x117834770) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0ins.cc:3753
#17 0x0000000100c09280 in row_insert_for_mysql_using_ins_graph (mysql_rec=Unhandled dwarf expression opcode 0xf3
) at /export/home2/pb2/build/sb_0-14952122-1428594960.01/mysqlcom-pro-5.8.0-m17/storage/innobase/row/row0mysql.cc:1681
#18 0x0000000100b39a28 in ha_innobase::write_row (this=0x11739bac0, record=0x11739bda0 "\376\a") at /export/home2/pb2/build0
Suggested fix:
no crash