[MDEV-24473] galera.galera_FK_duplicate_client_insert MTR failed: SIGABRT. InnoDB: Conflicting lock on table. Assertion failure in lock0lock.cc - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.18
Fix Version/s: N/A
Component/s: Galera, Tests
Labels:
None
Environment:
kvm-rpm-centos74-amd64-debug

Description

galera.galera_FK_duplicate_client_insert failed on BB 10.4 CS: SIGABRT. InnoDB: Conflicting lock on table. Assertion failure in lock0lock.cc .
It seems to be a sporadic issue.

stdio.log:

10.4.18, 41a961d85c9a083c816a9f628d97786964d208a5, kvm-rpm-centos74-amd64-debug
galera.galera_FK_duplicate_client_insert 'innodb' w2 [ fail ]
Test ended at 2020-12-17 13:21:26

CURRENT_TEST: galera.galera_FK_duplicate_client_insert
mysqltest: At line 101: query 'commit' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0...

The result from queries just before the failure was:
< snip >
connection node_1_u;
commit;
connection node_1;
truncate user_session;
set debug_sync = reset;
connection node_1_u;
begin;
update user set j = j + 1 WHERE id > 0;
connection node_1_i;
set debug_sync='lock_wait_suspend_thread_enter SIGNAL ins_waiting WAIT_FOR cont_ins';
insert into user_session(id,fk1,fk2) values (2, 2, 2);
connection node_1;
set debug_sync='now WAIT_FOR ins_waiting';
connection node_2_i;
insert into user_session(id,fk1,fk2) values (2, 2, 3);
connection node_1;
set debug_sync='now SIGNAL cont_ins';
connection node_1_i;
connection node_1_u;
commit;

More results from queries before failure can be found in /dev/shm/var/2/log/galera_FK_duplicate_client_insert.log


Server [mysqld.1 - pid: 6654, winpid: 6654, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2020-12-17 13:21:09 1 [ERROR] InnoDB: Conflicting lock on table: `test`.`user` index: PRIMARY that has lock
RECORD LOCKS space id 33 page no 3 n bits 72 index PRIMARY of table `test`.`user` trx id 536 lock mode S locks rec but not gap
Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
0: len 4; hex 80000002; asc ;;
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 4; hex 80000000; asc ;;

2020-12-17 13:21:09 1 [ERROR] InnoDB: WSREP state:
2020-12-17 13:21:09 1 [ERROR] WSREP: Thread BF trx_id: 539 thread: 1 seqno: 244 client_state: exec client_mode: high priority transaction_mode: replaying applier: 1 toi: 0 local: 0 query: update user set j = j + 1 WHERE id > 0E[�_
2020-12-17 13:21:09 1 [ERROR] WSREP: Thread BF trx_id: 536 thread: 2 seqno: 243 client_state: exec client_mode: high priority transaction_mode: committing applier: 1 toi: 0 local: 0 query: NULL
2020-12-17 13:21:09 0x7f0242851700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.18/storage/innobase/lock/lock0lock.cc line 687
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
201217 13:21:09 [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-debug-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=4
max_threads=153
thread_count=13
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63641 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x55a7589a8870
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 = 0x7f0242850c58 thread_stack 0x49000
addr2line: Dwarf Error: Offset (18481501) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1277835307) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (122439681) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (2198601474) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Could not find abbrev number 149.
addr2line: Dwarf Error: Offset (1560760067) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (4011649795) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1009978) greater than or equal to .debug_info size (878025).
addr2line: Dwarf Error: Unable to read alt ref 1009978.
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (7500912) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Could not find abbrev number 161.
addr2line: Dwarf Error: Offset (7628135) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (3992982149) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (5390925) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Could not find abbrev number 130.
mysys/stacktrace.c:174(my_print_stacktrace)[0x55a74d1f6ed6]
sql/signal_handler.cc:209(handle_fatal_signal)[0x55a74cabbeee]
sigaction.c:0(__restore_rt)[0x7f024ad0e5e0]
:0(__GI_raise)[0x7f024921a1f7]
:0(__GI_abort)[0x7f024921b8e8]
/usr/sbin/mysqld(+0xd48bde)[0x55a74cecdbde]
addr2line: Dwarf Error: Offset (18481501) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1277835307) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (122439681) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (2198601474) greater than or equal to .debug_str size (3522994).
/usr/sbin/mysqld(+0xb9068b)[0x55a74cd1568b]
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Could not find abbrev number 149.
/usr/sbin/mysqld(+0xb98191)[0x55a74cd1d191]
addr2line: Dwarf Error: Offset (1560760067) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (4011649795) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1009978) greater than or equal to .debug_info size (878025).
addr2line: Dwarf Error: Unable to read alt ref 1009978.
/usr/sbin/mysqld(+0xba07a6)[0x55a74cd257a6]
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (7500912) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Could not find abbrev number 161.
addr2line: Dwarf Error: Offset (7628135) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (3992982149) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (5390925) greater than or equal to .debug_str size (3522994).
/usr/sbin/mysqld(+0xba19ed)[0x55a74cd269ed]
addr2line: Dwarf Error: Could not find abbrev number 130.
/usr/sbin/mysqld(+0xcb9f27)[0x55a74ce3ef27]
/usr/sbin/mysqld(+0xcbfdb6)[0x55a74ce44db6]
/usr/sbin/mysqld(+0xb20e72)[0x55a74cca5e72]
/usr/sbin/mysqld(+0xb21324)[0x55a74cca6324]
ut/ut0new.cc:95(ut_new_boot())[0x55a74cac3375]
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2488161024) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1932546816) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2487309056) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2488161024) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1932546816) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2487309056) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2488161024) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1932546816) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2487309056) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2488161024) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1932546816) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2487309056) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2488161024) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1932546816) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2487309056) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (245173908) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (245173908) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
lock/lock0lock.cc:687(Gis_read_stream::check_next_symbol(char))[0x55a74cad1a14]
lock/lock0lock.cc:1161(Gis_read_stream::check_next_symbol(char))[0x55a74cbeac78]
lock/lock0lock.cc:1932(Gis_read_stream::check_next_symbol(char))[0x55a74cbeb9b3]
lock/lock0lock.cc:5808(lock_clust_rec_read_check_and_lock(unsigned long, buf_block_t const, unsigned char const, dict_index_t, unsigned short const, lock_mode, unsigned long, que_thr_t*))[0x55a74cbdc28e]
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (112788337) greater than or equal to .debug_str size (3522994).
row/row0sel.cc:1254(void std::__introsort_loop<unsigned char, long>(unsigned char, unsigned char**, long))[0x55a74ca1ba7e]
row/row0sel.cc:5095(row_search_mvcc(unsigned char, page_cur_mode_t, row_prebuilt_t, unsigned long, unsigned long))[0x55a74ca06592]
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365241379) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (31130435) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (26477338) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (29426478) greater than or equal to .debug_str size (1507968).
handler/ha_innodb.cc:9255(ha_innobase::index_read(unsigned char, unsigned char const, unsigned int, ha_rkey_function))[0x55a74d283d41]
handler/ha_innodb.cc:9756(ha_innobase::rnd_pos(unsigned char, unsigned char))[0x55a74d284de1]
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
sql/handler.cc:2897(handler::ha_rnd_pos(unsigned char, unsigned char))[0x55a74d297591]
addr2line: Dwarf Error: Offset (245173908) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (245173908) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (352528052) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (320193802) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2634978305) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (2634978305) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (3724748323) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (365234769) greater than or equal to .debug_str size (1507968).
src/trx_handle.cpp:387(galera::TrxHandleSlave::apply(void, wsrep_cb_status ()(void, wsrep_ws_handle const, unsigned int, wsrep_buf const, wsrep_trx_meta const, bool*), wsrep_trx_meta const&, bool&))[0x7f0245de6560]
src/trx_handle.hpp:826(galera::TrxHandleMaster::lock())[0x7f0245e234ae]
src/trx_handle.hpp:1132(galera_replay_trx)[0x7f0245e37c3b]
/usr/sbin/mysqld(_ZN5wsrep18wsrep_provider_v266replayERKNS_9ws_handleEPNS_21high_priority_serviceE+0x2a)[0x55a74d29845e]
addr2line: Dwarf Error: Offset (18481501) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (1277835307) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (122439681) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (2198601474) greater than or equal to .debug_str size (3522994).
/usr/sbin/mysqld(_ZN20Wsrep_client_service6replayEv+0x194)[0x55a74ca057a8]
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Could not find abbrev number 149.
addr2line: Dwarf Error: Offset (1560760067) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (4011649795) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1009978) greater than or equal to .debug_info size (878025).
addr2line: Dwarf Error: Unable to read alt ref 1009978.
/usr/sbin/mysqld(_ZN5wsrep11transaction6replayERNS_11unique_lockINS_5mutexEEE+0x80)[0x55a74d2927b6]
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (1507968).
/usr/sbin/mysqld(_ZN5wsrep11transaction15after_statementEv+0x418)[0x55a74d2945ac]
addr2line: Dwarf Error: Offset (7500912) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Could not find abbrev number 161.
addr2line: Dwarf Error: Offset (7628135) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (248912385) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (3992982149) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (1107325285) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Offset (6514020) greater than or equal to .debug_str size (1507968).
addr2line: Dwarf Error: Offset (5390925) greater than or equal to .debug_str size (3522994).
addr2line: Dwarf Error: Could not find abbrev number 130.
/usr/sbin/mysqld(_ZN5wsrep12client_state15after_statementEv+0x184)[0x55a74d2713ca]
/usr/sbin/mysqld(+0x6b8637)[0x55a74c83d637]
/usr/sbin/mysqld(+0x6ce107)[0x55a74c853107]
src/wsrep_provider_v26.cpp:867(wsrep::wsrep_provider_v26::replay(wsrep::ws_handle const&, wsrep::high_priority_service*))[0x55a74c854403]
sql/wsrep_client_service.cc:282(Wsrep_client_service::replay())[0x55a74c856d28]
src/transaction.cpp:1889(wsrep::transaction::replay(wsrep::unique_lock<wsrep::mutex>&))[0x55a74c960bce]
src/transaction.cpp:856(wsrep::transaction::after_statement())[0x55a74c960ca0]
src/client_state.cpp:258(wsrep::client_state::after_statement())[0x55a74d1a05dd]
pthread_create.c:0(start_thread)[0x7f024ad06e25]
/lib64/libc.so.6(clone+0x6d)[0x7f02492dd34d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f0245296d1b): update user set j = j + 1 WHERE id > 0

Connection ID (thread ID): 1
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on

The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /dev/shm/var/2/mysqld.1/data
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size unlimited unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 4096 23142 processes
Max open files 1024 1024 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 23142 23142 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: core

----------SERVER LOG END-------------


- found 'core.6655' (0/0)

Trying 'dbx' to get a backtrace
gdb not found, cannot get the stack trace

Trying 'lldb' to get a backtrace from coredump /dev/shm/var/2/log/galera.galera_FK_duplicate_client_insert-innodb/mysqld.1/data/core.6655
- deleting it, already saved 0
- skipping '/dev/shm/var/2/log/galera.galera_FK_duplicate_client_insert-innodb/'

Retrying test galera.galera_FK_duplicate_client_insert, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
***Warnings generated in error logs during shutdown after running tests: galera.MW-402 galera.MW-369 galera.MW-285 galera.enforce_storage_engine galera.fk galera.MW-252 galera.binlog_checksum galera.galera_FK_duplicate_client_insert galera.create galera.MW-258 galera.ev51914 galera.MW-357 galera.MW-292 galera.MW-416 galera.MW-388 galera.basic galera.galera#505 galera.MW-309 galera.MW-259 galera.galera#500

2020-12-17 13:21:09 1 [ERROR] InnoDB: Conflicting lock on table: `test`.`user` index: PRIMARY that has lock
2020-12-17 13:21:09 1 [ERROR] InnoDB: WSREP state:
2020-12-17 13:21:09 1 [ERROR] WSREP: Thread BF trx_id: 539 thread: 1 seqno: 244 client_state: exec client_mode: high priority transaction_mode: replaying applier: 1 toi: 0 local: 0 query: update user set j = j + 1 WHERE id > 0E[�_
2020-12-17 13:21:09 1 [ERROR] WSREP: Thread BF trx_id: 536 thread: 2 seqno: 243 client_state: exec client_mode: high priority transaction_mode: committing applier: 1 toi: 0 local: 0 query: NULL
Attempting backtrace. You can use the following information to find out

Server logs.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

MDEV-24473_104_logs_201217.zip
785 kB
2020-12-22 17:06

Issue Links

blocks

MDEV-23851 Galera assertion at lock0lock.cc line 655 because of BF-BF lock wait

Closed

relates to

MDEV-24775 galera.galera_FK_duplicate_client_insert test failure in 10.6

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2020-12-22 17:05

Updated:: 2022-01-31 08:24

Resolved:: 2022-01-21 06:34

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.