Details
Description
2019-03-10 9:54:29 140525759887104 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 4)
|
mysqld: /home/jan/mysql/10.2-galera/storage/innobase/include/sync0policy.ic:64: void MutexDebug<Mutex>::enter(const Mutex*, const char*, unsigned int) [with Mutex = TTASEventMutex<GenericPolicy>]: Assertion `!is_owned()' failed.
|
190310 9:54:29 [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.2.23-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=9
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63104 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7fcea8000d60
|
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 = 0x7fcec8267a40 thread_stack 0x49000
|
/home/jan/mysql/10.2-galera/sql/mysqld(my_print_stacktrace+0x38)[0x55d3c8cd2c84]
|
/home/jan/mysql/10.2-galera/sql/mysqld(handle_fatal_signal+0x3dc)[0x55d3c85883eb]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7fcecec40730]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x10b)[0x7fcecdaa88bb]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x121)[0x7fcecda93535]
|
linux/raise.c:51(__GI_raise)[0x7fcecda9340f]
|
stdlib/abort.c:81(__GI_abort)[0x7fcecdaa10f2]
|
/home/jan/mysql/10.2-galera/sql/mysqld(+0xa5e4f2)[0x55d3c87b74f2]
|
/home/jan/mysql/10.2-galera/sql/mysqld(+0xa5d460)[0x55d3c87b6460]
|
include/sync0policy.ic:66(MutexDebug<TTASEventMutex<GenericPolicy> >::enter(TTASEventMutex<GenericPolicy> const*, char const*, unsigned int))[0x55d3c87b494d]
|
include/sync0policy.h:347(GenericPolicy<TTASEventMutex<GenericPolicy> >::enter(TTASEventMutex<GenericPolicy> const&, char const*, unsigned int))[0x55d3c88181e4]
|
include/ib0mutex.h:637(PolicyMutex<TTASEventMutex<GenericPolicy> >::enter(unsigned int, unsigned int, char const*, unsigned int))[0x55d3c878d880]
|
lock/lock0lock.cc:6957(lock_trx_handle_wait(trx_t*))[0x55d3c858ae55]
|
handler/ha_innodb.cc:5288(innobase_kill_query(handlerton*, THD*, thd_kill_levels))[0x55d3c832efcc]
|
sql/handler.cc:810(kill_handlerton(THD*, st_plugin_int**, void*))[0x55d3c858aeaf]
|
sql/sql_plugin.cc:2396(plugin_foreach_with_mask(THD*, char (*)(THD*, st_plugin_int**, void*), int, unsigned int, void*))[0x55d3c82c9fb8]
|
sql/handler.cc:817(ha_kill_query(THD*, thd_kill_levels))[0x55d3c84edac1]
|
sql/sql_class.cc:1720(THD::awake(killed_state))[0x55d3c87aa055]
|
sql/wsrep_mysqld.cc:2648(wsrep_thd_awake)[0x55d3c87aa698]
|
handler/ha_innodb.cc:19634(wsrep_innobase_kill_one_trx(void*, trx_t const*, trx_t*, unsigned long))[0x55d3c85988bf]
|
handler/ha_innodb.cc:19708(wsrep_abort_transaction(handlerton*, THD*, THD*, char))[0x55d3c84ff339]
|
sql/handler.cc:6252(ha_abort_transaction(THD*, THD*, char))[0x55d3c84eba9e]
|
sql/wsrep_thd.cc:656(wsrep_abort_thd(void*, void*, char))[0x55d3c8469579]
|
sql/wsrep_mysqld.cc:2009(wsrep_grant_mdl_exception(MDL_context*, MDL_ticket*, MDL_key const*))[0x55d3c8469e96]
|
sql/mdl.cc:1592(MDL_lock::can_grant_lock(enum_mdl_type, MDL_context*, bool) const)[0x55d3c846a216]
|
sql/mdl.cc:1923(MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**))[0x55d3c82a09ec]
|
sql/mdl.cc:2067(MDL_context::acquire_lock(MDL_request*, double))[0x55d3c82a1373]
|
sql/sql_base.cc:1453(open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, unsigned int, MDL_ticket**))[0x55d3c82a45e0]
|
sql/sql_base.cc:1752(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x55d3c82a579e]
|
sql/sql_base.cc:3488(open_and_process_table(THD*, LEX*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x55d3c82a6f51]
|
sql/sql_base.cc:4009(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x55d3c8299f07]
|
sql/sql_base.cc:4767(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x55d3c86b608e]
|
/home/jan/mysql/10.2-galera/sql/mysqld(_ZN9Log_event11apply_eventEP14rpl_group_info+0x59)[0x55d3c82716b9]
|
/home/jan/mysql/10.2-galera/sql/mysqld(+0x7a2b88)[0x55d3c84fbb88]
|
sql/sql_base.h:504(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int))[0x55d3c84fc35b]
|
/usr/lib/libgalera_smm.so(_ZNK6galera9TrxHandle5applyEPvPF15wsrep_cb_statusS1_PKvmjPK14wsrep_trx_metaERS6_+0xb8)[0x7fcec8d8d4a8]
|
/usr/lib/libgalera_smm.so(+0x21880e)[0x7fcec8dce80e]
|
src/trx_handle.cpp:316(galera::TrxHandle::apply(void*, wsrep_cb_status (*)(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*), wsrep_trx_meta const&) const)[0x7fcec8dd0fb5]
|
src/replicator_smm.cpp:92(apply_trx_ws(void*, wsrep_cb_status (*)(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*), wsrep_cb_status (*)(void*, unsigned int, wsrep_trx_meta const*, bool*, bool), galera::TrxHandle const&, wsrep_trx_meta const&))[0x7fcec8dd40c6]
|
src/replicator_smm.cpp:450(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*))[0x7fcec8db1878]
|
src/replicator_smm.cpp:1250(galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*))[0x7fcec8db2408]
|
src/gcs_action_source.cpp:117(galera::GcsActionSource::dispatch(void*, gcs_action const&, bool&))[0x7fcec8dd467d]
|
src/gcs_action_source.cpp:28(galera::GcsActionSource::process(void*, bool&))[0x7fcec8de73f8]
|
/home/jan/mysql/10.2-galera/sql/mysqld(+0x7a516c)[0x55d3c84fe16c]
|
/home/jan/mysql/10.2-galera/sql/mysqld(start_wsrep_THD+0x4db)[0x55d3c84ebfcd]
|
nptl/pthread_create.c:487(start_thread)[0x7fcecec35fa3]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fcecdb6a82f]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fcebc0c313b): INSERT INTO t1 (f1) SELECT 000000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5
|
Connection ID (thread ID): 2
|
Status: NOT_KILLED
|
Attachments
Issue Links
- is blocked by
-
MDEV-23328 Server hang due to Galera lock conflict resolution
- Closed
- relates to
-
MDEV-18464 Port kill_one_trx fixes from 10.4 to 10.1
- Closed