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 assur

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 you

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

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 t

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

2005-04-27 Thread Oskar
ssage- > From: Manuel Lemos [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 > i

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 ma

[PHP-DB] Transaction over persistent connection problem

2005-04-27 Thread Oskar
Hello, I would like to create transaction that is commited/rolled back in the next step of the script. Example: Apply changes? Yes No I don't know why but sometimes the script works som