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:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 4:05 AM To: [EMAIL PROTECTED] Cc: mono-list@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 <[EMAIL PROTECTED]> 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@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Martin Hinks http://www.m-s-d.net _______________________________________________ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
