Search Postgresql Archives

Re: Database system was interrupted. Possible reasons for a database to suddenly stop accepting connections?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/9/20 5:53 AM, Buzenets, Yuriy (GE Renewable Energy, consultant) wrote:
Some time ago the database at my work suddenly stopped accepting connections. In the logs there was a message “the database system was interrupted; last known up at 2020-10-29 12:03:16 PDT”, followed by a lot of “the database system is starting up” messages. It seems like the database tried to recover from whatever failure occurred but recovery was not successful until the database process was shut down and restarted. The latest error message before “system was interrupted” occurs 13 minutes before so it’s not clear to us what could cause this issue and why the database process had to be restarted. If anyone could help us understand what might’ve been the cause, we would greatly appreciate it. We’re using PostgreSQL 9.4 on CentOS 6.8, we know it reached EOL and plan to upgrade to a newer version soon. I’ve also attached the log file from the time the database system was unavailable if it helps to figure out the cause of the outage

There are a lot of 'terminating connection due to administrator command' lines. How many connections where/are being used to this server?


Thanks,

Yuriy Buzenets



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux