OPenfire 3.5.2->3.6.0a upgrade fails

We’re using debian etch and MySQL and openfire upgrade fails. We had to restore the MySQL database from backup and reinstall

3.5.2 to get the server back up. Does anyone have a way to get this upgrade done or should we just wait for 3.6.1?

Thanks in advance,

James

Hi James,

Did openfire log any errors when the upgrade scripts failed?

daryl

We use Openfire in a production environment and had to get it back online as soon as possible. If it logged anything, we didn’t take time to look and restored from backup to return our jabber server to service.

Ward… James Ward

jeward@torzo.commailto:jeward@torzo.com

Linux Sysadmin

(520) 290-0910x268

ICQ: 201663408

I just tried upgrading ours and it failed…

Now I’m stuck as I’m not a sql person, lol…

Tomorrow morning should be really interesting

Same issue here on Ubuntu with mysql. I’m upgrading all the way from 3.3.2 but it’s failing at script 19.

error.log for us says:

2008.09.19 09:26:59 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:383)] SchemaManager: Failed to execute SQL:
ALTER TABLE jiveUser DROP INDEX jiveUser_cDate_idx;
2008.09.19 09:26:59 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:273)]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.jiveUser' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
        at com.mysql.jdbc.Statement.execute(Statement.java:727)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.Statement$$EnhancerByProxool$$116b4e2a.execute()
        at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:378)
        at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:270)
        at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java:71)
        at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:498)
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:79)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties.java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
        at com.install4j.runtime.Launcher.main(Unknown Source)
2008.09.19 09:26:59 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofProperty' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.PreparedStatement$$EnhancerByProxool$$98257d76.executeQuery()
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:337)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties.java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
        at com.install4j.runtime.Launcher.main(Unknown Source)
2008.09.19 09:26:59 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:709)] Database could not be accessed
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.PreparedStatement$$EnhancerByProxool$$98257d76.executeQuery()
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
        at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
        at com.install4j.runtime.Launcher.main(Unknown Source)
2008.09.19 09:26:59 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)]
java.lang.IllegalArgumentException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
        at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
        at com.install4j.runtime.Launcher.main(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.ofID' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.PreparedStatement$$EnhancerByProxool$$98257d76.executeQuery()
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
        ... 16 more