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 1sOGL4-00DJxY-G4 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jul 2024 12:40:58 +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 1sOGL2-001UfJ-A8 for pgsql-admin@arkaria.postgresql.org; Mon, 01 Jul 2024 12:40:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOGL1-001Uf3-VF for pgsql-admin@lists.postgresql.org; Mon, 01 Jul 2024 12:40:56 +0000 Received: from mail-ed1-x52c.google.com ([2a00:1450:4864:20::52c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sOGKz-0041un-JT for pgsql-admin@postgresql.org; Mon, 01 Jul 2024 12:40:55 +0000 Received: by mail-ed1-x52c.google.com with SMTP id 4fb4d7f45d1cf-57d1d45ba34so268458a12.3 for ; Mon, 01 Jul 2024 05:40:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1719837652; x=1720442452; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt:date:to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=16QSqJs1rI7Djce6x0CACYiZm5MiWy528kvliQ84gx4=; b=I3O2FL2IiU3P6bUdAwgdXLyYXJEdUu1tGe4xEqhxp8BXjaz8vw79Ex3rC+dwjiN+ds X0cuJMxwCbblJNmAIfj2HF3wFtmAqhTkOePAE2SzWppGLjcsLZyp2ugCq4+9xmkOZFbh ypT4Bx3PbdWgguWCg/yjOWCE45s2pYknwLkCuD2LfMHQnZXG9h8Hqbl95XvqKXEij+PD H1ymcGHabx/bnuE5zlTJ7MOEOU1Qh2jDS5G98piL+eF0LTntveZ00r36mGnyqk9yWhOS Ht6GEJieoHKQ1u1i+1ZuZ4gbsz/uTJdu59WOFVZsO9y4wqYyvDvkPuLo3hm+ca6lQlu1 axFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719837652; x=1720442452; h=mime-version:user-agent:content-transfer-encoding:autocrypt:date:to :from:subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=16QSqJs1rI7Djce6x0CACYiZm5MiWy528kvliQ84gx4=; b=AMrJJRTrirtd56YEURZZaDb81qzpSabtGruN9nYqfrWzCptmtxYlptqk3lPXtyly2g fnVUdioqmk06EFucEwjcleskUJsdRnW7t0BEgQJpprINkyqG2wKkym92VTyHAMJ1O3ds nHnrsinIrN5SAesVGeSC5TFMPQ28xJeKnHakasLxePD8oSFpE6VigsblCoFP7btDrK3u tiSsBBRqUyGUUNo2K4xsn7GxwMmctip34r/LBHmfiXYPQSh2Q5gEKX1rWcsfpoOVxnqY yXEguBOjH1POB0xZzy25O8E3ctqSB0RGzDGxQXGg1kGRoGPe4leZy3v5xjegiePpaTWz HGFg== X-Forwarded-Encrypted: i=1; AJvYcCUwG44dxSKwVz1Oims9botau59Zwi2t2iUi7EWzwuxJLDI1eiDgB9d/dvgyECknxtGgF7zXon4JYOEkIt4q04DrAdBwi770y3gZdw== X-Gm-Message-State: AOJu0YzRb8tcE636eWf9W+fUVsvfIHRB/3JkuIzRzyVxGBi0d/u2ACAW 56YawgVD1cn7iLSWw7/BXLH6xFBVxmuPHK7PpFFx1t85yrY5Js/QOB0Z0S7Ky7o= X-Google-Smtp-Source: AGHT+IGHu6FEiWD+xenJ7wxMFaSXGJ598bQc4JJfozvjzCq+77bKM0aBfs0ruEBZ9YgAyEz4CUmaWw== X-Received: by 2002:a05:6402:354f:b0:57c:ff70:5429 with SMTP id 4fb4d7f45d1cf-5879f0cbec6mr3404778a12.8.1719837651756; Mon, 01 Jul 2024 05:40:51 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:39a5:f244:3f01:d160:93bb]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-58614f3d3f1sm4326694a12.94.2024.07.01.05.40.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 01 Jul 2024 05:40:51 -0700 (PDT) Message-ID: Subject: Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process From: Laurenz Albe To: veerendra.pulapa@ashnik.com, pgsql-admin@postgresql.org Date: Mon, 01 Jul 2024 14:40:50 +0200 Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Veerendra Pulapa wrote: > I am reaching out to discuss an issue we recently encountered with our Po= stgreSQL > setup, where a bug triggered on our standby servers before it affected th= e master. > I am seeking insights into whether the resource differences between our s= ervers > could have played a role in this sequence of events. > > Issue Overview: > > We observed a signal 11 (segmentation fault) error that first appeared on= our > standby servers and subsequently affected the master server. Please don't hijack another thread, start your own. You should tell us the exact PostgreSQL version and operating system. Also, tell us exactly what you did to trigger the problem. Collect a core dump and get a stack trace (you need debugging symbols): https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_b= ackend Yours, Laurenz Albe