FYI we just ran into an issue with our upgrade from 9.8 to 9.81. With 9.81 there is an attempt to add an index to jss_access_logs for the timestamp_epoch column.
The thing is that our database already had that index and thus failed out when the JSS started back up. Presenting us with this message;
There was an error updating the database schema. Contact JAMF Software Support.
Resolution was to drop the index and restart tomcat. After making a backup of course.
drop index timestamp_epoch on jss_access_logs;
JAMFSoftwareServer.log
Duplicate key name 'timestamp_epoch':ALTER TABLE jss_access_logs ADD INDEX timestamp_epoch (timestamp_epoch)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'timestamp_epoch'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)
at com.jamfsoftware.jss.database.ThreeByteUtf8CompatiblePreparedStatement.executeUpdate(ThreeByteUtf8CompatiblePreparedStatement.java:54)
at com.jamfsoftware.jss.database.DataSource.execute(DataSource.java:581)
at com.jamfsoftware.jss.database.schema.TableMySQL.alterTablePerformNonDropAlters(TableMySQL.java:428)
at com.jamfsoftware.jss.database.schema.VerifyDatabaseSchema.Verify(VerifyDatabaseSchema.java:255)
at com.jamfsoftware.jss.server.initialization.InitializeServerThread.run(InitializeServerThread.java:238)
at java.lang.Thread.run(Unknown Source)
2015-09-30 17:29:17,893 [FATAL] [Thread-3 ] [InitializeServerThread ] - Fatal error logged during server initialization: There was an error updating the database schema. Contact JAMF Software Support.
