Your message dated Sat, 14 Oct 2017 15:20:36 +0000
with message-id <[email protected]>
and subject line Bug#856423: fixed in postgresql-plproxy 2.8-1
has caused the Debian Bug report #856423,
regarding postgresql-plproxy: autopkgtest failures since move to newnet (2.6-2)
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.)
--
856423: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=856423
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-plproxy
Version: 2.7-1
Severity: normal
Tags: patch
User: [email protected]
Usertags: origin-ubuntu zesty ubuntu-patch
Dear Maintainer,
The autopkgtests for postgresql-plproxy have been failing ever since
2.6-2 because postgres is not network namespace aware.
In Ubuntu, the attached patch was applied to achieve the following:
* d/t/installcheck fixes:
- Passing a port to pg_virtualenv even with newnet does not avoid
port collisions, as pg_virtualenv (via pg_createcluster) is only
looking at the configured clusters on the filesystem, not what is
running in the current network namespace. Set an alternative
PG_CLUSTER_CONF_ROOT instead, and set it before we call
pg_virtualenv.
- Set the socket directory for pg_createcluster, as we are using the
standard port and that can lead to conflicts. This also requires
making the AUTOPKGTEST_TMP directory world-writeable so the
postgres user can write socket information there.
Thanks for considering the patch.
*** /tmp/tmpnVHESZ/postgresql-plproxy_2.7-1ubuntu1.debdiff
diff -Nru postgresql-plproxy-2.7/debian/tests/installcheck
postgresql-plproxy-2.7/debian/tests/installcheck
--- postgresql-plproxy-2.7/debian/tests/installcheck 2016-09-25
14:04:41.000000000 -0700
+++ postgresql-plproxy-2.7/debian/tests/installcheck 2017-02-28
10:19:53.000000000 -0800
@@ -21,9 +21,19 @@
;;
esac
- if ! newnet pg_virtualenv -c '-p 5432 --locale C' -i '--auth trust' -v
$v \
- make -f $PWD/Makefile \
- installcheck PG_CONFIG=/usr/lib/postgresql/$v/bin/pg_config;
then
+ # AUTOPKGTEST_TMP is not writeable by any user except root, but
+ # we want to use it for storing the Postgres socket
+ # Set PG_CLUSTER_CONF_ROOT, because although we are running in a
+ # network namespace (so we can reuse the default port),
+ # pg_virtualenv/pg_createcluster looks at the configured
+ # databases on the filesystem
+ # Set the socket directory because we are to re-use the port and
+ # there can be conflicts in the normal socket directory
+ if ! chmod o+w $AUTOPKGTEST_TMP && \
+ PG_CLUSTER_CONF_ROOT=$AUTOPKGTEST_TMP \
+ PG_CONFIG=/usr/lib/postgresql/$v/bin/pg_config \
+ newnet pg_virtualenv -c "-p 5432 --locale C -s
$AUTOPKGTEST_TMP" -i '--auth trust' -v $v \
+ make -f $PWD/Makefile installcheck; then \
head -n 500 regression.diffs
exit 1
fi
-- System Information:
Debian Release: stretch/sid
APT prefers zesty
APT policy: (500, 'zesty')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.10.0-8-generic (SMP w/4 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
--
Nishanth Aravamudan
Ubuntu Server
Canonical Ltd
--- End Message ---
--- Begin Message ---
Source: postgresql-plproxy
Source-Version: 2.8-1
We believe that the bug you reported is fixed in the latest version of
postgresql-plproxy, 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 postgresql-plproxy
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: Sat, 14 Oct 2017 16:21:59 +0200
Source: postgresql-plproxy
Binary: postgresql-10-plproxy
Architecture: source
Version: 2.8-1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers
<[email protected]>
Changed-By: Christoph Berg <[email protected]>
Description:
postgresql-10-plproxy - database partitioning system for PostgreSQL 10
Closes: 856423
Changes:
postgresql-plproxy (2.8-1) unstable; urgency=medium
.
* New upstream release.
* Run tests via newnet/localhost so they don't conflict with an existing
cluster on 5432. (Closes: #856423)
Checksums-Sha1:
396b4d230a33d4d5f3b29f87bcf8e1200f60b0c4 2209 postgresql-plproxy_2.8-1.dsc
42c8e258ddfc7f525bccd87491d879ea37f2a016 79698
postgresql-plproxy_2.8.orig.tar.gz
53ebede72b6da9091b7a1e58bdd566b9395801a7 4668
postgresql-plproxy_2.8-1.debian.tar.xz
0152774e7c3d8707a1f375d69f3c4e8f6ffb6c3e 7376
postgresql-plproxy_2.8-1_source.buildinfo
Checksums-Sha256:
7e60f00d780a8f27116482285cc04ba237cd6b46b10fb91e55d4d9c4dea968ff 2209
postgresql-plproxy_2.8-1.dsc
4c6b19c4f62a509f1235d7b92cf355ca5eb89114b9b6d2b5f25d7f54c958acf5 79698
postgresql-plproxy_2.8.orig.tar.gz
f9d3a14b47532d9291c03779ad48e72c4c10cc446ed583a991381416ff82563b 4668
postgresql-plproxy_2.8-1.debian.tar.xz
1cb67bad6c93430c50440da07b8d91877dfba79c2707e9fad86c7502f8f87d72 7376
postgresql-plproxy_2.8-1_source.buildinfo
Files:
76f6ffef3429fb436224de93455df256 2209 database optional
postgresql-plproxy_2.8-1.dsc
1ecd3ba86b39375f7c8ba8d482eb77ff 79698 database optional
postgresql-plproxy_2.8.orig.tar.gz
169db3af1c1cb754fd1f8522811df3ae 4668 database optional
postgresql-plproxy_2.8-1.debian.tar.xz
b3500497043895ccecbd862137ba8385 7376 database optional
postgresql-plproxy_2.8-1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCAAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAlniJQIACgkQTFprqxLS
p647PxAAoYlNYksA3UxnC+7+HDPB4aUvMEZNd6r/fLoPzjefSBNhF+cSPp5glD2G
uSSD4jqe7U4a15MEfcaxIzMMl1uIY6QUmSzc+I7tBbgUzLsVxFsvoq9cFgYTjEgc
03FhH7Mis1uaSqUKbd5p8vrRlQ17Frw9DCugC0Yb5JLCWVLoVMaJ2vnPY1p36///
j22VBv7wmM5ccYg/HJ+YP/UpsnOnvjmR0BW0hBIr2g3PCcI12fiOHq3UsrdJiFF1
Ct/gw1zRF4A+Ulic283ZrmaNMKtp29i465LE+iAVBf7a7HvLxAcvSXXdO3yY/9bu
ivKLdlbQ/79W2HyI87Com95mm0d6S4jG/gnfNoRDdDkgrVGod8JNi+fkvqJZfHwe
q5P/kKsw34YW7jXyObAL7I4W65LT/g7ITqeKOXGbuSnFfKinPAEG01S1niKNe+gl
/7lKVDcH+SSFKXJ+PWvTlQ7iYOHtXuItZH6wfNyLg+EFygh41AeyMtfB+SyhxKnh
Ix6SwkvoDpzftqPvrIPDEYQUTWAIgklzMEvqanSWX3p1EVijrpXluev3chYEuzLV
khstdVm5P4KsxhGBw5uHJ9b24s36HGHjXxDwi07RMYOehYZtq/z6lLxXZZWdjqHt
2jB/GKH9KN4Fj/UIv3StbfwhPupk/N6lMa8vLqRf0KHSvuaMhC8=
=QYGf
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
