BUG #15528: on v11.0 version still get error "ERROR: catalog ismissing 1 attribute(s) for relid 6855092" - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15528: on v11.0 version still get error "ERROR: catalog ismissing 1 attribute(s) for relid 6855092"
Date
Msg-id 15528-d5798d0d38a8a639@postgresql.org
Whole thread Raw
Responses Re: BUG #15528: on v11.0 version still get error "ERROR: catalog is missing 1 attribute(s) for relid 6855092"
Re: BUG #15528: on v11.0 version still get error "ERROR: catalog ismissing 1 attribute(s) for relid 6855092"
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15528
Logged by:          zhou xiaowei
Email address:      110876189@qq.com
PostgreSQL version: 11.0
Operating system:   Linux 3.10.0-327.36.58.4.x86_64
Description:

Hi,my friend.
I dump out 27969 tables from PG v9.6.8 one by one, use "pg_dump -t xxx -f
xxx.sql". Then start 300 threads to parallel import these .sql  into
v11.0.
after data imported completely, parallel create constraint for every
table.
when all completely, execute "vacuum full",I got error "ERROR:  catalog is
missing 1 attribute(s) for relid 6855092", which occured on 11beta2 solved
by BUG #15309.

Today, I want to make sure which step cause this issue, I only start 300
threads to parallel import these .sql, not create constraint for them.
when execute "vacuum full", I got error "ERROR:  duplicate key value
violates unique constraint "pg_class_relname_nsp_index""
the details:
ERROR:  duplicate key value violates unique constraint
"pg_class_relname_nsp_index"
DETAIL:  Key (relname, relnamespace)=(pg_toast_17589_index, 99) already
exists.
STATEMENT:  vacuum full;

after "vacuum full" error,I got different info about pg_toast_17589_index
from pg_class:
ncc_1126=# select relname from pg_class where relname =
'pg_toast_17589_index';
       relname        
----------------------
 pg_toast_17589_index
 pg_toast_17589_index
(2 rows)

ncc_1126=# select * from pg_class where relname = 'pg_toast_17589_index';
       relname        | relnamespace | reltype | reloftype | relowner |
relam | relfilenode | reltablespace | relpages | reltuples | relallvisible |
reltoastrelid | relhasindex | relisshared | relpersistence | relkind |
relnatts | relchecks | relhasoids | relhasrules | relhastriggers |
relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated |
relreplident | relispartition | relrewrite | relfrozenxid | relminmxid |
relacl | reloptions | relpartbound 

----------------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+-------------+----------------+----------------+----------------+---------------------+----------------+--------------+----------------+------------+--------------+------------+--------+------------+--------------
 pg_toast_17589_index |           99 |       0 |         0 |    16396 |
403 |     1739800 |             0 |        1 |         0 |             0 |
          0 | f           | f           | p              | i       |
2 |         0 | f          | f           | f              | f              |
f              | f                   | t              | n            | f
         |          0 |            0 |          0 |        |            | 
 pg_toast_178529      |           99 |  178537 |         0 |    16396 |
0 |     1807123 |             0 |        0 |         0 |             0 |
        0 | t           | f           | p              | t       |        3
|         0 | f          | f           | f              | f              | f
             | f                   | t              | n            | f
       |          0 |        96029 |          1 |        |            | 
(2 rows)

two querys got different content for column 'relname'. 

.sql's content as follow:
--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.8
-- Dumped by pg_dump version 9.6.8

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: hrtm_myquestion; Type: TABLE; Schema: ncc_gh; Owner: ncc_gh
--

CREATE TABLE ncc_gh.hrtm_myquestion (
xxxx
);

ALTER TABLE ncc_gh.hrtm_myquestion OWNER TO ncc_gh;

--
-- Data for Name: hrtm_myquestion; Type: TABLE DATA; Schema: ncc_gh; Owner:
ncc_gh
--

COPY ncc_gh.hrtm_myquestion (......
\.
--
-- PostgreSQL database dump complete
--

what happened? is this a bug?
To get more details for this issue, how can I do it?


pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15525: Build failures when compiling Postgres with Make parallelization
Next
From: PG Bug reporting form
Date:
Subject: BUG #15529: interval max value '178000000 years' in doc is not exact.It should 178956970.