SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper The table 'arch_contract_data' is full

Submitted by jagch on Wed, 04/11/2018 - 23:48
1
0
-1

Hi, I have a VPS with Linux where run Bonita 7.5.4 in MySql DB. The server crashed because of the following error. This can happen or I have to configure something in the Database.

I hope for help as soon as possible since the system is down.

Thank you so much

2018-04-11 11:59:26.851 -0300 SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper The table 'arch_contract_data' is full
2018-04-11 11:59:26.852 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 1114, SQLState: HY000
2018-04-11 11:59:26.852 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper The table 'arch_contract_data' is full
2018-04-11 11:59:26.853 -0300 SEVERE: org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl HHH000346: Error during managed flush [could not execute statement]
2018-04-11 11:59:48.831 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1114, SQLState: HY000
2018-04-11 11:59:48.832 -0300 SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper The table 'arch_contract_data' is full
2018-04-11 11:59:48.832 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 1114, SQLState: HY000
2018-04-11 11:59:48.833 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper The table 'arch_contract_data' is full
2018-04-11 11:59:48.833 -0300 SEVERE: org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl HHH000346: Error during managed flush [could not execute statement]
2018-04-11 11:59:53.701 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1030, SQLState: HY000
2018-04-11 11:59:53.701 -0300 SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Got error 122 from storage engine
2018-04-11 11:59:53.704 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 1030, SQLState: HY000
2018-04-11 11:59:53.704 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Got error 122 from storage engine
2018-04-11 11:59:53.705 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 6, SQLState: HY000
2018-04-11 11:59:53.705 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Error on delete of '/tmp/#sql_33b_0.MYI' (Errcode: 2)
2018-04-11 12:00:04.771 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1030, SQLState: HY000
2018-04-11 12:00:04.773 -0300 SEVERE: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Got error 122 from storage engine
2018-04-11 12:00:04.775 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 1030, SQLState: HY000
2018-04-11 12:00:04.776 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Got error 122 from storage engine
2018-04-11 12:00:04.776 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 6, SQLState: HY000
2018-04-11 12:00:04.776 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Error on delete of '/tmp/#sql_33b_0.MYI' (Errcode: 2)
2018-04-11 12:01:12.356 -0300 WARNING: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1030, SQLState: HY000
2018-04-11 12:01:12.357 -0300 SEVERE: org.hiber2018-04-11 18:31:28.990 -0300 INFO: org.quartz.plugins.management.ShutdownHookPlugin Shutting down Quartz...
2018-04-11 18:31:28.990 -0300 INFO: org.quartz.core.QuartzScheduler Scheduler QuartzScheduler_$NON_CLUSTERED shutting down.
2018-04-11 18:31:28.991 -0300 INFO: org.quartz.core.QuartzScheduler Scheduler QuartzScheduler$NON_CLUSTERED paused.
2018-04-11 18:31:28.992 -0300 INFO: org.quartz.core.QuartzScheduler Scheduler QuartzScheduler$_NON_CLUSTERED shutdown complete.
2018-04-11 18:31:28.992 -0300 INFO: org.apache.coyote.http11.Http11Protocol Pausing ProtocolHandler ["http-bio-8080"]
2018-04-11 18:31:28.995 -0300 INFO: org.apache.coyote.ajp.AjpProtocol Pausing ProtocolHandler ["ajp-bio-8009"]
2018-04-11 18:31:28.995 -0300 INFO: org.apache.catalina.core.StandardService Stopping service Catalina
2018-04-11 18:31:29.047 -0300 INFO: org.tuckey.web.filters.urlrewrite.UrlRewriteFilter destroy called

1 answer

Submitted by antoine.mottier on Wed, 04/10/2019 - 16:05
1
0
-1
This one is the BEST answer!

Hi,

Based on the following lo line: The table 'arch_contract_data' is full
I assume that this is related to database size limitation or disk space usage.

I can find some recommendation regarding MySQL database on a stack overflow post that I think might apply to your situation.

Note that I think issue is not specific to Bonita but is rather a MySQL usage.

Also if you have old process definition and associated instances that you no longer need to archived you might want to disable and remove them in order to free some space.

Notifications