You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2013/11/12 19:38:17 UTC
[jira] [Resolved] (CONNECTORS-797) Database Exception on Status and
Job Management screen
[ https://issues.apache.org/jira/browse/CONNECTORS-797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-797.
------------------------------------
Resolution: Fixed
> 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.4.1, 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)