Обсуждение: Postgres SIGALRM timer
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.
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