pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
worker took too long to start; cancelled ( postgres 9.0.3) 2+ messages / 1 participants [nested] [flat]
* worker took too long to start; cancelled ( postgres 9.0.3) @ 2011-05-04 21:55 Dinesh Bhandary <dbhandary@iii.com> 2011-05-05 17:16 ` Re: worker took too long to start; cancelled ( postgres 9.0.3) Dinesh Bhandary <dbhandary@iii.com> 0 siblings, 1 reply; 2+ messages in thread From: Dinesh Bhandary @ 2011-05-04 21:55 UTC (permalink / raw) To: pgsql-admin Hi All - I am getting the following error while starting postgres 9.0.3. And when it happens I could not establish new connections and the following error messages keeps on coming up. Are you guys aware of this problem? Is it a bug? It has happened to me twice already. We are running this on red hat 5.6. "worker took too long to start; cancelled" Thanks. Dinesh ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: worker took too long to start; cancelled ( postgres 9.0.3) 2011-05-04 21:55 worker took too long to start; cancelled ( postgres 9.0.3) Dinesh Bhandary <dbhandary@iii.com> @ 2011-05-05 17:16 ` Dinesh Bhandary <dbhandary@iii.com> 0 siblings, 0 replies; 2+ messages in thread From: Dinesh Bhandary @ 2011-05-05 17:16 UTC (permalink / raw) To: dbhandary@iii.com; +Cc: pgsql-admin Hi All - I am reposting my earlier message. I saw someone had the same problem that I had, but I could not see the resolution. Please let me know if you have more info on this. Here is the thread that talks about the same problem. Hello. >You haven't really provided us with much detail here, but it kind of >sounds like your system is overloaded. >...Robert Thank you for your kindness. Following modules are used mod_auth_pgsql-2.0.3_1 postgresql-client-8.3.9_1,1 postgresql-server-8.3.9_1 p5-DBD-Pg-2.16.0 php5-pdo_pgsql-5.2.12 What kind of information shall, I geve you in addtion to the list above? > Date: Mon, 18 Jan 2010 15:33:02 -0500 > Subject: Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown > From: robertmhaas(at)gmail(dot)com > To: azuneko(at)hotmail(dot)com > CC: pgsql-bugs(at)postgresql(dot)org > > On Mon, Jan 18, 2010 at 12:43 AM, azuneko<azuneko(at)hotmail(dot)com> wrote: > > The following bug has been logged online: > > > > Bug reference: 5284 > > Logged by: azuneko > > Email address: azuneko(at)hotmail(dot)com > > PostgreSQL version: 8.3.3 > > Operating system: FreeBSD7.0.2 > > Description: Postgres CPU 100% and worker took too long to start; > > cancelled... Systemdown > > Details: > > > > Hello, > > > > I have the following 2 problems. > > It would be appreciated if you give me some information such as the way to > > avoid them.(Or if those problems are already known and fixed, could you > > please tell me what version I should apply.) > > > > 1,CPU utilization of postgres reaches 100%. > > > > I excuted "top" command and sometimes found that CPU utilization of postgres > > process reached 100% or almost 100%. (This is similar to the problem that > > was posted at > > http://archives.free.net.ph/message/20081104.074244.6e0dbcde.ja.html.) > > What might be the cause? > > > > 2. The following warning can be seen in the postgres log. > > WARNING: worker took too long to start; cancelled > > > > After this warning firstly appears in the log, the same warining message > > seems to be repeated. And if you leave this state as it is, the OS freezes > > before long. I guess this event happens because the daemons related to > > postgres (such as vacuum and autovacuum) won't release the shared memory and > > exclusively keep using it. Am I correct? > > > > Those 2 problems are confirmed to happen at least under the following > > conditions; > > Software > > -OS : FreeBSD 7.0.2 > > -Postgres version : 8.3.3 > > Hardware > > -Disk configuration : RAID5 (MegaCLI) > > -CPU : Xeon2.4 > > > > Thank you. > > You haven't really provided us with much detail here, but it kind of > sounds like your system is overloaded. > > ...Robert On 5/4/2011 2:55 PM, Dinesh Bhandary wrote: > Hi All - > > I am getting the following error while starting postgres 9.0.3. And > when it happens I could not establish new connections and the > following error messages keeps on coming up. > Are you guys aware of this problem? Is it a bug? It has happened to me > twice already. We are running this on red hat 5.6. > > "worker took too long to start; cancelled" > > Thanks. > > Dinesh > ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-05-05 17:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-05-04 21:55 worker took too long to start; cancelled ( postgres 9.0.3) Dinesh Bhandary <dbhandary@iii.com> 2011-05-05 17:16 ` Dinesh Bhandary <dbhandary@iii.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox