PDA

View Full Version : Over 2000 MySQL errors today!


Me2Be
Mon 20th Nov '00, 12:01am
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
Mon 20th Nov '00, 1:09am
It is the same session problem you had before.

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

Me2Be
Mon 20th Nov '00, 1:13am
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
Mon 20th Nov '00, 1:17am
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
Mon 20th Nov '00, 1:06pm
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! ;)