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 1p1QQn-0005x6-Ab for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 11:11:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1QQm-0006oP-73 for pgsql-general@arkaria.postgresql.org; Sat, 03 Dec 2022 11:11:40 +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 1p14hW-0000xD-13 for pgsql-general@lists.postgresql.org; Fri, 02 Dec 2022 11:59:30 +0000 Received: from sonic319-25.consmr.mail.gq1.yahoo.com ([98.137.66.206]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p14hQ-0008B4-QE for pgsql-general@postgresql.org; Fri, 02 Dec 2022 11:59:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1669982360; bh=oduftAd9rzXdntYo0La4//MHcGt+0J9WxK9/9KAe9co=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=OAGN4+xcSKzJD6mayo5t7RFnVgRcZNf7Vlo/XLUuJ2OrslLEpV4Ei3jIzSyv/KEMQeEv69YYCuc4ug3jrbjJICbLSuzUPd/XNoOts4QJuxGv1a2dHiDyjnoopQ7/9alvFVjAjKcYQDux0eCjyhBKTg43WjQCq2aVzlSuy2LrKWf1jtWSiKGvCg+O2XGCVSeFxbfaSomM34LPXjv1AzbvVvocwiT8U9ujTWXuMlLAB7kmNn4LgiV7Ey6q/AU4MNODlsAekzAnxv0uSgX1Fl+wCUi717UBXXxGto4jQXfwH6IBzXoMag6nX5rWPLZK0MN2koCjJ9rQMaC3orQIN04vxQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1669982360; bh=44Jfxju27M2LBSpQj6MQNaH2p8rwZyaPz55fvRns892=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=c4DxXxkuHUE94q2gr+RjNy9+ij/pE0M8RhiVFD5B1eW81d5QMQHjzGdtd+u4khfWFBAxjwraVJnmqT1Q2S24Noc44h8YyAuGgEyBfxOI3eaAkR5i3QRED+E4ocYHlOt1u5mQOKVhjm8vsPkI3yvx/ikWoAr7445MFfhoTUflWZK92WQxzPWBaPoeuCfcAF6X6nXb/wMW6Y/B0MChrA3RsIsSVWf1Rybymk8jOyJLCUIOd5rzvOaXvocDTAlZ1335XmuoeaKGIGsJU4wV47szwqXDhpiQXihhArLnhVd1C/5tME/uK8i1JCgdiurUScT+upPXd0XEcvR9/y1MnF4agQ== X-YMail-OSG: 18PTpkYVM1lKYt_aYd4mvvx1bOaZyWj6kiUUmNfvfZMfTsUUYv9N1c8WxdWYTVk OaMZe1Xtl4p99eDh12JhPPZF08DH_J.ojfRamJs7T0KrLmOF.ow1bLgKs2hLltJmhaqf4nbv6l5l X3Zp5_FJnZcdEhZPpNx0GXCGVlPKvVCgBfZfTz.RAH6J8_l9cbiqm1IkowVZ7eDdQlxCSOxo8tnt GXTUiMJPQT.MKv6NpDfgqA.Ib6t3FGMITdTwRhP06At8yKmwwHTfiOKJrcGHWXcU7g.tew_f_.Q2 4EVDD0unsvjNdySZd4l.E9GUFeuBlZfp8fqXG.SILlyt56yKDOX5.YModRjXDSG9kfarp4LDV7NR uLZr7r_Jvn3BwoEfnROSGYNzYLiY0EtxMQYBxjPc0RP9ToV.kemGkZprnFdk9be3V10gZDkCBzxc igt4PFQqdFLEYwHBNsUpuMfiL8TGQs.gFjvMsTgPPXQ4tI.NyMfvLwpu8mrC72R1kl5oYJrZHEJp TMXkS3lCh1m43nd9nC0SK1AdIL15VsVKxM7IWhzOxYizipeQtMjAZVjN_G05YAoDo_XseRlaZzDF 92aI2wTv0sSUY9xZybUFXSSpo3474ViGhFgzkYK6A8jtiIMu.U8c1mmaAeAIuZO_VwsdzULFtsi1 PfUR5xF_zwZZs32m.dtBE8EdNHSkhcHWpCQx682b0UpR._kYU9DiCXVHVJZ7s8ybTiE7xuX4ZcPZ oygexWuZ1r1R1QJ4_yUyFRIuK9WSIf6meVZeCLL2q7jkjwgC2nDCBYh1_l2SRAsOJk1YPXp.1mEo rCOP3YNYWqm3zXS4C.DDxEMLGVhIMmFrSGP6wH11bD3kwHtZqxU_LFFuB30rXN6ES59vuH6oHOam 5TtXAU7lusHSUgPAShqjSumjv7u09IjHTrCYbjHWDvNx7NccXoIZh46d0ZdIlo1DfWM0rFxi9OOG ezQW78BLQDsWnKKAV6StbUjr8u2Gvy1SRkzIjdAEQP2VALwnvmytou_h9jQpqLt7zNalNfRS1qp8 UJhVmiZQQJazNM3t63BNHSBylp_zuC4jLDRKh3Q.8mhSK.aSu9YwdG0Vm_tv46M1hwDYoMWw4MaC AZTWL24zfd9Iot2OZrlqq02GXqRl4OQDsula0mTUzHjj3kMzA5uMJx7ojGWQU776SDR5FIMN.svb 8_sQjlX7zDzwTuLLWKOz6HcO_u5eqvXnBVu4QOl1LovJHGaTHvFbG64yMkE_.gWJZoZY1PLAcQb7 _qfYm4P0DeuRnqzsAiJpUeJL00fmuGvIAH22eN7CZt7nlcG60noxpTOOEoCs.P8U.TDCTepMXoEp DAbCL_BwK3LzCH8RIRxLG.YfDLAixWSplkkl5gzPg4z.IhSZ7.yX2Dn4HRz2cFB1er2qjzMvsxiA frqEgt4XU7l_rfC88lsizeo3Phq8yPuSTN0saElSHyPYQR4RI5J0agX0TmearMa3B.EyxFY3E8ml uiUh5HzLvC0unuq38vec2hlhLM1CkTRy_NkITvgMRydI.VCluZccn3aIsujggO9II5I1fVxPYlt. VzLlY88P5vkaOht2zyuFKwwojTNhB02g1iNTC6unqF_Xgv.00g2T0MywkW.VdJPApvFhh6jfNki0 KByhgQjH2t.YBD_UdKHxQcctH2nyX25rF_BSuQIHS89BLovT37X61oi5c9JfwKRrwo2tB2l4H5WG p5dvpktpZSJEStAgygGQRNDPThJ5mDnA6h54W9Ermurof1rHAgoOFQDQQiGIxLa13_JABJxpss46 zQdJ3qrF_TwpH6kwCtNGSXQQwQbNq7Md5uWVLU8ex.4_fwm.PetswZmuKPFI0GCuZQIALzt.AYK3 SgTrvKK6y.Kua9Dnbu8EdJ0wNPzpyGYRwO9mOfkVMJ0g1dfhkrjrqUL1p9EtGqDbYUmFYkvPjehu H0tmdLkn.fW2yaYLlvHJB5NSjBI_AKInPdatwDqJSyY2Tbx2hZUmNUdWK8dDgX17BbT1qmpLToue 5wFs4jSuNhfHSn0WNTBoRpqGAe4PkKyDIeDO6n2WQwVhisewq_rCLhyRj5N51lGamCeyIkFTZn44 hVmrR96XZkK1gZqxYvvkGe.HcI3PoLKkhJxgKTrXSbBrKNEV..bNbqFQ4hO4iv34dmjvkNWUoQNC 6IiSLZ2A_9TzmZ8Nypxls1OUEqVlyPldkG6n9U72o07PHpl1jsJwcA.gr8ecfVPpewk_.icsOO0W LwFE- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic319.consmr.mail.gq1.yahoo.com with HTTP; Fri, 2 Dec 2022 11:59:20 +0000 Date: Fri, 2 Dec 2022 11:59:18 +0000 (UTC) From: Ludwig Isaac Lim To: "pgsql-general@postgresql.org" Message-ID: <1649936435.214554.1669982358413@mail.yahoo.com> Subject: print in plpython not appearing in logs MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <1649936435.214554.1669982358413.ref@mail.yahoo.com> X-Mailer: WebService/1.1.20926 YMailNorrin Content-Length: 2415 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I'm having problems wherein my print() statements inside my plpython stored= proc are not appearing in postgresql log. I tried setting the file=3Dsys.s= tderr To reproduce: CREATE OR REPLACE PROCEDURE p_ludwig_test() AS $$ =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 import sys =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 try: =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0x =3D 1 / 0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 except: =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0plpy.log("hello") =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0print("oink oink", file=3Dsys.stderr) =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0print("oink oink - v2") =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0plpy.log("haha") $$ LANGUAGE plpython3u; call p_ludwig_test() Output: --------------------- 2022-12-02 11:46:11.324 UTC [19390] LOG:=C2=A0 hello 2022-12-02 11:46:11.324 UTC [19390] CONTEXT:=C2=A0 PL/Python procedure "p_l= udwig_test" 2022-12-02 11:46:11.324 UTC [19390] STATEMENT:=C2=A0 call p_ludwig_test(); 2022-12-02 11:46:11.324 UTC [19390] LOG:=C2=A0 haha 2022-12-02 11:46:11.324 UTC [19390] CONTEXT:=C2=A0 PL/Python procedure "p_l= udwig_test" 2022-12-02 11:46:11.324 UTC [19390] STATEMENT:=C2=A0 call p_ludwig_test(); Notice that the "oink oink"=C2=A0 is=C2=A0 not there. Relevant logging configuration: logging_collector =3D on=C2=A0 =C2=A0=C2=A0 log_directory =3D 'logs'=C2=A0=C2=A0 log_min_messages =3D info=C2=A0 log_min_error_statement =3D error=C2=A0 PG version ------------------- =C2=A0PostgreSQL 14.6 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7= .3.1 20180712 (Red Hat 7.3.1-15), 64-bit The reason why I'm trying to use print() is because plpy logger is quite ve= rbose. Each logging will output 3 line for example: =C2=A0 =C2=A0plpy.log("hello") Will generate the following 3 lines in the log: 2022-12-02 11:46:11.324 UTC [19390] LOG:=C2=A0 hello 2022-12-02 11:46:11.324 UTC [19390] CONTEXT:=C2=A0 PL/Python procedure "p_l= udwig_test" 2022-12-02 11:46:11.324 UTC [19390] STATEMENT:=C2=A0 call p_ludwig_test(); Another thing is there is another stored procedure that I have wherein the = print() to stderr actually works, so I'm not sure what I'm doing wrong. Thank you in advance, Ludwig