mysqld got signal 6 ; | abort in malloc, coming from Warning_info::push_warning (Sql_alloc::operator new)

[Roel Van de Paar]

2014-10-20 20:06:38 7f87043e5700 InnoDB: Error: Fetch of persistent statistics requested for table "test"."t1" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2014-10-20 20:06:38 7f87043e5700 [Info] InnoDB: the file format in the system tablespace is now set to Barracuda.
09:06:38 UTC - mysqld got signal 6 ;
[...]
Query (7f86ac004e90): REPAIR TABLE t2 USE_FRM
Connection ID (thread ID): 4

Thread 1 (Thread 0x7f87043e5700 (LWP 2098)):
+bt
#0 0x00007f870da69771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f870c66d5c9 in raise () from /lib64/libc.so.6
#5 0x00007f870c66ecd8 in abort () from /lib64/libc.so.6
#6 0x00007f870c6addd7 in __libc_message () from /lib64/libc.so.6
#7 0x00007f870c6b47dc in malloc_consolidate () from /lib64/libc.so.6
#8 0x00007f870c6b6069 in _int_malloc () from /lib64/libc.so.6
#9 0x00007f870c6b812c in malloc () from /lib64/libc.so.6
#10 0x0000000000ab15ae in my_malloc (size=2016, my_flags=1040) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/my_malloc.c:38
#11 0x0000000000aab255 in alloc_root (mem_root=0x2e4d618, length=392) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/my_alloc.c:224
#12 0x000000000062fc13 in Sql_alloc::operator new (size=392, mem_root=0x2e4d618) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_alloc.h:40
#13 0x00000000007aefca in Warning_info::push_warning (this=0x2e4d618, thd=0x2e49be0, sql_errno=1399, sqlstate=0xf595a5 "XAE07", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7f87043e2810 "XAER_RMFAIL: эту команду нельзя выполнять когда глобальная транзакция находится в состоянии 'ACTIVE'") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_error.cc:726
#14 0x00000000007a12df in Diagnostics_area::push_warning (this=0x2e4d3f0, thd=0x2e49be0, sql_errno=1399, sqlstate=0xf595a5 "XAE07", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7f87043e2810 "XAER_RMFAIL: эту команду нельзя выполнять когда глобальная транзакция находится в состоянии 'ACTIVE'") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_error.h:761
#15 0x00000000007963ec in THD::raise_condition (this=0x2e49be0, sql_errno=1399, sqlstate=0xf595a5 "XAE07", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7f87043e2810 "XAER_RMFAIL: эту команду нельзя выполнять когда глобальная транзакция находится в состоянии 'ACTIVE'") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_class.cc:1412
#16 0x00000000006253bc in my_message_sql (error=1399, str=0x7f87043e2810 "XAER_RMFAIL: эту команду нельзя выполнять когда глобальная транзакция находится в состоянии 'ACTIVE'", MyFlags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/mysqld.cc:3396
#17 0x0000000000aae369 in my_error (nr=1399, MyFlags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/my_error.c:185
#18 0x00000000008b6718 in trans_check_state (thd=0x2e49be0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/transaction.cc:47
#19 0x00000000007e29e9 in mysql_execute_command (thd=0x2e49be0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:2837
#20 0x00000000007ed193 in mysql_parse (thd=0x2e49be0, rawbuf=0x7f86ac004e90 "REPAIR TABLE t2 USE_FRM", length=23, parser_state=0x7f87043e3d50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#21 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2e49be0, packet=0x3644831 "REPAIR TABLE t2 USE_FRM;", packet_length=24) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#22 0x00000000007de528 in do_command (thd=0x2e49be0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#23 0x00000000008c2c30 in threadpool_process_request (thd=0x2e49be0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#24 0x00000000008c5572 in handle_event (connection=0x35cbf20) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#25 0x00000000008c57a2 in worker_main (param=0x1897c00 <all_groups>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#26 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7f86a0317980) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#27 0x00007f870da64df3 in start_thread () from /lib64/libpthread.so.0
#28 0x00007f870c72e01d in clone () from /lib64/libc.so.6

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3221