Projects tigase _server tigase-muc Issues #46
Issues with Derby schema in latest versions (#46)
Closed
wojciech.kapcia@tigase.net opened 1 decade ago
Aug 6, 2013 9:38:03 AM tigase.muc.history.DerbySqlHistoryProvider init
WARNING: Initializing problem
java.sql.SQLSyntaxErrorException: The number of values assigned is not the same as the number of specified or implied columns.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
        at tigase.db.jdbc.DataRepositoryImpl.prepareQuery(DataRepositoryImpl.java)
        at tigase.db.jdbc.DataRepositoryImpl.initStatement(DataRepositoryImpl.java)
        at tigase.db.jdbc.DataRepositoryImpl.initPreparedStatement(DataRepositoryImpl.java)
        at tigase.db.DataRepositoryPool.initPreparedStatement(DataRepositoryPool.java)
        at tigase.muc.history.DerbySqlHistoryProvider.internalInit(DerbySqlHistoryProvider.java)
        at tigase.muc.history.DerbySqlHistoryProvider.init(DerbySqlHistoryProvider.java)
        at tigase.muc.MUCComponent.setProperties(MUCComponent.java)
        at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java)
        at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java)
        at tigase.conf.Configurator.componentAdded(Configurator.java)
        at tigase.conf.Configurator.componentAdded(Configurator.java)
        at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
        at tigase.server.MessageRouter.addComponent(MessageRouter.java)
        at tigase.server.MessageRouter.addRouter(MessageRouter.java)
        at tigase.server.MessageRouter.setProperties(MessageRouter.java)
        at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java)
        at tigase.conf.Configurator.updateMessageRouter(Configurator.java)
        at tigase.osgi.ModulesManagerImpl.update(ModulesManagerImpl.java)
        at tigase.muc.Activator.registerAddons(Activator.java)
        at tigase.muc.Activator.serviceChanged(Activator.java)
Aug 6, 2013 9:38:03 AM tigase.muc.history.DerbySqlHistoryProvider init
WARNING: Can't initialize muc history
java.sql.SQLException: Table/View 'MUC_HISTORY' already exists in Schema 'APP'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at tigase.muc.history.DerbySqlHistoryProvider.init(DerbySqlHistoryProvider.java)
        at tigase.muc.MUCComponent.setProperties(MUCComponent.java)
        at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java)
        at tigase.conf.ConfiguratorAbstract.componentAdded(ConfiguratorAbstract.java)
        at tigase.conf.Configurator.componentAdded(Configurator.java)
        at tigase.conf.Configurator.componentAdded(Configurator.java)
        at tigase.server.AbstractComponentRegistrator.addComponent(AbstractComponentRegistrator.java)
        at tigase.server.MessageRouter.addComponent(MessageRouter.java)
        at tigase.server.MessageRouter.addRouter(MessageRouter.java)
        at tigase.server.MessageRouter.setProperties(MessageRouter.java)
        at tigase.conf.ConfiguratorAbstract.setup(ConfiguratorAbstract.java)
        at tigase.conf.Configurator.updateMessageRouter(Configurator.java)
Bartosz MaƂkowski commented 1 decade ago

I have no idea what is wrong. Code looks good.

It seems that old muc_history is in database. Queries doesn't match to it and new table can't be created.

wojciech.kapcia@tigase.net commented 1 decade ago

One parameter was missing.

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
RedmineID
1448
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-muc#46
Please wait...
Page is in error, reload to recover