Hi Godwin, Thanks its works fine if i add the table in the fresh pack DB and start the IS.
On Tue, Feb 16, 2016 at 3:38 PM, Godwin Shrimal <[email protected]> wrote: > Hi Rajjaz, > > It looks H2 database is corrupted. You may need to try it with fresh pack > again (If data doesn't matters) or use a recovery tool to recover the > database. > > > Thanks > Godwin > > On Tue, Feb 16, 2016 at 3:20 PM, Rajjaz Mohammed <[email protected]> wrote: > >> Hi All, >> i'm trying to create new table in WSO2 IS. but after create new table >> using H2 console i'm getiing below error[1]. any suggestion?. >> >> [1] >> [2016-02-16 15:13:25,086] FATAL >> {org.wso2.carbon.utils.dbcreator.DatabaseCreator} - Failed to create >> database tables for registry resource store. File corrupted while reading >> record: "1037 of 805". Possible solution: use the recovery tool [90030-140] >> org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "1037 >> of 805". Possible solution: use the recovery tool [90030-140] >> at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at org.h2.store.PageStore.readPage(PageStore.java:1094) >> at org.h2.store.PageStore.getPage(PageStore.java:561) >> at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:218) >> at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:73) >> at org.h2.table.RegularTable.<init>(RegularTable.java:75) >> at org.h2.store.PageStore.addMeta(PageStore.java:1443) >> at org.h2.store.PageStore.readMetaData(PageStore.java:1380) >> at org.h2.store.PageStore.recover(PageStore.java:1178) >> at org.h2.store.PageStore.openExisting(PageStore.java:317) >> at org.h2.store.PageStore.open(PageStore.java:271) >> at org.h2.engine.Database.getPageStore(Database.java:2059) >> at org.h2.engine.Database.open(Database.java:534) >> at org.h2.engine.Database.openDatabase(Database.java:207) >> at org.h2.engine.Database.<init>(Database.java:202) >> at org.h2.engine.Engine.openSession(Engine.java:56) >> at org.h2.engine.Engine.openSession(Engine.java:146) >> at org.h2.engine.Engine.getSession(Engine.java:125) >> at org.h2.engine.Session.createSession(Session.java:122) >> at >> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:241) >> at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95) >> at org.h2.Driver.connect(Driver.java:73) >> 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:128) >> at >> org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:58) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:328) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:88) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:112) >> 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-02-16 15:13:25,088] 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:338) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:88) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:112) >> 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: java.lang.Exception: Failed to create database tables for >> registry resource store. File corrupted while reading record: "1037 of >> 805". Possible solution: use the recovery tool [90030-140] >> at >> org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:69) >> at >> org.wso2.carbon.user.core.common.DefaultRealmService.initializeDatabase(DefaultRealmService.java:328) >> ... 19 more >> Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading >> record: "1037 of 805". Possible solution: use the recovery tool [90030-140] >> at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at org.h2.store.PageStore.readPage(PageStore.java:1094) >> at org.h2.store.PageStore.getPage(PageStore.java:561) >> at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:218) >> at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:73) >> at org.h2.table.RegularTable.<init>(RegularTable.java:75) >> at org.h2.store.PageStore.addMeta(PageStore.java:1443) >> at org.h2.store.PageStore.readMetaData(PageStore.java:1380) >> at org.h2.store.PageStore.recover(PageStore.java:1178) >> at org.h2.store.PageStore.openExisting(PageStore.java:317) >> at org.h2.store.PageStore.open(PageStore.java:271) >> at org.h2.engine.Database.getPageStore(Database.java:2059) >> at org.h2.engine.Database.open(Database.java:534) >> at org.h2.engine.Database.openDatabase(Database.java:207) >> at org.h2.engine.Database.<init>(Database.java:202) >> at org.h2.engine.Engine.openSession(Engine.java:56) >> at org.h2.engine.Engine.openSession(Engine.java:146) >> at org.h2.engine.Engine.getSession(Engine.java:125) >> at org.h2.engine.Session.createSession(Session.java:122) >> at >> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:241) >> at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111) >> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95) >> at org.h2.Driver.connect(Driver.java:73) >> 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:128) >> at >> org.wso2.carbon.utils.dbcreator.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:58) >> ... 20 more >> [2016-02-16 15:13:30,649] INFO >> {org.apache.catalina.startup.TaglibUriRule} - TLD skipped. URI: >> http://tiles.apache.org/tags-tiles is already defined >> >> >> >> -- >> Thank you >> Best Regards >> >> *Rajjaz HM* >> Associate Software Engineer >> WSO2 Inc. <http://wso2.com/> >> lean | enterprise | middleware >> Mobile | +94752833834 >> Email | [email protected] >> LinkedIn | Blogger | WSO2 Profile >> <http://wso2.com/about/team/mohammer_rajjaz/> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Godwin Amila Shrimal* > Senior Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: *+94772264165* > linkedin: *http://lnkd.in/KUum6D <http://lnkd.in/KUum6D>* > twitter: https://twitter.com/godwinamila > -- Thank you Best Regards *Rajjaz HM* Associate Software Engineer WSO2 Inc. <http://wso2.com/> lean | enterprise | middleware Mobile | +94752833834 Email | [email protected] LinkedIn | Blogger | WSO2 Profile <http://wso2.com/about/team/mohammer_rajjaz/>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
