[Mono-list] Npgsql

[Elliott Draper]

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: mono-list-bounces at lists.ximian.com
>[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Elliott Draper
>Sent: Monday, June 06, 2005 6:19 AM
>To: carl at carl-olsen.com
>Cc: mono-list at 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: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
>
>
>
>
>  
>