Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAZPX-007D7m-Hc for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Dec 2023 17:40:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rAZPV-004xIZ-Uw for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Dec 2023 17:40:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAZPV-004xIR-LN for pgsql-hackers@lists.postgresql.org; Tue, 05 Dec 2023 17:40:41 +0000 Received: from mail-il1-x12a.google.com ([2607:f8b0:4864:20::12a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rAZPS-00AFv4-PE for pgsql-hackers@postgresql.org; Tue, 05 Dec 2023 17:40:40 +0000 Received: by mail-il1-x12a.google.com with SMTP id e9e14a558f8ab-35d77fb7d94so6321405ab.0 for ; Tue, 05 Dec 2023 09:40:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701798037; x=1702402837; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=IppIBLFIDhEw/4FwkIpYnuL+WN0PuXUx6k3NeyJ8uO0=; b=cCutuzZIC0od5nISAe66GlTUeRhvJiDoEoAaGoJP+kHka2sXqht1j84O2mOrSqErJP wKi+1m+Dw6MiENGXH3LN0IFhRNG/QeInVh5PuiVUMigitO6xitDHyfQfWHL76ke2V77+ MrvvFJbaXxSVy09A7FcUgkGqjMFFVI39B9kID8H1YyBGPctxCRUsxKlLtb9EoJV4IBx5 +7sKnu8jDzmHcjiRYLO1ZbW8adO5CXpX7FZpS1qFIfUy9psnwhtpbX5zVphryWvI21qu YsVAViF1YYk4wfgn8m/sDMhi+0Qu003kWpagVc3bhFpchy96kB8wmkcCQrld67sp1POi h0bw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701798037; x=1702402837; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=IppIBLFIDhEw/4FwkIpYnuL+WN0PuXUx6k3NeyJ8uO0=; b=H4ku9iou3YyltipmTn/cCMFTn8/lGEgCUZ/tukkOZbGkHD5zqmS/duy7uxmUQ1KGSM HHU0fqunXR0mdcfiYGIOzFlm4/Pz2Ia0UxpqpaSxYh2/Q45iUoyWtHZgPqThQ/dhNIaM hdpU/nAD1ZOLqSpHDmw5YQpMbnfDFLlAHxx+6+IBGkFDZh15sccjYAA8/z1fXKDBgwU+ fK07bGJ5Fdnhe3sFnscS3tyJIaTFrZYQkmLPEAMzt1eQ91d+reKx1wZNGWiCavWQBfAF 8V8+FyfDGd2fobJb0s3NzD5E+N7WstrNGAUgnAOaObVCrIPPNIqaMLn5Y4rogpLraOle BGOg== X-Gm-Message-State: AOJu0Ywsbg+ZdDcpCNuXq3QBEiVZlDiylawWHqfY2cId5SY4S/+b8IHa QXSkS9rSW0j0wocfFHP62E8= X-Google-Smtp-Source: AGHT+IGe/8rs+W1g6uUV5IEhi/2tz3WZ7YwMTo1NL/0L7pltjQ54YcamQ51kHCM1Oak+TRy/A/WhdA== X-Received: by 2002:a92:d3c3:0:b0:35d:6078:c9c1 with SMTP id c3-20020a92d3c3000000b0035d6078c9c1mr6816340ilh.28.1701798036806; Tue, 05 Dec 2023 09:40:36 -0800 (PST) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id fr2-20020a056638658200b00463ffa38f99sm3210562jab.179.2023.12.05.09.40.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 05 Dec 2023 09:40:36 -0800 (PST) Date: Tue, 5 Dec 2023 11:40:34 -0600 From: Nathan Bossart To: Peter Eisentraut Cc: pgsql-hackers Subject: Re: backtrace_on_internal_error Message-ID: <20231205174034.GA2757816@nathanxps13> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Dec 05, 2023 at 11:55:05AM +0100, Peter Eisentraut wrote: > Would others find this useful? Yes. I think I would use this pretty frequently. > Any other settings or variants in this area > that should be considered while we're here? IMO it would be nice to have a way to turn on backtraces for everything, or at least everything above a certain logging level. That would primarily be useful for when you don't know exactly which C function is producing the error. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com