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

checksums on multiple servers are not computed equally

    XMLWordPrintable

Details

    Description

      I'm not sure when or where this exactly happens (maybe massive inserts)
      But after some time the checksums of tables differ between master and remote.

      Issuing a repair table command fixes this issue (temporary).

      The table has the option "checksum=1"

      I assume the write order of massive inserts differ and therefore the calculation of the checksum is different.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36460 Checksum Table Quick is not updated correctly

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15519 CHECKSUM TABLE gives different results across MariaDB 10.0 and 10.2

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40482 Quick-Checksum failure in aria

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.