Hi, I'm also getting the same issue, any update on this? we want to up the basic APIM setup with H2 database for test automation
Thanks Amalka On Mon, Aug 25, 2014 at 6:48 PM, Roshan Wijesena <ros...@wso2.com> wrote: > Hi Danushka, Abimaran > > Thanks for your responses.. > > I am trying to start up basic APIM setup with built in H2 database first > because we ship H2 database by default. I can understand the fact that DB > is corrupted, just curious why is getting corrupted every time that I am > going to start up the set up. > > Regards > Roshan > > > On Mon, Aug 25, 2014 at 6:28 PM, Danushka Fernando <danush...@wso2.com> > wrote: > >> 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 >>> >>> >> > > > -- > 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 > > -- Amalka Subasinghe Senior Software Engineer WSO2 Inc. Mobile: +94 77 9401267
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
