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

WSREP RecordSet checksum inconsistency in IST when active data load on donor node

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.9(EOL)
    • N/A
    • Galera
    • None

    Description

      Sysbench data load command:

      sysbench /usr/share/sysbench/oltp_insert.lua  --mysql-storage-engine=innodb --table-size=10000000 --tables=10 --threads=10 --mysql-db=test --mysql-user=root --db-driver=mysql --mysql-socket=/test/mtest/GAL_MD100522-mariadb-10.9.0-linux-x86_64-opt/node1/node1_socket.sock prepare
      

      Error info

      2022-05-10  8:36:44 0 [ERROR] WSREP: RecordSet checksum does not match:
      computed: 8655f5a3 45c7b965 c7e51e6a 6346c064
      found:    e8d5d95a aa2562a1 01676ee2 a0d71159: 22 (Invalid argument)
               at /test/mtest/10.9_galera_opt/galerautils/src/gu_rset.cpp:checksum():554
      2022-05-10  8:36:44 0 [ERROR] WSREP: Writeset deserialization failed: Writeset checksum failed: 22 (Invalid argument)
               at /test/mtest/10.9_galera_opt/galera/src/write_set_ng.hpp:checksum_fin():865
               at /test/mtest/10.9_galera_opt/galera/src/trx_handle.hpp:unserialize():541
      WS flags:      0
      Trx proto:     5
      Trx source:    00000000-0000-0000-0000-000000000000
      Trx conn_id:   18446744073709551615
      Trx trx_id:    18446744073709551615
      Trx last_seen: -1
      2022-05-10  8:36:44 0 [ERROR] WSREP: got exception while reading IST stream: Writeset checksum failed: 22 (Invalid argument)
               at /test/mtest/10.9_galera_opt/galera/src/write_set_ng.hpp:checksum_fin():865
               at /test/mtest/10.9_galera_opt/galera/src/trx_handle.hpp:unserialize():541
      2022-05-10  8:36:44 0 [Note] WSREP: Receiving IST...  0.3% (  15/5932 events) complete.
      

      Attachments

        1. n1.cnf
          1 kB
        2. n2.cnf
          1 kB
        3. node2.err
          35 kB

        Issue Links

          Activity

            People

              Yurchenko Alexey
              ramesh Ramesh Sivaraman
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.