#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
Stack trace from Percona Server 5.5.21:
#4 <signal handler called> mutex_trylock () from /lib/libpthread .so.0 enter_func (thd=0x8a6a978, tables=0x8ae9f68, cond=0x0) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ include/ os0sync. ic:54 table_stats_ fill (thd=0x8a6a978, tables=0x8ae9f68, cond=0x0) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ storage/ innobase/ handler/ i_s.cc: 4038 tables_ result (join=0x8aea858, place=PROCESSED _BY_JOIN_ EXEC) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ show.cc: 7420 workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:1926 array=0x8a6c0a8 , tables=0x8ae9f68, options= 2684619520, result=0x8aea848, unit=0x8a6bb74, lex=0x8a6bfb0) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:2600 tables_ done_option= 0) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ select. cc:312 sqlcom_ select (thd=0x8a6a978, all_tables= 0x8ae9f68) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 4734 command (thd=0x8a6a978) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 2278 0x8ae9de8 "select * from INNODB_ TABLE_STATS" , length=32, parser_ state=0xb6493dd c) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 5804
#5 0xb76f121d in pthread_
#6 0x084accba in pfs_mutex_
at /home/jenkins/
#7 i_s_innodb_
at /home/jenkins/
#8 0x081f277e in get_schema_
executed_
at /home/jenkins/
#9 0x081ecf79 in JOIN::exec (this=0x8aea858)
at /home/jenkins/
#10 0x081ef8ee in mysql_select (thd=0x8a6a978, rref_pointer_
wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0,
proc_param=0x0, select_
select_
at /home/jenkins/
#11 0x081f0274 in handle_select (thd=0x8a6a978, lex=0x8a6bb10, result=0x8aea848,
setup_
at /home/jenkins/
#12 0x081a4748 in execute_
at /home/jenkins/
#13 0x081a6ebf in mysql_execute_
at /home/jenkins/
#14 0x081ae0b8 in mysql_parse (thd=0x8a6a978,
rawbuf=
at /home/jenkins/
#15 0x081af93f in dispatch_command (command=COM_QUERY, thd=0x8a6a978, 0x8ae1c19 "select * from INNODB_ TABLE_STATS" , packet_length=32) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 1060 workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ parse.cc: 788 one_connection (thd_arg=0x8a6a978) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ connect. cc:1433 one_connection (arg=0x8a6a978) workspace/ percona- server- 5.5-binaries/ label_exp/ centos5- 32/Percona- Server- 5.5.21- rel25.1/ sql/sql_ connect. cc:1340 .so.0
packet=
at /home/jenkins/
#16 0x081afe36 in do_command (thd=0x8a6a978)
at /home/jenkins/
#17 0x082594d5 in do_handle_
at /home/jenkins/
#18 0x082595bf in handle_
at /home/jenkins/
#19 0xb76eeb25 in start_thread () from /lib/libpthread
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, storage- engine= myisam) , schema. INNODB_ TABLE_STATS
- start server with --skip-innodb (for 5.5 also with --default-
- run select * from information_