Please attach the complete error log. -Ajith
On Mon, Sep 1, 2014 at 2:59 PM, Amalka Subasinghe <ama...@wso2.com> wrote: > 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 > > -- Ajith Vitharana. WSO2 Inc. - http://wso2.org Email : aji...@wso2.com Mobile : +94772217350
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev