[CONNECTORS-797] Database Exception on Status and Job Management screen

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.4
• Fix Version/s: ManifoldCF 1.4.1, ManifoldCF 1.5
• Component/s: Framework crawler agent

Environment

Postgresql 9.2.5

• Assignee: Karl Wright
• Reporter: Graeme Seaton
• Created: 31/Oct/13 16:03
• Updated: 12/Nov/13 18:36
• Resolved: 12/Nov/13 18:36

Description

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 (....'