Re: PostgreSQL 8.4.8 bringing my website down every evening

On Mon, Jun 20, 2011 at 9:36 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> I've added
>
>  $db->beginTransaction();
>  ....
>  $db->commit();
>
> around _all_ statements, but now get:

I don't think that was a good idea.

>  SQLSTATE[25P02]: In failed sql transaction:
>  7 ERROR: current   transaction is aborted,
>  commands ignored until end of transaction block
>
> quite often. I don't understand why
> would transaction get aborted here...

Probably some commands were meant to be run
in same transaction, or were transaction control
commands.

Don't do it without synchronizing with business logic...

> Maybe I should try session mode of pgbouncer
> again, now that I've got rid of the persistent
> PHP connections?

You could, but try to turn off prepared
statements in PDO first.

--
marko