message type 0x50

From: Alessandro GARDICH <gremlin(at)gremlin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: message type 0x50
Date: 2003-09-10 15:18:27
Message-ID: 1063207106.1258.31.camel@motoko.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi to all

i received "message type 0x50 arrived from server while idle" ...

RedHat Linux 9, postgres 7.3.4

the program is quite simple, a loop do UPDATE on a random entry on a
table. Server is without autocommit.

with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,
update loop have a random delay from 0 to 500 msec using usleep().

I have problems using SIGALRM and libpq (libpqxx exactly), does libpq
use select or other signal ???

trying to substiture usleep with a null for loop i obtain the massage
"type 0x50..."

some suggestion ???

P.S. on the table there is a trigger that execute an NOTIFY every
update, but only one is received also if many updates happen between
commits ... why ???

--
Alessandro GARDICH <gremlin(at)gremlin(dot)it>
gremlin.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2003-09-10 15:35:03 Re: why does count take so long?
Previous Message Jean-Luc Lachance 2003-09-10 15:16:59 Re: why does count take so long?