Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ivut2-0007Yb-BH for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jan 2020 03:16:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ivusz-0003cH-VB for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Jan 2020 03:16:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ivusz-0003c6-1b for pgsql-bugs@lists.postgresql.org; Mon, 27 Jan 2020 03:16:25 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ivusv-0000zY-CP for pgsql-bugs@lists.postgresql.org; Mon, 27 Jan 2020 03:16:23 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id F10CF434; Sun, 26 Jan 2020 22:16:17 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 26 Jan 2020 22:16:18 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=WKzX068kyzvhn+3IcAX/eJv7CJe xnQo7zkIr4QjuGzE=; b=fTiwCGZk3fqSC9/jgADFN+GldYAam8XVueddRwh2iea kc1Xa6Gqs71vqMUkm5/3nFKuu7oECskAsFAJP3S+5eF5WY7zeBPeTH2NNbLrF/tl usoKbvIic4InHGP5MDtlHXsDR708RykN+Rt6PhZxBy6lkHf8IYDwkyako2DH6mIY /bWjxYbuaszQN2oq+6XakrGkOLvUz1NaRGS3Ccy+62IDqRiflsTQBS25yoZpztlK EhoERkkzhz0XI8EjmcdA1ObuRZTA6W1XnqzLEWIruOdRLtnGqgb7NuMQVXwIvxMK nt4f4nKcI3uaFCA/17i4Xf9vuZHd6itURYYWUHvLT1A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=WKzX06 8kyzvhn+3IcAX/eJv7CJexnQo7zkIr4QjuGzE=; b=ibHtTFpHR+FWG52EccMH6H zUQEz++cVzB1CVxBF+K3V/L1M0Wj0Xp2Voyf0ZHb0lLqcVqNmjncYmfHSOagruR2 oefCrNGubjotivstNnWgwUQcImwy5wvq5KG8YrVjUMAUEBf4QVhY10q7F2oz4rJc YdaaE507PTeZAkf8HfQ7FE6/k6YvJESYSok68L79tVjwh5CqAoAmG0OSF02Oxgbx FWRuu56HS5K+5g0LxqcD0C1k0ftyTJPFvno3Aek5Rlp7X9jW/h9chC6jdrMljkwn VVat6NMYCo3j1mCFphINhJHNuzEpZT+HIoLaj+Dn9h+Ds+lNDZmaKggbUeRkDFhg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrfedugdehiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecuvehluhhs thgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesph grqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 0801C328005D; Sun, 26 Jan 2020 22:16:12 -0500 (EST) Date: Mon, 27 Jan 2020 12:16:05 +0900 From: Michael Paquier To: Daniel Gustafsson Cc: srinivasulu , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16227: Loss database tables automatically in a couple of days Message-ID: <20200127031605.GC4913@paquier.xyz> References: <16227-e9da632231da5d2a@postgresql.org> <20200123114829.GF1895@paquier.xyz> <004e01d5d1e6$1dfb2820$59f17860$@com.sg> <253FC2BA-4B15-4C90-A2AA-776799E407B8@yesql.se> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ncSAzJYg3Aa9+CRW" Content-Disposition: inline In-Reply-To: <253FC2BA-4B15-4C90-A2AA-776799E407B8@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --ncSAzJYg3Aa9+CRW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 24, 2020 at 02:04:57PM +0100, Daniel Gustafsson wrote: > I don't think this log dump qualifies as providing details, this is a vol= unteer > driven effort where people spend their own time. Have you gone over them= to > see if there is anything you suspect? Looking at a single one of these, = there > are numerous DROP TABLE statements in it, and we have no way of knowing if > thats expected or not. Yeah. What I can see from those logs is a bunch of logs mentioning DDL queries doing what you are complaining about. What you should try to understand is from where those come from. This comes with an effort =66rom your side, where you need to audit your queries, and put in place drastic connection policies to your database. One thing that you should try to do first is enable log_connections and log_disconnections. A second is to track down the process which may be doing that. And that's not an issue with Postgres, that's an issue with your server. Postgres here simply does what it is told to. -- Michael --ncSAzJYg3Aa9+CRW Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4uVfUACgkQnvQgOdby QH3HKQ//Zuw32IXDyXC9+f2779V6c9PzbI0FB5Kyq5pMbSOrRdYbN2Q9jKOGyuZy QyUUUZTGzrqNkqK0p3VmZrn9V4v8kFVdui6m8U5+wENQsDd2l1foTNRD6bPCkJP9 kgu7CGsT/L05B3DajRabas7zrmefmG0vBaKG/PDx/b5OeapUaX9xYE8J1F/fn4RZ ITJgvXYUGgOv9lCsvf1HgkTi1MLoJHSuKLFHN3kT5/N40dg4WoBbgMgzajIQj36X A9YL2eB23IqZv16rjxixmYEAysPeSq5BXiPXOP6z0BuassgZ79mA2H6rcZyqtZH8 RVIzMJZ7JTUMMDbSCTBKIyiLQ8CQeO30PGwUDMWG8sjwOl91FRWw2zv3goeIOOAS 8Ub8NeNvsqvq8wCb1tgf8FAmx1RMyg25z22xWDtkJd6a0YcEzukM+FMLqmDRcx9o comi2yDLxpmKX0HyvX1Bxpqb4uq28x+G6Wk14kR2SkEuEnWXz7FwTNblWOBl8SW2 ZhYbqHVfMomvhm3zIix81lw9oDD+N2GG5RvxAtHBPm0FMJLUXzmY6nU7T8eJExud U5X3G+vbpyMI+dV6ISBZQxBfW2sCUjDG9xB5iKD5LYJ3LcjIQrTgipymTm4mTN24 jI9i4LiaiHCDJ3dRgvmIkl43EwgCrOhAviufPRcW0oO1reJMYXU= =n5W7 -----END PGP SIGNATURE----- --ncSAzJYg3Aa9+CRW--