# Checking port 63573 # Found port 63573 Name: main Data directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/archives Connection string: port=63573 host=/tmp/xbvCaF74Yf Log file: /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/log/002_pg_dump_main.log [03:38:46.285](0.031s) # 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/002_pg_dump/data/t_002_pg_dump_main_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/log/002_pg_dump_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 42016 #### Begin standard error psql::56: NOTICE: merging column "col1" with inherited definition psql::56: NOTICE: merging column "col2" with inherited definition psql::255: NOTICE: return type dump_test.int42 is only a shell psql::262: NOTICE: argument type dump_test.int42 is only a shell psql::338: WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the subscription. psql::340: WARNING: wal_level is insufficient to publish logical changes HINT: Set wal_level to "logical" before creating subscriptions. psql::344: WARNING: wal_level is insufficient to publish logical changes HINT: Set wal_level to "logical" before creating subscriptions. psql::348: WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the subscription. psql::352: WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the subscription. psql::356: WARNING: wal_level is insufficient to publish logical changes HINT: Set wal_level to "logical" before creating subscriptions. psql::358: WARNING: wal_level is insufficient to publish logical changes HINT: Set wal_level to "logical" before creating subscriptions. psql::562: NOTICE: merging column "col1" with inherited definition #### End standard error # Running: pg_dump -p 63573 qqq [03:38:47.280](0.995s) ok 1 - connecting to a non-existent database: exit code not 0 [03:38:47.280](0.000s) ok 2 - connecting to a non-existent database: matches # Running: pg_dump -d regression_invalid [03:38:47.289](0.009s) ok 3 - connecting to an invalid database: exit code not 0 [03:38:47.289](0.000s) ok 4 - connecting to an invalid database: matches # Running: pg_dump -p 63573 --role=regress_dump_test_role [03:38:47.313](0.023s) ok 5 - connecting with an unprivileged user: exit code not 0 [03:38:47.313](0.000s) ok 6 - connecting with an unprivileged user: matches # Running: pg_dump -p 63573 -n nonexistent [03:38:47.326](0.013s) ok 7 - dumping a non-existent schema: exit code not 0 [03:38:47.327](0.000s) ok 8 - dumping a non-existent schema: matches # Running: pg_dump -p 63573 -t nonexistent [03:38:47.344](0.018s) ok 9 - dumping a non-existent table: exit code not 0 [03:38:47.345](0.000s) ok 10 - dumping a non-existent table: matches # Running: pg_dump -p 63573 --strict-names -n nonexistent* [03:38:47.358](0.013s) ok 11 - no matching schemas: exit code not 0 [03:38:47.358](0.000s) ok 12 - no matching schemas: matches # Running: pg_dump -p 63573 --strict-names -t nonexistent* [03:38:47.373](0.014s) ok 13 - no matching tables: exit code not 0 [03:38:47.373](0.000s) ok 14 - no matching tables: matches # Running: pg_dumpall --exclude-database . [03:38:47.403](0.030s) ok 15 - pg_dumpall: option --exclude-database rejects multipart pattern ".": exit code not 0 [03:38:47.403](0.000s) ok 16 - pg_dumpall: option --exclude-database rejects multipart pattern ".": matches # Running: pg_dumpall --exclude-database myhost.mydb [03:38:47.421](0.017s) ok 17 - pg_dumpall: option --exclude-database rejects multipart database names: exit code not 0 [03:38:47.421](0.000s) ok 18 - pg_dumpall: option --exclude-database rejects multipart database names: matches # Running: pg_dump -p 63573 -n pg_catalog ../src/bin/pg_dump/pg_dump_sort.c:204:31: runtime error: index 47 out of bounds for type 'int [47]' ==42147==Using libbacktrace symbolizer. #0 0x5594b1e748ba in DOTypeNameCompare ../src/bin/pg_dump/pg_dump_sort.c:204 #1 0x5594b1ea6921 in pg_qsort ../src/include/lib/sort_template.h:364 #2 0x5594b1e76ea8 in sortDumpableObjectsByTypeName ../src/bin/pg_dump/pg_dump_sort.c:192 #3 0x5594b1e6b4db in main ../src/bin/pg_dump/pg_dump.c:993 #4 0x7ff2bdebfd09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #5 0x5594b1e2dd29 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_dump+0x4dd29) [03:38:47.575](0.154s) not ok 19 - pg_dump: option -n pg_catalog [03:38:47.575](0.000s) # Failed test 'pg_dump: option -n pg_catalog' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/002_pg_dump.pl line 4786. # Running: pg_dumpall -p 63573 --exclude-database "myhost.mydb" -- -- PostgreSQL database cluster dump -- SET default_transaction_read_only = off; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; -- -- Roles -- CREATE ROLE postgres; ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS; CREATE ROLE regress_dump_test_role; ALTER ROLE regress_dump_test_role WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS; CREATE ROLE "regress_quoted \"" role"; ALTER ROLE "regress_quoted \"" role" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS; -- -- User Configurations -- -- -- Tablespaces -- CREATE TABLESPACE regress_dump_tablespace OWNER regress_dump_test_role LOCATION ''; -- -- Databases -- -- -- Database "template1" dump -- \connect template1 -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- Database "dump_test" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: dump_test; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE dump_test WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'C.UTF-8'; ALTER DATABASE dump_test OWNER TO postgres; \connect dump_test SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: DATABASE dump_test; Type: ACL; Schema: -; Owner: postgres -- REVOKE CONNECT,TEMPORARY ON DATABASE dump_test FROM PUBLIC; GRANT TEMPORARY ON DATABASE dump_test TO PUBLIC; GRANT CREATE ON DATABASE dump_test TO regress_dump_test_role; -- -- PostgreSQL database dump complete -- -- -- Database "dump_test2" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 17devel -- Dumped by pg_dump version 17devel SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: dump_test2; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE dump_test2 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'C'; ALTER DATABASE dump_test2 OWNER TO postgres; \connect dump_test2 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- PostgreSQL database dump complete -- -- -- Database "postgres" dump -- \connect postgres ../src/bin/pg_dump/pg_dump_sort.c:204:31: runtime error: index 47 out of bounds for type 'int [47]' ==42251==Using libbacktrace symbolizer. #0 0x56068352b8ba in DOTypeNameCompare ../src/bin/pg_dump/pg_dump_sort.c:204 #1 0x56068355d921 in pg_qsort ../src/include/lib/sort_template.h:364 #2 0x56068352dea8 in sortDumpableObjectsByTypeName ../src/bin/pg_dump/pg_dump_sort.c:192 #3 0x5606835224db in main ../src/bin/pg_dump/pg_dump.c:993 #4 0x7f676fbd1d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #5 0x5606834e4d29 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_dump+0x4dd29) Aborted (core dumped) pg_dumpall: error: pg_dump failed on database "postgres", exiting [03:38:48.162](0.586s) not ok 20 - pg_dumpall: option --exclude-database handles database names with embedded dots [03:38:48.162](0.000s) # Failed test 'pg_dumpall: option --exclude-database handles database names with embedded dots' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/002_pg_dump.pl line 4794. # Running: pg_dump --schema myhost.mydb.myschema [03:38:48.177](0.015s) ok 21 - pg_dump: option --schema rejects three-part schema names: exit code not 0 [03:38:48.178](0.000s) ok 22 - pg_dump: option --schema rejects three-part schema names: matches # Running: pg_dump --schema otherdb.myschema [03:38:48.211](0.033s) ok 23 - pg_dump: option --schema rejects cross-database multipart schema names: exit code not 0 [03:38:48.211](0.000s) ok 24 - pg_dump: option --schema rejects cross-database multipart schema names: matches # Running: pg_dump --schema . [03:38:48.242](0.031s) ok 25 - pg_dump: option --schema rejects degenerate two-part schema name: ".": exit code not 0 [03:38:48.242](0.000s) ok 26 - pg_dump: option --schema rejects degenerate two-part schema name: ".": matches # Running: pg_dump --schema "some.other.db".myschema [03:38:48.258](0.016s) ok 27 - pg_dump: option --schema rejects cross-database multipart schema names with embedded dots: exit code not 0 [03:38:48.258](0.000s) ok 28 - pg_dump: option --schema rejects cross-database multipart schema names with embedded dots: matches # Running: pg_dump --schema .. [03:38:48.271](0.013s) ok 29 - pg_dump: option --schema rejects degenerate three-part schema name: "..": exit code not 0 [03:38:48.271](0.000s) ok 30 - pg_dump: option --schema rejects degenerate three-part schema name: "..": matches # Running: pg_dump --table myhost.mydb.myschema.mytable [03:38:48.284](0.013s) ok 31 - pg_dump: option --table rejects four-part table names: exit code not 0 [03:38:48.285](0.000s) ok 32 - pg_dump: option --table rejects four-part table names: matches # Running: pg_dump --table otherdb.pg_catalog.pg_class [03:38:48.297](0.012s) ok 33 - pg_dump: option --table rejects cross-database three part table names: exit code not 0 [03:38:48.297](0.000s) ok 34 - pg_dump: option --table rejects cross-database three part table names: matches # Running: pg_dump -p 63573 --table "some.other.db".pg_catalog.pg_class [03:38:48.309](0.012s) ok 35 - pg_dump: option --table rejects cross-database three part table names with embedded dots: exit code not 0 [03:38:48.310](0.000s) ok 36 - pg_dump: option --table rejects cross-database three part table names with embedded dots: matches # Running: pg_dump --no-sync --format=custom --file=/tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/tmp_test_KGxk/binary_upgrade.dump -w --schema-only --binary-upgrade -d postgres ../src/bin/pg_dump/pg_dump_sort.c:204:31: runtime error: index 47 out of bounds for type 'int [47]' ==42338==Using libbacktrace symbolizer. #0 0x55a2192c48ba in DOTypeNameCompare ../src/bin/pg_dump/pg_dump_sort.c:204 #1 0x55a2192f6921 in pg_qsort ../src/include/lib/sort_template.h:364 #2 0x55a2192c6ea8 in sortDumpableObjectsByTypeName ../src/bin/pg_dump/pg_dump_sort.c:192 #3 0x55a2192bb4db in main ../src/bin/pg_dump/pg_dump.c:993 #4 0x7f25c2e71d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #5 0x55a21927dd29 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/pg_dump+0x4dd29) [03:38:48.479](0.169s) not ok 37 - binary_upgrade: pg_dump runs [03:38:48.479](0.000s) # Failed test 'binary_upgrade: pg_dump runs' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/002_pg_dump.pl line 4873. # Running: pg_restore -Fc --verbose --file=/tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/tmp_test_KGxk/binary_upgrade.sql /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/tmp_test_KGxk/binary_upgrade.dump pg_restore: error: could not read from input file: end of file [03:38:48.503](0.023s) not ok 38 - binary_upgrade: pg_restore runs [03:38:48.503](0.000s) # Failed test 'binary_upgrade: pg_restore runs' # at /tmp/cirrus-ci-build/src/bin/pg_dump/t/002_pg_dump.pl line 4915. could not read "/tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/tmp_test_KGxk/binary_upgrade.sql": No such file or directory at /tmp/cirrus-ci-build/src/bin/pg_dump/t/002_pg_dump.pl line 4926. # Postmaster PID for node "main" is 42016 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_dump/002_pg_dump/data/t_002_pg_dump_main_data/pgdata -m immediate stop waiting for server to shut down... done server stopped # No postmaster PID for node "main" [03:38:48.533](0.030s) # Tests were run but no plan was declared and done_testing() was not seen. [03:38:48.534](0.000s) # Looks like your test exited with 2 just after 38.