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 1ihMje-0001tr-13 for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 23:58:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihMjc-0006cT-IE for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 23:58:36 +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 1ihMjb-0006cM-QB for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 23:58:36 +0000 Received: from resqmta-po-05v.sys.comcast.net ([2001:558:fe16:19:96:114:154:164]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ihMjY-00029F-Ha for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 23:58:34 +0000 Received: from resomta-po-02v.sys.comcast.net ([96.114.154.226]) by resqmta-po-05v.sys.comcast.net with ESMTP id hMcri62DS7oc3hMjWi3hGt; Tue, 17 Dec 2019 23:58:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1576627110; bh=8iYOdHqKX28qhIEqw+sNqdxFNC3q1glJs1lqoejN2Tc=; h=Received:Received:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type; b=UciUhcyYJ0d/KuY/rUiGQUM4OGNOzwqQSr3xwD+PZyxWN1QRUbBLskWAJj4NjpeR7 5P1m8huXlhW+ZsCNjCP87E9N9viKKsTmdMWycyNX8QoOBJJlgYvgzves6rnYrNVSFJ TPPYYDPgVooyU+LiZ9AD6lNM4QaB7YITXuOga5BdRx4g5+iS03YHEgP5+CFQizypyt zSwEJLc2wUTHAXq5ZoghaESuvfknVOjIpxfzTVCvXV6JM8hNHY8SH1Bw54ux4HAomy T8xhCCE079/SAT4OwoTXy9xkJq9X7/+6uKFFKibk4OPfXEBADOj30CocpMxsSElK55 gxzyz+6zLZiOw== Received: from DESKTOPF9S98NO ([IPv6:2601:283:4880:8b40:7875:5efe:8d3c:9247]) by resomta-po-02v.sys.comcast.net with ESMTPSA id hMjUizmPrvOzUhMjVin8AK; Tue, 17 Dec 2019 23:58:30 +0000 X-Xfinity-VMeta: sc=-100.00;st=legit From: To: "'Bruce Momjian'" , Cc: , "'JED WALKER'" References: <16131-953e6ab7cb264396@postgresql.org> <20191217235411.GC30116@momjian.us> In-Reply-To: <20191217235411.GC30116@momjian.us> Subject: RE: BUG #16131: pg_upgrade 9 -> 11.6 and a database is missing Date: Tue, 17 Dec 2019 16:58:28 -0700 Message-ID: <000401d5b535$e1de6400$a59b2c00$@comcast.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQDdiMttEhOyaFXUGh4+F+dr86tvRQHTu6zEqaC7PqA= Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk It only happened on one system and it was a 9.2. I've done three other test systems (9.2 and 9.3 to 11.6 now) and one of the production and not seen it again. I would have to ask for time to roll the system back and try it again, and in my company's brilliance (as a contractor) I'll be furloughed in a day til after New Year's. I would love to figure this out, but if you haven't seen it from anyone else I'm guessing it was a one time oddity. Did I send you the logs? (I didn't see anything in them) If they will let me I might use my own time to rollback and try again and will let you know. Thanks, Jed -----Original Message----- From: Bruce Momjian Sent: Tuesday, December 17, 2019 4:54 PM To: jedwa@comcast.net; pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16131: pg_upgrade 9 -> 11.6 and a database is missing Sorry for the late reply, but I have no idea what would cause this. I don't think the 11.5->11.6 changes would have. Is there any chance you can re-run the upgrade to test if it happens again? --------------------------------------------------------------------------- On Thu, Nov 21, 2019 at 07:01:07PM +0000, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 16131 > Logged by: Jed Walker > Email address: jedwa@comcast.net > PostgreSQL version: 11.6 > Operating system: CentOS Linux release 7.7.1908 (Core) > Description: > > I did an upgrade of two matching servers, one from 9.2 -> 11.5 and had > no problems, but yesterday I did the other 9.2 -> 11.6 and a database > and user were missing from the upgraded database. > > I saw no errors, other than the unix_socket_directories issue, but one > of our databases is not in the new 11 server. We had a similar system > with the same databases that I upgraded a week ago and all databases came across. > There is no reference to this database in the upgrade logs. > The key difference between the system that I did previously that > worked and this is that the one that worked was 9.2 -> 11.5, and this > was 9.2 -> 11.6 > > Upgrade process: > yum install -y > https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgd > g-redhat-repo-latest.noarch.rpm > yum install -y postgresql11 > yum install -y postgresql11-server > shutdown -r now > systemctl stop postgresql > /usr/pgsql-11/bin/postgresql-11-setup initdb > /usr/pgsql-11/bin/pg_upgrade -v -r -d /var/lib/pgsql/data -D > /var/lib/pgsql/11/data -b "/usr/bin" -B "/usr/pgsql-11/bin" > systemctl disable postgresql > systemctl enable postgresql-11 > systemctl start postgresql-11 > ~/analyze_new_cluster.sh > > These are the databases, after upgrade database wasp and user > wasp_user were missing. > postgres=# \l > List of databases > Name | Owner | Encoding | Collate | Ctype | Access > privileges > -----------+-----------+----------+-------------+-------------+------- > -----------+-----------+----------+-------------+-------------+------- > -----------+-----------+----------+-------------+-------------+------- > -----------+-----------+----------+-------------+-------------+---- > nasdb | nasuser | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > + > | | | | | > postgres=CTc/postgres > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > postgres=CTc/postgres + > | | | | | > =c/postgres > wasp | wasp_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > =Tc/wasp_user + > | | | | | > wasp_user=CTc/wasp_user > > The users are using the system, but I'd be happy to send logs etc. > -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +