Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk0NF-0004vV-Or for pgsql-admin@arkaria.postgresql.org; Thu, 28 Apr 2022 09:23:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nk0MG-0005e3-6W for pgsql-admin@arkaria.postgresql.org; Thu, 28 Apr 2022 09:22:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk0MF-0005du-9l for pgsql-admin@lists.postgresql.org; Thu, 28 Apr 2022 09:22:43 +0000 Received: from mx0b-001b2d01.pphosted.com ([148.163.158.5] helo=mx0a-001b2d01.pphosted.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk0MB-0003qz-LW for pgsql-admin@lists.postgresql.org; Thu, 28 Apr 2022 09:22:42 +0000 Received: from pps.filterd (m0098420.ppops.net [127.0.0.1]) by mx0b-001b2d01.pphosted.com (8.17.1.5/8.17.1.5) with ESMTP id 23S8rjn0025289 for ; Thu, 28 Apr 2022 09:22:38 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ibm.com; h=from : to : cc : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pp1; bh=jk+/7s9HOTvdPOLFWz28UWi0GsO0oQ23YHFVEadmnXw=; b=cRKOzRwDTrVlGOhnL47iq2vTKDWmMeafyopYhU9UjfvTqXJDBGbYBXZMt+cPsxWsQooT 4bfvUVRdmFJ/J11/7OgXgrpqA8lspkeB30QIWlQ75tgzQgsNdG519mSfagu9B/jtj5Hn yznyvXKLlB3L7DBM4k22DaTz9LZdvBRgF6yFmB7hRhekUzMU06ufdrTdEIwx31Q5JYaV sikw7LMcBTw2XsL3psrXhJNFfAw+tWg3QexvIQov7NOi7w6O6ubyVjMBNyTTevZXi7Gp FC/u9xz1F89te6cvmoTZohqbn5olG/bClzlc5g+7MGmHpeItxfl1+ABeYoNw+ZFJfYSN vA== Received: from pps.reinject (localhost [127.0.0.1]) by mx0b-001b2d01.pphosted.com (PPS) with ESMTPS id 3fqqtmrhh3-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Thu, 28 Apr 2022 09:22:38 +0000 Received: from m0098420.ppops.net (m0098420.ppops.net [127.0.0.1]) by pps.reinject (8.17.1.5/8.17.1.5) with ESMTP id 23S9KL35007580 for ; Thu, 28 Apr 2022 09:22:37 GMT Received: from nam10-dm6-obe.outbound.protection.outlook.com (mail-dm6nam10lp2101.outbound.protection.outlook.com [104.47.58.101]) by mx0b-001b2d01.pphosted.com (PPS) with ESMTPS id 3fqqtmrhgs-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 28 Apr 2022 09:22:37 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Wrip81XCvh9gh7O+6Dg4lXuHSPGgVVtjoAe0VnB9ZrGNlBzuiqVs+auOHdbcEi9ogRzgTq96wsQH4am+fShJFwCY9m9RM6vofPXshzfczt3Nn9aulIdPjPc0fTO+rrI21AJ7XfxF8E5OCvlwiBRY5UhfYkRpr/zCgsBGPTBDuFqHJJ8xlApZCiNZh/AdF7javgmvnYhswDBNvFnSnaypJUjKdFJPBT+vs1ktJ1r+cFTiDRzH7e1TzUq2BZi9wHCDy9+ziFtrOAqrIcuY5Mh98eq6+5KOT+owGc4/FFVfa1mZcEVGTSsop8M58zGWdaVY5mHwRDF2mDG4RtASeqoeXw== 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=b4lMhAxq9Na0+OlDbRAQSPAOQFBv0i7IFt9HYVcOBd8=; b=aoFHPjaj4yswUn6LyWD/vFp2JknqHeCyxn94iaP6aZmal0TFWsjs5WNX/GfpbboCVymgMJ/LGMVOOyQ9KIxW18cuOsiShHftGuHAl6V6qh3BwOTEzLOH2rYWDhU4W/xvBXQhiQaK+CrFKUDf/GTtXuClglmEZkBatBDUGMwqji6iEQCH0Nb2kHIw3bMt/BE0AB5JxwvAguaakzR0CMzkUcmxmFZNU3m1JCcUEVtjrrXFHv7km5WHpqkarR2yCMvhAsZ3uViGEM7Jn2LvQijMKeDfGmrqQ4E9l3Bzja8PYNrOs8xQTbXAEFQJ5hpXeP5qGZie9iuKLOYgTc0cBEPPqw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=pt.ibm.com; dmarc=pass action=none header.from=pt.ibm.com; dkim=pass header.d=pt.ibm.com; arc=none Received: from SA0PR15MB3856.namprd15.prod.outlook.com (2603:10b6:806:86::7) by MN2PR15MB3423.namprd15.prod.outlook.com (2603:10b6:208:fd::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5206.13; Thu, 28 Apr 2022 09:22:35 +0000 Received: from SA0PR15MB3856.namprd15.prod.outlook.com ([fe80::1008:6e19:2ccc:82c4]) by SA0PR15MB3856.namprd15.prod.outlook.com ([fe80::1008:6e19:2ccc:82c4%6]) with mapi id 15.20.5206.013; Thu, 28 Apr 2022 09:22:35 +0000 From: Adelino Silva To: Nikhil Shetty CC: Pgsql-admin Thread-Topic: [EXTERNAL] Re: Postgres Stale Statistics Thread-Index: AQHYWj20dBukMgKxPEugQ60f7bQGIK0D2DEOgAAMhQCAAShcFw== Date: Thu, 28 Apr 2022 09:22:35 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 32faae4e-3083-4171-61af-08da28f8a1bb x-ms-traffictypediagnostic: MN2PR15MB3423:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: jMhhbEiyoET1oo3ZbsI+N5K7tr8nM3VhS/N0b7pdbKkLQ4l5E680ASaSihkYPD/yVCsmApXm1NfQVrxrASVQiQP5hu5I2LFBWExc30FPYxmS5ewSC1kbaYwG2UyaJXNo00c53FhHllYSzb+AQflphI8Vz0264910nvDGu6d1uCVK9AWK9H8g3oebq9t/30+lXzDFA1KP3B5eDLHz2eQGrAxvp2mYsSyb3ZznLutEb05JKikK9pfZpNuMJBL3UTxj+mdDdei0/0Dh72l16x/abT+znr+Ar1WfRFYnOwshtDTIrXqgzg0H+WuyIMhL5ig7T0kMMShRBDQQiC4XOFSt9dKDn2BIdFtsZvpxpZsi5yzLbQmKeiTvNKpMrjHg+KhJ3KClFDLBiY/S2Pq71kNBsmbz9I9zo+00zMt4vg69rsZUDqVR1JLujDg/1kT5Xr1Ggcw5aXc6DrfT/P0PwcroQh1g6uWh/On04nrbuFcqKXTZEpiuX58GOF5XOWT7tUpC+IczYSwo2RalTSId3WL4CnQBMDjC9w8bzbu3Sqqrv9iuNEaQ5GaJwQgZnynp38o6HsLX5/SKBOfM1Zz4RjGqaH0eli4EOMpQ0otXuYq4+58I3AGFrvUTB4GeXXy5UFgEba8QE9VCgPE444Q/1pBBypBDKM9+2STdGOHGiwZ9vk/KLIjbOhmyWpdZM0BPjS8APvro1zW7e5h8jZhy+nNo3jV6eB6yFqArgqNE8WsM391XvS7cPuh4FnVS5f9SMuWtvsXNlXG4PDCiob+yUCT2gnbVI785+BTBm4yQV8ytFBs= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA0PR15MB3856.namprd15.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(366004)(66556008)(19627405001)(9686003)(4326008)(186003)(2906002)(66476007)(66446008)(64756008)(7696005)(86362001)(53546011)(66946007)(76116006)(316002)(38100700002)(91956017)(38070700005)(6506007)(8676002)(83380400001)(55016003)(6916009)(16350225007)(33656002)(122000001)(508600001)(8936002)(966005)(166002)(5660300002)(44832011)(52536014)(71200400001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 2 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?S7J64GOMWuDYB3U19ODCwxQuE8A6T6YL6b3x08dBNxTTCZxQJjxObeAj?= =?Windows-1252?Q?Z5DTJ3hZivDOU9FGDCR/wZABhEPA1OMbV3Ein9Mev7EA2Gl5KI80Owbs?= =?Windows-1252?Q?fa7FrwRgkVS8HSKr8XmAmu2Ew8b+DB7UkcoDkwY9t1iKolzUddMzMcvD?= =?Windows-1252?Q?9LWwEcQCp50Oh3zh2S3A1NV/8XYYZUIaM6Y63OPebdMVH/q72bBp4wE8?= =?Windows-1252?Q?c3A1CNo8/Km0K61y3bnlb0z9ntmqksblJblKO4A3dhcb7LUzGLiyctXD?= =?Windows-1252?Q?UEsrmh3Xb/JutmUZMADZKwy+7ULDSsypZj+O9nrnaL/CGq5ME2VT9F10?= =?Windows-1252?Q?fvqm3H/5/18r8jnekPYjmboSyhTzp9vPkvM0CecnDJ4dVeVszcfHjVzD?= =?Windows-1252?Q?qgX0puX0hOBSBTy/iezFjJtwAL45Ly0ohSMYm7SeFGFIKuI7uPIwrsZM?= =?Windows-1252?Q?dKyqq0ShWe4SSq9JOda0wO3qgUmqMOoyrqTlZl1JHuKhAyfwdiU3ma7I?= =?Windows-1252?Q?YHynWqypvR4lYnnunGi/hWmiFLyUSEQMECKXdgeg39PjmuN4Gw4DthN3?= =?Windows-1252?Q?H8O5m3BUU9MOsptQ7P7ARe8FzU+R95T9FLi+QBhM326iIPhGqpjEXZZA?= =?Windows-1252?Q?1khCeTHZ/sly4cUgmVVsu9pMvx8GUe1s+cbOTBXtcOoWEGXeaiWJPtaI?= =?Windows-1252?Q?miZNZx+tnoV3kfxr6K+GIqDN/uuhao5uP64aByScKg1Vo3rOaUb+zMda?= =?Windows-1252?Q?mrc0No5F5aGzMFgkJeVjOLjnUnB4oOQNxu0xoRQc2ygf+tlT/GWJe4gH?= =?Windows-1252?Q?Q3X977GR5EXVt0G51KhSxBM7RZpBxK8xeLXpmBQioTTDbPfktpVqf2Mv?= =?Windows-1252?Q?n6yhHumZ5k181r8KF1JmEX84fDgLvLaE9IFfGlxV7/F74Ppo5fYxiJkL?= =?Windows-1252?Q?TKBZvgbd2DyRtlGs3RZySgZ7K9pBhnDg+fHtmvtRhEs1P3QR3KOTUNUO?= =?Windows-1252?Q?+IoX3tTwXcFS08xfGpFtzXfh/3ZZ8lh9dtYXEUk1YIhnLbdeUZwxOOEh?= =?Windows-1252?Q?YdfHGMGVrsgUelZk+bfFiEKbbSufzeLA2gkhL4Xq+39XvHgqTH3DYUDD?= =?Windows-1252?Q?GIyelfxt+1gc2KIEwv/OnpB0H0dKD2dbbnBUyjqqDMQm9LDiTg7M03JH?= =?Windows-1252?Q?S7fwpRo3O6jxNgnZeHfUNgXLMcdeffBSbjZhuEsl7gSAwW2b30EvbtX7?= =?Windows-1252?Q?mL98uwClHZc4aYuwbEMoHa8C3DQPgnzAPQLI2qIExWWK+0aAjQQU8JQJ?= =?Windows-1252?Q?59LdV1To3O8w9ng6tCpYmhBk2oe3qTJWNXGx1DgN4nhNGpHDr0r6/6jw?= =?Windows-1252?Q?M5nGBf0wgN0A+5/6RlGQasBmyjTH87iEhWCP8oq8eHQj6ASFD8StptJT?= =?Windows-1252?Q?l7wPPZOmE0hA2GQEkGttIBH1fcF3z9xFgiUHWTQay4swtoBtQM+6ffYt?= =?Windows-1252?Q?e/glu1/IebcJ6l7BY193eL3ZGptpIaeSE+AVVFD/62LXRWwF/w9k/IUT?= =?Windows-1252?Q?5Uf/BKcDClsOHwgwfIRFQcJSvJBBFcWGk+W/6GNmBzAucy/osBqOSXAi?= =?Windows-1252?Q?WnAuOn21ehbCuu6jJVach0Lt8SZQTvei1oStp4O0vlmOM5AmkSJaxN38?= =?Windows-1252?Q?fyZzBP7TiU0tva0KIo4tc63j1DPXlHFl0sJ0rBl0bVQLNOcKc2hJlqxX?= =?Windows-1252?Q?9+RSq+gpEmyBZGWjwNvxgsfaqg60iP/Qe0tuxOtn2ijUubY5UmAsZvNm?= =?Windows-1252?Q?s5jaBT+V+ctfDEBevY+E4sCPnYRpSl/xt7TYBlRgLKSpALoiMLGoagHN?= =?Windows-1252?Q?1AuhR2mlrkFOJAAheeHXVqgHndrwUcEA4r1lIV/zKYG3wFvAqL37ucUB?= =?Windows-1252?Q?aZVnlOoX?= x-ms-exchange-antispam-messagedata-1: TLvSfHL2eTxBTw== Content-Type: multipart/alternative; boundary="_000_SA0PR15MB38568AF0F1533CF282F36F8BD2FD9SA0PR15MB3856namp_" X-OriginatorOrg: PT.ibm.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SA0PR15MB3856.namprd15.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 32faae4e-3083-4171-61af-08da28f8a1bb X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Apr 2022 09:22:35.6134 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: fcf67057-50c9-4ad4-98f3-ffca64add9e9 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: cC8+sAkgH8GEzS6lsEYKbnNrmvqBcYFiTvIFtXGy5f00PTnzQsRmHdORRKzzjsm50cptK7dy9KoIcs3ooRt2sQYYlRTyvwfI8mBJ85JmVWs= X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN2PR15MB3423 X-Proofpoint-ORIG-GUID: HMUEwOeBf5W3E9w7V6qOCwIOya1-ZdAa X-Proofpoint-GUID: SXYCX3-2pDOlFtAwcZfOsKcc1BGyKBYk X-Proofpoint-UnRewURL: 16 URL's were un-rewritten MIME-Version: 1.0 Subject: RE: Postgres Stale Statistics X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.205,Aquarius:18.0.858,Hydra:6.0.486,FMLib:17.11.64.514 definitions=2022-04-28_01,2022-04-27_01,2022-02-23_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 mlxscore=0 bulkscore=0 adultscore=0 impostorscore=0 malwarescore=0 suspectscore=0 phishscore=0 priorityscore=1501 spamscore=0 clxscore=1015 mlxlogscore=999 lowpriorityscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2202240000 definitions=main-2204280055 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SA0PR15MB38568AF0F1533CF282F36F8BD2FD9SA0PR15MB3856namp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Nikhil, About the EAGAIN (Resource temporarily unavailable). UDP is a stateless protocol, unlike TCP which is connection oriented. The r= ecvfrom() code will not know whether or not the sender has closed its socke= t, it only knows whether or not there is data waiting to be read. According= to the man page for recvfrom on Linux: If no messages are available at the socket, the receive calls wait for = a message to arrive, unless the socket is nonblocking (see fcntl(2)) in whi= ch case the value -1 is returned and the external variable errno set to EAG= AIN. may you need to explore other option like disk saturation. using stale statistics instead of current ones because stats collector is n= ot responding Regards, Adelino Silva ________________________________ From: Nikhil Shetty Sent: Wednesday, April 27, 2022 4:36 PM To: Adelino Silva Cc: Pgsql-admin Subject: [EXTERNAL] Re: Postgres Stale Statistics Hi Adelino, I went through the article and I see there is no issue with IPv= 6 in our case, it is using IPv4. I used strace and found 'Resource temporar= ily unavailable' error though, not sure what this means, does this mean the= re is an ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Hi Adelino, I went through the article and I see there is no issue with IPv6 in our cas= e, it is using IPv4. I used strace and found 'Resource temporarily unavailable' error though, no= t sure what this means, does this mean there is an issue with disk I/O? strace: Process 5134 attached epoll_wait(3, [{EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1 close(3) =3D 0 recvfrom(10, "\2\0\0\0\230\0\0\0\7@\0\0\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0= \0\0"..., 1000, 0, NULL, NULL) =3D 152 recvfrom(10, 0x7ffeeb967fa0, 1000, 0, NULL, NULL) =3D -1 EAGAIN (Resource t= emporarily unavailable) epoll_create1(EPOLL_CLOEXEC) =3D 3 epoll_ctl(3, EPOLL_CTL_ADD, 11, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860176= , u64=3D31860176}}) =3D 0 epoll_ctl(3, EPOLL_CTL_ADD, 7, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860200,= u64=3D31860200}}) =3D 0 epoll_ctl(3, EPOLL_CTL_ADD, 10, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860224= , u64=3D31860224}}) =3D 0 epoll_wait(3, [{EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1 close(3) =3D 0 recvfrom(10, "\2\0\0\0\250\3\0\0\7@\0\0\10\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\= 0\0\0"..., 1000, 0, NULL, NULL) =3D 936 recvfrom(10, "\2\0\0\0\250\3\0\0\0\0\0\0\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0= \0\0\0"..., 1000, 0, NULL, NULL) =3D 936 recvfrom(10, "\2\0\0\0x\1\0\0\7@\0\0\3\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\= 0"..., 1000, 0, NULL, NULL) =3D 376 recvfrom(10, 0x7ffeeb967fa0, 1000, 0, NULL, NULL) =3D -1 EAGAIN (Resource t= emporarily unavailable) epoll_create1(EPOLL_CLOEXEC) =3D 3 epoll_ctl(3, EPOLL_CTL_ADD, 11, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860176= , u64=3D31860176}}) =3D 0 epoll_ctl(3, EPOLL_CTL_ADD, 7, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860200,= u64=3D31860200}}) =3D 0 epoll_ctl(3, EPOLL_CTL_ADD, 10, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860224= , u64=3D31860224}}) =3D 0 epoll_wait(3, [{EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1 close(3) Regards, Nikhil On Wed, Apr 27, 2022 at 8:25 PM Adelino Silva > wrote: One possible cause for this problem is that the statistics collector proces= s is bound to an IP:port which is not responding. See the following thread discussion. https://stackoverflow.com/questions/46008372/using-stale-statistics-instead= -of-current-ones [https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon@2.png?v= =3D73d79a89bded] Using stale statistics instead of current ones - Stack Overflow Teams. Q&A for work. Connect and share knowledge within a single location t= hat is structured and easy to search. Learn more stackoverflow.com Regards, Adelino Silva ________________________________ From: Nikhil Shetty > Sent: Wednesday, April 27, 2022 2:49 PM To: Adelino Silva > Cc: Pgsql-admin > Subject: [EXTERNAL] Re: Postgres Stale Statistics Hi Adelino, I had gone through that thread before, we cannot move the stats= to RAM as of now. Thanks, Nikhil On Wed, Apr 27, 2022 at 6:16 PM Adelino S= ilva > wrote: Hi,= Found this thread that explains the warning. ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Hi Adelino, I had gone through that thread before, we cannot move the stats to RAM as o= f now. Thanks, Nikhil On Wed, Apr 27, 2022 at 6:16 PM Adelino Silva > wrote: Hi, Found this thread that explains the warning. using stale statistics instead of current ones because stats collector is n= ot responding https://www.postgresql.org/message-id/1457523467.24545.43.camel@2ndquadrant= .com [https://www.postgresql.org/media-archives/img/about/press/elephant.png] PostgreSQL: Re: using stale statistics instead of current ones because stat= s collector is not responding Hi, On Tue, 2016-03-08 at 16:18 -0800, Tory M Blue wrote: > No hits on the = intratubes on this. > =85 www.postgresql.org Regards, Adelino Silva ________________________________ From: Nikhil Shetty > Sent: Wednesday, April 27, 2022 12:08 PM To: Pgsql-admin > Subject: [EXTERNAL] Postgres Stale Statistics Hi, We are getting below WARNING on one of the standby instances. Not sure = what caused it but to resolve it we tried restarting the database instances= but it is still not working WARNING - using stale statistics instead of cu= rrent ones because ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Hi, We are getting below WARNING on one of the standby instances. Not sure what= caused it but to resolve it we tried restarting the database instances but= it is still not working WARNING - using stale statistics instead of current ones because stats coll= ector is not responding Postgresql version - 11.7 Any other option to resolve this? We are thinking of building the standby a= gain but what if the WARNING is for a primary database instance and a resta= rt won't solve it? Thanks and Regards, Nikhil --_000_SA0PR15MB38568AF0F1533CF282F36F8BD2FD9SA0PR15MB3856namp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi Nikhil,

About the EAGAIN (Resource temporarily unavailable).
UDP is a stateless protocol, unlike TCP which is connection oriented. = The recvfrom() code will not know whether or not the sender has closed its = socket, it only knows whether or not there is data waiting to be read. Acco= rding to the man page for recvfrom on Linux:

    If no messages a= re available at the socket, the receive calls wait for a message to arrive,= unless the socket is nonblocking (see fcntl(2)) in which case the value -1= is returned and the external variable errno set to EAGAIN.


may you need to explore other option like disk saturation.

Regards,

Adelino Silva
From: Nikhil Shetty <nik= hil.dba04@gmail.com>
Sent: Wednesday, April 27, 2022 4:36 PM
To: Adelino Silva <adelino.silva@pt.ibm.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Re: Postgres Stale Statistics
 
Hi Adelino, I went through the article and I see there is no issue with IPv= 6 in our case, it is using IPv4. I used strace and found 'Resource temporar= ily unavailable' error though, not sure what this means, does this mean the= re is an
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
 
ZjQcmQRYFpfptBannerEnd
Hi Adelino,

I went through the article and I see there is no issue with IPv6 in ou= r case, it is using IPv4.


I used strace and found 'Resource temporarily unavailable' error thoug= h, not sure what this means, does this mean there is an issue with disk I/O= ?

strace: Process = 5134 attached

epoll_wait(3, [{= EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1

close(3)          &n= bsp;                     =3D 0

recvfrom(10, &qu= ot;\2\0\0\0\230\0\0\0\7@\0\0\1\0\0\0\5\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0".= .., 1000, 0, NULL, NULL) =3D 152

recvfrom(10, 0x7= ffeeb967fa0, 1000, 0, NULL, NULL) =3D -1 EAGAIN (Resource temporarily unava= ilable)

epoll_create1(EP= OLL_CLOEXEC)    &nb= sp;       =3D 3

epoll_ctl(3, EPO= LL_CTL_ADD, 11, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860176, u64=3D31860176= }}) =3D 0

epoll_ctl(3, EPO= LL_CTL_ADD, 7, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860200, u64=3D31860200}= }) =3D 0

epoll_ctl(3, EPO= LL_CTL_ADD, 10, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860224, u64=3D31860224= }}) =3D 0

epoll_wait(3, [{= EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1

close(3)          &n= bsp;                     =3D 0

recvfrom(10, &qu= ot;\2\0\0\0\250\3\0\0\7@\0\0\10\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"= ..., 1000, 0, NULL, NULL) =3D 936

recvfrom(10, &qu= ot;\2\0\0\0\250\3\0\0\0\0\0\0\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"= ;..., 1000, 0, NULL, NULL) =3D 936

recvfrom(10, &qu= ot;\2\0\0\0x\1\0\0\7@\0\0\3\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,= 1000, 0, NULL, NULL) =3D 376

recvfrom(10, 0x7= ffeeb967fa0, 1000, 0, NULL, NULL) =3D -1 EAGAIN (Resource temporarily unava= ilable)

epoll_create1(EP= OLL_CLOEXEC)    &nb= sp;       =3D 3

epoll_ctl(3, EPO= LL_CTL_ADD, 11, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860176, u64=3D31860176= }}) =3D 0

epoll_ctl(3, EPO= LL_CTL_ADD, 7, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860200, u64=3D31860200}= }) =3D 0

epoll_ctl(3, EPO= LL_CTL_ADD, 10, {EPOLLIN|EPOLLERR|EPOLLHUP, {u32=3D31860224, u64=3D31860224= }}) =3D 0

epoll_wait(3, [{= EPOLLIN, {u32=3D31860224, u64=3D31860224}}], 1, -1) =3D 1

close(3)      


Regards,

Nikhil   


On Wed, Apr 27, 2022 at 8:25 PM Ade= lino Silva <adelino.silva@pt= .ibm.com> wrote:
One possible cause for this problem is that the statistics collector proces= s is bound to an IP:port which is not responding.
See the following thread discussion.

3D""
Teams. Q&A for work. Connect and share knowledge within a single locati= on that is structured and easy to search. Learn more

Regards,

Adelino Silva

Fr= om: Nikhil Shetty <nikhil.dba04@gmail.com>
Sent: Wednesday, April 27, 2022 2:49 PM
To: Adelino Silva <adelino.silva@pt.ibm.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Re: Postgres Stale Statistics
 
Hi Adelino, I had gone through that thread before, we cannot move the stats= to RAM as of now. Thanks, Nikhil On Wed, Apr 27, 2022 at 6:16 PM Adelino S= ilva <adel= ino.silva@pt.ibm.com> wrote: Hi, Found this thread that explains the warning.
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
&= nbsp;
ZjQcmQRYFpfptBannerEnd
Hi Adelino,

I had gone through that thread before, we cannot move the stats to RAM= as of now.

Thanks,
Nikhil

On Wed, Apr 27, 2022 at 6:16 PM Adelino Silva <adelino.silva@pt.ibm= .com> wrote:
Hi,

Found this thread that explains the warning.
3D""=
= PostgreSQL: Re: using stale statistics instead of current ones because stat= s collector is not responding
Hi, On Tue, 2016-03-08 at 16:18 -0800, Tory M Blue wrote: > No hits on t= he intratubes on this. > =85
www.postgresql.org<= /a>


Regards,

Adelino Silva

From: Nikhil Shetty <nikhil.dba04@gmail.com>
Sent: Wednesday, April 27, 2022 12:08 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Postgres Stale Statistics
 
Hi, We are getting below WARNING on one of the standby instances.= Not sure what caused it but to resolve it we tried restarting the database= instances but it is still not working WARNING - using stale statistics ins= tead of current ones because
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
&= nbsp;
ZjQcmQRYFpfptBannerEnd
Hi,

We are getting below WARNING on one of the standby instances. Not= sure what caused it but to resolve it we tried restarting the database ins= tances but it is still not working


WARNING - using stale statistics instead of current ones because stats coll= ector is not responding


Postgresql version - 11.7


Any other option to resolve this? We are thinking of building the standby a= gain but what if the WARNING is for a primary database instance and a resta= rt won't solve it?


Thanks and Regards,

Nikhil

--_000_SA0PR15MB38568AF0F1533CF282F36F8BD2FD9SA0PR15MB3856namp_--