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

Alfresco Connector fails to complete seeding request, leading to hang (and postgresql deadlock)

    XMLWordPrintableJSON

    Details

      Description

      Alfresco connector gets stuck when processing documents around 35,000 and postgres manifold database in idle state and after days gets deadlock message
      "
      2016-12-21 10:54:17.946 UTC >ERROR: deadlock detected
      < 2016-12-21 10:54:17.946 UTC >DETAIL: Process 28072 waits for ShareLock on transaction 432231; blocked by process 28038.
      Process 28038 waits for ShareLock on transaction 432227; blocked by process 28072.
      Process 28072: UPDATE jobqueue SET failtime=NULL,checktime=$1,failcount=NULL,checkaction=$2 WHERE jobid=$3 AND (status=$4 OR status=$5)
      Process 28038: SELECT needpriority FROM jobqueue WHERE id=$1 FOR UPDATE
      < 2016-12-21 10:54:17.946 UTC >HINT: See server log for query details."

      On separate note, ran ant load-pg and it was completed successfully.

        Attachments

        1. jstack5.out
          48 kB
          Chalitha Perera

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              chalitha.perera Chalitha Perera
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: