[CONNECTORS-791] Sanity test fails due to a bad SQL expression

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.4
• Fix Version/s: ManifoldCF 1.4
• Component/s: Framework crawler agent
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 21/Oct/13 14:31
• Updated: 21/Oct/13 18:03
• Resolved: 21/Oct/13 18:03

Description

The failure is as follows:

    [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]

The following trace is in the log:

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)