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: F8E84F0F56445B4CB39E019EF67DACBA340A8B@exchsrvr.winemantech.com (view raw or flat)
Thread:
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:
http://npgsql.projects.postgresql.org/docs/manual/UserManual.htm (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

Hello,

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?

Thanks,

-Frances


In response to

Responses

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-2014 The PostgreSQL Global Development Group