Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.22
-
Centos 7
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
Issue Links
- relates to
-
MDEV-26933 InnoDB fails to detect page number mismatch
- Closed
-
MDEV-31347 fil_ibd_create() may hijack the file handle of an old file
- Closed