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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.9
    • Fix Version/s: 10.9
    • Component/s: Galera
    • Labels:
      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

          Activity

            People

            Assignee:
            Yurchenko Alexey
            Reporter:
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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