Re: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Manuel Lemos
Hello, 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

RE: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Oskar
[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 4:21 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Transaction over persistent connection problem The solution of Metabase (portable database abstraction package) is to implicitly register a shutdown function that clean any pending

Re: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Manuel Lemos
Hello, on 04/27/2005 11:49 AM Oskar said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and you cannot assure that

RE: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Oskar
Thanks for your help, Manuel. Your advice saved me hours of searching the web. Regards, OKi98 -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 7:20 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Transaction over persistent

Re: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Jochem Maas
Manuel Lemos wrote: Hello, on 04/27/2005 11:49 AM Oskar said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and

Re: [PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Manuel Lemos
Hello, on 04/27/2005 08:13 PM Jochem Maas said the following: Ok. So the idea of splitting one transaction into two steps of a script is wrong? Yes, it is not possible to achive that. What happens is that first access to script is handled by one Web server process or thread and you cannot