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 1s7O2X-005QDI-MY for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 23:28:07 +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 1s7O2W-00ACoP-T7 for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 23:28:04 +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 1s7O2W-00ACoD-4i for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 23:28:04 +0000 Received: from mail-westusazon11012008.outbound.protection.outlook.com ([52.101.85.8] helo=BY5PR09CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7O2O-000PJw-HS for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 23:28:02 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=H/zkcV/ibK5/ekUpdd2aCkZT1QwbQeiF3ewPAT6a8KaFWBiY8rj74iXeKdo6RSGSMnbTQm24iUAWCoRjSGC9yi89nU9UaGdbQxqlLmc3LJI199oUVtxJqg4IK9njgO6tR7mUULgqxvq/m1G8gy+IctjtWQ4DcDsztaWXLAl9/W3y3bvTijwtYcDsygmGdUJHwlH88H4zH/VE3rSRnxkfzoyxNKjD9d7loz78L5VgwIyULhzRdal6Bx7OKCU1zegxYcpGennGALka5XsfezEGFYIWZ5evwHlc0InwlQeBGb3hDBrPyArW0Ha5t/prd6oUkkuPn+hr7V8HbOMplDONPw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=H81L8EP1tpngrBaUW+8SViqKM4nBuiETqZj3vkjkUow=; b=OeMHJnGg8270vZmgg6FkA8wsLCEEB0DmWAfp68HWqxGcvWwa1DSnsygzWtZDQn8lSv+X0fNot03vjSTvw+H6ZwsuHxTalnEfHWiB3C09FbbHbwGJAm6JWmC9s8TEgUaoHSgFDaxcXJTNJKLJGVMSsJmgXpNuIzUQEtR3Asm3U3+Z72AFmrgVS8NG9ArK1UjtL6oieuhqJqol6m3htxPA+u1ON/jZ0SzM0jdNuOZcRsS2y1P4cFAukzPv3ncWGQPKDDv0LlsptePgnGAuBeLrNH9URkThyrKbaLl5ltY5+6ZHrrhCzndjJ57UAHTzWrKDr7w+08KdPhfrg9XcI/KWzw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fnal.gov; dmarc=pass action=none header.from=fnal.gov; dkim=pass header.d=fnal.gov; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fnal.gov; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=H81L8EP1tpngrBaUW+8SViqKM4nBuiETqZj3vkjkUow=; b=kPtqTYbHU6TjoMOhPkuDXm0JL2P8RYkIA7+ZVqU/Yg6VZutPg7R7yZlSkyKFrPi0gXUaSncnxOEnKZw3CwHl5wjJVCpuFqcFhgy68/E8d2HntUDoqkgddaBcl0csXKkwfh5OI05wyjXTwh0MzAInBgUjAPpB8LekbdiGJafhH9K5sFVTLqcRs9DUM2c1BiecJC15DIPZ9C6QD6vcTNvX0UmSEIMFqciwAX6Kfhr4H9N5Yi79AsMFpRYD3QXZ1kPJicLx64wsXCc18IQLPsYFgfXnsxZogEZsKopqtTqButU5jX41r30HgiHMOrF0siu+LOU+Kdv3nWvZG8qHhl27Eg== Received: from PH0PR09MB7308.namprd09.prod.outlook.com (2603:10b6:510:65::12) by SJ0PR09MB6351.namprd09.prod.outlook.com (2603:10b6:a03:264::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7544.55; Wed, 15 May 2024 23:27:53 +0000 Received: from PH0PR09MB7308.namprd09.prod.outlook.com ([fe80::8792:b770:76bc:6673]) by PH0PR09MB7308.namprd09.prod.outlook.com ([fe80::8792:b770:76bc:6673%5]) with mapi id 15.20.7587.028; Wed, 15 May 2024 23:27:53 +0000 From: Dmitry O Litvintsev To: "pgsql-general@lists.postgresql.org" Subject: Seeing new stuff in log after upgrading from 11 to 15 Thread-Topic: Seeing new stuff in log after upgrading from 11 to 15 Thread-Index: AQHapx4yTBk/dPtCZUK+q2HV1X+7lA== Date: Wed, 15 May 2024 23:27:52 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fnal.gov; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PH0PR09MB7308:EE_|SJ0PR09MB6351:EE_ x-ms-office365-filtering-correlation-id: 82a5470b-f01d-40ae-85d6-08dc7536a48b x-fermilab-ob: 1 x-fermilab-sender-location: inside x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|366007|1800799015|38070700009; x-microsoft-antispam-message-info: =?iso-8859-1?Q?MC756mdgRfeQSltMUviHQEHKjwsC4JNcMYEn3w5d5pmreBZ/dBIamLO8NN?= =?iso-8859-1?Q?KFIUBCGOX/QMKG3CUXk5HkApm1Tbg3FU83bOzdb4BXyf+RmrGTsBzO9dU/?= =?iso-8859-1?Q?AClnbH4ntJYzXFhwWscTzH8Fdztt2H/TCQv0rKWHuw8w3OWpQ0ePTN/AVY?= =?iso-8859-1?Q?rm4UfSIEkamJYZrYt1WlK+tuLfnEGL2CJI2GR1R6U+FMnaB4VjKfEWxJDM?= =?iso-8859-1?Q?fFvUtg8ub1kIVDYCoSV6JcQEYBHNYccgqBHS494rqrJNP1MNXtl6w/FzQX?= =?iso-8859-1?Q?LJHSg9sFw9ZZzyGuxSu8f5n88PO4U70D9vUzrNi4FByp4SGZzEu4pNtbci?= =?iso-8859-1?Q?zMIpAnxIKj2quIt2pkfMI06nxhyZ20vYPXMS9qCyOdTAZ2KpcgXOqH/xRM?= =?iso-8859-1?Q?xrA3Qm6I5FHCDC15Exjv4GQFRnrjqAAJHlHu+VnpSYydD0qf3bqL8zr5ft?= =?iso-8859-1?Q?y72i+Vl4b0WVDIwi8xWksAVETLv/uSANACibzSZS5pogreqTrggFvHBzKY?= =?iso-8859-1?Q?+Dx+vwSUhZYy1m3GaLzy83sfsbAFNeaJ4KfeShSucd+q9ON3OpIc9kWsX3?= =?iso-8859-1?Q?8rDh55VaHKUMqDsPve2X5qMeov+s/lsnrIfNIPISGnc4OIhVmr7nqv8Vpq?= =?iso-8859-1?Q?2Oyt9vl456GgSLGvWFtL3Gmyda2glfzyKDrgopKe1rJKCXm16RL89d2PPX?= =?iso-8859-1?Q?TWGhdOkV7hiO63ZT6YD6M+PgUf4xYRzjXi1aU4G17KO/8EcH2NTCB1VdWn?= =?iso-8859-1?Q?13Z3KuhmPnWYg3XHJDE67aFuCVKMALf6KgUrgv2PyLZjeJls8ivWnyo6Ev?= =?iso-8859-1?Q?EsD5VkVXgB/hZSJF5f8RFxD1TYvuy4cnFKkNTnKwXPKGWKbtROr3DRenHG?= =?iso-8859-1?Q?CnHUZPNo9jyczHIpL8jkS5vr2OepQGcZ0q62F8IyRL4GN1O9Xw23sVuDS3?= =?iso-8859-1?Q?utD0q+Z8gPfo5MFse+4uFTy2whgmtRaKLE+ra0bfyVWhZdGvvasyYmGora?= =?iso-8859-1?Q?kXNwlyodc+suRxR34+9pBcTpcK9CjVs7UbLeXx2s7IvJt7DaE0jKKxo0eA?= =?iso-8859-1?Q?06i6MaDjFTmvfDrWOX+CDKp01aEA6IlNM+azWInEpYjID2h0YhsSbTxVDN?= =?iso-8859-1?Q?n4Vnuae7po393kjxtcUsnRwLLOxWQel4RSIyAClhEl6qLDDgmIrEfJ0gPU?= =?iso-8859-1?Q?QiIeemuHB6+dH5Wdljg8iCmkE3zO8FcPeZ1WZmqKXWCOxZuRi4uhcuCuBP?= =?iso-8859-1?Q?TVmanozbHwybUVoLanU+hEIxmG2DhOVtk98ukJcUYjohT/nIM/F8nLDtZF?= =?iso-8859-1?Q?Wxi/qk2jwStdxJRcchTz9BN5pH5/Z3U6nv44Lq7Y3tRi5UEjeYjJtICMfC?= =?iso-8859-1?Q?X3eet4usAMAwsZ7qyzKufdc2LbJX84bg=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH0PR09MB7308.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366007)(1800799015)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?VpDeFwiNajfJED4eceDdZhLuqOgs+8jbT8FvRFO4Nfaoqas5v8rYDjYNhC?= =?iso-8859-1?Q?YqPIMiUm1Bu7ezDKbJ1zt5CNwygrtzhvvCARzSmlbvBVMMPgWWtRDVNhAa?= =?iso-8859-1?Q?2eYZWuMk/ePI2vukvk5/RrDhgG5qU17bobjpuy1WH4bNXJ+eM4X2RiJweW?= =?iso-8859-1?Q?4hOFJwZ+DMNsEjm6Xy8cadFccQmo3ZTslwCH2G1IbzVAgQyKik6Pq2GvTM?= =?iso-8859-1?Q?1bH7b8RnnlCr4fXSy0Xv7AxveCJjDKOsBOd9+1LlkaO6CV8v7lDVUk0rOx?= =?iso-8859-1?Q?x5E2Bwk6fht+jUPczeEyYru2u3uUS/964UGc9OV5lz5kOPbzLP/F/it0Jd?= =?iso-8859-1?Q?blSGI0orqhsoiluM93aicrQbzAO2qaAmxP81mbC+VFSzP80biSvvV/yQxL?= =?iso-8859-1?Q?3iI4gzJou056+wv1XFIt8TDjttMN2XB0PiaFNT7bPDqnFvOOZWel7/QYh6?= =?iso-8859-1?Q?axZaonJgDTeqWe0/kerWqLEC38BkwkwooDVJKAtB//qrur507QkQDNtZWJ?= =?iso-8859-1?Q?HaiSRfglDmn+3XU0cG5OCWPiio8g2mZVVWnu3OBA876I+3+AxaxQOQp1uA?= =?iso-8859-1?Q?zV2QvUOPGL7Sa3saBB+INCh8P8GmSJdxhah3ra63uvVamG1so7Ot3JG4c8?= =?iso-8859-1?Q?Ptuqjk1BEXnu0dCQbeRloY/UBojv2wAy3VH6AcYpH5bZySsfGJdh/GV6IL?= =?iso-8859-1?Q?lcp2255wyrNIhMDeHk625p7dbyUpR579oItimmHfxJ4y1rccbHgCqLHgQH?= =?iso-8859-1?Q?tEhtI0jsYAx6GUf890gtaFD9ZLa7yJ0M3Lho9d3EkJdjwxkl+jHOb2UhKD?= =?iso-8859-1?Q?ajOcjygyjqvdtmusEiJ1bRXP3rQPLBSfk+KFvwyUVURmzP/ivXjs8c0/VU?= =?iso-8859-1?Q?t/kOdZs2+liIPnYrsMcHLVI/kLNLPIBhpXS0p0BNdPo4WhoNdSqdRdgSHG?= =?iso-8859-1?Q?+p7QPLhg4BHoiI+v0lPSSHIHeDH8BlG1ICyUFrq25Xfi+5n7wdc7G0CUc1?= =?iso-8859-1?Q?vZ826+ptyvDU2Dsei4sUf7ICpjLrJi/mR+WY3RfAzqcdYWlpULQwdjaixF?= =?iso-8859-1?Q?itesM/qN0CmmVHEjvDBpn6OHlaaQEMT9c670zY4EO6uqNz14Dl41N6ybQn?= =?iso-8859-1?Q?m4mQ3zrd8uHrQx8T7sQ/N+AUjmEHEkwsvba5ZDAAgd+y6QGODe0lzXvsSi?= =?iso-8859-1?Q?BLPggdkr+h80Lu0wTEn9uCNnaBIMqWkLhDz1zO/r8lmjnEe9cqJdbZDxEt?= =?iso-8859-1?Q?TDSL8NLS2qRenviEcmoNd1cCwcTn4URMjlrVaMN0KVoXFyMZLI0easDdX0?= =?iso-8859-1?Q?PVQRd26ccgIObixBYq9XVK8AVhQgWManvH+rGDx1wPcmHzfUPd0UuB7bBR?= =?iso-8859-1?Q?eNwqAoi3btQcrMKH5fyUx68g0WhGHnS+emNQPodoF8kochH7AA3s+thO5P?= =?iso-8859-1?Q?DdJY0uXO5tXIXjyq+gVtECPZ6Wj5AugY/LyROfTMN1J8CJcO1ijnZLlcoN?= =?iso-8859-1?Q?xdX6UOcbyuv4tZ14zImjMUdIxm+klOg2aDNO+g19qYl0lx6GeVcJz+tYkO?= =?iso-8859-1?Q?TWMHke7VEuklspRDfUKF3z3d7xqg7JRtAaRX97OJUO9hvgzJIMmcJA9r2I?= =?iso-8859-1?Q?GLjpPSDKlMvfh7NOZ2qmHySnegWrHh8LtB?= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: fnal.gov X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PH0PR09MB7308.namprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 82a5470b-f01d-40ae-85d6-08dc7536a48b X-MS-Exchange-CrossTenant-originalarrivaltime: 15 May 2024 23:27:52.8581 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR09MB6351 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, =0A= =0A= After upgrade 11 -> 15 started to see these messages in hot standby log:=0A= =0A= < 2024-05-15 17:20:24.164 CDT 151879 > LOG: restartpoint complete: wrote = 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; write= =3D1619.469 s, sync=3D0.022 s, total=3D1619.539 s; sync files=3D1492, longe= st=3D0.002 s, average=3D0.001 s; distance=3D2195446 kB, estimate=3D4171347 = kB=0A= < 2024-05-15 17:20:24.164 CDT 151879 > LOG: recovery restart point at 17A= B8/47000140=0A= < 2024-05-15 17:20:24.164 CDT 151879 > DETAIL: Last completed transaction= was at log time 2024-05-15 17:20:24.138362-05.=0A= < 2024-05-15 17:20:24.167 CDT 151879 > LOG: restartpoint starting: wal=0A= =0A= while running 11 the log was almost empty, and I did not modify verbosity s= ettings... =0A= Queston : are above harmless and just informational?=0A= I checked the data and the data is definitely being replicated.=0A= =0A= Thank you, =0A= Dmitry=