Thread: Sudden JVM crashes - a Postgres driver problem?

Sudden JVM crashes - a Postgres driver problem?

From
Robert Sösemann
Date:
Hello,


we have a really tricky problem while running our web-application:

The JVM crashes from time to time for no apparent reason.
There seems to be no direct relation to any user-action,
method-call or whatever.

We've checked the JVM crash dumps, but were not able to find something suspicious. The only ideas we've come up, were
the 
usual suspects: JNI-calls and JDBC-Type2-drivers.

This is our current setup:
- JVM 1.4.2_09 on Linux SuSE 9.3
- mysql-database 4.1.14-max with
- mysql-connector-java-3.0.14-production driver
- postgresql-database 8.0.3 with postgresql-8.0-312.jdbc3 driver

The only JNI-calls that I know of, is through some 3rd party UUID-library from "org.doomdark.jug". Maybe the
forementioned 
jdbc-drivers contain JNI-calls, despite being Type4-drivers.

I've also checked a bunch of mailing-lists and it seems there are some outstanding bugs in hotspot, that may trigger
the 
crash. Does anybody have more information or a workaround for this?


Who can help? Thanks in advance!

Robert
Leiter Softwareentwicklung
________________________________________

Gölz & Schwarz GmbH
Waltherstr. 29, 80337 München, Germany
phone: + 49 - (0)89 / 54 46 70 - 0
fax: +49 - (0)89 / 54 46 70 - 10
e-mail: robert.soesemann@goelz.com
web: http://www.goelz.com
________________________________________
Sie suchen den aktiven Dialog mit Ihren Kunden? Sie möchten neue Wege gehen, um
Ihre Zielgruppen online zu motivieren und zu binden? Dann haben wir genau das Richtige
für Sie: Marketing Suite - die Komplett-Lösung für intelligentes Online Marketing!
Informationen zur Marketing Suite erhalten Sie unter http://www.goelz.com/marketingsuite.

Re: Sudden JVM crashes - a Postgres driver problem?

From
Jan de Visser
Date:
On Thursday 13 October 2005 07:23, Robert Sösemann wrote:
> Hello,
>
>
> we have a really tricky problem while running our web-application:
>
> The JVM crashes from time to time for no apparent reason.
> There seems to be no direct relation to any user-action,
> method-call or whatever.
>
> We've checked the JVM crash dumps, but were not able to find something
> suspicious. The only ideas we've come up, were the usual suspects:
> JNI-calls and JDBC-Type2-drivers.
>
> This is our current setup:
> - JVM 1.4.2_09 on Linux SuSE 9.3
> - mysql-database 4.1.14-max with
> - mysql-connector-java-3.0.14-production driver
> - postgresql-database 8.0.3 with postgresql-8.0-312.jdbc3 driver
>
> The only JNI-calls that I know of, is through some 3rd party UUID-library
> from "org.doomdark.jug". Maybe the forementioned jdbc-drivers contain
> JNI-calls, despite being Type4-drivers.

The pgsql jdbc driver is pure java.

>
> I've also checked a bunch of mailing-lists and it seems there are some
> outstanding bugs in hotspot, that may trigger the crash. Does anybody have
> more information or a workaround for this?
>
>
> Who can help? Thanks in advance!
>
> Robert
> Leiter Softwareentwicklung

JdV!!

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

Re: Sudden JVM crashes - a Postgres driver problem?

From
"Markus Wollny"
Date:
pgsql-jdbc-owner@postgresql.org wrote:

>> I've also checked a bunch of mailing-lists and it seems there are
>> some outstanding bugs in hotspot, that may trigger the crash. Does
>> anybody have more information or a workaround for this?

