Hi Kasun, I came across [1] which matches with your observations with IS (Starting, shutdown and restart the server). According to [1] this is a bug in 1.3.176 and is fixed in 1.4.179 Beta [2].
[1] https://groups.google.com/forum/#!topic/h2-database/5LZlZ_jC4QI [2] http://www.h2database.com/html/changelog.html On Thu, Aug 25, 2016 at 2:58 PM, Kalpa Welivitigoda <[email protected]> wrote: > 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 <[email protected]> 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(Act >> ivator.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(Act >> ivator.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 <[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.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 <[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/orgwso2car >>>>>>>> bon-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]> >> > > > > -- > 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> > -- 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
