Re: [GENERAL] Postgres SIGALRM timer

2015-06-19 Thread Tom Lane
Scottix  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


[GENERAL] Postgres SIGALRM timer

2015-06-19 Thread Scottix
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.