Re: database crash during pgbench run - Mailing list pgsql-performance

From Tom Lane
Subject Re: database crash during pgbench run
Date
Msg-id 10578.1544544074@sss.pgh.pa.us
Whole thread Raw
In response to database crash during pgbench run  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: database crash during pgbench run
List pgsql-performance
Greg Clough <Greg.Clough@ihsmarkit.com> writes:
>>> 2018-12-10 19:11:56 IST  23647  LOG:  received fast shutdown request
>>> any idea what can cause it ?

>> Something sent SIGINT to the postmaster.

> My money is on the OoM (Out of Memory) killer.

That usually uses SIGKILL.  If I had to guess, I'd wonder whether the
postmaster was manually started, and if so whether it was properly
dissociated from the user's terminal (with nohup or the like).
If it wasn't, then a control-C typed at the terminal would SIGINT the
postmaster as well as whatever it was meant to terminate.

            regards, tom lane


pgsql-performance by date:

Previous
From: Greg Clough
Date:
Subject: RE: database crash during pgbench run
Next
From: Justin Pryzby
Date:
Subject: Re: Database size 1T but unclear why