| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | n(dot)kalinin(at)postgrespro(dot)ru |
| Subject: | BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()") |
| Date: | 2025-11-27 10:18:06 |
| Message-ID: | 19336-3ff9a25f0dc4ab42@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 19336
Logged by: Nikita Kalinin
Email address: n(dot)kalinin(at)postgrespro(dot)ru
PostgreSQL version: 18.1
Operating system: ubuntu 22.04
Description:
With this parameter in postgresql.conf: debug_parallel_query = on
If you execute the query: SELECT pg_sleep_for('5 minutes');
and then kill the postgres process with signal 9, you get the following in
the log:
2025-11-27 06:44:27.263 UTC [643318] FATAL: postmaster exited during a
parallel transaction
TRAP: failed Assert("!IsTransactionOrTransactionBlock()"), File: "pgstat.c",
Line: 673, PID: 643318
/lib/x86_64-linux-gnu/libasan.so.8(+0x831e0)[0x7058d98831e0]
postgres: test postgres 127.0.0.1(44374)
SELECT(ExceptionalCondition+0x156)[0x616e63da3dcf]
postgres: test postgres 127.0.0.1(44374)
SELECT(pgstat_report_stat+0x43)[0x616e635c9ced]
postgres: test postgres 127.0.0.1(44374) SELECT(+0x51c29fe)[0x616e635c99fe]
postgres: test postgres 127.0.0.1(44374)
SELECT(shmem_exit+0x29f)[0x616e633beca2]
postgres: test postgres 127.0.0.1(44374) SELECT(+0x4fb7750)[0x616e633be750]
Maybe the Assert shouldn't be printed to the log, and only the following
output should remain?
postgres=# SELECT pg_sleep_for('5 minutes');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-11-27 15:55:25 | Re: BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()") |
| Previous Message | PG Bug reporting form | 2025-11-27 08:55:14 | BUG #19335: the function encrypt does not work correct - ERROR: encrypt error: Key was too big |