From: | Robert Fitzpatrick <lists(at)webtent(dot)net> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | worker took too long to start; cancelled |
Date: | 2008-11-05 17:18:41 |
Message-ID: | 1225905521.16529.168.camel@columbus.webtent.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a FreeBSD server with Postfix that filters mail using
amavisd-maia+SA+ClamAV. It crashed when we received an SMTP attack that
traced back to a compromised user login and a flood a messages were sent
to this smarthost. After getting it back up, I find this in the logs...
Nov 4 08:09:50 esmtp postgres[769]: [6-1] WARNING: worker took too
long to start; cancelled
I have this every minute prior to the crash about 5 or 6 times. However,
this server is not accessing a local database. All filtering is using a
production db server over our private network. This server was just
brought online with 6GB of memory using the PAE kernel option for
FreeBSD. I copied over a working pgsql configuration on our existing
production db server and some boot settings and wondering if memory or
memory settings may be the issue?
esmtp# cat /boot/loader.conf
#console="comconsole"
kern.ipc.semmni=32
kern.ipc.semmns=512
esmtp# cat /etc/sysctl.conf
# $FreeBSD: src/etc/sysctl.conf,v 1.8 2003/03/13 18:43:50 mux Exp $
#
#security.bsd.see_other_uids=0
# tuning for PostgreSQL
kern.ipc.shm_use_phys=1
kern.ipc.shmmax=1073741824
kern.ipc.shmall=262144
kern.ipc.semmsl=512
kern.ipc.semmap=256
Also, from postgresql.conf, here are my custom settings...
max_connections = 250
shared_buffers = 512MB
work_mem = 128MB
maintenance_work_mem = 256MB
max_fsm_pages = 179200
max_fsm_pages = 512000
wal_buffers = 256kB
checkpoint_segments = 100
effective_cache_size = 1028MB
Again, I'm wondering why the local postgresql was even involved since
the mail system does not use the localhost pg server for filtering.
Unless the error is related to the production db server it is hitting. I
did not find any errors isolated to this time period, but I do see the
following throughout those logs...
ERROR: deadlock detected
As I mentioned, this server and the production db server both filter
using Maia Mailguard which is the only use of of pgsql on those servers.
--
Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-11-05 17:44:08 | Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...)) |
Previous Message | Ivan Sergio Borgonovo | 2008-11-05 17:17:12 | Re: gin creation and previous history of server |