# Running: createdb --help [12:38:15.730](0.017s) ok 1 - createdb --help exit code 0 [12:38:15.731](0.000s) ok 2 - createdb --help goes to stdout [12:38:15.731](0.000s) ok 3 - createdb --help nothing to stderr [12:38:15.731](0.000s) ok 4 - createdb --help maximum line length # Running: createdb --version [12:38:15.737](0.006s) ok 5 - createdb --version exit code 0 [12:38:15.737](0.000s) ok 6 - createdb --version goes to stdout [12:38:15.738](0.000s) ok 7 - createdb --version nothing to stderr # Running: createdb --not-a-valid-option [12:38:15.744](0.006s) ok 8 - createdb with invalid option nonzero exit code [12:38:15.744](0.000s) ok 9 - createdb with invalid option prints error message # Checking port 65504 # Found port 65504 Name: main Data directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/archives Connection string: port=65504 host=/tmp/ApfS3LpQHD Log file: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/log/020_createdb_main.log [12:38:15.747](0.003s) # 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/scripts/020_createdb/data/t_020_createdb_main_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/log/020_createdb_main.log -o --cluster-name=main start pg_ctl: another server might be running; trying to start server anyway waiting for server to start.... done server started # Postmaster PID for node "main" is 28778 # Running: createdb foobar1 createdb: error: query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); [12:38:16.206](0.459s) not ok 10 - createdb foobar1 exit code 0 [12:38:16.206](0.000s) # Failed test 'createdb foobar1 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 19. [12:38:16.206](0.000s) not ok 11 - SQL CREATE DATABASE run: SQL found in server log [12:38:16.207](0.000s) # Failed test 'SQL CREATE DATABASE run: SQL found in server log' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 19. [12:38:16.207](0.000s) # '2024-03-19 12:38:15.898 UTC [28794][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:15.898 UTC [28794][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:15.898 UTC [28794][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=020_createdb.pl # 2024-03-19 12:38:15.898 UTC [28794][client backend] [[unknown]][0/1:0] FATAL: database "postgres" does not exist # 2024-03-19 12:38:15.899 UTC [28795][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:15.900 UTC [28795][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:15.900 UTC [28795][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=template1 application_name=020_createdb.pl # 2024-03-19 12:38:15.900 UTC [28795][client backend] [020_createdb.pl][1/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:569:28: runtime error: load of value 57, which is not a valid value for type '_Bool' # ==28795==Using libbacktrace symbolizer. # #0 0x5615cf3d12e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5615cf3d136c in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5615cf640331 in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5615cf64069e in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5615cf640a78 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5615cf643978 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5615cf63a12f in BackendMain ../src/backend/tcop/backend_startup.c:101 # #7 0x5615cf4e4a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267 # #8 0x5615cf4eabb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593 # #9 0x5615cf4eb15f in ServerLoop ../src/backend/postmaster/postmaster.c:1674 # #10 0x5615cf4ecb81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372 # #11 0x5615cf317488 in main ../src/backend/main/main.c:197 # #12 0x7f790c48ad09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #13 0x5615cee85219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219) # # ' # doesn't match '(?^:statement: CREATE DATABASE foobar1)' # Running: createdb -l C -E LATIN1 -T template0 foobar2 createdb: error: query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); [12:38:16.521](0.315s) not ok 12 - createdb -l C -E LATIN1 -T template0 foobar2 exit code 0 [12:38:16.522](0.000s) # Failed test 'createdb -l C -E LATIN1 -T template0 foobar2 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 23. [12:38:16.522](0.001s) not ok 13 - create database with encoding: SQL found in server log [12:38:16.522](0.000s) # Failed test 'create database with encoding: SQL found in server log' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 23. [12:38:16.523](0.000s) # '2024-03-19 12:38:16.213 UTC [28815][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:16.213 UTC [28815][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:16.213 UTC [28815][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=020_createdb.pl # 2024-03-19 12:38:16.213 UTC [28815][client backend] [[unknown]][2/1:0] FATAL: database "postgres" does not exist # 2024-03-19 12:38:16.214 UTC [28816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:16.215 UTC [28816][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:16.215 UTC [28816][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=template1 application_name=020_createdb.pl # 2024-03-19 12:38:16.216 UTC [28816][client backend] [020_createdb.pl][3/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:569:28: runtime error: load of value 57, which is not a valid value for type '_Bool' # ==28816==Using libbacktrace symbolizer. # #0 0x5615cf3d12e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5615cf3d136c in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5615cf640331 in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5615cf64069e in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5615cf640a78 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5615cf643978 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5615cf63a12f in BackendMain ../src/backend/tcop/backend_startup.c:101 # #7 0x5615cf4e4a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267 # #8 0x5615cf4eabb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593 # #9 0x5615cf4eb15f in ServerLoop ../src/backend/postmaster/postmaster.c:1674 # #10 0x5615cf4ecb81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372 # #11 0x5615cf317488 in main ../src/backend/main/main.c:197 # #12 0x7f790c48ad09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #13 0x5615cee85219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219) # # ' # doesn't match '(?^:statement: CREATE DATABASE foobar2 ENCODING 'LATIN1')' # Running: createdb -T template0 -E UTF8 --locale-provider=icu foobar4 createdb: error: query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); [12:38:17.158](0.636s) ok 14 - create database with ICU fails without ICU locale specified # Running: createdb -T template0 -E UTF8 --locale-provider=icu --locale=C --icu-locale=en foobar5 createdb: error: query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); [12:38:17.473](0.315s) not ok 15 - createdb -T template0 -E UTF8 --locale-provider=icu --locale=C --icu-locale=en foobar5 exit code 0 [12:38:17.474](0.000s) # Failed test 'createdb -T template0 -E UTF8 --locale-provider=icu --locale=C --icu-locale=en foobar5 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 40. [12:38:17.474](0.000s) not ok 16 - create database with ICU locale specified: SQL found in server log [12:38:17.474](0.000s) # Failed test 'create database with ICU locale specified: SQL found in server log' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 40. [12:38:17.474](0.000s) # '2024-03-19 12:38:17.165 UTC [28863][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:17.166 UTC [28863][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:17.166 UTC [28863][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=020_createdb.pl # 2024-03-19 12:38:17.166 UTC [28863][client backend] [[unknown]][6/1:0] FATAL: database "postgres" does not exist # 2024-03-19 12:38:17.167 UTC [28864][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-19 12:38:17.167 UTC [28864][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_main_data/pgdata/pg_hba.conf:117) # 2024-03-19 12:38:17.167 UTC [28864][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=template1 application_name=020_createdb.pl # 2024-03-19 12:38:17.168 UTC [28864][client backend] [020_createdb.pl][7/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:569:28: runtime error: load of value 57, which is not a valid value for type '_Bool' # ==28864==Using libbacktrace symbolizer. # #0 0x5615cf3d12e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5615cf3d136c in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5615cf640331 in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5615cf64069e in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5615cf640a78 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5615cf643978 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5615cf63a12f in BackendMain ../src/backend/tcop/backend_startup.c:101 # #7 0x5615cf4e4a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267 # #8 0x5615cf4eabb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593 # #9 0x5615cf4eb15f in ServerLoop ../src/backend/postmaster/postmaster.c:1674 # #10 0x5615cf4ecb81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372 # #11 0x5615cf317488 in main ../src/backend/main/main.c:197 # #12 0x7f790c48ad09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #13 0x5615cee85219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219) # # ' # doesn't match '(?^:statement: CREATE DATABASE foobar5 .* LOCALE_PROVIDER icu ICU_LOCALE 'en')' # Running: createdb -T template0 -E UTF8 --locale-provider=icu --icu-locale=@colNumeric=lower foobarX createdb: error: query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); [12:38:17.789](0.315s) ok 17 - fails for invalid ICU locale # Running: createdb -T template0 --locale-provider=icu --encoding=SQL_ASCII foobarX [12:38:18.266](0.477s) ok 18 - fails for encoding not supported by ICU: exit code not 0 [12:38:18.266](0.000s) not ok 19 - fails for encoding not supported by ICU: matches [12:38:18.267](0.000s) # Failed test 'fails for encoding not supported by ICU: matches' # at /tmp/cirrus-ci-build/src/bin/scripts/t/020_createdb.pl line 59. [12:38:18.267](0.000s) # 'createdb: error: query failed: server closed the connection unexpectedly # This probably means the server terminated abnormally # before or while processing the request. # createdb: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false); # ' # doesn't match '(?^:ERROR: encoding "SQL_ASCII" is not supported with ICU provider)' # Checking port 65505 # Found port 65505 Name: icu Data directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/archives Connection string: port=65505 host=/tmp/ApfS3LpQHD Log file: /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/log/020_createdb_icu.log [12:38:18.269](0.003s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/pgdata -A trust -N --locale-provider=icu --icu-locale=en The files belonging to this database system will be owned by user "postgres". This user must also own the server process. Using language tag "en" for ICU locale "en". The database cluster will be initialized with this locale configuration: locale provider: icu default collation: en LC_COLLATE: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C.UTF-8 LC_TIME: C.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_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 ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ../src/backend/optimizer/plan/planner.c:569:28: runtime error: load of value 57, which is not a valid value for type '_Bool' ==28987==Using libbacktrace symbolizer. #0 0x558be23d02e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569 #1 0x558be23d036c in planner ../src/backend/optimizer/plan/planner.c:276 #2 0x558be263f331 in pg_plan_query ../src/backend/tcop/postgres.c:904 #3 0x558be263f69e in pg_plan_queries ../src/backend/tcop/postgres.c:996 #4 0x558be263fa78 in exec_simple_query ../src/backend/tcop/postgres.c:1193 #5 0x558be2642978 in PostgresMain ../src/backend/tcop/postgres.c:4680 #6 0x558be2642efd in PostgresSingleUserMain ../src/backend/tcop/postgres.c:4136 #7 0x558be2316570 in main ../src/backend/main/main.c:194 #8 0x7f9b190c9d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #9 0x558be1e84219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219) Aborted (core dumped) child process exited with exit code 134 initdb: removing data directory "/tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/pgdata" [12:38:27.484](9.215s) Bail out! command "initdb -D /tmp/cirrus-ci-build/build/testrun/scripts/020_createdb/data/t_020_createdb_icu_data/pgdata -A trust -N --locale-provider=icu --icu-locale=en" exited with value 1 # No postmaster PID for node "main" # No postmaster PID for node "icu"