Openfire Wizard at startup

Hi, I’ve had a few issues with OpenFire and finally got it to start, happy days.

However, the Wizard is now starting every time. I checked the openfire.xml but there isn’t true but I do have a file openfiredemoboot.xml that has it. Changed it there but still booting with the Wizard.

If anyone could help me that would be amazing. Been banging my head for a few hours now.

Tks ;o)

After the initial setup wizard runs, it modified the openfire.xml file to persist some changes (and indicate that the wizard does not need to run again). It appears that Openfire is unable to change that file. Ninety nine out of a hundred times, that is caused by a file permission issue. Make sure that the user that is running Openfire has permissions to create and update files in the Openfire installation directory.

Tks Guus,

I should have been more specific. While I was having other issues it did an OpenFire update which I believe has create this issue. However the database already exists and user have been using OpenFire for over a year. Ideally I’d like to reuse the “old” database.

If not possible, how can I just remove the old embedded Database as I’m getting this error message when running the wizard again

"Choose how you would like to connect to the Openfire database.

A connection to the database could not be made. View the error message by opening the “/logs/error.log” log file,

error.log

hsqldb.db.HSQLDB7C340C8E47.ENGINE - could not reopen database
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:38 hsqldb.db.HSQLDB7C340C8E47.ENGINE - bad line in script file 229
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:38 hsqldb.db.HSQLDB7C340C8E47.ENGINE - could not reopen database
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:38 hsqldb.db.HSQLDB7C340C8E47.ENGINE - bad line in script file 229
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:38 hsqldb.db.HSQLDB7C340C8E47.ENGINE - could not reopen database
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:39 hsqldb.db.HSQLDB7C340C8E47.ENGINE - bad line in script file 229
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:39 hsqldb.db.HSQLDB7C340C8E47.ENGINE - could not reopen database
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:39 hsqldb.db.HSQLDB7C340C8E47.ENGINE - bad line in script file 229
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more
2022.12.14 13:59:39 hsqldb.db.HSQLDB7C340C8E47.ENGINE - could not reopen database
org.hsqldb.HsqlException: error in script file line: 229 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.getError(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.processScript(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Log.open(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.persist.Logger.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.reopen(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.Database.open(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.DatabaseManager.newSession(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) [hsqldb-2.4.1.jar:2.4.1]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_352]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_352]
	at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:355) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:889) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:424) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:349) [commons-pool2-2.6.2.jar:2.6.2]
	at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) [commons-dbcp2-2.6.0.jar:2.6.0]
	at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:171) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.isSetupMode(JiveGlobals.java:1239) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:536) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.util.JiveGlobals.getIntProperty(JiveGlobals.java:605) [xmppserver-4.6.4.jar:4.6.4]
	at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask.run(PluginMonitor.java:396) [xmppserver-4.6.4.jar:4.6.4]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_352]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_352]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_352]
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB7C340C8E47
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
	... 33 more

I’m not sure what’s going on there. Did the database get corrupted somehow? Can you restore it from a backup, to see if that works better?

“Removing the database” will remove pretty much all state. Instead of doing that manually, you might as well completely uninstall / remove Openfire, and reinstall it completely, if it comes to that.