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:[EMAIL PROTECTED] Sent: Thursday, June 02, 2005 8:13 PM To: [EMAIL PROTECTED] Cc: mono-list@lists.ximian.com; mono-list@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" <[EMAIL PROTECTED]> To: <mono-list@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@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list