Can this be because of defining the idp in sso-idp-config.xml? Thanks & Regards Danushka Fernando Software Engineer WSO2 inc. http://wso2.com/ Mobile : +94716332729
On Wed, Dec 10, 2014 at 12:54 PM, Udara Liyanage <[email protected]> wrote: > > Hi, > > Following error is appearing continuously after a tenant is created. Seems > like UNIQUE (TENANT_ID, NAME)) constraint of the IDP table is violating > since tenantid=1 domain=local is trying to be inserted again and again. > > What could be the issue ? > > *Query getting executed"* > INSERT INTO IDP (TENANT_ID, NAME, IS_PRIMARY, HOME_REALM_ID, CERTIFICATE, > ALIAS, INBOUND_PROV_ENABLED, INBOUND_PROV_USER_STORE_ID, USER_CLAIM_URI, > ROLE_CLAIM_URI,DEFAULT_AUTHENTICATOR_NAME,DEFAULT_PRO_CONNECTOR_NAME, > DESCRIPTION,IS_FEDERATION_HUB,IS_LOCAL_CLAIM_DIALECT,PROVISIONING_ROLE, > IS_ENABLED, DISPLAY_NAME ) VALUES (1, 'LOCAL', '1','localhost',null, null, > '0', null, null, null,null,null, null,'0','0' ,null, '1', null) > 36 Query rollback > 36 Query rollback > > *Constrain:* > UNIQUE (TENANT_ID, NAME)); > > > > [2014-12-10 12:49:01,056] ERROR > {org.wso2.carbon.idp.mgt.internal.TenantManagementListener} - Error when > adding Resident Identity Provider entry for tenant udara.com > org.wso2.carbon.identity.application.common.IdentityApplicationManagementException: > Error occurred while adding Identity Provider for tenant 1 > at > org.wso2.carbon.idp.mgt.dao.IdPManagementDAO.addIdP(IdPManagementDAO.java:1364) > at > org.wso2.carbon.idp.mgt.dao.CacheBackedIdPMgtDAO.addIdP(CacheBackedIdPMgtDAO.java:275) > at > org.wso2.carbon.idp.mgt.IdentityProviderManager.addResidentIdP(IdentityProviderManager.java:325) > at > org.wso2.carbon.idp.mgt.internal.TenantManagementListener.onTenantCreate(TenantManagementListener.java:48) > at > org.wso2.carbon.tenant.mgt.util.TenantMgtUtil.triggerAddTenant(TenantMgtUtil.java:94) > at > org.apache.stratos.manager.publisher.TenantSynzhronizerTask.execute(TenantSynzhronizerTask.java:82) > at > org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:67) > at org.quartz.core.JobRunShell.run(JobRunShell.java:213) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry '1-LOCAL' for key 'TENANT_ID' > at sun.reflect.GeneratedConstructorAccessor89.newInstance(Unknown Source) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > at com.mysql.jdbc.Util.getInstance(Util.java:384) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) > at > org.wso2.carbon.idp.mgt.dao.IdPManagementDAO.addIdP(IdPManagementDAO.java:1300) > ... 13 more > [2014-12-10 12:49:01,057] ERROR > {org.apache.stratos.manager.publisher.TenantSynzhronizerTask} - Could not > publish complete tenant event > org.wso2.carbon.stratos.common.exception.StratosException: Error when > adding Resident Identity Provider entry for tenant udara.com > at > org.wso2.carbon.idp.mgt.internal.TenantManagementListener.onTenantCreate(TenantManagementListener.java:53) > at > org.wso2.carbon.tenant.mgt.util.TenantMgtUtil.triggerAddTenant(TenantMgtUtil.java:94) > at > org.apache.stratos.manager.publisher.TenantSynzhronizerTask.execute(TenantSynzhronizerTask.java:82) > at > org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:67) > at org.quartz.core.JobRunShell.run(JobRunShell.java:213) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > > > > -- > > Udara Liyanage > Software Engineer > WSO2, Inc.: http://wso2.com > lean. enterprise. middleware > > web: http://udaraliyanage.wordpress.com > phone: +94 71 443 6897 > > _______________________________________________ > 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
