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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
