Upgrade to 9.81

stuart_harrop
New Contributor II

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.

0 REPLIES 0