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

Bug #1183625 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Critical
Laurynas Biveinis
5.1
Invalid
Undecided
Laurynas Biveinis
5.5
Invalid
Undecided
Laurynas Biveinis
5.6
Fix Released
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

Tags: qa userstat

Related branches

Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
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;

Revision history for this message
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.

Revision history for this message
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
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.