worker took too long to start; cancelled

Поиск
Список
Период
Сортировка
От Robert Fitzpatrick
Тема worker took too long to start; cancelled
Дата
Msg-id 1225905521.16529.168.camel@columbus.webtent.org
обсуждение исходный текст
Ответы Re: worker took too long to start; cancelled  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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


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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: gin creation and previous history of server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))