Skip site navigation (1) Skip section navigation (2)

Re: Cancelled statement due to lost connection

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: "Frances Collier" <fcollier(at)preparedresponse(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Cancelled statement due to lost connection
Date: 2006-09-29 20:31:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
"Due to user request" suggests to me that the client (in this case, IIS or .NET) is timing out waiting for a response and cancelling the query.

The documentation for Npgsql seems to support that: (search for 'Cancelling a command in progress').

Brandon Aiken
CS/IT Systems Engineer
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Frances Collier
Sent: Friday, September 29, 2006 4:02 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Cancelled statement due to lost connection


I have implemented an ASP.Net page on one box that has successfully connected to my PostgreSQL database on another. Both boxes are running Windows Server 2003. I am using the Npgsql connector. Most of the time it runs fine, but on one query I am getting a "canceling statement due to user request" error (Code: 57014).  I figure the connection is timing out, especially since running it through pgAdmin it takes 29375+31 ms. So, I set the NpgsqlConnection CommandTimeout to 300. But it didn't help. I've run through the PostgreSQL documentation, the postgresql.conf, and pg_hba.conf (for good measure) trying to find where to set the connection time for PostgreSQL. Can this be set? If so, what's the proper configuration for that?



In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2006-09-29 20:58:05
Subject: Re: Postgres locking up?
Previous:From: Frances CollierDate: 2006-09-29 20:02:17
Subject: Cancelled statement due to lost connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group