Well once you've got that sorted, if you need any more help with PgSQL,
or anything else, post some information on the problem you are having
here and I will take another look for you. Especially where SQL is
concerned, if the error is being a bit on the vague side, then include
your SQL statements, and code to create the connection/execute the
statements, as this will greatly help anyone looking at it to get a
grasp on what's going on.
Regards,
-= El =-
Carl Olsen wrote:
Actually, I tried a remote connection using putty and it timed out. That
gave me a clue that it's Apache or Linux and not necessary the Npgsql.dll
file giving me a problem. I've started to add several assemblies to the web
site and referenced them from the global.aspx.cs file, which means it can't
find some of the pieces. That could easily be the problem. I rebooted the
server and now the entire web site is broken. I'll have to finish what I'm
doing and then check it again.
Thank you!
Carl
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Elliott Draper
Sent: Monday, June 06, 2005 6:19 AM
To: [EMAIL PROTECTED]
Cc: mono-list@lists.ximian.com
Subject: Re: [Mono-list] Npgsql
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:[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
_______________________________________________
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
