Hi Roshan H2 dbs get corrupted some times. We are not recommending H2 in production deployments. So if you want to store some data please use mysql. And you can delete h2 dbs (under $CARBON_HOME/repository/database/) and start the server with -Dsetup option.
Thanks & Regards Danushka Fernando Software Engineer WSO2 inc. http://wso2.com/ Mobile : +94716332729 On Mon, Aug 25, 2014 at 5:20 PM, Abimaran Kugathasan <abima...@wso2.com> wrote: > Hi Roshan, > > Seems that DB file was correpted. Can you check WSO2AM_DB.trace.db file > and attached it here? > > > On Mon, Aug 25, 2014 at 4:15 PM, Roshan Wijesena <ros...@wso2.com> wrote: > >> Hi Devs, >> >> I am keep getting below exception when I am trying to add a new API via >> publisher >> >> Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading >> record: >> "/home/roshan/workspace/MIT/wso2am-1.7.0-SNAPSHOT/repository/database/WSO2AM_DB.h2.db". >> 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.readVariableHeader(PageStore.java:699) >> at org.h2.store.PageStore.openExisting(PageStore.java:314) >> 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.apimgt.impl.utils.APIMgtDBUtil.getConnection(APIMgtDBUtil.java:138) >> at org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO.addAPI(ApiMgtDAO.java:4833) >> ... 66 more >> >> any one has idea why is this? >> >> Regards >> Roshan >> >> >> -- >> Roshan Wijesena. >> Senior Software Engineer-WSO2 Inc. >> Mobile: *+94752126789* >> Email: ros...@wso2.com >> *WSO2, Inc. :** wso2.com <http://wso2.com/>* >> lean.enterprise.middleware. >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Thanks > Abimaran Kugathasan > > Software Engineer | WSO2 Inc > Data & APIs Technologies Team > Mobile : +94 77 1708229 > > <http://stackoverflow.com/users/515034> > <http://lk.linkedin.com/in/abimaran> > <http://www.lkabimaran.blogspot.com/> <https://github.com/abimaran> > <https://twitter.com/abimaran> > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev