Daily Table Failure
Posted: Wed May 28, 2003 10:26 am
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
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