Over 2000 MySQL errors today!

[Me2Be]

I checked the board this morning and everything was working fine. I went to log on tonight to check it out and there are 2339 Vbulletin database errors in my mailbox!

The board appears to be fine, I see messages being posted and I can create/reply to messages.

I haven't made any script or database changes in weeks, so I'm not sure why this is happening all of a sudden!

Here are some of the errors:

Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,8327,'63.28.52.148',974657884,'/index.php')
mysql error: Got error -1 from table handler
mysql error number: 1030

Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,0,'64.12.96.205',974662852,'/index.php')
mysql error: Got error -1 from table handler
mysql error number: 1030

Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,6937,'205.188.196.32',974664298,'/forumdisplay.php?forumid=50')
mysql error: Got error -1 from table handler
mysql error number: 1030

They are all pretty much the same thing -- anyone have any ideas how to fix this or what is wrong?

[Freddie Bingham]

It is the same session problem you had before.

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

[Me2Be]

I had found that after I posted this (I should have deleted this) and found the instructions and session_fix.php file you gave me last time.

Thanks!

[eva2000]

me2be are you running 1.1.4 ? i got around 70 of these errors yesterday as well


Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,470,'216.78.45.24',974603729,'/')
mysql error: Duplicate entry '168274' for key 1
mysql error number: 1062
Date: Saturday 18th of November 2000 09:15:29 PM
Script: /
Referer:

it turns out my session, category and another table went corrupt - i realised my uptime was 15 mins compared to 8 days so my server was restarted not by me - which may have caused my corruption.

the MySQL repairing and prevention guide in my sig - http://vbulletin.com/forum/showthread.php?threadid=3944 pretty much covers this for MySQL v3.22.23 and below

if you're on MySQL 3.23.x and above just use myisamchk instead of isamchk command

i.e. for mysql 3.23.27 beta (note 3.22.x use isamchk)

to check for corruption.

1. shut down mysql server

/etc/rc.d/init.d/mysql stop

2. check to see all mysql processes have finished using 'top' and

ps aux|grep mysql|more

3. check for errors in forum tables

/usr/local/bin/myisamchk /usr/local/var/mysql/forum/*.MYI

4. if errors turn up, fix them

/usr/local/bin/myisamchk -r /usr/local/var/mysql/forum/*.MYI

that runs repair on all tables including ones with no errors

or you can repair the particular table using

/usr/local/bin/myisamchk -r /usr/local/var/mysql/forum/session.MYI

for session table or whichever tables are corrupted


5. may want to rerun a check

/usr/local/bin/myisamchk /usr/local/var/mysql/forum/*.MYI

6. if no errors display

7. restart mysql server

/etc/rc.d/init.d/mysql start

[Me2Be]

No, still on 1.1.3 - I'm using too many hacks and didn't want to have to rework them for 1.1.4. I'm (im)patiently waiting for 2.0! ;)