BUG #8079: pg_ctl is killed by windows service controller due to "Timed out waiting for server startup" event

Поиск
Список
Период
Сортировка
От krzbia@interia.pl
Тема BUG #8079: pg_ctl is killed by windows service controller due to "Timed out waiting for server startup" event
Дата
Msg-id E1USOeY-00024n-1Y@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8079
Logged by:          Christopher Bialas
Email address:      krzbia@interia.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=3D"http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name=3D"PostgreSQL" /> =

  <EventID Qualifiers=3D"0">0</EventID> =

  <Level>4</Level> =

  <Task>0</Task> =

  <Keywords>0x80000000000000</Keywords> =

  <TimeCreated SystemTime=3D"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=3D"http://schemas.microsoft.com/win/2004/08/events/event">
  - <System>
    <Provider Name=3D"PostgreSQL" /> =

    <EventID Qualifiers=3D"0">0</EventID> =

    <Level>2</Level> =

    <Task>0</Task> =

    <Keywords>0x80000000000000</Keywords> =

    <TimeCreated SystemTime=3D"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>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Erika31
Дата:
Сообщение: Re: wrong search_path being used
Следующее
От: victor@maintstar.com
Дата:
Сообщение: BUG #8080: 32-bit ODBC Driver Needs timestamp MetaData Type