Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cuGYn-0004Er-3a for pgsql-hackers@arkaria.postgresql.org; Sat, 01 Apr 2017 10:47:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cuGYm-0000fW-2Z for pgsql-hackers@arkaria.postgresql.org; Sat, 01 Apr 2017 10:47:08 +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 1cuGXI-0006RC-H9 for pgsql-hackers@postgresql.org; Sat, 01 Apr 2017 10:45:36 +0000 Received: from gauss.credativ.com ([93.94.130.89]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cuGWw-0006mc-T4 for pgsql-hackers@postgresql.org; Sat, 01 Apr 2017 10:45:35 +0000 Received: from gauss.credativ.com (localhost [127.0.0.1]) by gauss.credativ.com (Postfix) with ESMTP id B09591E1945; Sat, 1 Apr 2017 12:45:12 +0200 (CEST) Received: from ex (ip-109-40-2-79.web.vodafone.de [109.40.2.79]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: ase@gauss.credativ.com) by gauss.credativ.com (Postfix) with ESMTPSA id 499DA1E18B9; Sat, 1 Apr 2017 12:45:12 +0200 (CEST) From: Andreas Seltenreich To: Ashutosh Sharma Cc: pgsql-hackers Subject: Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint References: <87o9wo8o0j.fsf@credativ.de> <87a8868td0.fsf@credativ.de> X-PGP-Key: 4096R/803D1FFF 2015-02-04 Key fingerprint = 4758 81DC 8539 494D 29B4 692D F587 0601 803D 1FFF Date: Sat, 01 Apr 2017 12:45:09 +0200 In-Reply-To: <87a8868td0.fsf@credativ.de> (Andreas Seltenreich's message of "Mon, 27 Mar 2017 20:30:51 +0200") Message-ID: <87tw685ruy.fsf@credativ.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Andreas Seltenreich writes: >>> TRAP: FailedAssertion("!(LWLockHeldByMe(((LWLock*) (&(bufHdr)->content_lock))))", File: "bufmgr.c", Line: 3397) > I got about one TRAP per hour when testing on 20 nodes with one postgres > and 5 sqlsmithes on each. > Ashutosh Sharma writes: >> [2. reacquire_lock_hashkillitems_if_required.patch] I've done about 12 hours of testing since applying this patch and no failed assertions so far. regards, Andreas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers