Hi, We are still getting this error from APIM trunk built pack,when we call key validation service using thrift.
The reason for the error is the db table creation of 'IDN_THRIFT_SESSION' is missing from identity related db scripts.. By going through code, "org.wso2.carbon.identity.thrift.authentication" bundle is reffering a database table called "IDN_THRIFT_SESSION" [for eg: isSessionExisting() in ThriftSessionDAO class] and that table creation has later removed with the commit r*172057*.. Is this done intentionally..? Can we get added the missing db table creation again to identity related db scripts..? Thanks; On Mon, Jul 1, 2013 at 6:09 AM, Sanjeewa Malalgoda <sanje...@wso2.com>wrote: > Hi Team, > I can see following error when we call key validation service using > thrift. Any idea about this? (I tested today trunk pack) > > > Thanks, > Sanjeewa. > > > > [2013-07-01 18:32:41,428] INFO - LogMediator STATUS = Message dispatched > to the main sequence. Invalid URL., RESOURCE = > /twitter/1.0.0/search.atom?q=wso2 > [2013-07-01 18:34:19,546] INFO - CarbonAuthenticationUtil > 'admin@carbon.super [-1234]' logged in at [2013-07-01 18:34:19,546+0530] > from IP address > [2013-07-01 18:34:19,551] ERROR - ThriftSessionDAO Error when executing > the SQL : SELECT SESSION_ID FROM IDN_THRIFT_SESSION WHERE SESSION_ID=? > [2013-07-01 18:34:19,552] ERROR - ThriftSessionDAO Table > "IDN_THRIFT_SESSION" not found; SQL statement: > SELECT SESSION_ID FROM IDN_THRIFT_SESSION WHERE SESSION_ID=? [42102-140] > org.h2.jdbc.JdbcSQLException: Table "IDN_THRIFT_SESSION" not found; SQL > statement: > SELECT SESSION_ID FROM IDN_THRIFT_SESSION WHERE SESSION_ID=? [42102-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.command.Parser.readTableOrView(Parser.java:4498) > at org.h2.command.Parser.readTableFilter(Parser.java:1011) > at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1577) > at org.h2.command.Parser.parseSelectSimple(Parser.java:1682) > at org.h2.command.Parser.parseSelectSub(Parser.java:1571) > at org.h2.command.Parser.parseSelectUnion(Parser.java:1416) > at org.h2.command.Parser.parseSelect(Parser.java:1404) > at org.h2.command.Parser.parsePrepared(Parser.java:392) > at org.h2.command.Parser.parse(Parser.java:275) > at org.h2.command.Parser.parse(Parser.java:247) > at org.h2.command.Parser.prepare(Parser.java:201) > at org.h2.command.Parser.prepareCommand(Parser.java:214) > at org.h2.engine.Session.prepareLocal(Session.java:434) > at org.h2.engine.Session.prepareCommand(Session.java:384) > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1071) > at > org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71) > at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:234) > at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.wso2.carbon.ndatasource.rdbms.ConnectionRollbackOnReturnInterceptor.invoke(ConnectionRollbackOnReturnInterceptor.java:51) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) > at $Proxy13.prepareStatement(Unknown Source) > at > org.wso2.carbon.identity.thrift.authentication.dao.ThriftSessionDAO.isSessionExisting(ThriftSessionDAO.java:89) > at > org.wso2.carbon.identity.thrift.authentication.dao.ThriftSessionDAO.addSession(ThriftSessionDAO.java:116) > at > org.wso2.carbon.identity.thrift.authentication.ThriftAuthenticatorServiceImpl.addThriftSession(ThriftAuthenticatorServiceImpl.java:79) > at > org.wso2.carbon.identity.thrift.authentication.ThriftAuthenticatorServiceImpl.authenticate(ThriftAuthenticatorServiceImpl.java:143) > at > org.wso2.carbon.identity.thrift.authentication.AuthenticatorServiceImpl.authenticate(AuthenticatorServiceImpl.java:25) > at > org.wso2.carbon.identity.thrift.authentication.AuthenticatorService$Processor$authenticate.getResult(AuthenticatorService.java:166) > at > org.wso2.carbon.identity.thrift.authentication.AuthenticatorService$Processor$authenticate.getResult(AuthenticatorService.java:154) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34) > at org.apache.thrift.server.TServlet.doPost(TServlet.java:83) > at > org.wso2.carbon.identity.thrift.authentication.AuthenticatorServlet.doPost(AuthenticatorServlet.java:50) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) > at > org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) > at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) > at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) > at > org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) > at > org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:172) > at > org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) > at > org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:619) > [2013-07-01 18:34:19,554] ERROR - ThriftAuthenticatorServiceImpl Error > occured while authenticating the user: admin > org.wso2.carbon.identity.base.IdentityException: Error when reading thrift > session information from the persistence store. > > > -- > * > * > *Sanjeewa Malalgoda* > WSO2 Inc. > Mobile : +94713068779 > > <http://sanjeewamalalgoda.blogspot.com/>blog > :http://sanjeewamalalgoda.blogspot.com/<http://sanjeewamalalgoda.blogspot.com/> > > > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Lalaji Sureshika WSO2, Inc.; http://wso2.com/ email: lal...@wso2.com; cell: +94 71 608 6811 blog: http://lalajisureshika.blogspot.com
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev