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.