Thread: Postgres SIGALRM timer

Postgres SIGALRM timer

From

Scottix

Date:

19 June 2015, 20:34:16

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

Any help appreciated.

Re: Postgres SIGALRM timer

From

Tom Lane

Date:

19 June 2015, 22:33:12

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