Openfire Upgrade from 3.5.2. to 3.6 Fails

David_Thor · August 27, 2008, 12:43pm

This is the Startup log:

Found old database version 16 for openfire. Upgrading to version 20…
SchemaManager: Failed to execute SQL:
CREATE TABLE mucService ( serviceID INT NOT NULL, subdomain NVARCHAR(255) NOT NULL, description NVARCHAR(255), CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
java.sql.SQLException: There is already an object named ‘mucService’ in the database.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1157)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$d0d7356b.execute()
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)

java.sql.SQLException: Invalid object name ‘ofProperty’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
Database could not be accessed
java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)

java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name ‘ofID’.
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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 more
java.lang.IllegalArgumentException: java.sql.SQLException: Invalid object name ‘ofID’.
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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)
Caused by: java.sql.SQLException: Invalid object name ‘ofID’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:777)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$579164b7.executeQuery()
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
… 16 moEre

rror starting the server. Please check the log files for more information.
Server halted

NO_MESSAGES_OR_FRIEN · August 27, 2008, 12:52pm

Are you using LDAP? Even if you are not try this:

stop your server
edit your openfire.xml file setup tag to read false.
start server
go to admin page and step throught the config again.

David_Thor · August 27, 2008, 12:59pm

I did try the setup. In fact we almost always run through the setup as part of an upgrade. This time it stops on the DB screen with an error of:

The Openfire database schema does not appear to be installed. Follow the installation guide to fix this error.

kari_kimber · August 27, 2008, 1:30pm

I have a same problem.

kero · August 27, 2008, 1:42pm

same here

kero · August 27, 2008, 2:33pm

I downgraded

dpkg -i openfire_3.5.2_all.deb

and everything works fine again.

Daniel_Henninger · August 27, 2008, 3:00pm

Good lord, it sounds like there are some leftover tables hanging around that it’s conflicting with. You downgraded and it’s working fine? Did you restore your db from a previous version? I would think the db would be in a fairly confused state at the moment if you partially upgraded and then stopped.

Daniel_Henninger · August 27, 2008, 3:01pm

So both of you are using the embedded db and seeing this?

David_Thor · August 27, 2008, 3:05pm

Our database is runnoing on MSFT SQL

kero · August 27, 2008, 3:06pm

Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

greetings

kero

Daniel_Henninger · August 27, 2008, 3:08pm

dthor wrote:

Our database is runnoing on MSFT SQL

What? =) What is that?

David_Thor · August 27, 2008, 3:09pm

We use LDAP via Active Direcotyr… i just dropped back to 3.5.2 and used the DB backup and most everything seems fins. I ca’nt find the old version of rhte gateway .jar… the new one says it only works with 3.6

Daniel_Henninger · August 27, 2008, 3:35pm

Hrm. I’ve attached a copy of the last released gateway.jar before this one.
gateway.jar (1188765 Bytes)

Daniel_Henninger · August 27, 2008, 3:35pm

But what is MSFT SQL?

Daniel_Henninger · August 27, 2008, 3:36pm

kero wrote:

Im using ldap (readonly) for user authentification and the embedded DB from openfire. I just reinstalled the 3.5.2 version, no DB restoring.

greetings

kero

Interesting. It sounds like the old tables are still present, or nothing got renamed, or something. scratch head

David_Thor · August 27, 2008, 3:40pm

SQL Server… Microsoft SQL

Daniel_Henninger · August 27, 2008, 4:17pm

dthor wrote:

SQL Server… Microsoft SQL

I’ve been told that there’s a bug in script 19 for SQL server:

In upgrade script 19
Line 60 - ofUserFlag should be ofRoster
Line 140 - mucRoom__pk should be mucRoom_pk

Artur_Nowak · August 27, 2008, 4:59pm

But it doesn’t help to problem with upgrade and error:

