Has anyone run into the following issue where the ...
# troubleshoot
a
Has anyone run into the following issue where the GMS kept crashing during the bootstrap step of
IngestRootUserStep
?
Copy code
io.ebean.AcquireLockException: Error when batch flush on sql: update metadata_aspect_v2 set metadata=?, createdOn=?, createdBy=?, createdFor=?, systemmetadata=? where urn=? and aspect=? and version=?
	at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:44)
	at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:219)
	at io.ebeaninternal.server.transaction.TransactionManager.translate(TransactionManager.java:246)
	at io.ebeaninternal.server.transaction.JdbcTransaction.translate(JdbcTransaction.java:698)
	at io.ebeaninternal.server.transaction.JdbcTransaction.batchFlush(JdbcTransaction.java:680)
	at io.ebeaninternal.server.transaction.JdbcTransaction.internalBatchFlush(JdbcTransaction.java:796)
	at io.ebeaninternal.server.transaction.JdbcTransaction.flushCommitAndNotify(JdbcTransaction.java:1005)
	at io.ebeaninternal.server.transaction.JdbcTransaction.commit(JdbcTransaction.java:1057)
	at io.ebeaninternal.api.ScopeTrans.commitTransaction(ScopeTrans.java:136)
	at io.ebeaninternal.api.ScopedTransaction.commit(ScopedTransaction.java:110)
	at com.linkedin.metadata.entity.ebean.EbeanAspectDao.runInTransactionWithRetry(EbeanAspectDao.java:462)
	at com.linkedin.metadata.entity.EntityService.ingestAspectToLocalDB(EntityService.java:536)
	at com.linkedin.metadata.entity.EntityService.wrappedIngestAspectToLocalDB(EntityService.java:495)
	at com.linkedin.metadata.entity.EntityService.ingestAspect(EntityService.java:632)
	at com.linkedin.metadata.boot.steps.IngestRootUserStep.execute(IngestRootUserStep.java:67)
	at com.linkedin.metadata.boot.BootstrapManager.start(BootstrapManager.java:35)
Caused by
Copy code
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832)
I found out that there was due to the MySQL persistence volume was full. Bumping the volume resolved the issue.