# Checking port 64409 # Found port 64409 Name: main Data directory: /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/archives Connection string: port=64409 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/jqKJIKrEEp Log file: /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/log/004_pg_dump_parallel_main.log [10:41:50.243](0.014s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata -l /Users/admin/pgsql/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 27458 # Running: createdb regression_src # Running: createdb regression_dest1 # Running: createdb regression_dest2 # Running: pg_dump -Fd --no-sync -j2 -f /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup/dump1 port=64409 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/jqKJIKrEEp dbname='regression_src' pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tplain_data_key (ID 3568 OID 16413) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tplain_data_key (ID 3569 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_mod_data_key (ID 3571 OID 16418) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_mod_data_key (ID 3572 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p1_mod_data_key (ID 3574 OID 16423) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p1_mod_data_key (ID 3575 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p2_mod_data_key (ID 3577 OID 16428) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p2_mod_data_key (ID 3578 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p3_mod_data_key (ID 3580 OID 16433) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p3_mod_data_key (ID 3581 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_en_data_key (ID 3583 OID 16438) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_en_data_key (ID 3584 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p1_en_data_key (ID 3586 OID 16443) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p1_en_data_key (ID 3587 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p2_en_data_key (ID 3589 OID 16448) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p2_en_data_key (ID 3590 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p3_en_data_key (ID 3592 OID 16453) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p3_en_data_key (ID 3593 OID 0) pg_dump: warning: archive items not in correct section order [10:41:50.901](0.658s) ok 1 - parallel dump # Running: pg_restore -v -d port=64409 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/jqKJIKrEEp dbname='regression_dest1' -j3 /Users/admin/pgsql/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 3754 ENCODING ENCODING pg_restore: processing item 3755 STDSTRINGS STDSTRINGS pg_restore: processing item 3756 SEARCHPATH SEARCHPATH pg_restore: processing item 3757 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 3561 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3562 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3563 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3564 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3565 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3566 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 3745 TABLE DATA tplain pg_restore: launching item 3749 TABLE DATA tht_p1 pg_restore: launching item 3748 TABLE DATA ths_p3 pg_restore: processing data for table "public.tplain" pg_restore: processing data for table "public.tht_p1" pg_restore: finished item 3749 TABLE DATA tht_p1 pg_restore: launching item 3746 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: pg_restore: processing data for table "public.ths_p3" finished item 3745 TABLE DATA tplain pg_restore: launching item 3568 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 3746 TABLE DATA ths_p1 pg_restore: launching item 3750 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 3568 CONSTRAINT tplain tplain_data_key pg_restore: launching item 3747 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 3748 TABLE DATA ths_p3 pg_restore: launching item 3751 TABLE DATA tht_p3 pg_restore: finished item 3750 TABLE DATA tht_p2 pg_restore: launching item 3571 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 3751 TABLE DATA tht_p3 pg_restore: launching item 3583 CONSTRAINT tht tht_en_data_key pg_restore: finished item 3571 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3580 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: finished item 3747 TABLE DATA ths_p2 pg_restore: launching item 3574 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" pg_restore: finished item 3583 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3586 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" pg_restore: finished item 3580 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3596 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3574 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3589 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: finished item 3586 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3597 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3596 INDEX ATTACH ths_p3_mod_data_key pg_restore: launching item 3594 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3597 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3577 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3589 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3598 INDEX ATTACH tht_p2_en_data_key pg_restore: finished item 3594 INDEX ATTACH ths_p1_mod_data_key pg_restore:pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" launching item 3592 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3598 INDEX ATTACH tht_p2_en_data_key pg_restore: launching item 3758 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_mod_data_key" pg_restore: finished item 3758 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: launching item 3759 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 3759 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: launching item 3760 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2_mod_data_key" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3760; 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 3577 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: launching item 3595 INDEX ATTACH ths_p2_mod_data_key pg_restore: pg_restore: finished item 3760 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: launching item 3761 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3_mod_data_key" pg_restore: finished item 3761 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: launching item 3762 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: finished item 3592 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_en_data_key" pg_restore: launching item 3599 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3595 INDEX ATTACH ths_p2_mod_data_key pg_restore: launching item 3763 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1_en_data_key" finished item 3762 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: launching item 3764 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 3599 INDEX ATTACH tht_p3_en_data_key pg_restore: launching item 3765 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: finished item 3763 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: launching item 3766 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3_en_data_key" pg_restore: pg_restore: finished item 3764 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: launching item 3767 STATISTICS DATA STATISTICS DATA ths creating STATISTICS DATA "public.STATISTICS DATA tplain_data_key" pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths" pg_restore: finished item 3765 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: launching item 3768 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: finished item 3766 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1" pg_restore: launching item 3769 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: finished item 3767 STATISTICS DATA STATISTICS DATA ths pg_restore: launching item 3770 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3" creating STATISTICS DATA "public.STATISTICS DATA ths_p2" pg_restore: finished item 3768 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: launching item 3771 STATISTICS DATA STATISTICS DATA tht pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht" pg_restore: finished item 3769 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: launching item 3772 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: finished item 3770 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore:pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1" launching item 3773 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2" pg_restore: finished item 3771 STATISTICS DATA STATISTICS DATA tht pg_restore: launching item 3774 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3" pg_restore: finished item 3772 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: launching item 3775 STATISTICS DATA STATISTICS DATA tplain pg_restore: finished item 3773 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain" pg_restore: finished item 3774 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: finished item 3775 STATISTICS DATA STATISTICS DATA tplain pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 2 [10:41:50.955](0.054s) not ok 2 - parallel restore [10:41:50.955](0.000s) # Failed test 'parallel restore' # at /Users/admin/pgsql/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 56. # Running: pg_dump -Fd --no-sync -j2 -f /Users/admin/pgsql/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup/dump2 --inserts port=64409 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/jqKJIKrEEp dbname='regression_src' pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tplain_data_key (ID 3568 OID 16413) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tplain_data_key (ID 3569 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_mod_data_key (ID 3571 OID 16418) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_mod_data_key (ID 3572 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p1_mod_data_key (ID 3574 OID 16423) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p1_mod_data_key (ID 3575 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p2_mod_data_key (ID 3577 OID 16428) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p2_mod_data_key (ID 3578 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT ths_p3_mod_data_key (ID 3580 OID 16433) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR ths_p3_mod_data_key (ID 3581 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_en_data_key (ID 3583 OID 16438) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_en_data_key (ID 3584 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p1_en_data_key (ID 3586 OID 16443) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p1_en_data_key (ID 3587 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p2_en_data_key (ID 3589 OID 16448) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p2_en_data_key (ID 3590 OID 0) pg_dump: warning: could not resolve dependency loop among these items: pg_dump: detail: CONSTRAINT tht_p3_en_data_key (ID 3592 OID 16453) pg_dump: detail: POST-DATA BOUNDARY (ID 3753) pg_dump: detail: RELATION STATISTICS FOR tht_p3_en_data_key (ID 3593 OID 0) pg_dump: warning: archive items not in correct section order [10:41:51.038](0.083s) ok 3 - parallel dump as inserts # Running: pg_restore -v -d port=64409 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/jqKJIKrEEp dbname='regression_dest2' -j3 /Users/admin/pgsql/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 3754 ENCODING ENCODING pg_restore: processing item 3755 STDSTRINGS STDSTRINGS pg_restore: processing item 3756 SEARCHPATH SEARCHPATH pg_restore: processing item 3757 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 3561 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3562 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3563 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3564 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3565 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3566 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 3745 TABLE DATA tplain pg_restore: launching item 3749 TABLE DATA tht_p1 pg_restore: launching item 3748 TABLE DATA ths_p3 pg_restore: processing data for table "public.tplain" pg_restore: processing data for table "public.tht_p1" pg_restore: processing data for table "public.ths_p3" pg_restore: finished item 3748 TABLE DATA ths_p3 pg_restore: launching item 3746 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: finished item 3746 TABLE DATA ths_p1 pg_restore: launching item 3747 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 3749 TABLE DATA tht_p1 pg_restore: launching item 3751 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 3745 TABLE DATA tplain pg_restore: launching item 3568 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 3568 CONSTRAINT tplain tplain_data_key pg_restore: launching item 3750 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 3747 TABLE DATA ths_p2 pg_restore: launching item 3571 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: finished item 3571 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3580 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: finished item 3580 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3596 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3596 INDEX ATTACH ths_p3_mod_data_key pg_restore: launching item 3574 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" pg_restore: finished item 3574 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3594 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3594 INDEX ATTACH ths_p1_mod_data_key pg_restore: launching item 3577 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3577 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: launching item 3595 INDEX ATTACH ths_p2_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: finished item 3595 INDEX ATTACH ths_p2_mod_data_key pg_restore: launching item 3583 CONSTRAINT tht tht_en_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: finished item 3583 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3586 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" pg_restore: finished item 3586 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3597 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3597 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3758 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_mod_data_key" pg_restore: finished item 3758 STATISTICS DATA STATISTICS DATA ths_mod_data_key pg_restore: launching item 3759 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 3759 STATISTICS DATA STATISTICS DATA ths_p1_mod_data_key pg_restore: launching item 3760 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 3760 STATISTICS DATA STATISTICS DATA ths_p2_mod_data_key pg_restore: launching item 3761 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 3761 STATISTICS DATA STATISTICS DATA ths_p3_mod_data_key pg_restore: launching item 3762 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_en_data_key" pg_restore: finished item 3762 STATISTICS DATA STATISTICS DATA tht_en_data_key pg_restore: launching item 3763 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 3763 STATISTICS DATA STATISTICS DATA tht_p1_en_data_key pg_restore: launching item 3764 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2_en_data_key" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3764; 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 3764 STATISTICS DATA STATISTICS DATA tht_p2_en_data_key pg_restore: launching item 3765 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3_en_data_key" pg_restore: from TOC entry 3765; 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 3765 STATISTICS DATA STATISTICS DATA tht_p3_en_data_key pg_restore: launching item 3766 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain_data_key" pg_restore: finished item 3766 STATISTICS DATA STATISTICS DATA tplain_data_key pg_restore: launching item 3767 STATISTICS DATA STATISTICS DATA ths pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths" pg_restore: finished item 3767 STATISTICS DATA STATISTICS DATA ths pg_restore: launching item 3768 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p1" pg_restore: finished item 3768 STATISTICS DATA STATISTICS DATA ths_p1 pg_restore: launching item 3769 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p2" pg_restore: finished item 3769 STATISTICS DATA STATISTICS DATA ths_p2 pg_restore: launching item 3770 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA ths_p3" pg_restore: finished item 3770 STATISTICS DATA STATISTICS DATA ths_p3 pg_restore: launching item 3771 STATISTICS DATA STATISTICS DATA tht pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht" pg_restore: finished item 3771 STATISTICS DATA STATISTICS DATA tht pg_restore: launching item 3772 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p1" pg_restore: finished item 3772 STATISTICS DATA STATISTICS DATA tht_p1 pg_restore: launching item 3773 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p2" pg_restore: finished item 3773 STATISTICS DATA STATISTICS DATA tht_p2 pg_restore: launching item 3774 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tht_p3" pg_restore: finished item 3774 STATISTICS DATA STATISTICS DATA tht_p3 pg_restore: launching item 3775 STATISTICS DATA STATISTICS DATA tplain pg_restore: creating STATISTICS DATA "public.STATISTICS DATA tplain" pg_restore: finished item 3775 STATISTICS DATA STATISTICS DATA tplain pg_restore: finished item 3751 TABLE DATA tht_p3 pg_restore: launching item 3592 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3592 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: launching item 3599 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3599 INDEX ATTACH tht_p3_en_data_key pg_restore: finished item 3750 TABLE DATA tht_p2 pg_restore: launching item 3589 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: finished item 3589 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3598 INDEX ATTACH tht_p2_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" pg_restore: finished item 3598 INDEX ATTACH tht_p2_en_data_key pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 4 [10:41:51.246](0.208s) not ok 4 - parallel restore as inserts [10:41:51.246](0.000s) # Failed test 'parallel restore as inserts' # at /Users/admin/pgsql/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 73. [10:41:51.247](0.000s) 1..4 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /Users/admin/pgsql/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:41:51.365](0.118s) # Looks like you failed 2 tests of 4.