Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46195=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cR6d9-00007X-2F
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2017 00:19:07 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46195=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cR6d8-0001Hl-Gv
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2017 00:19:06 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <dba@propaas.com>)
	id 1cR6bQ-0007jI-PQ
	for pgsql-admin@postgresql.org; Wed, 11 Jan 2017 00:17:21 +0000
Received: from mail-io0-x242.google.com ([2607:f8b0:4001:c06::242])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <dba@propaas.com>)
	id 1cR6bJ-0007No-7Q
	for pgsql-admin@postgresql.org; Wed, 11 Jan 2017 00:17:18 +0000
Received: by mail-io0-x242.google.com with SMTP id q20so13156973ioi.3
        for <pgsql-admin@postgresql.org>;
 Tue, 10 Jan 2017 16:17:12 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=propaas-com.20150623.gappssmtp.com; s=20150623;
        h=to:from:subject:message-id:date:user-agent:mime-version
         :content-transfer-encoding;
        bh=9xFpXKe2Ro7pTxj8OeMGXHyU4Kf/zYGcdAAyMqIKty8=;
        b=Utndk/JNz58Bch1fbMDOJxiBOBOAp7KfZk/jq5Zzd4/DjwbKcJqWBi1dHcub34ptlY
         ag9x6MkH+zuy/jRxnlSbBrZMEd5WolcCyI4RsbiuVgD7OYa0E3H9Rmi3GPhd1Sjc5r8Q
         ToCLBn2zYtgYxD2i1hC3AZUGWiN52zCeUrSBiICnoYxU4wL7DabgkfhQjtBgsZA7YJiB
         8Ai+tlGdWF5wdHMQJB0fnef7maAZUlZhQymfv3ru62FG6DWTVbB+dWKP4IYu4uED8EHF
         F0g8wxTMiqIuUB/nDEpRUn8R8eLJKspGHbieG17Bj5aWNrlCxnS2JlfDVA/WxkivopaA
         gfAg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:to:from:subject:message-id:date:user-agent
         :mime-version:content-transfer-encoding;
        bh=9xFpXKe2Ro7pTxj8OeMGXHyU4Kf/zYGcdAAyMqIKty8=;
        b=ECyRJdHQ7IiJRnVWJraH7MrvH6TZs8GXez/ljEJ0L1OmCRk9jMyho4F32gmmSmORAN
         J8QfD59tJMaL19bwWF4K8GelsgxQMyDTmtAycv6L71vcMnWl7/w8sKWSRBKErcSmdjlQ
         5EVDsRNO0DEM9NOs4VT63Cn7yvhLJ6KZ+z5u4Dgk8p4WCAiJ8mrIsqD9fOY5n9+KiNVK
         YeV4Pwxjp6u2WItAbzD8VWxuhTJds1DPwMQce+b/Exd9cBwcBWjSVYb2u0w5z4brBSTu
         zK7mKND9nGyiUTBTPtUb30UC3lIUyBJz4DL/4L6eBLPJQ0wmNEFdZcXSszkWj3sDyFEg
         HN3w==
X-Gm-Message-State: 
 AIkVDXLq8YU5ViJ2X+Dl8UJQjB1lGHP5R8saXPgl6kkR2g0xdViMeqks1yFViSumv0kPRg==
X-Received: by 10.107.175.221 with SMTP id p90mr6669659ioo.80.1484093831351;
        Tue, 10 Jan 2017 16:17:11 -0800 (PST)
Received: from [192.168.1.17] (c-24-9-41-137.hsd1.co.comcast.net.
 [24.9.41.137])
        by smtp.gmail.com with ESMTPSA id
 k205sm9070911ita.15.2017.01.10.16.17.09
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Tue, 10 Jan 2017 16:17:10 -0800 (PST)
To: pgsql-admin@postgresql.org
From: ProPAAS DBA <dba@propaas.com>
Subject: Lock Error
Message-ID: <6d59d2ac-26cc-2452-ff10-2302a646cd6c@propaas.com>
Date: Tue, 10 Jan 2017 17:17:09 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.5.1
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi all;


Anyone know what the cause of this error might be?


ERROR:  lock main [some number] is not held

for example:

ERROR:  lock main 74764 is not held


Thanks in advance...





-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin