BF animal malleefowl reported an failure in 001_password.pl
От | houzj.fnst@fujitsu.com |
---|---|
Тема | BF animal malleefowl reported an failure in 001_password.pl |
Дата | |
Msg-id | OS0PR01MB57163D3BF2AB42ECAA94E5C394C29@OS0PR01MB5716.jpnprd01.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: BF animal malleefowl reported an failure in 001_password.pl
|
Список | pgsql-hackers |
Hi, I noticed one BF failure[1] when monitoring the BF for some other commit. # Failed test 'authentication success for method password, connstr user=scram_role: log matches' # at t/001_password.pl line 120. # '2023-01-13 07:33:46.741 EST [243628:5] LOG: received SIGHUP, reloading configuration files # 2023-01-13 07:33:46.742 EST [243662:1] [unknown] LOG: connection received: host=[local] # 2023-01-13 07:33:46.744 EST [243662:2] [unknown] LOG: connection authorized: user=scram_role database=postgres application_name=001_password.pl # 2023-01-13 07:33:46.748 EST [243662:3] 001_password.pl LOG: statement: SELECT $$connected with user=scram_role$$ # ' # doesn't match '(?^:connection authenticated: identity="scram_role" method=password)' # Looks like you failed 1 test of 79. [08:33:47] t/001_password.pl ........ After checking the test and log, I can see the test failed at the following code: ---- # For plain "password" method, all users should also be able to connect. reset_pg_hba($node, 'all', 'all', 'password'); test_conn($node, 'user=scram_role', 'password', 0, log_like => [qr/connection authenticated: identity="scram_role" method=password/]); ---- From the log, the expected "xxx method=password " log was not output, a simple "connection authorized: user=scram_role database=postgres " was output Instead. So it seems the connection happens before pg_ident.conf is actually reloaded ? Not sure if we need to do something make sure the reload happen, because it's looks like very rare failure which hasn't happen in last 90 days. [1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=malleefowl&dt=2023-01-13%2009%3A54%3A51 Best regards, Hou zhijie
В списке pgsql-hackers по дате отправления: