[JON] ORA-12899: value too large for column "JBOSSOPERATIONNETWORK"."RHQ_BUNDLE_DEPLOYMENT"."NAME" (actual: 204, maximum: 200) exception during bundle rollback
Issue
- We have run the following:
- deploy bundle version 1.1;
- deploy bundle version 1.2;
- revert to previous bundle version;
- deploy bundle version 1.2;
- revert to previous bundle version;
...
After a certain number of revisions, bundle revert fails with the following exception:
[1358432364922] javax.ejb.EJBException:java.lang.RuntimeException: javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state -> java.lang.RuntimeException:javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state -> javax.transaction.RollbackException:[com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state -> javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update -> org.hibernate.exception.GenericJDBCException:Could not execute JDBC batch update -> java.sql.BatchUpdateException:ORA-12899: value too large for column "JBOSSOPERATIONNETWORK"."RHQ_BUNDLE_DEPLOYMENT"."NAME" (actual: 204, maximum: 200)
[SQLException=ORA-12899: value too large for column "JBOSSOPERATIONNETWORK"."RHQ_BUNDLE_DEPLOYMENT"."NAME" (actual: 204, maximum: 200)
-> ORA-12899: value too large for column "JBOSSOPERATIONNETWORK"."RHQ_BUNDLE_DEPLOYMENT"."NAME" (actual: 204, maximum: 200)
Have you seen this before and do you know what the root cause of this is?
- We are running Postgres as a backend database. After we used rollback (revert) option few times successfully, bundle revert failed with the following exception:
...
2013-01-21 09:07:49,614 ERROR [org.hibernate.util.JDBCExceptionReporter] Batch entry 0 insert into RHQ_BUNDLE_DEPLOYMENT (NAME, DESCRIPTION, STATUS, ERROR_MESSAGE, SUBJECT_NAME, IS_LIVE, CTIME, MTIME, REPLACED_BUNDLE_DEPLOYMENT_ID, CONFIG_ID, BUNDLE_VERSION_ID, BUNDLE_DESTINATION_ID, ID) values ('Deployment [2] Revert To: Deployment [2] Revert To: Deployment [2] Revert To: Deployment [8] Revert To: Deployment [6] Revert To: Deployment [4] Revert To: Deployment [2] Revert To: Deployment [1] of Version [1.1] to [newDest]', '', 'PENDING', NULL, 'rhqadmin', '0', '1358759269603', '1358759269603', NULL, '18931', '10071', '10071', '10125') was aborted. Call getNextException to see the cause.
2013-01-21 09:07:49,614 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 22001
2013-01-21 09:07:49,614 ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: value too long for type character varying(200)
2013-01-21 09:07:49,614 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
...
Caused by: javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state
Environment
- JBoss Operations Network (JON) 3.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.