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 1iSyF5-0003J7-AB for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Nov 2019 06:59:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSyF3-000792-Sq for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Nov 2019 06:59:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSyF3-00078L-Kj for pgsql-bugs@lists.postgresql.org; Fri, 08 Nov 2019 06:59:33 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSyEx-0002b8-UE for pgsql-bugs@postgresql.org; Fri, 08 Nov 2019 06:59:33 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id B199A1885516B for ; Thu, 7 Nov 2019 23:59:24 -0700 (MST) Date: Thu, 7 Nov 2019 23:59:24 -0700 (MST) From: nemo To: pgsql-bugs@postgresql.org Message-ID: <1573196364683-0.post@n3.nabble.com> Subject: pg_dump: error: schema with OID 7956828 does not exist MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, I have a problem on PG12 os:CentOS Linux release 7.4.1708 (Core) db:PostgreSQL 12.0 the db log is 2019-11-08 11:59:40.385 CST,,,19005,,5dc4e7d2.4a3d,1,,2019-11-08 11:58:10 CST,1/0,0,WARNING,57P02,"terminating connection because of crash of another server process","The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,"quickdie, postgres.c:2717"," os message ,i find is not oom Nov 6 10:00:02 xx-xx crond: /usr/sbin/sendmail: Cannot allocate memory Nov 8 16:23:59 xx-xx kernel: Reserving 161MB of memory at 688MB for crashkernel (System RAM: 8191MB) Nov 8 16:23:59 xx-xx kernel: Early memory node ranges Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0xbffe0000-0xbfffffff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0xc0000000-0xfeffbfff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0xfeffc000-0xfeffffff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0xff000000-0xfffbffff] Nov 8 16:23:59 xx-xx kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 8 16:23:59 xx-xx kernel: please try 'cgroup_disable=memory' option if you don't want memory cgroups Nov 8 16:23:59 xx-xx kernel: Initializing cgroup subsys memory Nov 8 16:23:59 xx-xx kernel: Freeing initrd memory: 17248k freed Nov 8 16:23:59 xx-xx kernel: Non-volatile memory driver v1.3 Nov 8 16:23:59 xx-xx kernel: crash memory driver: version 1.1 Nov 8 16:23:59 xx-xx kernel: Freeing unused kernel memory: 1764k freed Nov 8 16:24:00 xx-xx kernel: [TTM] Zone kernel: Available graphics memory: 4005228 kiB Nov 8 16:24:00 xx-xx kernel: [TTM] Zone dma32: Available graphics memory: 2097152 kiB Nov 8 17:36:48 xx-xx kernel: Reserving 161MB of memory at 688MB for crashkernel (System RAM: 8191MB) Nov 8 17:36:48 xx-xx kernel: Early memory node ranges Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0xbffe0000-0xbfffffff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0xc0000000-0xfeffbfff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0xfeffc000-0xfeffffff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0xff000000-0xfffbffff] Nov 8 17:36:48 xx-xx kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 8 17:36:48 xx-xx kernel: please try 'cgroup_disable=memory' option if you don't want memory cgroups Nov 8 17:36:48 xx-xx kernel: Initializing cgroup subsys memory Nov 8 17:36:48 xx-xx kernel: Freeing initrd memory: 17824k freed Nov 8 17:36:48 xx-xx kernel: Non-volatile memory driver v1.3 Nov 8 17:36:48 xx-xx kernel: crash memory driver: version 1.1 Nov 8 17:36:48 xx-xx kernel: Freeing unused kernel memory: 1984k freed Nov 8 17:36:48 xx-xx kernel: Freeing unused kernel memory: 424k freed Nov 8 17:36:48 xx-xx kernel: Freeing unused kernel memory: 556k freed Nov 8 17:36:49 xx-xx kernel: [TTM] Zone kernel: Available graphics memory: 4004518 kiB Nov 8 17:36:49 xx-xx kernel: [TTM] Zone dma32: Available graphics memory: 2097152 kiB Nov 8 17:38:12 xx-xx kernel: Reserving 161MB of memory at 688MB for crashkernel (System RAM: 8191MB) Nov 8 17:38:12 xx-xx kernel: Early memory node ranges Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xbffe0000-0xbfffffff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xc0000000-0xfeffbfff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xfeffc000-0xfeffffff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xff000000-0xfffbffff] Nov 8 17:38:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 8 17:38:12 xx-xx kernel: please try 'cgroup_disable=memory' option if you don't want memory cgroups Nov 8 17:38:12 xx-xx kernel: Initializing cgroup subsys memory Nov 8 17:38:12 xx-xx kernel: Freeing initrd memory: 17824k freed Nov 8 17:38:12 xx-xx kernel: Non-volatile memory driver v1.3 Nov 8 17:38:12 xx-xx kernel: crash memory driver: version 1.1 Nov 8 17:38:12 xx-xx kernel: Freeing unused kernel memory: 1984k freed Nov 8 17:38:12 xx-xx kernel: Freeing unused kernel memory: 424k freed Nov 8 17:38:12 xx-xx kernel: Freeing unused kernel memory: 556k freed Nov 8 17:38:13 xx-xx kernel: [TTM] Zone kernel: Available graphics memory: 4004514 kiB Nov 8 17:38:13 xx-xx kernel: [TTM] Zone dma32: Available graphics memory: 2097152 kiB Nov 8 18:35:12 xx-xx kernel: Reserving 161MB of memory at 688MB for crashkernel (System RAM: 8191MB) Nov 8 18:35:12 xx-xx kernel: Early memory node ranges Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xbffe0000-0xbfffffff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xc0000000-0xfeffbfff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xfeffc000-0xfeffffff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xff000000-0xfffbffff] Nov 8 18:35:12 xx-xx kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 8 18:35:12 xx-xx kernel: please try 'cgroup_disable=memory' option if you don't want memory cgroups Nov 8 18:35:12 xx-xx kernel: Initializing cgroup subsys memory Nov 8 18:35:12 xx-xx kernel: Freeing initrd memory: 17824k freed Nov 8 18:35:12 xx-xx kernel: Non-volatile memory driver v1.3 Nov 8 18:35:12 xx-xx kernel: crash memory driver: version 1.1 Nov 8 18:35:12 xx-xx kernel: Freeing unused kernel memory: 1984k freed Nov 8 18:35:12 xx-xx kernel: Freeing unused kernel memory: 424k freed Nov 8 18:35:12 xx-xx kernel: Freeing unused kernel memory: 556k freed Nov 8 18:35:13 xx-xx kernel: [TTM] Zone kernel: Available graphics memory: 4004514 kiB Nov 8 18:35:13 xx-xx kernel: [TTM] Zone dma32: Available graphics memory: 2097152 kiB Nov 8 18:47:14 xx-xx kernel: Reserving 161MB of memory at 688MB for crashkernel (System RAM: 8191MB) Nov 8 18:47:14 xx-xx kernel: Early memory node ranges Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0x0009f000-0x0009ffff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0x000a0000-0x000effff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0x000f0000-0x000fffff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0xbffe0000-0xbfffffff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0xc0000000-0xfeffbfff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0xfeffc000-0xfeffffff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0xff000000-0xfffbffff] Nov 8 18:47:14 xx-xx kernel: PM: Registered nosave memory: [mem 0xfffc0000-0xffffffff] Nov 8 18:47:14 xx-xx kernel: please try 'cgroup_disable=memory' option if you don't want memory cgroups Nov 8 18:47:14 xx-xx kernel: Initializing cgroup subsys memory Nov 8 18:47:14 xx-xx kernel: Freeing initrd memory: 17824k freed Nov 8 18:47:14 xx-xx kernel: Non-volatile memory driver v1.3 Nov 8 18:47:14 xx-xx kernel: crash memory driver: version 1.1 Nov 8 18:47:14 xx-xx kernel: Freeing unused kernel memory: 1984k freed Nov 8 18:47:14 xx-xx kernel: Freeing unused kernel memory: 424k freed Nov 8 18:47:14 xx-xx kernel: Freeing unused kernel memory: 556k freed Nov 8 18:47:15 xx-xx kernel: [TTM] Zone kernel: Available graphics memory: 4004518 kiB Nov 8 18:47:15 xx-xx kernel: [TTM] Zone dma32: Available graphics memory: 2097152 kiB os error message: Nov 8 14:30:56 xx-xx kernel: postgres[26427]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] Nov 8 14:31:41 xx-xx kernel: postgres[26453]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] Nov 8 14:32:27 xx-xx kernel: postgres[26479]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] Nov 8 14:33:12 xx-xx kernel: postgres[26523]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] Nov 8 14:33:58 xx-xx kernel: postgres[26556]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] Nov 8 14:40:43 xx-xx kernel: postgres[26571]: segfault at 0 ip 00007f0e0a9e8641 sp 00007fff971a9598 error 4 in libc-2.17.so[7f0e0a879000+1c3000] then i run the pg_dump $ pg_dump -Fc -d testdb -f test-20191108.dump pg_dump: error: schema with OID 7956828 does not exist # select * from pg_namespace where oid = 7956828 ; oid | nspname | nspowner | nspacl -----+---------+----------+-------- (0 rows) please help me!!! -- Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html