# Running: createuser --help [22:50:08.751](0.017s) ok 1 - createuser --help exit code 0 [22:50:08.751](0.000s) ok 2 - createuser --help goes to stdout [22:50:08.751](0.000s) ok 3 - createuser --help nothing to stderr [22:50:08.751](0.000s) ok 4 - createuser --help maximum line length # Running: createuser --version [22:50:08.758](0.007s) ok 5 - createuser --version exit code 0 [22:50:08.758](0.000s) ok 6 - createuser --version goes to stdout [22:50:08.758](0.000s) ok 7 - createuser --version nothing to stderr # Running: createuser --not-a-valid-option [22:50:08.765](0.007s) ok 8 - createuser with invalid option nonzero exit code [22:50:08.765](0.000s) ok 9 - createuser with invalid option prints error message # Checking port 53628 # Found port 53628 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=53628 host=/tmp/D6JKab9g8s Log file: /tmp/cirrus-ci-build/build/testrun/scripts/040_createuser/log/040_createuser_main.log [22:50:08.770](0.005s) # 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 29164 # 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); [22:50:09.231](0.461s) not ok 10 - createuser regress_user1 exit code 0 [22:50:09.231](0.000s) # Failed test 'createuser regress_user1 exit code 0' # at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 19. [22:50:09.232](0.000s) not ok 11 - SQL CREATE USER run: SQL found in server log [22:50:09.232](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. [22:50:09.232](0.000s) # '2024-02-23 22:50:08.923 UTC [29183][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:08.924 UTC [29183][client backend] [[unknown]][3/3: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-02-23 22:50:08.924 UTC [29183][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:08.924 UTC [29183][client backend] [[unknown]][3/3:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:08.925 UTC [29184][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:08.926 UTC [29184][client backend] [[unknown]][3/4: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-02-23 22:50:08.926 UTC [29184][client backend] [[unknown]][3/4:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:08.927 UTC [29184][client backend] [040_createuser.pl][3/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29184==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:09.547](0.315s) not ok 12 - createuser -L regress_role1 exit code 0 [22:50:09.548](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. [22:50:09.548](0.000s) not ok 13 - create a non-login role: SQL found in server log [22:50:09.548](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. [22:50:09.548](0.000s) # '2024-02-23 22:50:09.239 UTC [29201][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:09.240 UTC [29201][client backend] [[unknown]][4/3: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-02-23 22:50:09.240 UTC [29201][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:09.240 UTC [29201][client backend] [[unknown]][4/3:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:09.241 UTC [29202][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:09.242 UTC [29202][client backend] [[unknown]][4/4: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-02-23 22:50:09.242 UTC [29202][client backend] [[unknown]][4/4:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:09.243 UTC [29202][client backend] [040_createuser.pl][4/5:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29202==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:10.185](0.637s) not ok 14 - createuser -r regress user2 exit code 0 [22:50:10.186](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. [22:50:10.186](0.000s) not ok 15 - create a CREATEROLE user: SQL found in server log [22:50:10.186](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. [22:50:10.186](0.000s) # '2024-02-23 22:50:09.555 UTC [29225][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:09.556 UTC [29225][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-02-23 22:50:09.556 UTC [29225][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:09.556 UTC [29225][client backend] [[unknown]][5/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:09.557 UTC [29226][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:09.558 UTC [29226][client backend] [[unknown]][5/2: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-02-23 22:50:09.558 UTC [29226][client backend] [[unknown]][5/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:09.559 UTC [29226][client backend] [040_createuser.pl][5/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29226==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:10.822](0.636s) not ok 16 - createuser -s regress_user3 exit code 0 [22:50:10.823](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. [22:50:10.824](0.001s) not ok 17 - create a superuser: SQL found in server log [22:50:10.824](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. [22:50:10.824](0.000s) # '2024-02-23 22:50:10.194 UTC [29268][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:10.195 UTC [29268][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-02-23 22:50:10.195 UTC [29268][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:10.195 UTC [29268][client backend] [[unknown]][6/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:10.196 UTC [29269][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:10.197 UTC [29269][client backend] [[unknown]][6/2: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-02-23 22:50:10.197 UTC [29269][client backend] [[unknown]][6/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:10.198 UTC [29269][client backend] [040_createuser.pl][6/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29269==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:11.962](1.138s) not ok 18 - createuser -a regress_user1 -a regress user2 regress user \#4 exit code 0 [22:50:11.963](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. [22:50:11.963](0.000s) not ok 19 - add a role as a member with admin option of the newly created role: SQL found in server log [22:50:11.963](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. [22:50:11.963](0.000s) # '2024-02-23 22:50:10.833 UTC [29309][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:10.834 UTC [29309][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-02-23 22:50:10.834 UTC [29309][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:10.834 UTC [29309][client backend] [[unknown]][7/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:10.835 UTC [29311][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:10.836 UTC [29311][client backend] [[unknown]][7/2: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-02-23 22:50:10.836 UTC [29311][client backend] [[unknown]][7/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:10.837 UTC [29311][client backend] [040_createuser.pl][7/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29311==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:13.102](1.138s) not ok 20 - createuser REGRESS_USER5 -m regress_user3 -m regress user \#4 exit code 0 [22:50:13.102](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. [22:50:13.103](0.000s) not ok 21 - add a role as a member of the newly created role: SQL found in server log [22:50:13.103](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. [22:50:13.103](0.000s) # '2024-02-23 22:50:11.972 UTC [29413][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:11.972 UTC [29413][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-02-23 22:50:11.972 UTC [29413][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:11.973 UTC [29413][client backend] [[unknown]][8/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:11.974 UTC [29414][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:11.975 UTC [29414][client backend] [[unknown]][8/2: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-02-23 22:50:11.975 UTC [29414][client backend] [[unknown]][8/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:11.976 UTC [29414][client backend] [040_createuser.pl][8/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29414==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:14.243](1.141s) not ok 22 - createuser -v 2029 12 31 regress_user6 exit code 0 [22:50:14.244](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. [22:50:14.244](0.000s) not ok 23 - create a role with a password expiration date: SQL found in server log [22:50:14.245](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. [22:50:14.245](0.000s) # '2024-02-23 22:50:13.112 UTC [29525][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:13.113 UTC [29525][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-02-23 22:50:13.113 UTC [29525][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:13.113 UTC [29525][client backend] [[unknown]][9/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:13.114 UTC [29526][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:13.115 UTC [29526][client backend] [[unknown]][9/2: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-02-23 22:50:13.115 UTC [29526][client backend] [[unknown]][9/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:13.116 UTC [29526][client backend] [040_createuser.pl][9/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29526==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:15.383](1.138s) not ok 24 - createuser --bypassrls regress_user7 exit code 0 [22:50:15.383](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. [22:50:15.384](0.000s) not ok 25 - create a BYPASSRLS role: SQL found in server log [22:50:15.384](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. [22:50:15.384](0.000s) # '2024-02-23 22:50:14.253 UTC [29624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:14.253 UTC [29624][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-02-23 22:50:14.253 UTC [29624][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:14.254 UTC [29624][client backend] [[unknown]][10/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:14.254 UTC [29625][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:14.255 UTC [29625][client backend] [[unknown]][10/2: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-02-23 22:50:14.255 UTC [29625][client backend] [[unknown]][10/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:14.256 UTC [29625][client backend] [040_createuser.pl][10/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29625==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # ' # 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); [22:50:16.521](1.137s) not ok 26 - createuser --no-bypassrls regress_user8 exit code 0 [22:50:16.522](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. [22:50:16.522](0.000s) not ok 27 - create a role without BYPASSRLS: SQL found in server log [22:50:16.522](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. [22:50:16.522](0.000s) # '2024-02-23 22:50:15.391 UTC [29675][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:15.392 UTC [29675][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-02-23 22:50:15.392 UTC [29675][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=postgres application_name=040_createuser.pl # 2024-02-23 22:50:15.392 UTC [29675][client backend] [[unknown]][11/1:0] FATAL: database "postgres" does not exist # 2024-02-23 22:50:15.393 UTC [29676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:15.394 UTC [29676][client backend] [[unknown]][11/2: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-02-23 22:50:15.394 UTC [29676][client backend] [[unknown]][11/2:0] LOG: connection authorized: user=postgres database=template1 application_name=040_createuser.pl # 2024-02-23 22:50:15.395 UTC [29676][client backend] [040_createuser.pl][11/3:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # ../src/backend/optimizer/plan/planner.c:576:28: runtime error: load of value 5, which is not a valid value for type '_Bool' # ==29676==Using libbacktrace symbolizer. # #0 0x55bc929ac069 in standard_planner ../src/backend/optimizer/plan/planner.c:576 # #1 0x55bc929ac0f5 in planner ../src/backend/optimizer/plan/planner.c:283 # #2 0x55bc92c18279 in pg_plan_query ../src/backend/tcop/postgres.c:903 # #3 0x55bc92c185e6 in pg_plan_queries ../src/backend/tcop/postgres.c:995 # #4 0x55bc92c189c0 in exec_simple_query ../src/backend/tcop/postgres.c:1192 # #5 0x55bc92c1b8c0 in PostgresMain ../src/backend/tcop/postgres.c:4675 # #6 0x55bc92ac1657 in BackendRun ../src/backend/postmaster/postmaster.c:4477 # #7 0x55bc92ac6f3b in BackendStartup ../src/backend/postmaster/postmaster.c:4153 # #8 0x55bc92ac72b8 in ServerLoop ../src/backend/postmaster/postmaster.c:1771 # #9 0x55bc92ac8d4a in PostmasterMain ../src/backend/postmaster/postmaster.c:1470 # #10 0x55bc928f2305 in main ../src/backend/main/main.c:198 # #11 0x7f0c0f797d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) # #12 0x55bc92463229 in _start (/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres+0x8b1229) # # 2024-02-23 22:50:16.271 UTC [29164][postmaster] LOG: server process (PID 29184) was terminated by signal 6: Aborted # 2024-02-23 22:50:16.271 UTC [29164][postmaster] DETAIL: Failed process was running: SELECT pg_catalog.set_config('search_path', '', false); # 2024-02-23 22:50:16.271 UTC [29164][postmaster] LOG: terminating any other active server processes # ' # 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/D6JKab9g8s/.s.PGSQL.53628" failed: FATAL: the database system is in recovery mode [22:50:16.535](0.013s) not ok 28 - createuser --with-admin regress_user1 regress_user9 exit code 0 [22:50:16.536](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. [22:50:16.536](0.000s) not ok 29 - --with-admin: SQL found in server log [22:50:16.536](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. [22:50:16.536](0.000s) # '2024-02-23 22:50:16.530 UTC [29741][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.530 UTC [29741][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-02-23 22:50:16.531 UTC [29742][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.531 UTC [29742][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/D6JKab9g8s/.s.PGSQL.53628" failed: FATAL: the database system is in recovery mode [22:50:16.549](0.013s) not ok 30 - createuser --with-member regress_user1 regress_user10 exit code 0 [22:50:16.550](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. [22:50:16.550](0.000s) not ok 31 - --with-member: SQL found in server log [22:50:16.550](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. [22:50:16.550](0.000s) # '2024-02-23 22:50:16.543 UTC [29744][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.544 UTC [29744][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-02-23 22:50:16.545 UTC [29745][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.545 UTC [29745][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/D6JKab9g8s/.s.PGSQL.53628" failed: FATAL: the database system is in recovery mode [22:50:16.564](0.013s) not ok 32 - createuser --role regress_user1 regress_user11 exit code 0 [22:50:16.564](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. [22:50:16.564](0.000s) not ok 33 - --role: SQL found in server log [22:50:16.565](0.000s) # Failed test '--role: SQL found in server log' # at /tmp/cirrus-ci-build/src/bin/scripts/t/040_createuser.pl line 70. [22:50:16.565](0.000s) # '2024-02-23 22:50:16.559 UTC [29747][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.559 UTC [29747][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-02-23 22:50:16.560 UTC [29748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.560 UTC [29748][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/D6JKab9g8s/.s.PGSQL.53628" failed: FATAL: the database system is in recovery mode [22:50:16.578](0.013s) not ok 34 - createuser regress_user12 --member-of regress_user1 exit code 0 [22:50:16.578](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. [22:50:16.579](0.000s) not ok 35 - --member-of: SQL found in server log [22:50:16.579](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. [22:50:16.579](0.000s) # '2024-02-23 22:50:16.572 UTC [29750][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.573 UTC [29750][client backend] [[unknown]][:0] FATAL: the database system is in recovery mode # 2024-02-23 22:50:16.574 UTC [29751][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-23 22:50:16.574 UTC [29751][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/D6JKab9g8s/.s.PGSQL.53628" failed: FATAL: the database system is in recovery mode [22:50:16.592](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. [22:50:16.606](0.013s) ok 37 - fails for too many non-options [22:50:16.606](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" [22:50:21.718](5.112s) # Looks like you failed 26 tests of 37.