Daily Table Failure

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Deddog
Forum Commoner
Posts: 55
Joined: Thu Sep 26, 2002 6:05 am
Location: Brighton

Daily Table Failure

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
hedge
Forum Contributor
Posts: 234
Joined: Fri Aug 30, 2002 10:19 am
Location: Calgary, AB, Canada

Post 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.
Deddog
Forum Commoner
Posts: 55
Joined: Thu Sep 26, 2002 6:05 am
Location: Brighton

New error messages

Post 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.
Deddog
Forum Commoner
Posts: 55
Joined: Thu Sep 26, 2002 6:05 am
Location: Brighton

Hopefull solution

Post 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.
Post Reply