Your message dated Tue, 25 Oct 2022 14:36:27 +0000
with message-id <[email protected]>
and subject line Bug#1021859: fixed in pgbouncer 1.17.0-4
has caused the Debian Bug report #1021859,
regarding pgbouncer FTBFS: test failures
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1021859: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1021859
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Source: pgbouncer
Source-Version: 1.17.0-4
Done: Christoph Berg <[email protected]>
We believe that the bug you reported is fixed in the latest version of
pgbouncer, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <[email protected]> (supplier of updated pgbouncer package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Mon, 24 Oct 2022 11:48:31 +0200
Source: pgbouncer
Architecture: source
Version: 1.17.0-4
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Changed-By: Christoph Berg <[email protected]>
Closes: 1009025 1021859
Changes:
pgbouncer (1.17.0-4) unstable; urgency=medium
.
* Install pgbouncer.service and pgbouncer.socket files from upstream.
(Closes: #1009025)
* Cherry-pick 04ff38b25e from upstream to fix tests.
(Closes: #1021859, but needs 4a6de748d3 in postgresql-15 as well)
Checksums-Sha1:
4853326f551110c8a54896f130b4f7bc5391e948 2229 pgbouncer_1.17.0-4.dsc
08667bb10b3fa025ef6c2f011363424134f39436 11052 pgbouncer_1.17.0-4.debian.tar.xz
Checksums-Sha256:
ff4dd4e3a16324d4a5ee7685ea85fca821225a848bc95d4615f24b37e7025ecd 2229
pgbouncer_1.17.0-4.dsc
9ce70267a12c112bfac7fd60029e8463ea91c4801c302f75baa21c9587226f4d 11052
pgbouncer_1.17.0-4.debian.tar.xz
Files:
f20fe9394307916bccbe4ee90c96bbc2 2229 database optional pgbouncer_1.17.0-4.dsc
a32dcbd1cb6b8d154bf0c633da1287bd 11052 database optional
pgbouncer_1.17.0-4.debian.tar.xz
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAmNWl4MACgkQTFprqxLS
p64gqg//bTAI3cLS5mGN0xqd/EwQ7oEET7Z0mF6ZN4TzwF3tmWjfnQJrbgJja30f
uSJHVRNNpdZ0n1FxGhrbLYXMz/E7+HLGKJWj+RhKxdmUTOnxtNL3cIs90g5pwnEU
IEPUOM5oYMyIWAv0omHfkBCNxsmiweSImRhC00lE9ZDykQRfrVHiNleoIfx0QLeO
uqD5F94kZ2SoxpPSN8F/ftYSSgPSCMj22MGlCJtDLw04vDKcqJyhz/mO4RTAKHct
NNK4cONBOB94jQwHIlVpGZ5+ZIWJo6r3HjQiDKEvgQMyinWn8Cnwi/X7xTtnyPkn
hYr9lzW4bKegMpchSlJAiu7CDVr3tiprtaOZH+Fzp8WYT6NpllwTXdlFo1z+cnBb
3XTJtrfJo1ZL9nOg1fo9P1cteuPhtG8vZAzsRai2sABVoyEmhZT1BPL9neSquwA5
whnqmt7kd4Z5HxJp78/LU9BNUN7K0DzWrqKmZ9lq11aYRpFqVQpStdPvDC+G4cVE
RMzrgG+nbwlXgHdQoTP4fTgExqpv/txvK9osfNwl9Zi6UtR5xyIirBCt8gFQeTPW
MWFCtytE+T8RT/Y9InNWxqtJ7KTELDdImjsl4rDT97U5x4ffrqfxGXrerkb4mW2a
g1u300f57plFxbrHka7f4nqCGqMekFyKyHFHwbUOglD9KJv9M6w=
=zGRw
-----END PGP SIGNATURE-----
--- End Message ---
