Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4(EOL), 10.5
-
None
Description
--source include/galera_cluster.inc
|
--source include/have_log_bin.inc
|
|
CREATE TABLE t1 (a INT) ENGINE=MyISAM; |
LOCK TABLE t1 WRITE CONCURRENT; |
|
--connect (con1,localhost,root,,test)
|
SET lock_wait_timeout= 1; |
--error ER_LOCK_WAIT_TIMEOUT
|
CREATE VIEW v1 AS SELECT * FROM t1; |
10.4 edc3899d |
mysqld: /data/src/10.4/wsrep-lib/include/wsrep/client_state.hpp:289: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed.
|
200412 18:39:34 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f26d25fe102 in __GI___assert_fail (assertion=0x55b51a7d2280 "state_ == s_exec", file=0x55b51a7d2220 "/data/src/10.4/wsrep-lib/include/wsrep/client_state.hpp", line=289, function=0x55b51a7d6900 <wsrep::client_state::start_transaction(wsrep::transaction_id const&)::__PRETTY_FUNCTION__> "int wsrep::client_state::start_transaction(const wsrep::transaction_id&)") at assert.c:101
|
#8 0x000055b51894e281 in wsrep::client_state::start_transaction (this=0x62b000125408, id=...) at /data/src/10.4/wsrep-lib/include/wsrep/client_state.hpp:289
|
#9 0x000055b518fe0b85 in wsrep_start_transaction (thd=0x62b00011f270, trx_id=45) at /data/src/10.4/sql/wsrep_trans_observer.h:137
|
#10 0x000055b518fe52f4 in wsrep_bf_abort (bf_thd=0x62b00012d270, victim_thd=0x62b00011f270) at /data/src/10.4/sql/wsrep_thd.cc:353
|
#11 0x000055b519001142 in wsrep_thd_bf_abort (bf_thd=0x62b00012d270, victim_thd=0x62b00011f270, signal=0 '\000') at /data/src/10.4/sql/service_wsrep.cc:203
|
#12 0x000055b51a50de82 in wsrep_break_lock (data=0x61a0000d12c8, lock_queue1=0x61d00034b770, wait_queue=0x61d00034b740) at /data/src/10.4/mysys/thr_lock.c:708
|
#13 0x000055b51a50eb17 in thr_lock (data=0x61a0000d12c8, owner=0x62b00012edf8, lock_wait_timeout=1) at /data/src/10.4/mysys/thr_lock.c:849
|
#14 0x000055b51a511097 in thr_multi_lock (data=0x62b000136200, count=1, owner=0x62b00012edf8, lock_wait_timeout=1) at /data/src/10.4/mysys/thr_lock.c:1295
|
#15 0x000055b5194c1584 in mysql_lock_tables (thd=0x62b00012d270, sql_lock=0x62b0001361d8, flags=0) at /data/src/10.4/sql/lock.cc:348
|
#16 0x000055b5194c1125 in mysql_lock_tables (thd=0x62b00012d270, tables=0x62b0001361c0, count=1, flags=0) at /data/src/10.4/sql/lock.cc:300
|
#17 0x000055b5188668af in lock_tables (thd=0x62b00012d270, tables=0x62b0001343e0, count=2, flags=0) at /data/src/10.4/sql/sql_base.cc:5480
|
#18 0x000055b518864d0a in open_and_lock_tables (thd=0x62b00012d270, options=..., tables=0x62b0001343e0, derived=true, flags=0, prelocking_strategy=0x7f26b6bcbef0) at /data/src/10.4/sql/sql_base.cc:5226
|
#19 0x000055b5187c4981 in open_and_lock_tables (thd=0x62b00012d270, tables=0x62b0001343e0, derived=true, flags=0) at /data/src/10.4/sql/sql_base.h:503
|
#20 0x000055b518ca94d9 in mysql_create_view (thd=0x62b00012d270, views=0x62b0001343e0, mode=VIEW_CREATE_NEW) at /data/src/10.4/sql/sql_view.cc:450
|
#21 0x000055b5189ef0c8 in mysql_execute_command (thd=0x62b00012d270) at /data/src/10.4/sql/sql_parse.cc:5922
|
#22 0x000055b5189fc46a in mysql_parse (thd=0x62b00012d270, rawbuf=0x62b000134290 "CREATE VIEW v1 AS SELECT * FROM t1", length=34, parser_state=0x7f26b6bd15d0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
|
#23 0x000055b5189faeba in wsrep_mysql_parse (thd=0x62b00012d270, rawbuf=0x62b000134290 "CREATE VIEW v1 AS SELECT * FROM t1", length=34, parser_state=0x7f26b6bd15d0, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7704
|
#24 0x000055b5189d10b0 in dispatch_command (command=COM_QUERY, thd=0x62b00012d270, packet=0x629000320271 "CREATE VIEW v1 AS SELECT * FROM t1", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1827
|
#25 0x000055b5189cda88 in do_command (thd=0x62b00012d270) at /data/src/10.4/sql/sql_parse.cc:1359
|
#26 0x000055b518da5dc4 in do_handle_one_connection (connect=0x611000076670) at /data/src/10.4/sql/sql_connect.cc:1412
|
#27 0x000055b518da5666 in handle_one_connection (arg=0x611000076670) at /data/src/10.4/sql/sql_connect.cc:1316
|
#28 0x000055b51a3e3531 in pfs_spawn_thread (arg=0x61600008f4f0) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#29 0x00007f26d2e78fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
|
#30 0x00007f26d26c74cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Reproducible on 10.4, 10.5.
Not reproducible on 10.3.
No obvious problem on a non-debug build.
Attachments
Issue Links
- relates to
-
MDEV-25410 Assertion `state_ == s_exec' failed - mysqld got signal 6
-
- Closed
-
similar experience with galera 10.4 it crashed with the following error message.
mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.18/wsrep-lib/include/wsrep/client_state.hpp:320: int wsrep::client_state::start_transaction(const wsrep::transaction_id&): Assertion `state_ == s_exec' failed.
210318 13:46:38 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 10.4.18-MariaDB-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=7
max_threads=2002
thread_count=12
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4536933 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f43840009a8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f43ac5a0cf0 thread_stack 0x49000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x556ad86a047e]
/usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x556ad812ee8f]
/lib64/libpthread.so.0(+0xf630)[0x7f4401a99630]
/lib64/libc.so.6(gsignal+0x37)[0x7f43ffd693d7]
/lib64/libc.so.6(abort+0x148)[0x7f43ffd6aac8]
/lib64/libc.so.6(+0x2f1a6)[0x7f43ffd621a6]
/lib64/libc.so.6(+0x2f252)[0x7f43ffd62252]
/usr/sbin/mysqld(+0x84110f)[0x556ad80a210f]
/usr/sbin/mysqld(wsrep_thd_bf_abort+0x19)[0x556ad80a80f9]
/usr/sbin/mysqld(+0xa81546)[0x556ad82e2546]
/usr/sbin/mysqld(_Z20ha_abort_transactionP3THDS0_c+0x75)[0x556ad813af85]
/usr/sbin/mysqld(_ZNK8MDL_lock14can_grant_lockE13enum_mdl_typeP11MDL_contextb+0x15a)[0x556ad80113ca]
/usr/sbin/mysqld(_ZN11MDL_context21try_acquire_lock_implEP11MDL_requestPP10MDL_ticket+0xf1)[0x556ad8011a71]
/usr/sbin/mysqld(_ZN11MDL_context12acquire_lockEP11MDL_requestd+0x35)[0x556ad8011b85]
/usr/sbin/mysqld(+0x65569f)[0x556ad7eb669f]
/usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x560)[0x556ad7eba6a0]
/usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xcc7)[0x556ad7ebdd07]
/usr/sbin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x34)[0x556ad7ebe414]
/usr/sbin/mysqld(_ZN14Rows_log_event14do_apply_eventEP14rpl_group_info+0x77e)[0x556ad822d1ae]
/usr/sbin/mysqld(_Z18wsrep_apply_eventsP3THDP14Relay_log_infoPKvm+0x23d)[0x556ad80a101d]
/usr/sbin/mysqld(_ZN21Wsrep_applier_service15apply_write_setERKN5wsrep7ws_metaERKNS0_12const_bufferERNS0_14mutable_bufferE+0x9d)[0x556ad808abed]
/usr/sbin/mysqld(+0xeccd7f)[0x556ad872dd7f]
/usr/sbin/mysqld(_ZN5wsrep12server_state8on_applyERNS_21high_priority_serviceERKNS_9ws_handleERKNS_7ws_metaERKNS_12const_bufferE+0xf5)[0x556ad872e8b5]
/usr/sbin/mysqld(+0xede2a8)[0x556ad873f2a8]
/usr/lib64/galera-4/libgalera_smm.so(+0x2d4c0)[0x7f43ad77f4c0]
/usr/lib64/galera-4/libgalera_smm.so(+0x39080)[0x7f43ad78b080]
/usr/lib64/galera-4/libgalera_smm.so(+0x3f929)[0x7f43ad791929]
/usr/lib64/galera-4/libgalera_smm.so(+0x6a099)[0x7f43ad7bc099]
/usr/lib64/galera-4/libgalera_smm.so(+0x6ae57)[0x7f43ad7bce57]
/usr/lib64/galera-4/libgalera_smm.so(+0x6b384)[0x7f43ad7bd384]
/usr/lib64/galera-4/libgalera_smm.so(+0x3fe7b)[0x7f43ad791e7b]
/usr/lib64/galera-4/libgalera_smm.so(+0x1e2b8)[0x7f43ad7702b8]
/usr/sbin/mysqld(_ZN5wsrep18wsrep_provider_v2611run_applierEPNS_21high_priority_serviceE+0xe)[0x556ad873f9de]
/usr/sbin/mysqld(+0x841b52)[0x556ad80a2b52]
/usr/sbin/mysqld(_Z15start_wsrep_THDPv+0x377)[0x556ad8095247]
/usr/sbin/mysqld(+0xdf121d)[0x556ad865221d]
/lib64/libpthread.so.0(+0x7ea5)[0x7f4401a91ea5]
/lib64/libc.so.6(clone+0x6d)[0x7f43ffe319fd]