Postgres SIGALRM timer

Started by Scottixalmost 11 years ago2 messagesgeneral
Jump to latest
#1Scottix
scottix@gmail.com

I am running a posgres server with a zabbix server and zabbix agent and I
am getting a bunch errors about SIGALRM, It makes postgres drop connections
randomly.

Ubuntu 14.04.2 LTS
Linux Host 3.19.0-21-generic #21~14.04.1-Ubuntu SMP Sun Jun 14 18:45:42 UTC
2015 x86_64 x86_64 x86_64 GNU/Linux
Postgres 9.4.4

CPU:
model name : Intel(R) Core(TM) i3 CPU 540 @ 3.07GHz

Memory:
4GB

No significant load is on the machine.

2015-06-19 08:45:22 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument
2015-06-19 08:45:53 PDT FATAL: could not enable SIGALRM timer: Invalid
argument

Any help appreciated.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Scottix (#1)
Re: Postgres SIGALRM timer

Scottix <scottix@gmail.com> writes:

I am running a posgres server with a zabbix server and zabbix agent and I
am getting a bunch errors about SIGALRM, It makes postgres drop connections
randomly.
2015-06-19 08:45:22 PDT FATAL: could not enable SIGALRM timer: Invalid
argument

That's really weird. [ looks at code... ] You aren't using a
--disable-integer-timestamps build by any chance, are you?
Even if you were, I don't see how we could be passing a bad
value to setitimer().

I'm a bit inclined to say there's something wrong with your kernel,
since we've not heard similar reports elsewhere.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general