[Mono-list] Npgsql

[Carl Olsen]

Okay, I've increased the number of connections from 100 to 500 and increased
some of the values in the memory section of the postgresql.conf file.  I
really have no idea what I'm doing, so if you can suggest some values that
make sense, please feel free.  The site I'm hosting (www.carl-olsen.com) is
just a small, experimental set of pages, so it's beyond my comprehension how
100 connections would not be enough to run my application.  If I was running
a large application, would it even be possible using SUSE 9.2 Pro and
PostgreSQL 7 on the same machine?  The machine is a Sempron 2400 with 1 GB
of RAM and it's only a few months old.

-----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