MySQL database problem - GoFuckYourself.com

solonline · 10-16-2004, 11:56 AM

Damnation a BB we run is throwing up a shit load of errors - seems only to have started the past hour or so. I know zero about this kind of thing, so am kinda stuck, when trying to post
im pulling this error :

Invalid SQL: INSERT INTO userfield (userid,field5,field1,field2,field3,field4) VALUES (10710,'text,'','','','') mysql error: Got error 28 from table handler
mysql error number: 1030

and when trying to run standard admin commands such as mass prune I get this :

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0,155,16063,29715,42358) AND postid=857986
mysql error: Can't find file: 'searchindex.MYD' (errno: 2)

mysql error number: 1017

Date: Saturday 16th of October 2004 11:41:50 AM
Script: http// url
Referer: http://url

If anybody has any ideas on what could be the problem please let me know.

thanks

SMG · 10-16-2004, 11:59 AM

sounds like your database crashed ... for starters:
REPAIR TABLE userfield;
MAYBE REPAIR TABLE searchindex;
as long as theyre INNODB tables.
otherwise you gotta go in shell and use isamchk

Scherfi · 10-16-2004, 12:00 PM

Quote:

Originally posted by solonline
VALUES (10710,'text,'','','','')

text is missing this: '

hth. good luck.

Serge Litehead · 10-16-2004, 12:02 PM

Quote:

Originally posted by Scherfi
text is missing this: '

hth. good luck.

nice catch

JSA Matt · 10-16-2004, 12:04 PM

Looks like your tables are corrupt, try running the REPAIR command on them or if you have root do this:

Kill the mysql process and make sure it is not running (mysqld)... you can either use the mysql.sh stop command or kill PID

cd into the directory where your database files are located and run

myisamchk -r */*.MYI

this should repair all your indexes

Scherfi · 10-16-2004, 12:06 PM

isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

solonline · 10-16-2004, 12:06 PM

ok thanks looking into all these now - help mucho appreciated

Damn im crap at such things as this but learn as go along cheers

solonline · 10-16-2004, 12:08 PM

Quote:

Originally posted by Scherfi
isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

Ah now that rings a bell when I had a similar meltdown last year -
checking this now cheers

JSA Matt · 10-16-2004, 12:09 PM

Quote:

Originally posted by Scherfi
isn't "error 28" out of memory or something like that?

http://forums.devshed.com/archive/t-124674

Yes, which is why the tables are now corrupted... first fix the memory leak then rebuild the tables

Scherfi · 10-16-2004, 12:13 PM

see, i love gfy for that

hope you get your problem solved.
good luck!

10-16-2004, 11:56 AM	#1
solonline Confirmed User Join Date: Jan 2003 Location: EU- Posts: 718	MySQL database problem Damnation a BB we run is throwing up a shit load of errors - seems only to have started the past hour or so. I know zero about this kind of thing, so am kinda stuck, when trying to post im pulling this error : Invalid SQL: INSERT INTO userfield (userid,field5,field1,field2,field3,field4) VALUES (10710,'text,'','','','') mysql error: Got error 28 from table handler mysql error number: 1030 and when trying to run standard admin commands such as mass prune I get this : Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0,155,16063,29715,42358) AND postid=857986 mysql error: Can't find file: 'searchindex.MYD' (errno: 2) mysql error number: 1017 Date: Saturday 16th of October 2004 11:41:50 AM Script: http// url Referer: http://url If anybody has any ideas on what could be the problem please let me know. thanks

10-16-2004, 11:59 AM	#2
SMG Confirmed User Join Date: Aug 2003 Posts: 1,798	sounds like your database crashed ... for starters: REPAIR TABLE userfield; MAYBE REPAIR TABLE searchindex; as long as theyre INNODB tables. otherwise you gotta go in shell and use isamchk __________________ TGP Webmasters: sign up for the top 100 tgp list! Submit galleries If you add me to icq (title) make sure to mention GFY or I'll think you're a bot and deny you.

10-16-2004, 12:06 PM	#6
Scherfi Confirmed User Join Date: Jun 2003 Location: PornStudio Posts: 868	isn't "error 28" out of memory or something like that? http://forums.devshed.com/archive/t-124674 __________________ http://www.fastthumber.com

10-16-2004, 12:13 PM	#10
Scherfi Confirmed User Join Date: Jun 2003 Location: PornStudio Posts: 868	see, i love gfy for that hope you get your problem solved. good luck! __________________ http://www.fastthumber.com

10-16-2004, 12:04 PM	#5
JSA Matt So Fucking Banned Join Date: Aug 2003 Location: San Diego, CA Posts: 5,464	Looks like your tables are corrupt, try running the REPAIR command on them or if you have root do this: Kill the mysql process and make sure it is not running (mysqld)... you can either use the mysql.sh stop command or kill PID cd into the directory where your database files are located and run myisamchk -r /.MYI this should repair all your indexes