[
https://issues.apache.org/jira/browse/CONNECTORS-1367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15823817#comment-15823817
]
Karl Wright commented on CONNECTORS-1367:
-----------------------------------------
[~chalitha.perera] All jobs have schedule type. There should be absolutely
the ability to select this. If it's missing that implies that the UI for this
connector is also broken in some way.
> Alfresco Connector deadlock with postgresql
> -------------------------------------------
>
> Key: CONNECTORS-1367
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1367
> Project: ManifoldCF
> Issue Type: Bug
> Components: Alfresco webscript connector
> Affects Versions: ManifoldCF 2.5
> Reporter: Chalitha Perera
> Assignee: Karl Wright
> Attachments: jstack5.out
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
