Percona Server with XtraDB

handle_fatal_signal (sig=11) in handler::update_global_table_stats @ sql/handler.cc:4679 | Userstat related

Reported by Roel Van de Paar on 2013-05-24
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Undecided
Laurynas Biveinis
5.5
Undecided
Laurynas Biveinis
5.6
Critical
Laurynas Biveinis

Bug Description

Thread 1 (LWP 14836):
+bt
#0 0x0000003fde20c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000065f93e in handle_fatal_signal (sig=11) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x00000000005ad8c4 in handler::update_global_table_stats (this=0x7f1d9801e510) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/handler.cc:4679
#4 0x000000000068d690 in close_temporary (table=0x7f1d9808aa30, free_share=true, delete_table=false) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_base.cc:2155
#5 0x000000000069277d in close_temporary_table (thd=0x3a46bf0, table=0x7f1d9808aa30, free_share=true, delete_table=false) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_base.cc:2132
#6 0x000000000072d6ad in mysql_alter_table (thd=<optimized out>, new_db=0x7f1df4735600 "\240\206\061\001", new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f1d98004d80, alter_info=<optimized out>, order_num=0, order=0x0, ignore=false) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_table.cc:8376
#7 0x00000000008155b7 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x3a46bf0) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_alter.cc:317
#8 0x00000000006db280 in mysql_execute_command (thd=0x3a46bf0) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_parse.cc:5124
#9 0x00000000006de648 in mysql_parse (thd=0x3a46bf0, rawbuf=<optimized out>, length=61116272, parser_state=<optimized out>) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_parse.cc:6443
#10 0x00000000006df4c5 in dispatch_command (command=COM_QUERY, thd=0x3a46bf0, packet=0x3a4ab31 "ALTER TABLE `table500_innodb_compressed` MODIFY `c36` DATETIME ", packet_length=65) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_parse.cc:1359
#11 0x00000000006ad0bf in do_handle_one_connection (thd_arg=<optimized out>) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_connect.cc:1617
#12 0x00000000006ad217 in handle_one_connection (arg=0x3a46bf0) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/sql/sql_connect.cc:1528
#13 0x0000000000af3aa9 in pfs_spawn_thread (arg=0x3a2e990) at /ssd/5.6-merge-3_opt/Percona-Server-5.6.10-alpha60.2/storage/perfschema/pfs.cc:1853
#14 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0
#15 0x0000003fddee890d in clone () from /lib64/libc.so.6

Query (7f1d98004bd0): ALTER TABLE `table500_innodb_compressed` MODIFY `c36` DATETIME

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 int unsigned,c2 text,c3 blob,c4 date,c5 date,c6 char(1),c7 text,pk int,c9 CHAR(1),c10 text,c11 date,c12 char(1),
c13 int unsigned,c14 char(1),c47 text,c16 char(1),c17 int,key(c17)) ENGINE=innodb ROW_FORMAT=dynamic;
ALTER TABLE t1 MODIFY c1 FLOAT;

Roel Van de Paar (roel11) wrote :

--userstat option is required, and you may have to run the testcase 3-4 times to get the crash.

Roel Van de Paar (roel11) wrote :

Not really qa blocking, but is seen in many trials (seems like most if not all userstat trials). No crashes seen without --userstat.

summary: handle_fatal_signal (sig=11) in handler::update_global_table_stats @
- sql/handler.cc:4679
+ sql/handler.cc:4679 | Userstat related
tags: added: userstat

A 5.6 porting regression. Dropped the rows_read and rows_changed initialization from the handler constructor initializer list.

Will add a testcase to lower versions as well, to help with bug 1179534.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers