Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.18
-
None
-
kvm-zyp-opensuse150-amd64
Description
galera_sr.galera-features#56 failed on BB 10.4 CS: "query 'reap' failed: 1213: Deadlock found when trying to get lock".
It seems to be a sporadic issue.
10.4.18, 542d769ea1a22a7a6a87c9fe76ff911a162ade44, kvm-zyp-opensuse150-amd64 |
galera_sr.galera-features#56 'innodb' w2 [ fail ]
|
Test ended at 2021-01-28 08:45:33
|
|
CURRENT_TEST: galera_sr.galera-features#56
|
mysqltest: At line 50: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
|
|
The result from queries just before the failure was:
|
< snip >
|
connection node_2;
|
set session wsrep_sync_wait=15;
|
SELECT COUNT(*) from ten;
|
COUNT(*)
|
10
|
SELECT COUNT(*) from t1;
|
COUNT(*)
|
0
|
set session wsrep_sync_wait=0;
|
SET GLOBAL wsrep_slave_threads = 4;
|
SET SESSION wsrep_trx_fragment_size = 1;
|
connection node_1;
|
INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
|
connection node_1a;
|
INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
|
connection node_2;
|
INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2;;
|
connection node_1;
|
connection node_1a;
|
connection node_2;
|
|
More results from queries before failure can be found in /dev/shm/var/2/log/galera-features#56.log
|
|
- saving '/dev/shm/var/2/log/galera_sr.galera-features#56-innodb/' to '/dev/shm/var/log/galera_sr.galera-features#56-innodb/'
|
|
Retrying test galera_sr.galera-features#56, attempt(2/3)...
|
|
worker[2] > Restart - not started
|
worker[2] > Restart - not started
|
***Warnings generated in error logs during shutdown after running tests: galera_sr.GCF-900 galera_sr.GCF-561 galera_sr.GCF-1051 galera_sr.GCF-585 galera_sr.GCF-1008 galera_sr.GCF-627 galera_sr.MDEV-23623 galera_sr.GCF-1018 galera_sr.MDEV-22616 galera_sr.GCF-597 galera_sr.GCF-845 galera_sr.GCF-851 galera_sr.GCF-571 galera_sr.GCF-623 galera_sr.GCF-867 galera_sr.GCF-889 galera_sr.GCF-620 galera_sr.GCF-580 galera_sr.GCF-572 galera_sr.galera-features#56
|
|
2021-01-28 8:45:31 189 [Warning] WSREP: Could not find streaming applier for 0c336610-6145-11eb-b755-c63927cc0979:1476
|
2021-01-28 8:45:31 2 [ERROR] WSREP: Failed to apply write set: gtid: 0bf48c4d-6145-11eb-8658-435dcb31e7f0:562 server_id: 0c336610-6145-11eb-b755-c63927cc0979 client_id: 18446744073709551615 trx_id: 1476 flags: 20 (rollback | pa_unsafe)
|