BUG #15697: Restarting the server because of the error checkpointer

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: aleksandr(dot)newray(at)gmail(dot)com
Subject: BUG #15697: Restarting the server because of the error checkpointer
Date: 2019-03-16 07:59:13
Message-ID: 15697-150d75b6fe4fa61f@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: 15697
Logged by: Alex Newray
Email address: aleksandr(dot)newray(at)gmail(dot)com
PostgreSQL version: 11.2
Operating system: Ubuntu 16.04.6 LTS
Description:

I have a website using postgresql on my vps. I get an error restarting
postgresql server:

2019-03-15 05:58:53.305 UTC [1329] LOG: shutting down
2019-03-15 05:58:53.313 UTC [1311] LOG: checkpointer process (PID 1329)
exited with exit code 0
2019-03-15 05:58:53.313 UTC [1311] LOG: terminating any other active server
processes
2019-03-15 05:58:53.314 UTC [6441] retouch(at)retouch_db WARNING: terminating
connection because of crash of another server process
2019-03-15 05:58:53.314 UTC [6441] retouch(at)retouch_db 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.
2019-03-15 05:58:53.314 UTC [6441] retouch(at)retouch_db HINT: In a moment you
should be able to reconnect to the database and repeat your command.
2019-03-15 05:58:53.316 UTC [6440] retouch(at)retouch_db WARNING: terminating
connection because of crash of another server process
2019-03-15 05:58:53.316 UTC [6440] retouch(at)retouch_db 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.
2019-03-15 05:58:53.316 UTC [6440] retouch(at)retouch_db HINT: In a moment you
should be able to reconnect to the database and repeat your command.
2019-03-15 05:58:53.318 UTC [1332] WARNING: terminating connection because
of crash of another server process
2019-03-15 05:58:53.318 UTC [1332] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exi
ted abnormally and possibly corrupted shared memory.
2019-03-15 05:58:53.318 UTC [1332] HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2019-03-15 05:58:53.320 UTC [1311] LOG: all server processes terminated;
reinitializing
2019-03-15 05:58:53.341 UTC [13043] LOG: database system was shut down at
2019-03-15 05:58:53 UTC
2019-03-15 05:58:53.348 UTC [1311] LOG: database system is ready to accept
connections

I do load testing of the site and make a stream of requests directly to the
database and it works well. But for 2 days in a row at a certain time I get
an error restarting the server, and it does not depend on the load on the
server

The server has enough memory to start the server. The charts show that the
memory runs out, and in dmesg there is no record of postgres

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-03-16 14:14:09 Re: BUG #15697: Restarting the server because of the error checkpointer
Previous Message PG Bug reporting form 2019-03-16 03:55:11 BUG #15696: year field of interval type is not rounded to nearest integer