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
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? |