net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889]

Atlassian JIRA | Mark Gaylard | 8 years ago
  1. 0

    We occasionally get empty notification emails from bamboo. All they have in them is the subject '[Bamboo]'. The logged errors are below. It doesn't happen every time, maybe 1 in 5 or so. This started happening when we upgraded from v1.2.2 to v2.0.3. I did an export of 1.2.2, then created a new bamboo home and database for v2.0.3 to use then imported the previous export. The version of the database and jdbc driver stayed the same. Mark. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,745 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [BatcherImpl] exception clearing maxRows/queryTimeout java.sql.SQLException: You can't operate on a closed Statement!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1206) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:105) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:889) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1198) ... 46 more 2008-06-16 10:42:37,748 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [PersistentCollection] Failed to lazily initialize a collection net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889] at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.collection.AbstractCollectionPersister.convert(AbstractCollectionPersister.java:728) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:291) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2424) at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:543) at org.postgresql.jdbc3.Jdbc3Statement.createResultSet(Jdbc3Statement.java:36) at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:196) at org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:377) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1275) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) ... 36 more 2008-06-16 10:42:37,750 ERROR [pool-26-thread-1] [AllBuildsCondition] Could not create email content for notificationAll Completed Builds

    Atlassian JIRA | 8 years ago | Mark Gaylard
    net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889]
  2. 0

    We occasionally get empty notification emails from bamboo. All they have in them is the subject '[Bamboo]'. The logged errors are below. It doesn't happen every time, maybe 1 in 5 or so. This started happening when we upgraded from v1.2.2 to v2.0.3. I did an export of 1.2.2, then created a new bamboo home and database for v2.0.3 to use then imported the previous export. The version of the database and jdbc driver stayed the same. Mark. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,745 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,745 WARN [pool-26-thread-1] [BatcherImpl] exception clearing maxRows/queryTimeout java.sql.SQLException: You can't operate on a closed Statement!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1206) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:105) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:889) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getMaxRows(NewProxyPreparedStatement.java:1198) ... 46 more 2008-06-16 10:42:37,748 WARN [pool-26-thread-1] [JDBCExceptionReporter] SQL Error: 0, SQLState: 55000 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [JDBCExceptionReporter] This statement has been closed. 2008-06-16 10:42:37,748 ERROR [pool-26-thread-1] [PersistentCollection] Failed to lazily initialize a collection net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889] at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.collection.AbstractCollectionPersister.convert(AbstractCollectionPersister.java:728) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:291) at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315) at net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195) at net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71) at net.sf.hibernate.collection.Set.iterator(Set.java:130) at com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627) at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111) at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302) at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327) at org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.Template.merge(Template.java:256) at com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78) at com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118) at sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy36.handleEvent(Unknown Source) at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32) at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34) at java.lang.Thread.run(Thread.java:595) Caused by: org.postgresql.util.PSQLException: This statement has been closed. at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2424) at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:543) at org.postgresql.jdbc3.Jdbc3Statement.createResultSet(Jdbc3Statement.java:36) at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:196) at org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:377) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1275) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020) at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995) at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93) at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288) ... 36 more 2008-06-16 10:42:37,750 ERROR [pool-26-thread-1] [AllBuildsCondition] Could not create email content for notificationAll Completed Builds

    Atlassian JIRA | 8 years ago | Mark Gaylard
    net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl.commits#13860889]
  3. 0

    PO very slow on zkwebui

    adempiere | 5 years ago | bma99
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ""limit""   Position: 501; State=42601; ErrorCode=0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    help

    adempiere | 2 years ago | deepesh1203
    org.postgresql.util.PSQLException: ERROR: relation "ad_table" does not exist Position: 15; State=42P01; ErrorCode=0
  6. 0

    Hibernate does not create table - some converters

    Stack Overflow | 2 years ago | Koziołek
    org.postgresql.util.PSQLException: ERROR: relation "prowizje_szablony" does not exist Pozycja: 273
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    This statement has been closed.

    at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2424)
    2. org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:543)
    3. org.postgresql.jdbc3.Jdbc3Statement.createResultSet(Jdbc3Statement.java:36)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:196)
    5. org.postgresql.core.v3.QueryExecutorImpl$1.handleResultRows(QueryExecutorImpl.java:377)
    6. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1275)
    7. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    8. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    9. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
    10. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
    10 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    1 frame
  4. net.sf.hibernate
    Set.iterator
    1. net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
    2. net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
    3. net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
    4. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
    5. net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020)
    6. net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995)
    7. net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93)
    8. net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288)
    9. net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3315)
    10. net.sf.hibernate.collection.PersistentCollection.initialize(PersistentCollection.java:195)
    11. net.sf.hibernate.collection.PersistentCollection.read(PersistentCollection.java:71)
    12. net.sf.hibernate.collection.Set.iterator(Set.java:130)
    12 frames
  5. com.atlassian.bamboo
    BuildResultsImpl.getUniqueAuthors
    1. com.atlassian.bamboo.results.BuildResultsImpl.getUniqueAuthors(BuildResultsImpl.java:627)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:585)
    3 frames
  7. Apache Velocity
    Template.merge
    1. org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:111)
    2. org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:302)
    3. org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:157)
    4. org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
    5. org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
    6. org.apache.velocity.runtime.parser.node.ASTNENode.evaluate(ASTNENode.java:45)
    7. org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:45)
    8. org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:68)
    9. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
    10. org.apache.velocity.Template.merge(Template.java:256)
    10 frames
  8. com.atlassian.bamboo
    NotificationListener.handleEvent
    1. com.atlassian.bamboo.notification.conditions.AllBuildsCondition.getTextEmail(AllBuildsCondition.java:78)
    2. com.atlassian.bamboo.notification.NotificationListener.handleEvent(NotificationListener.java:118)
    2 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor673.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:585)
    3 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  11. Hibernate
    HibernateInterceptor.invoke
    1. org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  13. Unknown
    $Proxy36.handleEvent
    1. $Proxy36.handleEvent(Unknown Source)
    1 frame
  14. com.atlassian.event
    DefaultEventManager$2.run
    1. com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202)
    1 frame
  15. Backport of JSR 166
    ThreadPoolExecutor$Worker.run
    1. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
    2. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
    2 frames
  16. com.atlassian.bamboo
    NamedThreadFactory$1.run
    1. com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$1.run(NamedThreadFactory.java:32)
    1 frame
  17. Backport of JSR 166
    ThreadHelpers$1.run
    1. edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34)
    1 frame
  18. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame