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

RHQ3.0.0 Content Source Sync issues with Postgres 9.0.3?

n_mouli Mar 8, 2011 4:34 AM

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

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

1. RHQ3.0.0 Content Source Sync issues with Postgres 9.0.3?

lkrejci Mar 8, 2011 5:26 AM (in response to n_mouli)

Well, RHQ3 was not tested with Postgres 9 and only contains Postgres 8 drivers. Given no testing was done, I would not recommend running RHQ 3 with Postgres 9. But then one would hope it would work when everything is set up correctly.

The exceptions give an impression that this error happens deep inside the postgres driver, which would lead me to believe that this is either a bug in the JDBC driver or that you might be using an old version of the driver.

Are you sure your RHQ installation uses the latest postgres jdbc driver available?

The driver should be in $RHQ_HOME/jbossas/server/default/lib
Actions
2. RHQ3.0.0 Content Source Sync issues with Postgres 9.0.3?

n_mouli Mar 8, 2011 7:00 AM (in response to lkrejci)

Bingo. Stupid me
Replacing the Postgres-8.4 JDBC-3 driver with the Postgres-9.0 JDBC-4 driver is working wonders.
1 of 1 people found this helpful
Actions

Go to original post