# Checking port 51404 # Found port 51404 Name: main Data directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/backup Archive directory: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/archives Connection string: port=51404 host=/tmp/Rc9mZb7Ln6 Log file: /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/log/004_pg_dump_parallel_main.log [06:37:37.388](0.025s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/pgdata # Running: /tmp/cirrus-ci-build/src/bin/pg_dump/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/pgdata -l /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/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 30755 # Running: createdb regression_src # Running: createdb regression_dest1 # Running: createdb regression_dest2 # Running: pg_dump -Fd --no-sync -j2 -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/backup/dump1 port=51404 host=/tmp/Rc9mZb7Ln6 dbname='regression_src' [06:37:38.909](1.521s) ok 1 - parallel dump # Running: pg_restore -v -d port=51404 host=/tmp/Rc9mZb7Ln6 dbname='regression_dest1' -j3 /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/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.tht_p1" pg_restore: processing data for table "public.ths_p3" pg_restore: finished item 4043 TABLE DATA tht_p1 pg_restore: launching item 4040 TABLE DATA ths_p1 pg_restore: processing data for table "public.ths_p1" pg_restore: processing data for table "public.tplain" pg_restore: finished item 4042 TABLE DATA ths_p3 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 4040 TABLE DATA ths_p1 pg_restore: launching item 4045 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4041 TABLE DATA ths_p2 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 4045 TABLE DATA tht_p3 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 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 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 3871 CONSTRAINT tplain tplain_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 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 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 3875 CONSTRAINT ths_p1 ths_p1_mod_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: finished item 3892 INDEX ATTACH tht_p2_en_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 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 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 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 3890 INDEX ATTACH ths_p3_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: 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 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 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: 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 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 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: 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 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 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 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: finished item 3888 INDEX ATTACH ths_p1_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: finished main parallel loop pg_restore: warning: errors ignored on restore: 27 [06:37:39.237](0.328s) not ok 2 - parallel restore [06:37:39.237](0.000s) [06:37:39.237](0.000s) # Failed test 'parallel restore' # at t/004_pg_dump_parallel.pl line 56. # Running: pg_dump -Fd --no-sync -j2 -f /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/t_004_pg_dump_parallel_main_data/backup/dump2 --inserts port=51404 host=/tmp/Rc9mZb7Ln6 dbname='regression_src' [06:37:39.885](0.648s) ok 3 - parallel dump as inserts # Running: pg_restore -v -d port=51404 host=/tmp/Rc9mZb7Ln6 dbname='regression_dest2' -j3 /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/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 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 4041 TABLE DATA ths_p2 pg_restore: processing data for table "public.ths_p2" pg_restore: finished item 4040 TABLE DATA ths_p1 pg_restore: launching item 4045 TABLE DATA tht_p3 pg_restore: processing data for table "public.tht_p3" pg_restore: finished item 4041 TABLE DATA ths_p2 pg_restore: launching item 4044 TABLE DATA tht_p2 pg_restore: processing data for table "public.tht_p2" pg_restore: finished item 4043 TABLE DATA tht_p1 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 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 4045 TABLE DATA tht_p3 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 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 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 3877 CONSTRAINT ths_p2 ths_p2_mod_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 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 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 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: 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 3888 INDEX ATTACH ths_p1_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 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 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 3891 INDEX ATTACH tht_p1_en_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: 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 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 4068 STATISTICS DATA INDEX tht_p3_en_data_key pg_restore: pg_restore: from TOC entry 4066; 0 0 STATISTICS DATA INDEX tht_p1_en_data_key (no owner) creating STATISTICS DATA "public.INDEX tht_p3_en_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.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: 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: 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:40.533](0.648s) not ok 4 - parallel restore as inserts [06:37:40.534](0.000s) [06:37:40.534](0.000s) # Failed test 'parallel restore as inserts' # at t/004_pg_dump_parallel.pl line 73. [06:37:40.534](0.000s) 1..4 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/src/bin/pg_dump/tmp_check/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:40.556](0.022s) # Looks like you failed 2 tests of 4.