Consensys / cakeshop

An integrated development environment and SDK for Ethereum-like ledgers
https://www.goquorum.com
Apache License 2.0
506 stars 199 forks source link

Cakeshop freezes with 100% cpu use #45

Closed caleteeter closed 4 years ago

caleteeter commented 7 years ago

After running a Quorum network (deployed from Azure template), I am getting exceptions on the blockmaker. This network (1 blockmaker and 1 voter) has been running for a few weeks, not under massive load (just developers). This is output from the Cakeshop instance.

WARN 2017-07-23 11:06:01,812 [BlockSaver-34] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-07-23 11:06:01,813 [BlockSaver-34] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TOTALDIFFICULTY ERROR 2017-07-23 11:06:01,813 [BlockSaver-34] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-07-23 11:06:01,813 [BlockSaver-34] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-07-23 11:06:01,842 [BlockSaver-34] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$6304e8b.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.ex

fixanoid commented 7 years ago

Could you start cakeshop in debug mode and see which value is breaking it? This mught be related to the long timestamps, the fix for which I'll check in a minute.

hotblade commented 7 years ago

I have similar issue but on different column. Below is the log when run in debug mode.



Running pre-flight checks...

Testing ethereum data dir path /Users/alee/work/cakeshop/data/local/ethereum OK

Testing db path /Users/alee/work/cakeshop/data/local/db OK

Testing geth server binary OK

Testing solc compiler binary OK

ALL TESTS PASSED!


