[CONNECTORS-1367] Alfresco Connector fails to complete seeding request, leading to hang (and postgresql deadlock)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 2.5
• Fix Version/s: ManifoldCF 2.7
• Component/s: Alfresco webscript connector
• Assignee: Karl Wright
• Reporter: Chalitha Perera
• Created: 16/Jan/17 05:31
• Updated: 21/Feb/18 11:57
• Resolved: 21/Feb/18 11:57

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.