You should be able to update the table schema. At the same time you don't need to get a fresh pack and start if you are working with H2 DB. just update relevant db script(<CARBON_HOME/dbscripts/>) and remove content within <CARBON_HOME>/repository/database and start the pack with -Dsetup
On Tue, Feb 16, 2016 at 6:23 AM, Rajjaz Mohammed <[email protected]> wrote: > 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 > > -- Regards, UdaraR
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
