Search Postgresql Archives

Re: Postgresql service stopped automatically after restart

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

 



On 06/03/2014 10:58 PM, Kalai R wrote:
Hi,

Yesterday the psql service  stopped in our two customers's machines

See comments inline below.


Windows OS  ---> Windows XP
We re-installed the postgresql to solve the problem.

Except from what you have indicated it does not solve the problem, just pushes it into the future again.

We use postgresql *silent* installation method to install psql from Our
application

You still have not indicated what exactly happens during your install process. It would be nice to know to get a handle on the initial setup.




Psql Log  for one machine

2014-06-01 18:29:48 IST LOG:  database system was interrupted; last
known up at 2014-06-01 18:23:19 IST

The log information before this would be helpful to possibly help determine what caused the interruption.

2014-06-01 18:29:49 IST LOG:  database system was not properly shut
down; automatic recovery in progress
2014-06-01 18:29:49 IST LOG:  record with zero length at 0/5C44778
2014-06-01 18:29:49 IST LOG:  redo is not required
2014-06-01 18:29:50 IST LOG:  database system is ready to accept connections
2014-06-01 18:29:50 IST LOG:  autovacuum launcher started
2014-06-01 18:33:21 IST ERROR:  canceling statement due to user request
2014-06-01 18:33:21 IST ERROR:  canceling statement due to user request
2014-06-01 18:33:21 IST LOG:  received fast shutdown request

So who or what initiated the fast shutdown?

2014-06-01 18:33:21 IST LOG:  aborting any active transactions
2014-06-01 18:33:21 IST ERROR:  canceling statement due to user request
2014-06-01 18:33:21 IST ERROR:  canceling statement due to user request
2014-06-01 18:33:21 IST LOG:  autovacuum launcher shutting down
2014-06-01 18:33:21 IST LOG:  shutting down
2014-06-01 18:33:22 IST LOG:  database system is shut down





psql log for another one machine


2014-06-02 09:50:52 IST FATAL:  the database system is starting up
2014-06-02 09:50:52 IST LOG:  database system was shut down at
2014-06-01 17:04:03 IST
2014-06-02 09:50:53 IST FATAL:  the database system is starting up
2014-06-02 09:50:53 IST FATAL:  the database system is starting up
2014-06-02 09:50:53 IST LOG:  database system is ready to accept connections
2014-06-02 09:50:53 IST LOG:  autovacuum launcher started
2014-06-02 10:22:56 IST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.

This looks a firewall issue to me.

Do you know what client it is complaining about?

You might want to add information to the log entries to help with debugging this.

See below for the options available:

http://www.postgresql.org/docs/9.3/interactive/runtime-config-logging.html

log_line_prefix (string)




2014-06-02 16:32:54 IST LOG:  could not reserve shared memory region
(addr=029D0000) for child 000004D8: error code 1455
2014-06-02 16:32:54 IST LOG:  could not fork autovacuum worker process:
A blocking operation was interrupted by a call to WSACancelBlockingCall.


I have seen this before, it is coming from Windows Sockets. The last this was brought up there was no resolution.

Here is the previous thread, I would take a look at it to see if anything looks similar. Also in the thread are links to previous reports that might be worth looking at:

http://www.postgresql.org/message-id/2C0926ABD16BB641A8E2F11A5492004254713952D6@xxxxxxxxxxxxxxxxxxxxxxxxxx

2014-06-02 16:33:09 IST LOG:  server process (PID 5844) was terminated
by exception 0xC000012D
2014-06-02 16:33:09 IST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.

Well according to here:

http://msdn.microsoft.com/en-us/library/cc704588.aspx

This means:

{Out of Virtual Memory} Your system is low on virtual memory. To ensure that Windows runs correctly, increase the size of your virtual memory paging file. For more information, see Help.


2014-06-02 16:33:14 IST FATAL:  could not create shared memory segment:
error code 1455
2014-06-02 16:33:14 IST DETAIL:  Failed system call was
CreateFileMapping(size=145850368, name=Global/PostgreSQL:C:/Program
Files/PostgreSQL/9.3/data).

Not sure about this one.



Thanks in Advance

--
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