About two days ago our entire db went down. Not mysql issues or vb there was a root runaway process which they killed which stopped the slew of vb database errors we were getting. We thought whew!
Tonight starting about 7pm CST till about 9pm CST we have been getting multiple errors. I checked the server we seem to be ok there for moment.
Here is our top
last pid: 87433; load averages: 2.43, 2.43, 2.41 up 5+06:49:21 02:21:22
46 processes: 2 running, 44 sleeping
CPU states: 46.4% user, 0.0% nice, 11.0% system, 0.4% interrupt, 42.2% idle
Mem: 513M Active, 243M Inact, 163M Wired, 39M Cache, 112M Buf, 47M Free
Swap: 1024M Total, 80M Used, 944M Free, 7% Inuse
Here are some of the errors we are seeing.
Database error in vBulletin :
cannot use database forums
mysql error: Lost connection to MySQL server during query
_________________
Invalid SQL: UPDATE session SET lastactivity=1034813144,location='/portal/forums/showthread.php?s=&postid=6036' WHERE sessionhash='b88dfb201b3cf585c3824c36a1504d78'
mysql error: File '/usr/local/mysql-3.23.52/var/forums/session.MYD' not found (Errcode: 24)
mysql error number: 1105
___________________________-
Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,171,173,214,255,964,992,993,995,1048,1049,1088,1134,1173,1201,2854,2944,3098,3104,3108, 3147,3158,3197,3413,3880,4118,4365,4474,4503,4519,4729,4865,4969,5022,5947,5963,5987,6036)
ORDER BY dateline
mysql error: Can't find file: './forums/userfield.frm' (errno: 24)
mysql error number: 1017
________________________-
The first one I get we are losing the connection to the db however mysql uptime is
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.52
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 23 hours 41 min 0 sec
Threads: 33 Questions: 900034 Slow queries: 1889 Opens: 6981 Flush tables: 1
Open tables: 64 Queries per second avg: 10.556
Any help would be greatly appreciated.
Chris
Tonight starting about 7pm CST till about 9pm CST we have been getting multiple errors. I checked the server we seem to be ok there for moment.
Here is our top
last pid: 87433; load averages: 2.43, 2.43, 2.41 up 5+06:49:21 02:21:22
46 processes: 2 running, 44 sleeping
CPU states: 46.4% user, 0.0% nice, 11.0% system, 0.4% interrupt, 42.2% idle
Mem: 513M Active, 243M Inact, 163M Wired, 39M Cache, 112M Buf, 47M Free
Swap: 1024M Total, 80M Used, 944M Free, 7% Inuse
Here are some of the errors we are seeing.
Database error in vBulletin :
cannot use database forums
mysql error: Lost connection to MySQL server during query
_________________
Invalid SQL: UPDATE session SET lastactivity=1034813144,location='/portal/forums/showthread.php?s=&postid=6036' WHERE sessionhash='b88dfb201b3cf585c3824c36a1504d78'
mysql error: File '/usr/local/mysql-3.23.52/var/forums/session.MYD' not found (Errcode: 24)
mysql error number: 1105
___________________________-
Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,171,173,214,255,964,992,993,995,1048,1049,1088,1134,1173,1201,2854,2944,3098,3104,3108, 3147,3158,3197,3413,3880,4118,4365,4474,4503,4519,4729,4865,4969,5022,5947,5963,5987,6036)
ORDER BY dateline
mysql error: Can't find file: './forums/userfield.frm' (errno: 24)
mysql error number: 1017
________________________-
The first one I get we are losing the connection to the db however mysql uptime is
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.52
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 23 hours 41 min 0 sec
Threads: 33 Questions: 900034 Slow queries: 1889 Opens: 6981 Flush tables: 1
Open tables: 64 Queries per second avg: 10.556
Any help would be greatly appreciated.
Chris
Comment