[MDEV-21536] galera.galera_sp_insert_parallel MTR failed: [Warning] WSREP: trx not committed in purge and discard Created: 2020-01-20  Updated: 2022-05-05  Resolved: 2022-05-04

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.12, 10.5.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

kvm-deb-jessie-x86


 Description   

galera.galera_sp_insert_parallel failed on bb.

stdio.log:

10.4.12 7ea413ac2d80c7f03d1dbad90ac30ecddd8b2835

 
galera.galera_sp_insert_parallel 'innodb' w1 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2020-01-20 01:54:37
 
line
 
2020-01-20  1:54:36 2 [Warning] WSREP: trx not committed in purge and discard: source: a12f9693-3b51-11ea-b396-da965a37fc20 version: 5 local: 1 flags: 65 conn_id: 70 trx_id: 3964 tstamp: 509738528698; state: REPLICATING:0->CERTIFYING:3078->APPLYING:1064->COMMITTING:1299->COMMITTED:1498 seqnos (l: 1722, g: 1910, s: 1908, d: 1809) WS pa_range: 101; state history: REPLICATING:0->CERTIFYING:3078->APPLYING:1064->COMMITTING:1299->COMMITTED:1498
 
^ Found warnings in /dev/shm/var/1/log/mysqld.2.err
 
ok
 
 
 
 - saving '/dev/shm/var/1/log/galera.galera_sp_insert_parallel-innodb/' to '/dev/shm/var/log/galera.galera_sp_insert_parallel-innodb/'
 
 
 
Retrying test galera.galera_sp_insert_parallel, attempt(2/3)...
 
 
 
worker[1] > Restart  - not started
 
worker[1] > Restart  - not started
 
galera.galera_binlog_event_max_size_min 'innodb' w2 [ pass ]   2015
 
worker[2] > Restart [mysqld.1 - pid: 13670, winpid: 13670] - using different config file
 
worker[2] > Restart [mysqld.2 - pid: 13706, winpid: 13706] - using different config file
 
galera.galera_sp_insert_parallel 'innodb' w1 [ retry-pass ]   4286
 
 
 
Retrying test galera.galera_sp_insert_parallel, attempt(3/3)...
 
 
 
galera.galera_sp_insert_parallel 'innodb' w1 [ retry-pass ]   5107



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-03-23 ]

It failed also on bb, 10.5.

Comment by Stepan Patryshev (Inactive) [ 2020-07-13 ]

It failed on BB 10.4 and 10.5:

10.4.14 5d471453edb6f6cbe4f6c2a233c158082b4b52fb, kvm-deb-stretch-x86

 
galera.galera_sp_insert_parallel 'innodb' w1 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2020-07-11 08:19:09
 
line
 
2020-07-11  8:19:07 66 [Warning] WSREP: Wait for gtid returned error 3 while waiting for prior transactions to commit before setting position
 
^ Found warnings in /dev/shm/var/1/log/mysqld.2.err
 
ok
 
 
 
 - saving '/dev/shm/var/1/log/galera.galera_sp_insert_parallel-innodb/' to '/dev/shm/var/log/galera.galera_sp_insert_parallel-innodb/'
 
 
 
Retrying test galera.galera_sp_insert_parallel, attempt(2/3)...
 
 
 
worker[1] > Restart  - not started
 
worker[1] > Restart  - not started

Comment by Jan Lindström (Inactive) [ 2022-05-04 ]

Could not reproduce with 10.4.25+26.4.11

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