Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-797

Database Exception on Status and Job Management screen

    Details

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

        Attachments

        1. CONNECTORS-797.patch.2
          2 kB
          Karl Wright
        2. CONNECTORS-797.patch
          1 kB
          Karl Wright

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              gseaton Graeme Seaton
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: