# Running: psql --help [16:53:38.015](0.018s) ok 1 - psql --help exit code 0 [16:53:38.015](0.000s) ok 2 - psql --help goes to stdout [16:53:38.015](0.000s) ok 3 - psql --help nothing to stderr [16:53:38.016](0.000s) ok 4 - psql --help maximum line length # Running: psql --version [16:53:38.021](0.005s) ok 5 - psql --version exit code 0 [16:53:38.021](0.000s) ok 6 - psql --version goes to stdout [16:53:38.021](0.000s) ok 7 - psql --version nothing to stderr # Running: psql --not-a-valid-option [16:53:38.028](0.006s) ok 8 - psql with invalid option nonzero exit code [16:53:38.028](0.000s) ok 9 - psql with invalid option prints error message [16:53:38.033](0.005s) ok 10 - psql --help=commands exit code 0 [16:53:38.034](0.000s) ok 11 - psql --help=commands goes to stdout [16:53:38.034](0.000s) ok 12 - psql --help=commands nothing to stderr [16:53:38.038](0.005s) ok 13 - psql --help=variables exit code 0 [16:53:38.039](0.000s) ok 14 - psql --help=variables goes to stdout [16:53:38.039](0.000s) ok 15 - psql --help=variables nothing to stderr # Checking port 53064 # Found port 53064 Name: main Data directory: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/archives Connection string: port=53064 host=/tmp/xT0i2i7hCR Log file: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/log/001_basic_main.log [16:53:38.042](0.003s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata -A trust -N --locale=C --encoding=UTF8 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "C". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... 2024-03-21 16:53:38.454 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.743 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.747 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.748 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.750 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.752 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.753 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.753 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.754 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.755 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.756 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-21 16:53:38.876 UTC [75992] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/psql/001_basic/log/001_basic_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 76101 [16:53:39.233](1.191s) ok 16 - \copyright: exit code 0 [16:53:39.233](0.000s) ok 17 - \copyright: no stderr [16:53:39.234](0.000s) ok 18 - \copyright: matches [16:53:39.244](0.011s) ok 19 - \help without arguments: exit code 0 [16:53:39.245](0.000s) ok 20 - \help without arguments: no stderr [16:53:39.245](0.000s) ok 21 - \help without arguments: matches [16:53:39.256](0.011s) ok 22 - \help with argument: exit code 0 [16:53:39.256](0.001s) ok 23 - \help with argument: no stderr [16:53:39.257](0.000s) ok 24 - \help with argument: matches [16:53:39.268](0.011s) ok 25 - handling of unexpected PQresultStatus: exit code not 0 [16:53:39.268](0.000s) ok 26 - handling of unexpected PQresultStatus: matches [16:53:39.277](0.009s) ok 27 - \timing with successful query: exit code 0 [16:53:39.277](0.000s) ok 28 - \timing with successful query: no stderr [16:53:39.277](0.000s) ok 29 - \timing with successful query: matches [16:53:39.286](0.009s) ok 30 - \timing with query error: query failed [16:53:39.286](0.000s) ok 31 - \timing with query error: timing output appears [16:53:39.286](0.000s) ok 32 - \timing with query error: timing was updated [16:53:39.295](0.009s) ok 33 - ENCODING variable is set and updated: exit code 0 [16:53:39.296](0.000s) ok 34 - ENCODING variable is set and updated: no stderr [16:53:39.296](0.000s) ok 35 - ENCODING variable is set and updated: matches [16:53:39.305](0.009s) ok 36 - notification: exit code 0 [16:53:39.305](0.000s) ok 37 - notification: no stderr [16:53:39.306](0.000s) ok 38 - notification: matches [16:53:39.314](0.008s) ok 39 - notification with payload: exit code 0 [16:53:39.314](0.000s) ok 40 - notification with payload: no stderr [16:53:39.314](0.000s) ok 41 - notification with payload: matches [16:53:39.324](0.010s) ok 42 - server crash: psql exit code [16:53:39.324](0.001s) ok 43 - server crash: output before crash [16:53:39.325](0.000s) ok 44 - server crash: no output after crash [16:53:39.325](0.000s) ok 45 - server crash: error message [16:53:39.334](0.009s) ok 46 - \errverbose with no previous error: exit code 0 [16:53:39.335](0.000s) ok 47 - \errverbose with no previous error: no stderr [16:53:39.335](0.000s) ok 48 - \errverbose with no previous error: matches [16:53:39.346](0.012s) ok 49 - \errverbose after normal query with error [16:53:39.357](0.010s) ok 50 - \errverbose after FETCH_COUNT query with error [16:53:39.365](0.008s) ok 51 - \errverbose after \gdesc with error # Running: psql -X --single-transaction -v ON_ERROR_STOP=1 -c INSERT INTO tab_psql_single VALUES (1) -c INSERT INTO tab_psql_single VALUES (2) INSERT 0 1 INSERT 0 1 [16:53:39.389](0.024s) ok 52 - ON_ERROR_STOP, --single-transaction and multiple -c switches [16:53:39.400](0.011s) ok 53 - --single-transaction commits transaction, ON_ERROR_STOP and multiple -c switches # Running: psql -X --single-transaction -v ON_ERROR_STOP=1 -c INSERT INTO tab_psql_single VALUES (3) -c \copy tab_psql_single FROM '/tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent' INSERT 0 1 /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent: No such file or directory [16:53:39.415](0.014s) ok 54 - ON_ERROR_STOP, --single-transaction and multiple -c switches, error [16:53:39.424](0.010s) ok 55 - client-side error rolls back transaction, ON_ERROR_STOP and multiple -c switches # Running: psql -X --single-transaction -v ON_ERROR_STOP=1 -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql INSERT 0 1 INSERT 0 1 [16:53:39.438](0.014s) ok 56 - ON_ERROR_STOP, --single-transaction and multiple -f switches [16:53:39.448](0.010s) ok 57 - --single-transaction commits transaction, ON_ERROR_STOP and multiple -f switches # Running: psql -X --single-transaction -v ON_ERROR_STOP=1 -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql INSERT 0 1 psql:/tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql:1: error: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent: No such file or directory [16:53:39.462](0.014s) ok 58 - ON_ERROR_STOP, --single-transaction and multiple -f switches, error [16:53:39.472](0.010s) ok 59 - client-side error rolls back transaction, ON_ERROR_STOP and multiple -f switches # Running: psql -X --single-transaction -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -c \copy tab_psql_single FROM '/tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent' INSERT 0 1 INSERT 0 1 /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent: No such file or directory [16:53:39.485](0.014s) ok 60 - no ON_ERROR_STOP, --single-transaction and multiple -f/-c switches [16:53:39.495](0.010s) ok 61 - client-side error commits transaction, no ON_ERROR_STOP and multiple -f/-c switches # Running: psql -X --single-transaction -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_insert.sql -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql INSERT 0 1 INSERT 0 1 psql:/tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql:1: error: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent: No such file or directory [16:53:39.509](0.014s) ok 62 - no ON_ERROR_STOP, --single-transaction and multiple -f switches [16:53:39.521](0.012s) ok 63 - client-side error commits transaction, no ON_ERROR_STOP and multiple -f switches # Running: psql -X --single-transaction -c INSERT INTO tab_psql_single VALUES (5) -f /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql -c INSERT INTO tab_psql_single VALUES (6) INSERT 0 1 psql:/tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/tab_copy.sql:1: error: /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/tmp_test_2NXm/nonexistent: No such file or directory INSERT 0 1 [16:53:39.536](0.015s) ok 64 - no ON_ERROR_STOP, --single-transaction and multiple -c switches [16:53:39.548](0.012s) ok 65 - client-side error commits transaction, no ON_ERROR_STOP and multiple -c switches [16:53:39.574](0.026s) ok 66 - \copy from with DEFAULT: exit code 0 [16:53:39.574](0.000s) ok 67 - \copy from with DEFAULT: no stderr [16:53:39.575](0.000s) ok 68 - \copy from with DEFAULT: matches [16:53:39.603](0.029s) ok 69 - \watch with 3 iterations: exit code 0 [16:53:39.604](0.000s) ok 70 - \watch with 3 iterations: no stderr [16:53:39.604](0.000s) ok 71 - \watch with 3 iterations: matches [16:53:39.612](0.009s) ok 72 - \watch, invalid minimum row setting: exit code not 0 [16:53:39.613](0.000s) ok 73 - \watch, invalid minimum row setting: matches [16:53:39.620](0.007s) ok 74 - \watch, minimum rows is specified more than once: exit code not 0 [16:53:39.620](0.000s) ok 75 - \watch, minimum rows is specified more than once: matches [16:53:39.634](0.013s) ok 76 - \watch, 2 minimum rows: exit code 0 [16:53:39.634](0.000s) not ok 77 - \watch, 2 minimum rows: no stderr [16:53:39.635](0.000s) # Failed test '\watch, 2 minimum rows: no stderr' # at /tmp/cirrus-ci-build/src/bin/psql/t/001_basic.pl line 371. [16:53:39.635](0.000s) # got: 'psql::5: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree' # expected: '' [16:53:39.635](0.000s) ok 78 - \watch, 2 minimum rows: matches [16:53:39.643](0.008s) ok 79 - \watch, negative interval: exit code not 0 [16:53:39.644](0.000s) ok 80 - \watch, negative interval: matches [16:53:39.651](0.007s) ok 81 - \watch, incorrect interval: exit code not 0 [16:53:39.651](0.000s) ok 82 - \watch, incorrect interval: matches [16:53:39.658](0.007s) ok 83 - \watch, out-of-range interval: exit code not 0 [16:53:39.658](0.000s) ok 84 - \watch, out-of-range interval: matches [16:53:39.666](0.008s) ok 85 - \watch, interval value is specified more than once: exit code not 0 [16:53:39.667](0.001s) ok 86 - \watch, interval value is specified more than once: matches [16:53:39.677](0.010s) ok 87 - \watch, iteration count is specified more than once: exit code not 0 [16:53:39.678](0.001s) ok 88 - \watch, iteration count is specified more than once: matches [16:53:39.690](0.012s) ok 89 - one command \g: exit code 0 [16:53:39.690](0.000s) ok 90 - one command \g: no stderr [16:53:39.690](0.000s) ok 91 - one command \g: matches [16:53:39.691](0.000s) ok 92 [16:53:39.701](0.010s) ok 93 - two commands \g: exit code 0 [16:53:39.701](0.000s) ok 94 - two commands \g: no stderr [16:53:39.701](0.000s) ok 95 - two commands \g: matches [16:53:39.702](0.000s) ok 96 [16:53:39.713](0.011s) ok 97 - two commands \g with only last result: exit code 0 [16:53:39.713](0.000s) ok 98 - two commands \g with only last result: no stderr [16:53:39.713](0.000s) ok 99 - two commands \g with only last result: matches [16:53:39.713](0.000s) ok 100 [16:53:39.713](0.000s) ok 101 [16:53:39.724](0.011s) ok 102 - copy output passed to \g pipe: exit code 0 [16:53:39.725](0.001s) not ok 103 - copy output passed to \g pipe: no stderr [16:53:39.725](0.001s) # Failed test 'copy output passed to \g pipe: no stderr' # at /tmp/cirrus-ci-build/src/bin/psql/t/001_basic.pl line 430. [16:53:39.726](0.000s) # got: 'psql::1: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree' # expected: '' [16:53:39.726](0.000s) ok 104 - copy output passed to \g pipe: matches [16:53:39.726](0.000s) ok 105 [16:53:39.726](0.000s) 1..105 ### Stopping node "main" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/psql/001_basic/data/t_001_basic_main_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" [16:53:39.831](0.105s) # Looks like you failed 2 tests of 105.