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(
PageDataIndex.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(
AlterTableAddConstraint.java:280)
at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(
AlterTableAddConstraint.java:205)
at org.h2.command.ddl.AlterTableAddConstraint.update(
AlterTableAddConstraint.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(
SessionRemote.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(
PooledConnection.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(
ConnectionPool.java:188)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(
DataSourceProxy.java:127)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.
getDialectCount(ClaimDAO.java:158)
at org.wso2.carbon.user.core.common.DefaultRealm.
populateProfileAndClaimMaps(DefaultRealm.java:448)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.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.
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:390)
at org.eclipse.osgi.framework.internal.core.Framework.
resumeBundle(Framework.java:1176)
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)
[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.
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:390)
at org.eclipse.osgi.framework.internal.core.Framework.
resumeBundle(Framework.java:1176)
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: 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.
populateProfileAndClaimMaps(DefaultRealm.java:448)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.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(
PageDataIndex.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(
AlterTableAddConstraint.java:280)
at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(
AlterTableAddConstraint.java:205)
at org.h2.command.ddl.AlterTableAddConstraint.update(
AlterTableAddConstraint.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(
SessionRemote.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(
PooledConnection.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(
ConnectionPool.java:188)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(
DataSourceProxy.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 <[email protected]>
wrote:
> Hi Madhawa,
>
> On Thu, Aug 25, 2016 at 11:36 AM, Madhawa Gunasekara <[email protected]>
> 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.
> wso2v3.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 <[email protected]>
>> 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 <[email protected]>
>>> 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 <
>>>> [email protected]> 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 <
>>>>> [email protected]> 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
>>>>> [email protected]
>>>>> 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
>>>> [email protected]
>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>
>>>>
>>>
>>>
>>> --
>>> Best Regards,
>>>
>>> Kalpa Welivitigoda
>>> Senior Software Engineer, WSO2 Inc. http://wso2.com
>>> Email: [email protected]
>>> 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: [email protected]
> Mobile: +94776509215
>
> [image: http://wso2.com/signature] <http://wso2.com/signature>
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
--
Kasun Bandara
*Software Engineer*
Mobile : +94 (0) 718 338 360
<%2B94%20%280%29%20773%20451194>
[email protected] <[email protected]>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
