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
|
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: