Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRAtO-0003qQ-QZ for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2017 04:52:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cRAtN-0000LE-Qp for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2017 04:52:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cRArf-0006oT-UY for pgsql-admin@postgresql.org; Wed, 11 Jan 2017 04:50:24 +0000 Received: from mail-it0-x242.google.com ([2607:f8b0:4001:c0b::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cRArZ-0004N4-Je for pgsql-admin@postgresql.org; Wed, 11 Jan 2017 04:50:20 +0000 Received: by mail-it0-x242.google.com with SMTP id o138so1607636ito.3 for ; Tue, 10 Jan 2017 20:50:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=propaas-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=A8r3mTmSvMKuJQL3VJ9ECFUK/zfz8bDrxZGFWZUNyZ0=; b=VzhlcrEkJFNCr2hucS0017UmGyMqEBznoX0YOI93nGnSuOFSaGdeaN4cFj72yhT9+w j27QpRT4zXuYAbnhdFY9X7Uwsm5fKFzqngS2r/pYSA6tzwZ7EdFt/cvOOypQAtRK01co Vf/rQba70L7LlO5MkYLt9kaGy57wQaHo8tAWyqedxmSBPtbumtAGou4HhfRgaEPiDzPu i9G+6DvYfq4vUH3qLT8FvKMgCisMk/yMSqgohfsTBZl5fP8Z3pc+MYGySWQBi12XA3C3 ifZW6xtOaYZjrop2l7zvPycY74iWw8+nvM9vKgW+RKsrAVoceuaBc5dnWnyJ5YobHJhE D9Ww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=A8r3mTmSvMKuJQL3VJ9ECFUK/zfz8bDrxZGFWZUNyZ0=; b=gStnd1Y30lm1zNtXIWDPBFaxDQZ2sLjRVUXgzfycp8fgVjwU/ww4FoVW5iBMKGQOP8 klaYq/LAsABbiqlHU24xj8GB+gRnWVbpOEkwPU9Yz8ziwu7DaHlJ12VyWMiHN64SOLVl fnkeW74Pu17vxJQBLrRnTkoPHNOBk+ga/PTYbxj6yrdhW68MtoKrtgmFbB6aKkYFr2MI CgFNCd4wDQzozskB1PuN58CLUikXRIYd9lerpdv3CBGTzIStvdeE0/51or5ZvqVNpgio /mpIeOMq7EZrVKnTCpSXlwKRnHCfxGB5Cg2rztzB1GPO5eqtjpPkLauuTkMl7Dl3e7L6 G+EQ== X-Gm-Message-State: AIkVDXLQegQfQlabhA2vSxXMoDUbQPOMRv3GGDRzPmxPxJBqSueTgV/qwW6ci61jy53fBA== X-Received: by 10.36.20.66 with SMTP id 63mr6427900itg.103.1484110215373; Tue, 10 Jan 2017 20:50:15 -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 f187sm2537842ita.7.2017.01.10.20.50.13 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 10 Jan 2017 20:50:14 -0800 (PST) Subject: Re: Lock Error To: Tom Lane References: <6d59d2ac-26cc-2452-ff10-2302a646cd6c@propaas.com> <15916.1484101605@sss.pgh.pa.us> Cc: pgsql-admin@postgresql.org From: ProPAAS DBA Message-ID: <92300a1a-2c0d-2079-b2ae-e45a894ebc10@propaas.com> Date: Tue, 10 Jan 2017 21:50:13 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.5.1 MIME-Version: 1.0 In-Reply-To: <15916.1484101605@sss.pgh.pa.us> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org I'll check with the client and see if we can re-create it, they claim this error is happening daily. Would a log file help to start with? On 01/10/2017 07:26 PM, Tom Lane wrote: > ProPAAS DBA writes: >> Anyone know what the cause of this error might be? >> ERROR: lock main [some number] is not held > That would be a bug. If you can reproduce it, we'd like to see how. > > regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin