Problem reloading regression database - Mailing list pgsql-hackers

From Bruce Momjian
Subject Problem reloading regression database
Date
Msg-id 200201130418.g0D4ITp10845@candle.pha.pa.us
Whole thread Raw
Responses Re: Problem reloading regression database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I am testing pg_upgrade.  I successfully did a pg_upgrade of a 7.2
regression database into a fresh 7.2 install.  I compared the output of
pg_dump from both copies and found that c_star dump caused a crash.  I
then started doing more testing of the regression database and found
that the regression database does not load in cleanly.  These failures
cause pg_upgrade files not to match the loaded schema.

Looks like there is a problem with inheritance, patch attached listing
the pg_dump load failures. I also see what looks like a crash in the
server logs:

    DEBUG:  pq_flush: send() failed: Broken pipe
    FATAL 1:  Socket command type 1 unknown

Looks like it should be fixed before final.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
-- TOC Entry ID 2 (OID 18411)
--
-- Name: "widget_in" (opaque) Type: FUNCTION Owner: postgres
--
CREATE FUNCTION "widget_in" (opaque) RETURNS widget AS
'/usr/var/local/src/gen/pgsql/CURRENT/pgsql/src/test/regress/regress.so','widget_in' LANGUAGE 'C'; 
NOTICE:  ProcedureCreate: type widget is not yet defined
CREATE
--
-- TOC Entry ID 3 (OID 18412)
--
-- Name: "widget_out" (opaque) Type: FUNCTION Owner: postgres
--
--
CREATE TABLE "stud_emp" (
    "percent" integer
)
INHERITS ("emp", "student");
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "name"
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "age"
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "location"
CREATE
--
-- TOC Entry ID 61 (OID 18465)
--
-- Name: city Type: TABLE Owner: postgres
--
--
CREATE TABLE "d_star" (
    "dd" double precision
)
INHERITS ("b_star", "c_star");
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "class"
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "aa"
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "a"
CREATE
--
-- TOC Entry ID 73 (OID 18510)
--
-- Name: e_star Type: TABLE Owner: postgres
--
--
CREATE TABLE "d" (
    "dd" text
)
INHERITS ("b", "c", "a");
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "aa"
NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "aa"
CREATE
--
-- TOC Entry ID 100 (OID 135278)
--
-- Name: street Type: VIEW Owner: postgres
-- Data for TOC Entry ID 325 (OID 18512)
--
-- Name: f_star Type: TABLE DATA Owner: postgres
--
COPY "f_star" FROM stdin;
ERROR:  copy: line 1, pg_atoi: error in "((1,3),(2,4))": can't parse "((1,3),(2,4))"
lost synchronization with server, resetting connection
--
-- Data for TOC Entry ID 326 (OID 18517)
--
-- Name: aggtest Type: TABLE DATA Owner: postgres

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: timestamptz + interval fixed
Next
From: Bruce Momjian
Date:
Subject: Re: Problem reloading regression database