Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jtmdx-0000ka-D3 for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2020 06:36:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jtmdw-0004Lc-Ao for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Jul 2020 06:36:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jtmdv-0004LT-CV for pgsql-hackers@lists.postgresql.org; Fri, 10 Jul 2020 06:36:20 +0000 Received: from wforward3-smtp.messagingengine.com ([64.147.123.22]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jtmdr-0005O9-CP for pgsql-hackers@postgresql.org; Fri, 10 Jul 2020 06:36:19 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.west.internal (Postfix) with ESMTP id 06F5ED49; Fri, 10 Jul 2020 02:36:11 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Fri, 10 Jul 2020 02:36:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=CzQENijrb4anFGeFDZExtJSJpvKRUmb3ZcMzoh+FX qU=; b=ORyP/MrErFFG1cW2xkNqYPBKPC3QVXaYl28nm7jFDurvzjdp8EV9sQbwR p/tcDN/6uCXs0gXTM2vk9MvEQa+PYLriszmlmPomch8lii6m4vi4RMIwEDIM9fuT tV60w7JWRNsURIAp9RIB3OKp3HPJn+xLviqNCewjOe415VsDO5eZ+YoOv0U093Ng dMrxtGU0O+7RCK1qByOO42BYuVNw7BXGBCE3H+xVZnDtVGSomS+IXpESmVQ7CzPo gMugphNesjK4pbnVkq1eB0NREmos3AasutJaLRrppY6Lhs797zx9N5QMARH5DJ++ Gz7jS0X+wBErmamfIc/lMHxdG+zHg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrvddtgdduudduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeehnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnhepveeuteelvdeuudfggfev udegudfhvdekgeeufefhtdeguedugefhheeugeefhfeinecuffhomhgrihhnpedvnhguqh hurggurhgrnhhtrdgtohhmnecukfhppeelfedrvdegfedrudeluddrvdefkeenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvih hsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomh X-ME-Proxy: Received: from april.pezone.net (p5df3bfee.dip0.t-ipconnect.de [93.243.191.238]) by mail.messagingengine.com (Postfix) with ESMTPA id 1A6053280059; Fri, 10 Jul 2020 02:36:09 -0400 (EDT) Subject: Re: Log the location field before any backtrace To: Michael Paquier , Alvaro Herrera References: <20200709163138.GA23549@alvherre.pgsql> <20200710020324.GI11153@paquier.xyz> Cc: Daniel Gustafsson , pgsql-hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <9ca6e1c0-3aed-5cbb-5700-b503831ccdb7@2ndquadrant.com> Date: Fri, 10 Jul 2020 08:36:07 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20200710020324.GI11153@paquier.xyz> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-07-10 04:04, Michael Paquier wrote: > On Thu, Jul 09, 2020 at 12:31:38PM -0400, Alvaro Herrera wrote: >> On 2020-Jul-09, Daniel Gustafsson wrote: >>> On 9 Jul 2020, at 11:17, Peter Eisentraut wrote: >>>> >>>> In PG13, we added the ability to add backtraces to the log >>>> output. After some practical experience with it, I think the >>>> order in which the BACKTRACE and the LOCATION fields are printed >>>> is wrong. I propose we put the LOCATION field before the >>>> BACKTRACE field, not after. This makes more sense because the >>>> location is effectively at the lowest level of the backtrace. >>> >>> Makes sense, +1 >> >> Likewise > > +1. committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services