| 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: | Whole Thread | Raw Message | 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? |