Thread: Re: Strange Error

Re: Strange Error

From
# sriram #
Date:
mine is a standalone application..no servlets now...

i believe there are no firewall scripts running on the machine...

believe me...this is pure ill luck...simple programs throwing complex
errors..


!Here are a few more ideas:
!
!
!> well....i missed the database...it should read
!> jdbc:postgres://localhost:5432/mydb," "," ".....
!OK, so that's not the problem.
!
!> i mentioned apache and tomcat...to make matters more simple if someone
!> really feels that my jdbc classpath should also be present on the tomcat
!> lib directory....i tried that also...(sounds silly though)
!
!Are you running this through a servlet, or just in a standalone application?
!I'd suggest trying to debug this with a simple standalone application first
!& get tomcat involved once the database issue is resolved.
!
!
!> i ran netstat --tcp -a -n | grep 5432 and i found just 5432 listening to
!> my requests and there are no other clashes...
!
!I think others have experienced disconnects after an initial response due to
!some packet filtering, so I'm still curious about whether you have any
!network security software running.
!
!
!> i also tried running postmaster on a different port...but no avail...
!> some one mentioned that i am trying to access a jdbc2 statement......
!> how far can i go in that direction...
!
!
!> PS..amazingly mysql also throws the same error ??
!
!I think this is an important clue. I think it points again to another piece
!of software interfering.
!
!-NickF



Re: Strange Error

From
"Dave Cramer"
Date:
Well if both mysql, and postgres are throwing the same error then
something else is interfering. If it were me, I would monitor the
connection with a small cron job that does a netstat | grep 5432 and
note the pid of the connection. My assumption is that something is
restarting postgres? I suspect that it will drop at exactly the same
time everyday. At any rate, I don't believe it is the jdbc driver, or
postgres. I routinely keep connections alive for months.

One thing that just hit me, do you do a Vacuum in a cron job? Of course
that would only affect postgres, but it popped in my head.


Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of # sriram #
Sent: Tuesday, February 26, 2002 8:04 AM
To: Nick
Cc: Psql-Jdbc
Subject: Re: [JDBC] Strange Error


mine is a standalone application..no servlets now...

i believe there are no firewall scripts running on the machine...

believe me...this is pure ill luck...simple programs throwing complex
errors..


!Here are a few more ideas:
!
!
!> well....i missed the database...it should read
!> jdbc:postgres://localhost:5432/mydb," "," ".....
!OK, so that's not the problem.
!
!> i mentioned apache and tomcat...to make matters more simple if
someone !> really feels that my jdbc classpath should also be present on
the tomcat !> lib directory....i tried that also...(sounds silly though)
! !Are you running this through a servlet, or just in a standalone
application? !I'd suggest trying to debug this with a simple standalone
application first !& get tomcat involved once the database issue is
resolved. ! ! !> i ran netstat --tcp -a -n | grep 5432 and i found just
5432 listening to !> my requests and there are no other clashes... ! !I
think others have experienced disconnects after an initial response due
to !some packet filtering, so I'm still curious about whether you have
any !network security software running. ! ! !> i also tried running
postmaster on a different port...but no avail... !> some one mentioned
that i am trying to access a jdbc2 statement...... !> how far can i go
in that direction... ! ! !> PS..amazingly mysql also throws the same
error ?? ! !I think this is an important clue. I think it points again
to another piece !of software interfering. ! !-NickF



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Re: Strange Error

From
"Peter V. Cooper"
Date:
Sounds suspiciously like a problem one of my associates is having.
Did you try moving the client closer to the server ie WAN->LAN->LOCAL.
I was unable to debug the WAN or LAN as my first install will have
the JDBC Client on the same machine and that seems to stay alive
forever. We were having lost connections overnight on a servlet container
(Tomcat) across seperate machines. I have not yet narrowed my problem
down because the site is being installed with one computer with both
postgres and tomcat on the same machine. I will get back to this later.
One suggestion which seemed reasonable if these two are on different
machines which it looks like is the network layers closing the connection
due to a Firewall (seemingly not) or a VPN with timeout logic. The VPN
which connected to Oracle at another site I installed would cause the
JDBC driver to drop it's static connection and the servlet container would
need to be restarted. This was even after the timeout was supposedly
fixed by the ISP network guys. Again, sounds suspiciously like a JDBC
client having the connection closed.

BTW, the isClosed method in JDBC only tells you if you have closed the
connection. Not what one would logically conclude from the docs. Read
the specs about this one.

At 08:18 AM 2/26/2002 -0500, Dave Cramer wrote:
>Well if both mysql, and postgres are throwing the same error then
>something else is interfering. If it were me, I would monitor the
>connection with a small cron job that does a netstat | grep 5432 and
>note the pid of the connection. My assumption is that something is
>restarting postgres? I suspect that it will drop at exactly the same
>time everyday. At any rate, I don't believe it is the jdbc driver, or
>postgres. I routinely keep connections alive for months.
>
>One thing that just hit me, do you do a Vacuum in a cron job? Of course
>that would only affect postgres, but it popped in my head.
>
>
>Dave
>
>-----Original Message-----
>From: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of # sriram #
>Sent: Tuesday, February 26, 2002 8:04 AM
>To: Nick
>Cc: Psql-Jdbc
>Subject: Re: [JDBC] Strange Error
>
>
>mine is a standalone application..no servlets now...
>
>i believe there are no firewall scripts running on the machine...
>
>believe me...this is pure ill luck...simple programs throwing complex
>errors..
>
>
>!Here are a few more ideas:
>!
>!
>!> well....i missed the database...it should read
>!> jdbc:postgres://localhost:5432/mydb," "," ".....
>!OK, so that's not the problem.
>!
>!> i mentioned apache and tomcat...to make matters more simple if
>someone !> really feels that my jdbc classpath should also be present on
>the tomcat !> lib directory....i tried that also...(sounds silly though)
>! !Are you running this through a servlet, or just in a standalone
>application? !I'd suggest trying to debug this with a simple standalone
>application first !& get tomcat involved once the database issue is
>resolved. ! ! !> i ran netstat --tcp -a -n | grep 5432 and i found just
>5432 listening to !> my requests and there are no other clashes... ! !I
>think others have experienced disconnects after an initial response due
>to !some packet filtering, so I'm still curious about whether you have
>any !network security software running. ! ! !> i also tried running
>postmaster on a different port...but no avail... !> some one mentioned
>that i am trying to access a jdbc2 statement...... !> how far can i go
>in that direction... ! ! !> PS..amazingly mysql also throws the same
>error ?? ! !I think this is an important clue. I think it points again
>to another piece !of software interfering. ! !-NickF
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html


Re: Strange Error

From
Tom Lane
Date:
"Dave Cramer" <Dave@micro-automation.net> writes:
> ... My assumption is that something is
> restarting postgres? I suspect that it will drop at exactly the same
> time everyday. At any rate, I don't believe it is the jdbc driver, or
> postgres. I routinely keep connections alive for months.
> One thing that just hit me, do you do a Vacuum in a cron job? Of course
> that would only affect postgres, but it popped in my head.

Another possibility, since postgres is normally run as an unprivileged
user, is that the server is being killed because it's exceeding some
"ulimit" setting.  Cure: set limit to unlimited before starting
postmaster.  Not sure if mysql is vulnerable to same thing (don't they
prefer to run as root?)

            regards, tom lane