Exception executing SQL update .. java.sql.SQLException: Error writing file (Errcode: 28)

Troubleshooting Databases

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

The following appears in the logs

2014-08-11 12:33:24,370 ERROR [active-objects-ddl-0]  net.java.ao.sql Exception executing SQL update <ALTER TABLE AO_FB71B4_SSH_PUBLIC_KEY CHANGE COLUMN KEY_TEXT KEY_TEXT LONGTEXT NOT NULL>
java.sql.SQLException: Error writing file './stash/#sql-317d_84.frm' (Errcode: 28)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725) ~[mysql-connector-java-5.1.24-bin.jar:na]
	at com.jolbox.bonecp.StatementHandle.executeUpdate(StatementHandle.java:536) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2309) [activeobjects-plugin-0.25.2.jar:na]
	at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2379) [activeobjects-plugin-0.25.2.jar:na]
	at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2342) [activeobjects-plugin-0.25.2.jar:na]
	at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99) [activeobjects-plugin-0.25.2.jar:na]
	at net.java.ao.EntityManager.migrate(EntityManager.java:128) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:48) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:65) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:59) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25) [sal-core-2.11.0.jar:na]
	at com.atlassian.stash.internal.sal.spi.HostContextAccessorImpl.doInTransaction(HostContextAccessorImpl.java:27) [stash-platform-3.0.4.jar:na]
	at com.sun.proxy.$Proxy197.doInTransaction(Unknown Source) [na:na]
	at com.sun.proxy.$Proxy279.doInTransaction(Unknown Source) [na:na]
	at com.sun.proxy.$Proxy484.doInTransaction(Unknown Source) [na:na]
	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21) [sal-core-2.11.0.jar:na]
	at com.sun.proxy.$Proxy382.execute(Unknown Source) [na:na]
	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:58) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:40) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.createActiveObjects(ActiveObjectsServiceFactory.java:160) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.access$1100(ActiveObjectsServiceFactory.java:51) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:224) [activeobjects-plugin-0.25.2.jar:na]
	at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:216) [activeobjects-plugin-0.25.2.jar:na]
	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_65]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_65]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65]
	... 54 frames trimmed

Cause

MySQL database reports Error code 28, which seems to relate to the disk being full: http://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28.

Resolution

Resolution is as simple as freeing up more space on your MySQL server

Last modified on Mar 30, 2016

Was this helpful?

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