Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 8.4.8 bringing my website down every evening - Mailing list pgsql-general

From Alexander Farber
Subject Re: PostgreSQL 8.4.8 bringing my website down every evening
Date
Msg-id BANLkTi=BuHctNZ6ZGY6eYyLYg50sP5=csQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL 8.4.8 bringing my website down every evening  (Amitabh Kant <amitabhkant@gmail.com>)
Responses Re: PostgreSQL 8.4.8 bringing my website down every evening  (Marko Kreen <markokr@gmail.com>)
List pgsql-general
Tree view 
I've added

  $db->beginTransaction();
  ....
  $db->commit();

around _all_ statements, but now get:

  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...

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

Regards
Alex

pgsql-general by date:

Previous
From: Marko Kreen
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening
Next
From: BangarRaju Vadapalli
Date:
Subject: Re: Forward referencing of table aliases in subqueries does not work in 9.1 beta2 ( works in 9.0 and 8.4.2 )