[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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
