Страница 1 из 1

проблемы с openfire

Добавлено: 2014-03-17 10:48:47
nikodim
При запуске вываливается (в логе error):

Код: Выделить всё

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)
При этом пользователи не могут какое-то время войти в чат, а админы попасть в админку. через минут 10 все нормально.
Системная информация:

Код: Выделить всё

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