Sudden JVM crashes - a Postgres driver problem? - Mailing list pgsql-jdbc

The following query has caused our JVM to crash. could someone please explain it?

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.mule.providers.tcp.TcpConnector@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.mule.providers.tcp.TcpConnector@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@staff.mail.uoguelph.ca
INFO  2007-03-29 09:15:02,628 [Thread-4] org.mule.providers.email.Pop3Connector:
 Disconnected: org.mule.providers.email.Pop3Connector@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.mule.providers.jdbc.JdbcConnector@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  >  > Theonly 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