0s autopkgtest [03:42:04]: starting date and time: 2025-04-30 03:42:04+0000 0s autopkgtest [03:42:04]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [03:42:04]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.4i8p81i2/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-12 --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-12/12.22-0ubuntu0.20.04.3 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@lcy02-70.secgroup --name adt-focal-amd64-postgresql-common-20250430-034204-juju-7f2275-prod-proposed-migration-environment-2-57e30f57-1682-414c-a1a0-a6700b80a534 --image adt/ubuntu-focal-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 38s autopkgtest [03:42:42]: testbed dpkg architecture: amd64 38s autopkgtest [03:42:42]: testbed apt version: 2.0.10 38s autopkgtest [03:42:42]: @@@@@@@@@@@@@@@@@@@@ test bed setup 38s autopkgtest [03:42:42]: testbed release detected to be: None 39s autopkgtest [03:42:43]: updating testbed package index (apt update) 39s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 39s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 39s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 39s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 39s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [6856 B] 39s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.3 kB] 39s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [7128 B] 39s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [37.4 kB] 39s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [354 kB] 39s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [82.7 kB] 39s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1716 B] 39s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [577 kB] 39s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [9620 B] 39s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 39s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [25.1 kB] 39s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [41.2 kB] 39s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 39s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [3772 B] 39s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 39s Get:20 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 41s Fetched 1440 kB in 1s (2472 kB/s) 42s Reading package lists... 42s autopkgtest [03:42:46]: upgrading testbed (apt dist-upgrade and autopurge) 43s Reading package lists... 43s Building dependency tree... 43s Reading state information... 43s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 43s Starting 2 pkgProblemResolver with broken count: 0 43s Done 43s 43s The following packages will be upgraded: 43s distro-info-data libcryptsetup12 libxml2 43s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 43s Need to get 811 kB of archives. 43s After this operation, 0 B of additional disk space will be used. 43s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main amd64 distro-info-data all 0.43ubuntu1.18 [5020 B] 43s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcryptsetup12 amd64 2:2.2.2-3ubuntu2.5 [166 kB] 43s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxml2 amd64 2.9.10+dfsg-5ubuntu0.20.04.10 [640 kB] 44s Fetched 811 kB in 0s (16.6 MB/s) 44s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 97389 files and directories currently installed.) 44s Preparing to unpack .../distro-info-data_0.43ubuntu1.18_all.deb ... 44s Unpacking distro-info-data (0.43ubuntu1.18) over (0.43ubuntu1.17) ... 44s Preparing to unpack .../libcryptsetup12_2%3a2.2.2-3ubuntu2.5_amd64.deb ... 44s Unpacking libcryptsetup12:amd64 (2:2.2.2-3ubuntu2.5) over (2:2.2.2-3ubuntu2.4) ... 44s Preparing to unpack .../libxml2_2.9.10+dfsg-5ubuntu0.20.04.10_amd64.deb ... 44s Unpacking libxml2:amd64 (2.9.10+dfsg-5ubuntu0.20.04.10) over (2.9.10+dfsg-5ubuntu0.20.04.9) ... 44s Setting up distro-info-data (0.43ubuntu1.18) ... 44s Setting up libcryptsetup12:amd64 (2:2.2.2-3ubuntu2.5) ... 44s Setting up libxml2:amd64 (2.9.10+dfsg-5ubuntu0.20.04.10) ... 44s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 44s Reading package lists... 45s Building dependency tree... 45s Reading state information... 45s Starting pkgProblemResolver with broken count: 0 45s Starting 2 pkgProblemResolver with broken count: 0 45s Done 45s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 45s autopkgtest [03:42:49]: testbed running kernel: Linux 5.4.0-214-generic #234-Ubuntu SMP Fri Mar 14 23:50:27 UTC 2025 45s autopkgtest [03:42:49]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 49s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (dsc) [2534 B] 49s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (tar) [216 kB] 49s gpgv: Signature made Mon Aug 24 15:04:29 2020 UTC 49s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 49s gpgv: Can't check signature: No public key 49s dpkg-source: warning: failed to verify signature on ./postgresql-common_214ubuntu0.1.dsc 49s autopkgtest [03:42:53]: testing package postgresql-common version 214ubuntu0.1 49s autopkgtest [03:42:53]: build not needed 49s autopkgtest [03:42:53]: test default-psql: preparing testbed 49s Reading package lists... 49s Building dependency tree... 49s Reading state information... 49s Starting pkgProblemResolver with broken count: 0 49s Starting 2 pkgProblemResolver with broken count: 0 49s Done 50s The following NEW packages will be installed: 50s libllvm10 libpq5 libxslt1.1 postgresql postgresql-12 postgresql-client-12 50s postgresql-client-common postgresql-common ssl-cert 50s 0 upgraded, 9 newly installed, 0 to remove and 1 not upgraded. 50s Need to get 30.4 MB of archives. 50s After this operation, 121 MB of additional disk space will be used. 50s Get:1 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 50s Get:2 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 50s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 50s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 50s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 50s Get:6 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 50s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 50s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 50s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql all 12+214ubuntu0.1 [3924 B] 50s Preconfiguring packages ... 50s Fetched 30.4 MB in 0s (68.4 MB/s) 50s Selecting previously unselected package libllvm10:amd64. 50s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 97389 files and directories currently installed.) 50s Preparing to unpack .../0-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 50s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 52s Selecting previously unselected package libpq5:amd64. 52s Preparing to unpack .../1-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 52s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 52s Selecting previously unselected package libxslt1.1:amd64. 52s Preparing to unpack .../2-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 52s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 52s Selecting previously unselected package postgresql-client-common. 52s Preparing to unpack .../3-postgresql-client-common_214ubuntu0.1_all.deb ... 52s Unpacking postgresql-client-common (214ubuntu0.1) ... 52s Selecting previously unselected package postgresql-client-12. 52s Preparing to unpack .../4-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 52s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 52s Selecting previously unselected package ssl-cert. 52s Preparing to unpack .../5-ssl-cert_1.0.39_all.deb ... 52s Unpacking ssl-cert (1.0.39) ... 52s Selecting previously unselected package postgresql-common. 52s Preparing to unpack .../6-postgresql-common_214ubuntu0.1_all.deb ... 52s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 52s Unpacking postgresql-common (214ubuntu0.1) ... 52s Selecting previously unselected package postgresql-12. 52s Preparing to unpack .../7-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 52s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 53s Selecting previously unselected package postgresql. 53s Preparing to unpack .../8-postgresql_12+214ubuntu0.1_all.deb ... 53s Unpacking postgresql (12+214ubuntu0.1) ... 53s Setting up postgresql-client-common (214ubuntu0.1) ... 53s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 53s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 53s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 54s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 54s Setting up ssl-cert (1.0.39) ... 54s Setting up postgresql-common (214ubuntu0.1) ... 54s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 54s Adding user postgres to group ssl-cert 54s 54s Creating config file /etc/postgresql-common/createcluster.conf with new version 54s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 54s Removing obsolete dictionary files: 55s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 55s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 55s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 55s Creating new PostgreSQL cluster 12/main ... 55s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 56s The files belonging to this database system will be owned by user "postgres". 56s This user must also own the server process. 56s 56s The database cluster will be initialized with locale "C.UTF-8". 56s The default database encoding has accordingly been set to "UTF8". 56s The default text search configuration will be set to "english". 56s 56s Data page checksums are disabled. 56s 56s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 56s creating subdirectories ... ok 56s selecting dynamic shared memory implementation ... posix 56s selecting default max_connections ... 100 56s selecting default shared_buffers ... 128MB 56s selecting default time zone ... Etc/UTC 56s creating configuration files ... ok 56s running bootstrap script ... ok 56s performing post-bootstrap initialization ... ok 56s syncing data to disk ... ok 56s 56s Success. You can now start the database server using: 56s 56s pg_ctlcluster 12 main start 56s 56s Ver Cluster Port Status Owner Data directory Log file 56s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 56s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 59s Setting up postgresql (12+214ubuntu0.1) ... 59s Processing triggers for systemd (245.4-4ubuntu3.24) ... 59s Processing triggers for man-db (2.9.1-1) ... 61s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 61s autopkgtest [03:43:05]: test default-psql: [----------------------- 62s autopkgtest [03:43:06]: test default-psql: -----------------------] 62s autopkgtest [03:43:06]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 62s default-psql PASS 62s autopkgtest [03:43:06]: test run-testsuite: preparing testbed 129s autopkgtest [03:44:13]: testbed dpkg architecture: amd64 129s autopkgtest [03:44:13]: testbed apt version: 2.0.10 129s autopkgtest [03:44:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 129s autopkgtest [03:44:13]: testbed release detected to be: focal 129s autopkgtest [03:44:13]: updating testbed package index (apt update) 129s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 129s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 129s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 129s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 130s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/multiverse Sources [7128 B] 130s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [37.4 kB] 130s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.3 kB] 130s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [6856 B] 130s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 Packages [354 kB] 130s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/main i386 Packages [82.7 kB] 130s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 c-n-f Metadata [1716 B] 130s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/restricted i386 Packages [9620 B] 130s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 Packages [577 kB] 130s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/restricted amd64 c-n-f Metadata [116 B] 130s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 Packages [41.2 kB] 130s Get:16 http://ftpmaster.internal/ubuntu focal-proposed/universe i386 Packages [25.1 kB] 130s Get:17 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 c-n-f Metadata [1904 B] 130s Get:18 http://ftpmaster.internal/ubuntu focal-proposed/multiverse i386 Packages [760 B] 130s Get:19 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 Packages [3772 B] 130s Get:20 http://ftpmaster.internal/ubuntu focal-proposed/multiverse amd64 c-n-f Metadata [116 B] 132s Fetched 1440 kB in 1s (2440 kB/s) 133s Reading package lists... 133s autopkgtest [03:44:17]: upgrading testbed (apt dist-upgrade and autopurge) 133s Reading package lists... 134s Building dependency tree... 134s Reading state information... 134s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 134s Starting 2 pkgProblemResolver with broken count: 0 134s Done 134s 134s The following packages will be upgraded: 134s distro-info-data libcryptsetup12 libxml2 134s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s Need to get 811 kB of archives. 134s After this operation, 0 B of additional disk space will be used. 134s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main amd64 distro-info-data all 0.43ubuntu1.18 [5020 B] 134s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcryptsetup12 amd64 2:2.2.2-3ubuntu2.5 [166 kB] 134s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxml2 amd64 2.9.10+dfsg-5ubuntu0.20.04.10 [640 kB] 134s Fetched 811 kB in 0s (38.4 MB/s) 135s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 97389 files and directories currently installed.) 135s Preparing to unpack .../distro-info-data_0.43ubuntu1.18_all.deb ... 135s Unpacking distro-info-data (0.43ubuntu1.18) over (0.43ubuntu1.17) ... 135s Preparing to unpack .../libcryptsetup12_2%3a2.2.2-3ubuntu2.5_amd64.deb ... 135s Unpacking libcryptsetup12:amd64 (2:2.2.2-3ubuntu2.5) over (2:2.2.2-3ubuntu2.4) ... 135s Preparing to unpack .../libxml2_2.9.10+dfsg-5ubuntu0.20.04.10_amd64.deb ... 135s Unpacking libxml2:amd64 (2.9.10+dfsg-5ubuntu0.20.04.10) over (2.9.10+dfsg-5ubuntu0.20.04.9) ... 135s Setting up distro-info-data (0.43ubuntu1.18) ... 135s Setting up libcryptsetup12:amd64 (2:2.2.2-3ubuntu2.5) ... 135s Setting up libxml2:amd64 (2.9.10+dfsg-5ubuntu0.20.04.10) ... 135s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 135s Reading package lists... 135s Building dependency tree... 135s Reading state information... 135s Starting pkgProblemResolver with broken count: 0 135s Starting 2 pkgProblemResolver with broken count: 0 135s Done 136s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 136s Reading package lists... 137s Building dependency tree... 137s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 137s Starting 2 pkgProblemResolver with broken count: 0 137s Done 137s The following NEW packages will be installed: 137s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 137s emacsen-common fakeroot g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us 137s lib32gcc-s1 lib32stdc++6 libasan5 libatomic1 libc-dev-bin libc6-dev 137s libc6-i386 libcc1-0 libclang-common-10-dev libclang-cpp10 libclang1-10 137s libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 137s libgc1c2 libgcc-9-dev libgomp1 libisl22 libitm1 libllvm10 liblsan0 libmpc3 137s libncurses-dev libobjc-9-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 137s libpython3.8 libquadmath0 libstdc++-9-dev libtcl8.6 libtinfo-dev libtsan0 137s libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-10 llvm-10-dev 137s llvm-10-runtime llvm-10-tools net-tools postgresql-12 postgresql-all 137s postgresql-client-12 postgresql-client-common postgresql-common 137s postgresql-plperl-12 postgresql-plpython3-12 postgresql-pltcl-12 137s postgresql-server-dev-12 postgresql-server-dev-all python3-pygments ssl-cert 137s 0 upgraded, 74 newly installed, 0 to remove and 1 not upgraded. 137s Need to get 141 MB of archives. 137s After this operation, 738 MB of additional disk space will be used. 137s Get:1 http://ftpmaster.internal/ubuntu focal/universe amd64 binfmt-support amd64 2.2.0-2 [58.2 kB] 137s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.17 [71.8 kB] 137s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-214.234 [1116 kB] 137s Get:4 http://ftpmaster.internal/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB] 137s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.17 [2521 kB] 137s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 137s Get:7 http://ftpmaster.internal/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB] 137s Get:8 http://ftpmaster.internal/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB] 137s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.2 [7502 kB] 137s Get:10 http://ftpmaster.internal/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB] 137s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.5.0-1ubuntu1~20.04 [48.8 kB] 137s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgomp1 amd64 10.5.0-1ubuntu1~20.04 [102 kB] 137s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libitm1 amd64 10.5.0-1ubuntu1~20.04 [26.2 kB] 137s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libatomic1 amd64 10.5.0-1ubuntu1~20.04 [9284 B] 137s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.2 [2752 kB] 137s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main amd64 liblsan0 amd64 10.5.0-1ubuntu1~20.04 [835 kB] 137s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtsan0 amd64 10.5.0-1ubuntu1~20.04 [2016 kB] 137s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libubsan1 amd64 10.5.0-1ubuntu1~20.04 [785 kB] 137s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.5.0-1ubuntu1~20.04 [146 kB] 137s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [2359 kB] 137s Get:21 http://ftpmaster.internal/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.2 [8276 kB] 137s Get:22 http://ftpmaster.internal/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5208 B] 137s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libstdc++-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [1722 kB] 137s Get:24 http://ftpmaster.internal/ubuntu focal-updates/main amd64 g++-9 amd64 9.4.0-1ubuntu1~20.04.2 [8421 kB] 137s Get:25 http://ftpmaster.internal/ubuntu focal/main amd64 g++ amd64 4:9.3.0-1ubuntu2 [1604 B] 137s Get:26 http://ftpmaster.internal/ubuntu focal-updates/main amd64 build-essential amd64 12.8ubuntu1.1 [4664 B] 137s Get:27 http://ftpmaster.internal/ubuntu focal/main amd64 libllvm10 amd64 1:10.0.0-4ubuntu1 [15.3 MB] 138s Get:28 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-cpp10 amd64 1:10.0.0-4ubuntu1 [9944 kB] 138s Get:29 http://ftpmaster.internal/ubuntu focal/main amd64 libgc1c2 amd64 1:7.6.4-0.4ubuntu1 [83.9 kB] 138s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc4 amd64 10.5.0-1ubuntu1~20.04 [42.8 kB] 138s Get:31 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 libobjc-9-dev amd64 9.4.0-1ubuntu1~20.04.2 [225 kB] 138s Get:32 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libc6-i386 amd64 2.31-0ubuntu9.17 [2726 kB] 138s Get:33 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32gcc-s1 amd64 10.5.0-1ubuntu1~20.04 [49.1 kB] 138s Get:34 http://ftpmaster.internal/ubuntu focal-updates/main amd64 lib32stdc++6 amd64 10.5.0-1ubuntu1~20.04 [522 kB] 138s Get:35 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang-common-10-dev amd64 1:10.0.0-4ubuntu1 [5012 kB] 138s Get:36 http://ftpmaster.internal/ubuntu focal/universe amd64 libclang1-10 amd64 1:10.0.0-4ubuntu1 [7571 kB] 138s Get:37 http://ftpmaster.internal/ubuntu focal/universe amd64 clang-10 amd64 1:10.0.0-4ubuntu1 [66.9 kB] 138s Get:38 http://ftpmaster.internal/ubuntu focal/main amd64 emacsen-common all 3.0.4 [14.9 kB] 138s Get:39 http://ftpmaster.internal/ubuntu focal/main amd64 dictionaries-common all 1.28.1 [178 kB] 138s Get:40 http://ftpmaster.internal/ubuntu focal/main amd64 libfakeroot amd64 1.24-1 [25.7 kB] 138s Get:41 http://ftpmaster.internal/ubuntu focal/main amd64 fakeroot amd64 1.24-1 [62.6 kB] 138s Get:42 http://ftpmaster.internal/ubuntu focal/main amd64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 138s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpgtypes3 amd64 12.22-0ubuntu0.20.04.3 [45.7 kB] 138s Get:44 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq5 amd64 12.22-0ubuntu0.20.04.3 [118 kB] 138s Get:45 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg6 amd64 12.22-0ubuntu0.20.04.3 [43.4 kB] 138s Get:46 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-compat3 amd64 12.22-0ubuntu0.20.04.3 [12.7 kB] 138s Get:47 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libpq-dev amd64 12.22-0ubuntu0.20.04.3 [138 kB] 138s Get:48 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 libecpg-dev amd64 12.22-0ubuntu0.20.04.3 [239 kB] 138s Get:49 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libncurses-dev amd64 6.2-0ubuntu2.1 [340 kB] 138s Get:50 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libpython3.8 amd64 3.8.10-0ubuntu1~20.04.18 [1625 kB] 138s Get:51 http://ftpmaster.internal/ubuntu focal/main amd64 libtcl8.6 amd64 8.6.10+dfsg-1 [902 kB] 138s Get:52 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libtinfo-dev amd64 6.2-0ubuntu2.1 [972 B] 138s Get:53 http://ftpmaster.internal/ubuntu focal-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.20.04.3 [151 kB] 138s Get:54 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-runtime amd64 1:10.0.0-4ubuntu1 [180 kB] 138s Get:55 http://ftpmaster.internal/ubuntu focal/main amd64 libpfm4 amd64 4.10.1+git20-g7700f49-2 [266 kB] 138s Get:56 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10 amd64 1:10.0.0-4ubuntu1 [5214 kB] 138s Get:57 http://ftpmaster.internal/ubuntu focal/main amd64 libffi-dev amd64 3.3-4 [57.0 kB] 138s Get:58 http://ftpmaster.internal/ubuntu focal-updates/main amd64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 138s Get:59 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-tools amd64 1:10.0.0-4ubuntu1 [317 kB] 138s Get:60 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-4 amd64 4.8.7-4build1 [6792 kB] 138s Get:61 http://ftpmaster.internal/ubuntu focal/universe amd64 libz3-dev amd64 4.8.7-4build1 [67.5 kB] 138s Get:62 http://ftpmaster.internal/ubuntu focal/universe amd64 llvm-10-dev amd64 1:10.0.0-4ubuntu1 [26.0 MB] 139s Get:63 http://ftpmaster.internal/ubuntu focal/main amd64 net-tools amd64 1.60+git20180626.aebd88e-1ubuntu1 [196 kB] 139s Get:64 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 139s Get:65 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-client-12 amd64 12.22-0ubuntu0.20.04.3 [1073 kB] 139s Get:66 http://ftpmaster.internal/ubuntu focal/main amd64 ssl-cert all 1.0.39 [17.0 kB] 139s Get:67 http://ftpmaster.internal/ubuntu focal-updates/main amd64 postgresql-common all 214ubuntu0.1 [169 kB] 139s Get:68 http://ftpmaster.internal/ubuntu focal-proposed/main amd64 postgresql-12 amd64 12.22-0ubuntu0.20.04.3 [13.6 MB] 139s Get:69 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-server-dev-12 amd64 12.22-0ubuntu0.20.04.3 [995 kB] 139s Get:70 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-server-dev-all all 214ubuntu0.1 [7652 B] 139s Get:71 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plperl-12 amd64 12.22-0ubuntu0.20.04.3 [68.6 kB] 139s Get:72 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-plpython3-12 amd64 12.22-0ubuntu0.20.04.3 [76.5 kB] 139s Get:73 http://ftpmaster.internal/ubuntu focal-proposed/universe amd64 postgresql-pltcl-12 amd64 12.22-0ubuntu0.20.04.3 [31.6 kB] 139s Get:74 http://ftpmaster.internal/ubuntu focal-updates/universe amd64 postgresql-all all 12+214ubuntu0.1 [1924 B] 139s Preconfiguring packages ... 139s Fetched 141 MB in 2s (77.0 MB/s) 140s Selecting previously unselected package binfmt-support. 140s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 97389 files and directories currently installed.) 140s Preparing to unpack .../00-binfmt-support_2.2.0-2_amd64.deb ... 140s Unpacking binfmt-support (2.2.0-2) ... 140s Selecting previously unselected package libc-dev-bin. 140s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_amd64.deb ... 140s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 140s Selecting previously unselected package linux-libc-dev:amd64. 140s Preparing to unpack .../02-linux-libc-dev_5.4.0-214.234_amd64.deb ... 140s Unpacking linux-libc-dev:amd64 (5.4.0-214.234) ... 140s Selecting previously unselected package libcrypt-dev:amd64. 140s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb ... 140s Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 140s Selecting previously unselected package libc6-dev:amd64. 140s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_amd64.deb ... 140s Unpacking libc6-dev:amd64 (2.31-0ubuntu9.17) ... 140s Selecting previously unselected package gcc-9-base:amd64. 140s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 140s Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 140s Selecting previously unselected package libisl22:amd64. 140s Preparing to unpack .../06-libisl22_0.22.1-1_amd64.deb ... 140s Unpacking libisl22:amd64 (0.22.1-1) ... 140s Selecting previously unselected package libmpc3:amd64. 140s Preparing to unpack .../07-libmpc3_1.1.0-1_amd64.deb ... 140s Unpacking libmpc3:amd64 (1.1.0-1) ... 140s Selecting previously unselected package cpp-9. 140s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 140s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 141s Selecting previously unselected package cpp. 141s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_amd64.deb ... 141s Unpacking cpp (4:9.3.0-1ubuntu2) ... 141s Selecting previously unselected package libcc1-0:amd64. 141s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libgomp1:amd64. 141s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libitm1:amd64. 141s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libatomic1:amd64. 141s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libasan5:amd64. 141s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 141s Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 141s Selecting previously unselected package liblsan0:amd64. 141s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 141s Selecting previously unselected package libtsan0:amd64. 141s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_amd64.deb ... 141s Unpacking libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 142s Selecting previously unselected package libubsan1:amd64. 142s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_amd64.deb ... 142s Unpacking libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 142s Selecting previously unselected package libquadmath0:amd64. 142s Preparing to unpack .../18-libquadmath0_10.5.0-1ubuntu1~20.04_amd64.deb ... 142s Unpacking libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 142s Selecting previously unselected package libgcc-9-dev:amd64. 142s Preparing to unpack .../19-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 142s Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 142s Selecting previously unselected package gcc-9. 142s Preparing to unpack .../20-gcc-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 142s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 143s Selecting previously unselected package gcc. 143s Preparing to unpack .../21-gcc_4%3a9.3.0-1ubuntu2_amd64.deb ... 143s Unpacking gcc (4:9.3.0-1ubuntu2) ... 143s Selecting previously unselected package libstdc++-9-dev:amd64. 143s Preparing to unpack .../22-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 143s Unpacking libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 143s Selecting previously unselected package g++-9. 143s Preparing to unpack .../23-g++-9_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 143s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 144s Selecting previously unselected package g++. 144s Preparing to unpack .../24-g++_4%3a9.3.0-1ubuntu2_amd64.deb ... 144s Unpacking g++ (4:9.3.0-1ubuntu2) ... 144s Selecting previously unselected package build-essential. 144s Preparing to unpack .../25-build-essential_12.8ubuntu1.1_amd64.deb ... 144s Unpacking build-essential (12.8ubuntu1.1) ... 144s Selecting previously unselected package libllvm10:amd64. 144s Preparing to unpack .../26-libllvm10_1%3a10.0.0-4ubuntu1_amd64.deb ... 144s Unpacking libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 145s Selecting previously unselected package libclang-cpp10. 145s Preparing to unpack .../27-libclang-cpp10_1%3a10.0.0-4ubuntu1_amd64.deb ... 145s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 146s Selecting previously unselected package libgc1c2:amd64. 146s Preparing to unpack .../28-libgc1c2_1%3a7.6.4-0.4ubuntu1_amd64.deb ... 146s Unpacking libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 146s Selecting previously unselected package libobjc4:amd64. 146s Preparing to unpack .../29-libobjc4_10.5.0-1ubuntu1~20.04_amd64.deb ... 146s Unpacking libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 146s Selecting previously unselected package libobjc-9-dev:amd64. 146s Preparing to unpack .../30-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_amd64.deb ... 146s Unpacking libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 146s Selecting previously unselected package libc6-i386. 146s Preparing to unpack .../31-libc6-i386_2.31-0ubuntu9.17_amd64.deb ... 146s Unpacking libc6-i386 (2.31-0ubuntu9.17) ... 146s Selecting previously unselected package lib32gcc-s1. 146s Preparing to unpack .../32-lib32gcc-s1_10.5.0-1ubuntu1~20.04_amd64.deb ... 146s Unpacking lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 146s Selecting previously unselected package lib32stdc++6. 146s Preparing to unpack .../33-lib32stdc++6_10.5.0-1ubuntu1~20.04_amd64.deb ... 146s Unpacking lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 146s Selecting previously unselected package libclang-common-10-dev. 146s Preparing to unpack .../34-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 146s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 147s Selecting previously unselected package libclang1-10. 147s Preparing to unpack .../35-libclang1-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 147s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 148s Selecting previously unselected package clang-10. 148s Preparing to unpack .../36-clang-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 148s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 148s Selecting previously unselected package emacsen-common. 148s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 148s Unpacking emacsen-common (3.0.4) ... 148s Selecting previously unselected package dictionaries-common. 148s Preparing to unpack .../38-dictionaries-common_1.28.1_all.deb ... 148s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 148s Unpacking dictionaries-common (1.28.1) ... 148s Selecting previously unselected package libfakeroot:amd64. 148s Preparing to unpack .../39-libfakeroot_1.24-1_amd64.deb ... 148s Unpacking libfakeroot:amd64 (1.24-1) ... 148s Selecting previously unselected package fakeroot. 148s Preparing to unpack .../40-fakeroot_1.24-1_amd64.deb ... 148s Unpacking fakeroot (1.24-1) ... 148s Selecting previously unselected package hunspell-en-us. 148s Preparing to unpack .../41-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 148s Unpacking hunspell-en-us (1:2018.04.16-1) ... 148s Selecting previously unselected package libpgtypes3:amd64. 148s Preparing to unpack .../42-libpgtypes3_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libpq5:amd64. 148s Preparing to unpack .../43-libpq5_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libecpg6:amd64. 148s Preparing to unpack .../44-libecpg6_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libecpg-compat3:amd64. 148s Preparing to unpack .../45-libecpg-compat3_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libpq-dev. 148s Preparing to unpack .../46-libpq-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libecpg-dev. 148s Preparing to unpack .../47-libecpg-dev_12.22-0ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 148s Selecting previously unselected package libncurses-dev:amd64. 148s Preparing to unpack .../48-libncurses-dev_6.2-0ubuntu2.1_amd64.deb ... 148s Unpacking libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 148s Selecting previously unselected package libpython3.8:amd64. 148s Preparing to unpack .../49-libpython3.8_3.8.10-0ubuntu1~20.04.18_amd64.deb ... 148s Unpacking libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 148s Selecting previously unselected package libtcl8.6:amd64. 148s Preparing to unpack .../50-libtcl8.6_8.6.10+dfsg-1_amd64.deb ... 148s Unpacking libtcl8.6:amd64 (8.6.10+dfsg-1) ... 148s Selecting previously unselected package libtinfo-dev:amd64. 148s Preparing to unpack .../51-libtinfo-dev_6.2-0ubuntu2.1_amd64.deb ... 148s Unpacking libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 148s Selecting previously unselected package libxslt1.1:amd64. 148s Preparing to unpack .../52-libxslt1.1_1.1.34-4ubuntu0.20.04.3_amd64.deb ... 148s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 148s Selecting previously unselected package llvm-10-runtime. 148s Preparing to unpack .../53-llvm-10-runtime_1%3a10.0.0-4ubuntu1_amd64.deb ... 148s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 148s Selecting previously unselected package libpfm4:amd64. 149s Preparing to unpack .../54-libpfm4_4.10.1+git20-g7700f49-2_amd64.deb ... 149s Unpacking libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 149s Selecting previously unselected package llvm-10. 149s Preparing to unpack .../55-llvm-10_1%3a10.0.0-4ubuntu1_amd64.deb ... 149s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 149s Selecting previously unselected package libffi-dev:amd64. 149s Preparing to unpack .../56-libffi-dev_3.3-4_amd64.deb ... 149s Unpacking libffi-dev:amd64 (3.3-4) ... 149s Selecting previously unselected package python3-pygments. 149s Preparing to unpack .../57-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 149s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 149s Selecting previously unselected package llvm-10-tools. 149s Preparing to unpack .../58-llvm-10-tools_1%3a10.0.0-4ubuntu1_amd64.deb ... 149s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 149s Selecting previously unselected package libz3-4:amd64. 149s Preparing to unpack .../59-libz3-4_4.8.7-4build1_amd64.deb ... 149s Unpacking libz3-4:amd64 (4.8.7-4build1) ... 150s Selecting previously unselected package libz3-dev:amd64. 150s Preparing to unpack .../60-libz3-dev_4.8.7-4build1_amd64.deb ... 150s Unpacking libz3-dev:amd64 (4.8.7-4build1) ... 150s Selecting previously unselected package llvm-10-dev. 150s Preparing to unpack .../61-llvm-10-dev_1%3a10.0.0-4ubuntu1_amd64.deb ... 150s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 152s Selecting previously unselected package net-tools. 152s Preparing to unpack .../62-net-tools_1.60+git20180626.aebd88e-1ubuntu1_amd64.deb ... 152s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 152s Selecting previously unselected package postgresql-client-common. 152s Preparing to unpack .../63-postgresql-client-common_214ubuntu0.1_all.deb ... 152s Unpacking postgresql-client-common (214ubuntu0.1) ... 152s Selecting previously unselected package postgresql-client-12. 152s Preparing to unpack .../64-postgresql-client-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 152s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 153s Selecting previously unselected package ssl-cert. 153s Preparing to unpack .../65-ssl-cert_1.0.39_all.deb ... 153s Unpacking ssl-cert (1.0.39) ... 153s Selecting previously unselected package postgresql-common. 153s Preparing to unpack .../66-postgresql-common_214ubuntu0.1_all.deb ... 153s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 153s Unpacking postgresql-common (214ubuntu0.1) ... 153s Selecting previously unselected package postgresql-12. 153s Preparing to unpack .../67-postgresql-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 153s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 154s Selecting previously unselected package postgresql-server-dev-12. 154s Preparing to unpack .../68-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 154s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 154s Selecting previously unselected package postgresql-server-dev-all. 154s Preparing to unpack .../69-postgresql-server-dev-all_214ubuntu0.1_all.deb ... 154s Unpacking postgresql-server-dev-all (214ubuntu0.1) ... 154s Selecting previously unselected package postgresql-plperl-12. 154s Preparing to unpack .../70-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 154s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 154s Selecting previously unselected package postgresql-plpython3-12. 154s Preparing to unpack .../71-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 154s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 154s Selecting previously unselected package postgresql-pltcl-12. 154s Preparing to unpack .../72-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_amd64.deb ... 154s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 154s Selecting previously unselected package postgresql-all. 154s Preparing to unpack .../73-postgresql-all_12+214ubuntu0.1_all.deb ... 154s Unpacking postgresql-all (12+214ubuntu0.1) ... 154s Setting up postgresql-client-common (214ubuntu0.1) ... 154s Setting up libpgtypes3:amd64 (12.22-0ubuntu0.20.04.3) ... 154s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 154s Setting up libgc1c2:amd64 (1:7.6.4-0.4ubuntu1) ... 154s Setting up libpq5:amd64 (12.22-0ubuntu0.20.04.3) ... 154s Setting up linux-libc-dev:amd64 (5.4.0-214.234) ... 154s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 154s Setting up libobjc4:amd64 (10.5.0-1ubuntu1~20.04) ... 154s Setting up libgomp1:amd64 (10.5.0-1ubuntu1~20.04) ... 154s Setting up libffi-dev:amd64 (3.3-4) ... 154s Setting up libfakeroot:amd64 (1.24-1) ... 154s Setting up libllvm10:amd64 (1:10.0.0-4ubuntu1) ... 154s Setting up fakeroot (1.24-1) ... 154s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 154s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 154s Setting up libz3-4:amd64 (4.8.7-4build1) ... 154s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 155s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 155s Setting up libpfm4:amd64 (4.10.1+git20-g7700f49-2) ... 155s Setting up emacsen-common (3.0.4) ... 155s Setting up ssl-cert (1.0.39) ... 155s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 155s Setting up libpython3.8:amd64 (3.8.10-0ubuntu1~20.04.18) ... 155s Setting up libquadmath0:amd64 (10.5.0-1ubuntu1~20.04) ... 155s Setting up postgresql-common (214ubuntu0.1) ... 155s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 155s Adding user postgres to group ssl-cert 155s 155s Creating config file /etc/postgresql-common/createcluster.conf with new version 155s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 155s en_us 155s Removing obsolete dictionary files: 156s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 156s Setting up libmpc3:amd64 (1.1.0-1) ... 156s Setting up libatomic1:amd64 (10.5.0-1ubuntu1~20.04) ... 156s Setting up libtcl8.6:amd64 (8.6.10+dfsg-1) ... 156s Setting up binfmt-support (2.2.0-2) ... 157s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 157s Setting up libubsan1:amd64 (10.5.0-1ubuntu1~20.04) ... 157s Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) ... 157s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.20.04.3) ... 157s Setting up libecpg6:amd64 (12.22-0ubuntu0.20.04.3) ... 157s Setting up libc6-i386 (2.31-0ubuntu9.17) ... 157s Setting up libisl22:amd64 (0.22.1-1) ... 157s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 157s Creating new PostgreSQL cluster 12/main ... 157s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 157s The files belonging to this database system will be owned by user "postgres". 157s This user must also own the server process. 157s 157s The database cluster will be initialized with locale "C.UTF-8". 157s The default database encoding has accordingly been set to "UTF8". 157s The default text search configuration will be set to "english". 157s 157s Data page checksums are disabled. 157s 157s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 157s creating subdirectories ... ok 157s selecting dynamic shared memory implementation ... posix 157s selecting default max_connections ... 100 157s selecting default shared_buffers ... 128MB 157s selecting default time zone ... Etc/UTC 157s creating configuration files ... ok 158s running bootstrap script ... ok 158s performing post-bootstrap initialization ... ok 158s syncing data to disk ... ok 158s 158s Success. You can now start the database server using: 158s 158s pg_ctlcluster 12 main start 158s 158s Ver Cluster Port Status Owner Data directory Log file 158s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 158s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 161s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 161s Setting up libcc1-0:amd64 (10.5.0-1ubuntu1~20.04) ... 161s Setting up liblsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 161s Setting up libitm1:amd64 (10.5.0-1ubuntu1~20.04) ... 161s Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up libtsan0:amd64 (10.5.0-1ubuntu1~20.04) ... 161s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 161s Setting up libz3-dev:amd64 (4.8.7-4build1) ... 161s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 161s Setting up libecpg-compat3:amd64 (12.22-0ubuntu0.20.04.3) ... 161s Setting up dictionaries-common (1.28.1) ... 161s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 161s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 161s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 161s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 161s Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up lib32gcc-s1 (10.5.0-1ubuntu1~20.04) ... 161s Setting up lib32stdc++6 (10.5.0-1ubuntu1~20.04) ... 161s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 161s Setting up hunspell-en-us (1:2018.04.16-1) ... 161s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up libc6-dev:amd64 (2.31-0ubuntu9.17) ... 161s Setting up libncurses-dev:amd64 (6.2-0ubuntu2.1) ... 161s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 161s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 161s Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 161s Setting up libobjc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up cpp (4:9.3.0-1ubuntu2) ... 161s Setting up libtinfo-dev:amd64 (6.2-0ubuntu2.1) ... 161s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up libstdc++-9-dev:amd64 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up gcc (4:9.3.0-1ubuntu2) ... 161s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 161s Setting up g++ (4:9.3.0-1ubuntu2) ... 161s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 161s Setting up build-essential (12.8ubuntu1.1) ... 161s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 161s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 161s Setting up postgresql-server-dev-all (214ubuntu0.1) ... 161s Setting up postgresql-all (12+214ubuntu0.1) ... 161s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 162s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 162s Processing triggers for systemd (245.4-4ubuntu3.24) ... 162s Processing triggers for man-db (2.9.1-1) ... 164s Processing triggers for dictionaries-common (1.28.1) ... 165s autopkgtest [03:44:49]: test run-testsuite: [----------------------- 165s Generating locales (this might take a while)... 166s en_US.UTF-8... done 167s ru_RU.ISO-8859-5... done 168s ru_RU.UTF-8... done 168s Generation complete. 168s ====== Running all tests with umask 077 ======= 168s === Running test 001_packages.t ... === 168s 1..18 168s # PostgreSQL versions installed: 12 168s ok 1 - postgresql-12 installed 168s ok 2 # skip No python2 support 168s ok 3 - postgresql-plpython3-12 installed 168s ok 4 - postgresql-plperl-12 installed 168s ok 5 - postgresql-pltcl-12 installed 168s ok 6 - postgresql-server-dev-12 installed 168s ok 7 # skip No postgresql-contrib-12 package for version 12 168s ok 8 - libecpg-dev installed 168s ok 9 - procps installed 168s ok 10 - netcat-openbsd installed 169s ok 11 - hunspell-en-us installed 169s ok 12 - system has a default UTF-8 locale 169s ok 13 - locale ru_RU exists 169s ok 14 - locale ru_RU.UTF-8 exists 169s ok 15 - user postgres in the UNIX group ssl-cert 169s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 169s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 169s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 169s === Running test 002_existing_clusters.t ... === 169s 1..8 169s ok 1 - Cleanup: No clusters left behind 169s ok 2 - No postgres processes left behind 169s ok 3 - No files in /etc/postgresql left behind 169s ok 4 - No files in /var/lib/postgresql left behind 169s ok 5 - No files in /var/run/postgresql left behind 169s ok 6 - No files in /var/log/postgresql left behind 169s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 169s ok 8 - PostgreSQL TCP ports are closed 169s === Running test 003_package_checks.t ... === 169s 1..4 169s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 169s ok 2 - psql is linked against libedit 169s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 169s ok 4 - psql is not linked against libreadline 169s === Running test 005_PgCommon.t ... === 169s 1..24 169s ok 1 - correctly parsed line 'local all postgres ident sameuser' 169s ok 2 - correctly parsed line 'local foo nobody trust' 169s ok 3 - correctly parsed line 'local foo nobody crypt' 169s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 169s ok 5 - correctly parsed line 'local foo,bar nobody ident' 169s ok 6 - correctly parsed line 'local all +foogrp password' 169s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 169s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 169s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 169s ok 10 - @expected_records has correct number of entries 169s ok 11 - returned read_pg_hba array has correct number of records 169s ok 12 - line 'foo all all md5' parsed as invalid 169s ok 13 - line 'local all all foo' parsed as invalid 169s ok 14 - line 'host all all foo' parsed as invalid 169s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 169s ok 16 - line 'host all all md5' parsed as invalid 169s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 169s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 169s ok 19 - read_conf_file returns empty dict for nonexisting file 169s ok 20 - read_conf_file() parsing 169s ok 21 - read_conf_file() parsing with include directives 169s ok 22 - set_conf_value 169s ok 23 - disable_conf_value 169s ok 24 - replace_conf_value 169s === Running test 006_next_free_port.t ... === 169s 1..5 169s ok 1 - next_free_port is 5432 170s ok 2 - next_free_port detects localhost ipv4 socket 170s ok 3 - next_free_port detects wildcard ipv4 socket 171s ok 4 - next_free_port detects localhost ipv6 socket 171s ok 5 - next_free_port detects wildcard ipv6 socket 171s === Running test 007_pg_conftool.t ... === 171s 1..41 171s # test without cluster 171s ok 1 - pg_conftool show all 171s ok 2 - correct output of pg_conftool show all 171s ok 3 - pg_conftool foo.conf show all 171s ok 4 - correct output of pg_conftool foo.conf show all 171s ok 5 - pg_conftool /tmp/bYgpeAbZX2/different.conf show all 171s ok 6 - correct output of pg_conftool /tmp/bYgpeAbZX2/different.conf show all 172s ok 7 - pg_conftool 9.7 main show all 172s ok 8 - correct output of pg_conftool 9.7 main show all 172s # test show 172s ok 9 - pg_conftool show all 172s ok 10 - correct output of pg_conftool show all 172s ok 11 - pg_conftool other.conf show all 172s ok 12 - correct output of pg_conftool other.conf show all 172s ok 13 - pg_conftool /tmp/bYgpeAbZX2/different.conf show all 172s ok 14 - correct output of pg_conftool /tmp/bYgpeAbZX2/different.conf show all 172s ok 15 - pg_conftool 12 main show all 172s ok 16 - correct output of pg_conftool 12 main show all 172s ok 17 - pg_conftool 12 main other.conf show all 172s ok 18 - correct output of pg_conftool 12 main other.conf show all 172s ok 19 - pg_conftool show a 172s ok 20 - correct output of pg_conftool show a 172s ok 21 - pg_conftool -s show a 172s ok 22 - correct output of pg_conftool -s show a 172s # test set 172s ok 23 - pg_conftool set c 7 172s ok 24 - correct output of pg_conftool set c 7 172s ok 25 - file contains new setting 172s ok 26 - pg_conftool set a 8 172s ok 27 - correct output of pg_conftool set a 8 172s ok 28 - file contains updated setting 172s ok 29 - pg_conftool /tmp/bYgpeAbZX2/different.conf set a 9 172s ok 30 - correct output of pg_conftool /tmp/bYgpeAbZX2/different.conf set a 9 172s ok 31 - file with path contains updated setting 172s # test remove 172s ok 32 - pg_conftool remove a 172s ok 33 - correct output of pg_conftool remove a 172s ok 34 - setting removed from file 172s ok 35 - pg_conftool /tmp/bYgpeAbZX2/different.conf remove a 172s ok 36 - correct output of pg_conftool /tmp/bYgpeAbZX2/different.conf remove a 172s ok 37 - setting removed from file with path 172s # test edit 172s ok 38 - pg_conftool edit 172s ok 39 - correct output of pg_conftool edit 172s ok 40 - pg_conftool /tmp/bYgpeAbZX2/different.conf edit 172s ok 41 - correct output of pg_conftool /tmp/bYgpeAbZX2/different.conf edit 172s === Running test 010_defaultport_cluster.t ... === 172s 1..14 172s ok 1 - psql --version 172s ok 2 - pg_wrapper selects highest available version number 172s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 172s ok 4 - connecting to localhost fails with no clusters 172s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 172s ok 6 - pg_wrapper uses host and port from PGCLUSTER 172s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 172s ok 8 - pg_wrapper uses --cluster from the command line 172s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 172s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 172s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 172s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 172s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 172s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 172s === Running test 015_start_stop.t ... === 172s 1..71 172s # We are running systemd 172s # Running tests for 12 172s # Cluster does not exist yet 172s ok 1 - cluster 12 main does not exist 172s ok 2 - service postgresql@12-main does not exist 173s ok 3 - systemctl start postgresql 173s ok 4 - cluster 12 main does not exist 173s ok 5 - service postgresql@12-main does not exist 173s ok 6 - systemctl start postgresql@12-main 173s ok 7 - cluster 12 main does not exist 173s ok 8 - service postgresql@12-main does not exist 173s # Start/stop postgresql using system tools 173s ok 9 - pg_createcluster 12 main 173s ok 10 - cluster 12 main is stopped 173s ok 11 - service postgresql@12-main is stopped 176s ok 12 - systemctl start postgresql 176s ok 13 - cluster 12 main is running 176s ok 14 - service postgresql@12-main is running 176s ok 15 - systemctl start postgresql 176s ok 16 - cluster 12 main is already running 176s ok 17 - service postgresql@12-main is already running 176s ok 18 - systemctl stop postgresql 182s ok 19 - cluster 12 main is stopped 182s ok 20 - service postgresql@12-main is stopped 182s ok 21 - systemctl stop postgresql 182s ok 22 - cluster 12 main is already stopped 182s ok 23 - service postgresql@12-main is already stopped 182s # Start/stop specific cluster using system tools 184s ok 24 - systemctl start postgresql@12-main 184s ok 25 - cluster 12 main is running 184s ok 26 - service postgresql@12-main is running 184s ok 27 - systemctl start postgresql@12-main 184s ok 28 - cluster 12 main is running 184s ok 29 - service postgresql@12-main is running 187s ok 30 - systemctl restart postgresql@12-main 187s ok 31 - cluster 12 main is running 187s ok 32 - service postgresql@12-main is running 187s ok 33 - systemctl stop postgresql@12-main 187s ok 34 - cluster 12 main is stopped 187s ok 35 - service postgresql@12-main is stopped 187s ok 36 - systemctl stop postgresql@12-main 187s ok 37 - cluster 12 main is already stopped 187s ok 38 - service postgresql@12-main is already stopped 187s ok 39 - pg_dropcluster 12 main 187s ok 40 - cluster 12 main does not exist 187s ok 41 - service postgresql@12-main does not exist 187s # Start/stop specific cluster using pg_*cluster 187s ok 42 - pg_ctlcluster start 12 main 187s ok 43 - cluster 12 main does not exist 187s ok 44 - service postgresql@12-main does not exist 190s ok 45 - pg_createcluster 12 main --start 190s ok 46 - cluster 12 main is running 190s ok 47 - service postgresql@12-main is running 190s ok 48 - pg_ctlcluster 12 main start 191s ok 49 - cluster 12 main is already running 191s ok 50 - service postgresql@12-main is already running 193s ok 51 - pg_ctlcluster 12-main restart 193s ok 52 - cluster 12 main is running 193s ok 53 - service postgresql@12-main is running 193s ok 54 - pg_ctlcluster 12 main stop 193s ok 55 - cluster 12 main is stopped 193s ok 56 - service postgresql@12-main is stopped 193s ok 57 - pg_ctlcluster 12 main stop 193s ok 58 - cluster 12 main is already stopped 193s ok 59 - service postgresql@12-main is already stopped 195s ok 60 - pg_ctlcluster start 12-main 196s ok 61 - cluster 12 main is running 196s ok 62 - service postgresql@12-main is running 196s ok 63 - pg_dropcluster 12 main --stop 196s ok 64 - Cleanup: No clusters left behind 196s ok 65 - No postgres processes left behind 196s ok 66 - No files in /etc/postgresql left behind 196s ok 67 - No files in /var/lib/postgresql left behind 196s ok 68 - No files in /var/run/postgresql left behind 196s ok 69 - No files in /var/log/postgresql left behind 196s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 196s ok 71 - PostgreSQL TCP ports are closed 196s === Running test 020_create_sql_remove.t ... === 196s 1..144 196s # Running tests for 12 199s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.Z5S8SM 199s ok 2 - pg_createcluster 12 main 199s ok 3 - Socket and pid file are in /var/run/postgresql/ 199s ok 4 - xlog/wal directory /tmp/12.xlog.Z5S8SM was created 199s ok 5 - Exactly one postgres master process running 201s ok 6 - pg_ctlcluster 12 main restart 201s ok 7 - cluster restarts with new environment file 201s ok 8 - Exactly one postgres master process running 202s ok 9 - correct value of PGEXTRAVAR1 in environment 202s ok 10 - correct value of PGEXTRAVAR2 in environment 202s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 202s ok 12 - createdb --version 202s ok 13 - pg_wrapper selects version number of cluster 202s ok 14 - psql --version 202s ok 15 - pg_wrapper selects version number of cluster 202s ok 16 - pg_lscluster reports online cluster on port 5432 202s ok 17 - log file is actually used 202s ok 18 - /etc/postgresql is owned by user "postgres" 202s ok 19 - version configuration directory file is owned by user "postgres" 202s ok 20 - configuration directory file is owned by user "postgres" 202s ok 21 - version data directory file is owned by user "postgres" 202s ok 22 - data directory file is owned by user "postgres" 202s ok 23 - log file has 0640 permissions 202s ok 24 - log file is owned by user "postgres" 202s ok 25 - log file is owned by group "adm" 202s ok 26 - no log symlink by default 202s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 202s ok 28 - pg_lsclusters -h 202s ok 29 - correct output of pg_lsclusters -h 202s ok 30 - stopping cluster 204s ok 31 - restarting cluster with nondefault log symlink 204s ok 32 - log target is used as log file 204s ok 33 - default log is not used 204s ok 34 - pg_lsclusters -h 204s ok 35 - correct output of pg_lsclusters -h 204s ok 36 - stopping cluster 206s ok 37 - restarting cluster with explicitly configured log file 206s ok 38 - default log is not used 206s ok 39 - log symlink target is used for startup message 206s ok 40 - exactly one log file 206s ok 41 - custom log is actually used 206s ok 42 - pg_lsclusters -h 206s ok 43 - correct output of pg_lsclusters -h 207s ok 44 - stopping cluster 207s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 207s ok 46 - /etc/postgres-hack was not created 209s ok 47 - restarting cluster 209s ok 48 - ps -o tty -U postgres h 209s ok 49 - postgres processes do not have an associated terminal 209s ok 50 - SSL is enabled 209s ok 51 - psql -l fails for nobody 209s ok 52 - createuser nobody 209s ok 53 - createdb nobodydb 209s ok 54 - psql -ltA succeeds for nobody 209s ok 55 - psql -ltA output 209s ok 56 - SQL command: create table 209s ok 57 - SQL command: insert into table values 209s ok 58 - SQL command: insert into table values 209s ok 59 - primary key violation 209s ok 60 - psql -tAc "select * from phone order by name" nobodydb 209s ok 61 - SQL command output: select -tA 209s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 209s ok 63 - SQL command output: select -tx 209s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 209s ok 65 - SQL command output: select -tAx 209s ok 66 - CREATE EXTENSION plperlu fails for user nobody 209s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 209s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 209s ok 69 - creating PL/PerlU function as user nobody fails 209s ok 70 - creating unsafe PL/Perl function as user postgres fails 210s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 210s ok 72 - creating PL/PerlU function as user postgres succeeds 210s ok 73 - psql nobodydb -Atc "select read_file()" 210s ok 74 - calling PL/PerlU function 210s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 210s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 210s ok 77 - creating unsafe PL/Perl function as user nobody fails 210s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 210s ok 79 - creating PL/Perl function as user nobody succeeds 210s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 210s ok 81 - calling PL/Perl function 210s ok 82 # skip No python2 support 210s ok 83 # skip No python2 support 210s ok 84 # skip No python2 support 210s ok 85 # skip No python2 support 210s ok 86 # skip No python2 support 210s ok 87 # skip No python2 support 210s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 210s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 210s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 210s ok 91 - creating PL/Python3 function as user postgres succeeds 210s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 210s ok 93 - calling PL/Python function 210s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 210s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 210s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 210s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 210s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 210s ok 99 - creating PL/Tcl function as user nobody succeeds 210s ok 100 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 210s ok 101 - creating PL/TclU function as user postgres succeeds 210s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 210s ok 103 - calling PL/Tcl function 210s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 210s ok 105 - calling PL/TclU function 210s ok 106 - stopping cluster 210s ok 107 - pg_ctlcluster 12 main start 210s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 213s ok 109 - pg_ctlcluster 12 main start 213s ok 110 - cluster restarts with pgdata symlink 213s ok 111 - postgres master has OOM killer protection 213s ok 112 - postgres client backend has no OOM adjustment 213s ok 113 - ps h 7391 213s ok 114 - process title is idle 214s ok 115 - ps h 7391 214s ok 116 - process title is idle in transaction 214s ok 117 - ps h 7391 214s ok 118 - process title is SELECT 216s ok 119 - dropdb nobodydb 216s ok 120 - dropuser nobody 216s ok 121 - stopping cluster 219s ok 122 - starting cluster as postgres works without a log file 219s ok 123 - log file got recreated and used 219s ok 124 - creating a directory in spc2 219s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.GVTxmY'" 219s ok 126 - creating tablespace spc1 219s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 219s ok 128 - creating a table in spc1 219s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.EHlIqw'" 219s ok 130 - creating tablespace spc2 219s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 219s ok 132 - creating a table in spc2 219s ok 133 - pg_dropcluster removes cluster 219s ok 134 - xlog/wal directory /tmp/12.xlog.Z5S8SM was deleted 219s ok 135 - tablespace spc1 was emptied 219s ok 136 - tablespace spc2 was emptied 219s ok 137 - Cleanup: No clusters left behind 219s ok 138 - No postgres processes left behind 219s ok 139 - No files in /etc/postgresql left behind 219s ok 140 - No files in /var/lib/postgresql left behind 219s ok 141 - No files in /var/run/postgresql left behind 219s ok 142 - No files in /var/log/postgresql left behind 219s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 219s ok 144 - PostgreSQL TCP ports are closed 219s === Running test 021_pg_renamecluster.t ... === 219s 1..20 222s ok 1 - pg_createcluster 12 main 225s ok 2 - pg_renamecluster 12 main donau 225s ok 3 - psql -tAc "show data_directory" 225s ok 4 - cluster is running and data_directory was moved 225s ok 5 - pg_hba.conf location updated 225s ok 6 - pg_ident.conf location updated 225s ok 7 - external_pid_file location updated 225s ok 8 - external_pid_file exists 225s ok 9 - stats_temp_directory location updated 225s ok 10 - stats_temp_directory exists 225s ok 11 - cluster_name is updated 225s ok 12 - pg_dropcluster removes cluster 225s ok 13 - Cleanup: No clusters left behind 225s ok 14 - No postgres processes left behind 225s ok 15 - No files in /etc/postgresql left behind 225s ok 16 - No files in /var/lib/postgresql left behind 225s ok 17 - No files in /var/run/postgresql left behind 225s ok 18 - No files in /var/log/postgresql left behind 225s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 225s ok 20 - PostgreSQL TCP ports are closed 225s === Running test 022_recovery.t ... === 225s 1..17 225s # Running tests for 12 229s ok 1 - pg_createcluster 12 main --start >/dev/null 229s ok 2 - pg_ctlcluster 12 main stop -m i 231s ok 3 - pg_ctlcluster 12 main start 231s ok 4 - psql -c '' 231s ok 5 - pg_ctlcluster 12 main stop -m i 231s ok 6 - create write-protected file in data directory 233s ok 7 - pg_ctlcluster 12 main start 234s ok 8 - psql -c '' 234s ok 9 - pg_dropcluster removes cluster 234s ok 10 - Cleanup: No clusters left behind 234s ok 11 - No postgres processes left behind 234s ok 12 - No files in /etc/postgresql left behind 234s ok 13 - No files in /var/lib/postgresql left behind 234s ok 14 - No files in /var/run/postgresql left behind 234s ok 15 - No files in /var/log/postgresql left behind 234s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 234s ok 17 - PostgreSQL TCP ports are closed 234s === Running test 025_logging.t ... === 234s 1..55 235s # Logging to /var/log/syslog works 235s # Running tests for 12 238s ok 1 - pg_createcluster 12 main 238s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 238s ok 3 - psql -qc "'foobar_12_8047'" 238s ok 4 - log an error 238s ok 5 - grep --binary-files=text foobar_12_8047 /var/log/postgresql/postgresql-12-main.log 238s ok 6 - error appears in logfile 238s ok 7 - pg_conftool 12 main set log_destination syslog 238s ok 8 - set log_destination syslog 238s ok 9 - pg_ctlcluster 12 main reload 238s ok 10 - 12 main reload 238s ok 11 - psql -Atc "show log_destination" 238s ok 12 - log_destination is syslog 238s ok 13 - pg_lscluster reports syslog 238s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 238s ok 15 - error appears in /var/log/syslog 238s ok 16 - pg_conftool 12 main set logging_collector on 238s ok 17 - set logging_collector on 238s ok 18 - pg_conftool 12 main set log_destination csvlog 238s ok 19 - set log_destination csvlog 241s ok 20 - pg_ctlcluster 12 main restart 241s ok 21 - 12 main restart 241s ok 22 - psql -Atc "show logging_collector" 241s ok 23 - logging_collector is on 241s ok 24 - psql -Atc "show log_destination" 241s ok 25 - log_destination is csvlog 241s ok 26 - pg_lscluster reports csvlog 241s ok 27 - psql -qc "'barbaz_12_8047'" 241s ok 28 - log an error 241s ok 29 - grep --binary-files=text barbaz_12_8047 /var/lib/postgresql/12/main/log/*.csv 241s ok 30 - error appears in log/*.csv 241s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 241s ok 32 - set log_destination stderr,syslog,csvlog 241s ok 33 - pg_ctlcluster 12 main reload 241s ok 34 - 12 main reload 241s ok 35 - psql -Atc "show log_destination" 241s ok 36 - log_destination is stderr,syslog,csvlog 241s ok 37 - pg_lscluster reports stderr,syslog,csvlog 241s ok 38 - psql -qc "'moo_12_8047'" 241s ok 39 - log an error 241s ok 40 - grep --binary-files=text moo_12_8047 /var/lib/postgresql/12/main/log/*.log 241s ok 41 - error appears in log/*.log 242s ok 42 - grep --binary-files=text 'postgres.*moo_12_8047' /var/log/syslog 242s ok 43 - error appears in /var/log/syslog 242s ok 44 - grep --binary-files=text moo_12_8047 /var/lib/postgresql/12/main/log/*.csv 242s ok 45 - error appears in log/*.csv 242s ok 46 - pg_dropcluster 12 main --stop 242s ok 47 - pg_dropcluster removes cluster 242s ok 48 - Cleanup: No clusters left behind 242s ok 49 - No postgres processes left behind 242s ok 50 - No files in /etc/postgresql left behind 242s ok 51 - No files in /var/lib/postgresql left behind 242s ok 52 - No files in /var/run/postgresql left behind 242s ok 53 - No files in /var/log/postgresql left behind 242s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 242s ok 55 - PostgreSQL TCP ports are closed 242s === Running test 030_errors.t ... === 242s 1..149 242s ok 1 - pg_lscluster reports cluster without binaries 242s ok 2 - pg_dropcluster 6.3 main 243s ok 3 - pg_createcluster --socketdir 243s ok 4 - pg_lsclusters -h 243s ok 5 - cluster was created 243s ok 6 - Port of created cluster is 5432 243s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 243s ok 8 - pg_createcluster on existing cluster 243s ok 9 - pg_lsclusters -h 243s ok 10 - original cluster still exists 243s ok 11 - pg_createcluster 12 test -p foo 243s ok 12 - pg_createcluster -p checks that port option is numeric 243s ok 13 - pg_createcluster 12 test -p 42 243s ok 14 - pg_createcluster -p checks valid port range 243s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 243s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 243s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 246s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 246s ok 19 - No sockets in /var/run/postgresql 246s ok 20 - Socket is in /tmp/postgresql-testsuite/ 246s ok 21 - cluster stops with custom unix_socket_dir 246s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 248s ok 23 - cluster starts after removing unix_socket_dir 248s ok 24 - Socket is in default dir /var/run/postgresql 248s ok 25 - No sockets in /tmp/postgresql-testsuite/ 248s ok 26 - pg_ctlcluster 12 main stop 248s ok 27 - pg_ctlcluster fails with corrupted PID file 248s ok 28 - pg_lsclusters -h 248s ok 29 - cluster is still online 248s ok 30 - pg_ctlcluster succeeds with restored PID file 248s ok 31 - pg_lsclusters -h 248s ok 32 - cluster is down 248s ok 33 - pg_ctlcluster 12 main stop 248s ok 34 - pg_ctlcluster stop fails on stopped cluster 251s ok 35 - pg_ctlcluster 12 main start 251s ok 36 - pg_ctlcluster succeeds with already existing PID file 251s ok 37 - pg_lsclusters -h 251s ok 38 - cluster is online 251s ok 39 - pg_ctlcluster stop succeeds 251s ok 40 - pg_lsclusters -h 251s ok 41 - cluster is down 251s ok 42 - no pid file left 251s ok 43 - pg_ctlcluster 12 main stop 251s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 251s ok 45 - pid file was cleaned up 251s ok 46 - pg_ctlcluster --force 12 main stop 251s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 251s ok 48 - pid file was cleaned up 251s ok 49 - pg_ctlcluster 12 main stop 251s ok 50 - pg_ctlcluster stop succeeds with stale PID file 251s ok 51 - pid file was cleaned up 251s ok 52 - pg_ctlcluster --force 12 main stop 251s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 251s ok 54 - pid file was cleaned up 251s ok 55 - pg_ctlcluster --force 12 main stop 251s ok 56 - pg_ctlcluster stop succeeds with empty PID file 251s ok 57 - pid file was cleaned up 253s ok 58 - pg_ctlcluster 12 main start 253s ok 59 - pg_ctlcluster succeeds with corrupted PID file 253s ok 60 - pg_lsclusters -h 253s ok 61 - cluster is online 253s ok 62 - pg_ctlcluster 12 main start 253s ok 63 - pg_ctlcluster start fails on running cluster 253s ok 64 - pg_ctlcluster stop 254s ok 65 - pg_ctlcluster 12 main start 254s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 254s ok 67 - pg_ctlcluster 12 main stop 254s ok 68 - stopping cluster 260s ok 69 - pg_ctlcluster 12 main start 260s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 260s ok 71 - pg_ctlcluster 12 main stop 260s ok 72 - stopping cluster 260s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 260s ok 74 - pg_dropcluster 12 main 260s ok 75 - pg_dropcluster works as user postgres 261s ok 76 - pg_createcluster succeeds 261s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 261s ok 78 - proper error message for nonexisting /var/lib/postgresql 263s ok 79 - pg_ctlcluster 12 main start 263s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 263s ok 81 - pg_ctlcluster 12 main stop 263s ok 82 - stopping cluster 264s ok 83 - pg_createcluster other 266s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 269s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 269s ok 86 269s ok 87 - pg_ctlcluster 12 other start 269s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 269s ok 89 - pg_ctlcluster 12 main stop 269s ok 90 - stopping main cluster 271s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 271s ok 92 - pg_dropcluster other 272s ok 93 - pg_dropcluster 272s ok 94 - No sockets any more 272s ok 95 - 'pg_lsclusters 4.5 foo' fails 272s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 272s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 272s ok 98 - 'psql --cluster 4.5/foo' fails 272s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 272s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 272s ok 101 - 'psql --cluster 12/foo' fails 272s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 272s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 272s ok 104 - 'pg_dropcluster 4.5 foo' fails 272s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 272s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 272s ok 107 - 'pg_dropcluster 12 foo' fails 272s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 272s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 272s ok 110 - 'pg_upgradecluster 4.5 foo' fails 272s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 272s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 272s ok 113 - 'pg_upgradecluster 12 foo' fails 272s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 272s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 272s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 272s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 272s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 272s ok 119 - 'pg_ctlcluster 12 foo stop' fails 272s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 272s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 272s ok 122 - Cleanup: No clusters left behind 272s ok 123 - No postgres processes left behind 272s ok 124 - No files in /etc/postgresql left behind 272s ok 125 - No files in /var/lib/postgresql left behind 272s ok 126 - No files in /var/run/postgresql left behind 272s ok 127 - No files in /var/log/postgresql left behind 272s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 272s ok 129 - PostgreSQL TCP ports are closed 272s ok 130 - pg_dropcluster 12 broken 272s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 272s ok 132 - Cleanup: No clusters left behind 272s ok 133 - No postgres processes left behind 272s ok 134 - No files in /etc/postgresql left behind 272s ok 135 - No files in /var/lib/postgresql left behind 272s ok 136 - No files in /var/run/postgresql left behind 272s ok 137 - No files in /var/log/postgresql left behind 272s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 272s ok 139 - PostgreSQL TCP ports are closed 272s ok 140 - pg_dropcluster 12 broken 272s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 272s ok 142 - Cleanup: No clusters left behind 272s ok 143 - No postgres processes left behind 272s ok 144 - No files in /etc/postgresql left behind 272s ok 145 - No files in /var/lib/postgresql left behind 272s ok 146 - No files in /var/run/postgresql left behind 272s ok 147 - No files in /var/log/postgresql left behind 272s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 272s ok 149 - PostgreSQL TCP ports are closed 272s === Running test 031_errors_disk_full.t ... === 272s 1..22 272s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 273s ok 1 - script failed 273s ok 2 - pg_createcluster fails due to insufficient disk space 273s ok 3 - does not leave files behind 273s ok 4 - Cleanup: No clusters left behind 273s ok 5 - No postgres processes left behind 273s ok 6 - No files in /etc/postgresql left behind 273s ok 7 - No files in /var/lib/postgresql left behind 273s ok 8 - No files in /var/run/postgresql left behind 273s ok 9 - No files in /var/log/postgresql left behind 273s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 273s ok 11 - PostgreSQL TCP ports are closed 273s # check disk full conditions on startup 274s ok 12 - script failed 274s ok 13 - pg_ctlcluster prints error message 274s ok 14 - log file has error message 274s ok 15 - Cleanup: No clusters left behind 274s ok 16 - No postgres processes left behind 274s ok 17 - No files in /etc/postgresql left behind 274s ok 18 - No files in /var/lib/postgresql left behind 274s ok 19 - No files in /var/run/postgresql left behind 274s ok 20 - No files in /var/log/postgresql left behind 274s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 274s ok 22 - PostgreSQL TCP ports are closed 274s === Running test 032_ssl_key_permissions.t ... === 274s 1..22 274s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 274s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 274s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 274s # 12 (12.22-0ubuntu0.20.04.3) 275s ok 4 - pg_createcluster 12 main 275s ok 5 - pg_ctlcluster 12 main start 275s ok 6 - ssl key owned by nobody refused 275s ok 7 - pg_ctlcluster 12 main start 275s ok 8 - ssl key with permissions root:root 0644 refused 275s ok 9 - pg_ctlcluster 12 main start 275s ok 10 - ssl key with permissions postgres:postgres 0640 refused 275s ok 11 - pg_dropcluster 12 main --stop 275s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 275s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 275s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 275s ok 15 - Cleanup: No clusters left behind 275s ok 16 - No postgres processes left behind 275s ok 17 - No files in /etc/postgresql left behind 275s ok 18 - No files in /var/lib/postgresql left behind 275s ok 19 - No files in /var/run/postgresql left behind 275s ok 20 - No files in /var/log/postgresql left behind 275s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 275s ok 22 - PostgreSQL TCP ports are closed 275s === Running test 040_upgrade.t ... === 276s 1..1 276s ok 1 - only one major version installed, skipping upgrade tests 276s === Running test 041_upgrade_custompaths.t ... === 276s 1..1 276s ok 1 - only one major version installed, skipping upgrade tests 276s === Running test 043_upgrade_ssl_cert.t ... === 276s 1..1 276s ok 1 - only one major version installed, skipping upgrade tests 276s === Running test 050_encodings.t ... === 276s 1..60 276s # Checking 12 ru_RU 279s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 280s ok 2 - psql -l succeeds 280s ok 3 - template1 is not UTF-8 encoded 280s ok 4 - creating test database 280s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 280s # create table t (x varchar); copy t from stdin" test 280s ok 6 - creating table with ISO-8859-5 characters 280s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 280s ok 8 - correct string in UTF-8 280s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 280s ok 10 - correct string in ISO-8859-5 280s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 280s # delete from t; copy t from stdin" test 280s ok 12 - creating table with UTF-8 characters 280s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 280s ok 14 - correct string in UTF-8 280s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 280s ok 16 - correct string in ISO-8859-1 280s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 280s ok 18 - Server error message has correct language and encoding 283s ok 19 - pg_ctlcluster 12 ru_RU restart 283s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 283s ok 21 - Dropping cluster 283s # Checking 12 ru_RU.UTF-8 286s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 287s ok 23 - psql -l succeeds 287s ok 24 - template1 is UTF-8 encoded 287s ok 25 - creating test database 287s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 287s # create table t (x varchar); copy t from stdin" test 287s ok 27 - creating table with ISO-8859-5 characters 287s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 287s ok 29 - correct string in UTF-8 287s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 287s ok 31 - correct string in ISO-8859-5 287s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 287s # delete from t; copy t from stdin" test 287s ok 33 - creating table with UTF-8 characters 287s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 287s ok 35 - correct string in UTF-8 287s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 287s ok 37 - correct string in ISO-8859-1 287s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 287s ok 39 - Server error message has correct language and encoding 290s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 290s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 290s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 290s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 290s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 290s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 290s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 290s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 290s ok 48 - Dropping cluster 290s # Check 12 locale environment variables 293s ok 49 - pg_createcluster: LC_ALL dominates LANG 293s ok 50 - psql -Atl --cluster 12/main 293s ok 51 - template1 is ASCII encoded 294s ok 52 - Dropping cluster 294s ok 53 - Cleanup: No clusters left behind 294s ok 54 - No postgres processes left behind 294s ok 55 - No files in /etc/postgresql left behind 294s ok 56 - No files in /var/lib/postgresql left behind 294s ok 57 - No files in /var/run/postgresql left behind 294s ok 58 - No files in /var/log/postgresql left behind 294s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 294s ok 60 - PostgreSQL TCP ports are closed 294s === Running test 052_upgrade_encodings.t ... === 294s 1..1 294s ok 1 - only one major version installed, skipping upgrade tests 294s === Running test 060_obsolete_confparams.t ... === 294s 1..1 294s ok 1 - only one major version installed, skipping upgrade tests 294s === Running test 070_non_postgres_clusters.t ... === 294s 1..40 295s ok 1 - pg_createcluster 12 main for owner nobody 295s ok 2 - pg_ctlcluster 12 main start 295s ok 3 - start refused when config and data owners mismatch 297s ok 4 - pg_ctlcluster succeeds with owner nobody 297s ok 5 - pg_lsclusters -h 297s ok 6 - pg_lsclusters shows running cluster 297s ok 7 - postgres is running as user nobody 297s ok 8 - ls /tmp/.s.PGSQL.* 297s ok 9 - socket is in /tmp 297s ok 10 - /var/run/postgresql is empty 297s ok 11 - conf dir is owned by user 297s ok 12 - conf dir is owned by user's primary group 297s ok 13 - files are owned by user 297s ok 14 - files are owned by user's primary group 297s ok 15 - log file has 0640 permissions 297s ok 16 - log file is owned by user 297s ok 17 - log file is owned by user's primary group 297s ok 18 - only one major version installed, skipping upgrade test 297s ok 19 - ... 297s ok 20 - ... 297s ok 21 - ... 297s ok 22 - ... 297s ok 23 - ... 297s ok 24 - ... 297s ok 25 - ... 297s ok 26 - ... 297s ok 27 - ... 297s ok 28 - ... 298s ok 29 - pg_dropcluster 298s ok 30 - pg_lsclusters -h 298s ok 31 - No clusters left 298s ok 32 - No postgres processes left 298s ok 33 - Cleanup: No clusters left behind 298s ok 34 - No postgres processes left behind 298s ok 35 - No files in /etc/postgresql left behind 298s ok 36 - No files in /var/lib/postgresql left behind 298s ok 37 - No files in /var/run/postgresql left behind 298s ok 38 - No files in /var/log/postgresql left behind 298s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 298s ok 40 - PostgreSQL TCP ports are closed 298s === Running test 080_start.conf.t ... === 298s 1..73 298s ok 1 - pg_createcluster 12 main 298s # start.conf auto 298s ok 2 - get_cluster_start_conf returns auto 298s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 298s ok 4 - start.conf contains auto 298s ok 5 - systemd generator links cluster 298s ok 6 - systemd generator links correct service file 301s ok 7 - /etc/init.d/postgresql start 12 301s ok 8 - correct output of /etc/init.d/postgresql start 12 301s ok 9 - pg_lsclusters -h 301s ok 10 - cluster is online 301s ok 11 - /etc/init.d/postgresql stop 12 301s ok 12 - correct output of /etc/init.d/postgresql stop 12 304s ok 13 - pg_lsclusters -h 304s ok 14 - cluster is down 304s # start.conf manual 304s ok 15 - get_cluster_start_conf returns manual 304s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 304s ok 17 - start.conf contains manual 304s ok 18 - systemd generator doesn't link cluster 304s ok 19 - /etc/init.d/postgresql start 12 304s ok 20 - correct output of /etc/init.d/postgresql start 12 304s ok 21 - pg_lsclusters -h 304s ok 22 - cluster is down 306s ok 23 - pg_ctlcluster 12 main start 306s ok 24 - correct output of pg_ctlcluster 12 main start 306s ok 25 - pg_lsclusters -h 306s ok 26 - cluster is online 306s ok 27 - pg_ctlcluster 12 main stop 306s ok 28 - correct output of pg_ctlcluster 12 main stop 306s ok 29 - pg_lsclusters -h 306s ok 30 - cluster is down 306s # start.conf disabled 306s ok 31 - get_cluster_start_conf returns disabled 307s ok 32 - systemd generator doesn't link cluster 307s ok 33 - /etc/init.d/postgresql start 12 307s ok 34 - correct output of /etc/init.d/postgresql start 12 307s ok 35 - pg_lsclusters -h 307s ok 36 - cluster is down 307s ok 37 - pg_ctlcluster 12 main start 307s ok 38 - correct output of pg_ctlcluster 12 main start 307s ok 39 - pg_lsclusters -h 307s ok 40 - cluster is down 309s ok 41 - pg_ctlcluster 12 main start 309s ok 42 - correct output of pg_ctlcluster 12 main start 309s ok 43 - pg_lsclusters -h 309s ok 44 - cluster is online 309s ok 45 - pg_ctlcluster 12 main stop 309s ok 46 - correct output of pg_ctlcluster 12 main stop 309s ok 47 - pg_lsclusters -h 309s ok 48 - cluster is down 311s ok 49 - pg_ctlcluster 12 main start 311s ok 50 - correct output of pg_ctlcluster 12 main start 312s ok 51 - pg_lsclusters -h 312s ok 52 - cluster is online 312s # test upgrade 312s ok 53 - only one major version installed, skipping upgrade test 312s ok 54 - ... 312s ok 55 - get_cluster_start_conf for old cluster returns manual 312s ok 56 - get_cluster_start_conf for new cluster returns manual 312s ok 57 - ... 312s ok 58 - dropping upgraded cluster 312s ok 59 - pg_lsclusters -h 312s ok 60 - no clusters any more 312s ok 61 - pg_createcluster 12 main --start-conf foo 312s ok 62 - pg_createcluster checks --start-conf validity 312s ok 63 - pg_createcluster checks --start-conf manual 312s ok 64 - get_cluster_start_conf returns manual 313s ok 65 - dropping cluster 313s ok 66 - Cleanup: No clusters left behind 313s ok 67 - No postgres processes left behind 313s ok 68 - No files in /etc/postgresql left behind 313s ok 69 - No files in /var/lib/postgresql left behind 313s ok 70 - No files in /var/run/postgresql left behind 313s ok 71 - No files in /var/log/postgresql left behind 313s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 313s ok 73 - PostgreSQL TCP ports are closed 313s === Running test 085_pg_ctl.conf.t ... === 313s 1..29 313s ok 1 - pg_createcluster 12 main 313s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 316s ok 3 - pg_ctlcluster 12 main start 316s ok 4 - starting cluster 316s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 316s ok 6 - soft core size is 0 316s ok 7 - set pg_ctl default option to -c 318s ok 8 - pg_ctlcluster 12 main restart 318s ok 9 - restarting cluster 318s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 318s ok 11 - soft core size is unlimited 318s ok 12 - restored pg_ctl default option 320s ok 13 - pg_ctlcluster 12 main restart 320s ok 14 - restarting cluster 320s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 320s ok 16 - soft core size is 0 322s ok 17 - pg_ctlcluster 12 main restart -- -c 322s ok 18 - restarting cluster with -c on the command line 322s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 322s ok 20 - soft core size is unlimited 323s ok 21 - dropping cluster 323s ok 22 - Cleanup: No clusters left behind 323s ok 23 - No postgres processes left behind 323s ok 24 - No files in /etc/postgresql left behind 323s ok 25 - No files in /var/lib/postgresql left behind 323s ok 26 - No files in /var/run/postgresql left behind 323s ok 27 - No files in /var/log/postgresql left behind 323s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 323s ok 29 - PostgreSQL TCP ports are closed 323s === Running test 090_multicluster.t ... === 323s 1..125 324s ok 1 - pg_createcluster 12 old 325s ok 2 - pg_createcluster 12 new1 325s ok 3 - pg_createcluster 12 new2 328s ok 4 - starting cluster 12/old 330s ok 5 - starting cluster 12/new1 332s ok 6 - starting cluster 12/new2 332s ok 7 - pg_lsclusters -h | sort -k3 332s ok 8 - clusters have the correct ports, skipping used 5433 332s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 332s ok 10 - createdb --version 332s ok 11 - pg_wrapper selects port 5432 as default cluster 332s ok 12 - createdb --cluster 12/new1 --version 332s ok 13 - pg_wrapper --cluster works 332s ok 14 - createdb --cluster 12/foo --version 332s ok 15 - pg_wrapper --cluster errors out for invalid cluster 332s ok 16 - createdb --cluster 12/new1 test 332s ok 17 - correct output of createdb --cluster 12/new1 test 332s ok 18 - psql -Atl --cluster 12/new1 332s ok 19 - test db appears in cluster new1 332s ok 20 - psql -Atl --cluster 12/new2 332s ok 21 - test db does not appear in cluster new2 332s ok 22 - psql -Atl 332s ok 23 - test db does not appear in default cluster 333s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 333s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 333s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 333s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 333s ok 28 - psql -Atl --cluster 12/localhost:5434 333s ok 29 - test db appears in cluster 12/localhost:5434 333s ok 30 - psql -Atl --cluster 12/localhost:5440 333s ok 31 - test db does not appear in cluster 12/localhost:5440 333s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 333s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 333s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 333s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 333s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 333s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 333s ok 38 - psql -Atl --cluster 6.4/localhost: 333s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 333s ok 40 - psql -Atl 333s ok 41 - PGCLUSTER selection (1) 333s ok 42 - psql -Atl 333s ok 43 - PGCLUSTER selection (2) 333s ok 44 - psql -l 333s ok 45 - invalid PGCLUSTER value 333s ok 46 - createdb --version 333s ok 47 - PGCLUSTER network cluster selection (1) 333s ok 48 - psql -Atl 333s ok 49 - PGCLUSTER network cluster selection (2) 333s ok 50 - psql -Atl 333s ok 51 - PGCLUSTER network cluster selection (3) 333s ok 52 - LC_MESSAGES=C psql -Atl 333s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 333s ok 54 - psql -Atc "show port" template1 333s ok 55 - PGPORT selection (1) 333s ok 56 - psql -Atc "show port" template1 333s ok 57 - PGPORT selection (2) 333s ok 58 - createdb --version 333s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 333s ok 60 - psql -Atc "show port" template1 333s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 333s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 333s ok 63 - PGDATABASE environment variable works 333s ok 64 - createdb --version 333s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 333s ok 66 - createdb --cluster 12/new1 --version 333s ok 67 - pg_wrapper --cluster works with empty user_clusters 333s ok 68 - createdb --version 333s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 333s ok 70 - psql -Atc "select current_database()" 333s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 333s ok 72 - psql -Atc 'select current_database()' 333s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 333s ok 74 - createdb --version 333s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 333s ok 76 - createdb --version 333s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 333s ok 78 - createdb --version 333s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 334s ok 80 - createdb --version 334s ok 81 - pg_wrapper selects correct version with per-user user_clusters 334s ok 82 - createdb --version 334s ok 83 - pg_wrapper selects correct version with per-user user_clusters 334s ok 84 - createdb --version 334s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 334s ok 86 - psql -Atl 334s ok 87 - $PGHOST overrides user_clusters 334s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 334s ok 89 - --cluster overrides $PGHOST 334s ok 90 - createdb --version 334s ok 91 - pg_wrapper ignores invalid lines in user_clusters 334s ok 92 - psql -Atc 'select current_database()' 334s ok 93 - pg_service conf selection 1 334s ok 94 - psql -Atc 'select current_database()' 334s ok 95 - pg_service conf selection 2 334s ok 96 - psql -Atc 'select current_database()' 334s ok 97 - pg_service conf selection 3 334s ok 98 - stopping cluster 12/old 336s ok 99 - restarting cluster 12/old 336s ok 100 - pg_lsclusters -h | sort -k3 336s ok 101 - port of first cluster was successfully changed 336s ok 102 - psql -l 336s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 336s ok 104 - psql -Atl --cluster 12/new1 336s ok 105 - --cluster selects appropriate cluster 336s ok 106 - psql -Atl -p 5434 336s ok 107 - -p selects appropriate cluster 336s ok 108 - psql -Atlp 5434 336s ok 109 - -Atlp selects appropriate cluster 337s ok 110 - psql -Atl --port 5434 337s ok 111 - --port selects appropriate cluster 337s ok 112 - env PGPORT=5434 psql -Atl 337s ok 113 - $PGPORT selects appropriate cluster 337s ok 114 - Restoring original /etc/postgresql-common/user_clusters 337s ok 115 - dropping 12/new1 337s ok 116 - dropping 12/new2 338s ok 117 - dropping 12/old 338s ok 118 - Cleanup: No clusters left behind 338s ok 119 - No postgres processes left behind 338s ok 120 - No files in /etc/postgresql left behind 338s ok 121 - No files in /var/lib/postgresql left behind 338s ok 122 - No files in /var/run/postgresql left behind 338s ok 123 - No files in /var/log/postgresql left behind 338s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 338s ok 125 - PostgreSQL TCP ports are closed 338s === Running test 100_upgrade_scripts.t ... === 338s 1..27 341s ok 1 - pg_createcluster 12 main 341s ok 2 - createdb --cluster 12/main db1 341s ok 3 - correct output of createdb --cluster 12/main db1 341s ok 4 - createdb --cluster 12/main db2 341s ok 5 - correct output of createdb --cluster 12/main db2 341s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 341s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 341s ok 8 - get_cluster_databases() works 341s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 343s ok 10 - run-upgrade-scripts succeeds 343s ok 11 - correct run-upgrade-script output 343s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 343s ok 13 - check SQL scripts results in 12/main db1 343s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 343s ok 15 - check SQL scripts results in 12/main db2 343s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 343s ok 17 - check shell scripts results in $v/main 343s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 343s ok 19 - pg_dropcluster 12 main 343s ok 20 - Cleanup: No clusters left behind 343s ok 21 - No postgres processes left behind 343s ok 22 - No files in /etc/postgresql left behind 343s ok 23 - No files in /var/lib/postgresql left behind 343s ok 24 - No files in /var/run/postgresql left behind 343s ok 25 - No files in /var/log/postgresql left behind 343s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 343s ok 27 - PostgreSQL TCP ports are closed 343s === Running test 110_integrate_cluster.t ... === 344s 1..32 344s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/kMye49l30d/c/postgres 344s ok 2 - creating raw initdb cluster for user postgres 345s ok 3 - pg_createcluster 12 postgres -d /tmp/kMye49l30d/c/postgres 345s ok 4 - integrating postgres cluster 345s ok 5 - pg_lsclusters 345s ok 6 - correct pg_lsclusters output 347s ok 7 - pg_ctlcluster 12 postgres start 347s ok 8 - starting cluster postgres 347s ok 9 - pg_lsclusters 347s ok 10 - correct pg_lsclusters output 347s ok 11 - dropping cluster postgres 347s ok 12 - No files in temporary cluster dir left behind 348s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/kMye49l30d/c/nobody 348s ok 14 - creating raw initdb cluster for user nobody 348s ok 15 - pg_createcluster 12 nobody -d /tmp/kMye49l30d/c/nobody 348s ok 16 - integrating nobody cluster 348s ok 17 - pg_lsclusters 348s ok 18 - correct pg_lsclusters output 351s ok 19 - pg_ctlcluster 12 nobody start 351s ok 20 - starting cluster nobody 351s ok 21 - pg_lsclusters 351s ok 22 - correct pg_lsclusters output 351s ok 23 - dropping cluster nobody 351s ok 24 - No files in temporary cluster dir left behind 351s ok 25 - Cleanup: No clusters left behind 351s ok 26 - No postgres processes left behind 351s ok 27 - No files in /etc/postgresql left behind 351s ok 28 - No files in /var/lib/postgresql left behind 351s ok 29 - No files in /var/run/postgresql left behind 351s ok 30 - No files in /var/log/postgresql left behind 351s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 351s ok 32 - PostgreSQL TCP ports are closed 351s === Running test 120_pg_upgradecluster_scripts.t ... === 351s 1..1 351s ok 1 - only one major version installed, skipping upgrade tests 351s === Running test 130_nonroot_admin.t ... === 351s 1..22 354s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 354s ok 2 - pg_lsclusters -h 354s ok 3 - correct output of pg_lsclusters -h 354s ok 4 - psql -Atl 354s ok 5 - correct output of psql -Atl 354s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 354s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 354s ok 15 - Cleanup: No clusters left behind 354s ok 16 - No postgres processes left behind 354s ok 17 - No files in /etc/postgresql left behind 354s ok 18 - No files in /var/lib/postgresql left behind 354s ok 19 - No files in /var/run/postgresql left behind 354s ok 20 - No files in /var/log/postgresql left behind 354s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 354s ok 22 - PostgreSQL TCP ports are closed 354s === Running test 135_pg_virtualenv.t ... === 355s 1..20 358s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 358s ok 2 - running pg_virtualenv as root 361s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 361s ok 4 - running pg_virtualenv as postgres 364s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 364s ok 6 - running pg_virtualenv as nobody 368s ok 7 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 368s ok 8 - running fakeroot pg_virtualenv as root 371s ok 9 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 371s ok 10 - running fakeroot pg_virtualenv as postgres 374s ok 11 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 374s ok 12 - running fakeroot pg_virtualenv as nobody 374s ok 13 - Cleanup: No clusters left behind 374s ok 14 - No postgres processes left behind 374s ok 15 - No files in /etc/postgresql left behind 374s ok 16 - No files in /var/lib/postgresql left behind 374s ok 17 - No files in /var/run/postgresql left behind 374s ok 18 - No files in /var/log/postgresql left behind 374s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 374s ok 20 - PostgreSQL TCP ports are closed 374s === Running test 140_pg_config.t ... === 374s 1..38 374s # Multiarch is enabled 374s # checking version specific output for 12 374s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 374s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 374s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 374s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 374s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 374s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 374s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 374s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 374s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 374s # checking pg_config output (should behave like version 12) 374s ok 15 - pg_config 374s ok 16 - correct output of pg_config 374s ok 17 - pg_config --help 374s ok 18 - correct output of pg_config --help 374s ok 19 - pg_config --pgxs 374s ok 20 - correct output of pg_config --pgxs 374s ok 21 - pg_config --libdir 374s ok 22 - correct output of pg_config --libdir 374s ok 23 - pg_config --pkglibdir 374s ok 24 - correct output of pg_config --pkglibdir 374s ok 25 - pg_config --bindir 374s ok 26 - correct output of pg_config --bindir 374s # checking pg_config.libpq-dev output (should behave like version 12) 374s ok 27 - pg_config.libpq-dev 374s ok 28 - correct output of pg_config.libpq-dev 374s ok 29 - pg_config.libpq-dev --help 374s ok 30 - correct output of pg_config.libpq-dev --help 374s ok 31 - pg_config.libpq-dev --pgxs 374s ok 32 - correct output of pg_config.libpq-dev --pgxs 374s ok 33 - pg_config.libpq-dev --libdir 374s ok 34 - correct output of pg_config.libpq-dev --libdir 374s ok 35 - pg_config.libpq-dev --pkglibdir 374s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 374s ok 37 - pg_config.libpq-dev --bindir 374s ok 38 - correct output of pg_config.libpq-dev --bindir 374s === Running test 150_tsearch_stemming.t ... === 374s 1..37 374s ok 1 - pg_updatedicts succeeded 374s ok 2 - pg_updatedicts created en_us.affix 374s ok 3 - pg_updatedicts created en_us.dict 374s ok 4 - pg_updatedicts created 12 en_us.affix symlink 374s ok 5 - pg_updatedicts created 12 en_us.dict symlink 377s ok 6 - pg_createcluster 12 main 377s ok 7 - createdb fts 377s ok 8 - correct output of createdb fts 378s ok 9 - creating en_US full text search configuration 378s ok 10 - creating data table and search index 378s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 378s ok 12 - stem search of correct word 378s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 378s ok 14 - stem search of correct word 378s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 378s ok 16 - stem search of unknown word 378s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 378s ok 18 - full text search, exact word 378s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 378s ok 20 - full text search for word stem 378s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 378s ok 22 - full text search for word substring fails 378s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 378s ok 24 - full text search, exact unicode word 378s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 378s ok 26 - full text search for unicode word stem 378s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 378s ok 28 - full text search for unicode word substring fails 379s ok 29 379s ok 30 - Cleanup: No clusters left behind 379s ok 31 - No postgres processes left behind 379s ok 32 - No files in /etc/postgresql left behind 379s ok 33 - No files in /var/lib/postgresql left behind 379s ok 34 - No files in /var/run/postgresql left behind 379s ok 35 - No files in /var/log/postgresql left behind 379s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 379s ok 37 - PostgreSQL TCP ports are closed 379s === Running test 160_alternate_confroot.t ... === 379s 1..28 382s ok 1 382s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 382s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 382s ok 4 - pg_lsclusters -h 382s ok 5 - correct output of pg_lsclusters -h 382s ok 6 - psql -Atl 382s ok 7 - correct output of psql -Atl 382s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 382s ok 9 - ... 382s ok 10 - ... 382s ok 11 - ... 382s ok 12 - ... 382s ok 13 - ... 382s ok 14 - ... 382s ok 15 - pg_dropcluster 12 test --stop 382s ok 16 - correct output of pg_dropcluster 12 test --stop 382s ok 17 - pg_lsclusters -h 382s ok 18 - correct output of pg_lsclusters -h 382s ok 19 - No files in root/data left behind 382s ok 20 - No cruft in root dir left behind 382s ok 21 - Cleanup: No clusters left behind 382s ok 22 - No postgres processes left behind 382s ok 23 - No files in /etc/postgresql left behind 382s ok 24 - No files in /var/lib/postgresql left behind 382s ok 25 - No files in /var/run/postgresql left behind 382s ok 26 - No files in /var/log/postgresql left behind 382s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 382s ok 28 - PostgreSQL TCP ports are closed 382s === Running test 170_extensions.t ... === 382s # Running tests for 12 385s ok 1 - pg_createcluster 12 main 385s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 385s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 385s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 385s ok 5 - extension adminpack installs without error 385s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 385s ok 7 - extension adminpack removes without error 385s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 385s ok 9 - extension amcheck installs without error 386s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 386s ok 11 - extension amcheck removes without error 386s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 386s ok 13 - extension autoinc installs without error 386s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 386s ok 15 - extension autoinc removes without error 386s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 386s ok 17 - extension bloom installs without error 386s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 386s ok 19 - extension bloom removes without error 386s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 386s ok 21 - extension btree_gin installs without error 386s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 386s ok 23 - extension btree_gin removes without error 386s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 386s ok 25 - extension btree_gist installs without error 386s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 386s ok 27 - extension btree_gist removes without error 386s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 386s ok 29 - extension citext installs without error 386s ok 30 - psql -qc 'DROP EXTENSION "citext"' 386s ok 31 - extension citext removes without error 386s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 386s ok 33 - extension cube installs without error 386s ok 34 - psql -qc 'DROP EXTENSION "cube"' 386s ok 35 - extension cube removes without error 386s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 386s ok 37 - extension dblink installs without error 386s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 386s ok 39 - extension dblink removes without error 386s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 386s ok 41 - extension dict_int installs without error 386s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 386s ok 43 - extension dict_int removes without error 386s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 386s ok 45 - extension dict_xsyn installs without error 386s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 386s ok 47 - extension dict_xsyn removes without error 386s ok 48 - psql -qc 'CREATE EXTENSION cube' 386s ok 49 - earthdistance dependency cube installs without error 387s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 387s ok 51 - extension earthdistance installs without error 387s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 387s ok 53 - extension earthdistance removes without error 387s ok 54 - psql -qc 'DROP EXTENSION cube' 387s ok 55 - earthdistance dependency extension cube removes without error 387s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 387s ok 57 - extension file_fdw installs without error 387s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 387s ok 59 - extension file_fdw removes without error 387s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 387s ok 61 - extension fuzzystrmatch installs without error 387s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 387s ok 63 - extension fuzzystrmatch removes without error 387s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 387s ok 65 - extension hstore installs without error 387s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 387s ok 67 - extension hstore removes without error 387s ok 68 - psql -qc 'CREATE EXTENSION hstore' 387s ok 69 - hstore_plperl dependency hstore installs without error 387s ok 70 - psql -qc 'CREATE EXTENSION plperl' 387s ok 71 - hstore_plperl dependency plperl installs without error 387s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 387s ok 73 - extension hstore_plperl installs without error 387s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 387s ok 75 - extension hstore_plperl removes without error 387s ok 76 - psql -qc 'DROP EXTENSION hstore' 387s ok 77 - hstore_plperl dependency extension hstore removes without error 387s ok 78 - psql -qc 'DROP EXTENSION plperl' 387s ok 79 - hstore_plperl dependency extension plperl removes without error 387s ok 80 - psql -qc 'CREATE EXTENSION hstore' 387s ok 81 - hstore_plperlu dependency hstore installs without error 387s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 387s ok 83 - hstore_plperlu dependency plperlu installs without error 387s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 387s ok 85 - extension hstore_plperlu installs without error 388s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 388s ok 87 - extension hstore_plperlu removes without error 388s ok 88 - psql -qc 'DROP EXTENSION hstore' 388s ok 89 - hstore_plperlu dependency extension hstore removes without error 388s ok 90 - psql -qc 'DROP EXTENSION plperlu' 388s ok 91 - hstore_plperlu dependency extension plperlu removes without error 388s ok 92 - psql -qc 'CREATE EXTENSION hstore' 388s ok 93 - hstore_plpython3u dependency hstore installs without error 388s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 388s ok 95 - hstore_plpython3u dependency plpython3u installs without error 388s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 388s ok 97 - extension hstore_plpython3u installs without error 388s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 388s ok 99 - extension hstore_plpython3u removes without error 388s ok 100 - psql -qc 'DROP EXTENSION hstore' 388s ok 101 - hstore_plpython3u dependency extension hstore removes without error 388s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 388s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 388s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 388s ok 105 - extension insert_username installs without error 388s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 388s ok 107 - extension insert_username removes without error 388s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 388s ok 109 - extension intagg installs without error 388s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 388s ok 111 - extension intagg removes without error 388s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 388s ok 113 - extension intarray installs without error 388s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 388s ok 115 - extension intarray removes without error 388s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 388s ok 117 - extension isn installs without error 388s ok 118 - psql -qc 'DROP EXTENSION "isn"' 388s ok 119 - extension isn removes without error 388s ok 120 - psql -qc 'CREATE EXTENSION plperl' 388s ok 121 - jsonb_plperl dependency plperl installs without error 388s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 388s ok 123 - extension jsonb_plperl installs without error 388s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 388s ok 125 - extension jsonb_plperl removes without error 388s ok 126 - psql -qc 'DROP EXTENSION plperl' 388s ok 127 - jsonb_plperl dependency extension plperl removes without error 389s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 389s ok 129 - jsonb_plperlu dependency plperlu installs without error 389s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 389s ok 131 - extension jsonb_plperlu installs without error 389s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 389s ok 133 - extension jsonb_plperlu removes without error 389s ok 134 - psql -qc 'DROP EXTENSION plperlu' 389s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 389s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 389s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 389s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 389s ok 139 - extension jsonb_plpython3u installs without error 389s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 389s ok 141 - extension jsonb_plpython3u removes without error 389s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 389s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 389s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 389s ok 145 - extension lo installs without error 389s ok 146 - psql -qc 'DROP EXTENSION "lo"' 389s ok 147 - extension lo removes without error 389s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 389s ok 149 - extension ltree installs without error 389s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 389s ok 151 - extension ltree removes without error 389s ok 152 - psql -qc 'CREATE EXTENSION ltree' 389s ok 153 - ltree_plpython3u dependency ltree installs without error 389s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 389s ok 155 - ltree_plpython3u dependency plpython3u installs without error 389s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 389s ok 157 - extension ltree_plpython3u installs without error 389s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 389s ok 159 - extension ltree_plpython3u removes without error 389s ok 160 - psql -qc 'DROP EXTENSION ltree' 389s ok 161 - ltree_plpython3u dependency extension ltree removes without error 389s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 389s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 389s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 389s ok 165 - extension moddatetime installs without error 389s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 389s ok 167 - extension moddatetime removes without error 389s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 389s ok 169 - extension pageinspect installs without error 389s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 389s ok 171 - extension pageinspect removes without error 390s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 390s ok 173 - extension pg_buffercache installs without error 390s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 390s ok 175 - extension pg_buffercache removes without error 390s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 390s ok 177 - extension pg_freespacemap installs without error 390s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 390s ok 179 - extension pg_freespacemap removes without error 390s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 390s ok 181 - extension pg_prewarm installs without error 390s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 390s ok 183 - extension pg_prewarm removes without error 390s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 390s ok 185 - extension pg_stat_statements installs without error 390s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 390s ok 187 - extension pg_stat_statements removes without error 390s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 390s ok 189 - extension pg_trgm installs without error 390s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 390s ok 191 - extension pg_trgm removes without error 390s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 390s ok 193 - extension pg_visibility installs without error 390s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 390s ok 195 - extension pg_visibility removes without error 390s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 390s ok 197 - extension pgcrypto installs without error 390s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 390s ok 199 - extension pgcrypto removes without error 390s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 390s ok 201 - extension pgrowlocks installs without error 390s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 390s ok 203 - extension pgrowlocks removes without error 390s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 390s ok 205 - extension pgstattuple installs without error 390s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 390s ok 207 - extension pgstattuple removes without error 390s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 390s ok 209 - extension plperl installs without error 390s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 390s ok 211 - extension plperl removes without error 390s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 390s ok 213 - extension plperlu installs without error 390s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 390s ok 215 - extension plperlu removes without error 390s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 390s ok 217 - extension plpython3u installs without error 391s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 391s ok 219 - extension plpython3u removes without error 391s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 391s ok 221 - extension pltcl installs without error 391s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 391s ok 223 - extension pltcl removes without error 391s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 391s ok 225 - extension pltclu installs without error 391s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 391s ok 227 - extension pltclu removes without error 391s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 391s ok 229 - extension postgres_fdw installs without error 391s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 391s ok 231 - extension postgres_fdw removes without error 391s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 391s ok 233 - extension refint installs without error 391s ok 234 - psql -qc 'DROP EXTENSION "refint"' 391s ok 235 - extension refint removes without error 391s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 391s ok 237 - extension seg installs without error 391s ok 238 - psql -qc 'DROP EXTENSION "seg"' 391s ok 239 - extension seg removes without error 391s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 391s ok 241 - extension sslinfo installs without error 391s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 391s ok 243 - extension sslinfo removes without error 391s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 391s ok 245 - extension tablefunc installs without error 391s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 391s ok 247 - extension tablefunc removes without error 391s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 391s ok 249 - extension tcn installs without error 391s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 391s ok 251 - extension tcn removes without error 391s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 391s ok 253 - extension tsm_system_rows installs without error 391s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 391s ok 255 - extension tsm_system_rows removes without error 391s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 391s ok 257 - extension tsm_system_time installs without error 391s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 391s ok 259 - extension tsm_system_time removes without error 392s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 392s ok 261 - extension unaccent installs without error 392s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 392s ok 263 - extension unaccent removes without error 392s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 392s ok 265 - extension uuid-ossp installs without error 392s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 392s ok 267 - extension uuid-ossp removes without error 392s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 392s ok 269 - extension xml2 installs without error 392s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 392s ok 271 - extension xml2 removes without error 392s ok 272 - pg_dropcluster 12 main 392s ok 273 - Cleanup: No clusters left behind 392s ok 274 - No postgres processes left behind 392s ok 275 - No files in /etc/postgresql left behind 392s ok 276 - No files in /var/lib/postgresql left behind 392s ok 277 - No files in /var/run/postgresql left behind 392s ok 278 - No files in /var/log/postgresql left behind 392s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 392s ok 280 - PostgreSQL TCP ports are closed 392s 1..280 392s === Running test 180_ecpg.t ... === 392s 1..17 392s ok 1 - ecpg test.pgc 392s ok 2 - ecpg processing 392s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 392s ok 4 - compiling ecpg output 396s ok 5 - pg_createcluster 12 main 396s ok 6 - createuser nobody 396s ok 7 - /tmp/tmp.TOJcDlei5X/test 396s not ok 8 - runs and gives correct output 396s # Failed test 'runs and gives correct output' 396s # at t/TestLib.pm line 201. 396s # got: ' 396s # ' 396s # expected: 'template1 396s # ' 396s ok 9 - pg_dropcluster 12 main 396s ok 10 - Cleanup: No clusters left behind 396s ok 11 - No postgres processes left behind 396s ok 12 - No files in /etc/postgresql left behind 396s ok 13 - No files in /var/lib/postgresql left behind 396s ok 14 - No files in /var/run/postgresql left behind 396s ok 15 - No files in /var/log/postgresql left behind 396s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 396s ok 17 - PostgreSQL TCP ports are closed 396s # Looks like you failed 1 test of 17. 397s autopkgtest [03:48:41]: test run-testsuite: -----------------------] 397s autopkgtest [03:48:41]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 397s run-testsuite FAIL non-zero exit status 1 397s autopkgtest [03:48:41]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 397s # Failed test 'runs and gives correct output' 397s # at t/TestLib.pm line 201. 397s # got: ' 397s # ' 397s # expected: 'template1 397s # ' 397s # Looks like you failed 1 test of 17. 397s autopkgtest [03:48:41]: @@@@@@@@@@@@@@@@@@@@ summary 397s default-psql PASS 397s run-testsuite FAIL non-zero exit status 1 412s nova [W] Skipping flock for amd64 412s Creating nova instance adt-focal-amd64-postgresql-common-20250430-034204-juju-7f2275-prod-proposed-migration-environment-2-57e30f57-1682-414c-a1a0-a6700b80a534 from image adt/ubuntu-focal-amd64-server-20250428.img (UUID d9136e81-3de8-4a76-87d4-9426c63d0efe)... 412s nova [W] Timed out waiting for 32209542-75a7-47c8-a6b8-6ac2c8dc4e7d to get deleted. 412s nova [W] Skipping flock for amd64 412s Creating nova instance adt-focal-amd64-postgresql-common-20250430-034204-juju-7f2275-prod-proposed-migration-environment-2-57e30f57-1682-414c-a1a0-a6700b80a534 from image adt/ubuntu-focal-amd64-server-20250428.img (UUID d9136e81-3de8-4a76-87d4-9426c63d0efe)... 412s nova [W] Timed out waiting for 6b6672c2-527f-47a9-8f7b-21b825cbcbe0 to get deleted.