Comment 4 for bug 896439

Revision history for this message
Elena Stepanova (elenst) wrote :

Stack trace from Percona Server 5.5.21:

#4 <signal handler called>
#5 0xb76f121d in pthread_mutex_trylock () from /lib/libpthread.so.0
#6 0x084accba in pfs_mutex_enter_func (thd=0x8a6a978, tables=0x8ae9f68, cond=0x0)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/storage/innobase/include/os0sync.ic:54
#7 i_s_innodb_table_stats_fill (thd=0x8a6a978, tables=0x8ae9f68, cond=0x0)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/storage/innobase/handler/i_s.cc:4038
#8 0x081f277e in get_schema_tables_result (join=0x8aea858,
    executed_place=PROCESSED_BY_JOIN_EXEC)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_show.cc:7420
#9 0x081ecf79 in JOIN::exec (this=0x8aea858)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:1926
#10 0x081ef8ee in mysql_select (thd=0x8a6a978, rref_pointer_array=0x8a6c0a8, tables=0x8ae9f68,
    wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0,
    proc_param=0x0, select_options=2684619520, result=0x8aea848, unit=0x8a6bb74,
    select_lex=0x8a6bfb0)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:2600
#11 0x081f0274 in handle_select (thd=0x8a6a978, lex=0x8a6bb10, result=0x8aea848,
    setup_tables_done_option=0)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_select.cc:312
#12 0x081a4748 in execute_sqlcom_select (thd=0x8a6a978, all_tables=0x8ae9f68)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:4734
#13 0x081a6ebf in mysql_execute_command (thd=0x8a6a978)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:2278
#14 0x081ae0b8 in mysql_parse (thd=0x8a6a978,
    rawbuf=0x8ae9de8 "select * from INNODB_TABLE_STATS", length=32, parser_state=0xb6493ddc)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:5804

#15 0x081af93f in dispatch_command (command=COM_QUERY, thd=0x8a6a978,
    packet=0x8ae1c19 "select * from INNODB_TABLE_STATS", packet_length=32)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:1060
#16 0x081afe36 in do_command (thd=0x8a6a978)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_parse.cc:788
#17 0x082594d5 in do_handle_one_connection (thd_arg=0x8a6a978)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_connect.cc:1433
#18 0x082595bf in handle_one_connection (arg=0x8a6a978)
    at /home/jenkins/workspace/percona-server-5.5-binaries/label_exp/centos5-32/Percona-Server-5.5.21-rel25.1/sql/sql_connect.cc:1340
#19 0xb76eeb25 in start_thread () from /lib/libpthread.so.0

Reproducible on Percona Server 5.1.61, 5.5.21, MariaDB 5.1.62, 5.2.12, 5.3.6, 5.5.23.

To reproduce,
- start server with --skip-innodb (for 5.5 also with --default-storage-engine=myisam),
- run select * from information_schema.INNODB_TABLE_STATS