pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: nemo <dbyzaa@163.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: pg_dump: error: schema with OID 7956828 does not exist
Date: Fri, 8 Nov 2019 12:18:27 +0100
Message-ID: <20191108111827.eu6uw7vm3syv4y55@development> (raw )
In-Reply-To: <1573196364683-0.post@n3.nabble.com >
References: <1573196364683-0.post@n3.nabble.com >
On Thu, Nov 07, 2019 at 11:59:24PM -0700, nemo wrote:
>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!!!
>
Clearly the postgres process is crashing because of segfault. Please see
[1] (there's a section about core dumps) and give us backtrace and other
details.
Other than that, it'd be interesting to know where does the schema OID
come from, so maybe investigate a bit in the server log and catalogs and
try to figure out which object is referring to the OID.
[1] https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
view thread (2+ messages)
Message-ID: <20191108111827.eu6uw7vm3syv4y55@development>
Permalink: ../20191108111827.eu6uw7vm3syv4y55@development/
Also on: postgresql.org/message-id/20191108111827.eu6uw7vm3syv4y55@development
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: tomas.vondra@2ndquadrant.com, dbyzaa@163.com
Subject: Re: pg_dump: error: schema with OID 7956828 does not exist
In-Reply-To: <20191108111827.eu6uw7vm3syv4y55@development>
References: <1573196364683-0.post@n3.nabble.com> <20191108111827.eu6uw7vm3syv4y55@development>
* 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