PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15727
PG VersionUnsupported/Unknown
OSUbuntu 5.4.0-6ubuntu1~16.04.10
Opened2019-04-02 10:30:15+00
Reported byRoman Zharkov
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15727
Logged by:          Roman Zharkov
Email address:      (redacted)
PostgreSQL version: Unsupported/Unknown
Operating system:   Ubuntu 5.4.0-6ubuntu1~16.04.10
Description:        

Hello,
Our test server crashed while benchmarking connection pooler called Yandex
Odyssey.
There is no debugging info in the code dump now, because it takes few hours
to reproduce the error. We will try to reproduce the error with debugging
info.

Server version - PostgreSQL 12devel-master, commit - bb76134 on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0
20160609, 64-bit

The error does not reproduce on PostgreSQL 12devel-master, commit -
2fadf24

2019-04-01 15:27:38.829 +07 [7524] ERROR:  unexpected table_lock_tuple
status: 1
2019-04-01 15:27:38.829 +07 [7524] STATEMENT:  UPDATE pgbench_accounts SET
abalance = 1 WHERE aid = 1;
2019-04-01 15:27:38.829 +07 [7524] PANIC:  cannot abort transaction
400048276, it was already committed
2019-04-01 15:27:39.001 +07 [7499] ERROR:  unexpected table_lock_tuple
status: 1
2019-04-01 15:27:39.001 +07 [7499] STATEMENT:  UPDATE pgbench_accounts SET
abalance = 1 WHERE aid = 2;
2019-04-01 15:27:39.001 +07 [7499] PANIC:  cannot abort transaction
400051561, it was already committed
2019-04-01 15:27:41.193 +07 [7509] ERROR:  unexpected table_lock_tuple
status: 1
2019-04-01 15:27:41.193 +07 [7509] STATEMENT:  UPDATE pgbench_accounts SET
abalance = 1 WHERE aid = 1;
2019-04-01 15:27:41.193 +07 [7509] PANIC:  cannot abort transaction
400088425, it was already committed
2019-04-01 15:41:01.176 +07 [3559] LOG:  server process (PID 7499) was
terminated by signal 6: Aborted
2019-04-01 15:41:01.176 +07 [3559] DETAIL:  Failed process was running:
UPDATE pgbench_accounts SET abalance = 1 WHERE aid = 2;
2019-04-01 15:41:01.176 +07 [3559] LOG:  terminating any other active server
processes

[New LWP 7509]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `postgres: zharkov test 127.0.0.1(42666) UPDATE       
'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007f1f4c6c7428 in __GI_raise (sig=sig@entry=6) at
../sysdeps/unix/sysv/linux/raise.c:54
54      ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
(gdb) bt
#0  0x00007f1f4c6c7428 in __GI_raise (sig=sig@entry=6) at
../sysdeps/unix/sysv/linux/raise.c:54
#1  0x00007f1f4c6c902a in __GI_abort () at abort.c:89
#2  0x000000000085faac in errfinish ()
#3  0x00000000008633e4 in elog_finish ()
#4  0x000000000050266d in RecordTransactionAbort ()
#5  0x0000000000502788 in AbortTransaction ()
#6  0x0000000000502fb5 in AbortCurrentTransaction ()
#7  0x000000000075029f in PostgresMain ()
#8  0x0000000000480593 in ServerLoop ()
#9  0x00000000006dfc04 in PostmasterMain ()
#10 0x00000000004813b9 in main ()

Messages

DateAuthorSubject
2019-04-02 10:30:15+00PG Bug reporting formBUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 15:29:25+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 15:44:26+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 15:47:20+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 15:51:08+00Alvaro HerreraRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 15:51:38+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 16:00:48+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 16:13:20+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:00:51+00Alvaro HerreraRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:04:15+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:11:52+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:13:58+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:17:14+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:17:21+00Alvaro HerreraRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:30:56+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:35:47+00=?utf-8?B?0JbQsNGA0LrQvtCyINCg0L7QvNCw0L0=?=Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-02 17:35:54+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-03 08:29:21+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-03 08:38:16+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-03 12:20:27+00Alvaro HerreraRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-03 12:59:23+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 16:23:06+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 16:28:46+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 17:09:15+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 17:10:25+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 17:17:05+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 17:27:08+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-06 23:10:37+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-07 20:33:15+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-08 07:21:47+00Amit LangoteRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-08 08:18:48+00Amit LangoteRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-08 16:31:37+00Tom LaneRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-08 16:41:38+00Andres FreundRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-09 04:55:22+00Amit LangoteRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 03:29:03+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 03:47:30+00Michael PaquierRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 04:17:54+00=?utf-8?B?0JbQsNGA0LrQvtCyINCg0L7QvNCw0L0=?=Re: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 04:23:42+00Michael PaquierRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 04:44:37+00Thomas MunroRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 05:35:34+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 08:52:17+00Thomas MunroRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-11 08:55:58+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-12 02:44:04+00r(dot)zharkov(at)postgrespro(dot)ruRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-12 05:04:53+00Thomas MunroRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-12 05:19:05+00Michael PaquierRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed
2019-04-12 05:39:21+00Thomas MunroRe: BUG #15727: PANIC: cannot abort transaction 295144144, it was already committed