[
https://issues.apache.org/jira/browse/CONNECTORS-791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13800708#comment-13800708
]
Karl Wright commented on CONNECTORS-791:
----------------------------------------
r1534192 (trunk)
r1534194 (release branch)
> Sanity test fails due to a bad SQL expression
> ---------------------------------------------
>
> Key: CONNECTORS-791
> URL: https://issues.apache.org/jira/browse/CONNECTORS-791
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework crawler agent
> Affects Versions: ManifoldCF 1.4
> Reporter: Karl Wright
> Assignee: Karl Wright
> Priority: Blocker
> Fix For: ManifoldCF 1.4
>
>
> The failure is as follows:
> {code}
> [junit] Testcase:
> sanityCheck(org.apache.manifoldcf.filesystem_tests.APISani
> tyDerbyIT): Caused an ERROR
> [junit] Database exception: SQLException doing query (42X01): Syntax
> error:
> Encountered "WHERE" at line 1, column 104.
> [junit] java.lang.Exception: Database exception: SQLException doing query
> (4
> 2X01): Syntax error: Encountered "WHERE" at line 1, column 104.
> [junit] at
> org.apache.manifoldcf.crawler.tests.ManifoldCFInstance.getJob
> DocumentsProcessedAPI(ManifoldCFInstance.java:227)
> [junit] at
> org.apache.manifoldcf.filesystem_tests.APISanityTester.execut
> eTest(APISanityTester.java:212)
> [junit] at
> org.apache.manifoldcf.filesystem_tests.APISanityDerbyIT.sanit
> yCheck(APISanityDerbyIT.java:53)
> [junit]
> {code}
> The following trace is in the log:
> {code}
> ERROR 2013-10-21 10:27:15,148 (qtp1215713589-141) - Database exception:
> SQLException doing query (42X01): Syntax error: Encountered "WHERE" at line
> 1, column 104.
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database
> exception: SQLException doing query (42X01): Syntax error: Encountered
> "WHERE" at line 1, column 104.
> at
> org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:723)
> at
> org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:770)
> at
> org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1437)
> at
> org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
> at
> org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:191)
> at
> org.apache.manifoldcf.core.database.DBInterfaceDerby.performQuery(DBInterfaceDerby.java:970)
> at
> org.apache.manifoldcf.crawler.jobs.JobManager.buildCountsUsingGroupBy(JobManager.java:7568)
> at
> org.apache.manifoldcf.crawler.jobs.JobManager.makeJobStatus(JobManager.java:7266)
> at
> org.apache.manifoldcf.crawler.jobs.JobManager.getStatus(JobManager.java:7156)
> at
> org.apache.manifoldcf.crawler.system.ManifoldCF.apiReadJobStatus(ManifoldCF.java:2078)
> at
> org.apache.manifoldcf.crawler.system.ManifoldCF.executeReadCommand(ManifoldCF.java:3200)
> at
> org.apache.manifoldcf.apiservlet.APIServlet.executeRead(APIServlet.java:231)
> at org.apache.manifoldcf.apiservlet.APIServlet.doGet(APIServlet.java:77)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
> at
> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:480)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
> at
> org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
> at
> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
> at
> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
> at
> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
> at
> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
> at
> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
> at
> org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
> at org.eclipse.jetty.server.Server.handle(Server.java:349)
> at
> org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
> at
> org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:919)
> at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:582)
> at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
> at
> org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:51)
> at
> org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
> at
> org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
> at java.lang.Thread.run(Thread.java:724)
> {code}
--
This message was sent by Atlassian JIRA
(v6.1#6144)
