Page 1 of 1

Daily Table Failure

Posted: Wed May 28, 2003 10:26 am
by Deddog
Have a DB that contains 4 tables. 2 of these tables seem to fail over night. The system has been working fine the previous day but when you try to load a relevent page the follwing morning you get the below errors.
Rebooting the sever fixes the problem until the following morning.

Is there some DB logic i need to be made aware of? Is there a connection that is remaining open to the table over night? Is the "Back Up Exec" software causing the problem?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 81

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 138

No Results

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\sites\intranet\htdocs\new03\site\Contacts\frontpage.php on line 141

Posted: Wed May 28, 2003 10:30 am
by twigletmac
Perhaps adding some error handling into your script (using something like mysql_error() would help you get more useful error messages.

Something - connection, db selection, SQL statement - is failing so you need some error handling to find out what.

Mac

Posted: Wed May 28, 2003 1:06 pm
by hedge
We had backup exec cause our Oracle DB to go down each evening. The network guy had installed it on our DB server without telling me.

New error messages

Posted: Thu May 29, 2003 2:53 am
by Deddog
Cheers Hedge,
i'm sure i've heard of backup software causing problems.

Twigletmac,
thanks again. You keep telling me to do these things and i'm gonna get there one day. In my deffence i have been trawling through my code and trying to make it a bit more robust and error friendly.

It crashed again this morning.

on one table i got

Got error -1 from table handler

and on the other

Got error 28 from table handler.

Will try and locate these errors on the mysql site, but please feel free to state what they are.

Many thanks,

Deddog.

Hopefull solution

Posted: Thu May 29, 2003 3:14 am
by Deddog
Would seem the problem is to do with disk space.

Have cleared a wad off the HD, so I should hopefully be in the clear.