MySQL Incorrect key file during upgrade
Symptoms
Upgrade fails with the following appears in the atlassian-fisheye-<date>.log
:
2013-06-14 18:15:00,086 ERROR - The Web context could not be started
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbControlFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /srv/atlassian/fisheye/sql/MYSQL/upgrade/upgrade_81.sql: Incorrect key file for table '/tmp/#sql_69b_0.MYI'; try to repair it
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
Cause
MySQL temporary table size has been full.
Resolution
Roll back the database
- Increase tmp_table_size in MySQL
- Redo the upgrade
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.