MV Agusta Forum banner

1 - 7 of 7 Posts

8,867 Posts
Discussion Starter #1

At around 11pm today, the attachments database of this forum was marked as corrupted by MySQL. I get e-mailed everytime there is an error when loading a page (the error many of you received when trying to view certain threads).

Looked into it and found that there was indeed some type of corruption. Backed up the files and ran some tools on them which ended successfully (as far as I can see).

Data records: 273 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
myisamchk: warning: Size of indexfile is: 162816 Should be: 36864
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 274 keys of 273
- check record links
myisamchk: error: Record-count is not ok; is 1522 Should be: 273
myisamchk: warning: Found 1528 parts Should be: 273 parts
MyISAM-table '**************.MYI' is corrupted
Fix it using switch "-r" or "-o"

- recovering (with sort) MyISAM-table '*************.MYI'
Data records: 273
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
Data records: 1522
This site has daily backups, as a precautionary measure just to let everyone know. Not only are full backups conducted and saved to a backup hard drive on this server, but database backups are made daily and transferred to another server. :conveyer:

8,867 Posts
Discussion Starter #7
Made a few modifications to memory management and such. Seeing if this will help the issue that arose again.
1 - 7 of 7 Posts