[
https://issues.apache.org/jira/browse/LENS-394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arshad Matin closed LENS-394.
-----------------------------
> Seeing unexpected end of stament in QueryPurger in tests
> --------------------------------------------------------
>
> Key: LENS-394
> URL: https://issues.apache.org/jira/browse/LENS-394
> Project: Apache Lens
> Issue Type: Bug
> Components: server
> Reporter: Amareshwari Sriramadasu
> Assignee: Jaideep Dhok
> Fix For: 2.1
>
> Attachments: rb31858.patch
>
>
> Seeing a lot of following exceptions in test :
> {noformat}
> org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:759)]
> Exception while purging query
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (unexpected end of statement)
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
> at
> org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:454)
> at
> org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at
> org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:756)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.sql.SQLSyntaxErrorException: unexpected end of statement
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
> ... 7 more
> Caused by: org.hsqldb.HsqlException: unexpected end of statement
> at org.hsqldb.error.Error.parseError(Unknown Source)
> at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
> at org.hsqldb.ParserDQL.XreadSelect(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
> at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
> at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
> at org.hsqldb.ParserCommand.compilePart(Unknown Source)
> at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
> at org.hsqldb.Session.executeDirectStatement(Unknown Source)
> at org.hsqldb.Session.execute(Unknown Source)
> ... 13 more
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (unexpected end of statement)
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
> at
> org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175)
> at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:286)
> at
> org.apache.lens.server.query.LensServerDAO.getQuery(LensServerDAO.java:156)
> at
> org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:118)
> at
> org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:756)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.sql.SQLSyntaxErrorException: unexpected end of statement
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
> ... 8 more
> Caused by: org.hsqldb.HsqlException: unexpected end of statement
> at org.hsqldb.error.Error.parseError(Unknown Source)
> at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
> at org.hsqldb.ParserDQL.XreadSelect(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
> at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
> at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
> at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
> at org.hsqldb.ParserCommand.compilePart(Unknown Source)
> at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
> at org.hsqldb.Session.executeDirectStatement(Unknown Source)
> at org.hsqldb.Session.execute(Unknown Source)
> ... 14 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
