PDA

View Full Version : [Purge Observed hands] TimeOut ...



ZeBoulet
04-17-2010, 02:25 AM
Hello,
See image for error.

When i manually purge hands (even when i filter just past 45 days) i go now in time out.

Did apply performance tips.
Did not find in PGSQL conf file a timeout connexion option ...

What is wired, is that i have no PGSQL activity after a wile ...
Than goes in time out.

Any idear ?

Thx
Regards
ZeBoulet

netsrak
04-17-2010, 07:51 AM
I have the same problem (similar configuration with Linux postgresql).

Only workaround is to purge in smaller portions (day by day).

I already mailed this problem to the developers but at the moment they have no idea how to fix this.

ZeBoulet
04-18-2010, 04:48 AM
Posted a thread at Forums PostgreSQL.fr (http://forums.postgresql.fr)
We will see if there have any idear.

ZeBoulet
04-18-2010, 05:06 AM
Hi,
U use Npgsql ... ?... ?
OK

Seems we must increase the time out value of Npgsql
When HM sens a request, Npgsql fails on time out ...

Will this help ?

ZeBoulet

netsrak
04-18-2010, 05:31 AM
I'll ask Roy...