Thursday, August 08, 2013

Cloudera Manager - java.sql.BatchUpdateException


Error:

javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException: Batch entry 0 insert into COMMANDS (OPTIMISTIC_LOCK_VERSION, NAME, STATE, START_INSTANT, END_INSTANT, ACTIVE, RESULT_MESSAGE, RESULT_DATA, RESULT_DATA_MIME_TYPE, RESULT_DATA_FILENAME, RESULT_DATA_PATH, RESULT_DATA_REAPED, SUCCESS, INTERNAL_STATE, ARGUMENTS, AUDITED, CLUSTER_ID, SERVICE_ID, ROLE_ID, HOST_ID, SCHEDULE_ID, PARENT_ID, COMMAND_ID) values ('0', 'Start', 'STARTED', '1375964722382', NULL, '1', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, '8', '58', NULL, NULL, NULL, '2041') was aborted. Call getNextException to see the cause.
at AbstractEntityManagerImpl.java line 1377
in org.hibernate.ejb.AbstractEntityManagerImpl convert()

...

Caused by: org.hibernate.exception.GenericJDBCException:Batch entry 0 insert into COMMANDS (OPTIMISTIC_LOCK_VERSION, NAME, STATE, START_INSTANT, END_INSTANT, ACTIVE, RESULT_MESSAGE, RESULT_DATA, RESULT_DATA_MIME_TYPE, RESULT_DATA_FILENAME, RESULT_DATA_PATH, RESULT_DATA_REAPED, SUCCESS, INTERNAL_STATE, ARGUMENTS, AUDITED, CLUSTER_ID, SERVICE_ID, ROLE_ID, HOST_ID, SCHEDULE_ID, PARENT_ID, COMMAND_ID) values ('0', 'Start', 'STARTED', '1375964722382', NULL, '1', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, '8', '58', NULL, NULL, NULL, '2041') was aborted. Call getNextException to see the cause.
at StandardSQLExceptionConverter.java line 54
in org.hibernate.exception.internal.StandardSQLExceptionConverter convert()

....

Caused by: java.sql.BatchUpdateException:Batch entry 0 insert into COMMANDS (OPTIMISTIC_LOCK_VERSION, NAME, STATE, START_INSTANT, END_INSTANT, ACTIVE, RESULT_MESSAGE, RESULT_DATA, RESULT_DATA_MIME_TYPE, RESULT_DATA_FILENAME, RESULT_DATA_PATH, RESULT_DATA_REAPED, SUCCESS, INTERNAL_STATE, ARGUMENTS, AUDITED, CLUSTER_ID, SERVICE_ID, ROLE_ID, HOST_ID, SCHEDULE_ID, PARENT_ID, COMMAND_ID) values ('0', 'Start', 'STARTED', '1375964722382', NULL, '1', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, '0', NULL, '8', '58', NULL, NULL, NULL, '2041') was aborted. Call getNextException to see the cause.
at AbstractJdbc2Statement.java line 2598

in org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler handleError()

Occurred after Cloudera Manager upgrade.

Possible cause: Because there is no connection errors, but rather a failure to insert, probably the database is unhappy.  Most likely it's out of disk space. See if your host is out of disk space.

To check what DB your CM is using, take a look at "/etc/cloudera-scm-server/db.properties" file on the host where you installed your CM.

No comments: