Hallo leute,
ich habe einige Probleme mit meiner Website. In der MySQL log habe ich folgendes gefunden;
SQL
2020-12-06 2:00:59 4624 [ERROR] InnoDB: Database page corruption on disk or a
failed file read of tablespace der@002dls@
002dtreffpunkt/wcf1_attachment page [page id: space=668, page number=157].
You may have to recover from a backup.
2020-12-06 2:00:59 4624 [Note] InnoDB: Page dump in ascii and hex (16384
bytes):
InnoDB: End of page dump
2020-12-06 2:00:59 4624 [Note] InnoDB: Uncompressed page, stored checksum in
field1 2930249221, calculated checksums for
field1: crc32 2079064010, innodb 3868367162, page type 17855 ==
INDEX.none 3735928559, stored checksum in field2 293024
9221, calculated checksums for field2: crc32 2079064010, innodb
1754119730, none 3735928559, page LSN 0 1925378465, low
4 bytes of LSN at page end 1925378465, page number (if stored to page
already) 157, space id (if created with >= MySQL-4.
1.1 and stored already) 668
2020-12-06 2:00:59 4624 [Note] InnoDB: Page may be an index page where index
id is 1760
2020-12-06 2:00:59 4624 [Note] InnoDB: Index 1760 is `PRIMARY` in table
`der-ls-treffpunkt`.`wcf1_attachment`
2020-12-06 2:00:59 4624 [Note] InnoDB: It is also possible that your
operating system has corrupted its own file cache a
nd rebooting your computer removes the error. If the corrupt page is an
index page. You can also try to fix the corruptio
n by dumping, dropping, and reimporting the corrupt table. You can use
CHECK TABLE to scan your table for corruption. Ple
ase refer to [1]https://mariadb.com/kb/en/library/innodb-recovery-modes/
for information about forcing recovery.
Display More
Ich nutze einen Linux RootServer (Debian 10 - Plesk Obsidian) und verwalte meine Datenbanken über Plesk. Wenn ich zb. in phpMyAdmin alle Tabellen makiere und auf repariere Tabelle klicke, bekomme ich nach geraumer Zeit folgendes gemeldet
Könnte mir jemand dazu etwas Hilfestellung geben?
Danke vorab