java.lang.NegativeArraySizeException from ReceiveTupleV3(PGStream.java:349) ... - Mailing list pgsql-general

From S K
Subject java.lang.NegativeArraySizeException from ReceiveTupleV3(PGStream.java:349) ...
Date
Msg-id AANLkTim0kOsTjazA_sVaTf8gAG2F7Jo4JgSLiO6IJQJ_@mail.gmail.com
Whole thread Raw
List pgsql-general
Our application has been in production for a couple of years. Recent investigation into a problem revealed the following error started a few months back.  I restarted the application, but the error appears after a few days and the thread dies.

Any ideas on how to debug this issue is appreciated.

- Ravi

[21/06/2010 13:49:27] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
[21/06/2010 13:49:27] ERROR org.hibernate.util.JDBCExceptionReporter - An SQLException was provoked by the following failure: java.lang.NegativeArraySizeException
[21/06/2010 13:49:27] ERROR com.aw.cac.nms.poller.ConfigurationService - Thread terminated with exception: pool-1-thread-1
org.hibernate.exception.GenericJDBCException: could not execute query
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2147)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
        at org.hibernate.loader.Loader.list(Loader.java:2023)
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) 
        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)
        at com.aw.cac.nms.mgmt.uw.UwDeviceManager.getDevices(UwDeviceManager.java:223)
        at $DeviceManager_1294c519b0c.getDevices($DeviceManager_1294c519b0c.java)
        at $DeviceManager_1294c519b0d.getDevices($DeviceManager_1294c519b0d.java)
        at com.aw.cac.nms.poller.reachability.ConfigurationServiceImpl$ManagedAddressLoader.getAddresses(ConfigurationServiceImpl.java:194)
        at com.aw.cac.nms.poller.reachability.ConfigurationServiceImpl.reload(ConfigurationServiceImpl.java:93)
        at com.aw.cac.nms.poller.reachability.ConfigurationServiceImpl$1.run(ConfigurationServiceImpl.java:84)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.NegativeArraySizeException
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:369)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:93)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
        at org.hibernate.loader.Loader.doQuery(Loader.java:662)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2144)
        ... 21 more
Caused by: java.lang.NegativeArraySizeException
        at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:349)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1306)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        ... 26 more

pgsql-general by date:

Previous
From: Sam Wun
Date:
Subject: Re: how to create an admin user for restore database.
Next
From: Janet Jacobsen
Date:
Subject: best way to check pgdump