From: | Iurii Popov <iurii(dot)i(dot)popov(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14310: Triggers do not fire |
Date: | 2016-09-26 09:38:10 |
Message-ID: | CAGjBcO2xrURk7697rCAO=vXaGRY7Ed4+edBdWZLSt-_7PubLcg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The problem was with pgbouncer: https://pgbouncer.github.io/changelog.html
WARNING: Since version 1.7, server_reset_query is not executed when
database is in transaction-pooling mode. Seems this was not highlighted
enough in 1.7 announcement. If your apps depend on that happening, use
server_reset_query_always to restore previous behaviour.
We use pool_mode = transaction
Adding server_reset_query_always = 1 solves the problem. But I have not
understand a reason yet.
2016-09-05 18:05 GMT+03:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> iurii(dot)i(dot)popov(at)gmail(dot)com writes:
> > We have a repeating problem with triggers and handles in foreign keys
> since
> > we have updated PostgreSQL.
>
> > There are two projects with PostgreSQL 9.2.17 and 9.4.9 respectively. We
> do
> > not have the problem with 9.2.16 and 9.4.4 versions.
>
> > By accident a BEFORE INSERT FOR EACH ROW triggers do not fire and
> handles in
> > foreign keys (ON DELETE SET NULL and ON DELETE CASCADE) do not fire.
>
> > If we do actions by hands (INSERT or DELETE) everything works but with
> > people online we have this problem by accident.
>
> This is not enough information for anyone to reproduce your problem, or
> even really to understand what you're talking about.
>
> For hints on how to submit a useful bug report, please see
>
> https://www.postgresql.org/docs/9.4/static/bug-reporting.html
>
> https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>
> regards, tom lane
>
--
Iurii Popov
From | Date | Subject | |
---|---|---|---|
Next Message | kgmeetsonu | 2016-09-26 13:53:55 | BUG #14340: pg xlog size increasing |
Previous Message | Greg Stark | 2016-09-25 21:24:15 | Re: "HDT" time zone not recognized by PostreSQL 9.5 |