[
https://issues.apache.org/jira/browse/CONNECTORS-797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13810516#comment-13810516
]
Karl Wright commented on CONNECTORS-797:
----------------------------------------
Hi Graeme,
If you could try the second patch before increasing the maxcount parameter,
that would be great.
If you want an accurate count in the UI, you will definitely need to increase
the maxcount parameter eventually though to get it. Otherwise you will get
something like this:
>500000
> 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, CONNECTORS-797.patch.2
>
>
> 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)
