2 Replies Latest reply on Mar 8, 2011 7:00 AM by Chandramouli Nagarajan

    RHQ3.0.0 Content Source Sync issues with Postgres 9.0.3?

    Chandramouli Nagarajan Newbie

      Hi all,

      I have setup a content source for JBoss EAP Patch Source URL and was trying to do a content source sync. The rhq-server web-page does not report any error but it does not provide any updates on the Synch Results section as well.

      On observing the req-server-log4j-log the following exception gets thrown every time a sync is attempted.

      Any ideads what could be the issue here?

       

      =====================================================

      2011-03-08 03:14:43,114 INFO  [org.rhq.enterprise.server.plugin.pc.content.ContentServerPluginContainer] Scheduled content source sync job [5100fe83--ae61b2e3--12e94bf3825:syncContentSource] to fire now at [Tue Mar 08 03:14:43 CST 2011] for [ContentSource: id=[10001], name=[JBoss Patch Content Source]].

      2011-03-08 03:15:09,593 WARN  [org.jboss.resource.connectionmanager.NoTxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.NoTxConnectionManager$NoTxConnectionEventListener@87c551[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@bc431e handles=1 lastUse=1299575684653 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@1f6d04a context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@e4d035]

      java.lang.ArrayIndexOutOfBoundsException: 2

              at org.postgresql.util.PGbytea.toBytes(PGbytea.java:76)

              at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBytes(AbstractJdbc2ResultSet.java:2271)

              at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBytes(AbstractJdbc2ResultSet.java:2451)

              at org.jboss.resource.adapter.jdbc.WrappedResultSet.getBytes(WrappedResultSet.java:464)

              at org.quartz.impl.jdbcjobstore.PostgreSQLDelegate.getJobDetailFromBlob(PostgreSQLDelegate.java:118)

              at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getMapFromProperties(StdJDBCDelegate.java:928)

              at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:2133)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1554)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1548)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2768)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2733)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3760)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)

              at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)

      2011-03-08 03:15:09,594 WARN  [org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler] Failed restore connection's original auto commit setting.

      java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1b6b12d

              at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:454)

              at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3551)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3774)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)

              at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)

      2011-03-08 03:15:09,594 ERROR [org.quartz.core.QuartzSchedulerThread] quartzSchedulerThreadLoop: RuntimeException null

      java.lang.reflect.UndeclaredThrowableException

              at $Proxy492.rollback(Unknown Source)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3601)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3764)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)

              at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)

      Caused by: java.lang.reflect.InvocationTargetException

              at sun.reflect.GeneratedMethodAccessor479.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)

              ... 5 more

      Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1b6b12d

              at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:496)

              ... 9 more

      2011-03-08 03:15:14,391 WARN  [org.jboss.resource.connectionmanager.NoTxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.NoTxConnectionManager$NoTxConnectionEventListener@2fa0be[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@e2df23 handles=1 lastUse=1299575714387 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$PoolBySubject@1f6d04a context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@e4d035]

      java.lang.ArrayIndexOutOfBoundsException: 2

              at org.postgresql.util.PGbytea.toBytes(PGbytea.java:76)

              at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBytes(AbstractJdbc2ResultSet.java:2271)

              at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBytes(AbstractJdbc2ResultSet.java:2451)

              at org.jboss.resource.adapter.jdbc.WrappedResultSet.getBytes(WrappedResultSet.java:464)

              at org.quartz.impl.jdbcjobstore.PostgreSQLDelegate.getJobDetailFromBlob(PostgreSQLDelegate.java:118)

              at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getMapFromProperties(StdJDBCDelegate.java:928)

              at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:2133)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1554)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:949)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3126)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)

      2011-03-08 03:15:14,392 WARN  [org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler] Failed restore connection's original auto commit setting.

      java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@e21b11

              at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:454)

              at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3551)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3145)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)

      2011-03-08 03:15:14,392 ERROR [org.quartz.impl.jdbcjobstore.JobStoreCMT] MisfireHandler: Error handling misfires: null

      java.lang.reflect.UndeclaredThrowableException

              at $Proxy492.rollback(Unknown Source)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3601)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3132)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)

              at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)

      Caused by: java.lang.reflect.InvocationTargetException

              at sun.reflect.GeneratedMethodAccessor479.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)

              ... 5 more

      Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@e21b11

              at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)

              at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:496)

              ... 9 more

      =====================================================