Re: BUG #13990: Postgres shutting down automatically - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #13990: Postgres shutting down automatically
Date
Msg-id CAB7nPqQ64X8oGhCPBRLJ6Yn3p7NC3xgFP5LLxxQLABTrgX__AA@mail.gmail.com
Whole thread Raw
In response to BUG #13990: Postgres shutting down automatically  (syspegasus@gmail.com)
List pgsql-bugs
On Thu, Feb 25, 2016 at 9:10 PM,  <syspegasus@gmail.com> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13990
> Logged by:          Talita
> Email address:      syspegasus@gmail.com
> PostgreSQL version: 9.4.5
> Operating system:   Windows 7
> Description:
>
> Hi, I'm having problem with the postgres service.. randomly stop to
> working.. And to work again I have to wait a time, or restart the
> computer(and sometimes don't work too).. I'm using Windows 7.
>
> In the log appears:
> 2016-02-25 08:54:52 BRT WARNING:  worker took too long to start; canceled
>
> I tried to unistall and install again, but the problem persist. I don't know
> more what to do..

There is no bug here, the error message you are seeing is a sign that
this node is CPU-starved and slow to start up an autovacuum process:
this prevents a worker to start should another one be in starting
state or failed to start.
--
Michael

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13988: "plan should not reference subplan's variable" whilst using row level security
Next
From: Michael Paquier
Date:
Subject: Re: BUG #13977: Strange behavior with WAL archive recovery