mysqld got signal 6 ; after stored routine warnings | handle_fatal_signal/abort (sig=6) in allocs from user_var_entry::free_value

[Roel Van de Paar]

[...more warnings in log...]
2014-10-19 07:02:14 19829 [Warning] Stored routine 'test '.'test_func_dt6 ': invalid value in column mysql.proc.db_collation.
20:02:14 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
[...]
Query (0): Connection ID (thread ID): 4
Status: KILL_CONNECTION

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7fb0208a9700 (LWP 20358)):
+bt
#0 0x00007fb026dd4771 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 0x00007fb0259d85c9 in raise () from /lib64/libc.so.6
#5 0x00007fb0259d9cd8 in abort () from /lib64/libc.so.6
#6 0x00007fb025a18dd7 in __libc_message () from /lib64/libc.so.6
#7 0x00007fb025a1f7dc in malloc_consolidate () from /lib64/libc.so.6
#8 0x00007fb025a20097 in _int_free () from /lib64/libc.so.6
#9 0x0000000000ab19f8 in my_free (ptr=0x7fafc02db380) 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:140
#10 0x00000000006c78e1 in user_var_entry::free_value (this=0x7fafc02d4600) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_class.h:5150
#11 0x00000000007a21a2 in user_var_entry::destroy (this=0x7fafc02d4600) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_class.h:5264
#12 0x00000000007933a9 in free_user_var (entry=0x7fafc02d4600) 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:96
#13 0x0000000000a973b5 in my_hash_free_elements (hash=0x2eed1c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/hash.c:134
#14 0x0000000000a97449 in my_hash_free (hash=0x2eed1c0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/hash.c:155
#15 0x0000000000796faa in THD::cleanup (this=0x2eecc20) 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:1713
#16 0x00000000007971bf in THD::release_resources (this=0x2eecc20) 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:1771
#17 0x00000000008c2b5e in threadpool_remove_connection (thd=0x2eecc20) 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:257
#18 0x00000000008c4f44 in connection_abort (connection=0x358a1f0) 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:1363
#19 0x00000000008c55aa in handle_event (connection=0x358a1f0) 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:1564
#20 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
#21 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7faf9808b5b0) 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
#22 0x00007fb026dcfdf3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007fb025a9901d 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-3206