| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Robert Lebel <boblebel2(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14406: Statement fails after upgrade to 9.6.1 |
| Date: | 2016-11-28 14:56:25 |
| Message-ID: | 20161128145625.GB31951@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Sun, Nov 27, 2016 at 12:54:22PM -0700, Robert Lebel wrote:
> I can't really provide useful additional information, but I just had the same
> issue. An UPDATE with RETURNING statement was consistently failing after
> being called 5 or 6 times. After restarting my app server (which use
> postgres jdbc driver), the update query would work again 5-6 times, then
> fail.
>
> Recreating the table also made the issue disappear (thanks Corey). I tried
> vacuum etc, without success.
It sound like the 5-6 times is related to prepared queries:
http://momjian.us/main/blogs/pgblog/2016.html#June_15_2016
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-11-28 16:39:47 | Re: BUG #14437: BTREE Index is not used for queries on citext columns |
| Previous Message | pawel.kania | 2016-11-28 07:17:55 | BUG #14437: BTREE Index is not used for queries on citext columns |