Re: PostgreSQL 8.4.8 bringing my website down every evening

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: PostgreSQL 8.4.8 bringing my website down every evening
Дата
Msg-id BANLkTi=BuHctNZ6ZGY6eYyLYg50sP5=csQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 8.4.8 bringing my website down every evening  (Amitabh Kant <amitabhkant@gmail.com>)
Ответы Re: PostgreSQL 8.4.8 bringing my website down every evening
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Marko Kreen
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening
Следующее
От: BangarRaju Vadapalli
Дата:
Сообщение: Re: Forward referencing of table aliases in subqueries does not work in 9.1 beta2 ( works in 9.0 and 8.4.2 )