# Checking port 61147 # Found port 61147 Name: main Data directory: C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/pgdata Backup directory: C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/backup Archive directory: C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/archives Connection string: port=61147 host=C:/Windows/TEMP/luQwAfDK6C Log file: C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\log/004_pg_dump_parallel_main.log [10:44:49.818](0.063s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/pgdata -l C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\log/004_pg_dump_parallel_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 6124 # Running: createdb regression_src # Running: createdb regression_dest1 # Running: createdb regression_dest2 # Running: pg_dump -Fd --no-sync -j2 -f C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/backup/dump1 port=61147 host=C:/Windows/TEMP/luQwAfDK6C dbname='regression_src' pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tplain_data_key (ID 3908 OID 16413) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tplain_data_key (ID 3909 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_mod_data_key (ID 3911 OID 16418) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_mod_data_key (ID 3912 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p1_mod_data_key (ID 3914 OID 16423) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p1_mod_data_key (ID 3915 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p2_mod_data_key (ID 3917 OID 16428) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p2_mod_data_key (ID 3918 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p3_mod_data_key (ID 3920 OID 16433) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p3_mod_data_key (ID 3921 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_en_data_key (ID 3923 OID 16438) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_en_data_key (ID 3924 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p1_en_data_key (ID 3926 OID 16443) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p1_en_data_key (ID 3927 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p2_en_data_key (ID 3929 OID 16448) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p2_en_data_key (ID 3930 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p3_en_data_key (ID 3932 OID 16453) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p3_en_data_key (ID 3933 OID 0) pg_dump: warning: archive items not in correct section order [10:44:52.461](2.644s) ok 1 - parallel dump # Running: pg_restore -v -d port=61147 host=C:/Windows/TEMP/luQwAfDK6C dbname='regression_dest1' -j3 C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/backup/dump1 pg_restore: connecting to database for restore pg_restore: processing item 4094 ENCODING ENCODING pg_restore: processing item 4095 STDSTRINGS STDSTRINGS pg_restore: processing item 4096 SEARCHPATH SEARCHPATH pg_restore: processing item 4097 DATABASE regression_src pg_restore: processing item 863 TYPE digit pg_restore: creating TYPE "public.digit" pg_restore: processing item 219 TABLE ths pg_restore: creating TABLE "public.ths" pg_restore: processing item 221 TABLE ths_p1 pg_restore: creating TABLE "public.ths_p1" pg_restore: processing item 223 TABLE ths_p2 pg_restore: creating TABLE "public.ths_p2" pg_restore: processing item 225 TABLE ths_p3 pg_restore: creating TABLE "public.ths_p3" pg_restore: processing item 227 TABLE tht pg_restore: creating TABLE "public.tht" pg_restore: processing item 229 TABLE tht_p1 pg_restore: creating TABLE "public.tht_p1" pg_restore: processing item 231 TABLE tht_p2 pg_restore: creating TABLE "public.tht_p2" pg_restore: processing item 233 TABLE tht_p3 pg_restore: creating TABLE "public.tht_p3" pg_restore: processing item 217 TABLE tplain pg_restore: creating TABLE "public.tplain" pg_restore: processing item 3901 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3902 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3903 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3904 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3905 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3906 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 4085 TABLE DATA tplain pg_restore: launching item 4089 TABLE DATA tht_p1 pg_restore: launching item 4088 TABLE DATA ths_p3 pg_restore: processing data for table "public.ths_p3" pg_restore: finished item 4088 TABLE DATA ths_p3 pg_restore: launching item 4086 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: finished item 4086 TABLE DATA ths_p1 pg_restore: launching item 4087 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: processing data for table "public.tplain" pg_restore: finished item 4087 TABLE DATA ths_p2 pg_restore: launching item 4090 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 4090 TABLE DATA tht_p2 pg_restore: launching item 4091 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4091 TABLE DATA tht_p3 pg_restore: launching item 3911 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: finished item 4085 TABLE DATA tplain pg_restore: launching item 3908 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 3911 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3920 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: finished item 3920 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3936 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3936 INDEX ATTACH ths_p3_mod_data_key pg_restore: launching item 3914 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" pg_restore: finished item 3908 CONSTRAINT tplain tplain_data_key pg_restore: launching item 3917 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3914 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3934 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3917 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: launching item 3923 CONSTRAINT tht tht_en_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: processing data for table "public.tht_p1" pg_restore: finished item 3934 INDEX ATTACH ths_p1_mod_data_key pg_restore: launching item 3935 INDEX ATTACH ths_p2_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: finished item 3935 INDEX ATTACH ths_p2_mod_data_key pg_restore: launching item 4098 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_mod_data_key" pg_restore: finished item 4098 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: launching item 4099 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1_mod_data_key" pg_restore: finished item 4099 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: launching item 4100 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2_mod_data_key" pg_restore: finished item 4100 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: launching item 4101 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3_mod_data_key" pg_restore: finished item 4101 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: launching item 4102 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_en_data_key" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 4102; 0 0 STATISTICS DATA STATISTICS DATA tht_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.tht_en_data_key" does not exist LINE 2: 'public.tht_en_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.tht_en_data_key'::regclass, '170000'::integer, 'relpages', '0'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4102 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: launching item 4103 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1_en_data_key" pg_restore: from TOC entry 4103; 0 0 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.tht_p1_en_data_key" does not exist LINE 2: 'public.tht_p1_en_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.tht_p1_en_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4103 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: launching item 4104 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2_en_data_key" pg_restore: from TOC entry 4104; 0 0 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.tht_p2_en_data_key" does not exist LINE 2: 'public.tht_p2_en_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.tht_p2_en_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4089 TABLE DATA tht_p1 pg_restore: launching item 4105 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: finished item 4104 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore:pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3_en_data_key" launching item 4106 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain_data_key" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 4105; 0 0 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.tht_p3_en_data_key" does not exist LINE 2: 'public.tht_p3_en_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.tht_p3_en_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4105 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: launching item 4107 STATISTICS DATA STATISTICS DATA ths pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths" pg_restore: finished item 4106 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: launching item 4108 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1" pg_restore: finished item 4108 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: launching item 4109 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2" pg_restore: finished item 4107 STATISTICS DATA STATISTICS DATA ths pg_restore: launching item 4110 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3" pg_restore: finished item 4109 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: launching item 4111 STATISTICS DATA STATISTICS DATA tht pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht" pg_restore: finished item 4110 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: launching item 4112 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1" pg_restore: finished item 4111 STATISTICS DATA STATISTICS DATA tht pg_restore: launching item 4113 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2" pg_restore: finished item 4112 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: launching item 4114 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3" pg_restore: finished item 4113 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: launching item 4115 STATISTICS DATA STATISTICS DATA tplain pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain" pg_restore: finished item 4114 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: finished item 4115 STATISTICS DATA STATISTICS DATA tplain pg_restore: finished item 3923 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3926 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3929 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" launching item 3932 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3926 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3937 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3932 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: finished item 3937 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3939 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3939 INDEX ATTACH tht_p3_en_data_key pg_restore: finished item 3929 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3938 INDEX ATTACH tht_p2_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" pg_restore: finished item 3938 INDEX ATTACH tht_p2_en_data_key pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 8 [10:44:52.711](0.250s) not ok 2 - parallel restore [10:44:52.711](0.000s) # Failed test 'parallel restore' # at C:/cirrus/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 56. # Running: pg_dump -Fd --no-sync -j2 -f C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/backup/dump2 --inserts port=61147 host=C:/Windows/TEMP/luQwAfDK6C dbname='regression_src' pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tplain_data_key (ID 3908 OID 16413) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tplain_data_key (ID 3909 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_mod_data_key (ID 3911 OID 16418) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_mod_data_key (ID 3912 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p1_mod_data_key (ID 3914 OID 16423) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p1_mod_data_key (ID 3915 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p2_mod_data_key (ID 3917 OID 16428) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p2_mod_data_key (ID 3918 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p3_mod_data_key (ID 3920 OID 16433) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR ths_p3_mod_data_key (ID 3921 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_en_data_key (ID 3923 OID 16438) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_en_data_key (ID 3924 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p1_en_data_key (ID 3926 OID 16443) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p1_en_data_key (ID 3927 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p2_en_data_key (ID 3929 OID 16448) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p2_en_data_key (ID 3930 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p3_en_data_key (ID 3932 OID 16453) pg_dump: detail: POST-DATA BOUNDARY (ID 4093) pg_dump: detail: RELATION STATISTICS FOR tht_p3_en_data_key (ID 3933 OID 0) pg_dump: warning: archive items not in correct section order [10:44:53.087](0.376s) ok 3 - parallel dump as inserts # Running: pg_restore -v -d port=61147 host=C:/Windows/TEMP/luQwAfDK6C dbname='regression_dest2' -j3 C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/backup/dump2 pg_restore: connecting to database for restore pg_restore: processing item 4094 ENCODING ENCODING pg_restore: processing item 4095 STDSTRINGS STDSTRINGS pg_restore: processing item 4096 SEARCHPATH SEARCHPATH pg_restore: processing item 4097 DATABASE regression_src pg_restore: processing item 863 TYPE digit pg_restore: creating TYPE "public.digit" pg_restore: processing item 219 TABLE ths pg_restore: creating TABLE "public.ths" pg_restore: processing item 221 TABLE ths_p1 pg_restore: creating TABLE "public.ths_p1" pg_restore: processing item 223 TABLE ths_p2 pg_restore: creating TABLE "public.ths_p2" pg_restore: processing item 225 TABLE ths_p3 pg_restore: creating TABLE "public.ths_p3" pg_restore: processing item 227 TABLE tht pg_restore: creating TABLE "public.tht" pg_restore: processing item 229 TABLE tht_p1 pg_restore: creating TABLE "public.tht_p1" pg_restore: processing item 231 TABLE tht_p2 pg_restore: creating TABLE "public.tht_p2" pg_restore: processing item 233 TABLE tht_p3 pg_restore: creating TABLE "public.tht_p3" pg_restore: processing item 217 TABLE tplain pg_restore: creating TABLE "public.tplain" pg_restore: processing item 3901 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3902 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3903 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3904 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3905 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3906 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 4085 TABLE DATA tplain pg_restore: launching item 4089 TABLE DATA tht_p1 pg_restore: launching item 4088 TABLE DATA ths_p3 pg_restore: processing data for table "public.tht_p1" pg_restore: processing data for table "public.ths_p3" pg_restore: processing data for table "public.tplain" pg_restore: finished item 4088 TABLE DATA ths_p3 pg_restore: launching item 4086 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: finished item 4089 TABLE DATA tht_p1 pg_restore: launching item 4087 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 4087 TABLE DATA ths_p2 pg_restore: launching item 4090 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 4085 TABLE DATA tplain pg_restore: launching item 3908 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 3908 CONSTRAINT tplain tplain_data_key pg_restore: launching item 4091 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4091 TABLE DATA tht_p3 pg_restore: launching item 3911 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: finished item 4090 TABLE DATA tht_p2 pg_restore: launching item 3923 CONSTRAINT tht tht_en_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: finished item 3923 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3926 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" pg_restore: finished item 3926 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3937 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3937 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3929 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: finished item 3929 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3932 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3932 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: launching item 3938 INDEX ATTACH tht_p2_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" pg_restore: finished item 3938 INDEX ATTACH tht_p2_en_data_key pg_restore: launching item 3939 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3939 INDEX ATTACH tht_p3_en_data_key pg_restore: launching item 4098 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_mod_data_key" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 4098; 0 0 STATISTICS DATA STATISTICS DATA ths_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.ths_mod_data_key" does not exist LINE 2: 'public.ths_mod_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.ths_mod_data_key'::regclass, '170000'::integer, 'relpages', '0'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4098 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: launching item 4099 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1_mod_data_key" pg_restore: from TOC entry 4099; 0 0 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.ths_p1_mod_data_key" does not exist LINE 2: 'public.ths_p1_mod_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.ths_p1_mod_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4099 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: launching item 4100 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2_mod_data_key" pg_restore: from TOC entry 4100; 0 0 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.ths_p2_mod_data_key" does not exist LINE 2: 'public.ths_p2_mod_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.ths_p2_mod_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4100 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: launching item 4101 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3_mod_data_key" pg_restore: from TOC entry 4101; 0 0 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: relation "public.ths_p3_mod_data_key" does not exist LINE 2: 'public.ths_p3_mod_data_key'::regclass, ^ Command was: SELECT pg_catalog.pg_set_relation_stats( 'public.ths_p3_mod_data_key'::regclass, '170000'::integer, 'relpages', '1'::integer, 'reltuples', '0'::real, 'relallvisible', '0'::integer ); pg_restore: finished item 4101 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: launching item 4102 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_en_data_key" pg_restore: finished item 4102 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: launching item 4103 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1_en_data_key" pg_restore: finished item 4103 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: launching item 4104 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2_en_data_key" pg_restore: finished item 4104 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: launching item 4105 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3_en_data_key" pg_restore: finished item 4105 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: launching item 4106 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain_data_key" pg_restore: finished item 4106 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: launching item 4107 STATISTICS DATA STATISTICS DATA ths pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths" pg_restore: finished item 4107 STATISTICS DATA STATISTICS DATA ths pg_restore: launching item 4108 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1" pg_restore: finished item 4108 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: launching item 4109 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2" pg_restore: finished item 4109 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: launching item 4110 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3" pg_restore: finished item 4110 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: launching item 4111 STATISTICS DATA STATISTICS DATA tht pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht" pg_restore: finished item 4111 STATISTICS DATA STATISTICS DATA tht pg_restore: launching item 4112 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1" pg_restore: finished item 4112 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: launching item 4113 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2" pg_restore: finished item 4113 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: launching item 4114 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3" pg_restore: finished item 4114 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: launching item 4115 STATISTICS DATA STATISTICS DATA tplain pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain" pg_restore: finished item 4115 STATISTICS DATA STATISTICS DATA tplain pg_restore: finished item 4086 TABLE DATA ths_p1 pg_restore: finished item 3911 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3920 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3914 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: launching item 3917 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: pg_restore:creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3914 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3934 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3917 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: finished item 3934 INDEX ATTACH ths_p1_mod_data_key pg_restore: launching item 3935 INDEX ATTACH ths_p2_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: finished item 3935 INDEX ATTACH ths_p2_mod_data_key pg_restore: finished item 3920 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3936 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3936 INDEX ATTACH ths_p3_mod_data_key pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 8 [10:44:54.385](1.298s) not ok 4 - parallel restore as inserts [10:44:54.385](0.000s) # Failed test 'parallel restore as inserts' # at C:/cirrus/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 73. [10:44:54.388](0.002s) 1..4 ### Stopping node "main" using mode immediate # Running: pg_ctl -D C:\cirrus\build/testrun/pg_dump/004_pg_dump_parallel\data/t_004_pg_dump_parallel_main_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" [10:44:54.543](0.156s) # Looks like you failed 2 tests of 4.