Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21536

galera.galera_sp_insert_parallel MTR failed: [Warning] WSREP: trx not committed in purge and discard

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.12, 10.5.2
    • N/A
    • Galera, Tests
    • None
    • 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
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            stepan.patryshev Stepan Patryshev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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