Hi Kasun,
We have updated h2 database from 1.2.140 to 1.3.176 and that would be the
root cause for the exception. We need to dig a bit and look into the schema
restrictions introduced in h2.
@Manuri, thanks for the clarification.
@Madhawa, sorry I misunderstood your point at the first place.
On Thu, Aug 25, 2016 at 12:47 PM, Kasun Bandara <kas...@wso2.com> wrote:
> Hi Kalpa,
>
> When we running the IS integration tests, we encountered the following
> issue upon restarting the sever. This is reproducible with the following
> sequence in a fresh pack which built top of kernel 4.4.9.
>
> 1) Start up the server
> 2) Shutdown the server
> 3) Restart the server
>
> 2016-08-25 11:31:35,677] ERROR {org.wso2.carbon.user.core.util.DatabaseUtil}
> - Database Error - Unique index or primary key violation: "PRIMARY KEY ON
> """".PAGE_INDEX"; SQL statement:
> ALTER TABLE PUBLIC.IDN_OAUTH2_ACCESS_TOKEN_SCOPE ADD CONSTRAINT
> PUBLIC.CONSTRAINT_B1A FOREIGN KEY(TOKEN_ID) REFERENCES
> PUBLIC.IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE NOCHECK
> [23505-176]
> org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
> "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
> ALTER TABLE PUBLIC.IDN_OAUTH2_ACCESS_TOKEN_SCOPE ADD CONSTRAINT
> PUBLIC.CONSTRAINT_B1A FOREIGN KEY(TOKEN_ID) REFERENCES
> PUBLIC.IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE NOCHECK
> [23505-176]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
> at org.h2.message.DbException.get(DbException.java:178)
> at org.h2.message.DbException.get(DbException.java:154)
> at org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageD
> ataIndex.java:166)
> at org.h2.index.PageDataIndex.add(PageDataIndex.java:144)
> at org.h2.store.PageStore.addMeta(PageStore.java:1808)
> at org.h2.index.PageBtreeIndex.<init>(PageBtreeIndex.java:64)
> at org.h2.table.RegularTable.addIndex(RegularTable.java:235)
> at org.h2.command.ddl.AlterTableAddConstraint.createIndex(Alter
> TableAddConstraint.java:280)
> at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTa
> bleAddConstraint.java:205)
> at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTable
> AddConstraint.java:73)
> at org.h2.engine.MetaRecord.execute(MetaRecord.java:59)
> at org.h2.engine.Database.open(Database.java:719)
> at org.h2.engine.Database.openDatabase(Database.java:260)
> at org.h2.engine.Database.<init>(Database.java:254)
> at org.h2.engine.Engine.openSession(Engine.java:57)
> at org.h2.engine.Engine.openSession(Engine.java:164)
> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142)
> at org.h2.engine.Engine.createSession(Engine.java:125)
> at org.h2.engine.Engine.createSession(Engine.java:27)
> at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionR
> emote.java:331)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91)
> at org.h2.Driver.connect(Driver.java:74)
> at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(
> PooledConnection.java:278)
> at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledC
> onnection.java:182)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(
> ConnectionPool.java:701)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(
> ConnectionPool.java:635)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(Con
> nectionPool.java:188)
> at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(Da
> taSourceProxy.java:127)
> at org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount
> (ClaimDAO.java:158)
> at org.wso2.carbon.user.core.common.DefaultRealm.populateProfil
> eAndClaimMaps(DefaultRealm.java:448)
> at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRe
> alm.java:124)
> at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(
> DefaultRealmService.java:263)
> at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(
> DefaultRealmService.java:100)
> at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(
> DefaultRealmService.java:113)
> at org.wso2.carbon.user.core.internal.Activator.startDeploy(
> Activator.java:68)
> at org.wso2.carbon.user.core.internal.BundleCheckActivator.star
> t(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.s
> tartActivator(BundleContextImpl.java:702)
> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(
> BundleContextImpl.java:683)
> at org.eclipse.osgi.framework.internal.core.BundleHost.startWor
> ker(BundleHost.java:381)
> at org.eclipse.osgi.framework.internal.core.AbstractBundle.resu
> me(AbstractBundle.java:390)
> at org.eclipse.osgi.framework.internal.core.Framework.resumeBun
> dle(Framework.java:1176)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.r
> esumeBundles(StartLevelManager.java:559)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.r
> esumeBundles(StartLevelManager.java:544)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(
> StartLevelManager.java:457)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> oSetStartLevel(StartLevelManager.java:243)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> ispatchEvent(StartLevelManager.java:438)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> ispatchEvent(StartLevelManager.java:1)
> at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEve
> nt(EventManager.java:230)
> at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread
> .run(EventManager.java:340)
> [2016-08-25 11:31:35,680] ERROR {org.wso2.carbon.user.core.internal.Activator}
> - Cannot start User Manager Core bundle
> org.wso2.carbon.user.core.UserStoreException: Cannot initialize the realm.
> at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(
> DefaultRealmService.java:273)
> at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(
> DefaultRealmService.java:100)
> at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(
> DefaultRealmService.java:113)
> at org.wso2.carbon.user.core.internal.Activator.startDeploy(
> Activator.java:68)
> at org.wso2.carbon.user.core.internal.BundleCheckActivator.star
> t(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.s
> tartActivator(BundleContextImpl.java:702)
> at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(
> BundleContextImpl.java:683)
> at org.eclipse.osgi.framework.internal.core.BundleHost.startWor
> ker(BundleHost.java:381)
> at org.eclipse.osgi.framework.internal.core.AbstractBundle.resu
> me(AbstractBundle.java:390)
> at org.eclipse.osgi.framework.internal.core.Framework.resumeBun
> dle(Framework.java:1176)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.r
> esumeBundles(StartLevelManager.java:559)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.r
> esumeBundles(StartLevelManager.java:544)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(
> StartLevelManager.java:457)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> oSetStartLevel(StartLevelManager.java:243)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> ispatchEvent(StartLevelManager.java:438)
> at org.eclipse.osgi.framework.internal.core.StartLevelManager.d
> ispatchEvent(StartLevelManager.java:1)
> at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEve
> nt(EventManager.java:230)
> at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread
> .run(EventManager.java:340)
> Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error -
> Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX";
> SQL statement:
> ALTER TABLE PUBLIC.IDN_OAUTH2_ACCESS_TOKEN_SCOPE ADD CONSTRAINT
> PUBLIC.CONSTRAINT_B1A FOREIGN KEY(TOKEN_ID) REFERENCES
> PUBLIC.IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE NOCHECK
> [23505-176]
> at org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount
> (ClaimDAO.java:168)
> at org.wso2.carbon.user.core.common.DefaultRealm.populateProfil
> eAndClaimMaps(DefaultRealm.java:448)
> at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRe
> alm.java:124)
> at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(
> DefaultRealmService.java:263)
> ... 19 more
> Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key
> violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
> ALTER TABLE PUBLIC.IDN_OAUTH2_ACCESS_TOKEN_SCOPE ADD CONSTRAINT
> PUBLIC.CONSTRAINT_B1A FOREIGN KEY(TOKEN_ID) REFERENCES
> PUBLIC.IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE NOCHECK
> [23505-176]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
> at org.h2.message.DbException.get(DbException.java:178)
> at org.h2.message.DbException.get(DbException.java:154)
> at org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageD
> ataIndex.java:166)
> at org.h2.index.PageDataIndex.add(PageDataIndex.java:144)
> at org.h2.store.PageStore.addMeta(PageStore.java:1808)
> at org.h2.index.PageBtreeIndex.<init>(PageBtreeIndex.java:64)
> at org.h2.table.RegularTable.addIndex(RegularTable.java:235)
> at org.h2.command.ddl.AlterTableAddConstraint.createIndex(Alter
> TableAddConstraint.java:280)
> at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTa
> bleAddConstraint.java:205)
> at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTable
> AddConstraint.java:73)
> at org.h2.engine.MetaRecord.execute(MetaRecord.java:59)
> at org.h2.engine.Database.open(Database.java:719)
> at org.h2.engine.Database.openDatabase(Database.java:260)
> at org.h2.engine.Database.<init>(Database.java:254)
> at org.h2.engine.Engine.openSession(Engine.java:57)
> at org.h2.engine.Engine.openSession(Engine.java:164)
> at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142)
> at org.h2.engine.Engine.createSession(Engine.java:125)
> at org.h2.engine.Engine.createSession(Engine.java:27)
> at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionR
> emote.java:331)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107)
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91)
> at org.h2.Driver.connect(Driver.java:74)
> at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(
> PooledConnection.java:278)
> at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledC
> onnection.java:182)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(
> ConnectionPool.java:701)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(
> ConnectionPool.java:635)
> at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(Con
> nectionPool.java:188)
> at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(Da
> taSourceProxy.java:127)
> at org.wso2.carbon.user.core.claim.dao.ClaimDAO.getDialectCount
> (ClaimDAO.java:158)
> ... 22 more
>
> Thanks,
> Kasun.
>
> On Thu, Aug 25, 2016 at 11:56 AM, Kalpa Welivitigoda <kal...@wso2.com>
> wrote:
>
>> Hi Madhawa,
>>
>> On Thu, Aug 25, 2016 at 11:36 AM, Madhawa Gunasekara <madha...@wso2.com>
>> wrote:
>>
>>> Hi Kalpa,
>>>
>>> Thanks for the reply. One more thing to clarify, previously there were
>>> two h2 bundles in the pack in (4.4.7, 4.4.8)
>>> 1. h2-1.2.140-wso2v3.jar in /repository/lib folder - a simple
>>> orbit bundle
>>> 2. h2-database-engine_1.2.140.wso2v3.jar in /repository/components/lib
>>> folder - orbit bundle with a custom activator
>>>
>>
>> I could only find the following h2 related jars in kernel,
>>
>> 4.4.8 - repository/components/plugins/h2-database-engine_1.2.140.wso
>> 2v3.jar
>> 4.4.9-rc2 - repository/components/plugins/h2_1.3.176.wso2v1.jar
>>
>> Would you please check whether the other jar is packed from a feature or
>> from the product level?
>>
>>
>>> but now I can see only one h2 bundle, which is in the plug-in folder. Is
>>> there any reason to remove that h2 bundle in repository/lib folder? because
>>> we are currently using repository/lib h2 bundle to deploy samples and db
>>> scripts for the samples.
>>>
>>> [1] https://github.com/wso2/carbon-kernel/blob/4.4.x/distributio
>>> n/kernel/carbon-home/bin/build.xml#L119
>>>
>>> Thanks,
>>> Madhawa
>>>
>>>
>>>
>>> On Wed, Aug 24, 2016 at 8:48 PM, Kalpa Welivitigoda <kal...@wso2.com>
>>> wrote:
>>>
>>>> Hi Madhawa,
>>>>
>>>> Yes, H2 version in kernel 4.4.9 is 1.3.176, it's the latest stable
>>>> version [1].
>>>>
>>>> [1] http://h2-database.66688.n3.nabble.com/What-is-the-last-stab
>>>> le-version-of-H2-for-1-4-x-versions-td4033283.html
>>>>
>>>> On Wed, Aug 24, 2016 at 7:09 PM, Madhawa Gunasekara <madha...@wso2.com>
>>>> wrote:
>>>>
>>>>> Hi Thusitha,
>>>>>
>>>>> Do we upgrade the h2 database in carbon kernel 4.4.9 release ?
>>>>>
>>>>> Thanks,
>>>>> Madhawa
>>>>>
>>>>> On Wed, Aug 24, 2016 at 5:59 PM, Thusitha Thilina Dayaratne <
>>>>> thusit...@wso2.com> wrote:
>>>>>
>>>>>> Hi DSS/IS Team,
>>>>>>
>>>>>> Can IS and DSS teams test their products with the carbon kernel
>>>>>> 4.4.9-rc2 and vote?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> On Wed, Aug 24, 2016 at 5:35 PM, Thusitha Thilina Dayaratne <
>>>>>> thusit...@wso2.com> wrote:
>>>>>>
>>>>>>> Hi Devs,
>>>>>>>
>>>>>>> This is the 2nd release candidate of the WSO2 Carbon Kernel 4.4.9.
>>>>>>>
>>>>>>> This release fixes the following issues
>>>>>>> *https://wso2.org/jira/issues/?filter=13289
>>>>>>> <https://wso2.org/jira/issues/?filter=13289>*
>>>>>>>
>>>>>>> Please download, test your products with kernel 4.4.9 RC2 and vote.
>>>>>>> Vote will be open for 72 hours or as longer as needed.
>>>>>>>
>>>>>>> *Source and binary distribution files:*
>>>>>>> https://github.com/wso2/carbon-kernel/archive/v4.4.9-rc2.zip
>>>>>>> http://svn.wso2.org/repos/wso2/people/thusithad/4.4.9/wso2ca
>>>>>>> rbon-4.4.9-rc2.zip
>>>>>>>
>>>>>>> *Maven staging repository*
>>>>>>> https://maven.wso2.org/nexus/content/repositories/orgwso2carbon-1036
>>>>>>>
>>>>>>> *The tag to be voted upon : *
>>>>>>> https://github.com/wso2/carbon-kernel/releases/tag/v4.4.9-rc2
>>>>>>>
>>>>>>> [ ] Broken - Do not release (explain why)
>>>>>>> [ ] Stable - Go ahead and release
>>>>>>>
>>>>>>> Thank you
>>>>>>> Carbon Team
>>>>>>> --
>>>>>>> Thusitha Dayaratne
>>>>>>> Software Engineer
>>>>>>> WSO2 Inc. - lean . enterprise . middleware | wso2.com
>>>>>>>
>>>>>>> Mobile +94712756809
>>>>>>> Blog alokayasoya.blogspot.com
>>>>>>> About http://about.me/thusithathilina
>>>>>>> <http://wso2.com/signature>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thusitha Dayaratne
>>>>>> Software Engineer
>>>>>> WSO2 Inc. - lean . enterprise . middleware | wso2.com
>>>>>>
>>>>>> Mobile +94712756809
>>>>>> Blog alokayasoya.blogspot.com
>>>>>> About http://about.me/thusithathilina
>>>>>> <http://wso2.com/signature>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Dev mailing list
>>>>>> Dev@wso2.org
>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> *Madhawa Gunasekara*
>>>>> Software Engineer
>>>>> WSO2 Inc.; http://wso2.com
>>>>> lean.enterprise.middleware
>>>>>
>>>>> mobile: +94 71941102 <+94+71941102>
>>>>> blog: *http://madhawa-gunasekara.blogspot.com
>>>>> <http://madhawa-gunasekara.blogspot.com>*
>>>>> linkedin: *http://lk.linkedin.com/in/mgunasekara
>>>>> <http://lk.linkedin.com/in/mgunasekara>*
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> Dev@wso2.org
>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Best Regards,
>>>>
>>>> Kalpa Welivitigoda
>>>> Senior Software Engineer, WSO2 Inc. http://wso2.com
>>>> Email: kal...@wso2.com
>>>> Mobile: +94776509215
>>>>
>>>> [image: http://wso2.com/signature] <http://wso2.com/signature>
>>>>
>>>
>>>
>>>
>>> --
>>> *Madhawa Gunasekara*
>>> Software Engineer
>>> WSO2 Inc.; http://wso2.com
>>> lean.enterprise.middleware
>>>
>>> mobile: +94 71941102 <+94+71941102>
>>> blog: *http://madhawa-gunasekara.blogspot.com
>>> <http://madhawa-gunasekara.blogspot.com>*
>>> linkedin: *http://lk.linkedin.com/in/mgunasekara
>>> <http://lk.linkedin.com/in/mgunasekara>*
>>>
>>
>>
>>
>> --
>> Best Regards,
>>
>> Kalpa Welivitigoda
>> Senior Software Engineer, WSO2 Inc. http://wso2.com
>> Email: kal...@wso2.com
>> Mobile: +94776509215
>>
>> [image: http://wso2.com/signature] <http://wso2.com/signature>
>>
>> _______________________________________________
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Kasun Bandara
> *Software Engineer*
> Mobile : +94 (0) 718 338 360
> <%2B94%20%280%29%20773%20451194>
> kas...@wso2.com <thili...@wso2.com>
>
--
Best Regards,
Kalpa Welivitigoda
Senior Software Engineer, WSO2 Inc. http://wso2.com
Email: kal...@wso2.com
Mobile: +94776509215
[image: http://wso2.com/signature] <http://wso2.com/signature>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
