# Running: createuser --help [14:01:12.228](0.015s) ok 1 - createuser --help exit code 0 [14:01:12.228](0.000s) ok 2 - createuser --help goes to stdout [14:01:12.228](0.000s) ok 3 - createuser --help nothing to stderr [14:01:12.228](0.000s) ok 4 - createuser --help maximum line length # Running: createuser --version [14:01:12.233](0.005s) ok 5 - createuser --version exit code 0 [14:01:12.233](0.000s) ok 6 - createuser --version goes to stdout [14:01:12.233](0.000s) ok 7 - createuser --version nothing to stderr # Running: createuser --not-a-valid-option [14:01:12.238](0.004s) ok 8 - createuser with invalid option nonzero exit code [14:01:12.238](0.000s) ok 9 - createuser with invalid option prints error message # Checking port 51049 # Found port 51049 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=51049 host=/tmp/0Y4iSH6rAA Log file: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_main.log [14:01:12.241](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 28474 # 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); [14:01:13.049](0.809s) not ok 10 - createuser regress_user1 exit code 0 [14:01:13.050](0.000s) # Failed test 'createuser regress_user1 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 19. [14:01:13.050](0.000s) not ok 11 - SQL CREATE USER run: SQL found in server log [14:01:13.050](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. [14:01:13.050](0.000s) # '2024-03-15 14:01:12.420 UTC [28488][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:12.421 UTC [28488][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-15 14:01:12.421 UTC [28488][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-03-15 14:01:12.421 UTC [28488][client backend] [[unknown]][0/1:0] FATAL: database "postgres" does not exist # 2024-03-15 14:01:12.422 UTC [28489][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:12.423 UTC [28489][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-15 14:01:12.423 UTC [28489][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-03-15 14:01:12.423 UTC [28489][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 53, which is not a valid value for type '_Bool' # ==28489==Using libbacktrace symbolizer. # #0 0x5651b72410a9 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5651b7241135 in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5651b74af71e in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5651b74afa8b in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5651b74afe65 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5651b74b2d65 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5651b7356104 in BackendRun ../src/backend/postmaster/postmaster.c:4452 # #7 0x5651b735b949 in BackendStartup ../src/backend/postmaster/postmaster.c:4117 # #8 0x5651b735bd62 in ServerLoop ../src/backend/postmaster/postmaster.c:1780 # #9 0x5651b735d77c in PostmasterMain ../src/backend/postmaster/postmaster.c:1478 # #10 0x5651b7187315 in main ../src/backend/main/main.c:197 # #11 0x7fdc1f071d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x5651b6cf6219 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); [14:01:14.187](1.137s) not ok 12 - createuser -L regress_role1 exit code 0 [14:01:14.188](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. [14:01:14.188](0.000s) not ok 13 - create a non-login role: SQL found in server log [14:01:14.188](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. [14:01:14.188](0.000s) # '2024-03-15 14:01:13.058 UTC [28538][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:13.058 UTC [28538][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-15 14:01:13.058 UTC [28538][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-03-15 14:01:13.058 UTC [28538][client backend] [[unknown]][2/1:0] FATAL: database "postgres" does not exist # 2024-03-15 14:01:13.059 UTC [28539][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:13.060 UTC [28539][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-15 14:01:13.060 UTC [28539][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-03-15 14:01:13.061 UTC [28539][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 53, which is not a valid value for type '_Bool' # ==28539==Using libbacktrace symbolizer. # #0 0x5651b72410a9 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5651b7241135 in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5651b74af71e in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5651b74afa8b in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5651b74afe65 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5651b74b2d65 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5651b7356104 in BackendRun ../src/backend/postmaster/postmaster.c:4452 # #7 0x5651b735b949 in BackendStartup ../src/backend/postmaster/postmaster.c:4117 # #8 0x5651b735bd62 in ServerLoop ../src/backend/postmaster/postmaster.c:1780 # #9 0x5651b735d77c in PostmasterMain ../src/backend/postmaster/postmaster.c:1478 # #10 0x5651b7187315 in main ../src/backend/main/main.c:197 # #11 0x7fdc1f071d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x5651b6cf6219 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); [14:01:15.325](1.136s) not ok 14 - createuser -r regress user2 exit code 0 [14:01:15.325](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. [14:01:15.325](0.000s) not ok 15 - create a CREATEROLE user: SQL found in server log [14:01:15.325](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. [14:01:15.326](0.000s) # '2024-03-15 14:01:14.195 UTC [28627][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:14.196 UTC [28627][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-15 14:01:14.196 UTC [28627][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-03-15 14:01:14.196 UTC [28627][client backend] [[unknown]][4/1:0] FATAL: database "postgres" does not exist # 2024-03-15 14:01:14.196 UTC [28628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:14.197 UTC [28628][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-15 14:01:14.197 UTC [28628][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-03-15 14:01:14.198 UTC [28628][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 53, which is not a valid value for type '_Bool' # ==28628==Using libbacktrace symbolizer. # #0 0x5651b72410a9 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5651b7241135 in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5651b74af71e in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5651b74afa8b in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5651b74afe65 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5651b74b2d65 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5651b7356104 in BackendRun ../src/backend/postmaster/postmaster.c:4452 # #7 0x5651b735b949 in BackendStartup ../src/backend/postmaster/postmaster.c:4117 # #8 0x5651b735bd62 in ServerLoop ../src/backend/postmaster/postmaster.c:1780 # #9 0x5651b735d77c in PostmasterMain ../src/backend/postmaster/postmaster.c:1478 # #10 0x5651b7187315 in main ../src/backend/main/main.c:197 # #11 0x7fdc1f071d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x5651b6cf6219 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); [14:01:16.964](1.638s) not ok 16 - createuser -s regress_user3 exit code 0 [14:01:16.985](0.021s) # Failed test 'createuser -s regress_user3 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 31. [14:01:16.985](0.000s) not ok 17 - create a superuser: SQL found in server log [14:01:16.985](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. [14:01:16.985](0.000s) # '2024-03-15 14:01:15.333 UTC [28730][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:15.334 UTC [28730][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-15 14:01:15.334 UTC [28730][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-03-15 14:01:15.334 UTC [28730][client backend] [[unknown]][6/1:0] FATAL: database "postgres" does not exist # 2024-03-15 14:01:15.335 UTC [28731][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:15.335 UTC [28731][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-15 14:01:15.335 UTC [28731][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-03-15 14:01:15.336 UTC [28731][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 53, which is not a valid value for type '_Bool' # ==28731==Using libbacktrace symbolizer. # #0 0x5651b72410a9 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5651b7241135 in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5651b74af71e in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5651b74afa8b in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5651b74afe65 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5651b74b2d65 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5651b7356104 in BackendRun ../src/backend/postmaster/postmaster.c:4452 # #7 0x5651b735b949 in BackendStartup ../src/backend/postmaster/postmaster.c:4117 # #8 0x5651b735bd62 in ServerLoop ../src/backend/postmaster/postmaster.c:1780 # #9 0x5651b735d77c in PostmasterMain ../src/backend/postmaster/postmaster.c:1478 # #10 0x5651b7187315 in main ../src/backend/main/main.c:197 # #11 0x7fdc1f071d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x5651b6cf6219 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); [14:01:20.126](3.140s) not ok 18 - createuser -a regress_user1 -a regress user2 regress user \#4 exit code 0 [14:01:20.126](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. [14:01:20.126](0.000s) not ok 19 - add a role as a member with admin option of the newly created role: SQL found in server log [14:01:20.126](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. [14:01:20.127](0.000s) # '2024-03-15 14:01:16.994 UTC [28861][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:16.994 UTC [28861][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-15 14:01:16.994 UTC [28861][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-03-15 14:01:16.994 UTC [28861][client backend] [[unknown]][8/1:0] FATAL: database "postgres" does not exist # 2024-03-15 14:01:16.996 UTC [28862][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:16.996 UTC [28862][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-15 14:01:16.996 UTC [28862][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-03-15 14:01:16.997 UTC [28862][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 53, which is not a valid value for type '_Bool' # ==28862==Using libbacktrace symbolizer. # #0 0x5651b72410a9 in standard_planner ../src/backend/optimizer/plan/planner.c:569 # #1 0x5651b7241135 in planner ../src/backend/optimizer/plan/planner.c:276 # #2 0x5651b74af71e in pg_plan_query ../src/backend/tcop/postgres.c:904 # #3 0x5651b74afa8b in pg_plan_queries ../src/backend/tcop/postgres.c:996 # #4 0x5651b74afe65 in exec_simple_query ../src/backend/tcop/postgres.c:1193 # #5 0x5651b74b2d65 in PostgresMain ../src/backend/tcop/postgres.c:4680 # #6 0x5651b7356104 in BackendRun ../src/backend/postmaster/postmaster.c:4452 # #7 0x5651b735b949 in BackendStartup ../src/backend/postmaster/postmaster.c:4117 # #8 0x5651b735bd62 in ServerLoop ../src/backend/postmaster/postmaster.c:1780 # #9 0x5651b735d77c in PostmasterMain ../src/backend/postmaster/postmaster.c:1478 # #10 0x5651b7187315 in main ../src/backend/main/main.c:197 # #11 0x7fdc1f071d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x5651b6cf6219 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b5219) # # 2024-03-15 14:01:17.982 UTC [28474][postmaster] LOG: server process (PID 28539) was terminated by signal 6: Aborted # 2024-03-15 14:01:17.982 UTC [28474][postmaster] DETAIL: Failed process was running: SELECT pg_catalog.set_config('search_path', '', false); # 2024-03-15 14:01:18.004 UTC [28474][postmaster] LOG: terminating any other active server processes # ' # 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: connection to server on socket "/tmp/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.139](0.013s) not ok 20 - createuser REGRESS_USER5 -m regress_user3 -m regress user \#4 exit code 0 [14:01:20.140](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. [14:01:20.140](0.000s) not ok 21 - add a role as a member of the newly created role: SQL found in server log [14:01:20.140](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. [14:01:20.140](0.000s) # '2024-03-15 14:01:20.134 UTC [28931][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.134 UTC [28931][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.135 UTC [28932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.135 UTC [28932][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # ' # 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: connection to server on socket "/tmp/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.153](0.013s) not ok 22 - createuser -v 2029 12 31 regress_user6 exit code 0 [14:01:20.153](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. [14:01:20.154](0.000s) not ok 23 - create a role with a password expiration date: SQL found in server log [14:01:20.154](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. [14:01:20.154](0.000s) # '2024-03-15 14:01:20.147 UTC [28934][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.147 UTC [28934][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.148 UTC [28935][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.148 UTC [28935][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # ' # 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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.167](0.013s) not ok 24 - createuser --bypassrls regress_user7 exit code 0 [14:01:20.167](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. [14:01:20.168](0.000s) not ok 25 - create a BYPASSRLS role: SQL found in server log [14:01:20.168](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. [14:01:20.168](0.000s) # '2024-03-15 14:01:20.161 UTC [28939][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.161 UTC [28939][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.162 UTC [28940][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.162 UTC [28940][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.181](0.013s) not ok 26 - createuser --no-bypassrls regress_user8 exit code 0 [14:01:20.181](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. [14:01:20.181](0.000s) not ok 27 - create a role without BYPASSRLS: SQL found in server log [14:01:20.182](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. [14:01:20.182](0.000s) # '2024-03-15 14:01:20.175 UTC [28942][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.175 UTC [28942][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.176 UTC [28943][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.176 UTC [28943][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.195](0.013s) not ok 28 - createuser --with-admin regress_user1 regress_user9 exit code 0 [14:01:20.195](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. [14:01:20.195](0.000s) not ok 29 - --with-admin: SQL found in server log [14:01:20.195](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. [14:01:20.195](0.000s) # '2024-03-15 14:01:20.189 UTC [28945][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.189 UTC [28945][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.190 UTC [28946][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.190 UTC [28946][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.208](0.013s) not ok 30 - createuser --with-member regress_user1 regress_user10 exit code 0 [14:01:20.208](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. [14:01:20.209](0.000s) not ok 31 - --with-member: SQL found in server log [14:01:20.209](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. [14:01:20.209](0.000s) # '2024-03-15 14:01:20.202 UTC [28948][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.203 UTC [28948][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.203 UTC [28949][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.203 UTC [28949][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.222](0.013s) not ok 32 - createuser --role regress_user1 regress_user11 exit code 0 [14:01:20.222](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. [14:01:20.222](0.000s) not ok 33 - --role: SQL found in server log [14:01:20.222](0.000s) # Failed test '--role: SQL found in server log' # at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 70. [14:01:20.222](0.000s) # '2024-03-15 14:01:20.216 UTC [28951][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.216 UTC [28951][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.216 UTC [28952][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.216 UTC [28952][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.236](0.013s) not ok 34 - createuser regress_user12 --member-of regress_user1 exit code 0 [14:01:20.236](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. [14:01:20.236](0.000s) not ok 35 - --member-of: SQL found in server log [14:01:20.236](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. [14:01:20.237](0.000s) # '2024-03-15 14:01:20.229 UTC [28954][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.230 UTC [28954][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-03-15 14:01:20.230 UTC [28955][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-03-15 14:01:20.230 UTC [28955][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/0Y4iSH6rAA/.s.PGSQL.51049" failed: FATAL: the database system is in recovery mode [14:01:20.249](0.013s) 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. [14:01:20.262](0.013s) ok 37 - fails for too many non-options [14:01:20.262](0.001s) 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" [14:01:22.970](2.707s) # Looks like you failed 26 tests of 37.