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

Error "Checsum failure while reading node partition in file" makes server crashes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.27
    • N/A

    Description

      After replacing SSD drives laying under the the RAID+LVM (256GB drives to larger 512GB drives) and extending the LVM logical volume, server started crashing with:

      Checksum failure while reading node partition in file ... error on different TokuDB files (example crash.log attached) - most of the time it's main files, sometime index
      Table structure attached. Crash can be reproduced easily by reading the whole table (or identify the failing part of the data range and read its data).

      The only solution was to drop index/table - in case of table it hurt because it contained 10M-100M lines of data.
      What helps was to split large tables into partitions, smaller ones are not crashing anymore, but the the ones containing 30M+ lines per partition still crashes from time to time.

      My question is if it's related to storage layer or tokudb/mariadb?

      Attachments

        1. emerge.info
          5 kB
        2. my.cnf
          4 kB
        3. scanner.sql
          1 kB
        4. crash.log
          1.0 kB
        5. 20160711-mysqld.err
          9 kB
        6. core-gdb-201611071338.txt
          33 kB
        7. 201611071723-mysql.err
          12 kB
        8. core-gdb-201611071723.txt
          36 kB
        9. core-gdb-full-201611071338.txt
          46 kB
        10. core-gdb-full-201611071723.txt
          49 kB
        11. core-gdb-full-201611071338.txt
          46 kB
        12. 201611110203-innodb-mysqld.err
          10 kB
        13. 20161118-mysqld.err
          451 kB

        Activity

          People

            jplindst Jan Lindström (Inactive)
            jhejl Jan Hejl
            Votes:
            0 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.