From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | 1726002692(at)qq(dot)com |
Subject: | BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca |
Date: | 2021-10-14 09:11:28 |
Message-ID: | 17230-6a952347967d4dba@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17230
Logged by: 强 魏
Email address: 1726002692(at)qq(dot)com
PostgreSQL version: 14.0
Operating system: CentOS Linux release 7.6.1810 (Core)
Description:
progress: 138.0 s, 8286.2 tps, lat 15.298 ms stddev 7.433
progress: 140.0 s, 7855.4 tps, lat 16.129 ms stddev 9.201
progress: 142.0 s, 7492.5 tps, lat 16.957 ms stddev 9.997
progress: 144.0 s, 8296.6 tps, lat 15.266 ms stddev 7.544
progress: 146.0 s, 8196.0 tps, lat 15.449 ms stddev 7.577
progress: 148.0 s, 8149.4 tps, lat 15.563 ms stddev 7.607
progress: 150.0 s, 8112.8 tps, lat 15.616 ms stddev 7.702
progress: 152.0 s, 8158.8 tps, lat 15.549 ms stddev 7.538
progress: 154.0 s, 8097.6 tps, lat 15.616 ms stddev 7.823
progress: 156.0 s, 6926.9 tps, lat 18.358 ms stddev 11.232
progress: 158.0 s, 8221.3 tps, lat 15.424 ms stddev 7.358
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 66 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 73 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 77 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 78 aborted in command 8 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 84 aborted in command 5 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 85 aborted in command 8 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 86 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 91 aborted in command 5 (SQL) of script 0; SQL
command send failed
pgbench: error: client 92 script 0 aborted in command 5 query 0: PANIC:
corrupted line pointer: 351
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 94 aborted in command 5 (SQL) of script 0; SQL
command send failed
pgbench: error: client 67 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 68 aborted in command 4 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 70 aborted in command 4 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 71 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 72 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 74 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 79 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 80 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 88 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 89 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 90 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 93 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 64 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 65 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 69 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 75 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 81 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 87 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 95 aborted in command 4 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 96 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 97 aborted in command 10 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 100 aborted in command 7 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 101 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 102 aborted in command 8 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 105 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 106 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 2 aborted in command 6 (SQL) of script 0; SQL command
send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 6 aborted in command 7 (SQL) of script 0; SQL command
send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 10 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 11 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 13 aborted in command 7 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 14 aborted in command 8 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 17 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 109 aborted in command 7 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 22 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 111 aborted in command 10 (SQL) of script 0; SQL
command send failed
pgbench: error: WARNING: terminating connection because of crash of another
server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 23 aborted in command 10 (SQL) of script 0; SQL command send failed
pgbench: error: client 112 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 24 aborted in command 8 (SQL) of script 0; SQL
command send failed
pgbench: error: client 113 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 114 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 116 aborted in command 5 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 117 aborted in command 8 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench:WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
error: WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 118 aborted in command 6 (SQL) of script 0; SQL command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 1 aborted in command 8 (SQL) of script 0; perhaps the
backend died while processing
pgbench: error: client 120 aborted in command 7 (SQL) of script 0; SQL
command send failed
pgbench: error: client 4 aborted in command 10 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: pgbench: error: client 121 aborted in command 6 (SQL) of
script 0; SQL command send failed
client 5 aborted in command 8 (SQL) of script 0; perhaps the backend died
while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 7 aborted in command 9 (SQL) of script 0; perhaps the
backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: pgbench:WARNING: terminating connection because of crash of
another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 76 aborted in command 9 (SQL) of script 0; perhaps the backend died
while processing
pgbench:pgbench: error: client 83 aborted in command 8 (SQL) of script 0;
perhaps the backend died while processing
error: client 32 aborted in command 9 (SQL) of script 0; SQL command send
failed
error: pgbench:WARNING: terminating connection because of crash of another
server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 122 aborted in command 9 (SQL) of script 0; SQL command send failed
pgbench: error: client 34 aborted in command 7 (SQL) of script 0; SQL
command send failed
error: WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 8 aborted in command 7 (SQL) of script 0; perhaps the backend died
while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench:pgbench: error: client 9 aborted in command 10 (SQL) of script 0;
perhaps the backend died while processing
error: client 124 aborted in command 7 (SQL) of script 0; SQL command send
failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench:pgbench: error: client 125 aborted in command 6 (SQL) of script 0;
SQL command send failed
error: client 12 aborted in command 10 (SQL) of script 0; perhaps the
backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench:WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 127 aborted in command 5 (SQL) of script 0; SQL
command send failed
error: pgbench:WARNING: terminating connection because of crash of another
server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
error: client 110 aborted in command 4 (SQL) of script 0; SQL command send
failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 115 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 15 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 82 aborted in command 9 (SQL) of script 0; perhaps
the backend died while processing
client 126 aborted in command 4 (SQL) of script 0; SQL command send failed
pgbench:WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 16 aborted in command 10 (SQL) of script 0; perhaps
the backend died while processing
error: pgbench: error: client 18 aborted in command 10 (SQL) of script 0;
perhaps the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 19 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
client 99 aborted in command 6 (SQL) of script 0; perhaps the backend died
while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 104 aborted in command 7 (SQL) of script 0; perhaps
the backend died while processing
pgbench:pgbench: error: client 107 aborted in command 8 (SQL) of script 0;
perhaps the backend died while processing
error: client 43 aborted in command 7 (SQL) of script 0; SQL command send
failed
pgbench: error: client 108 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
error: client 20 aborted in command 10 (SQL) of script 0; perhaps the
backend died while processing
pgbench:pgbench: error: client 21 aborted in command 8 (SQL) of script 0;
perhaps the backend died while processing
error: WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 45 aborted in command 6 (SQL) of script 0; SQL command send failed
pgbench: error: client 98 aborted in command 5 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 103 aborted in command 6 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 119 aborted in command 4 (SQL) of script 0; perhaps
the backend died while processing
pgbench: pgbench: pgbench: error: error: error: client 123 aborted in
command 5 (SQL) of script 0; perhaps the backend died while processing
client 46 aborted in command 6 (SQL) of script 0; SQL command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
client 25 aborted in command 10 (SQL) of script 0; perhaps the backend died
while processing
pgbench: error: client 50 aborted in command 8 (SQL) of script 0; SQL
command send failed
pgbench:WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
error: client 26 aborted in command 9 (SQL) of script 0; perhaps the
backend died while processing
pgbench:pgbench: error: client 52 aborted in command 6 (SQL) of script 0;
SQL command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
error: client 27 aborted in command 10 (SQL) of script 0; perhaps the
backend died while processing
pgbench: error: client 55 aborted in command 9 (SQL) of script 0; SQL
command send failed
pgbench: error: client 29 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 30 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 31 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: pgbench:client 57 aborted in command 7 (SQL) of script 0;
SQL command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 58 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 59 aborted in command 6 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 60 aborted in command 9 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 61 aborted in command 8 (SQL) of script 0; SQL
command send failed
error: client 0 aborted in command 10 (SQL) of script 0; perhaps the backend
died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 62 aborted in command 9 (SQL) of script 0; SQL
command send failed
pgbench: error: client 3 aborted in command 10 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 28 aborted in command 6 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 63 aborted in command 8 (SQL) of script 0; SQL
command send failed
pgbench: error: client 33 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 35 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 36 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 37 aborted in command 4 (SQL) of script 0; SQL
command send failed
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 39 aborted in command 4 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 44 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 47 aborted in command 4 (SQL) of script 0; SQL
command send failed
pgbench: error: client 38 aborted in command 10 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 40 aborted in command 7 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 41 aborted in command 9 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 42 aborted in command 6 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 48 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 49 aborted in command 4 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 51 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
pgbench: error: client 54 aborted in command 7 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 56 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
pgbench: error: client 53 aborted in command 8 (SQL) of script 0; perhaps
the backend died while processing
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 100
query mode: simple
number of clients: 128
number of threads: 4
duration: 1800 s
number of transactions actually processed: 1242856
latency average = 16.167 ms
latency stddev = 8.419 ms
initial connection time = 231.339 ms
tps = 7840.892867 (without initial connection time)
pgbench: fatal: Run was aborted; the above results are incomplete.
From | Date | Subject | |
---|---|---|---|
Next Message | 两个孩子的爹 | 2021-10-14 09:14:15 | 回复:BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca |
Previous Message | Michael Paquier | 2021-10-14 07:53:24 | Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES |