on 04/27/2005 09:58 AM Oskar said the following:
You see - tables are locked and the only way to fix it is restarting MySQL.
Could you tell me what am I doing wrong, please?
I suspect that your scripts may be exiting once in a while with unfinished transactions due to bugs or errors that make it end prematurely. With persistent connections you need to rollback unfinished transations by the end of the script.
The solution of Metabase (portable database abstraction package) is to implicitly register a shutdown function that clean any pending transactions:
Regards, Manuel Lemos
PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/
PHP Reviews - Reviews of PHP books and other products http://www.phpclasses.org/reviews/
Metastorage - Data object relational mapping layer generator http://www.meta-language.net/metastorage.html
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php