DBD::PG and long running queries and tcp stack timeout
Hi,
I have a script that runs a query on a remote server. The query will
take quite some time to finish.
Now the problem is that the tcp stack will timeout before the query is finished.
I am running the query as async and have a loop where I query the
pg_ready status every 5 seconds.
Is there anyway to send some NOOP or anything so this connection does
not timeout? Just reading pg_ready seems to do nothing, probably
because it gets filled once the query is done.
Running the query as not async has the same issues with timeout.
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp
On 06/01/11 11:35 PM, Clemens Schwaighofer wrote:
Hi,
I have a script that runs a query on a remote server. The query will
take quite some time to finish.
Now the problem is that the tcp stack will timeout before the query is finished.
is there a NAT firewall or something else in the middle thats doing
connection tracking? tcp shouldn't time out like that even if your
query is taking multiple hours.
--
john r pierce N 37, W 123
santa cruz ca mid-left coast
yeah there is a NAT firewall inbetween. I can check there too.
But interesting thing is, if I set the tcp_keepalive_time higher it
won't time out. But still ... a bit strange.
2011/6/2 John R Pierce <pierce@hogranch.com>:
On 06/01/11 11:35 PM, Clemens Schwaighofer wrote:
Hi,
I have a script that runs a query on a remote server. The query will
take quite some time to finish.
Now the problem is that the tcp stack will timeout before the query is
finished.is there a NAT firewall or something else in the middle thats doing
connection tracking? tcp shouldn't time out like that even if your query
is taking multiple hours.--
john r pierce N 37, W 123
santa cruz ca mid-left coast--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp