On Sun, May 22, 2011 at 3:13 PM, Afkham Azeez <az...@wso2.com> wrote:

> Like I mentioned earlier, you are not supposed to resolve issues until you
> have committed to the branch.


Noted. I have kept the diff files locally and will attach them to the jira,
apply them to the branch as well and will then resolve the issue.

Thanks,
Hasini.

>
>
> On Sun, May 22, 2011 at 2:28 PM, Hasini Gunasinghe (JIRA) 
> <j...@wso2.org>wrote:
>
>>
>>     [
>> https://wso2.org/jira/browse/CARBON-9881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>>
>> Hasini Gunasinghe resolved CARBON-9881.
>> ---------------------------------------
>>
>>    Resolution: Fixed
>>
>> > Unable to start up server when pointed to the same database when
>> registries are seperated
>> >
>> -----------------------------------------------------------------------------------------
>> >
>> >                 Key: CARBON-9881
>> >                 URL: https://wso2.org/jira/browse/CARBON-9881
>> >             Project: WSO2 Carbon
>> >          Issue Type: Bug
>> >          Components: User Management
>> >    Affects Versions: 3.2.0
>> >         Environment: QA test setup
>> >            Reporter: Ishani Ratnayake
>> >            Assignee: Hasini Gunasinghe
>> >            Priority: Highest
>> >
>> > - Created two database named reg_config_db and reg_gov_db. Used the
>> configuration registry's and Governance registry's user mgmt pointed to
>> reg_config_db.
>> > - Was able to successfully start up the config registry but got the
>> following error when starting up the gov registry with '-Dsetup'
>> > [2011-05-13 10:03:45,015] ERROR
>> {org.wso2.carbon.user.core.internal.Activator} -  Cannot start User Manager
>> Core bundle
>> > java.lang.Exception: Error in creating the database
>> >       at
>> org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:280)
>> >       at
>> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:84)
>> >       at
>> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:117)
>> >       at
>> org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:51)
>> >       at
>> org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:54)
>> >       at
>> org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:782)
>> >       at java.security.AccessController.doPrivileged(Native Method)
>> >       at
>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:773)
>> >       at
>> org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:754)
>> >       at
>> org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:352)
>> >       at
>> org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:370)
>> >       at
>> org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1068)
>> >       at
>> org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:557)
>> >       at
>> org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:464)
>> >       at
>> org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:248)
>> >       at
>> org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:445)
>> >       at
>> org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:220)
>> >       at
>> org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:330)
>> > Caused by: java.lang.Exception: Error occurred while executing :
>> CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
>> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID)
>> >       at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:170)
>> >       at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQLScript(DatabaseCreator.java:323)
>> >       at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:61)
>> >       at
>> org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:274)
>> >       ... 17 more
>> > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>> Duplicate key name 'REG_PATH_IND_BY_PATH_VALUE'
>> >       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 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:3515)
>> >       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
>> >       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
>> >       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
>> >       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
>> >       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
>> >       at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
>> >       at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
>> >       at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
>> >       at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
>> >       at
>> org.wso2.carbon.utils.dbcreator.DatabaseCreator.executeSQL(DatabaseCreator.java:140)
>> >       ... 20 more
>>
>> --
>> This message is automatically generated by JIRA.
>> -
>> If you think it was sent incorrectly contact one of the administrators:
>> https://wso2.org/jira/secure/Administrators.jspa
>> -
>> For more information on JIRA, see: http://www.atlassian.com/software/jira
>>
>>
>> _______________________________________________
>> Carbon-jira mailing list
>> carbon-j...@wso2.org
>> https://wso2.org/cgi-bin/mailman/listinfo/carbon-jira
>>
>
>
>
> --
> *Afkham Azeez*
> Director of Architecture; WSO2, Inc.; http://wso2.com
> Member; Apache Software Foundation; http://www.apache.org/
> * <http://www.apache.org/>**
> email: **az...@wso2.com* <az...@wso2.com>* cell: +94 77 3320919
> blog: **http://blog.afkham.org* <http://blog.afkham.org>*
> twitter: **http://twitter.com/afkham_azeez*<http://twitter.com/afkham_azeez>
> *
> linked-in: **http://lk.linkedin.com/in/afkhamazeez*
> *
> *
> *Lean . Enterprise . Middleware*
>
>
_______________________________________________
Carbon-dev mailing list
Carbon-dev@wso2.org
http://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Reply via email to