Sudden JVM crashes - a Postgres driver problem?

The following query has caused our JVM to crash. could someone please explain it? our configuration is:
pg_ctl (PostgreSQL) 7.4.3
postgresql-8.1-404.jdbc3.jar
jdk build 1.4.2_05-b04
Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386
org.postgresql.util.PSQLException: ERROR: date/time field value out of range: "2
007-2-29 0:0"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:332)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:231)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:205)
at ca.uoguelph.ccs.portal.portlets.databasestatsreporterportlet.Database
StatsReporterPortlet.populateSummaryStatsData(DatabaseStatsReporterPortlet.java:
481)
at ca.uoguelph.ccs.portal.portlets.databasestatsreporterportlet.Database
StatsReporterPortlet.getSummaryStats(DatabaseStatsReporterPortlet.java:424)
at ca.uoguelph.ccs.portal.portlets.databasestatsreporterportlet.Database
StatsReporterPortlet.doView(DatabaseStatsReporterPortlet.java:215)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
at org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:205
)
at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:145)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
Chain.java:157)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
r.java:704)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
cher.java:590)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
er.java:510)
at org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
.java:120)
at org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
.java:73)
at org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
ava:103)
at org.jasig.portal.channels.portlet.CPortletAdapter.getMarkup(CPortletA
r.java:548)
at org.jasig.portal.channels.portlet.CPortletAdapter.renderCharacters(CP
tAdapter.java:481)
at org.jasig.portal.MultithreadedCharacterChannelAdapter.renderCharacter
tithreadedCharacterChannelAdapter.java:71)
at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486)
at org.jasig.portal.utils.threading.Worker.run(Worker.java:88)
DEBUG 2007-03-29 09:15:02,627 [Thread-4] org.mule.MuleManager: Stopping connecto
rs...
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: St
opping Connector: org.mule.providers.tcp.TcpConnector
DEBUG 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: St
opping receiver on endpoint: tcp://localhost:60504
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: Di
sconnected: org(dot)mule(dot)providers(dot)tcp(dot)TcpConnector(at)ac4d3b
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: Co
nnector org.mule.providers.tcp.TcpConnector has been stopped
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.email.Pop3Connector:
Stopping Connector: org.mule.providers.email.Pop3Connector
DEBUG 20at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486)
at org.jasig.portal.utils.threading.Worker.run(Worker.java:88)
DEBUG 2007-03-29 09:15:02,627 [Thread-4] org.mule.MuleManager: Stopping connecto
rs...
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: St
opping Connector: org.mule.providers.tcp.TcpConnector
DEBUG 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: St
opping receiver on endpoint: tcp://localhost:60504
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: Di
sconnected: org(dot)mule(dot)providers(dot)tcp(dot)TcpConnector(at)ac4d3b
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.tcp.TcpConnector: Co
nnector org.mule.providers.tcp.TcpConnector has been stopped
INFO 2007-03-29 09:15:02,627 [Thread-4] org.mule.providers.email.Pop3Connector:
Stopping Connector: org.mule.providers.email.Pop3Connector
DEBUG 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.Pop3Connector:
Stopping receiver on endpoint: pop3://portaltm:pteam2(at)staff(dot)mail(dot)uoguelph(dot)ca
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.Pop3Connector:
Disconnected: org(dot)mule(dot)providers(dot)email(dot)Pop3Connector(at)1cdfd19
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.Pop3Connector:
Connector org.mule.providers.email.Pop3Connector has been stopped
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.jdbc.JdbcConnector:
Stopping Connector: org.mule.providers.jdbc.JdbcConnector
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.jdbc.JdbcConnector:
Disconnected: org(dot)mule(dot)providers(dot)jdbc(dot)JdbcConnector(at)bbf7aa
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.jdbc.JdbcConnector:
Connector org.mule.providers.jdbc.JdbcConnector has been stopped
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.SmtpConnector:
Stopping Connector: org.mule.providers.email.SmtpConnector
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.SmtpConnector:
Connector org.mule.providers.email.SmtpConnector has been stopped
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.MuleManager: Connectors have b
een stopped successfully
INFO 2007-03-29 09:15:02,628 [Thread-4] org.mule.MuleManager: Stopping agents..
.
DEBUG 2007-03-29 09:15:02,628 [Thread-4] org.mule.MuleManager: Stopping agent: M
ule Admin
INFO 2007-03-29 09:15:02,629 [Thread-4] org.mule.MuleManager: Agents Successful
ly Stopped
INFO 2007-03-29 09:15:02,629 [Thread-4] org.mule.util.queue.TransactionalQueueM
anager: Stopping ResourceManager
INFO 2007-03-29 09:15:02,629 [Thread-4] org.mule.util.queue.TransactionalQueueM
anager: Stopped ResourceManager Re: Sudden JVM crashes - a Postgres driver problem?
---------------------------------

From: Jan de Visser <jdevisser ( at ) digitalfairway ( dot ) com>
To: pgsql-jdbc ( at ) postgresql ( dot ) org
Subject: Re: Sudden JVM crashes - a Postgres driver problem?
Date: Thu, 13 Oct 2005 08:27:01 -0400

---------------------------------

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 ( at ) digitalfairway ( dot ) com Baruk Khazad! Khazad ai-menu! --------------------------------------------------------------

---------------------------------

References:
Sudden JVM crashes - a Postgres driver problem?
From: Robert Sösemann

---------------------------------

Prev by Date: Re: How to insert "date" as timestamp
Next by Date: Unsubscribe
Previous by thread: Sudden JVM crashes - a Postgres driver problem?
Next by thread: Re: Sudden JVM crashes - a Postgres driver problem?
Index(es):
Main
Thread

Home | Main Index | Thread Index