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

galera_sr.galera_sr_log_bin: Test failure: WSREP: Could not open state file for reading

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.3
    • 10.4.5
    • Galera, Tests
    • OS: CentOS Linux release 7.6.1810 (Core).

    Description

      stdout.log: (the whole file is attached: 190204_galera_sr_stdout_laptop.log)

      "galera_sr.galera_sr_log_bin 'innodb' [ fail ]

      CURRENT_TEST: galera_sr.galera_sr_log_bin
      mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

      2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

      2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

      2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
      mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
      190204 16:26:52 [ERROR] mysqld got signal 6 ;

      Server version: 10.4.3-MariaDB-debug-log
      key_buffer_size=1048576
      read_buffer_size=131072
      max_used_connections=2
      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 = 63459 K bytes of memory

      mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.      "

      See also attached galera_sr_log_bin.log.

      Note: This test has failed only on suite running, but on standalone running it has passed.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-17046 Galera 4: Streaming replication

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stepan.patryshev Stepan Patryshev (Inactive) created issue -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Field Original Value New Value
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Description *stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _{color:#DE350B}"galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed."{color}_

            See also attached [^galera_sr_log_bin.log].             		*stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _"{color:#0747A6}galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.{color}"_

            See also attached [^galera_sr_log_bin.log].
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Description *stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _"{color:#0747A6}galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.{color}"_

            See also attached [^galera_sr_log_bin.log].             		*stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _"{color:#0747A6}galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.{color}"_

            See also attached [^galera_sr_log_bin.log].

            *Note*: This test has failed only on suite running, but onn standalone running it has passed.
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Description *stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _"{color:#0747A6}galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.{color}"_

            See also attached [^galera_sr_log_bin.log].

            *Note*: This test has failed only on suite running, but onn standalone running it has passed.             		*stdout.log:* (the whole file is attached: [^190204_galera_sr_stdout_laptop.log])

            _"{color:#0747A6}galera_sr.galera_sr_log_bin 'innodb' [ fail ]

            CURRENT_TEST: galera_sr.galera_sr_log_bin
            mysqltest: At line 51: query 'COMMIT' failed: 2013: Lost connection to MySQL server during query

            2019-02-04 16:26:45 0 [Warning] WSREP: Could not open state file for reading: '/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//grastate.dat'

            2019-02-04 16:26:45 0 [Warning] WSREP: access file(/home/stepan/galera/git/10.4/server/mysql-test/var/mysqld.2/data//gvwstate.dat) failed(No such file or directory)

            2019-02-04 16:26:49 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.
            190204 16:26:52 [ERROR] mysqld got signal 6 ;

            Server version: 10.4.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=2
            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 = 63459 K bytes of memory

            mysqld: /home/stepan/galera/git/10.4/server/storage/innobase/trx/trx0rseg.cc:92: void trx_rseg_update_wsrep_checkpoint(trx_rsegf_t*, const XID*, mtr_t*): Assertion `xid_seqno > wsrep_seqno' failed.{color}"_

            See also attached [^galera_sr_log_bin.log].

            *Note*: This test has failed only on suite running, but on standalone running it has passed.
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Assignee Stepan Patryshev [ stepan.patryshev ] Daniele Sciascia [ sciascid ]
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            Last time it failed on my machine on 15.03.2019.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Last time it failed on my machine on 15.03.2019.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Daniele Sciascia [ sciascid ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) added a comment -

            Could not reproduce anymore.

            jplindst Jan Lindström (Inactive) added a comment - Could not reproduce anymore.
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2019-05-27 12:24:15.0 2019-05-27 12:24:15.996
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.5 [ 23311 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 92278 ] MariaDB v4 [ 155645 ]

            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.