Graeme Seaton created CONNECTORS-797:
----------------------------------------
Summary: 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
Affects Versions: ManifoldCF 1.4
Environment: Postgresql 9.2.5
Reporter: Graeme Seaton
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)
