Stash server not allowing SSH connections after a database migration
The following appears in the
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)
Run the following query on your Stash database to check whether the reported table AO_FB71B4_PUBLIC_KEY is present in it:
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.
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;