Commit hits time-out before CommandTimeout

From: Ben Schalley <ben(dot)schalley(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Commit hits time-out before CommandTimeout
Date: 2012-03-15 20:49:13
Message-ID: CABM10LpHa7JkHnZ7u1KTa8s_M0cwmXMzEhbt5K_4dGujj73ndw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm not sure if it is a Npgsql or a PostgreSQL issue which we run into at
the office. I have also posted this on the Npgsql forum (see
http://pgfoundry.org/forum/forum.php?thread_id=11381&forum_id=519).

For a project we have a windows service which synchronizes an online
database from a supplier with a local database of a client. The queries
against the local database are executed within a transaction block. At the
end of the sync procedure we execute a commit on the transaction. This
commit can take a few minutes to finish so we set the CommandTimeout high
enough, and this works.

However for one client we have set the CommandTimout to 3600 seconds (1
hour) but the commit hits a timeout each time after 1410 seconds (23
minutes and 30 seconds).

What can be causing this "premature" timeout?

The version of PostgreSQL used is 8.2.9 and the version of Npgsql is 2.0.11

Thanx in advance for the help!

Ben

Browse pgsql-general by date

  From Date Subject
Next Message Ivan 2012-03-15 20:58:44 Re: undo update
Previous Message Alexander.Bagerman 2012-03-15 20:27:45 Indexing MS/Open Office and PDF documents