Re: Postgres SIGALRM timer - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres SIGALRM timer
Date
Msg-id 44419.1434742374@sss.pgh.pa.us
Whole thread Raw
In response to Postgres SIGALRM timer  (Scottix <scottix@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux
Next
From: Julien Rouhaud
Date:
Subject: Re: Is there any way to measure disk activity for each query?