# Running: createuser --help
[05:45:27.169](0.015s) ok 1 - createuser --help exit code 0
[05:45:27.169](0.000s) ok 2 - createuser --help goes to stdout
[05:45:27.170](0.000s) ok 3 - createuser --help nothing to stderr
[05:45:27.170](0.000s) ok 4 - createuser --help maximum line length
# Running: createuser --version
[05:45:27.175](0.006s) ok 5 - createuser --version exit code 0
[05:45:27.176](0.000s) ok 6 - createuser --version goes to stdout
[05:45:27.176](0.000s) ok 7 - createuser --version nothing to stderr
# Running: createuser --not-a-valid-option
[05:45:27.181](0.006s) ok 8 - createuser with invalid option nonzero exit code
[05:45:27.182](0.000s) ok 9 - createuser with invalid option prints error message
# Checking port 54571
# Found port 54571
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=54571 host=/tmp/nXA3Lncj71
Log file: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_main.log
[05:45:27.185](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 28960
# 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);
[05:45:27.643](0.458s) not ok 10 - createuser regress_user1 exit code 0
[05:45:27.643](0.000s) #   Failed test 'createuser regress_user1 exit code 0'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 19.
[05:45:27.644](0.000s) not ok 11 - SQL CREATE USER run: SQL found in server log
[05:45:27.644](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.
[05:45:27.644](0.000s) #                   '2024-03-09 05:45:27.335 UTC [28976][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:27.336 UTC [28976][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-09 05:45:27.336 UTC [28976][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:27.336 UTC [28976][client backend] [[unknown]][0/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:27.337 UTC [28977][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:27.338 UTC [28977][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-09 05:45:27.338 UTC [28977][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:27.338 UTC [28977][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 83, which is not a valid value for type '_Bool'
# ==28977==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:28.279](0.635s) not ok 12 - createuser -L regress_role1 exit code 0
[05:45:28.279](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.
[05:45:28.280](0.000s) not ok 13 - create a non-login role: SQL found in server log
[05:45:28.280](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.
[05:45:28.280](0.000s) #                   '2024-03-09 05:45:27.650 UTC [29000][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:27.651 UTC [29000][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-09 05:45:27.651 UTC [29000][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:27.651 UTC [29000][client backend] [[unknown]][2/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:27.652 UTC [29001][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:27.652 UTC [29001][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-09 05:45:27.652 UTC [29001][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:27.653 UTC [29001][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 83, which is not a valid value for type '_Bool'
# ==29001==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:28.915](0.635s) not ok 14 - createuser -r regress user2 exit code 0
[05:45:28.916](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.
[05:45:28.916](0.000s) not ok 15 - create a CREATEROLE user: SQL found in server log
[05:45:28.916](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.
[05:45:28.916](0.000s) #                   '2024-03-09 05:45:28.286 UTC [29042][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:28.287 UTC [29042][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-09 05:45:28.287 UTC [29042][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:28.287 UTC [29042][client backend] [[unknown]][4/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:28.287 UTC [29043][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:28.288 UTC [29043][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-09 05:45:28.288 UTC [29043][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:28.289 UTC [29043][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 83, which is not a valid value for type '_Bool'
# ==29043==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:30.053](1.136s) not ok 16 - createuser -s regress_user3 exit code 0
[05:45:30.053](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.
[05:45:30.053](0.000s) not ok 17 - create a superuser: SQL found in server log
[05:45:30.053](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.
[05:45:30.053](0.000s) #                   '2024-03-09 05:45:28.922 UTC [29080][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:28.922 UTC [29080][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-09 05:45:28.922 UTC [29080][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:28.922 UTC [29080][client backend] [[unknown]][6/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:28.924 UTC [29083][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:28.924 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-09 05:45:28.924 UTC [29083][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:28.925 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 83, which is not a valid value for type '_Bool'
# ==29083==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:31.191](1.137s) not ok 18 - createuser -a regress_user1 -a regress user2 regress user \#4 exit code 0
[05:45:31.191](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.
[05:45:31.191](0.000s) not ok 19 - add a role as a member with admin option of the newly created role: SQL found in server log
[05:45:31.192](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.
[05:45:31.192](0.000s) #                   '2024-03-09 05:45:30.059 UTC [29203][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:30.060 UTC [29203][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-09 05:45:30.060 UTC [29203][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:30.060 UTC [29203][client backend] [[unknown]][8/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:30.060 UTC [29204][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:30.061 UTC [29204][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-09 05:45:30.061 UTC [29204][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:30.062 UTC [29204][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 83, which is not a valid value for type '_Bool'
# ==29204==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:32.328](1.136s) not ok 20 - createuser REGRESS_USER5 -m regress_user3 -m regress user \#4 exit code 0
[05:45:32.328](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.
[05:45:32.329](0.000s) not ok 21 - add a role as a member of the newly created role: SQL found in server log
[05:45:32.329](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.
[05:45:32.329](0.000s) #                   '2024-03-09 05:45:31.198 UTC [29313][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:31.199 UTC [29313][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-09 05:45:31.199 UTC [29313][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:31.199 UTC [29313][client backend] [[unknown]][10/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:31.200 UTC [29316][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:31.201 UTC [29316][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-09 05:45:31.201 UTC [29316][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:31.201 UTC [29316][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 83, which is not a valid value for type '_Bool'
# ==29316==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# '
#     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);
[05:45:33.465](1.136s) not ok 22 - createuser -v 2029 12 31 regress_user6 exit code 0
[05:45:33.465](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.
[05:45:33.465](0.000s) not ok 23 - create a role with a password expiration date: SQL found in server log
[05:45:33.465](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.
[05:45:33.465](0.000s) #                   '2024-03-09 05:45:32.335 UTC [29395][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:32.336 UTC [29395][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-09 05:45:32.336 UTC [29395][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=040_createuser.pl
# 2024-03-09 05:45:32.336 UTC [29395][client backend] [[unknown]][12/1:0] FATAL:  database "postgres" does not exist
# 2024-03-09 05:45:32.336 UTC [29396][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:32.337 UTC [29396][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-09 05:45:32.337 UTC [29396][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=template1 application_name=040_createuser.pl
# 2024-03-09 05:45:32.338 UTC [29396][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 83, which is not a valid value for type '_Bool'
# ==29396==Using libbacktrace symbolizer.
#     #0 0x5592bc23972f in standard_planner ../src/backend/optimizer/plan/planner.c:569
#     #1 0x5592bc2397bb in planner ../src/backend/optimizer/plan/planner.c:276
#     #2 0x5592bc4a7cd3 in pg_plan_query ../src/backend/tcop/postgres.c:903
#     #3 0x5592bc4a8040 in pg_plan_queries ../src/backend/tcop/postgres.c:995
#     #4 0x5592bc4a841a in exec_simple_query ../src/backend/tcop/postgres.c:1192
#     #5 0x5592bc4ab31a in PostgresMain ../src/backend/tcop/postgres.c:4675
#     #6 0x5592bc34e754 in BackendRun ../src/backend/postmaster/postmaster.c:4475
#     #7 0x5592bc35403c in BackendStartup ../src/backend/postmaster/postmaster.c:4151
#     #8 0x5592bc3543b9 in ServerLoop ../src/backend/postmaster/postmaster.c:1769
#     #9 0x5592bc355e4b in PostmasterMain ../src/backend/postmaster/postmaster.c:1468
#     #10 0x5592bc17fa3b in main ../src/backend/main/main.c:197
#     #11 0x7facb1807d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09)
#     #12 0x5592bbcef219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219)
# 
# 2024-03-09 05:45:33.139 UTC [28960][postmaster] LOG:  server process (PID 29001) was terminated by signal 6: Aborted
# 2024-03-09 05:45:33.139 UTC [28960][postmaster] DETAIL:  Failed process was running: SELECT pg_catalog.set_config('search_path', '', false);
# 2024-03-09 05:45:33.139 UTC [28960][postmaster] LOG:  terminating any other active server processes
# '
#     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: connection to server on socket "/tmp/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.478](0.012s) not ok 24 - createuser --bypassrls regress_user7 exit code 0
[05:45:33.478](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.
[05:45:33.478](0.000s) not ok 25 - create a BYPASSRLS role: SQL found in server log
[05:45:33.478](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.
[05:45:33.478](0.000s) #                   '2024-03-09 05:45:33.471 UTC [29467][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.471 UTC [29467][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.472 UTC [29468][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.472 UTC [29468][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# '
#     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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.490](0.012s) not ok 26 - createuser --no-bypassrls regress_user8 exit code 0
[05:45:33.491](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.
[05:45:33.491](0.000s) not ok 27 - create a role without BYPASSRLS: SQL found in server log
[05:45:33.491](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.
[05:45:33.491](0.000s) #                   '2024-03-09 05:45:33.484 UTC [29470][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.484 UTC [29470][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.484 UTC [29471][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.485 UTC [29471][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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.503](0.012s) not ok 28 - createuser --with-admin regress_user1 regress_user9 exit code 0
[05:45:33.503](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.
[05:45:33.504](0.000s) not ok 29 - --with-admin: SQL found in server log
[05:45:33.504](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.
[05:45:33.504](0.000s) #                   '2024-03-09 05:45:33.496 UTC [29473][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.496 UTC [29473][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.497 UTC [29474][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.497 UTC [29474][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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.516](0.012s) not ok 30 - createuser --with-member regress_user1 regress_user10 exit code 0
[05:45:33.516](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.
[05:45:33.517](0.000s) not ok 31 - --with-member: SQL found in server log
[05:45:33.517](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.
[05:45:33.517](0.000s) #                   '2024-03-09 05:45:33.510 UTC [29476][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.510 UTC [29476][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.510 UTC [29477][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.510 UTC [29477][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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.529](0.012s) not ok 32 - createuser --role regress_user1 regress_user11 exit code 0
[05:45:33.529](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.
[05:45:33.530](0.000s) not ok 33 - --role: SQL found in server log
[05:45:33.530](0.000s) #   Failed test '--role: SQL found in server log'
#   at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 70.
[05:45:33.530](0.000s) #                   '2024-03-09 05:45:33.523 UTC [29479][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.523 UTC [29479][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.523 UTC [29480][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.523 UTC [29480][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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.542](0.012s) not ok 34 - createuser regress_user12 --member-of regress_user1 exit code 0
[05:45:33.542](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.
[05:45:33.542](0.000s) not ok 35 - --member-of: SQL found in server log
[05:45:33.543](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.
[05:45:33.543](0.000s) #                   '2024-03-09 05:45:33.536 UTC [29482][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.536 UTC [29482][client backend] [[unknown]][:0] FATAL:  the database system is in recovery mode
# 2024-03-09 05:45:33.536 UTC [29483][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
# 2024-03-09 05:45:33.536 UTC [29483][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/nXA3Lncj71/.s.PGSQL.54571" failed: FATAL:  the database system is in recovery mode
[05:45:33.555](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.
[05:45:33.567](0.012s) ok 37 - fails for too many non-options
[05:45:33.567](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"
[05:45:38.477](4.910s) # Looks like you failed 26 tests of 37.