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
          Andreas Schnederle-Wagner
        2. icinga.jpg
          159 kB
          Andreas Schnederle-Wagner
        3. mariadb.28062017.log
          562 kB
          Andreas Schnederle-Wagner
        4. mariadb.log
          562 kB
          Andreas Schnederle-Wagner
        5. mariadb.log
          2.87 MB
          Andreas Schnederle-Wagner
        6. piwik_archive_blob_2015_07_show_blob.jpg
          595 kB
          Andreas Schnederle-Wagner
        7. piwik_archive_blob_2015_07.jpg
          286 kB
          Andreas Schnederle-Wagner
        8. show_variables.txt
          18 kB
          Andreas Schnederle-Wagner

          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: