I received an error while upgrading the QIE instance on MySQL

Question

While upgrading QIE to the latest version I received an error:

2015-03-26 12:09:29,781 EDT [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: alter table message_queue add column error_form_id varchar(32)

2015-03-26 12:09:29,781 EDT [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Incorrect key file for table 'message_queue'; try to repair it

 

What should I do?

Answer 1

When adding a column to the database MySQL and Mariadb have to build the table as a temp table.  This requires that you have enough disk space on your system to contain a full copy of the table.

You need to check the location of the temp tables in your my.ini file.  Information regarding this can be found here:

https://dev.mysql.com/doc/refman/5.0/en/temporary-files.html

If you do not have the temp directory specified, then under windows, MySQL will default to 'C:\Windows\Temp'.

So, If you have a table that is 20G in size, and you want to add a column, you need to have a minimum of 20G on the drive configured for the temp tables.