INFO 2017-09-26 11:42:48,906 [main] (BlockchainInitializerTask.java:115) Overriding contract registry address with 0x9d13c6d3afe1721beef56b55d303b09e021e27ab INFO 2017-09-26 11:42:48,907 [main] (BlockchainInitializerTask.java:124) Loaded contract registry address 0x9d13c6d3afe1721beef56b55d303b09e021e27ab INFO 2017-09-26 11:42:48,915 [main] (BlockchainInitializerTask.java:88 ) Storing existing wallet account balances DEBUG 2017-09-26 11:42:49,092 [main] (SqlStatementLogger.java:92 ) select account0_.address as address1_00, account0_.balance as balance2_00 from PUBLIC.ACCOUNTS account0 where account0.address=? DEBUG 2017-09-26 11:42:49,171 [cake-1] (SqlStatementLogger.java:92 ) select this_.id as id1_50, this_.nodeIP as nodeIP2_50, this_.nodeName as nodeName3_50, this_.nodeUrl as nodeUrl4_50, this_.status as status5_50 from PUBLIC.PEERS this_

              ,%%%%%%%%,
            ,%%/\%%%%/\%%
           ,%%%\c "" J/%%%    ,,,,,,, 
  %.       %%%%/ 6  6 \%%%    |||||||
  `%%.     %%%%    _  |%%%  @@@@@@@@@@@
   `%%     `%%%%(__Y__)%%'  {~*~*~*~*~}
   //       ;%%%%`\-/%%%' @@@@@@@@@@@@@@@@
  ((       /  `%%%%%%%'   {~* CAKESHOP *~}
   \\    .'          |    {     OPEN     }
    \\  /       \  | |    {~~*~~*~~*~~*~~}
     \\/         ) | |    @@@@@@@@@@@@@@@
      \         /_ | |__      __) (__
      (___________)))))))    /_______\

      CAKESHOP
      version:     0.9.1
      build id:    6c7a88ee8b317fe2b69c97fe1e838112cb655411
      build date:  2017-01-03T15:30:05.595-0500

DEBUG 2017-09-26 11:42:49,198 [main] (AutoConfigurationReportLoggingInitializer.java:117)

========================= AUTO-CONFIGURATION REPORT

Positive matches:

AopAutoConfiguration matched

Negative matches:

ActiveMQAutoConfiguration did not match

Exclusions:

None

Unconditional classes:

org.springframework.boot.actuate.autoconfigure.HealthIndicatorAutoConfiguration

org.springframework.boot.actuate.autoconfigure.PublicMetricsAutoConfiguration

org.springframework.boot.autoconfigure.PropertyPlaceholderAutoConfiguration

org.springframework.boot.actuate.autoconfigure.ManagementServerPropertiesAutoConfiguration

org.springframework.boot.actuate.autoconfigure.AuditAutoConfiguration

org.springframework.boot.actuate.autoconfigure.EndpointAutoConfiguration

org.springframework.boot.autoconfigure.context.ConfigurationPropertiesAutoConfiguration

org.springframework.boot.actuate.autoconfigure.TraceRepositoryAutoConfiguration

org.springframework.boot.actuate.autoconfigure.MetricRepositoryAutoConfiguration

DEBUG 2017-09-26 11:42:49,229 [main] (GenericFilterBean.java:177) Initializing filter 'metricFilter' DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:202) Filter 'metricFilter' configured successfully DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:177) Initializing filter 'characterEncodingFilter' DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:202) Filter 'characterEncodingFilter' configured successfully DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:177) Initializing filter 'hiddenHttpMethodFilter' DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:202) Filter 'hiddenHttpMethodFilter' configured successfully DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:177) Initializing filter 'httpPutFormContentFilter' DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:202) Filter 'httpPutFormContentFilter' configured successfully DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:177) Initializing filter 'requestContextFilter' DEBUG 2017-09-26 11:42:49,232 [main] (GenericFilterBean.java:202) Filter 'requestContextFilter' configured successfully DEBUG 2017-09-26 11:42:49,233 [main] (GenericFilterBean.java:177) Initializing filter 'webRequestLoggingFilter' DEBUG 2017-09-26 11:42:49,233 [main] (GenericFilterBean.java:202) Filter 'webRequestLoggingFilter' configured successfully DEBUG 2017-09-26 11:42:49,233 [main] (GenericFilterBean.java:177) Initializing filter 'applicationContextIdFilter' DEBUG 2017-09-26 11:42:49,234 [main] (GenericFilterBean.java:202) Filter 'applicationContextIdFilter' configured successfully INFO 2017-09-26 11:42:49,331 [main] (JettyEmbeddedServletContainer.java:121) Jetty started on port(s) 8080 (http/1.1) url: http://192.168.0.5:8080/cakeshop/

INFO 2017-09-26 11:42:49,346 [main] (StartupInfoLogger.java:57 ) Started SpringBootApplication in 11.308 seconds (JVM running for 12.373) DEBUG 2017-09-26 11:42:54,209 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this_.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.blocknumber=? DEBUG 2017-09-26 11:42:54,221 [BlockScanner-34] (SqlStatementLogger.java:92 ) select max(this.blocknumber) as y0 from PUBLIC.BLOCKS this DEBUG 2017-09-26 11:42:54,223 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.blocknumber=? DEBUG 2017-09-26 11:42:54,271 [BlockScanner-34] (SqlStatementLogger.java:92 ) select transactio0.Block_id as Block_id1_10, transactio0_.transactions as transact2_10 from PUBLIC.Blocktransactions transactio0 where transactio0_.Blockid=? DEBUG 2017-09-26 11:42:54,283 [BlockScanner-34] (SqlStatementLogger.java:92 ) select uncles0.Block_id as Block_id1_20, uncles0_.uncles as uncles2_20 from PUBLIC.Blockuncles uncles0 where uncles0_.Block_id=? DEBUG 2017-09-26 11:42:54,342 [BlockSaver-35] (SqlStatementLogger.java:92 ) insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WARN 2017-09-26 11:42:54,354 [BlockSaver-35] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-09-26 11:42:54,355 [BlockSaver-35] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL ERROR 2017-09-26 11:42:54,356 [BlockSaver-35] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-09-26 11:42:54,356 [BlockSaver-35] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-09-26 11:42:54,358 [BlockSaver-35] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$26065d86.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581) ... 10 more Caused by: java.sql.BatchUpdateException: data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 27 more DEBUG 2017-09-26 11:42:54,361 [BlockSaver-35] (SqlStatementLogger.java:92 ) insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WARN 2017-09-26 11:42:54,364 [BlockSaver-35] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-09-26 11:42:54,364 [BlockSaver-35] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL ERROR 2017-09-26 11:42:54,364 [BlockSaver-35] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-09-26 11:42:54,365 [BlockSaver-35] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-09-26 11:42:54,365 [BlockSaver-35] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$26065d86.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581) ... 10 more Caused by: java.sql.BatchUpdateException: data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 27 more DEBUG 2017-09-26 11:42:54,368 [BlockSaver-35] (SqlStatementLogger.java:92 ) insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WARN 2017-09-26 11:42:54,370 [BlockSaver-35] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-09-26 11:42:54,370 [BlockSaver-35] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL ERROR 2017-09-26 11:42:54,371 [BlockSaver-35] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-09-26 11:42:54,371 [BlockSaver-35] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-09-26 11:42:54,371 [BlockSaver-35] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$26065d86.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581) ... 10 more Caused by: java.sql.BatchUpdateException: data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 27 more DEBUG 2017-09-26 11:42:54,374 [BlockSaver-35] (SqlStatementLogger.java:92 ) insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WARN 2017-09-26 11:42:54,376 [BlockSaver-35] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-09-26 11:42:54,376 [BlockSaver-35] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL ERROR 2017-09-26 11:42:54,376 [BlockSaver-35] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-09-26 11:42:54,377 [BlockSaver-35] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-09-26 11:42:54,377 [BlockSaver-35] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$26065d86.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581) ... 10 more Caused by: java.sql.BatchUpdateException: data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 27 more DEBUG 2017-09-26 11:42:54,379 [BlockSaver-35] (SqlStatementLogger.java:92 ) insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WARN 2017-09-26 11:42:54,383 [BlockSaver-35] (SqlExceptionHelper.java:129) SQL Error: 3403, SQLState: 22003 ERROR 2017-09-26 11:42:54,383 [BlockSaver-35] (SqlExceptionHelper.java:131) data exception: numeric value out of range; table: BLOCKS column: TIMESTAMP_VAL ERROR 2017-09-26 11:42:54,384 [BlockSaver-35] (BatchingBatch.java:124) HHH000315: Exception executing batch [could not execute batch] ERROR 2017-09-26 11:42:54,384 [BlockSaver-35] (SessionImpl.java:3166) HHH000346: Error during managed flush [could not execute batch] ERROR 2017-09-26 11:42:54,384 [BlockSaver-35] (SavingBlockListener.java:53 ) BlockSaverThread died org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into PUBLIC.BLOCKS (difficulty, extraData, gasLimit, gasUsed, logsBloom, miner, nonce, block_number, parentId, sha3Uncles, stateRoot, timestamp_val, totalDifficulty, transactionsRoot, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not execute batch at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168) at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:741) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:589) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) at com.jpmorgan.cakeshop.dao.BlockDAO$$EnhancerBySpringCGLIB$$26065d86.save() at com.jpmorgan.cakeshop.db.SavingBlockListener.saveBlock(SavingBlockListener.java:108) at com.jpmorgan.cakeshop.db.SavingBlockListener$BlockSaverThread.run(SavingBlockListener.java:48) Caused by: org.hibernate.exception.DataException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581) ... 10 more Caused by: java.sql.BatchUpdateException: data exception: numeric value out of range; table: BLOCKS column: TIMESTAMPVAL at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 27 more DEBUG 2017-09-26 11:43:12,387 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.blocknumber=? DEBUG 2017-09-26 11:44:00,588 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.blocknumber=? DEBUG 2017-09-26 11:45:33,001 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.blocknumber=? DEBUG 2017-09-26 11:45:59,089 [BlockScanner-34] (SqlStatementLogger.java:92 ) select this.id as id1_30, this_.difficulty as difficul2_30, this_.extraData as extraDat3_30, this_.gasLimit as gasLimit4_30, this_.gasUsed as gasUsed5_30, this_.logsBloom as logsBloo6_30, this_.miner as miner7_30, this_.nonce as nonce8_30, this_.block_number as block_nu9_30, this_.parentId as parentI10_30, this_.sha3Uncles as sha11_30, this_.stateRoot as stateRo12_30, this_.timestamp_val as timesta13_30, this_.totalDifficulty as totalDi14_30, this_.transactionsRoot as transac15_30 from PUBLIC.BLOCKS this where this.block_number=?

diegoGVF commented 7 years ago

Do you fix the error?

abceater commented 6 years ago

I am also getting this error, has anyone got a solution please?

bmcd commented 4 years ago

This was fixed a while ago, the wrong type was used for a database column that couldn't hold large values