[MDEV-23393] sql_sequence.kill failed in buildbot on embedded, server crash in THD::awake_no_mutex Created: 2020-08-03  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Sequence, Tests
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/23892/steps/mtr_ps_emb/logs/stdio

10.3 6053eb1ce278ac1f566cd74498506bf4

sql_sequence.kill 'innodb'               w2 [ fail ]
        Test ended at 2020-07-30 16:00:16
 
CURRENT_TEST: sql_sequence.kill
Warning: /mnt/buildbot/build/mariadb-10.3.24/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.3.24/mysql-test/std_data/cacert.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.24/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.3.24/mysql-test/std_data/client-cert.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.24/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.3.24/mysql-test/std_data/client-key.pem'
Warning: /mnt/buildbot/build/mariadb-10.3.24/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000
Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000
Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000
Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 71" errno: 2000
Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000
Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000
Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000
Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 71" errno: 2000
Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000
Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000
Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000
Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/transaction_registry.ibd' OS error: 71" errno: 2000
mysqltest got signal 11
read_command_buf (0x82912cd8): --ev
conn->name (0x82bbe8e0): 
conn->cur_query (0x82c0ab48): KILL 7
Attempting backtrace...
stack_bottom = 0x0 thread_stack 0x49000
mysys/stacktrace.c:269(my_print_stacktrace)[0x803d1307]
client/mysqltest.cc:9025(dump_backtrace())[0x803b3472]
client/mysqltest.cc:9042(signal_handler)[0x803b34b0]
addr2line: '': No such file
[0xb76f9c14]
sql/sql_class.cc:1852(THD::awake_no_mutex(killed_state))[0x8067dad0]
sql/sql_parse.cc:8988(kill_one_thread(THD*, long long, killed_state, killed_type))[0x808b835b]
sql/sql_parse.cc:9094(sql_kill(THD*, long long, killed_state, killed_type))[0x808b87c8]
sql/sql_parse.cc:5430(mysql_execute_command(THD*))[0x808b0c48]
sql/sql_prepare.cc:4812(Prepared_statement::execute(String*, bool))[0x80a20447]
sql/sql_prepare.cc:4240(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x80a1efd7]
sql/sql_prepare.cc:3240(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x80a1cae0]
sql/sql_prepare.cc:3138(mysqld_stmt_execute(THD*, char*, unsigned int))[0x80a1c689]
sql/sql_parse.cc:1790(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x808a81e5]
libmysqld/lib_sql.cc:171(emb_advanced_command)[0x80402df9]
libmysqld/lib_sql.cc:352(emb_stmt_execute)[0x8040353e]
libmysqld/libmysql.c:2583(mysql_stmt_execute)[0x803e77ad]
client/mysqltest.cc:944(connection_thread)[0x803a1f01]
/lib/i386-linux-gnu/libpthread.so.0(+0x62b5)[0xb76d02b5]
/lib/i386-linux-gnu/libc.so.6(clone+0x6e)[0xb712116e]
Writing a core file...



 Comments   
Comment by Alice Sherepa [ 2020-12-02 ]

on 10.6 https://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/25894/steps/mtr_ps_emb/logs/stdio

sql_sequence.kill 'innodb'               w4 [ fail ]
        Test ended at 2020-12-01 14:32:29
 
CURRENT_TEST: sql_sequence.kill
Warning: /mnt/buildbot/build/mariadb-10.6.0/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.6.0/mysql-test/std_data/cacert.pem'
Warning: /mnt/buildbot/build/mariadb-10.6.0/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.6.0/mysql-test/std_data/client-cert.pem'
Warning: /mnt/buildbot/build/mariadb-10.6.0/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.6.0/mysql-test/std_data/client-key.pem'
Warning: /mnt/buildbot/build/mariadb-10.6.0/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
mysqltest got signal 11
read_command_buf (0x82ebb6a0): --ev
 
conn->name (0x830ef8f8): 
 
conn->cur_query (0x8316bdd0): KILL 2
 
Attempting backtrace...
stack_bottom = 0x0 thread_stack 0x49000
mysys/stacktrace.c:212(my_print_stacktrace)[0x805138c1]
client/mysqltest.cc:9021(dump_backtrace())[0x804ba0c6]
client/mysqltest.cc:9038(signal_handler)[0x804ba104]
addr2line: '': No such file
[0xb76fbc14]
sql/sql_class.cc:1939(THD::awake_no_mutex(killed_state))[0x8086a558]
sql/sql_parse.cc:9112(kill_one_thread(THD*, long long, killed_state, killed_type))[0x807fff61]
sql/sql_parse.cc:9236(sql_kill(THD*, long long, killed_state, killed_type))[0x8080038c]
sql/sql_parse.cc:5403(mysql_execute_command(THD*))[0x807f8584]
sql/sql_prepare.cc:5012(Prepared_statement::execute(String*, bool))[0x807c1c55]
sql/sql_prepare.cc:4474(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x807c079c]
sql/sql_prepare.cc:3455(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x807be1fa]
sql/sql_prepare.cc:3234(mysqld_stmt_execute(THD*, char*, unsigned int))[0x807bdb30]
sql/sql_parse.cc:1741(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x807ef767]
libmysqld/lib_sql.cc:171(emb_advanced_command)[0x804dec4a]
libmysqld/lib_sql.cc:352(emb_stmt_execute)[0x804df399]
libmysqld/libmysql.c:2610(mysql_stmt_execute)[0x804d17a4]
client/mysqltest.cc:928(connection_thread)[0x804a8876]
??:0(start_thread)[0xb76d22b5]
??:0(clone)[0xb70a116e]
Writing a core file...

Generated at Thu Feb 08 09:22:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.