# Running: createuser --help
[12:42:15.612](0.014s) ok 1 - createuser --help exit code 0
[12:42:15.612](0.000s) ok 2 - createuser --help goes to stdout
[12:42:15.612](0.000s) ok 3 - createuser --help nothing to stderr
[12:42:15.612](0.000s) ok 4 - createuser --help maximum line length
# Running: createuser --version
[12:42:15.617](0.005s) ok 5 - createuser --version exit code 0
[12:42:15.617](0.000s) ok 6 - createuser --version goes to stdout
[12:42:15.617](0.000s) ok 7 - createuser --version nothing to stderr
# Running: createuser --not-a-valid-option
[12:42:15.622](0.004s) ok 8 - createuser with invalid option nonzero exit code
[12:42:15.622](0.000s) ok 9 - createuser with invalid option prints error message
# Checking port 51324
# Found port 51324
Name: main
Data directory: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/archives
Connection string: port=51324 host=/tmp/HskZ3D4H4D
Log file: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_main.log
[12:42:15.625](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/040_createuser/data/t_040_createuser_main_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata
### Starting node "main"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_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 29529
# Running: createuser regress_user1
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:16.077](0.453s) not ok 10 - createuser regress_user1 exit code 0
[12:42:16.078](0.000s) #   Failed test 'createuser regress_user1 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 19.
[12:42:16.078](0.000s) not ok 11 - SQL CREATE USER run: SQL found in server log
[12:42:16.078](0.000s) #   Failed test 'SQL CREATE USER run: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 19.
[12:42:16.078](0.000s) #                   '2024-03-17 12:42:15.769 UTC [29545][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:15.770 UTC [29545][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:15.770 UTC [29545][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:15.770 UTC [29545][client backend] [[unknown]][0/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:15.771 UTC [29546][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:15.771 UTC [29546][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:15.771 UTC [29546][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:15.772 UTC [29546][client backend] [040_createuser.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 150, which is not a valid value for type '_Bool'
# ==29546==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user1 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS;)'
# Running: createuser -L regress_role1
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:16.714](0.636s) not ok 12 - createuser -L regress_role1 exit code 0
[12:42:16.714](0.000s) #   Failed test 'createuser -L regress_role1 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 23.
[12:42:16.715](0.000s) not ok 13 - create a non-login role: SQL found in server log
[12:42:16.715](0.000s) #   Failed test 'create a non-login role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 23.
[12:42:16.715](0.000s) #                   '2024-03-17 12:42:16.084 UTC [29569][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:16.085 UTC [29569][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:16.085 UTC [29569][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:16.085 UTC [29569][client backend] [[unknown]][2/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:16.086 UTC [29570][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:16.086 UTC [29570][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:16.086 UTC [29570][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:16.087 UTC [29570][client backend] [040_createuser.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 150, which is not a valid value for type '_Bool'
# ==29570==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_role1 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT NOLOGIN NOREPLICATION NOBYPASSRLS;)'
# Running: createuser -r regress user2
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:17.350](0.635s) not ok 14 - createuser -r regress user2 exit code 0
[12:42:17.350](0.000s) #   Failed test 'createuser -r regress user2 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 27.
[12:42:17.351](0.000s) not ok 15 - create a CREATEROLE user: SQL found in server log
[12:42:17.351](0.000s) #   Failed test 'create a CREATEROLE user: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 27.
[12:42:17.351](0.000s) #                   '2024-03-17 12:42:16.721 UTC [29603][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:16.722 UTC [29603][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:16.722 UTC [29603][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:16.722 UTC [29603][client backend] [[unknown]][4/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:16.723 UTC [29604][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:16.723 UTC [29604][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:16.723 UTC [29604][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:16.724 UTC [29604][client backend] [040_createuser.pl][5/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 150, which is not a valid value for type '_Bool'
# ==29604==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE "regress user2" NOSUPERUSER NOCREATEDB CREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS;)'
# Running: createuser -s regress_user3
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:18.487](1.136s) not ok 16 - createuser -s regress_user3 exit code 0
[12:42:18.487](0.000s) #   Failed test 'createuser -s regress_user3 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 31.
[12:42:18.487](0.000s) not ok 17 - create a superuser: SQL found in server log
[12:42:18.487](0.000s) #   Failed test 'create a superuser: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 31.
[12:42:18.488](0.000s) #                   '2024-03-17 12:42:17.356 UTC [29645][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:17.356 UTC [29645][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:17.356 UTC [29645][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:17.357 UTC [29645][client backend] [[unknown]][6/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:17.357 UTC [29646][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:17.358 UTC [29646][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:17.358 UTC [29646][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:17.358 UTC [29646][client backend] [040_createuser.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 150, which is not a valid value for type '_Bool'
# ==29646==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user3 SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS;)'
# Running: createuser -a regress_user1 -a regress user2 regress user #4
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:19.624](1.136s) not ok 18 - createuser -a regress_user1 -a regress user2 regress user \#4 exit code 0
[12:42:19.624](0.000s) #   Failed test 'createuser -a regress_user1 -a regress user2 regress user #4 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 35.
[12:42:19.624](0.000s) not ok 19 - add a role as a member with admin option of the newly created role: SQL found in server log
[12:42:19.624](0.000s) #   Failed test 'add a role as a member with admin option of the newly created role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 35.
[12:42:19.624](0.000s) #                   '2024-03-17 12:42:18.494 UTC [29741][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:18.494 UTC [29741][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:18.494 UTC [29741][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:18.494 UTC [29741][client backend] [[unknown]][8/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:18.495 UTC [29742][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:18.496 UTC [29742][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:18.496 UTC [29742][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:18.497 UTC [29742][client backend] [040_createuser.pl][9/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 150, which is not a valid value for type '_Bool'
# ==29742==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE "regress user #4" NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS ADMIN regress_user1,"regress user2";)'
# Running: createuser REGRESS_USER5 -m regress_user3 -m regress user #4
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:20.760](1.136s) not ok 20 - createuser REGRESS_USER5 -m regress_user3 -m regress user \#4 exit code 0
[12:42:20.760](0.000s) #   Failed test 'createuser REGRESS_USER5 -m regress_user3 -m regress user #4 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 43.
[12:42:20.761](0.000s) not ok 21 - add a role as a member of the newly created role: SQL found in server log
[12:42:20.761](0.000s) #   Failed test 'add a role as a member of the newly created role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 43.
[12:42:20.761](0.000s) #                   '2024-03-17 12:42:19.631 UTC [29874][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:19.631 UTC [29874][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:19.631 UTC [29874][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:19.631 UTC [29874][client backend] [[unknown]][10/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:19.632 UTC [29875][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:19.632 UTC [29875][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:19.632 UTC [29875][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:19.633 UTC [29875][client backend] [040_createuser.pl][11/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 150, which is not a valid value for type '_Bool'
# ==29875==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE "REGRESS_USER5" NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS ROLE regress_user3,"regress user #4";)'
# Running: createuser -v 2029 12 31 regress_user6
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:22.398](1.637s) not ok 22 - createuser -v 2029 12 31 regress_user6 exit code 0
[12:42:22.398](0.000s) #   Failed test 'createuser -v 2029 12 31 regress_user6 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 50.
[12:42:22.398](0.000s) not ok 23 - create a role with a password expiration date: SQL found in server log
[12:42:22.398](0.000s) #   Failed test 'create a role with a password expiration date: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 50.
[12:42:22.399](0.000s) #                   '2024-03-17 12:42:20.766 UTC [29990][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:20.767 UTC [29990][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:20.767 UTC [29990][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:20.767 UTC [29990][client backend] [[unknown]][12/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:20.768 UTC [29991][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:20.768 UTC [29991][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:20.768 UTC [29991][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:20.769 UTC [29991][client backend] [040_createuser.pl][13/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 150, which is not a valid value for type '_Bool'
# ==29991==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user6 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS VALID UNTIL \'2029 12 31\';)'
# Running: createuser --bypassrls regress_user7
createuser: error: query failed: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
createuser: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);
[12:42:23.534](1.136s) not ok 24 - createuser --bypassrls regress_user7 exit code 0
[12:42:23.535](0.000s) #   Failed test 'createuser --bypassrls regress_user7 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 54.
[12:42:23.535](0.000s) not ok 25 - create a BYPASSRLS role: SQL found in server log
[12:42:23.535](0.000s) #   Failed test 'create a BYPASSRLS role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 54.
[12:42:23.535](0.000s) #                   '2024-03-17 12:42:22.404 UTC [30119][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:22.404 UTC [30119][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:22.404 UTC [30119][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-17 12:42:22.404 UTC [30119][client backend] [[unknown]][14/1:0] FATAL:  database "postgres" does not exist
# 2024-03-17 12:42:22.405 UTC [30120][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:22.405 UTC [30120][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata/pg_hba.conf:117)
# 2024-03-17 12:42:22.405 UTC [30120][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-17 12:42:22.406 UTC [30120][client backend] [040_createuser.pl][15/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 150, which is not a valid value for type '_Bool'
# ==30120==Using libbacktrace symbolizer.
#     #0 0x560eb92d78c0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x560eb92d794c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x560eb9545f9e in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x560eb954630b in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x560eb95466e5 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x560eb95495e5 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x560eb93ec91b in BackendRun ../src/backend/postmaster/postmaster.c:4452
#     #7 0x560eb93f2160 in BackendStartup ../src/backend/postmaster/postmaster.c:4117
#     #8 0x560eb93f2579 in ServerLoop ../src/backend/postmaster/postmaster.c:1780
#     #9 0x560eb93f3f93 in PostmasterMain ../src/backend/postmaster/postmaster.c:1478
#     #10 0x560eb921db2c in main ../src/backend/main/main.c:197
#     #11 0x7f8649c52d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x560eb8d8c219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b6219)
# 
# 2024-03-17 12:42:22.497 UTC [29529][postmaster] LOG:  server process (PID 29570) was terminated by signal 6: Aborted
# 2024-03-17 12:42:22.497 UTC [29529][postmaster] DETAIL:  Failed process was running: SELECT pg_catalog.set_config('search_path', '', false);
# 2024-03-17 12:42:22.497 UTC [29529][postmaster] LOG:  terminating any other active server processes
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user7 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION BYPASSRLS;)'
# Running: createuser --no-bypassrls regress_user8
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.548](0.012s) not ok 26 - createuser --no-bypassrls regress_user8 exit code 0
[12:42:23.548](0.000s) #   Failed test 'createuser --no-bypassrls regress_user8 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 58.
[12:42:23.548](0.000s) not ok 27 - create a role without BYPASSRLS: SQL found in server log
[12:42:23.548](0.000s) #   Failed test 'create a role without BYPASSRLS: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 58.
[12:42:23.548](0.000s) #                   '2024-03-17 12:42:23.541 UTC [30182][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.541 UTC [30182][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-17 12:42:23.542 UTC [30183][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.542 UTC [30183][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user8 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS;)'
# Running: createuser --with-admin regress_user1 regress_user9
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.561](0.012s) not ok 28 - createuser --with-admin regress_user1 regress_user9 exit code 0
[12:42:23.561](0.000s) #   Failed test 'createuser --with-admin regress_user1 regress_user9 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 62.
[12:42:23.561](0.000s) not ok 29 - --with-admin: SQL found in server log
[12:42:23.562](0.000s) #   Failed test '--with-admin: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 62.
[12:42:23.562](0.000s) #                   '2024-03-17 12:42:23.554 UTC [30185][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.554 UTC [30185][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-17 12:42:23.554 UTC [30186][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.554 UTC [30186][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user9 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS ADMIN regress_user1;)'
# Running: createuser --with-member regress_user1 regress_user10
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.574](0.012s) not ok 30 - createuser --with-member regress_user1 regress_user10 exit code 0
[12:42:23.574](0.000s) #   Failed test 'createuser --with-member regress_user1 regress_user10 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 66.
[12:42:23.574](0.000s) not ok 31 - --with-member: SQL found in server log
[12:42:23.574](0.000s) #   Failed test '--with-member: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 66.
[12:42:23.574](0.000s) #                   '2024-03-17 12:42:23.566 UTC [30188][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.566 UTC [30188][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-17 12:42:23.567 UTC [30189][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.567 UTC [30189][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user10 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS ROLE regress_user1;)'
# Running: createuser --role regress_user1 regress_user11
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.586](0.012s) not ok 32 - createuser --role regress_user1 regress_user11 exit code 0
[12:42:23.586](0.000s) #   Failed test 'createuser --role regress_user1 regress_user11 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 70.
[12:42:23.587](0.000s) not ok 33 - --role: SQL found in server log
[12:42:23.587](0.000s) #   Failed test '--role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 70.
[12:42:23.587](0.000s) #                   '2024-03-17 12:42:23.580 UTC [30194][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.580 UTC [30194][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-17 12:42:23.581 UTC [30195][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.581 UTC [30195][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user11 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS IN ROLE regress_user1;)'
# Running: createuser regress_user12 --member-of regress_user1
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.599](0.012s) not ok 34 - createuser regress_user12 --member-of regress_user1 exit code 0
[12:42:23.599](0.000s) #   Failed test 'createuser regress_user12 --member-of regress_user1 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 74.
[12:42:23.599](0.000s) not ok 35 - --member-of: SQL found in server log
[12:42:23.599](0.000s) #   Failed test '--member-of: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 74.
[12:42:23.599](0.000s) #                   '2024-03-17 12:42:23.592 UTC [30200][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.592 UTC [30200][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-17 12:42:23.592 UTC [30201][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-17 12:42:23.592 UTC [30201][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user12 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION NOBYPASSRLS IN ROLE regress_user1;)'
# Running: createuser regress_user1
createuser: error: connection to server on socket "/tmp/HskZ3D4H4D/.s.PGSQL.51324" failed: FATAL:  the database system is in recovery mode
[12:42:23.611](0.012s) ok 36 - fails if role already exists
# Running: createuser regress_user1 -m regress_user2 regress_user3
createuser: error: too many command-line arguments (first is "regress_user3")
createuser: hint: Try "createuser --help" for more information.
[12:42:23.623](0.012s) ok 37 - fails for too many non-options
[12:42:23.624](0.000s) 1..37
### Stopping node "main" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/data/t_040_createuser_main_data/pgdata -m immediate stop
waiting for server to shut down....... done
server stopped
# No postmaster PID for node "main"
[12:42:27.330](3.707s) # Looks like you failed 26 tests of 37.