# Running: createuser --help
[12:38:17.285](0.016s) ok 1 - createuser --help exit code 0
[12:38:17.285](0.000s) ok 2 - createuser --help goes to stdout
[12:38:17.285](0.000s) ok 3 - createuser --help nothing to stderr
[12:38:17.285](0.000s) ok 4 - createuser --help maximum line length
# Running: createuser --version
[12:38:17.292](0.007s) ok 5 - createuser --version exit code 0
[12:38:17.293](0.000s) ok 6 - createuser --version goes to stdout
[12:38:17.293](0.000s) ok 7 - createuser --version nothing to stderr
# Running: createuser --not-a-valid-option
[12:38:17.299](0.006s) ok 8 - createuser with invalid option nonzero exit code
[12:38:17.299](0.000s) ok 9 - createuser with invalid option prints error message
# Checking port 57456
# Found port 57456
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=57456 host=/tmp/rRN8gVbcZw
Log file: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_main.log
[12:38:17.303](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 28888
# 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:38:18.084](0.781s) not ok 10 - createuser regress_user1 exit code 0
[12:38:18.084](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:38:18.085](0.000s) not ok 11 - SQL CREATE USER run: SQL found in server log
[12:38:18.085](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:38:18.085](0.000s) #                   '2024-03-19 12:38:17.454 UTC [28904][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:17.455 UTC [28904][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-19 12:38:17.455 UTC [28904][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:17.455 UTC [28904][client backend] [[unknown]][0/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:17.456 UTC [28905][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:17.457 UTC [28905][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-19 12:38:17.457 UTC [28905][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:17.705 UTC [28905][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 57, which is not a valid value for type '_Bool'
# ==28905==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:18.720](0.635s) not ok 12 - createuser -L regress_role1 exit code 0
[12:38:18.720](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:38:18.721](0.000s) not ok 13 - create a non-login role: SQL found in server log
[12:38:18.721](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:38:18.721](0.000s) #                   '2024-03-19 12:38:18.091 UTC [28949][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:18.092 UTC [28949][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-19 12:38:18.092 UTC [28949][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:18.092 UTC [28949][client backend] [[unknown]][2/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:18.093 UTC [28950][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:18.093 UTC [28950][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-19 12:38:18.093 UTC [28950][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:18.094 UTC [28950][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 57, which is not a valid value for type '_Bool'
# ==28950==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:19.356](0.635s) not ok 14 - createuser -r regress user2 exit code 0
[12:38:19.356](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:38:19.357](0.000s) not ok 15 - create a CREATEROLE user: SQL found in server log
[12:38:19.357](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:38:19.357](0.000s) #                   '2024-03-19 12:38:18.727 UTC [29015][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:18.727 UTC [29015][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-19 12:38:18.727 UTC [29015][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:18.727 UTC [29015][client backend] [[unknown]][4/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:18.728 UTC [29016][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:18.728 UTC [29016][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-19 12:38:18.728 UTC [29016][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:18.729 UTC [29016][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 57, which is not a valid value for type '_Bool'
# ==29016==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:19.992](0.635s) not ok 16 - createuser -s regress_user3 exit code 0
[12:38:19.992](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:38:19.993](0.000s) not ok 17 - create a superuser: SQL found in server log
[12:38:19.993](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:38:19.993](0.000s) #                   '2024-03-19 12:38:19.363 UTC [29082][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:19.363 UTC [29082][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-19 12:38:19.363 UTC [29082][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:19.363 UTC [29082][client backend] [[unknown]][6/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:19.364 UTC [29083][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:19.365 UTC [29083][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-19 12:38:19.365 UTC [29083][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:19.365 UTC [29083][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 57, which is not a valid value for type '_Bool'
# ==29083==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:21.129](1.136s) not ok 18 - createuser -a regress_user1 -a regress user2 regress user \#4 exit code 0
[12:38:21.129](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:38:21.130](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:38:21.130](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:38:21.130](0.000s) #                   '2024-03-19 12:38:19.999 UTC [29144][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:20.000 UTC [29144][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-19 12:38:20.000 UTC [29144][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:20.000 UTC [29144][client backend] [[unknown]][8/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:20.003 UTC [29146][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:20.003 UTC [29146][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-19 12:38:20.003 UTC [29146][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:20.004 UTC [29146][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 57, which is not a valid value for type '_Bool'
# ==29146==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:21.765](0.635s) not ok 20 - createuser REGRESS_USER5 -m regress_user3 -m regress user \#4 exit code 0
[12:38:21.997](0.232s) #   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:38:22.213](0.217s) not ok 21 - add a role as a member of the newly created role: SQL found in server log
[12:38:22.214](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:38:22.214](0.000s) #                   '2024-03-19 12:38:21.135 UTC [29265][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:21.136 UTC [29265][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-19 12:38:21.136 UTC [29265][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:21.136 UTC [29265][client backend] [[unknown]][10/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:21.136 UTC [29267][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:21.137 UTC [29267][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-19 12:38:21.137 UTC [29267][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:21.138 UTC [29267][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 57, which is not a valid value for type '_Bool'
# ==29267==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:23.350](1.136s) not ok 22 - createuser -v 2029 12 31 regress_user6 exit code 0
[12:38:23.350](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:38:23.350](0.000s) not ok 23 - create a role with a password expiration date: SQL found in server log
[12:38:23.350](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:38:23.350](0.000s) #                   '2024-03-19 12:38:22.220 UTC [29360][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:22.220 UTC [29360][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-19 12:38:22.220 UTC [29360][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:22.220 UTC [29360][client backend] [[unknown]][12/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:22.221 UTC [29361][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:22.221 UTC [29361][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-19 12:38:22.221 UTC [29361][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:22.222 UTC [29361][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 57, which is not a valid value for type '_Bool'
# ==29361==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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:38:23.985](0.635s) not ok 24 - createuser --bypassrls regress_user7 exit code 0
[12:38:23.986](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:38:23.986](0.000s) not ok 25 - create a BYPASSRLS role: SQL found in server log
[12:38:23.986](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:38:23.986](0.000s) #                   '2024-03-19 12:38:23.356 UTC [29430][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:23.356 UTC [29430][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-19 12:38:23.356 UTC [29430][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:23.356 UTC [29430][client backend] [[unknown]][14/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:23.357 UTC [29431][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:23.357 UTC [29431][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-19 12:38:23.357 UTC [29431][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:23.358 UTC [29431][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 57, which is not a valid value for type '_Bool'
# ==29431==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     doesn't match '(?^:statement: CREATE ROLE regress_user7 NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN NOREPLICATION BYPASSRLS;)'
# Running: createuser --no-bypassrls regress_user8
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:38:24.621](0.635s) not ok 26 - createuser --no-bypassrls regress_user8 exit code 0
[12:38:24.622](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:38:24.622](0.000s) not ok 27 - create a role without BYPASSRLS: SQL found in server log
[12:38:24.622](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:38:24.622](0.000s) #                   '2024-03-19 12:38:23.991 UTC [29469][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:23.992 UTC [29469][client backend] [[unknown]][16/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-19 12:38:23.992 UTC [29469][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:23.992 UTC [29469][client backend] [[unknown]][16/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:23.993 UTC [29470][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:23.993 UTC [29470][client backend] [[unknown]][17/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-19 12:38:23.993 UTC [29470][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:23.994 UTC [29470][client backend] [040_createuser.pl][17/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'
# ==29470==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# '
#     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: 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:38:25.257](0.635s) not ok 28 - createuser --with-admin regress_user1 regress_user9 exit code 0
[12:38:25.258](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:38:25.258](0.000s) not ok 29 - --with-admin: SQL found in server log
[12:38:25.258](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:38:25.258](0.000s) #                   '2024-03-19 12:38:24.628 UTC [29508][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:24.628 UTC [29508][client backend] [[unknown]][18/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-19 12:38:24.628 UTC [29508][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-19 12:38:24.628 UTC [29508][client backend] [[unknown]][18/1:0] FATAL:  database "postgres" does not exist
# 2024-03-19 12:38:24.629 UTC [29509][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:24.629 UTC [29509][client backend] [[unknown]][19/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-19 12:38:24.629 UTC [29509][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-19 12:38:24.630 UTC [29509][client backend] [040_createuser.pl][19/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'
# ==29509==Using libbacktrace symbolizer.
#     #0 0x555a34f4f2e0 in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x555a34f4f36c in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x555a351be331 in pg_plan_query ../src/backend/tcop/postgres.c:904
#     #3 0x555a351be69e in pg_plan_queries ../src/backend/tcop/postgres.c:996
#     #4 0x555a351bea78 in exec_simple_query ../src/backend/tcop/postgres.c:1193
#     #5 0x555a351c1978 in PostgresMain ../src/backend/tcop/postgres.c:4680
#     #6 0x555a351b812f in BackendMain ../src/backend/tcop/backend_startup.c:101
#     #7 0x555a35062a31 in postmaster_child_launch ../src/backend/postmaster/launch_backend.c:267
#     #8 0x555a35068bb1 in BackendStartup ../src/backend/postmaster/postmaster.c:3593
#     #9 0x555a3506915f in ServerLoop ../src/backend/postmaster/postmaster.c:1674
#     #10 0x555a3506ab81 in PostmasterMain ../src/backend/postmaster/postmaster.c:1372
#     #11 0x555a34e95488 in main ../src/backend/main/main.c:197
#     #12 0x7ff826438d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #13 0x555a34a03219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b8219)
# 
# 2024-03-19 12:38:24.969 UTC [28888][postmaster] LOG:  server process (PID 28905) was terminated by signal 6: Aborted
# 2024-03-19 12:38:24.969 UTC [28888][postmaster] DETAIL:  Failed process was running: SELECT pg_catalog.set_config('search_path', '', false);
# 2024-03-19 12:38:24.969 UTC [28888][postmaster] LOG:  terminating any other active server processes
# '
#     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/rRN8gVbcZw/.s.PGSQL.57456" failed: FATAL:  the database system is in recovery mode
[12:38:25.271](0.012s) not ok 30 - createuser --with-member regress_user1 regress_user10 exit code 0
[12:38:25.271](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:38:25.271](0.000s) not ok 31 - --with-member: SQL found in server log
[12:38:25.271](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:38:25.271](0.000s) #                   '2024-03-19 12:38:25.264 UTC [29547][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.264 UTC [29547][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-19 12:38:25.264 UTC [29548][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.264 UTC [29548][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/rRN8gVbcZw/.s.PGSQL.57456" failed: FATAL:  the database system is in recovery mode
[12:38:25.284](0.013s) not ok 32 - createuser --role regress_user1 regress_user11 exit code 0
[12:38:25.284](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:38:25.284](0.000s) not ok 33 - --role: SQL found in server log
[12:38:25.284](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:38:25.285](0.000s) #                   '2024-03-19 12:38:25.276 UTC [29550][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.276 UTC [29550][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-19 12:38:25.276 UTC [29551][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.276 UTC [29551][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/rRN8gVbcZw/.s.PGSQL.57456" failed: FATAL:  the database system is in recovery mode
[12:38:25.296](0.012s) not ok 34 - createuser regress_user12 --member-of regress_user1 exit code 0
[12:38:25.297](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:38:25.297](0.000s) not ok 35 - --member-of: SQL found in server log
[12:38:25.297](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:38:25.297](0.000s) #                   '2024-03-19 12:38:25.289 UTC [29553][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.289 UTC [29553][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-19 12:38:25.290 UTC [29554][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-19 12:38:25.290 UTC [29554][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/rRN8gVbcZw/.s.PGSQL.57456" failed: FATAL:  the database system is in recovery mode
[12:38:25.309](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:38:25.321](0.012s) ok 37 - fails for too many non-options
[12:38:25.321](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:38:30.029](4.708s) # Looks like you failed 26 tests of 37.