Skip site navigation (1) Skip section navigation (2)

Sudden JVM crashes - a Postgres driver problem?

From: "ljairath(at)uoguelph(dot)ca" <lkjairath(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: brharp(at)uoguelph(dot)ca, Barbara Edwards <edwards(at)uoguelph(dot)ca>
Subject: Sudden JVM crashes - a Postgres driver problem?
Date: 2007-03-29 14:24:10
Message-ID: 487499.76828.qm@web88110.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
    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 


Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-03-29 14:31:42
Subject: Re: Sudden JVM crashes - a Postgres driver problem?
Previous:From: Hartmut BenzDate: 2007-03-29 13:00:25
Subject: Small addition to PGInterval

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group