SchemaManager: Failed to execute SQL:
CREATE TABLE mucService ( serviceID INT NOT NULL, subdomain NVARCHAR(255) NOT NULL, description NVARCHAR(255), CONSTRAINT mucService_pk PRIMARY KEY (subdomain) );
java.sql.SQLException: There is already an object named ‘mucService’ in the database.
…

i’am using Widows version of OpenFire and MSSQL

Please help

Daniel_Henninger · August 27, 2008, 5:01pm

Hrm. It looks like one of the upgrades partially succeeded and so now there are conflicting tables. Can you get a list of the tables in your db and paste them here (not the contents, just the table names)

Artur_Nowak · August 27, 2008, 5:05pm

yes, there is list of openfire database tables:

Name Owner Type Create Date
dtproperties dbo System 2006-07-26 10:42:23
jiveExtComponentConf dbo User 2006-07-25 17:45:33
jiveGroup dbo User 2006-07-25 17:45:33
jiveGroupProp dbo User 2006-07-25 17:45:33
jiveGroupUser dbo User 2006-07-25 17:45:33
jiveID dbo User 2006-07-25 17:45:33
jiveOffline dbo User 2006-07-25 17:45:33
jivePresence wildfire User 2007-02-13 18:36:55
jivePrivacyList dbo User 2006-07-25 17:45:33
jivePrivate dbo User 2006-07-25 17:45:33
jiveProperty dbo User 2006-07-25 17:45:33
jiveRemoteServerConf dbo User 2006-07-25 17:45:33
jiveRoster dbo User 2006-07-25 17:45:33
jiveRosterGroups dbo User 2006-07-25 17:45:33
jiveSASLAuthorized dbo User 2006-07-25 17:45:33
jiveSecurityAuditLog wildfire User 2008-04-23 17:32:33
jiveUser dbo User 2006-07-25 17:45:33
jiveUserFlag wildfire User 2008-04-23 17:32:33
jiveUserProp dbo User 2006-07-25 17:45:33
jiveVCard dbo User 2006-07-25 17:45:33
jiveVersion dbo User 2006-07-25 17:45:33
mucAffiliation dbo User 2006-07-25 17:45:33
mucConversationLog dbo User 2006-07-25 17:45:33
mucMember dbo User 2006-07-25 17:45:33
mucRoom dbo User 2006-07-25 17:45:33
mucRoomProp dbo User 2006-07-25 17:45:33
mucService wildfire User 2008-08-27 18:37:25
mucServiceProp wildfire User 2008-08-27 18:37:25
pubsubAffiliation dbo User 2006-07-25 17:45:33
pubsubDefaultConf dbo User 2006-07-25 17:45:33
pubsubItem dbo User 2006-07-25 17:45:33
pubsubNode dbo User 2006-07-25 17:45:33
pubsubNodeGroups dbo User 2006-07-25 17:45:33
pubsubNodeJIDs dbo User 2006-07-25 17:45:33
pubsubSubscription dbo User 2006-07-25 17:45:33
syscolumns dbo System 2000-08-06 01:29:12
syscomments dbo System 2000-08-06 01:29:12
sysdepends dbo System 2000-08-06 01:29:12
sysfilegroups dbo System 2000-08-06 01:29:12
sysfiles dbo System 2000-08-06 01:29:12
sysfiles1 dbo System 2000-08-06 01:29:12
sysforeignkeys dbo System 2000-08-06 01:29:12
sysfulltextcatalogs dbo System 2000-08-06 01:29:12
sysfulltextnotify dbo System 2000-08-06 01:29:12
sysindexes dbo System 2000-08-06 01:29:12
sysindexkeys dbo System 2000-08-06 01:29:12
sysmembers dbo System 2000-08-06 01:29:12
sysobjects dbo System 2000-08-06 01:29:12
syspermissions dbo System 2000-08-06 01:29:12
sysproperties dbo System 2000-08-06 01:29:12
sysprotects dbo System 2000-08-06 01:29:12
sysreferences dbo System 2000-08-06 01:29:12
systypes dbo System 2000-08-06 01:29:12
sysusers dbo System 2000-08-06 01:29:12