проблемы с openfire
Добавлено: 2014-03-17 10:48:47
При запуске вываливается (в логе error):
При этом пользователи не могут какое-то время войти в чат, а админы попасть в админку. через минут 10 все нормально.
Системная информация:
Код: Выделить всё
2014.03.17 09:34:53 org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
CREATE TABLE ofGatewayRegistration ( registrationID BIGINT NOT NULL, jid VARCHAR(25
2014.03.17 09:34:53 org.jivesoftware.database.SchemaManager - Table 'ofGatewayRegistration' already exists
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'ofGatewayRegistration' already exists
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.execute(PreparedStatement.java:882)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Statement$$EnhancerByProxool$$1f130c30.execute(<generated>)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:408)
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:244)
at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:136)
at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java:452)
at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java:80)
at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManager.java:1073)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecu
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.jav
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
2014.03.17 09:34:53 org.jivesoftware.openfire.container.PluginManager - kraken - База данных коррекции терпела неуд
2014.03.17 09:34:54 org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
CREATE TABLE ofPfRules ( id BIGINT NOT NULL AUTO_INCREMENT, ruleorder BIGINT ,
2014.03.17 09:34:54 org.jivesoftware.database.SchemaManager - Table 'ofPfRules' already exists
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'ofPfRules' already exists
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.execute(PreparedStatement.java:882)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Statement$$EnhancerByProxool$$1f130c30.execute(<generated>)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:408)
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:244)
at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:136)
at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java:452)
at org.jivesoftware.openfire.container.PluginManager.access$300(PluginManager.java:80)
at org.jivesoftware.openfire.container.PluginManager$PluginMonitor.run(PluginManager.java:1073)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecu
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.jav
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
Системная информация:
Код: Выделить всё
FreeBSD jabber.***.*** 9.1-RELEASE-p10 FreeBSD 9.1-RELEASE-p10 #0: Sun Jan 12 10:32:09 UTC 2014 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC i386