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

Database page corruptions

    XMLWordPrintable

    Details

      Description

      Hello,
      on one of our MariaDB Servers (running Piwik) we observe lot's of Database Page corruptions.
      Since it's running on the same SSD SAN as dozens of other MySQL/MariaDB/Percona SQL Servers I can exclude the Storage as the Source of the Problem.
      Also several other DB Servers on same Hardware Node show no such Problems.

      Could there be some kind of Bug? Already restored some of those Tables several times because of the Page corruptions ... I attached Log File starting with 28.03.2017 - at this Date all Tables were working. (restored some crashed Tables on 27.03.2017)

      Today again:

      mysqlcheck --all-databases --auto-repair
         Repairing tables
         piwik.piwik_archive_blob_2015_07
         Error    : Table 'piwik.piwik_archive_blob_2015_07' doesn't exist in engine
         status   : Operation failed
       
      ll /var/lib/mysql/piwik/piwik_archive_blob_2015_07*
         -rw-rw---- 1 mysql mysql      2380 Apr  2 03:09 /var/lib/mysql/piwik/piwik_archive_blob_2015_07.frm
         -rw-rw---- 1 mysql mysql 364904448 Apr  2 03:10 /var/lib/mysql/piwik/piwik_archive_blob_2015_07.ibd
      

      Andreas Schnederle-Wagner

        Attachments

        1. create_table.txt
          0.4 kB
        2. icinga.jpg
          icinga.jpg
          159 kB
        3. mariadb_config.zip
          9 kB
        4. mariadb.28062017.log
          562 kB
        5. mariadb.log
          562 kB
        6. mariadb.log
          2.87 MB
        7. piwik_archive_blob_2015_07_show_blob.jpg
          piwik_archive_blob_2015_07_show_blob.jpg
          595 kB
        8. piwik_archive_blob_2015_07.jpg
          piwik_archive_blob_2015_07.jpg
          286 kB
        9. show_variables.txt
          18 kB

          Activity

            People

            • Assignee:
              marko Marko Mäkelä
              Reporter:
              Futureweb Andreas Schnederle-Wagner
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: