pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: nemo <dbyzaa@163.com>
To: pgsql-bugs@postgresql.org
Subject: pg_dump: error: schema with OID 7956828 does not exist
Date: Thu, 7 Nov 2019 23:59:24 -0700 (MST)
Message-ID: <1573196364683-0.post@n3.nabble.com> (raw )
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
view thread (2+ messages) latest in thread
Message-ID: <1573196364683-0.post@n3.nabble.com>
Permalink: ../1573196364683-0.post@n3.nabble.com/
Also on: postgresql.org/message-id/1573196364683-0.post@n3.nabble.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: dbyzaa@163.com
Subject: Re: pg_dump: error: schema with OID 7956828 does not exist
In-Reply-To: <1573196364683-0.post@n3.nabble.com>
References: <1573196364683-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox