Hi Godwin, Can't we edit the database in the middle of working? it's mean while we working if we need some modification.
On Tue, Feb 16, 2016 at 3:51 PM, Rajjaz Mohammed <[email protected]> wrote: > 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/> > -- 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
