MySQL Incorrect key file during upgrade

Still need help?

The Atlassian Community is here for you.

Ask the community

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

  1. Roll back the database

  2. Increase tmp_table_size in MySQL
  3. Redo the upgrade
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.