Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id D3ADE200BFE for ; Mon, 16 Jan 2017 12:42:34 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id D21FE160B30; Mon, 16 Jan 2017 11:42:34 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 299C5160B22 for ; Mon, 16 Jan 2017 12:42:34 +0100 (CET) Received: (qmail 4425 invoked by uid 500); 16 Jan 2017 11:42:33 -0000 Mailing-List: contact dev-help@manifoldcf.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@manifoldcf.apache.org Delivered-To: mailing list dev@manifoldcf.apache.org Received: (qmail 4414 invoked by uid 99); 16 Jan 2017 11:42:33 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jan 2017 11:42:33 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id F225FC0C80 for ; Mon, 16 Jan 2017 11:42:32 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.199 X-Spam-Level: X-Spam-Status: No, score=-1.199 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id cCOBUpqjlTEE for ; Mon, 16 Jan 2017 11:42:32 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id F283B5FB5B for ; Mon, 16 Jan 2017 11:42:31 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 16F0EE865F for ; Mon, 16 Jan 2017 11:42:28 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 70E0A25288 for ; Mon, 16 Jan 2017 11:42:26 +0000 (UTC) Date: Mon, 16 Jan 2017 11:42:26 +0000 (UTC) From: "Karl Wright (JIRA)" To: dev@manifoldcf.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CONNECTORS-1367) Alfresco Connector deadlock with postgresql MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 16 Jan 2017 11:42:35 -0000 [ 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)