[Mono-list] Time out using Npgsql

[Carl Olsen]

The web server and PostgreSQL are both on the same box.  Before I added the
hit counter, I could always get to the home page and the timeout only
occurred (about once or twice a week) on the page that connects to
PostgreSQL.  So, that eliminates the possibility of any network problem.  I
never have a problem with pgadmin, which is also running on the same box and
also runs across the network (to my work computer several miles from here),
it's always up and running (which eliminates any problem with PostgreSQL,
network, and PHP connections to PostgreSQL).

-----Original Message-----
From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Francisco
Figueiredo Jr.
Sent: Thursday, June 30, 2005 3:09 PM
To: mono-list at lists.ximian.com
Subject: RE: [Mono-list] Time out using Npgsql


--- Carl Olsen <carl at carl-olsen.com> escreveu:

> I can't figure out where it is failing, because it just times out.  It's
> happening on all of my page now, since I have a session hit counter in the
> global.asax.cs file that writes to PostgreSQL every time someone visits
the
> site.  Before I added the hit counter, it was only occurring on the page
> that had data connections to PostgreSQL.  It only happens occasionally,
not
> all the time.  Restarting Apache fixes it.  I'm not sure if the problem is
> Npgsql or Apache, or both.
> 


Hi Carl.

Can you check if your webserver box is having network problems with your
postgresql box? This may mean some type of firewall or some network program
which could temporarily disable access to your postgresql box.

Also, could you try some console app in your webserver box to connect to
your
postgresql box? This test could make you sure that you are being able to get
data from postgresql. It would also be good if you could put this console
app
to keep all day trying connections to postgresql in order to check if you
get
network down just sometimes.


I hope it helps.

Regards,

Francisco Figueiredo Jr.


	
	
		
_______________________________________________________ 
Yahoo! Acesso Grátis - Internet rápida e grátis. 
Instale o discador agora! http://br.acesso.yahoo.com/
_______________________________________________
Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list