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@gremli n.it>
gremlin.it
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly
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@gremli n.it>
gremlin.it
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly