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
          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

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              Futureweb Andreas Schnederle-Wagner
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.