Thread: Postgres SIGALRM timer

Postgres SIGALRM timer

From
Scottix
Date:
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.

Re: Postgres SIGALRM timer

From
Tom Lane
Date:
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