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 1rg5Dl-0045D5-OV for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Mar 2024 15:54:50 +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 1rg5Dk-00DvWe-8L for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Mar 2024 15:54:48 +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 1rg5Dj-00DvWW-SS for pgsql-bugs@lists.postgresql.org; Fri, 01 Mar 2024 15:54:48 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rg5Dh-002HEW-NP for pgsql-bugs@lists.postgresql.org; Fri, 01 Mar 2024 15:54:47 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-2d094bc2244so30690841fa.1 for ; Fri, 01 Mar 2024 07:54:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dataegret-com.20230601.gappssmtp.com; s=20230601; t=1709308484; x=1709913284; darn=lists.postgresql.org; h=content-language:content-transfer-encoding:in-reply-to:mime-version :user-agent:date:message-id:from:references:to:subject:from:to:cc :subject:date:message-id:reply-to; bh=DPOHnEB2YlhMWaQ3iEVmENFana69VNEj3PFhrW1KCUM=; b=kZJsPsLq+vow4jSl9YgD31/DG2B8cFeKEryQz4tpPzL6VFv5oXYIWYfHoEfeO8ye0s q8swvVHHNRXcyyueUUtta/3JRJFsDa4VEVhmxSSkSO3fGDKTFHh0pDw1Njo2jLPWtjkO dzrm9OSDM0SBCAjZ1s+fC05pwp6ggyDYgOievFkV2qrV60dcWnKxr0lKqgO8NRyozFZr 8td6q9+3X+0uN5MmL9HpFh4EaHn1vw4ibTLjlo2efzugt8lWRbSKpiJq0YtnSNbs/M8k JR+Jnl1TEv/kS95Rk8dd4qk1ChdWZ5Kw05wW7MG6Ii861hJP/RZ+Kd10PRKv1+lp9xds 0qiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709308484; x=1709913284; h=content-language:content-transfer-encoding:in-reply-to:mime-version :user-agent:date:message-id:from:references:to:subject :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=DPOHnEB2YlhMWaQ3iEVmENFana69VNEj3PFhrW1KCUM=; b=FwdTtzi8Yx2HkJWrkAHc2g01Akew1MLtsa52SrEXeL+x0gm9g8njGtCFlgoQ5wbY48 aw+Kxb4UvmYFEoczLps4oEECSl2XOjSaS/dXSihwuc3NixCInQeHJ1CiEXGpidgfR0n7 9UIwJgsKpGfmQY4i95iS5CTxvJNbag6gds61gPD2HNLH8khIWCn/Q668GbEjIy3V8LPb r8+FHrvs1oih6laxt+mQIxdGZAZHFtvkX+Dr50vk6+cH3kQnqu80eiJaS0jVm3P79Wkc MGN7wTA3OdLIYpBS8bA/yLNttQ1wNC73kcZHc5HZjKLWWBBoSi26Z2Exid/gMUEZVAmk qcLg== X-Forwarded-Encrypted: i=1; AJvYcCWpFpvDEYAfWCbxZ2pGXT4KwEuoQaPb0Z/dHO1uO8uA3RzZaWF9ye2Yji/AxXz3rvvEqkrei/X7Sv57siFH/M2ibGlFozZ+isn80uWXwf6u X-Gm-Message-State: AOJu0YwoRJDUgVqiQN/g+mdU50tutKVBpPdP7ZdZBQLQmSosnbV47EF1 rzyUu+GrHYMzrWqEByq7WFmtTFDgeJobOzCfHHYNLAxX9Jv3c0oX0jn5kMYILLePen9VpkiSRjX /1XJnmA== X-Google-Smtp-Source: AGHT+IF6zvMB06yLz8Tj+H/LHwebL624uL/itQeCTCqVajsscQSfJaeyAhSYr2y99XQBzXfboR9IhA== X-Received: by 2002:a19:8c48:0:b0:513:ee1:2bd3 with SMTP id i8-20020a198c48000000b005130ee12bd3mr1637755lfj.37.1709308484212; Fri, 01 Mar 2024 07:54:44 -0800 (PST) Received: from Alexeys-MacBook-Pro.local ([176.62.124.84]) by smtp.googlemail.com with ESMTPSA id d13-20020a17090abf8d00b002960e397891sm3611470pjs.1.2024.03.01.07.54.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 01 Mar 2024 07:54:43 -0800 (PST) Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker To: Andrei Lepikhov , Tomas Vondra , pgsql-bugs@lists.postgresql.org References: <18349-83d33dd3d0c855c3@postgresql.org> <512ef568-336e-4087-ba23-f22b006d329d@postgrespro.ru> <7a1f5e5b-632f-4cc5-8078-b18a848e8924@postgrespro.ru> <2ff6260b-8722-b301-cf7e-4e66a159778c@dataegret.com> <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru> From: Alexey Ermakov Message-ID: Date: Fri, 1 Mar 2024 21:54:36 +0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.0; rv:68.0) Gecko/20100101 Thunderbird/68.12.1 MIME-Version: 1.0 In-Reply-To: <90092199-55cd-4fa3-a608-9a41d8e76c44@postgrespro.ru> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-03-01 18:48, Andrei Lepikhov wrote: > On 1/3/2024 16:50, Alexey Ermakov wrote: >> Hello! I reproduced generation of multiple temporary files and >> abnormal memory >> usage (in 'top' output both backend and parallel worker used around >> 3-4GB of >> RAM each, I often got OOM killer) but not memory allocation error so >> far. > Could you provide a backtrace at the moment of the error? It can show > us exact place of the error without guesses. > yes, will do it on next week (it could take some time to get approvals to install gdb/debug packages or set up another host). -- Alexey Ermakov