Source: pgbouncer Version: 1.17.0-3 Severity: serious Tags: ftbfs https://buildd.debian.org/status/fetch.php?pkg=pgbouncer&arch=amd64&ver=1.17.0-3%2Bb2&stamp=1665894517&raw=0
...
Sun Oct 16 04:26:31 UTC 2022 running test_show ... FAILED
# => show clients;
# type | user | database | state | addr | port | local_addr |
local_port | connect_time | request_time | wait | wait_us
| close_needed | ptr | link | remote_pid | tls
#
------+-----------+-----------+--------+------+------+------------+------------+-------------------------+-------------------------+------+---------+--------------+----------------+------+------------+-----
# C | pgbouncer | pgbouncer | active | unix | 6667 | unix |
6667 | 2022-10-16 04:26:31 UTC | 2022-10-16 04:26:31 UTC | 0 | 0 |
0 | 0x5555753a27f0 | | 2977531 |
# (1 row)
#
# => show config;
# key | value
| default | changeable
#
---------------------------+--------------------------------------------------------+--------------------------------------------------------+------------
# admin_users |
| | yes
# application_name_add_host | 0
| 0 | yes
# auth_file | userlist.txt
| | yes
# auth_hba_file |
| | yes
# auth_query | SELECT usename, passwd FROM pg_shadow WHERE
usename=$1 | SELECT usename, passwd FROM pg_shadow WHERE usename=$1 | yes
# auth_type | trust
| md5 | yes
# auth_user |
| | yes
# autodb_idle_timeout | 3600
| 3600 | yes
# client_idle_timeout | 0
| 0 | yes
# client_login_timeout | 60
| 60 | yes
# client_tls_ca_file |
| | yes
# client_tls_cert_file |
| | yes
# client_tls_ciphers | fast
| fast | yes
# client_tls_dheparams | auto
| auto | yes
# client_tls_ecdhcurve | auto
| auto | yes
# client_tls_key_file |
| | yes
# client_tls_protocols | secure
| secure | yes
# client_tls_sslmode | disable
| disable | yes
# conffile | test.ini
| | yes
# default_pool_size | 5
| 20 | yes
# disable_pqexec | 0
| 0 | no
# dns_max_ttl | 15
| 15 | yes
# dns_nxdomain_ttl | 15
| 15 | yes
# dns_zone_check_period | 0
| 0 | yes
# idle_transaction_timeout | 0
| 0 | yes
# ignore_startup_parameters |
| | yes
# job_name | pgbouncer
| pgbouncer | no
# listen_addr | 127.0.0.1
| | no
# listen_backlog | 128
| 128 | no
# listen_port | 6667
| 6432 | no
# log_connections | 1
| 1 | yes
# log_disconnections | 1
| 1 | yes
# log_pooler_errors | 1
| 1 | yes
# log_stats | 1
| 1 | yes
# logfile | test.log
| | yes
# max_client_conn | 10
| 100 | yes
# max_db_connections | 0
| 0 | yes
# max_packet_size | 2147483647
| 2147483647 | yes
# max_user_connections | 0
| 0 | yes
# min_pool_size | 0
| 0 | yes
# pidfile | test.pid
| | no
# pkt_buf | 4096
| 4096 | no
# pool_mode | statement
| session | yes
# query_timeout | 0
| 0 | yes
# query_wait_timeout | 120
| 120 | yes
# reserve_pool_size | 0
| 0 | yes
# reserve_pool_timeout | 5
| 5 | yes
# resolv_conf |
| | no
# sbuf_loopcnt | 5
| 5 | yes
# server_check_delay | 10
| 30 | yes
# server_check_query | select 1
| select 1 | yes
# server_connect_timeout | 15
| 15 | yes
# server_fast_close | 0
| 0 | yes
# server_idle_timeout | 60
| 600 | yes
# server_lifetime | 120
| 3600 | yes
# server_login_retry | 15
| 15 | yes
# server_reset_query | DISCARD ALL
| DISCARD ALL | yes
# server_reset_query_always | 0
| 0 | yes
# server_round_robin | 0
| 0 | yes
# server_tls_ca_file |
| | yes
# server_tls_cert_file |
| | yes
# server_tls_ciphers | fast
| fast | yes
# server_tls_key_file |
| | yes
# server_tls_protocols | secure
| secure | yes
# server_tls_sslmode | disable
| disable | yes
# so_reuseport | 0
| 0 | no
# stats_period | 60
| 60 | yes
# stats_users |
| | yes
# suspend_timeout | 10
| 10 | yes
# syslog | 0
| 0 | yes
# syslog_facility | daemon
| daemon | yes
# syslog_ident | pgbouncer
| pgbouncer | yes
# tcp_defer_accept | 0
| 1 | yes
# tcp_keepalive | 0
| 1 | yes
# tcp_keepcnt | 0
| 0 | yes
# tcp_keepidle | 0
| 0 | yes
# tcp_keepintvl | 0
| 0 | yes
# tcp_socket_buffer | 0
| 0 | yes
# tcp_user_timeout | 0
| 0 | yes
# unix_socket_dir | /tmp
| /tmp | no
# unix_socket_group |
| | no
# unix_socket_mode | 511
| 0777 | no
# user |
| | no
# verbose | 0
| | yes
# (84 rows)
#
# => show databases;
# name | host | port | database | force_user | pool_size
| min_pool_size | reserve_pool | pool_mode | max_connections |
current_connections | paused | disabled
#
-----------+---------------------+------+-----------+------------+-----------+---------------+--------------+-----------+-----------------+---------------------+--------+----------
# authdb | 127.0.0.1 | 6666 | p1 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# hostlist1 | 127.0.0.1,::1 | 6666 | p0 | bouncer | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# hostlist2 | 127.0.0.1,127.0.0.1 | 6666 | p0 | bouncer | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p0 | 127.0.0.1 | 6666 | p0 | bouncer | 2
| 0 | 0 | | 0 |
0 | 0 | 0
# p1 | 127.0.0.1 | 6666 | p1 | bouncer | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p2 | 127.0.0.1 | 6666 | p0 | | 5
| 0 | 0 | | 4 |
0 | 0 | 0
# p3 | 127.0.0.1 | 6666 | p0 | bouncer | 5
| 0 | 0 | session | 0 |
0 | 0 | 0
# p4 | 127.0.0.1 | 6666 | p4 | puser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p4l | 127.0.0.1 | 6666 | p4 | longpass | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p4x | 127.0.0.1 | 6666 | p4 | puser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p4y | 127.0.0.1 | 6666 | p4 | puser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p4z | 127.0.0.1 | 6666 | p4 | puser2 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p5 | 127.0.0.1 | 6666 | p5 | muser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p5x | 127.0.0.1 | 6666 | p5 | muser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p5y | 127.0.0.1 | 6666 | p5 | muser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p5z | 127.0.0.1 | 6666 | p5 | muser2 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p6 | 127.0.0.1 | 6666 | p6 | scramuser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p61 | 127.0.0.1 | 6666 | p6 | scramuser3 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p62 | 127.0.0.1 | 6666 | p6 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p6x | 127.0.0.1 | 6666 | p6 | scramuser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p6y | 127.0.0.1 | 6666 | p6 | scramuser1 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p6z | 127.0.0.1 | 6666 | p6 | scramuser2 | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p7a | 127.0.0.1 | 6666 | p7 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p7b | 127.0.0.1 | 6666 | p7 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p7c | 127.0.0.1 | 6666 | p7 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# p8 | 127.0.0.1 | 6666 | p0 | | 5
| 0 | 0 | | 0 |
0 | 0 | 0
# pgbouncer | | 6667 | pgbouncer | pgbouncer | 2
| 0 | 0 | statement | 0 |
0 | 0 | 0
# (27 rows)
#
# => show fds;
# fd | task | user | database | addr | port | cancel | link |
client_encoding | std_strings | datestyle | timezone | password |
scram_client_key | scram_server_key
#
----+--------+------+----------+-----------+------+--------+------+-----------------+-------------+-----------+----------+----------+------------------+------------------
# 7 | pooler | | | 127.0.0.1 | 6667 | 0 | 0 |
| | | | | |
# 8 | pooler | | | unix | 6667 | 0 | 0 |
| | | | | |
# (2 rows)
#
# => show help;
# NOTICE: Console usage
# DETAIL:
# SHOW HELP|CONFIG|DATABASES|POOLS|CLIENTS|SERVERS|USERS|VERSION
# SHOW FDS|SOCKETS|ACTIVE_SOCKETS|LISTS|MEM
# SHOW DNS_HOSTS|DNS_ZONES
# SHOW STATS|STATS_TOTALS|STATS_AVERAGES|TOTALS
# SET key = arg
# RELOAD
# PAUSE [<db>]
# RESUME [<db>]
# DISABLE <db>
# ENABLE <db>
# RECONNECT [<db>]
# KILL <db>
# SUSPEND
# SHUTDOWN
#
# message contents do not agree with length in message type "N"
# SHOW
Sun Oct 16 04:26:32 UTC 2022 running test_server_login_retry ... ok
Sun Oct 16 04:26:35 UTC 2022 running test_auth_user ... ok
Sun Oct 16 04:26:35 UTC 2022 running test_client_idle_timeout ... ok
Sun Oct 16 04:26:39 UTC 2022 running test_server_lifetime ... ok
Sun Oct 16 04:26:42 UTC 2022 running test_server_idle_timeout ... ok
Sun Oct 16 04:26:45 UTC 2022 running test_query_timeout ... ok
Sun Oct 16 04:26:48 UTC 2022 running test_idle_transaction_timeout ... ok
Sun Oct 16 04:26:55 UTC 2022 running test_server_connect_timeout_establish ...
ok
Sun Oct 16 04:27:00 UTC 2022 running test_server_connect_timeout_reject ...
skipped
Sun Oct 16 04:27:00 UTC 2022 running test_server_check_delay ... skipped
Sun Oct 16 04:27:00 UTC 2022 running test_tcp_user_timeout ... skipped
Sun Oct 16 04:27:01 UTC 2022 running test_max_client_conn ... ok
Sun Oct 16 04:27:04 UTC 2022 running test_pool_size ... ok
Sun Oct 16 04:27:09 UTC 2022 running test_min_pool_size ... ok
Sun Oct 16 04:27:11 UTC 2022 running test_reserve_pool_size ... ok
Sun Oct 16 04:27:24 UTC 2022 running test_max_db_connections ... ok
Sun Oct 16 04:27:26 UTC 2022 running test_max_user_connections ... ok
Sun Oct 16 04:27:28 UTC 2022 running test_connect_query ... ok
Sun Oct 16 04:27:28 UTC 2022 running test_online_restart ... ok
Sun Oct 16 04:27:39 UTC 2022 running test_pause_resume ... ok
Sun Oct 16 04:27:50 UTC 2022 running test_suspend_resume ... ok
Sun Oct 16 04:28:00 UTC 2022 running test_enable_disable ... ok
Sun Oct 16 04:28:01 UTC 2022 running test_database_restart ... ok
Sun Oct 16 04:28:07 UTC 2022 running test_database_change ... ok
Sun Oct 16 04:28:10 UTC 2022 running test_reconnect ... ok
Sun Oct 16 04:28:11 UTC 2022 running test_fast_close ... ok
Sun Oct 16 04:28:14 UTC 2022 running test_wait_close ... ok
Sun Oct 16 04:28:18 UTC 2022 running test_password_server ... ok
Sun Oct 16 04:28:18 UTC 2022 running test_password_client ... ok
Sun Oct 16 04:28:18 UTC 2022 running test_md5_server ... ok
Sun Oct 16 04:28:19 UTC 2022 running test_md5_client ... ok
Sun Oct 16 04:28:19 UTC 2022 running test_scram_server ... ok
Sun Oct 16 04:28:19 UTC 2022 running test_scram_client ... ok
Sun Oct 16 04:28:19 UTC 2022 running test_scram_both ... ok
Sun Oct 16 04:28:20 UTC 2022 running test_scram_takeover ... ok
Sun Oct 16 04:28:25 UTC 2022 running test_no_user_trust ... ok
Sun Oct 16 04:28:25 UTC 2022 running test_no_user_trust_forced_user ... ok
Sun Oct 16 04:28:25 UTC 2022 running test_no_user_password ... ok
Sun Oct 16 04:28:25 UTC 2022 running test_no_user_password_forced_user ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_no_user_md5 ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_no_user_md5_forced_user ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_no_user_scram ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_no_user_scram_forced_user ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_no_user_auth_user ... ok
Sun Oct 16 04:28:26 UTC 2022 running test_auto_database ... ok
Sun Oct 16 04:28:27 UTC 2022 running test_no_database ... ok
Sun Oct 16 04:28:27 UTC 2022 running test_no_database_authfail ... ok
Sun Oct 16 04:28:27 UTC 2022 running test_no_database_auth_user ... ok
Sun Oct 16 04:28:27 UTC 2022 running test_cancel ... FAILED
# Cancel request sent
# ERROR: canceling statement due to user request
Sun Oct 16 04:28:28 UTC 2022 running test_cancel_wait ... FAILED
# SET server_idle_timeout=2
# Cancel request sent
# ERROR: canceling statement due to user request
Sun Oct 16 04:28:30 UTC 2022 running test_cancel_pool_size ... FAILED
# SET server_idle_timeout=2
# Cancel request sent
# Cancel request sent
# Cancel request sent
# Cancel request sent
# Cancel request sent
# ERROR: canceling statement due to user request
# ERROR: canceling statement due to user request
# ERROR: canceling statement due to user request
# ERROR: canceling statement due to user request
# ERROR: canceling statement due to user request
Sun Oct 16 04:28:32 UTC 2022 running test_host_list ... skipped
Sun Oct 16 04:28:32 UTC 2022 running test_host_list_dummy ... ok
make[2]: *** [Makefile:36: check] Error 1
