Stash server not allowing SSH connections after a database migration
Symptoms
The following appears in the atlassian-stash.log:
2013-10-16 20:58:20,487 WARN [NioProcessor-4] net.java.ao.db.MySQLDatabaseProvider Error in schema creation: Can't create table '#sql-7f7_812c8' (errno: 13); attempting to roll back last partially generated table 2013-10-16 20:58:20,611 ERROR [NioProcessor-5] net.java.ao.sql Exception executing SQL update <ALTER TABLE AO_FB71B4_PUBLIC_KEY CHANGE COLUMN KEY_TEXT KEY_TEXT LONGTEXT NOT NULL> java.sql.SQLException: Can't create table '#sql-7f7_812c5' (errno: 13)Diagnosis
Run the following query on your Stash database to check whether the reported table AO_FB71B4_PUBLIC_KEY is present in it:
show tables;
Cause
Stash is unable to create the 'AO_FB71B4_PUBLIC_KEY' table, though as per the list of tables in your database, this table is already present and hence the process failing when it tries to create it again.
Workaround
To help workaround this, you can drop this table from the database. Ensure that Stash is shut down and that you have a complete database backup prior to attempting this. The table will be automatically recreated when you restart Stash:
drop table AO_FB71B4_PUBLIC_KEY;
Last modified on Feb 23, 2016
Powered by Confluence and Scroll Viewport.