More Recurrent Corruption

[macrumors]

I'm running into a recurrent corruption issue just in the past 2 days.

WHM 8.5.1 cPanel 8.5.3-S3
MySQL 4.0.15-standard
vBulletin 2.3.0

Corruption seems have crept into the attachement and searchindex db's each time... and a repair seems to work, but I'm not sure if anyone else is having this problem? I am on 4.0.15 so I don't think it's related to the previous discussion about recurrent problems.

I'm not sure how to proceed if this continues.

thanks
arn



Repairing forums_vbulletin

forums_vbulletin.access OK
forums_vbulletin.adminlog OK
forums_vbulletin.adminutil OK
forums_vbulletin.announcement OK
forums_vbulletin.attachment
info : Key 1 - Found wrong stored record at 324001772
info : Wrong bytesec: 110-34-112 at 324103344; Skipped
info : Found link that points at 72339069014638592 (outside data file) at 324103912
info : Found block with too small length at 324103932; Skipped
info : Found block with too small length at 324103960; Skipped
info : Found block with too small length at 324103976; Skipped
..............
info : Found block that points outside data file at 324144940
info : Found block that points outside data file at 324145092
info : Found block that points outside data file at 324145328
info : Found link that points at 838149946726379345 (outside data file) at 324145652
info : Found block with too small length at 324146072; Skipped
info : Found block with too small length at 324146408; Skipped
info : Found block that points outside data file at 324146476
info : Found link that points at -7114608535956187417 (outside data file) at 324146656
info : Found block with too small length at 324147060; Skipped
info : Found block with too small length at 324147064; Skipped
info : Found block that points outside data file at 324147900
warning : Number of rows changed from 8157 to 8156
status : OK
forums_vbulletin.avatar OK
forums_vbulletin.bbcode OK
forums_vbulletin.calendar_events OK
forums_vbulletin.customavatar OK
forums_vbulletin.forum OK
forums_vbulletin.forumpermission OK
forums_vbulletin.icon OK
forums_vbulletin.moderator OK
forums_vbulletin.poll OK
forums_vbulletin.pollvote OK
forums_vbulletin.post OK
forums_vbulletin.privatemessage OK
forums_vbulletin.profilefield OK
forums_vbulletin.replacement OK
forums_vbulletin.replacementset OK
forums_vbulletin.search OK
forums_vbulletin.searchindex
warning : Duplicate key for record at 67133572 against record at 22832546
warning : Duplicate key for record at 150205066 against record at 22832546
warning : Duplicate key for record at 150209576 against record at 22832546
..............
warning : Duplicate key for record at 67143890 against record at 50674052
warning : Duplicate key for record at 67137840 against record at 22831193
warning : Duplicate key for record at 150215857 against record at 50655605
warning : Number of rows changed from 15350813 to 15345461
status : OK
forums_vbulletin.session OK
forums_vbulletin.setting OK
forums_vbulletin.settinggroup OK
forums_vbulletin.smilie OK
forums_vbulletin.style OK
forums_vbulletin.subscribeforum OK
forums_vbulletin.subscribethread OK
forums_vbulletin.template OK
forums_vbulletin.templateset OK
forums_vbulletin.thread OK
forums_vbulletin.threadrate OK
forums_vbulletin.user OK
forums_vbulletin.useractivation OK
forums_vbulletin.userfield OK
forums_vbulletin.usergroup OK
forums_vbulletin.usertitle OK
forums_vbulletin.word OK

[macrumors]

I had had the cache query variables placed into my my.cnf briefly and it seemed to coincide time-wise with when the corruptions started... but I removed them and restarted mysql and still had a corruption once after that.


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=600
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[Steve Machol]

For help with optimizing your server, please see this thread:

http://www.vbulletin.com/forum/showthread.php?threadid=70117

[macrumors]

Just happned again


Database error in vBulletin 2.3.0:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (125,560450,0),(482,560450,0),(65,560450,0),(269,5 60450,0),(32,560450,0),(386,560450,0),(8143,560450 ,0),(1827,560450,0),(4761,560450,0),(2199,560450,0 ),(1576,560450,0),(110007,560450,0),(1971,560450,0 ),(915,560450,0),(3079,560450,0),(1257,560450,0),( 928,560450,0),(2266,560450,0),(5132,560450,0),(324 27,560450,0),(2161,560450,0),(97,560450,0),(1640,5 60450,0),(394802,560450,0),(26,560450,0),(2369,560 450,0),(110369,560450,0),(525,560450,0),(4176,5604 50,0),(691,560450,0),(622,560450,0),(594,560450,0) ,(46369,560450,0),(1096,560450,0),(109903,560450,0 )
mysql error: Incorrect key file for table: 'searchindex'. Try to repair it

mysql error number: 1034

Date: Friday 31st of October 2003 04:57:39 PM
Script: http://forums.macrumors.com/newreply.php
Referer: http://forums.macrumors.com/newreply.php?s=&action=newreply&threadid=45222