[Mono-list] Time out using Npgsql

[Carl Olsen]

I can't figure out where it is failing, because it just times out.  It's
happening on all of my page now, since I have a session hit counter in the
global.asax.cs file that writes to PostgreSQL every time someone visits the
site.  Before I added the hit counter, it was only occurring on the page
that had data connections to PostgreSQL.  It only happens occasionally, not
all the time.  Restarting Apache fixes it.  I'm not sure if the problem is
Npgsql or Apache, or both.

-----Original Message-----
From: Martin Hinks [mailto:mhinks at gmail.com] 
Sent: Thursday, June 30, 2005 4:05 AM
To: carl at carl-olsen.com
Cc: mono-list at lists.ximian.com
Subject: Re: [Mono-list] Time out using Npgsql

First of all, can you take the SQL statement out of the stored
procedure and just run it as a command from the ASP.NET page?

If you can't then can you use a different client to run the query on
the database?

Does it happen when you try to run ANY stored proc or just this one in
particular?

If all else fails locate the exact line that is failing and post a
code sample illustrating the problem.

On 6/27/05, Carl Olsen <carl at carl-olsen.com> wrote:
> I'm getting a time out error again.  The page is calling a simple stored
> procedure that returns a set of names from a PostgreSQL database.  Any
ideas
> on how to trouble shoot?
> 
> Carl
> http://www.carl-olsen.com/
> 
> Server error in '/' application
> 
>
----------------------------------------------------------------------------
> ----
> 
> The request timed out.
> Description: Error processing request.
> Error Message: HTTP 500. The request timed out.
> 
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 


-- 
Martin Hinks
http://www.m-s-d.net