From: | krzbia(at)interia(dot)pl |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8079: pg_ctl is killed by windows service controller due to "Timed out waiting for server startup" event |
Date: | 2013-04-17 09:27:46 |
Message-ID: | E1USOeY-00024n-1Y@wrigleys.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: 8079
Logged by: Christopher Bialas
Email address: krzbia(at)interia(dot)pl
PostgreSQL version: 9.2.4
Operating system: Microsoft Windows 2008R2 Standard server
Description:
With very high load of the server during startup (e.g. simultaneous logon
to local console) pg_ctl is being killed by windows service controller as it
does not respond on time. I've seen it with process explorer:
1. pg_ctl starts, then
2. postgres processing tasks start
3. pg_ctl is killed leaving postgres workers running.
As a result windows service is totally confused as service is dead, and it
cannot be started again as it finds out that postgres is already running.
The following is the excerpt from windows log:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="PostgreSQL" />
<EventID Qualifiers="0">0</EventID>
<Level>4</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-04-17T09:04:31.000000000Z" />
<EventRecordID>227797</EventRecordID>
<Channel>Application</Channel>
<Computer>mypc</Computer>
<Security />
</System>
- <EventData>
<Data>Waiting for server startup...</Data>
</EventData>
</Event>
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="PostgreSQL" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-04-17T09:04:36.000000000Z" />
<EventRecordID>227801</EventRecordID>
<Channel>Application</Channel>
<Computer>mypc</Computer>
<Security />
</System>
- <EventData>
<Data>Timed out waiting for server startup</Data>
</EventData>
</Event>
From | Date | Subject | |
---|---|---|---|
Next Message | Erika31 | 2013-04-17 11:00:48 | Re: wrong search_path being used |
Previous Message | Sofer, Yuval | 2013-04-17 09:09:55 | general question and BUG #5038 |