Fixed in r162752. Thanks, Johann.
On Thu, Feb 21, 2013 at 5:26 PM, Dinusha Senanayaka <[email protected]>wrote: > Hi , > > Server can be start only once.. Once you stop the server, it cannot be > start again at all. Throws the following exception.. Any idea ? > > [2013-02-21 17:11:18,523] ERROR - DatabaseUtil Unique index or primary key > violation: "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, > UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key > violation: "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, > UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098) > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:353) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doUpdateRoleListOfUser(JDBCUserStoreManager.java:1573) > at > org.wso2.carbon.user.core.common.AbstractUserStoreManager.updateRoleListOfUser(AbstractUserStoreManager.java:1241) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.addInitialAdminData(JDBCUserStoreManager.java:2041) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:216) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at > org.wso2.carbon.user.core.common.DefaultRealm.createObjectWithOptions(DefaultRealm.java:238) > at > org.wso2.carbon.user.core.common.DefaultRealm.initializeObjects(DefaultRealm.java:147) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:113) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:389) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1130) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: > "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, UM_ROLE_ID, > UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:157) > at org.h2.index.PageBtree.find(PageBtree.java:121) > at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138) > at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:93) > at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:90) > at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:81) > at org.h2.table.RegularTable.addRow(RegularTable.java:116) > at org.h2.command.dml.Insert.insertRows(Insert.java:120) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1080) > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:353) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doUpdateRoleListOfUser(JDBCUserStoreManager.java:1573) > at > org.wso2.carbon.user.core.common.AbstractUserStoreManager.updateRoleListOfUser(AbstractUserStoreManager.java:1241) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.addInitialAdminData(JDBCUserStoreManager.java:2041) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:216) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at > org.wso2.carbon.user.core.common.DefaultRealm.createObjectWithOptions(DefaultRealm.java:238) > at > org.wso2.carbon.user.core.common.DefaultRealm.initializeObjects(DefaultRealm.java:147) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:113) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:389) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1130) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > [2013-02-21 17:11:18,542] ERROR - DatabaseUtil Using sql : INSERT INTO > UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES ((SELECT UM_ID > FROM UM_ROLE WHERE UM_ROLE_NAME=? AND UM_TENANT_ID=?),(SELECT UM_ID FROM > UM_USER WHERE UM_USER_NAME=? AND UM_TENANT_ID=?), ?) > [2013-02-21 17:11:18,542] ERROR - JDBCUserStoreManager Unique index or > primary key violation: "CONSTRAINT_INDEX_BA ON > PUBLIC.UM_USER_ROLE(UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > org.wso2.carbon.user.core.UserStoreException: Unique index or primary key > violation: "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, > UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:364) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doUpdateRoleListOfUser(JDBCUserStoreManager.java:1573) > at > org.wso2.carbon.user.core.common.AbstractUserStoreManager.updateRoleListOfUser(AbstractUserStoreManager.java:1241) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.addInitialAdminData(JDBCUserStoreManager.java:2041) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:216) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at > org.wso2.carbon.user.core.common.DefaultRealm.createObjectWithOptions(DefaultRealm.java:238) > at > org.wso2.carbon.user.core.common.DefaultRealm.initializeObjects(DefaultRealm.java:147) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:113) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:389) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1130) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary > key violation: "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, > UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098) > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:353) > ... 31 more > [2013-02-21 17:11:18,546] ERROR - DefaultRealm Cannot create > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager > java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at > org.wso2.carbon.user.core.common.DefaultRealm.createObjectWithOptions(DefaultRealm.java:238) > at > org.wso2.carbon.user.core.common.DefaultRealm.initializeObjects(DefaultRealm.java:147) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:113) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:389) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1130) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: org.wso2.carbon.user.core.UserStoreException: Unique index or > primary key violation: "CONSTRAINT_INDEX_BA ON > PUBLIC.UM_USER_ROLE(UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doUpdateRoleListOfUser(JDBCUserStoreManager.java:1591) > at > org.wso2.carbon.user.core.common.AbstractUserStoreManager.updateRoleListOfUser(AbstractUserStoreManager.java:1241) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.addInitialAdminData(JDBCUserStoreManager.java:2041) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.<init>(JDBCUserStoreManager.java:216) > ... 27 more > Caused by: org.wso2.carbon.user.core.UserStoreException: Unique index or > primary key violation: "CONSTRAINT_INDEX_BA ON > PUBLIC.UM_USER_ROLE(UM_USER_ID, UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:364) > at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doUpdateRoleListOfUser(JDBCUserStoreManager.java:1573) > ... 30 more > Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary > key violation: "CONSTRAINT_INDEX_BA ON PUBLIC.UM_USER_ROLE(UM_USER_ID, > UM_ROLE_ID, UM_TENANT_ID)"; SQL statement: > INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [23001-140] > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098) > at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:353) > > > Regards, > Dinusha. > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
