Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jH4Nb-0001fZ-1b for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2020 11:39:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jH4NZ-0001g9-Qd for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2020 11:39:25 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1jH4NZ-0001g2-Dz for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2020 11:39:25 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jH4NW-000059-90 for pgsql-hackers@postgresql.org; Wed, 25 Mar 2020 11:39:25 +0000 Received: by mail-qt1-x843.google.com with SMTP id t9so1783782qto.9 for ; Wed, 25 Mar 2020 04:39:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=K2nIUZ+bGlTE4w1aHyfoldNpJAkYY8PLO23Sgn7ibyM=; b=hA0CDSRLqoO4AY2Sg4pCYIU34T9lsa5tccMt/uCw3z2mT1JsTL/SnNX0NK68lNQRBL 55gu2d4W74+jxCqy9hzGfPPUFWWMfw3wUpY1a5QtO2f1uTlvqNdVbzVrCCvLpEvp0L0a RyIdFsaCsHFZ71iUzLyZVYTJ6pvqltUUaWLo6pcYQHasvchJPGlH/jNnB89T6gd0M0U1 g1IjxOF2X/Nt9OqLylaitHIs+ZAN0uRxnLr0z957LfgEQQaaV+oFaJ0LN1tzZXnDcaUq LlwRYXn0yJeri58SuDB8X5rzG3tcQKJwqr6vu2PlIpM87BMHSed3UVcHWGimQrD5Nwey p9wA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=K2nIUZ+bGlTE4w1aHyfoldNpJAkYY8PLO23Sgn7ibyM=; b=mGKbQI3S2D7hdCk/tDSMM6fOa2xmFL5cZyQ5Jv9x28Ckwa6D2YpFRjeYjVdcAgkrxa VFVmkNb1S9q2U0SECwR1CuozZbOHVWURjoV61j6IwRB8gEgndWo1GnlG7v+2wGXlAI2c NxvZh/xTMNv59TBJs6zNQLmUlnzmjIs/aCO4B9sm59jCGdxM3iAoteXlLQnuZW675GdZ ndNfl4f5YYpyYYotaxxszqs02Ixm4Qz3BgfVqcmkoPtbuSbGJbxoj91FR3qRYiWy3g0w 0rqqjIDdZArt8IwjKqv1x1mTREhaTsTJEB0k8ZGxKXDROhfUvDRBjkYgcV5H0JrKwZDC bJwg== X-Gm-Message-State: ANhLgQ1m3yocNEjZwV1Z9QGQc7Ft1dtrQZR3reXMnaUb0pq8bJJS9MPr J7wM6et1p0qh+M0Of64FTLSrxw== X-Google-Smtp-Source: ADFU+vtHZy921HSMUhUlJRmiieNmnbDOXZu/rfXSFmrGVyvral//X/ZUfRnc8GUTDz0i+vDrIzXpyQ== X-Received: by 2002:ac8:1bf5:: with SMTP id m50mr2404114qtk.200.1585136360352; Wed, 25 Mar 2020 04:39:20 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id s188sm12365636qkh.67.2020.03.25.04.39.19 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 25 Mar 2020 04:39:19 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id AF7F6800C28; Wed, 25 Mar 2020 06:39:17 -0500 (CDT) Date: Wed, 25 Mar 2020 06:39:17 -0500 From: Justin Pryzby To: Amit Kapila Cc: Masahiko Sawada , Alvaro Herrera , Andres Freund , Michael Paquier , pgsql-hackers Subject: Re: error context for vacuum to include block number Message-ID: <20200325113917.GT21443@telsasoft.com> References: <20200325101229.GR21443@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, Mar 25, 2020 at 04:54:41PM +0530, Amit Kapila wrote: > On Wed, Mar 25, 2020 at 3:42 PM Justin Pryzby wrote: > > > > Attached patch addressing these. > > > > Thanks, you forgot to remove the below declaration which I have > removed in attached. Yes I saw.. > Apart from this, I have ran pgindent and now I think it is in good > shape. Do you have any other comments? Sawada-San, can you also I did just notice/remember while testing trucate that autovacuum does this: src/backend/postmaster/autovacuum.c: errcontext("automatic vacuum of table \"%s.%s.%s\"", And that appears to be interacting correctly. For example if you add an elog(ERROR) and run UPDATE/DELETE, and wait autovacuum_naptime, then it shows both contexts. -- Justin