[Mono-list] Npgsql

Mon Jun 6 21:12:13 EDT 2005

Okay, I removed the reference in the Global.asax.cs file to the assemblies
that have not been completed yet, and the web site is back up and
functioning again.  My next step is to convert about 20 to 30 stored
procedures from SQL Server 2000 to PostgreSQL 7.4.  It doesn't really matter
if I get them exact, because I can make up for it in code, but I'd really
like to get them as close as possible.

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 9:49 AM
To: carl at carl-olsen.com
Cc: mono-list at lists.ximian.com
Subject: Re: [Mono-list] Npgsql

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

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