Had a little database corruption in attachments - MVAgusta.net
 
LinkBack Thread Tools Display Modes
post #1 of 7 (permalink) Old 06-29-2006, 01:21 AM Thread Starter
Administrator
 
alvin's Avatar
 
Join Date: May 2005
Location: California, US
Posts: 8,856
Send a message via Yahoo to alvin
Had a little database corruption in attachments

Hello,

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

Quote:
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.
alvin is offline  
Sponsored Links
Advertisement
 
post #2 of 7 (permalink) Old 06-29-2006, 01:40 AM
Senior Member
 
fazer6's Avatar
 
Join Date: Mar 2006
Location: Tempe, AZ, USA
Posts: 8,920
Cool, no sweat Alvin. Best recovery time I thinnk I've ever seen!
fazer6 is offline  
post #3 of 7 (permalink) Old 06-29-2006, 01:46 AM
Senior Member
 
Join Date: Nov 2005
Location: South Australia
Posts: 2,839
Alvin, that means squat to me but I glad to see you're on top of it and it didn't cause you too much grief.
Rockethouse is offline  
Sponsored Links
Advertisement
 
post #4 of 7 (permalink) Old 06-29-2006, 12:16 PM
Senior Member
 
MV Blackie's Avatar
 
Join Date: Nov 2005
Location: Belgium
Posts: 312
Send a message via MSN to MV Blackie
nice job admin
under mysqladmin i often optimise all the tables, this helps preventing things going worse


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

MV Agusta : Magnificent Vehicle, All Greatest U See Trough Ages
Motorcycle Art
MV Blackie is offline  
post #5 of 7 (permalink) Old 06-29-2006, 04:31 PM
Senior Member
 
fazer6's Avatar
 
Join Date: Mar 2006
Location: Tempe, AZ, USA
Posts: 8,920
Ooh, i like the shirt!
fazer6 is offline  
post #6 of 7 (permalink) Old 06-29-2006, 04:32 PM Thread Starter
Administrator
 
alvin's Avatar
 
Join Date: May 2005
Location: California, US
Posts: 8,856
Send a message via Yahoo to alvin
It's a test for attachments.. something is going on with the database again
alvin is offline  
post #7 of 7 (permalink) Old 06-29-2006, 04:49 PM Thread Starter
Administrator
 
alvin's Avatar
 
Join Date: May 2005
Location: California, US
Posts: 8,856
Send a message via Yahoo to alvin
Made a few modifications to memory management and such. Seeing if this will help the issue that arose again.
alvin is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to use all of the features of the MVAgusta.net site, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome