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 1v80Mb-00BFbw-4h for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Oct 2025 18:00:09 +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 1v80MY-0021G0-EH for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Oct 2025 18:00:07 +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 1v80MY-0021Fk-0d for pgsql-hackers@lists.postgresql.org; Sun, 12 Oct 2025 18:00:06 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v80MW-001NuQ-1c for pgsql-hackers@lists.postgresql.org; Sun, 12 Oct 2025 18:00:05 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-46e6c8bc46eso21364935e9.3 for ; Sun, 12 Oct 2025 11:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760292003; x=1760896803; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=6yr6fYjvxEQb6BrnZ8U5KwVc2eKKmyQCbKxQuqAGvLA=; b=RakURfYEzQx3aZwlWGYOg2PYcgLKTrcBRB35VQWbm898mfnbh+IaKbNqRiv78JsHLh vnBU7wrGwFT+YmEl9IZOyCco4YkZvqAWyAbCWwSWa5QueJbPO3N6oSnsrQDKl3XtWeZf 1C5yZewSXTKli7lZOeGyivabhFsCKWpjziHFvoAOxG0hjZNqhmEZqMak4m3syJQBSzH4 wnOD5ntEJp2e2cWRJbL7Yu4Oe7IL0Wujiq1YFdgWFG2NToK2ooFRc6H+kEvXniSJa5Xo q5fXPqNTfrtoyPJt4Un2jYa9nP2iFSlVmTagC8FZEZjDlWznzVmCtJ8FFW+ttoLf1CRV KSdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760292003; x=1760896803; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=6yr6fYjvxEQb6BrnZ8U5KwVc2eKKmyQCbKxQuqAGvLA=; b=IZtMZeuEi/M60TX9He89i8JrXT+fJ46VxenpTPicBaoSFTzOlZLQr+PIOYnrdWkZxJ UEYaR9xDXyi6n4yk3XD9FzRsPFRW5HH5rHeyYt41SO8Uyt+5ZciC34kIPFN8IyMNSuVT CuzRDpZYth4/ggGrcail8aFed+F1F515Gsw0F1qUS6HFA1q5RepcydfO8/bGQeawdERO 4AB5ICPLZOVGEwnTcoNPZTSWj4RWr5QAJCRM/wa+DooV1RqfAkeqOcCOYvzcqkrnnuCX H2E2VsIeXlqUsfNJx5cNCcmT2vL+vUYj4HVtKrS0aGS7P2/UOCN5L+05LF2Jb38UfQ9w w27A== X-Forwarded-Encrypted: i=1; AJvYcCXax/A/hdO0vSExeiHXduK3puL/QDisXGthfTAoDowpF2aKBFeD16MCqvMEG5CVvY3/TrGdNYoS9PAOqSrS@lists.postgresql.org X-Gm-Message-State: AOJu0YyZ87vTT2vZWIkczCV24VGX8zzsDF2IkPdlNZvlGIC45GBMl5Ll D130ec7DNliiqSK2ZHX9iVqcG5MVdPhCPe3FwAeD69w3UKXBGtTOjrsh X-Gm-Gg: ASbGncuvhyvymt4lA33+G9h6GAsGqiv0+aZz6SrO3PkmSL8rL8ltyz2PqkoHfSbjfaa U+a63X4shy4t1Rn4kXOKpT/gzOKH45is/aJ0erb281HvXQfSP0dNKlkbx5hSa6siIWFkr8OZGjy NYBqvU7hhRPV0VfLg5FVbjBnAu1nfPJiKJweocf0qTaCgib8a0bG2aCHuwbPYSb6gnD2f1zhIoX HOktiIchzrlpOgEAM9wndYdqvn8Xn7bR7LNQ8RAA/xBjotOG5G2MlzHMWCnOssYDGBLwc5jyqJs JLX8MaMdXGGEBOScue57QbW+m9Pr3InxdK4kBhN7uSOctty0lex7Mr8TUujvsXSvQTMucr4peny kRMhOJLvgi8mcn6Vkd3gUhfErf68LrTKNNVh7QG/UZ6G0 X-Google-Smtp-Source: AGHT+IH1c+eiRm0fhdAqSsgyA0eQZYPtox76B9KmI0cSHQZvrmALWBUl/q53+npNkMg6EmI0a5z3FA== X-Received: by 2002:a05:600c:154a:b0:46f:b327:f20d with SMTP id 5b1f17b1804b1-46fb327f2aamr76579475e9.26.1760292002572; Sun, 12 Oct 2025 11:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.120.198]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-46fab4f3b07sm110542985e9.2.2025.10.12.11.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 12 Oct 2025 11:00:01 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------mKXxQ1nKxNAKFFfKTTBp2Naf" Message-ID: <970b24e8-967e-4012-ad6a-ff7605ebeadd@gmail.com> Date: Sun, 12 Oct 2025 21:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Potential deadlock in pgaio_io_wait() To: Thomas Munro Cc: Andres Freund , PostgreSQL Hackers , Heikki Linnakangas References: Content-Language: en-US From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------mKXxQ1nKxNAKFFfKTTBp2Naf Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello Thomas, 10.10.2025 04:44, Thomas Munro wrote: > I like the second one slightly more, but I'm also happy to be > outvoted. I'm working on committing the first one, but I ran into a > couple of CI failures[1] that I haven't understood yet. It could be > my patch's fault or turn out to be something already in the tree... > looking into that... > > [1]https://cirrus-ci.com/task/4737677834059776 I wonder whether it may be related to the issue we encountered with OpenBSD?: https://www.postgresql.org/message-id/flat/db2773a2-aca0-43d0-99c1-060efcd9954e%40gmail.com (I've found the same hanging "SELECT * FROM writetest;" in my notes from 2024-12...) Best regards, Alexander --------------mKXxQ1nKxNAKFFfKTTBp2Naf Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hello Thomas,

10.10.2025 04:44, Thomas Munro wrote:
I like the second one slightly more, but I'm also happy to be
outvoted.  I'm working on committing the first one, but I ran into a
couple of CI failures[1] that I haven't understood yet.  It could be
my patch's fault or turn out to be something already in the tree...
looking into that...

[1] https://cirrus-ci.com/task/4737677834059776

I wonder whether it may be related to the issue we encountered with
OpenBSD?:
https://www.postgresql.org/message-id/flat/db2773a2-aca0-43d0-99c1-060efcd9954e%40gmail.com

(I've found the same hanging "SELECT * FROM writetest;" in my notes from
2024-12...)

Best regards,
Alexander
 --------------mKXxQ1nKxNAKFFfKTTBp2Naf--