Project

General

Profile

Startup error - MessageArchiveDB initialization exception with MySQL

Peter Rajcani
Added over 4 years ago

We get the following error when we start Tigase server v. 7.0.0 Snapshot, user creation and messaging is not affected but message archiving might be. How can this issue be resolved?

Here is the log:

2014-12-29 16:34:07.428 [main]             SimpleCache.<init>()               WARNING:  Tigase cache turned off.
Loading component: amp :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.AmpComponentClustered}
Loading component: bosh :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.BoshConnectionClustered}
Loading component: c2s :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.ClientConnectionClustered}
2014-12-29 16:34:07.911 [main]             ClusterConnectionManager.itemAdded()  WARNING: Incorrect ClusterRepoItem, skipping connection attempt: hostname.com:b03f96081c403943626a1157a08791d7aa6edc0905b9cbe1caa213734e8873b5:5277:0:0.0:0.0
Loading component: cl-comp :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.ClusterConnectionManager}
Loading component: http :: componentInfo{Title=Tigase HTTP API component: Tigase HTTP API component, Version=1.1.0-SNAPSHOT-b79/7a03f72a, Class=tigase.http.HttpMessageReceiver}
2014-12-29 16:34:10.233 [main]             JDBCMessageArchiveRepository.initRepository()  WARNING: MessageArchiveDB initialization exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect table definition; there can be only one auto column and it must be defined as a key
                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
                at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
                at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                at com.mysql.jdbc.Util.getInstance(Util.java:381)
                at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
                at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
                at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
                at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
                at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
                at tigase.db.jdbc.DataRepositoryImpl.checkTable(DataRepositoryImpl.java:154)
                at tigase.db.DataRepositoryPool.checkTable(DataRepositoryPool.java:133)
                at tigase.archive.db.JDBCMessageArchiveRepository.initRepository(JDBCMessageArchiveRepository.java:395)
                at tigase.archive.MessageArchiveComponent.setProperties(MessageArchiveComponent.java:216)
                at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:580)
                at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:183)
                at tigase.conf.Configurator.componentAdded(Configurator.java:50)
                at tigase.conf.Configurator.componentAdded(Configurator.java:33)
                at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)
                at tigase.server.MessageRouter.addComponent(MessageRouter.java:108)
                at tigase.server.MessageRouter.addRouter(MessageRouter.java:145)
                at tigase.server.MessageRouter.setProperties(MessageRouter.java:807)
                at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java:580)
                at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java:183)
                at tigase.conf.Configurator.componentAdded(Configurator.java:50)
                at tigase.conf.Configurator.componentAdded(Configurator.java:33)
                at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java:116)
                at tigase.server.MessageRouter.addRegistrator(MessageRouter.java:131)
                at tigase.server.MessageRouter.setConfig(MessageRouter.java:700)
                at tigase.server.XMPPServer.start(XMPPServer.java:142)
                at tigase.server.XMPPServer.main(XMPPServer.java:112)
Loading component: message-archive :: componentInfo{Title=Tigase Message Archiving Component, Version=1.1.0-SNAPSHOT-b64/1a633bf2, Class=tigase.archive.MessageArchiveComponent}
Loading component: monitor :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.MonitorClustered}
2014-12-29 16:34:10.484 [main]             SimpleCache.<init>()               WARNING:  Tigase cache turned off.
Loading component: muc :: componentInfo{Title=Tigase MUC, Version=2.3.0-SNAPSHOT-b388/103c189a, Class=tigase.muc.MUCComponent}
Loading component: proxy :: componentInfo{Title=Tigase Socks5 Component, Version=1.1.0-SNAPSHOT-b47/4f9eea85, Class=tigase.socks5.Socks5ProxyComponent}
2014-12-29 16:34:11.141 [main]             SimpleCache.<init>()               WARNING:  Tigase cache turned off.
Loading component: pubsub :: componentInfo{Title=Tigase PubSub, Version=3.1.0-SNAPSHOT-b454/dbe16c8c, Class=tigase.pubsub.PubSubComponent}
Loading component: s2s :: componentInfo{Title=Tigase XMPP Server, Version=7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10), Class=tigase.cluster.S2SConnectionClustered}
Loading plugin: session-close=4:1165 ...                 , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: session-open=4:1165 ...                 , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: default-handler=4:1165 ...            , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:register=4:1165 ...         , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:auth=4:1165 ...               , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: urn:ietf:params:xml:ns:xmpp-sasl=4:1165 ...        , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: urn:ietf:params:xml:ns:xmpp-bind=4:1165 ...      , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: urn:ietf:params:xml:ns:xmpp-session=4:1165 ...                , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:roster=8:582 ...              , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:privacy=4:1165 ...          , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:version=4:1165 ...         , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: http://jabber.org/protocol/stats=4:1165 ...          , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: starttls=4:1165 ...              , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: vcard-temp=4:1165 ...    , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: http://jabber.org/protocol/commands=4:1165 ...             , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: jabber:iq:private=4:1165 ...          , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: urn:xmpp:ping=4:1165 ...              , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: presence=8:582 ...           , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: disco=4:1165 ... , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: zlib=4:1165 ...     , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: amp=4:1165 ...   , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)
Loading plugin: message-carbons=4:1165 ...        , version: 7.0.0-SNAPSHOT-b3736/ee746353 (2014-12-24/01:12:10)

Replies (3)

Added by Andrzej Wójcik IoT 1 CloudTigaseTeam over 4 years ago

You are right there was an issue in SQL for MySQL used to created tables to store messages for Message Archiving which made it impossible to create tables properly, so it affected message archiving. I fixed this issue and fix for it will be released as next SNAPSHOT of Tigase XMPP Server 7.0.0 - I think it should be released tomorrow.

Added by Peter Rajcani over 4 years ago

Thanks for the response. Will this fix be available in the planned 7.0.0 release in mid January?

Added by Andrzej Wójcik IoT 1 CloudTigaseTeam over 4 years ago

It should already be included in current SNAPSHOT version of 7.0.0 release so it will be part of 7.0.0 release in mid January.

    (1-3/3)