# Checking port 60881 # Found port 60881 Name: main Data directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/archives Connection string: port=60881 host=/tmp/lIndpbMLEn Log file: /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/log/004_pg_dump_parallel_main.log [06:37:36.259](0.012s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/pgdata -l /tmp/cirrus-ci-build/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 34888 # Running: createdb regression_src # Running: createdb regression_dest1 # Running: createdb regression_dest2 # Running: pg_dump -Fd --no-sync -j2 -f /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup/dump1 port=60881 host=/tmp/lIndpbMLEn dbname='regression_src' [06:37:36.830](0.571s) ok 1 - parallel dump # Running: pg_restore -v -d port=60881 host=/tmp/lIndpbMLEn dbname='regression_dest1' -j3 /tmp/cirrus-ci-build/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 4048 ENCODING ENCODING pg_restore: processing item 4049 STDSTRINGS STDSTRINGS pg_restore: processing item 4050 SEARCHPATH SEARCHPATH pg_restore: processing item 4051 DATABASE regression_src pg_restore: processing item 854 TYPE digit pg_restore: creating TYPE "public.digit" pg_restore: processing item 218 TABLE ths pg_restore: creating TABLE "public.ths" pg_restore: processing item 4052 STATISTICS DATA TABLE ths pg_restore: creating STATISTICS DATA "public.TABLE ths" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 4052; 0 0 STATISTICS DATA TABLE ths (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 219 TABLE ths_p1 pg_restore: creating TABLE "public.ths_p1" pg_restore: processing item 4053 STATISTICS DATA TABLE ths_p1 pg_restore: creating STATISTICS DATA "public.TABLE ths_p1" pg_restore: from TOC entry 4053; 0 0 STATISTICS DATA TABLE ths_p1 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p1'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 220 TABLE ths_p2 pg_restore: creating TABLE "public.ths_p2" pg_restore: processing item 4054 STATISTICS DATA TABLE ths_p2 pg_restore: creating STATISTICS DATA "public.TABLE ths_p2" pg_restore: from TOC entry 4054; 0 0 STATISTICS DATA TABLE ths_p2 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p2'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 221 TABLE ths_p3 pg_restore: creating TABLE "public.ths_p3" pg_restore: processing item 4055 STATISTICS DATA TABLE ths_p3 pg_restore: creating STATISTICS DATA "public.TABLE ths_p3" pg_restore: from TOC entry 4055; 0 0 STATISTICS DATA TABLE ths_p3 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p3'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 222 TABLE tht pg_restore: creating TABLE "public.tht" pg_restore: processing item 4056 STATISTICS DATA TABLE tht pg_restore: creating STATISTICS DATA "public.TABLE tht" pg_restore: from TOC entry 4056; 0 0 STATISTICS DATA TABLE tht (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 223 TABLE tht_p1 pg_restore: creating TABLE "public.tht_p1" pg_restore: processing item 4057 STATISTICS DATA TABLE tht_p1 pg_restore: creating STATISTICS DATA "public.TABLE tht_p1" pg_restore: from TOC entry 4057; 0 0 STATISTICS DATA TABLE tht_p1 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p1'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 224 TABLE tht_p2 pg_restore: creating TABLE "public.tht_p2" pg_restore: processing item 4058 STATISTICS DATA TABLE tht_p2 pg_restore: creating STATISTICS DATA "public.TABLE tht_p2" pg_restore: from TOC entry 4058; 0 0 STATISTICS DATA TABLE tht_p2 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p2'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 225 TABLE tht_p3 pg_restore: creating TABLE "public.tht_p3" pg_restore: processing item 4059 STATISTICS DATA TABLE tht_p3 pg_restore: creating STATISTICS DATA "public.TABLE tht_p3" pg_restore: from TOC entry 4059; 0 0 STATISTICS DATA TABLE tht_p3 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p3'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 217 TABLE tplain pg_restore: creating TABLE "public.tplain" pg_restore: processing item 4060 STATISTICS DATA TABLE tplain pg_restore: creating STATISTICS DATA "public.TABLE tplain" pg_restore: from TOC entry 4060; 0 0 STATISTICS DATA TABLE tplain (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tplain'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 3864 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3865 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3866 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3867 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3868 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3869 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 4039 TABLE DATA tplain pg_restore: launching item 4043 TABLE DATA tht_p1 pg_restore: launching item 4042 TABLE DATA ths_p3 pg_restore: processing data for table "public.tplain" pg_restore: finished item 4039 TABLE DATA tplain pg_restore: launching item 3871 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 3871 CONSTRAINT tplain tplain_data_key pg_restore: launching item 4040 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: finished item 4040 TABLE DATA ths_p1 pg_restore: launching item 4044 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 4044 TABLE DATA tht_p2 pg_restore: launching item 4041 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 4041 TABLE DATA ths_p2 pg_restore: launching item 4045 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4045 TABLE DATA tht_p3 pg_restore: launching item 3873 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: finished item 3873 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3875 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" pg_restore: finished item 3875 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3888 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3888 INDEX ATTACH ths_p1_mod_data_key pg_restore: launching item 3877 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3877 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: launching item 3889 INDEX ATTACH ths_p2_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: finished item 3889 INDEX ATTACH ths_p2_mod_data_key pg_restore: launching item 3881 CONSTRAINT tht tht_en_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: processing data for table "public.ths_p3" pg_restore: finished item 3881 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3885 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: finished item 3885 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3892 INDEX ATTACH tht_p2_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" pg_restore: processing data for table "public.tht_p1" pg_restore: finished item 4042 TABLE DATA ths_p3 pg_restore: launching item 3879 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: finished item 4043 TABLE DATA tht_p1 pg_restore: launching item 3883 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" pg_restore: finished item 3892 INDEX ATTACH tht_p2_en_data_key pg_restore: launching item 3887 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3879 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3890 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3883 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3891 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3887 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: launching item 4061 STATISTICS DATA INDEX ths_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_mod_data_key" pg_restore: finished item 3890 INDEX ATTACH ths_p3_mod_data_key pg_restore: launching item 4063 STATISTICS DATA INDEX ths_p2_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_p2_mod_data_key" pg_restore: finished item 3891 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3893 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3893 INDEX ATTACH tht_p3_en_data_key pg_restore: launching item 4062 STATISTICS DATA INDEX ths_p1_mod_data_key pg_restore:pg_restore: from TOC entry 4061; 0 0 STATISTICS DATA INDEX ths_mod_data_key (no owner) creating STATISTICS DATA "public.INDEX ths_p1_mod_data_key" pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_mod_data_key'::regclass, relpages => '0'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore:pg_restore: from TOC entry 4063; 0 0 STATISTICS DATA INDEX ths_p2_mod_data_key (no owner) finished item 4061 STATISTICS DATA INDEX ths_mod_data_key pg_restore:pg_restore: error: launching item 4064 STATISTICS DATA INDEX ths_p3_mod_data_key could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p2_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: pg_restore:creating STATISTICS DATA "public.INDEX ths_p3_mod_data_key" finished item 4063 STATISTICS DATA INDEX ths_p2_mod_data_key pg_restore: launching item 4065 STATISTICS DATA INDEX tht_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_en_data_key" pg_restore: from TOC entry 4062; 0 0 STATISTICS DATA INDEX ths_p1_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p1_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4062 STATISTICS DATA INDEX ths_p1_mod_data_key pg_restore: launching item 4066 STATISTICS DATA INDEX tht_p1_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_p1_en_data_key" pg_restore: from TOC entry 4065; 0 0 STATISTICS DATA INDEX tht_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_en_data_key'::regclass, relpages => '0'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4065 STATISTICS DATA INDEX tht_en_data_key pg_restore: launching item 4067 STATISTICS DATA INDEX tht_p2_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_p2_en_data_key" pg_restore: from TOC entry 4066; 0 0 STATISTICS DATA INDEX tht_p1_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p1_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4066 STATISTICS DATA INDEX tht_p1_en_data_key pg_restore: pg_restore:launching item 4068 STATISTICS DATA INDEX tht_p3_en_data_key from TOC entry 4064; 0 0 STATISTICS DATA INDEX ths_p3_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p3_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: creating STATISTICS DATA "public.INDEX tht_p3_en_data_key" pg_restore: finished item 4064 STATISTICS DATA INDEX ths_p3_mod_data_key pg_restore: launching item 4069 STATISTICS DATA INDEX tplain_data_key pg_restore: creating STATISTICS DATA "public.INDEX tplain_data_key" pg_restore: from TOC entry 4068; 0 0 STATISTICS DATA INDEX tht_p3_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p3_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4068 STATISTICS DATA INDEX tht_p3_en_data_key pg_restore: from TOC entry 4067; 0 0 STATISTICS DATA INDEX tht_p2_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p2_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4067 STATISTICS DATA INDEX tht_p2_en_data_key pg_restore: from TOC entry 4069; 0 0 STATISTICS DATA INDEX tplain_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tplain_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4069 STATISTICS DATA INDEX tplain_data_key pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 27 [06:37:36.903](0.074s) not ok 2 - parallel restore [06:37:36.904](0.000s) # Failed test 'parallel restore' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 56. # Running: pg_dump -Fd --no-sync -j2 -f /tmp/cirrus-ci-build/build/testrun/pg_dump/004_pg_dump_parallel/data/t_004_pg_dump_parallel_main_data/backup/dump2 --inserts port=60881 host=/tmp/lIndpbMLEn dbname='regression_src' [06:37:37.235](0.331s) ok 3 - parallel dump as inserts # Running: pg_restore -v -d port=60881 host=/tmp/lIndpbMLEn dbname='regression_dest2' -j3 /tmp/cirrus-ci-build/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 4048 ENCODING ENCODING pg_restore: processing item 4049 STDSTRINGS STDSTRINGS pg_restore: processing item 4050 SEARCHPATH SEARCHPATH pg_restore: processing item 4051 DATABASE regression_src pg_restore: processing item 854 TYPE digit pg_restore: creating TYPE "public.digit" pg_restore: processing item 218 TABLE ths pg_restore: creating TABLE "public.ths" pg_restore: processing item 4052 STATISTICS DATA TABLE ths pg_restore: creating STATISTICS DATA "public.TABLE ths" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 4052; 0 0 STATISTICS DATA TABLE ths (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 219 TABLE ths_p1 pg_restore: creating TABLE "public.ths_p1" pg_restore: processing item 4053 STATISTICS DATA TABLE ths_p1 pg_restore: creating STATISTICS DATA "public.TABLE ths_p1" pg_restore: from TOC entry 4053; 0 0 STATISTICS DATA TABLE ths_p1 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p1'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 220 TABLE ths_p2 pg_restore: creating TABLE "public.ths_p2" pg_restore: processing item 4054 STATISTICS DATA TABLE ths_p2 pg_restore: creating STATISTICS DATA "public.TABLE ths_p2" pg_restore: from TOC entry 4054; 0 0 STATISTICS DATA TABLE ths_p2 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p2'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 221 TABLE ths_p3 pg_restore: creating TABLE "public.ths_p3" pg_restore: processing item 4055 STATISTICS DATA TABLE ths_p3 pg_restore: creating STATISTICS DATA "public.TABLE ths_p3" pg_restore: from TOC entry 4055; 0 0 STATISTICS DATA TABLE ths_p3 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p3'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 222 TABLE tht pg_restore: creating TABLE "public.tht" pg_restore: processing item 4056 STATISTICS DATA TABLE tht pg_restore: creating STATISTICS DATA "public.TABLE tht" pg_restore: from TOC entry 4056; 0 0 STATISTICS DATA TABLE tht (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 223 TABLE tht_p1 pg_restore: creating TABLE "public.tht_p1" pg_restore: processing item 4057 STATISTICS DATA TABLE tht_p1 pg_restore: creating STATISTICS DATA "public.TABLE tht_p1" pg_restore: from TOC entry 4057; 0 0 STATISTICS DATA TABLE tht_p1 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p1'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 224 TABLE tht_p2 pg_restore: creating TABLE "public.tht_p2" pg_restore: processing item 4058 STATISTICS DATA TABLE tht_p2 pg_restore: creating STATISTICS DATA "public.TABLE tht_p2" pg_restore: from TOC entry 4058; 0 0 STATISTICS DATA TABLE tht_p2 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p2'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 225 TABLE tht_p3 pg_restore: creating TABLE "public.tht_p3" pg_restore: processing item 4059 STATISTICS DATA TABLE tht_p3 pg_restore: creating STATISTICS DATA "public.TABLE tht_p3" pg_restore: from TOC entry 4059; 0 0 STATISTICS DATA TABLE tht_p3 (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p3'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 217 TABLE tplain pg_restore: creating TABLE "public.tplain" pg_restore: processing item 4060 STATISTICS DATA TABLE tplain pg_restore: creating STATISTICS DATA "public.TABLE tplain" pg_restore: from TOC entry 4060; 0 0 STATISTICS DATA TABLE tplain (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tplain'::regclass, relpages => '0'::integer, reltuples => '-1'::real, relallvisible => '0'::integer ); pg_restore: processing item 3864 TABLE ATTACH ths_p1 pg_restore: creating TABLE ATTACH "public.ths_p1" pg_restore: processing item 3865 TABLE ATTACH ths_p2 pg_restore: creating TABLE ATTACH "public.ths_p2" pg_restore: processing item 3866 TABLE ATTACH ths_p3 pg_restore: creating TABLE ATTACH "public.ths_p3" pg_restore: processing item 3867 TABLE ATTACH tht_p1 pg_restore: creating TABLE ATTACH "public.tht_p1" pg_restore: processing item 3868 TABLE ATTACH tht_p2 pg_restore: creating TABLE ATTACH "public.tht_p2" pg_restore: processing item 3869 TABLE ATTACH tht_p3 pg_restore: creating TABLE ATTACH "public.tht_p3" pg_restore: entering main parallel loop pg_restore: launching item 4039 TABLE DATA tplain pg_restore: launching item 4043 TABLE DATA tht_p1 pg_restore: launching item 4042 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 4042 TABLE DATA ths_p3 pg_restore: launching item 4040 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: finished item 4043 TABLE DATA tht_p1 pg_restore: launching item 4041 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 4041 TABLE DATA ths_p2 pg_restore: launching item 4045 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4040 TABLE DATA ths_p1 pg_restore: launching item 4044 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 4039 TABLE DATA tplain pg_restore: launching item 3871 CONSTRAINT tplain tplain_data_key pg_restore: creating CONSTRAINT "public.tplain tplain_data_key" pg_restore: finished item 4045 TABLE DATA tht_p3 pg_restore: launching item 3873 CONSTRAINT ths ths_mod_data_key pg_restore: creating CONSTRAINT "public.ths ths_mod_data_key" pg_restore: finished item 3871 CONSTRAINT tplain tplain_data_key pg_restore: launching item 3881 CONSTRAINT tht tht_en_data_key pg_restore: creating CONSTRAINT "public.tht tht_en_data_key" pg_restore: finished item 3881 CONSTRAINT tht tht_en_data_key pg_restore: launching item 3883 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: creating CONSTRAINT "public.tht_p1 tht_p1_en_data_key" pg_restore: finished item 3873 CONSTRAINT ths ths_mod_data_key pg_restore: launching item 3879 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p3 ths_p3_mod_data_key" pg_restore: finished item 3883 CONSTRAINT tht_p1 tht_p1_en_data_key pg_restore: launching item 3891 INDEX ATTACH tht_p1_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p1_en_data_key" pg_restore: finished item 3879 CONSTRAINT ths_p3 ths_p3_mod_data_key pg_restore: launching item 3890 INDEX ATTACH ths_p3_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p3_mod_data_key" pg_restore: finished item 3891 INDEX ATTACH tht_p1_en_data_key pg_restore: launching item 3875 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p1 ths_p1_mod_data_key" pg_restore: finished item 3890 INDEX ATTACH ths_p3_mod_data_key pg_restore: launching item 3877 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: creating CONSTRAINT "public.ths_p2 ths_p2_mod_data_key" pg_restore: finished item 3875 CONSTRAINT ths_p1 ths_p1_mod_data_key pg_restore: launching item 3888 INDEX ATTACH ths_p1_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p1_mod_data_key" pg_restore: finished item 3888 INDEX ATTACH ths_p1_mod_data_key pg_restore: launching item 3887 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: creating CONSTRAINT "public.tht_p3 tht_p3_en_data_key" pg_restore: finished item 3887 CONSTRAINT tht_p3 tht_p3_en_data_key pg_restore: launching item 3893 INDEX ATTACH tht_p3_en_data_key pg_restore: creating INDEX ATTACH "public.tht_p3_en_data_key" pg_restore: finished item 3893 INDEX ATTACH tht_p3_en_data_key pg_restore: launching item 4061 STATISTICS DATA INDEX ths_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_mod_data_key" pg_restore: from TOC entry 4061; 0 0 STATISTICS DATA INDEX ths_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_mod_data_key'::regclass, relpages => '0'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4061 STATISTICS DATA INDEX ths_mod_data_key pg_restore: launching item 4062 STATISTICS DATA INDEX ths_p1_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_p1_mod_data_key" pg_restore: from TOC entry 4062; 0 0 STATISTICS DATA INDEX ths_p1_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p1_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4062 STATISTICS DATA INDEX ths_p1_mod_data_key pg_restore: launching item 4064 STATISTICS DATA INDEX ths_p3_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_p3_mod_data_key" pg_restore: from TOC entry 4064; 0 0 STATISTICS DATA INDEX ths_p3_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p3_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4064 STATISTICS DATA INDEX ths_p3_mod_data_key pg_restore: launching item 4065 STATISTICS DATA INDEX tht_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_en_data_key" pg_restore: from TOC entry 4065; 0 0 STATISTICS DATA INDEX tht_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_en_data_key'::regclass, relpages => '0'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4065 STATISTICS DATA INDEX tht_en_data_key pg_restore: launching item 4066 STATISTICS DATA INDEX tht_p1_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_p1_en_data_key" pg_restore: finished item 3877 CONSTRAINT ths_p2 ths_p2_mod_data_key pg_restore: launching item 3889 INDEX ATTACH ths_p2_mod_data_key pg_restore: creating INDEX ATTACH "public.ths_p2_mod_data_key" pg_restore: from TOC entry 4066; 0 0 STATISTICS DATA INDEX tht_p1_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p1_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4066 STATISTICS DATA INDEX tht_p1_en_data_key pg_restore: launching item 4063 STATISTICS DATA INDEX ths_p2_mod_data_key pg_restore: creating STATISTICS DATA "public.INDEX ths_p2_mod_data_key" pg_restore: from TOC entry 4063; 0 0 STATISTICS DATA INDEX ths_p2_mod_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.ths_p2_mod_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4063 STATISTICS DATA INDEX ths_p2_mod_data_key pg_restore: launching item 4068 STATISTICS DATA INDEX tht_p3_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_p3_en_data_key" pg_restore: from TOC entry 4068; 0 0 STATISTICS DATA INDEX tht_p3_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p3_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4068 STATISTICS DATA INDEX tht_p3_en_data_key pg_restore: launching item 4069 STATISTICS DATA INDEX tplain_data_key pg_restore: creating STATISTICS DATA "public.INDEX tplain_data_key" pg_restore: from TOC entry 4069; 0 0 STATISTICS DATA INDEX tplain_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tplain_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4069 STATISTICS DATA INDEX tplain_data_key pg_restore: finished item 3889 INDEX ATTACH ths_p2_mod_data_key pg_restore: finished item 4044 TABLE DATA tht_p2 pg_restore: launching item 3885 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: creating CONSTRAINT "public.tht_p2 tht_p2_en_data_key" pg_restore: finished item 3885 CONSTRAINT tht_p2 tht_p2_en_data_key pg_restore: launching item 3892 INDEX ATTACH tht_p2_en_data_key pg_restore: launching item 4067 STATISTICS DATA INDEX tht_p2_en_data_key pg_restore: creating STATISTICS DATA "public.INDEX tht_p2_en_data_key" pg_restore: creating INDEX ATTACH "public.tht_p2_en_data_key" pg_restore: from TOC entry 4067; 0 0 STATISTICS DATA INDEX tht_p2_en_data_key (no owner) pg_restore: error: could not execute query: ERROR: function pg_catalog.pg_set_relation_stats(relation => regclass, relpages => integer, reltuples => real, relallvisible => integer) does not exist LINE 1: SELECT pg_catalog.pg_set_relation_stats( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Command was: SELECT pg_catalog.pg_set_relation_stats( relation => 'public.tht_p2_en_data_key'::regclass, relpages => '1'::integer, reltuples => '0'::real, relallvisible => '0'::integer ); pg_restore: finished item 4067 STATISTICS DATA INDEX tht_p2_en_data_key pg_restore: finished item 3892 INDEX ATTACH tht_p2_en_data_key pg_restore: finished main parallel loop pg_restore: warning: errors ignored on restore: 27 [06:37:37.555](0.321s) not ok 4 - parallel restore as inserts [06:37:37.556](0.000s) # Failed test 'parallel restore as inserts' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/004_pg_dump_parallel.pl line 73. [06:37:37.556](0.000s) 1..4 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/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" [06:37:37.670](0.114s) # Looks like you failed 2 tests of 4.