回复:BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca

Поиск
Список
Период
Сортировка
От 两个孩子的爹
Тема 回复:BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca
Дата
Msg-id tencent_1F3B2B0152B80BBD745E6954EE6B50B08406@qq.com
обсуждение исходный текст
Ответ на BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
hi:
This problem occurs during pressure measurement。

Provide core dump file
------------------ 原始邮件 ------------------
发件人: "1726002692" <noreply@postgresql.org>;
发送时间: 2021年10月14日(星期四) 下午5:11
收件人: "pgsql-bugs"<pgsql-bugs@lists.postgresql.org>;
抄送: "两个孩子的爹"<1726002692@qq.com>;
主题: BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca

The following bug has been logged on the website:

Bug reference:      17230
Logged by:          强 魏
Email address:      1726002692@qq.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.

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17230: The postmaster has commanded this server process to roll back the current transaction and exit, beca
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17227: segmentation fault with jsonb_to_recordset