Re: Postgres SIGALRM timer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scottix <scottix(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres SIGALRM timer
Date: 2015-06-19 19:32:54
Message-ID: 44419.1434742374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scottix <scottix(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paula Price 2015-06-19 20:05:41 Re: Postgresql 9.2 has standby server lost data?
Previous Message Tom Lane 2015-06-19 18:42:00 Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux