[
https://issues.apache.org/jira/browse/CONNECTORS-797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13810472#comment-13810472
]
Graeme Seaton commented on CONNECTORS-797:
------------------------------------------
That did the trick.
Didn't increase the property "org.apache.manifoldcf.ui.maxstatuscount" value.
Would you expect that to improve performance or robustness (Testing against a
set of repositories of ~10M docs)?
> Database Exception on Status and Job Management screen
> ------------------------------------------------------
>
> Key: CONNECTORS-797
> URL: https://issues.apache.org/jira/browse/CONNECTORS-797
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework crawler agent
> Affects Versions: ManifoldCF 1.4
> Environment: Postgresql 9.2.5
> Reporter: Graeme Seaton
> Assignee: Karl Wright
> Priority: Critical
> Fix For: ManifoldCF 1.5
>
> Attachments: CONNECTORS-797.patch
>
>
> Receive the following message on the ' Status and Job Management' screen:
> Error: Database exception: SQLException doing query (42601): ERROR: syntax
> error at or near "status" Position: 60
> Digging through the debug logs found:
> DEBUG 2013-10-31 12:29:11,911 (http-apr-8081-exec-5) - Requested query:
> [SELECT COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN
> (?,?,?,?,?,?) LIMIT 500001]
> DEBUG 2013-10-31 12:29:11,911 (Thread-16) - Actual query: [SELECT
> COUNT(dochash) AS doccount FROM jobqueue WHERE id=?status IN (?,?,?,?,?,?)
> LIMIT 500001]
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 0: '1380815567276'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 1: 'A'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 2: 'a'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 3: 'P'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 4: 'F'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 5: 'f'
> DEBUG 2013-10-31 12:29:11,912 (Thread-16) - Parameter 6: 'G'
> DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Reinterpreting
> exception 'Database exception: SQLException doing query (42601): ERROR:
> syntax error at or near "status"
> Position: 60'. The exception type is 4
> DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database
> exception: SQLException doing query (42601): ERROR: syntax error at or near
> "status"
> Position: 60 is possibly a transaction abort signal
> DEBUG 2013-10-31 12:29:11,918 (http-apr-8081-exec-5) - Exception Database
> exception: SQLException doing query (42601): ERROR: syntax error at or near
> "status"
> Position: 60 is NOT a transaction abort signal
> Appears that the SQL request is missing a space at 'WHERE id=?status IN (....'
--
This message was sent by Atlassian JIRA
(v6.1#6144)
