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 1jCMQw-0003u8-5b for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2020 11:55:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jCMQu-0007H7-KX for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2020 11:55:24 +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 1jCMQu-0007DG-7b for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2020 11:55:24 +0000 Received: from mail-qv1-xf41.google.com ([2607:f8b0:4864:20::f41]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jCMQq-0005vy-S2 for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2020 11:55:23 +0000 Received: by mail-qv1-xf41.google.com with SMTP id u10so2425254qvi.2 for ; Thu, 12 Mar 2020 04:55:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=oZ+1k1JMpjdvtds0y0IG/a1b9PyOH03SKT7B8eWWl24=; b=HrXn3OU3rV/XQIPynjjqEcwYEaXRT9Xc9VWzx1kST2pxeBFozlXMVhfySQJASmJp8M DnJLIXQ7dSdpacTmrhPMDkgCyLDbK0icE/7yotslbiyKkYmB1uyXu4M4LAR50aOh//wD waNbRSOQYMia8kkdbotWiKzpbLhh6aq4gsATBudJPav69SzpzPVGsozVA76C6bAjsMvM 3kjl6KaiCM8j+QJ+760iAf1+8OXB3LRyU4/XRFlOaaTtekZNW0tQKTw8CZup79juavP3 O6Z+iW6jLBqt7lJkvi7+hdCyNwibmHpwDUeOTwvbgUKhuG/4ExaXJWmaRuah0+cOB6Dt 6wdQ== 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:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=oZ+1k1JMpjdvtds0y0IG/a1b9PyOH03SKT7B8eWWl24=; b=WEOSNYVp4cu/oXGk0ii+G3vOKDu1LCU24T5hWF7snf3sv3OBMo5jHAZCEWqUuIG2oo 8AYO6+/rI9kApf3TezkGdZwCHPrmkoQd+sevhmkh17+lJm5K16LfD9o8rYSF8z2mrdc3 QOePz4Rbkt2C9fRWSw4zb3rTZoaSuyQCV+oaUGhj1CohzE5WErOHpqHamOHRzcNrlaJo QpNoSLBEf/BwxzF7ziuk+tJFCnfsKB502QCMZ+pq2N1+RTBBJ8GZPbutqSEW1vPSrO2/ Fty/CsMTFQGG24DGnjTN3bGAAuLBXEWHkqq1AaTjCVNmpeAXJhGoct79DPY/Qmo2hZ6z jyhQ== X-Gm-Message-State: ANhLgQ2lsof6mt1l1Wuz9GlO5deAk/8p+OOVCy/8cVAbtlQZ8coNhik/ yd5JekmuxGQzdm0oYhYjclUCTXXCtjJ6M1gbo+9v+Asa6Xihn6CFGKyGHy0t3TZJ3mPuCmEc3tg FSbY3uVftVJiWjbgWiH6O/IkAd5fxdt5Sp8v7Z+mv2Xe6lYYFJgY1GC/0HFSBmZQEx0EOjrX9nH iqsYAnpGFTIQ== X-Google-Smtp-Source: ADFU+vurbvpnuiPJIw+32M+AtgQhpmXsA85jakYRLH/n2TsZvMXY5E3Qasea95ql+gkyl62HLU9Tbw== X-Received: by 2002:a0c:ac4e:: with SMTP id m14mr6739472qvb.37.1584014117214; Thu, 12 Mar 2020 04:55:17 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([179.56.30.174]) by smtp.gmail.com with ESMTPSA id k14sm2409085qkh.63.2020.03.12.04.55.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Mar 2020 04:55:16 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 308CD300AB8; Wed, 11 Mar 2020 19:14:57 -0300 (-03) Date: Wed, 11 Mar 2020 19:14:57 -0300 From: Alvaro Herrera To: "Demarest, Jamie" Cc: "pgsql-bugs@lists.postgresql.org" , "Tamayo, Cristofer" , "Cornman, Melody" Subject: Re: Postgresql create a core while trying log a message to syslog Message-ID: <20200311221457.GA5127@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3db74722-18cf-44dd-af9a-2575af201b66@CORPMAIL01.corp.sensis.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Mar-11, Demarest, Jamie wrote: > psql logging has been set up to log to syslog. When the syslog directory filled up psql trying to log to syslog cause psql to core. > > Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...(no debugging symbols found)...done. > (no debugging symbols found)...done. > [New LWP 7949] > [Thread debugging using libthread_db enabled] > Using host libthread_db library "/lib64/libthread_db.so.1". > Core was generated by `postgres: startup process recovering 000000050000000000000017 '. > Program terminated with signal 6, Aborted. > #0 0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6 > Missing separate debuginfos, use: debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64 > (gdb) bt > #0 0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6 > #1 0x00007f385ebb0ce8 in abort () from /lib64/libc.so.6 > #2 0x0000000000797058 in errfinish () > #3 0x000000000079aa38 in elog_finish () > #4 0x0000000000495db4 in heap_xlog_update () > #5 0x000000000049d1af in heap_redo () > #6 0x00000000004d8117 in StartupXLOG () Hmm. Please install debuginfo and get the backtrace again, as instructed: debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64 Thanks -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services