[google-cloud-sql-discuss] Re: PostgreSQL: checkpointer process was terminated by signal 9: killed

Hi,

The logs do not provide much information about the cause of the issue. More details may be needed in order to further investigate. That being said, similar issues are often caused by OOM. Have you checked the memory usage and other resource consumption for any abnormality before the instance went down?

On Friday, May 7, 2021 at 12:58:11 PM UTC-4 konrad...@gmail.com wrote:

Hello,

in the last couple weeks my Postgres instance went down a few times. I found the following messages in the logs, but can't put my finger on what the root cause may be.

Is this some known issue? What else can I do to troubleshoot?

[16-1] db=,user= LOG: checkpointer process (PID 645146) was terminated by signal 9: Killed

[17-1] db=,user= LOG: terminating any other active server processes

[2-1] db=,user= WARNING: terminating connection because of crash of another server process

[3-1] db=,user= 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.

[4-1] db=,user= HINT: In a moment you should be able to reconnect to the database and repeat your command.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/25c1ed11-f8d4-4e12-94fc-9a0d81a75dd8n%40googlegroups.com.