We're running ColdFusion MX 6.1 on a couple of Debian servers and a
couple of months ago we suddenly experienced massive stability problems
after the machines had run smoothely for several weeks. I don't know why
these problems just surfaced all of a sudden, but as far as I
understand, they were probably due a problem in Sun's JVM HotSpot
optimizer (see
http://www.talkingtree.com/blog/index.cfm?mode=day&day=21&month=05&year=
2004 ). In the end we had to restart the application server about once a
day which was not at all a comfortable workaround.

After trying several other hacks, one of them involving deactivation of
the HotSpot optimizer altogether and thus fullback to interpreter-mode,
I chose to ditch Sun's JVM in favour of BEA's JRockit VM; you may
download the VM free at
http://commerce.bea.com/products/weblogicjrockit/accept_terms142.jsp.
Documentation can be found here:
http://e-docs.bea.com/wljrockit/docs142/index.html.

Exchanging JVMs was done in a couple of minutes and we haven't had one
single JVM crash ever since. You may see comparable results by simply
upgrading your JVM or trying IBM's, though, so please try what suits you
best. I hope you'll be able to resolve your issue!

Kind regards

   Markus

Re: Sudden JVM crashes - a Postgres driver problem?

From
Patric Bechtel
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Robert,

I might be totally wrong, but I've had some problem with SuSE
distribution like this, and could get to stop it with the help of the
hotspot team.
Just as a test, comment out any appearances of ldap in
/etc/nsswitch.conf. Sounds very strange, but try it. If it works, you
have to set LDPRELOAD to a $JAVA_HOME/jre/lib/$ARCH/libjsig.so.

hope that helps...

Robert Sösemann schrieb am 13.10.2005 13:23:
> Hello,
>
>
> we have a really tricky problem while running our web-application:
>
> The JVM crashes from time to time for no apparent reason.
> There seems to be no direct relation to any user-action,
> method-call or whatever.
>
> We've checked the JVM crash dumps, but were not able to find something suspicious. The only ideas we've come up, were
the 
> usual suspects: JNI-calls and JDBC-Type2-drivers.
>
> This is our current setup:
> - JVM 1.4.2_09 on Linux SuSE 9.3
> - mysql-database 4.1.14-max with
> - mysql-connector-java-3.0.14-production driver
> - postgresql-database 8.0.3 with postgresql-8.0-312.jdbc3 driver
>
> The only JNI-calls that I know of, is through some 3rd party UUID-library from "org.doomdark.jug". Maybe the
forementioned 
> jdbc-drivers contain JNI-calls, despite being Type4-drivers.
>
> I've also checked a bunch of mailing-lists and it seems there are some outstanding bugs in hotspot, that may trigger
the 
> crash. Does anybody have more information or a workaround for this?
>
>
> Who can help? Thanks in advance!
>
> Robert
> Leiter Softwareentwicklung
> ________________________________________
>
> Gölz & Schwarz GmbH
> Waltherstr. 29, 80337 München, Germany
> phone: + 49 - (0)89 / 54 46 70 - 0
> fax: +49 - (0)89 / 54 46 70 - 10
> e-mail: robert.soesemann@goelz.com
> web: http://www.goelz.com
> ________________________________________
> Sie suchen den aktiven Dialog mit Ihren Kunden? Sie möchten neue Wege gehen, um
> Ihre Zielgruppen online zu motivieren und zu binden? Dann haben wir genau das Richtige
> für Sie: Marketing Suite - die Komplett-Lösung für intelligentes Online Marketing!
> Informationen zur Marketing Suite erhalten Sie unter http://www.goelz.com/marketingsuite.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
>

- --
Mit freundlichen Gruessen / Regards
Patric Bechtel, IPCON Informationssysteme OHG
Kontakt: http://www.ipcon.de/kontakt.php
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: GnuPT 2.5.2

iD8DBQFDTreTfGgGu8y7ypARAtV5AJ9aXJC1DBgJPngeYADlk/SHijZJswCdGnaZ
e+O8kw4lHxRJDtQIh9PlChM=
=LaUt
-----END PGP SIGNATURE-----