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 1sdc13-00H3E9-9Y for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Aug 2024 20:51:45 +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 1sdc10-0002gc-Ph for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Aug 2024 20:51:42 +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 1sdc10-0002gR-AY for pgsql-hackers@lists.postgresql.org; Mon, 12 Aug 2024 20:51:42 +0000 Received: from mail-qt1-x833.google.com ([2607:f8b0:4864:20::833]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sdc0w-004Pzm-Gq for pgsql-hackers@postgresql.org; Mon, 12 Aug 2024 20:51:40 +0000 Received: by mail-qt1-x833.google.com with SMTP id d75a77b69052e-44fe58fcf29so26060191cf.2 for ; Mon, 12 Aug 2024 13:51:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723495897; x=1724100697; darn=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=GwD4FBohTGHCkxXESbcHRGTRItA9tr/qT0Hjz62HO8A=; b=NNvKi0mDqcBXLBL9QQOhdTdsFMDxSODfiRZYznsMp++DhpGInHaO0EtvQ/wKRdQm46 V8INU+2M4n+8D6OJeo8WVFzYgQd0PhBWkyMoR0ST1FYkfHv3ohdw99LR9LCTrbotIUYz Mr5vqqbaXsCn9gCvI0KZi1YwTi9UDlEpkyJBDh8zG53SxR33C0KB04WxyeU/bvbqRisx ZIkxawMh4z29QA7cf8XQ1c9P21RkAaQuT/kPFoyfDWBfU7zqb0iOSu7Aj1Cij4DTSCUE nnu3xr7cTvtQ0mF3DAOvJ72KkcwonP3xDxVKAyWs26jvknSd5hSNbFZB0a4E+G1gx4p/ A/tg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723495897; x=1724100697; 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=GwD4FBohTGHCkxXESbcHRGTRItA9tr/qT0Hjz62HO8A=; b=EzCS4ybugJ818T5YhZ918KGjiTTdVXlC6X/FudTOm+Tbf60a+XUbyX5d/JbKdKznIB +xNbY6jtbArkT7NXFyjOur27hLdHKuv3tlDHFdM0SXg2DgzjgbNQumgT7JGcUq1JIn9v NHNKp0VO2HNlOfyaMKUAuG6PFKm1ul2yoMq7gVPDPZkdAan0FiCd3v0UN7OWJaSzACUM YYCDuF/dxieC8Z9fSSCUyCGFRsiqj/u4gMZqecomvv8JkRiWfW6ozXxebjJdy7XtmXrA uG3mIw02HuYjkn8PcycJclLJtPqShpatIafscTAZUxvCQEDPlZH6QRM57vUfl5zmh1T+ xM4A== X-Forwarded-Encrypted: i=1; AJvYcCVmhar0RDn9nIg6cw2My8ZK4Xors5bB2EHm33LKRDnOKfXbifbS6xmLE8G7A40Ux+JpuH/dZplh7TlQi6Z4J8FxIrIjeAfMWqrxj9RD X-Gm-Message-State: AOJu0YzhFoEYOeFy4qg3KRBSAZwCia9w9hca+pqWhy4ah0q2BFavV5Pf xMD4uTErsOK0oS1ptspVXTFP/vzUZxvOA0tGhYexmyuHGswK2rmW X-Google-Smtp-Source: AGHT+IEb2vq2u3K+pTCsXg15BFrZlwhupkG+tguhl1iAoXwnzVYrm11KFcvIhISMJ2ZSWbBpz/J9WQ== X-Received: by 2002:a05:622a:4892:b0:447:f43c:191a with SMTP id d75a77b69052e-453498ff139mr19663981cf.21.1723495897408; Mon, 12 Aug 2024 13:51:37 -0700 (PDT) Received: from [192.168.202.142] (72-21-198-66.amazon.com. [72.21.198.66]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-4531c1dc1bbsm26174591cf.46.2024.08.12.13.51.36 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 12 Aug 2024 13:51:36 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------S7leqT7biirxXmY20E6aogso" Message-ID: Date: Mon, 12 Aug 2024 15:51:35 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Restart pg_usleep when interrupted To: Nathan Bossart , Bertrand Drouvot Cc: Tom Lane , Robert Haas , "pgsql-hackers@postgresql.org" References: <9D64CD7C-CA24-4FF4-9421-3A1A63F87DAC@gmail.com> <526E6A51-FE30-47C4-85C8-F2D18877607F@gmail.com> Content-Language: en-US From: "Imseih (AWS), Sami" 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. --------------S7leqT7biirxXmY20E6aogso Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit > As cfbot points out [0], this is missing a Windows/frontend implementation. > > [0] https://cirrus-ci.com/task/6393555868975104 Looks like the pgsleep implementation is missing the #ifndef WIN32 I followed what is done in pg_usleep. v11 should now build on Windows, hopefully. Strangely, v10 build on a Windows machine I have locally. Regards, Sami --------------S7leqT7biirxXmY20E6aogso Content-Type: text/plain; charset=UTF-8; name="v11-0001-vaccum_delay-with-absolute-time-nanosleep.patch" Content-Disposition: attachment; filename="v11-0001-vaccum_delay-with-absolute-time-nanosleep.patch" Content-Transfer-Encoding: base64 RnJvbSA2MGE2MDU4YzE5NjAyNDZiOWZkNDMxMzk4YmQ2OGE3N2EwMjQ3YTlhIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBTYW1pIEltc2VpaCA8c2ltc2VpaEBhbWF6b24uY29t PgpEYXRlOiBNb24sIDEyIEF1ZyAyMDI0IDE1OjQ3OjU1IC0wNTAwClN1YmplY3Q6IFtQQVRD SCB2MTEgMS8xXSB2YWNjdW1fZGVsYXkgd2l0aCBhYnNvbHV0ZSB0aW1lIG5hbm9zbGVlcAoK LS0tCiBzcmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW0uYyAgICAgICAgfCAgMiArLQogc3Jj L2JhY2tlbmQvcG9ydC93aW4zMi9zaWduYWwuYyAgICAgIHwgMTAgKysrKysrCiBzcmMvaW5j bHVkZS9wb3J0LmggICAgICAgICAgICAgICAgICAgfCAgMSArCiBzcmMvaW5jbHVkZS9wb3J0 YWJpbGl0eS9pbnN0cl90aW1lLmggfCAxMCArKysrKysKIHNyYy9wb3J0L3Bnc2xlZXAuYyAg ICAgICAgICAgICAgICAgICB8IDQ5ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysKIDUg ZmlsZXMgY2hhbmdlZCwgNzEgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAt LWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3ZhY3V1bS5jIGIvc3JjL2JhY2tlbmQvY29t bWFuZHMvdmFjdXVtLmMKaW5kZXggNDhmOGVhYjIwMi4uNDMzMzNjNDY5OCAxMDA2NDQKLS0t IGEvc3JjL2JhY2tlbmQvY29tbWFuZHMvdmFjdXVtLmMKKysrIGIvc3JjL2JhY2tlbmQvY29t bWFuZHMvdmFjdXVtLmMKQEAgLTIzODQsNyArMjM4NCw3IEBAIHZhY3V1bV9kZWxheV9wb2lu dCh2b2lkKQogCQkJbXNlYyA9IHZhY3V1bV9jb3N0X2RlbGF5ICogNDsKIAogCQlwZ3N0YXRf cmVwb3J0X3dhaXRfc3RhcnQoV0FJVF9FVkVOVF9WQUNVVU1fREVMQVkpOwotCQlwZ191c2xl ZXAobXNlYyAqIDEwMDApOworCQlwZ191c2xlZXBfbm9uX2ludGVycnVwdGlibGUobXNlYyAq IDEwMDApOwogCQlwZ3N0YXRfcmVwb3J0X3dhaXRfZW5kKCk7CiAKIAkJLyoKZGlmZiAtLWdp dCBhL3NyYy9iYWNrZW5kL3BvcnQvd2luMzIvc2lnbmFsLmMgYi9zcmMvYmFja2VuZC9wb3J0 L3dpbjMyL3NpZ25hbC5jCmluZGV4IDI4NWNiNjExYjQuLmVkY2IxODEyMTUgMTAwNjQ0Ci0t LSBhL3NyYy9iYWNrZW5kL3BvcnQvd2luMzIvc2lnbmFsLmMKKysrIGIvc3JjL2JhY2tlbmQv cG9ydC93aW4zMi9zaWduYWwuYwpAQCAtNzMsNiArNzMsMTYgQEAgcGdfdXNsZWVwKGxvbmcg bWljcm9zZWMpCiAJfQogfQogCisvKgorICogcGdfdXNsZWVwX25vbl9pbnRlcnJ1cHRpYmxl IC0tLSBkZWxheSB0aGUgc3BlY2lmaWVkIG51bWJlciBvZiBtaWNyb3NlY29uZHMuCisgKgor ICogVW5saWtlIHBnX3VzbGVlcCwgdGhpcyByZWxpZXMgb24gYSBub24taW50ZXJydXB0aWJs ZSBzbGVlcC4KKyAqLwordm9pZAorcGdfdXNsZWVwX25vbl9pbnRlcnJ1cHRpYmxlKGxvbmcg bWljcm9zZWMpCit7CisJU2xlZXBFeCgobWljcm9zZWMgPCA1MDAgPyAxIDogKG1pY3Jvc2Vj ICsgNTAwKSAvIDEwMDApLCBGQUxTRSk7Cit9CiAKIC8qIEluaXRpYWxpemF0aW9uICovCiB2 b2lkCmRpZmYgLS1naXQgYS9zcmMvaW5jbHVkZS9wb3J0LmggYi9zcmMvaW5jbHVkZS9wb3J0 LmgKaW5kZXggYzc0MDAwNTI2Ny4uYzhmZjIzZTVlZSAxMDA2NDQKLS0tIGEvc3JjL2luY2x1 ZGUvcG9ydC5oCisrKyBiL3NyYy9pbmNsdWRlL3BvcnQuaApAQCAtMTYyLDYgKzE2Miw3IEBA IGV4dGVybiBpbnQJcGdfZGlzYWJsZV9hc2xyKHZvaWQpOwogCiAvKiBQb3J0YWJsZSBkZWxh eSBoYW5kbGluZyAqLwogZXh0ZXJuIHZvaWQgcGdfdXNsZWVwKGxvbmcgbWljcm9zZWMpOwor ZXh0ZXJuIHZvaWQgcGdfdXNsZWVwX25vbl9pbnRlcnJ1cHRpYmxlKGxvbmcgbWljcm9zZWMp OwogCiAvKiBQb3J0YWJsZSBTUUwtbGlrZSBjYXNlLWluZGVwZW5kZW50IGNvbXBhcmlzb25z IGFuZCBjb252ZXJzaW9ucyAqLwogZXh0ZXJuIGludAlwZ19zdHJjYXNlY21wKGNvbnN0IGNo YXIgKnMxLCBjb25zdCBjaGFyICpzMik7CmRpZmYgLS1naXQgYS9zcmMvaW5jbHVkZS9wb3J0 YWJpbGl0eS9pbnN0cl90aW1lLmggYi9zcmMvaW5jbHVkZS9wb3J0YWJpbGl0eS9pbnN0cl90 aW1lLmgKaW5kZXggZTY2ZWNmMzRjZC4uNmU0YjBmMWIxNyAxMDA2NDQKLS0tIGEvc3JjL2lu Y2x1ZGUvcG9ydGFiaWxpdHkvaW5zdHJfdGltZS5oCisrKyBiL3NyYy9pbmNsdWRlL3BvcnRh YmlsaXR5L2luc3RyX3RpbWUuaApAQCAtMzYsNiArMzYsMTAgQEAKICAqCiAgKiBJTlNUUl9U SU1FX0dFVF9OQU5PU0VDKHQpCQljb252ZXJ0IHQgdG8gaW50NjQgKGluIG5hbm9zZWNvbmRz KQogICoKKyAqIElOU1RSX1RJTUVfQUREX01JQ1JPU0VDKHgsdCkJCWFkZCB0IChpbiBtaWNy b3NlY29uZHMpIHRvIHgKKyAqCisgKiBJTlNUUl9USU1FX0lTX0dSRUFURVIoeCx5KQkJaXMg eCBncmVhdGVyIHRoYW4geT8KKyAqCiAgKiBOb3RlIHRoYXQgSU5TVFJfVElNRV9TVUJUUkFD VCBhbmQgSU5TVFJfVElNRV9BQ0NVTV9ESUZGIGNvbnZlcnQKICAqIGFic29sdXRlIHRpbWVz IHRvIGludGVydmFscy4gIFRoZSBJTlNUUl9USU1FX0dFVF94eHggb3BlcmF0aW9ucyBhcmUK ICAqIG9ubHkgdXNlZnVsIG9uIGludGVydmFscy4KQEAgLTE5NCw0ICsxOTgsMTAgQEAgR2V0 VGltZXJGcmVxdWVuY3kodm9pZCkKICNkZWZpbmUgSU5TVFJfVElNRV9HRVRfTUlDUk9TRUMo dCkgXAogCShJTlNUUl9USU1FX0dFVF9OQU5PU0VDKHQpIC8gTlNfUEVSX1VTKQogCisjZGVm aW5lIElOU1RSX1RJTUVfQUREX01JQ1JPU0VDKHgsdCkgXAorCSgoeCkudGlja3MgKz0gKHQp ICogTlNfUEVSX1VTKQorCisjZGVmaW5lIElOU1RSX1RJTUVfSVNfR1JFQVRFUih4LHkpIFwK KwkoKHgpLnRpY2tzID4gKHkpLnRpY2tzKQorCiAjZW5kaWYJCQkJCQkJLyogSU5TVFJfVElN RV9IICovCmRpZmYgLS1naXQgYS9zcmMvcG9ydC9wZ3NsZWVwLmMgYi9zcmMvcG9ydC9wZ3Ns ZWVwLmMKaW5kZXggMTI4NDQ1OGJmYy4uNjM1MjNhNmU0MSAxMDA2NDQKLS0tIGEvc3JjL3Bv cnQvcGdzbGVlcC5jCisrKyBiL3NyYy9wb3J0L3Bnc2xlZXAuYwpAQCAtMTQsNiArMTQsOCBA QAogCiAjaW5jbHVkZSA8dGltZS5oPgogCisjaW5jbHVkZSAicG9ydGFiaWxpdHkvaW5zdHJf dGltZS5oIgorCiAvKgogICogSW4gYSBXaW5kb3dzIGJhY2tlbmQsIHdlIGRvbid0IHVzZSB0 aGlzIGltcGxlbWVudGF0aW9uLCBidXQgcmF0aGVyCiAgKiB0aGUgc2lnbmFsLWF3YXJlIHZl cnNpb24gaW4gc3JjL2JhY2tlbmQvcG9ydC93aW4zMi9zaWduYWwuYy4KQEAgLTU0LDQgKzU2 LDUxIEBAIHBnX3VzbGVlcChsb25nIG1pY3Jvc2VjKQogCX0KIH0KIAorLyoKKyAqIHBnX3Vz bGVlcF9ub25faW50ZXJydXB0aWJsZSAtLS0gZGVsYXkgdGhlIHNwZWNpZmllZCBudW1iZXIg b2YgbWljcm9zZWNvbmRzLgorICoKKyAqIFVubGlrZSBwZ191c2xlZXAsIHRoaXMgZnVuY3Rp b24gY29udGludWVzIHRoZSBkZWxheSBpbiBjYXNlIG9mIGFuCisgKiBpbnRlcnJ1cHQuCisg Ki8KK3ZvaWQKK3BnX3VzbGVlcF9ub25faW50ZXJydXB0aWJsZShsb25nIG1pY3Jvc2VjKQor eworCS8qCisJICogV2UgYWxsb3cgbmFub3NsZWVwIHRvIGhhbmRsZSBpbnRlcnJ1cHRzIGFu ZCByZXRyeSB3aXRoIHRoZSByZW1haW5pbmcKKwkgKiB0aW1lLiBIb3dldmVyLCBmcmVxdWVu dCBpbnRlcnJ1cHRpb25zIGFuZCByZXN0YXJ0cyBvZiB0aGUgbmFub3NsZWVwCisJICogY2Fs bHMgY2FuIHN1YnN0YW50aWFsbHkgbGVhZCB0byBkcmlmdCBpbiB0aGUgdGltZSB3aGVuIHRo ZSBzbGVlcAorCSAqIGZpbmFsbHkgY29tcGxldGVzLiBUbyBkZWFsIHdpdGggdGhpcywgd2Ug YnJlYWsgb3V0IG9mIHRoZSBsb29wIHdoZW5ldmVyCisJICogdGhlIGN1cnJlbnQgdGltZSBp cyBwYXN0IHRoZSBleHBlY3RlZCBlbmQgdGltZSBvZiB0aGUgc2xlZXAuCisJICovCisJaWYg KG1pY3Jvc2VjID4gMCkKKwl7CisjaWZuZGVmIFdJTjMyCisJCXN0cnVjdCB0aW1lc3BlYyBk ZWxheTsKKwkJc3RydWN0IHRpbWVzcGVjIHJlbWFpbjsKKwkJaW5zdHJfdGltZQllbmRfdGlt ZTsKKworCQlJTlNUUl9USU1FX1NFVF9DVVJSRU5UKGVuZF90aW1lKTsKKwkJSU5TVFJfVElN RV9BRERfTUlDUk9TRUMoZW5kX3RpbWUsIG1pY3Jvc2VjKTsKKworCQlkZWxheS50dl9zZWMg PSBtaWNyb3NlYyAvIDEwMDAwMDBMOworCQlkZWxheS50dl9uc2VjID0gKG1pY3Jvc2VjICUg MTAwMDAwMEwpICogMTAwMDsKKworCQl3aGlsZSAobmFub3NsZWVwKCZkZWxheSwgJnJlbWFp bikgPT0gLTEgJiYgZXJybm8gPT0gRUlOVFIpCisJCXsKKwkJCWluc3RyX3RpbWUJY3VycmVu dF90aW1lOworCisJCQlJTlNUUl9USU1FX1NFVF9DVVJSRU5UKGN1cnJlbnRfdGltZSk7CisK KwkJCWlmIChJTlNUUl9USU1FX0lTX0dSRUFURVIoY3VycmVudF90aW1lLCBlbmRfdGltZSkp CisJCQkJYnJlYWs7CisKKwkJCWRlbGF5ID0gcmVtYWluOworCQl9CisjZWxzZQorCQlTbGVl cEV4KChtaWNyb3NlYyA8IDUwMCA/IDEgOiAobWljcm9zZWMgKyA1MDApIC8gMTAwMCksIEZB TFNFKTsKKyNlbmRpZgorCX0KK30KKworCiAjZW5kaWYJCQkJCQkJLyogZGVmaW5lZChGUk9O VEVORCkgfHwgIWRlZmluZWQoV0lOMzIpICovCi0tIAoyLjM5LjMgKEFwcGxlIEdpdC0xNDYp Cgo= --------------S7leqT7biirxXmY20E6aogso--