Svar: Re: [Mono-list] Npgsql

[Morten Schmidt]

This was some time ago, and the code has been updated several times
since.. So no code snippets this time. But I can tell you the sql was
less then 0.5 seconds in executing from pgAdmin3! Disabeling log4net
helped... 
 
/morten

>>>Elliott Draper <el at eldiablo.co.uk> 06/06/05 1:18 pm >>>
Well that sounds like the SQL call you are making is taking an
exceedingly long time. Have you tried running the same call using psql
from the command line, or from within the PgAdmin3 GUI to see how long
the SQL actually takes to execute? You can increase the timeout on your
connection object within your code, but that's really just avoiding the
problem. What exactly is your code doing? Can you post a snippet of both
the SQL you are using, and the code that creates the connection object
and executes your SQL? I might be able to shed a bit more light on the
issue then.

Regards,
-= El =-

Carl Olsen wrote:

>I've increased the connections from 100 to 500 and increased some of
the
>settings in the memory section of the postgresql.conf file.  Now I'm
>constantly getting this error:
>
>Server error in '/' application
>
>----------------------------------------------------------------------------
>----
>
>The request timed out.
>Description: Error processing request.
>Error Message: HTTP 500. The request timed out.
>
>
>----------------------------------------------------------------------------
>----
>
>Any ideas?
>
>Carl
>http://www.carl-olsen.com/
>
>-----Original Message-----
>From: Elliott Draper [mailto:el at eldiablo.co.uk]
>Sent: Thursday, June 02, 2005 8:13 PM
>To: carl at carl-olsen.com
>Cc: mono-list at lists.ximian.com; mono-list at lists.ximian.com
>Subject: Re: [Mono-list] Npgsql
>
>The error that you're getting is coming straight back from the PgSQL
>database. You need to free up some connections, and probably increase
the
>maximum number of connections at the server end to stop it happening
again.
>You could also use connection pooling in your app to try and limit the
>amount of connections to the PgSQL database. However this error is
simply
>PgSQL saying its hit its client limit.
>
>Regards,
>-= El =-
>
>-----Original Message-----
>From: Carl Olsen <carl at carl-olsen.com>
>To: <mono-list at lists.ximian.com>
>Date: Thu, 2 Jun 2005 18:21:58 -0500
>Subject: [Mono-list] Npgsql
>
>Server error in '/' application
>
>I keep getting this error until I refresh the page a few times.  Does
anyone
>know what could be causing it?
>
>Carl Olsen
>http://www.carl-olsen.com/Legislators/Senators.aspx
>
>
>----------------------------------------------------------------------------
>----
>
>Description: Error processing request.
>Error Message: HTTP 500.
>
>Stack Trace: Npgsql.NpgsqlException:
>sorry, too many clients already
>Severity: FATAL
>Code: 53300
>in <0x00056> Npgsql.NpgsqlConnector:CheckErrors ()
>in <0x001e1> Npgsql.NpgsqlConnector:Open ()
>in <0x00349> Npgsql.NpgsqlConnectorPool:GetPooledConnector
>(Npgsql.NpgsqlConnection Connection)
>in <0x00028> Npgsql.NpgsqlConnectorPool:RequestPooledConnectorInternal
>(Npgsql.NpgsqlConnection Connection)
>in <0x0005c> Npgsql.NpgsqlConnectorPool:RequestPooledConnector
>(Npgsql.NpgsqlConnection Connection)
>in <0x00023> Npgsql.NpgsqlConnectorPool:RequestConnector
>(Npgsql.NpgsqlConnection Connection)
>in <0x00071> Npgsql.NpgsqlConnection:Open ()
>in (wrapper remoting-invoke-with-check) Npgsql.NpgsqlConnection:Open ()
>in <0x000d0> CarlsWebs.CarlOlsen.Web.Legislators.Senators:Page_Load
>(System.Object sender, System.EventArgs e)
>in (wrapper delegate-invoke)
>System.MulticastDelegate:invoke_void_object_EventArgs
>(object,System.EventArgs)
>in <0x00056> System.Web.UI.Control:OnLoad (System.EventArgs e)
>in <0x00026> System.Web.UI.Control:LoadRecursive ()
>in <0x00149> System.Web.UI.Page:InternalProcessRequest ()
>in <0x000a9> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext
>context)
>in <0x00233> System.Web.HttpApplication+ExecuteHandlerState:Execute ()
>in <0x0007c> System.Web.HttpApplication+StateMachine:ExecuteState
>(IStateHandler state, System.Boolean readysync)
>
>
>
>
>----------------------------------------------------------------------------
>----
>
>
>
>Mono-list maillist  -  Mono-list at lists.ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
>
>
>
> 
>


Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://galactus.ximian.com/pipermail/mono-list/attachments/20050607/6223c071/attachment.html