0s autopkgtest [13:27:14]: starting date and time: 2025-05-02 13:27:14+0000 0s autopkgtest [13:27:14]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [13:27:14]: host juju-7f2275-prod-proposed-migration-environment-21; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.sem4vl12/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:python3.13 --apt-upgrade postgresql-17 --timeout-short=1200 --timeout-copy=80000 --timeout-build=80000 --env=ADT_TEST_TRIGGERS=python3.13/3.13.3-2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-riscv64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-21@sto01-riscv64-2.secgroup --name adt-questing-riscv64-postgresql-17-20250502-111413-juju-7f2275-prod-proposed-migration-environment-21-e80aebfd-b2d9-409c-bc03-bcb3b8101340 --image adt/ubuntu-questing-riscv64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-21 --net-id=net_prod-autopkgtest-workers-riscv64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 186s autopkgtest [13:30:20]: testbed dpkg architecture: riscv64 187s autopkgtest [13:30:21]: testbed apt version: 3.0.0 188s autopkgtest [13:30:22]: @@@@@@@@@@@@@@@@@@@@ test bed setup 189s autopkgtest [13:30:23]: testbed release detected to be: None 193s autopkgtest [13:30:27]: updating testbed package index (apt update) 195s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 195s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 195s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 195s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 196s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2029 kB] 197s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.4 kB] 197s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [171 kB] 197s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 Packages [197 kB] 197s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe riscv64 Packages [788 kB] 197s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse riscv64 Packages [8624 B] 201s Fetched 3348 kB in 6s (572 kB/s) 214s Reading package lists... 218s autopkgtest [13:30:52]: upgrading testbed (apt dist-upgrade and autopurge) 219s Reading package lists... 220s Building dependency tree... 220s Reading state information... 222s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 222s Starting 2 pkgProblemResolver with broken count: 0 222s Done 224s Entering ResolveByKeep 225s 226s Calculating upgrade... 227s The following packages will be upgraded: 227s htop libnpth0t64 libpython3.13 libpython3.13-minimal libpython3.13-stdlib 227s nano python3.13 python3.13-gdbm python3.13-minimal usb.ids 227s 10 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 227s Need to get 9242 kB of archives. 227s After this operation, 7168 B of additional disk space will be used. 227s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 python3.13 riscv64 3.13.3-2 [739 kB] 227s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 libpython3.13 riscv64 3.13.3-2 [2427 kB] 228s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 libpython3.13-stdlib riscv64 3.13.3-2 [2063 kB] 228s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 python3.13-minimal riscv64 3.13.3-2 [2401 kB] 228s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 libpython3.13-minimal riscv64 3.13.3-2 [882 kB] 228s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 libnpth0t64 riscv64 1.8-3 [8790 B] 228s Get:7 http://ftpmaster.internal/ubuntu questing/main riscv64 nano riscv64 8.4-1 [299 kB] 228s Get:8 http://ftpmaster.internal/ubuntu questing/main riscv64 usb.ids all 2025.04.01-1 [223 kB] 228s Get:9 http://ftpmaster.internal/ubuntu questing/main riscv64 htop riscv64 3.4.1-4 [168 kB] 228s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 python3.13-gdbm riscv64 3.13.3-2 [31.5 kB] 233s Fetched 9242 kB in 2s (5440 kB/s) 234s (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 ... 114197 files and directories currently installed.) 234s Preparing to unpack .../0-python3.13_3.13.3-2_riscv64.deb ... 235s Unpacking python3.13 (3.13.3-2) over (3.13.3-1) ... 236s Preparing to unpack .../1-libpython3.13_3.13.3-2_riscv64.deb ... 236s Unpacking libpython3.13:riscv64 (3.13.3-2) over (3.13.3-1) ... 237s Preparing to unpack .../2-libpython3.13-stdlib_3.13.3-2_riscv64.deb ... 238s Unpacking libpython3.13-stdlib:riscv64 (3.13.3-2) over (3.13.3-1) ... 240s Preparing to unpack .../3-python3.13-minimal_3.13.3-2_riscv64.deb ... 240s Unpacking python3.13-minimal (3.13.3-2) over (3.13.3-1) ... 242s Preparing to unpack .../4-libpython3.13-minimal_3.13.3-2_riscv64.deb ... 243s Unpacking libpython3.13-minimal:riscv64 (3.13.3-2) over (3.13.3-1) ... 244s Preparing to unpack .../5-libnpth0t64_1.8-3_riscv64.deb ... 244s Unpacking libnpth0t64:riscv64 (1.8-3) over (1.8-2) ... 245s Setting up libnpth0t64:riscv64 (1.8-3) ... 246s (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 ... 114197 files and directories currently installed.) 246s Preparing to unpack .../nano_8.4-1_riscv64.deb ... 246s Unpacking nano (8.4-1) over (8.3-1) ... 247s Preparing to unpack .../usb.ids_2025.04.01-1_all.deb ... 247s Unpacking usb.ids (2025.04.01-1) over (2025.01.14-1) ... 248s Preparing to unpack .../htop_3.4.1-4_riscv64.deb ... 248s Unpacking htop (3.4.1-4) over (3.4.0-2) ... 248s Preparing to unpack .../python3.13-gdbm_3.13.3-2_riscv64.deb ... 248s Unpacking python3.13-gdbm (3.13.3-2) over (3.13.3-1) ... 249s Setting up htop (3.4.1-4) ... 249s Setting up libpython3.13-minimal:riscv64 (3.13.3-2) ... 249s Setting up usb.ids (2025.04.01-1) ... 249s Setting up nano (8.4-1) ... 249s Installing new version of config file /etc/nanorc ... 249s Setting up python3.13-minimal (3.13.3-2) ... 261s Setting up libpython3.13-stdlib:riscv64 (3.13.3-2) ... 261s Setting up python3.13-gdbm (3.13.3-2) ... 262s Setting up libpython3.13:riscv64 (3.13.3-2) ... 262s Setting up python3.13 (3.13.3-2) ... 275s Processing triggers for systemd (257.4-1ubuntu3) ... 276s Processing triggers for man-db (2.13.0-1) ... 279s Processing triggers for install-info (7.1.1-1) ... 281s Processing triggers for libc-bin (2.41-6ubuntu1) ... 287s Reading package lists... 289s Building dependency tree... 289s Reading state information... 290s Starting pkgProblemResolver with broken count: 0 290s Starting 2 pkgProblemResolver with broken count: 0 290s Done 292s Solving dependencies... 293s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 305s autopkgtest [13:32:19]: testbed running kernel: Linux 6.14.0-13-generic #13.2-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 05:26:54 UTC 2025 306s autopkgtest [13:32:20]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 362s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (dsc) [4245 B] 362s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (tar) [21.5 MB] 362s Get:3 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (diff) [27.2 kB] 364s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 364s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 364s gpgv: Can't check signature: No public key 364s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 393s autopkgtest [13:33:47]: testing package postgresql-17 version 17.4-1 395s autopkgtest [13:33:49]: build not needed 412s autopkgtest [13:34:06]: test run-testsuite: preparing testbed 415s Reading package lists... 417s Building dependency tree... 417s Reading state information... 418s Starting pkgProblemResolver with broken count: 0 418s Starting 2 pkgProblemResolver with broken count: 0 418s Done 420s The following NEW packages will be installed: 420s autoconf automake autopoint autotools-dev build-essential cpp cpp-14 420s cpp-14-riscv64-linux-gnu cpp-riscv64-linux-gnu debhelper debugedit 420s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 420s fakeroot g++ g++-14 g++-14-riscv64-linux-gnu g++-riscv64-linux-gnu gcc 420s gcc-14 gcc-14-riscv64-linux-gnu gcc-riscv64-linux-gnu gettext hunspell-en-us 420s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libdebhelper-perl 420s libecpg-compat3 libecpg-dev libecpg6 libfakeroot 420s libfile-stripnondeterminism-perl libgcc-14-dev libgomp1 libio-pty-perl 420s libipc-run-perl libisl23 libitm1 libjson-perl liblsan0 libmpc3 libpgtypes3 420s libpq-dev libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool libtsan2 420s libubsan1 libxslt1.1 locales-all m4 po-debconf postgresql-17 420s postgresql-client-17 postgresql-client-common postgresql-common 420s postgresql-common-dev postgresql-doc-17 postgresql-plperl-17 420s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 420s ssl-cert 421s 0 upgraded, 70 newly installed, 0 to remove and 0 not upgraded. 421s Need to get 121 MB of archives. 421s After this operation, 747 MB of additional disk space will be used. 421s Get:1 http://ftpmaster.internal/ubuntu questing/main riscv64 libjson-perl all 4.10000-1 [81.9 kB] 421s Get:2 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-client-common all 274 [47.6 kB] 421s Get:3 http://ftpmaster.internal/ubuntu questing/main riscv64 libio-pty-perl riscv64 1:1.20-1build3 [31.6 kB] 421s Get:4 http://ftpmaster.internal/ubuntu questing/main riscv64 libipc-run-perl all 20231003.0-2 [91.5 kB] 421s Get:5 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-common-dev all 274 [73.0 kB] 421s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 421s Get:7 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-common all 274 [101 kB] 421s Get:8 http://ftpmaster.internal/ubuntu questing/main riscv64 m4 riscv64 1.4.19-7 [268 kB] 421s Get:9 http://ftpmaster.internal/ubuntu questing/main riscv64 autoconf all 2.72-3ubuntu1 [383 kB] 421s Get:10 http://ftpmaster.internal/ubuntu questing/main riscv64 autotools-dev all 20220109.1 [44.9 kB] 421s Get:11 http://ftpmaster.internal/ubuntu questing/main riscv64 automake all 1:1.17-3ubuntu1 [572 kB] 421s Get:12 http://ftpmaster.internal/ubuntu questing/main riscv64 autopoint all 0.23.1-1 [619 kB] 421s Get:13 http://ftpmaster.internal/ubuntu questing/main riscv64 libisl23 riscv64 0.27-1 [722 kB] 421s Get:14 http://ftpmaster.internal/ubuntu questing/main riscv64 libmpc3 riscv64 1.3.1-1build2 [61.5 kB] 421s Get:15 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [15.2 MB] 423s Get:16 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14 riscv64 14.2.0-19ubuntu2 [1028 B] 423s Get:17 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [5554 B] 423s Get:18 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp riscv64 4:14.2.0-1ubuntu1 [22.4 kB] 423s Get:19 http://ftpmaster.internal/ubuntu questing/main riscv64 libcc1-0 riscv64 15-20250404-0ubuntu1 [46.1 kB] 423s Get:20 http://ftpmaster.internal/ubuntu questing/main riscv64 libgomp1 riscv64 15-20250404-0ubuntu1 [149 kB] 423s Get:21 http://ftpmaster.internal/ubuntu questing/main riscv64 libitm1 riscv64 15-20250404-0ubuntu1 [29.7 kB] 423s Get:22 http://ftpmaster.internal/ubuntu questing/main riscv64 libasan8 riscv64 15-20250404-0ubuntu1 [3300 kB] 423s Get:23 http://ftpmaster.internal/ubuntu questing/main riscv64 liblsan0 riscv64 15-20250404-0ubuntu1 [1470 kB] 424s Get:24 http://ftpmaster.internal/ubuntu questing/main riscv64 libtsan2 riscv64 15-20250404-0ubuntu1 [2983 kB] 424s Get:25 http://ftpmaster.internal/ubuntu questing/main riscv64 libubsan1 riscv64 15-20250404-0ubuntu1 [1310 kB] 424s Get:26 http://ftpmaster.internal/ubuntu questing/main riscv64 libgcc-14-dev riscv64 14.2.0-19ubuntu2 [5994 kB] 425s Get:27 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [29.9 MB] 428s Get:28 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14 riscv64 14.2.0-19ubuntu2 [529 kB] 428s Get:29 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [1198 B] 428s Get:30 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc riscv64 4:14.2.0-1ubuntu1 [4998 B] 428s Get:31 http://ftpmaster.internal/ubuntu questing/main riscv64 libstdc++-14-dev riscv64 14.2.0-19ubuntu2 [6141 kB] 429s Get:32 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [16.8 MB] 431s Get:33 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14 riscv64 14.2.0-19ubuntu2 [23.0 kB] 431s Get:34 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [960 B] 431s Get:35 http://ftpmaster.internal/ubuntu questing/main riscv64 g++ riscv64 4:14.2.0-1ubuntu1 [1080 B] 431s Get:36 http://ftpmaster.internal/ubuntu questing/main riscv64 build-essential riscv64 12.12ubuntu1 [5090 B] 431s Get:37 http://ftpmaster.internal/ubuntu questing/main riscv64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 431s Get:38 http://ftpmaster.internal/ubuntu questing/main riscv64 libtool all 2.5.4-4 [168 kB] 431s Get:39 http://ftpmaster.internal/ubuntu questing/main riscv64 dh-autoreconf all 20 [16.1 kB] 431s Get:40 http://ftpmaster.internal/ubuntu questing/main riscv64 libarchive-zip-perl all 1.68-1 [90.2 kB] 431s Get:41 http://ftpmaster.internal/ubuntu questing/main riscv64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 431s Get:42 http://ftpmaster.internal/ubuntu questing/main riscv64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 431s Get:43 http://ftpmaster.internal/ubuntu questing/main riscv64 debugedit riscv64 1:5.1-2 [53.9 kB] 431s Get:44 http://ftpmaster.internal/ubuntu questing/main riscv64 dwz riscv64 0.15-1build6 [125 kB] 431s Get:45 http://ftpmaster.internal/ubuntu questing/main riscv64 gettext riscv64 0.23.1-1 [1201 kB] 431s Get:46 http://ftpmaster.internal/ubuntu questing/main riscv64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 431s Get:47 http://ftpmaster.internal/ubuntu questing/main riscv64 po-debconf all 1.0.21+nmu1 [233 kB] 431s Get:48 http://ftpmaster.internal/ubuntu questing/main riscv64 debhelper all 13.24.1ubuntu2 [895 kB] 431s Get:49 http://ftpmaster.internal/ubuntu questing/main riscv64 emacsen-common all 3.0.7 [13.0 kB] 431s Get:50 http://ftpmaster.internal/ubuntu questing/main riscv64 dictionaries-common all 1.30.10 [178 kB] 431s Get:51 http://ftpmaster.internal/ubuntu questing/main riscv64 libfakeroot riscv64 1.37.1-1 [35.7 kB] 431s Get:52 http://ftpmaster.internal/ubuntu questing/main riscv64 fakeroot riscv64 1.37.1-1 [80.6 kB] 431s Get:53 http://ftpmaster.internal/ubuntu questing/main riscv64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 431s Get:54 http://ftpmaster.internal/ubuntu questing/main riscv64 libpgtypes3 riscv64 17.4-1 [48.7 kB] 431s Get:55 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq5 riscv64 17.4-1 [148 kB] 432s Get:56 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg6 riscv64 17.4-1 [45.9 kB] 432s Get:57 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg-compat3 riscv64 17.4-1 [12.9 kB] 432s Get:58 http://ftpmaster.internal/ubuntu questing/main riscv64 libssl-dev riscv64 3.4.1-1ubuntu3 [6164 kB] 432s Get:59 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq-dev riscv64 17.4-1 [307 kB] 432s Get:60 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg-dev riscv64 17.4-1 [393 kB] 432s Get:61 http://ftpmaster.internal/ubuntu questing/main riscv64 libtcl8.6 riscv64 8.6.16+dfsg-1 [1064 kB] 432s Get:62 http://ftpmaster.internal/ubuntu questing/main riscv64 libxslt1.1 riscv64 1.1.39-0exp1ubuntu4 [178 kB] 432s Get:63 http://ftpmaster.internal/ubuntu questing/universe riscv64 locales-all riscv64 2.41-6ubuntu1 [11.2 MB] 434s Get:64 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-client-17 riscv64 17.4-1 [1387 kB] 434s Get:65 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-17 riscv64 17.4-1 [5505 kB] 435s Get:66 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-doc-17 all 17.4-1 [2131 kB] 435s Get:67 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-plperl-17 riscv64 17.4-1 [50.9 kB] 435s Get:68 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-plpython3-17 riscv64 17.4-1 [57.7 kB] 435s Get:69 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-pltcl-17 riscv64 17.4-1 [30.7 kB] 435s Get:70 http://ftpmaster.internal/ubuntu questing/universe riscv64 postgresql-server-dev-17 riscv64 17.4-1 [1663 kB] 441s Preconfiguring packages ... 442s Fetched 121 MB in 15s (8236 kB/s) 443s Selecting previously unselected package libjson-perl. 444s (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 ... 114197 files and directories currently installed.) 444s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 444s Unpacking libjson-perl (4.10000-1) ... 444s Selecting previously unselected package postgresql-client-common. 444s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 444s Unpacking postgresql-client-common (274) ... 445s Selecting previously unselected package libio-pty-perl. 445s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_riscv64.deb ... 445s Unpacking libio-pty-perl (1:1.20-1build3) ... 445s Selecting previously unselected package libipc-run-perl. 445s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 445s Unpacking libipc-run-perl (20231003.0-2) ... 446s Selecting previously unselected package postgresql-common-dev. 446s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 446s Unpacking postgresql-common-dev (274) ... 447s Selecting previously unselected package ssl-cert. 447s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 447s Unpacking ssl-cert (1.1.3ubuntu1) ... 447s Selecting previously unselected package postgresql-common. 447s Preparing to unpack .../06-postgresql-common_274_all.deb ... 448s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 448s Unpacking postgresql-common (274) ... 448s Selecting previously unselected package m4. 448s Preparing to unpack .../07-m4_1.4.19-7_riscv64.deb ... 448s Unpacking m4 (1.4.19-7) ... 449s Selecting previously unselected package autoconf. 449s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 449s Unpacking autoconf (2.72-3ubuntu1) ... 450s Selecting previously unselected package autotools-dev. 450s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 450s Unpacking autotools-dev (20220109.1) ... 450s Selecting previously unselected package automake. 450s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 450s Unpacking automake (1:1.17-3ubuntu1) ... 451s Selecting previously unselected package autopoint. 451s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 451s Unpacking autopoint (0.23.1-1) ... 452s Selecting previously unselected package libisl23:riscv64. 452s Preparing to unpack .../12-libisl23_0.27-1_riscv64.deb ... 452s Unpacking libisl23:riscv64 (0.27-1) ... 452s Selecting previously unselected package libmpc3:riscv64. 452s Preparing to unpack .../13-libmpc3_1.3.1-1build2_riscv64.deb ... 452s Unpacking libmpc3:riscv64 (1.3.1-1build2) ... 453s Selecting previously unselected package cpp-14-riscv64-linux-gnu. 453s Preparing to unpack .../14-cpp-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 453s Unpacking cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 460s Selecting previously unselected package cpp-14. 460s Preparing to unpack .../15-cpp-14_14.2.0-19ubuntu2_riscv64.deb ... 460s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 460s Selecting previously unselected package cpp-riscv64-linux-gnu. 460s Preparing to unpack .../16-cpp-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 460s Unpacking cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 461s Selecting previously unselected package cpp. 461s Preparing to unpack .../17-cpp_4%3a14.2.0-1ubuntu1_riscv64.deb ... 461s Unpacking cpp (4:14.2.0-1ubuntu1) ... 461s Selecting previously unselected package libcc1-0:riscv64. 461s Preparing to unpack .../18-libcc1-0_15-20250404-0ubuntu1_riscv64.deb ... 461s Unpacking libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 462s Selecting previously unselected package libgomp1:riscv64. 462s Preparing to unpack .../19-libgomp1_15-20250404-0ubuntu1_riscv64.deb ... 462s Unpacking libgomp1:riscv64 (15-20250404-0ubuntu1) ... 462s Selecting previously unselected package libitm1:riscv64. 462s Preparing to unpack .../20-libitm1_15-20250404-0ubuntu1_riscv64.deb ... 462s Unpacking libitm1:riscv64 (15-20250404-0ubuntu1) ... 463s Selecting previously unselected package libasan8:riscv64. 463s Preparing to unpack .../21-libasan8_15-20250404-0ubuntu1_riscv64.deb ... 463s Unpacking libasan8:riscv64 (15-20250404-0ubuntu1) ... 465s Selecting previously unselected package liblsan0:riscv64. 465s Preparing to unpack .../22-liblsan0_15-20250404-0ubuntu1_riscv64.deb ... 465s Unpacking liblsan0:riscv64 (15-20250404-0ubuntu1) ... 466s Selecting previously unselected package libtsan2:riscv64. 466s Preparing to unpack .../23-libtsan2_15-20250404-0ubuntu1_riscv64.deb ... 466s Unpacking libtsan2:riscv64 (15-20250404-0ubuntu1) ... 468s Selecting previously unselected package libubsan1:riscv64. 468s Preparing to unpack .../24-libubsan1_15-20250404-0ubuntu1_riscv64.deb ... 468s Unpacking libubsan1:riscv64 (15-20250404-0ubuntu1) ... 469s Selecting previously unselected package libgcc-14-dev:riscv64. 469s Preparing to unpack .../25-libgcc-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 469s Unpacking libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 475s Selecting previously unselected package gcc-14-riscv64-linux-gnu. 475s Preparing to unpack .../26-gcc-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 475s Unpacking gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 488s Selecting previously unselected package gcc-14. 488s Preparing to unpack .../27-gcc-14_14.2.0-19ubuntu2_riscv64.deb ... 488s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 488s Selecting previously unselected package gcc-riscv64-linux-gnu. 489s Preparing to unpack .../28-gcc-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 489s Unpacking gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 489s Selecting previously unselected package gcc. 489s Preparing to unpack .../29-gcc_4%3a14.2.0-1ubuntu1_riscv64.deb ... 489s Unpacking gcc (4:14.2.0-1ubuntu1) ... 489s Selecting previously unselected package libstdc++-14-dev:riscv64. 490s Preparing to unpack .../30-libstdc++-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 490s Unpacking libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 496s Selecting previously unselected package g++-14-riscv64-linux-gnu. 496s Preparing to unpack .../31-g++-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 496s Unpacking g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 503s Selecting previously unselected package g++-14. 503s Preparing to unpack .../32-g++-14_14.2.0-19ubuntu2_riscv64.deb ... 503s Unpacking g++-14 (14.2.0-19ubuntu2) ... 504s Selecting previously unselected package g++-riscv64-linux-gnu. 504s Preparing to unpack .../33-g++-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 504s Unpacking g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 504s Selecting previously unselected package g++. 504s Preparing to unpack .../34-g++_4%3a14.2.0-1ubuntu1_riscv64.deb ... 504s Unpacking g++ (4:14.2.0-1ubuntu1) ... 505s Selecting previously unselected package build-essential. 505s Preparing to unpack .../35-build-essential_12.12ubuntu1_riscv64.deb ... 505s Unpacking build-essential (12.12ubuntu1) ... 505s Selecting previously unselected package libdebhelper-perl. 505s Preparing to unpack .../36-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 505s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 506s Selecting previously unselected package libtool. 506s Preparing to unpack .../37-libtool_2.5.4-4_all.deb ... 506s Unpacking libtool (2.5.4-4) ... 506s Selecting previously unselected package dh-autoreconf. 506s Preparing to unpack .../38-dh-autoreconf_20_all.deb ... 506s Unpacking dh-autoreconf (20) ... 507s Selecting previously unselected package libarchive-zip-perl. 507s Preparing to unpack .../39-libarchive-zip-perl_1.68-1_all.deb ... 507s Unpacking libarchive-zip-perl (1.68-1) ... 507s Selecting previously unselected package libfile-stripnondeterminism-perl. 507s Preparing to unpack .../40-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 507s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 508s Selecting previously unselected package dh-strip-nondeterminism. 508s Preparing to unpack .../41-dh-strip-nondeterminism_1.14.1-2_all.deb ... 508s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 508s Selecting previously unselected package debugedit. 508s Preparing to unpack .../42-debugedit_1%3a5.1-2_riscv64.deb ... 508s Unpacking debugedit (1:5.1-2) ... 509s Selecting previously unselected package dwz. 509s Preparing to unpack .../43-dwz_0.15-1build6_riscv64.deb ... 509s Unpacking dwz (0.15-1build6) ... 509s Selecting previously unselected package gettext. 509s Preparing to unpack .../44-gettext_0.23.1-1_riscv64.deb ... 509s Unpacking gettext (0.23.1-1) ... 510s Selecting previously unselected package intltool-debian. 510s Preparing to unpack .../45-intltool-debian_0.35.0+20060710.6_all.deb ... 510s Unpacking intltool-debian (0.35.0+20060710.6) ... 511s Selecting previously unselected package po-debconf. 511s Preparing to unpack .../46-po-debconf_1.0.21+nmu1_all.deb ... 511s Unpacking po-debconf (1.0.21+nmu1) ... 511s Selecting previously unselected package debhelper. 512s Preparing to unpack .../47-debhelper_13.24.1ubuntu2_all.deb ... 512s Unpacking debhelper (13.24.1ubuntu2) ... 512s Selecting previously unselected package emacsen-common. 513s Preparing to unpack .../48-emacsen-common_3.0.7_all.deb ... 513s Unpacking emacsen-common (3.0.7) ... 513s Selecting previously unselected package dictionaries-common. 513s Preparing to unpack .../49-dictionaries-common_1.30.10_all.deb ... 514s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 514s Unpacking dictionaries-common (1.30.10) ... 514s Selecting previously unselected package libfakeroot:riscv64. 514s Preparing to unpack .../50-libfakeroot_1.37.1-1_riscv64.deb ... 514s Unpacking libfakeroot:riscv64 (1.37.1-1) ... 515s Selecting previously unselected package fakeroot. 515s Preparing to unpack .../51-fakeroot_1.37.1-1_riscv64.deb ... 515s Unpacking fakeroot (1.37.1-1) ... 515s Selecting previously unselected package hunspell-en-us. 515s Preparing to unpack .../52-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 515s Unpacking hunspell-en-us (1:2020.12.07-4) ... 516s Selecting previously unselected package libpgtypes3:riscv64. 516s Preparing to unpack .../53-libpgtypes3_17.4-1_riscv64.deb ... 516s Unpacking libpgtypes3:riscv64 (17.4-1) ... 516s Selecting previously unselected package libpq5:riscv64. 517s Preparing to unpack .../54-libpq5_17.4-1_riscv64.deb ... 517s Unpacking libpq5:riscv64 (17.4-1) ... 517s Selecting previously unselected package libecpg6:riscv64. 517s Preparing to unpack .../55-libecpg6_17.4-1_riscv64.deb ... 517s Unpacking libecpg6:riscv64 (17.4-1) ... 517s Selecting previously unselected package libecpg-compat3:riscv64. 518s Preparing to unpack .../56-libecpg-compat3_17.4-1_riscv64.deb ... 518s Unpacking libecpg-compat3:riscv64 (17.4-1) ... 518s Selecting previously unselected package libssl-dev:riscv64. 518s Preparing to unpack .../57-libssl-dev_3.4.1-1ubuntu3_riscv64.deb ... 518s Unpacking libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 524s Selecting previously unselected package libpq-dev. 524s Preparing to unpack .../58-libpq-dev_17.4-1_riscv64.deb ... 524s Unpacking libpq-dev (17.4-1) ... 525s Selecting previously unselected package libecpg-dev. 525s Preparing to unpack .../59-libecpg-dev_17.4-1_riscv64.deb ... 525s Unpacking libecpg-dev (17.4-1) ... 526s Selecting previously unselected package libtcl8.6:riscv64. 526s Preparing to unpack .../60-libtcl8.6_8.6.16+dfsg-1_riscv64.deb ... 526s Unpacking libtcl8.6:riscv64 (8.6.16+dfsg-1) ... 527s Selecting previously unselected package libxslt1.1:riscv64. 527s Preparing to unpack .../61-libxslt1.1_1.1.39-0exp1ubuntu4_riscv64.deb ... 527s Unpacking libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 527s Selecting previously unselected package locales-all. 528s Preparing to unpack .../62-locales-all_2.41-6ubuntu1_riscv64.deb ... 528s Unpacking locales-all (2.41-6ubuntu1) ... 553s Selecting previously unselected package postgresql-client-17. 553s Preparing to unpack .../63-postgresql-client-17_17.4-1_riscv64.deb ... 553s Unpacking postgresql-client-17 (17.4-1) ... 555s Selecting previously unselected package postgresql-17. 555s Preparing to unpack .../64-postgresql-17_17.4-1_riscv64.deb ... 555s Unpacking postgresql-17 (17.4-1) ... 558s Selecting previously unselected package postgresql-doc-17. 558s Preparing to unpack .../65-postgresql-doc-17_17.4-1_all.deb ... 558s Unpacking postgresql-doc-17 (17.4-1) ... 561s Selecting previously unselected package postgresql-plperl-17. 561s Preparing to unpack .../66-postgresql-plperl-17_17.4-1_riscv64.deb ... 561s Unpacking postgresql-plperl-17 (17.4-1) ... 562s Selecting previously unselected package postgresql-plpython3-17. 562s Preparing to unpack .../67-postgresql-plpython3-17_17.4-1_riscv64.deb ... 562s Unpacking postgresql-plpython3-17 (17.4-1) ... 562s Selecting previously unselected package postgresql-pltcl-17. 562s Preparing to unpack .../68-postgresql-pltcl-17_17.4-1_riscv64.deb ... 562s Unpacking postgresql-pltcl-17 (17.4-1) ... 563s Selecting previously unselected package postgresql-server-dev-17. 563s Preparing to unpack .../69-postgresql-server-dev-17_17.4-1_riscv64.deb ... 563s Unpacking postgresql-server-dev-17 (17.4-1) ... 565s Setting up postgresql-client-common (274) ... 566s Setting up libpgtypes3:riscv64 (17.4-1) ... 566s Setting up libio-pty-perl (1:1.20-1build3) ... 566s Setting up libarchive-zip-perl (1.68-1) ... 566s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 566s Setting up postgresql-doc-17 (17.4-1) ... 571s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 571s Setting up libpq5:riscv64 (17.4-1) ... 571s Setting up m4 (1.4.19-7) ... 571s Setting up libgomp1:riscv64 (15-20250404-0ubuntu1) ... 571s Setting up locales-all (2.41-6ubuntu1) ... 571s Setting up libfakeroot:riscv64 (1.37.1-1) ... 571s Setting up fakeroot (1.37.1-1) ... 571s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 571s Setting up autotools-dev (20220109.1) ... 571s Setting up emacsen-common (3.0.7) ... 572s Setting up ssl-cert (1.1.3ubuntu1) ... 581s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 587s Setting up libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 587s Setting up libmpc3:riscv64 (1.3.1-1build2) ... 587s Setting up libtcl8.6:riscv64 (8.6.16+dfsg-1) ... 587s Setting up autopoint (0.23.1-1) ... 587s Setting up libipc-run-perl (20231003.0-2) ... 587s Setting up autoconf (2.72-3ubuntu1) ... 587s Setting up libubsan1:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up dwz (0.15-1build6) ... 587s Setting up libasan8:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up libjson-perl (4.10000-1) ... 587s Setting up libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 587s Setting up debugedit (1:5.1-2) ... 587s Setting up libecpg6:riscv64 (17.4-1) ... 587s Setting up libtsan2:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up libisl23:riscv64 (0.27-1) ... 587s Setting up libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up liblsan0:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up libitm1:riscv64 (15-20250404-0ubuntu1) ... 587s Setting up postgresql-common-dev (274) ... 587s Setting up automake (1:1.17-3ubuntu1) ... 588s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 588s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 588s Setting up gettext (0.23.1-1) ... 588s Setting up libecpg-compat3:riscv64 (17.4-1) ... 588s Setting up dictionaries-common (1.30.10) ... 595s Setting up postgresql-client-17 (17.4-1) ... 611s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 612s Setting up libpq-dev (17.4-1) ... 612s Setting up cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 612s Setting up libecpg-dev (17.4-1) ... 612s Setting up intltool-debian (0.35.0+20060710.6) ... 612s Setting up postgresql-common (274) ... 620s Creating config file /etc/postgresql-common/createcluster.conf with new version 624s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 624s en_us 624s Removing obsolete dictionary files: 636s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 642s Setting up cpp-14 (14.2.0-19ubuntu2) ... 642s Setting up dh-strip-nondeterminism (1.14.1-2) ... 642s Setting up hunspell-en-us (1:2020.12.07-4) ... 643s Setting up libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 643s Setting up cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 643s Setting up libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 643s Setting up postgresql-17 (17.4-1) ... 666s Creating new PostgreSQL cluster 17/main ... 666s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 666s The files belonging to this database system will be owned by user "postgres". 666s This user must also own the server process. 666s 666s The database cluster will be initialized with locale "C.UTF-8". 666s The default database encoding has accordingly been set to "UTF8". 666s The default text search configuration will be set to "english". 666s 666s Data page checksums are disabled. 666s 666s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 666s creating subdirectories ... ok 666s selecting dynamic shared memory implementation ... posix 667s selecting default "max_connections" ... 100 667s selecting default "shared_buffers" ... 128MB 667s selecting default time zone ... Etc/UTC 667s creating configuration files ... ok 670s running bootstrap script ... ok 678s performing post-bootstrap initialization ... ok 678s syncing data to disk ... ok 695s Setting up po-debconf (1.0.21+nmu1) ... 695s Setting up postgresql-server-dev-17 (17.4-1) ... 695s Setting up gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 695s Setting up postgresql-plpython3-17 (17.4-1) ... 695s Setting up postgresql-plperl-17 (17.4-1) ... 695s Setting up cpp (4:14.2.0-1ubuntu1) ... 695s Setting up g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 695s Setting up postgresql-pltcl-17 (17.4-1) ... 695s Setting up gcc-14 (14.2.0-19ubuntu2) ... 695s Setting up gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 695s Setting up g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 695s Setting up g++-14 (14.2.0-19ubuntu2) ... 695s Setting up libtool (2.5.4-4) ... 695s Setting up gcc (4:14.2.0-1ubuntu1) ... 695s Setting up dh-autoreconf (20) ... 695s Setting up g++ (4:14.2.0-1ubuntu1) ... 695s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 695s Setting up build-essential (12.12ubuntu1) ... 695s Setting up debhelper (13.24.1ubuntu2) ... 695s Processing triggers for install-info (7.1.1-1) ... 698s Processing triggers for libc-bin (2.41-6ubuntu1) ... 698s Processing triggers for man-db (2.13.0-1) ... 706s Processing triggers for dictionaries-common (1.30.10) ... 727s autopkgtest [13:39:21]: test run-testsuite: [----------------------- 735s ====== Running all tests with umask 077 ======= 735s ### PostgreSQL test 001_packages.t ### 737s 1..22 737s ok 1 - /etc/os-release exists 737s ok 2 - OS is ubuntu 737s ok 3 - OS version is 25.10 737s # PostgreSQL versions installed: 17 737s ok 4 - postgresql-17 installed 737s ok 5 - postgresql-plpython3-17 installed 737s ok 6 - postgresql-plperl-17 installed 738s ok 7 - postgresql-pltcl-17 installed 738s ok 8 - postgresql-server-dev-17 installed 738s ok 9 # skip No postgresql-contrib-17 package for version 17 738s # postgresql-doc-17 installed 738s ok 10 - At least one doc package installed 738s ok 11 - libecpg-dev installed 738s ok 12 - postgresql-common-dev installed 739s ok 13 - procps installed 739s ok 14 - netcat-openbsd installed 739s ok 15 - hunspell-en-us installed 739s ok 16 - system has a default UTF-8 locale 739s ok 17 - locale ru_RU exists 739s ok 18 - locale ru_RU.UTF-8 exists 739s ok 19 - user postgres in the UNIX group ssl-cert 739s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 739s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 739s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 739s ### End test 001_packages.t ### 739s 739s ### PostgreSQL test 002_existing_clusters.t ### 740s 1..8 740s # Cleanup 741s ok 1 - Cleanup: No clusters left behind 742s ok 2 - No postgres processes left behind 742s ok 3 - No files in /etc/postgresql left behind 742s ok 4 - No files in /var/lib/postgresql left behind 742s ok 5 - No files in /var/run/postgresql left behind 742s ok 6 - No files in /var/log/postgresql left behind 742s ok 7 - PostgreSQL TCP ports are closed 742s ok 8 - Next free port is 5432 742s ### End test 002_existing_clusters.t ### 742s 742s ### PostgreSQL test 003_alternatives.t ### 743s 1..9 743s # Newest PG version installed is 17 743s ok 1 - psql.1.gz link group 744s ok 2 - postmaster.1.gz link group does not exist 744s ok 3 - psql.1.gz alternative 744s ok 4 - pg_dump.1.gz alternative 744s ok 5 - postgres.1.gz alternative 744s ok 6 - pg_ctl.1.gz alternative 744s # Newest PG doc version installed is 17 744s ok 7 - SPI_connect.3.gz link group 744s ok 8 - SPI_connect.3.gz alternative 744s ok 9 - SPI_exec.3.gz alternative 744s ### End test 003_alternatives.t ### 744s 744s ### PostgreSQL test 005_PgCommon.t ### 746s 1..24 746s ok 1 - correctly parsed line 'local all postgres ident sameuser' 746s ok 2 - correctly parsed line 'local foo nobody trust' 746s ok 3 - correctly parsed line 'local foo nobody crypt' 746s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 746s ok 5 - correctly parsed line 'local foo,bar nobody ident' 746s ok 6 - correctly parsed line 'local all +foogrp password' 746s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 746s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 746s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 746s ok 10 - @expected_records has correct number of entries 746s ok 11 - returned read_pg_hba array has correct number of records 746s ok 12 - line 'foo all all md5' parsed as invalid 746s ok 13 - line 'local all all foo' parsed as invalid 746s ok 14 - line 'host all all foo' parsed as invalid 746s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 746s ok 16 - line 'host all all md5' parsed as invalid 746s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 746s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 746s ok 19 - read_conf_file returns empty dict for nonexisting file 746s ok 20 - read_conf_file() parsing 746s ok 21 - read_conf_file() parsing with include directives 746s ok 22 - set_conf_value 746s ok 23 - disable_conf_value 746s ok 24 - replace_conf_value 746s ### End test 005_PgCommon.t ### 746s 746s ### PostgreSQL test 006_next_free_port.t ### 747s 1..5 747s ok 1 - next_free_port is 5432 748s ok 2 - next_free_port detects localhost ipv4 socket 749s ok 3 - next_free_port detects wildcard ipv4 socket 750s ok 4 - next_free_port detects localhost ipv6 socket 751s ok 5 - next_free_port detects wildcard ipv6 socket 751s ### End test 006_next_free_port.t ### 751s 751s ### PostgreSQL test 007_pg_conftool.t ### 752s 1..41 753s # test without cluster 754s ok 1 - pg_conftool show all 754s ok 2 - correct output of pg_conftool show all 755s ok 3 - pg_conftool foo.conf show all 755s ok 4 - correct output of pg_conftool foo.conf show all 756s ok 5 - pg_conftool /tmp/FVNF51mgpj/different.conf show all 756s ok 6 - correct output of pg_conftool /tmp/FVNF51mgpj/different.conf show all 757s ok 7 - pg_conftool 9.7 main show all 757s ok 8 - correct output of pg_conftool 9.7 main show all 757s # test show 758s ok 9 - pg_conftool show all 758s ok 10 - correct output of pg_conftool show all 759s ok 11 - pg_conftool other.conf show all 759s ok 12 - correct output of pg_conftool other.conf show all 760s ok 13 - pg_conftool /tmp/FVNF51mgpj/different.conf show all 760s ok 14 - correct output of pg_conftool /tmp/FVNF51mgpj/different.conf show all 760s ok 15 - pg_conftool 17 main show all 760s ok 16 - correct output of pg_conftool 17 main show all 761s ok 17 - pg_conftool 17 main other.conf show all 761s ok 18 - correct output of pg_conftool 17 main other.conf show all 762s ok 19 - pg_conftool show a 762s ok 20 - correct output of pg_conftool show a 763s ok 21 - pg_conftool -s show a 763s ok 22 - correct output of pg_conftool -s show a 763s # test set 764s ok 23 - pg_conftool set c 7 764s ok 24 - correct output of pg_conftool set c 7 764s ok 25 - file contains new setting 765s ok 26 - pg_conftool set a 8 765s ok 27 - correct output of pg_conftool set a 8 765s ok 28 - file contains updated setting 766s ok 29 - pg_conftool /tmp/FVNF51mgpj/different.conf set a 9 766s ok 30 - correct output of pg_conftool /tmp/FVNF51mgpj/different.conf set a 9 766s ok 31 - file with path contains updated setting 766s # test remove 767s ok 32 - pg_conftool remove a 767s ok 33 - correct output of pg_conftool remove a 767s ok 34 - setting removed from file 768s ok 35 - pg_conftool /tmp/FVNF51mgpj/different.conf remove a 768s ok 36 - correct output of pg_conftool /tmp/FVNF51mgpj/different.conf remove a 768s ok 37 - setting removed from file with path 768s # test edit 768s ok 38 - pg_conftool edit 768s ok 39 - correct output of pg_conftool edit 769s ok 40 - pg_conftool /tmp/FVNF51mgpj/different.conf edit 769s ok 41 - correct output of pg_conftool /tmp/FVNF51mgpj/different.conf edit 769s ### End test 007_pg_conftool.t ### 769s 770s ### PostgreSQL test 010_defaultport_cluster.t ### 771s 1..14 772s ok 1 - psql --version 772s ok 2 - pg_wrapper selects highest available version number 773s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 773s ok 4 - connecting to localhost fails with no clusters 773s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 773s ok 6 - pg_wrapper uses host and port from PGCLUSTER 775s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 775s ok 8 - pg_wrapper uses --cluster from the command line 775s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 775s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 777s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 777s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 778s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 778s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 778s ### End test 010_defaultport_cluster.t ### 778s 778s ### PostgreSQL test 015_start_stop.t ### 779s 1..71 779s # We are running systemd 779s # Running tests for 17 779s # Cluster does not exist yet 780s ok 1 - cluster 17 main does not exist 781s ok 2 - service postgresql@17-main does not exist 781s ok 3 - systemctl start postgresql 782s ok 4 - cluster 17 main does not exist 782s ok 5 - service postgresql@17-main does not exist 782s ok 6 - systemctl start postgresql@17-main 783s ok 7 - cluster 17 main does not exist 784s ok 8 - service postgresql@17-main does not exist 784s # Start/stop postgresql using system tools 803s ok 9 - pg_createcluster 17 main 804s ok 10 - cluster 17 main is stopped 804s ok 11 - service postgresql@17-main is stopped 810s ok 12 - systemctl start postgresql 811s ok 13 - cluster 17 main is running 811s ok 14 - service postgresql@17-main is running 811s ok 15 - systemctl start postgresql 812s ok 16 - cluster 17 main is already running 813s ok 17 - service postgresql@17-main is already running 813s ok 18 - systemctl stop postgresql 820s ok 19 - cluster 17 main is stopped 820s ok 20 - service postgresql@17-main is stopped 820s ok 21 - systemctl stop postgresql 821s ok 22 - cluster 17 main is already stopped 822s ok 23 - service postgresql@17-main is already stopped 822s # Start/stop specific cluster using system tools 827s ok 24 - systemctl start postgresql@17-main 828s ok 25 - cluster 17 main is running 828s ok 26 - service postgresql@17-main is running 828s ok 27 - systemctl start postgresql@17-main 829s ok 28 - cluster 17 main is running 830s ok 29 - service postgresql@17-main is running 836s ok 30 - systemctl restart postgresql@17-main 837s ok 31 - cluster 17 main is running 837s ok 32 - service postgresql@17-main is running 839s ok 33 - systemctl stop postgresql@17-main 841s ok 34 - cluster 17 main is stopped 841s ok 35 - service postgresql@17-main is stopped 841s ok 36 - systemctl stop postgresql@17-main 842s ok 37 - cluster 17 main is already stopped 843s ok 38 - service postgresql@17-main is already stopped 863s ok 39 - pg_dropcluster 17 main 864s ok 40 - cluster 17 main does not exist 864s ok 41 - service postgresql@17-main does not exist 864s # Start/stop specific cluster using pg_*cluster 865s ok 42 - pg_ctlcluster start 17 main 866s ok 43 - cluster 17 main does not exist 867s ok 44 - service postgresql@17-main does not exist 892s ok 45 - pg_createcluster 17 main --start 893s ok 46 - cluster 17 main is running 894s ok 47 - service postgresql@17-main is running 895s ok 48 - pg_ctlcluster 17 main start 896s ok 49 - cluster 17 main is already running 896s ok 50 - service postgresql@17-main is already running 904s ok 51 - pg_ctlcluster 17-main restart 905s ok 52 - cluster 17 main is running 906s ok 53 - service postgresql@17-main is running 908s ok 54 - pg_ctlcluster 17 main stop 910s ok 55 - cluster 17 main is stopped 910s ok 56 - service postgresql@17-main is stopped 911s ok 57 - pg_ctlcluster 17 main stop 912s ok 58 - cluster 17 main is already stopped 912s ok 59 - service postgresql@17-main is already stopped 918s ok 60 - pg_ctlcluster start 17-main 919s ok 61 - cluster 17 main is running 920s ok 62 - service postgresql@17-main is running 944s ok 63 - pg_dropcluster 17 main --stop 944s # Cleanup 945s ok 64 - Cleanup: No clusters left behind 945s ok 65 - No postgres processes left behind 945s ok 66 - No files in /etc/postgresql left behind 945s ok 67 - No files in /var/lib/postgresql left behind 945s ok 68 - No files in /var/run/postgresql left behind 945s ok 69 - No files in /var/log/postgresql left behind 945s ok 70 - PostgreSQL TCP ports are closed 946s ok 71 - Next free port is 5432 946s ### End test 015_start_stop.t ### 946s 946s ### PostgreSQL test 020_create_sql_remove.t ### 947s 1..141 947s # Running tests for 17 972s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.zpe1pQ 972s ok 2 - pg_createcluster 17 main 972s ok 3 - Socket and pid file are in /var/run/postgresql/ 972s ok 4 - xlog/wal directory /tmp/17.xlog.zpe1pQ was created 972s ok 5 - local method in pg_hba.conf is peer 972s ok 6 - host method in pg_hba.conf is scram-sha-256 972s ok 7 - Exactly one postgres master process running 978s ok 8 - pg_ctlcluster 17 main restart 978s ok 9 - cluster restarts with new environment file 978s ok 10 - Exactly one postgres master process running 978s ok 11 - correct value of PGEXTRAVAR1 in environment 978s ok 12 - correct value of PGEXTRAVAR2 in environment 978s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 979s ok 14 - createdb --version 979s ok 15 - pg_wrapper+createdb selects version number of cluster 980s ok 16 - psql --version 980s ok 17 - pg_wrapper+psql selects version 17 981s ok 18 - pg_lscluster reports online cluster on port 5432 981s ok 19 - log file is actually used 981s ok 20 - /etc/postgresql is owned by user "postgres" 981s ok 21 - version configuration directory file is owned by user "postgres" 981s ok 22 - configuration directory file is owned by user "postgres" 981s ok 23 - version data directory file is owned by user "postgres" 981s ok 24 - data directory file is owned by user "postgres" 981s ok 25 - log file has 0640 permissions 981s ok 26 - log file is owned by user "postgres" 981s ok 27 - log file is owned by group "adm" 981s ok 28 - no log symlink by default 981s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 982s ok 30 - pg_lsclusters -h 982s ok 31 - correct output of pg_lsclusters -h 983s ok 32 - stopping cluster 989s ok 33 - restarting cluster with nondefault log symlink 989s ok 34 - log target is used as log file 989s ok 35 - default log is not used 990s ok 36 - pg_lsclusters -h 990s ok 37 - correct output of pg_lsclusters -h 992s ok 38 - stopping cluster 997s ok 39 - restarting cluster with explicitly configured log file 997s ok 40 - default log is not used 997s ok 41 - log symlink target is used for startup message 997s ok 42 - exactly one log file 997s ok 43 - custom log is actually used 998s ok 44 - pg_lsclusters -h 998s ok 45 - correct output of pg_lsclusters -h 999s ok 46 - stopping cluster 1000s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 1000s ok 48 - /etc/postgres-hack was not created 1005s ok 49 - restarting cluster 1005s ok 50 - ps -o tty -U postgres h 1005s ok 51 - postgres processes do not have an associated terminal 1006s ok 52 - Server is linked with SSL support 1006s ok 53 - SSL is enabled in postgresql.conf 1007s ok 54 - psql -l fails for nobody 1008s ok 55 - createuser nobody 1010s ok 56 - createdb nobodydb 1011s ok 57 - psql -ltA succeeds for nobody 1011s ok 58 - psql -ltA output 1012s ok 59 - SQL command: create table 1013s ok 60 - SQL command: insert into table values 1014s ok 61 - SQL command: insert into table values 1015s ok 62 - primary key violation 1016s ok 63 - psql -tAc "select * from phone order by name" nobodydb 1016s ok 64 - SQL command output: select -tA 1018s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 1018s ok 66 - SQL command output: select -tx 1019s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 1019s ok 68 - SQL command output: select -tAx 1020s ok 69 - CREATE EXTENSION plperlu fails for user nobody 1021s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 1021s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 1022s ok 72 - creating PL/PerlU function as user nobody fails 1023s ok 73 - creating unsafe PL/Perl function as user postgres fails 1025s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 1025s ok 75 - creating PL/PerlU function as user postgres succeeds 1026s ok 76 - psql nobodydb -Atc "select read_file()" 1026s ok 77 - calling PL/PerlU function 1027s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 1027s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 1028s ok 80 - creating unsafe PL/Perl function as user nobody fails 1029s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 1029s ok 82 - creating PL/Perl function as user nobody succeeds 1030s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 1030s ok 84 - calling PL/Perl function 1031s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 1031s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 1033s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 1033s ok 88 - creating PL/Python3 function as user postgres succeeds 1034s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 1034s ok 90 - calling PL/Python function 1036s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 1036s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 1037s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 1037s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 1038s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 1038s ok 96 - creating PL/Tcl function as user nobody succeeds 1039s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 1039s ok 98 - creating PL/TclU function as user postgres succeeds 1041s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 1041s ok 100 - calling PL/Tcl function 1042s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 1042s ok 102 - calling PL/TclU function 1043s ok 103 - stopping cluster 1044s ok 104 - pg_ctlcluster 17 main start 1045s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 1049s ok 106 - pg_ctlcluster 17 main start 1049s ok 107 - cluster restarts with pgdata symlink 1051s ok 108 - postgres master has OOM killer protection 1051s ok 109 - postgres client backend has no OOM adjustment 1051s ok 110 - ps h 7167 1051s ok 111 - process title is idle 1052s ok 112 - ps h 7167 1052s ok 113 - process title is idle in transaction 1053s ok 114 - stopping cluster 1058s ok 115 - starting cluster as postgres works without a log file 1058s ok 116 - log file got recreated and used 1058s ok 117 - creating a directory in spc2 1059s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.1bLjsK'" 1059s ok 119 - creating tablespace spc1 1060s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 1060s ok 121 - creating a table in spc1 1062s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.kXlCjg'" 1062s ok 123 - creating tablespace spc2 1063s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 1063s ok 125 - creating a table in spc2 1063s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 1063s ok 127 - Correct apt NeverAutoRemove config 1085s ok 128 - pg_dropcluster removes cluster 1085s ok 129 - xlog/wal directory /tmp/17.xlog.zpe1pQ was deleted 1085s ok 130 - tablespace spc1 was emptied 1085s ok 131 - tablespace spc2 was emptied 1085s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 1085s ok 133 - Correct apt NeverAutoRemove config 1085s # Cleanup 1086s ok 134 - Cleanup: No clusters left behind 1086s ok 135 - No postgres processes left behind 1087s ok 136 - No files in /etc/postgresql left behind 1087s ok 137 - No files in /var/lib/postgresql left behind 1087s ok 138 - No files in /var/run/postgresql left behind 1087s ok 139 - No files in /var/log/postgresql left behind 1087s ok 140 - PostgreSQL TCP ports are closed 1087s ok 141 - Next free port is 5432 1087s ### End test 020_create_sql_remove.t ### 1087s 1087s ### PostgreSQL test 021_pg_renamecluster.t ### 1088s 1..20 1113s ok 1 - pg_createcluster 17 main 1126s ok 2 - pg_renamecluster 17 main donau 1127s ok 3 - psql -tAc "show data_directory" 1127s ok 4 - cluster is running and data_directory was moved 1127s ok 5 - pg_hba.conf location updated 1127s ok 6 - pg_ident.conf location updated 1128s ok 7 - external_pid_file location updated 1128s ok 8 - external_pid_file exists 1128s ok 9 # skip no stats_temp_directory in 17 1128s ok 10 # skip no stats_temp_directory in 17 1128s ok 11 - cluster_name is updated 1150s ok 12 - pg_dropcluster removes cluster 1151s # Cleanup 1151s ok 13 - Cleanup: No clusters left behind 1152s ok 14 - No postgres processes left behind 1152s ok 15 - No files in /etc/postgresql left behind 1152s ok 16 - No files in /var/lib/postgresql left behind 1152s ok 17 - No files in /var/run/postgresql left behind 1152s ok 18 - No files in /var/log/postgresql left behind 1152s ok 19 - PostgreSQL TCP ports are closed 1152s ok 20 - Next free port is 5432 1152s ### End test 021_pg_renamecluster.t ### 1152s 1152s ### PostgreSQL test 022_recovery.t ### 1153s 1..17 1153s # Running tests for 17 1178s ok 1 - pg_createcluster 17 main --start >/dev/null 1181s ok 2 - pg_ctlcluster 17 main stop -m i 1187s ok 3 - pg_ctlcluster 17 main start 1189s ok 4 - psql -c '' 1192s ok 5 - pg_ctlcluster 17 main stop -m i 1192s ok 6 - create write-protected file in data directory 1198s ok 7 - pg_ctlcluster 17 main start 1200s ok 8 - psql -c '' 1223s ok 9 - pg_dropcluster removes cluster 1223s # Cleanup 1224s ok 10 - Cleanup: No clusters left behind 1224s ok 11 - No postgres processes left behind 1224s ok 12 - No files in /etc/postgresql left behind 1224s ok 13 - No files in /var/lib/postgresql left behind 1224s ok 14 - No files in /var/run/postgresql left behind 1224s ok 15 - No files in /var/log/postgresql left behind 1224s ok 16 - PostgreSQL TCP ports are closed 1224s ok 17 - Next free port is 5432 1224s ### End test 022_recovery.t ### 1224s 1224s ### PostgreSQL test 025_logging.t ### 1226s 1..55 1227s # Logging to /var/log/syslog works 1227s # Running tests for 17 1252s ok 1 - pg_createcluster 17 main 1253s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 1254s ok 3 - psql -qc "'foobar_17_8399'" 1254s ok 4 - log an error 1254s ok 5 - grep --binary-files=text foobar_17_8399 /var/log/postgresql/postgresql-17-main.log 1254s ok 6 - error appears in logfile 1255s ok 7 - pg_conftool 17 main set log_destination syslog 1255s ok 8 - set log_destination syslog 1256s ok 9 - pg_ctlcluster 17 main reload 1256s ok 10 - 17 main reload 1257s ok 11 - psql -Atc "show log_destination" 1257s ok 12 - log_destination is syslog 1258s ok 13 - pg_lscluster reports syslog 1259s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 1259s ok 15 - error appears in /var/log/syslog 1260s ok 16 - pg_conftool 17 main set logging_collector on 1260s ok 17 - set logging_collector on 1261s ok 18 - pg_conftool 17 main set log_destination csvlog 1261s ok 19 - set log_destination csvlog 1269s ok 20 - pg_ctlcluster 17 main restart 1269s ok 21 - 17 main restart 1270s ok 22 - psql -Atc "show logging_collector" 1270s ok 23 - logging_collector is on 1271s ok 24 - psql -Atc "show log_destination" 1271s ok 25 - log_destination is csvlog 1272s ok 26 - pg_lscluster reports csvlog 1273s ok 27 - psql -qc "'barbaz_17_8399'" 1273s ok 28 - log an error 1274s ok 29 - grep --binary-files=text barbaz_17_8399 /var/lib/postgresql/17/main/log/*.csv 1274s ok 30 - error appears in log/*.csv 1275s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 1275s ok 32 - set log_destination stderr,syslog,csvlog 1276s ok 33 - pg_ctlcluster 17 main reload 1276s ok 34 - 17 main reload 1277s ok 35 - psql -Atc "show log_destination" 1277s ok 36 - log_destination is stderr,syslog,csvlog 1278s ok 37 - pg_lscluster reports stderr,syslog,csvlog 1279s ok 38 - psql -qc "'moo_17_8399'" 1279s ok 39 - log an error 1280s ok 40 - grep --binary-files=text moo_17_8399 /var/lib/postgresql/17/main/log/*.log 1280s ok 41 - error appears in log/*.log 1280s ok 42 - grep --binary-files=text 'postgres.*moo_17_8399' /var/log/syslog 1280s ok 43 - error appears in /var/log/syslog 1280s ok 44 - grep --binary-files=text moo_17_8399 /var/lib/postgresql/17/main/log/*.csv 1280s ok 45 - error appears in log/*.csv 1304s ok 46 - pg_dropcluster 17 main --stop 1304s ok 47 - pg_dropcluster removes cluster 1304s # Cleanup 1305s ok 48 - Cleanup: No clusters left behind 1305s ok 49 - No postgres processes left behind 1305s ok 50 - No files in /etc/postgresql left behind 1305s ok 51 - No files in /var/lib/postgresql left behind 1305s ok 52 - No files in /var/run/postgresql left behind 1305s ok 53 - No files in /var/log/postgresql left behind 1305s ok 54 - PostgreSQL TCP ports are closed 1305s ok 55 - Next free port is 5432 1305s ### End test 025_logging.t ### 1305s 1305s ### PostgreSQL test 027_jit.t ### 1307s ok 1 - No JIT tests on riscv64 1307s 1..1 1307s ### End test 027_jit.t ### 1307s 1307s ### PostgreSQL test 030_errors.t ### 1308s 1..156 1309s ok 1 - pg_lscluster reports cluster without binaries 1326s ok 2 - pg_dropcluster 6.3 main 1345s ok 3 - pg_createcluster --socketdir 1346s ok 4 - pg_lsclusters -h 1346s ok 5 - cluster was created 1346s ok 6 - Port of created cluster is 5432 1347s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 1347s ok 8 - pg_createcluster on existing cluster 1348s ok 9 - pg_lsclusters -h 1348s ok 10 - original cluster still exists 1349s ok 11 - pg_createcluster 17 test -p foo 1349s ok 12 - pg_createcluster -p checks that port option is numeric 1350s ok 13 - pg_createcluster 17 test -p 42 1350s ok 14 - pg_createcluster -p checks valid port range 1351s ok 15 - pg_ctlcluster 17 main start 1351s ok 16 - pg_ctlcluster refuses to start root-owned cluster 1352s ok 17 - pg_ctlcluster 17 main start 1352s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 1354s ok 19 - pg_ctlcluster 17 main start 1354s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 1355s ok 21 - pg_ctlcluster 17 main start 1355s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 1361s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 1361s ok 24 - No sockets in /var/run/postgresql 1361s ok 25 - Socket is in /tmp/postgresql-testsuite/ 1364s ok 26 - cluster stops with custom unix_socket_dir 1364s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 1370s ok 28 - cluster starts after removing unix_socket_dir 1370s ok 29 - Socket is in default dir /var/run/postgresql 1370s ok 30 - No sockets in /tmp/postgresql-testsuite/ 1371s ok 31 - pg_ctlcluster 17 main stop 1371s ok 32 - pg_ctlcluster fails with corrupted PID file 1372s ok 33 - pg_lsclusters -h 1372s ok 34 - cluster is still online 1373s ok 35 - pg_ctlcluster succeeds with restored PID file 1375s ok 36 - pg_lsclusters -h 1375s ok 37 - cluster is down 1376s ok 38 - pg_ctlcluster 17 main stop 1376s ok 39 - pg_ctlcluster stop fails on stopped cluster 1381s ok 40 - pg_ctlcluster 17 main start 1381s ok 41 - pg_ctlcluster succeeds with already existing PID file 1382s ok 42 - pg_lsclusters -h 1382s ok 43 - cluster is online 1384s ok 44 - pg_ctlcluster stop succeeds 1385s ok 45 - pg_lsclusters -h 1385s ok 46 - cluster is down 1385s ok 47 - no pid file left 1386s ok 48 - pg_ctlcluster 17 main stop 1386s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 1386s ok 50 - pid file was cleaned up 1387s ok 51 - pg_ctlcluster --force 17 main stop 1387s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 1387s ok 53 - pid file was cleaned up 1388s ok 54 - pg_ctlcluster 17 main stop 1388s ok 55 - pg_ctlcluster stop succeeds with stale PID file 1388s ok 56 - pid file was cleaned up 1389s ok 57 - pg_ctlcluster --force 17 main stop 1389s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 1389s ok 59 - pid file was cleaned up 1390s ok 60 - pg_ctlcluster --force 17 main stop 1390s ok 61 - pg_ctlcluster stop succeeds with empty PID file 1390s ok 62 - pid file was cleaned up 1395s ok 63 - pg_ctlcluster 17 main start 1395s ok 64 - pg_ctlcluster succeeds with corrupted PID file 1396s ok 65 - pg_lsclusters -h 1396s ok 66 - cluster is online 1397s ok 67 - pg_ctlcluster 17 main start 1397s ok 68 - pg_ctlcluster start fails on running cluster 1399s ok 69 - pg_ctlcluster stop 1401s ok 70 - pg_ctlcluster 17 main start 1401s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 1402s ok 72 - pg_ctlcluster 17 main stop 1402s ok 73 - stopping cluster 1412s ok 74 - pg_ctlcluster 17 main start 1412s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 1414s ok 76 - pg_ctlcluster 17 main stop 1414s ok 77 - stopping cluster 1414s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 1415s ok 79 - pg_dropcluster 17 main 1415s ok 80 - pg_dropcluster works as user postgres 1434s ok 81 - pg_createcluster succeeds 1435s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 1435s ok 83 - proper error message for nonexisting /var/lib/postgresql 1440s ok 84 - pg_ctlcluster 17 main start 1440s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 1441s ok 86 - pg_ctlcluster 17 main stop 1441s ok 87 - stopping cluster 1460s ok 88 - pg_createcluster other 1465s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 1470s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 1471s ok 91 1472s ok 92 - pg_ctlcluster 17 other start 1472s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 1474s ok 94 - pg_ctlcluster 17 main stop 1474s ok 95 - stopping main cluster 1479s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 1501s ok 97 - pg_dropcluster other 1521s ok 98 - pg_dropcluster 1521s ok 99 - No sockets any more 1522s ok 100 - 'pg_lsclusters 4.5 foo' fails 1522s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 1522s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 1523s ok 103 - 'psql --cluster 4.5/foo' fails 1523s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 1523s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 1524s ok 106 - 'psql --cluster 17/foo' fails 1524s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 1524s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 1525s ok 109 - 'pg_dropcluster 4.5 foo' fails 1525s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 1525s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 1526s ok 112 - 'pg_dropcluster 17 foo' fails 1526s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 1526s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 1527s ok 115 - 'pg_upgradecluster 4.5 foo' fails 1527s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 1527s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 1528s ok 118 - 'pg_upgradecluster 17 foo' fails 1528s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 1528s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 1529s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 1529s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 1529s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 1530s ok 124 - 'pg_ctlcluster 17 foo stop' fails 1530s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 1530s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 1530s # Cleanup 1531s ok 127 - Cleanup: No clusters left behind 1531s ok 128 - No postgres processes left behind 1531s ok 129 - No files in /etc/postgresql left behind 1531s ok 130 - No files in /var/lib/postgresql left behind 1531s ok 131 - No files in /var/run/postgresql left behind 1531s ok 132 - No files in /var/log/postgresql left behind 1531s ok 133 - PostgreSQL TCP ports are closed 1531s ok 134 - Next free port is 5432 1548s ok 135 - pg_dropcluster 17 broken 1548s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 1548s # Cleanup 1549s ok 137 - Cleanup: No clusters left behind 1549s ok 138 - No postgres processes left behind 1549s ok 139 - No files in /etc/postgresql left behind 1549s ok 140 - No files in /var/lib/postgresql left behind 1549s ok 141 - No files in /var/run/postgresql left behind 1549s ok 142 - No files in /var/log/postgresql left behind 1549s ok 143 - PostgreSQL TCP ports are closed 1549s ok 144 - Next free port is 5432 1569s ok 145 - pg_dropcluster 17 broken 1569s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 1569s ok 147 - /etc/postgresql/17 was removed 1569s ok 148 - /var/lib/postgresql/17 was removed 1569s # Cleanup 1570s ok 149 - Cleanup: No clusters left behind 1570s ok 150 - No postgres processes left behind 1570s ok 151 - No files in /etc/postgresql left behind 1570s ok 152 - No files in /var/lib/postgresql left behind 1570s ok 153 - No files in /var/run/postgresql left behind 1570s ok 154 - No files in /var/log/postgresql left behind 1570s ok 155 - PostgreSQL TCP ports are closed 1570s ok 156 - Next free port is 5432 1570s ### End test 030_errors.t ### 1570s 1570s ### PostgreSQL test 031_errors_disk_full.t ### 1572s 1..22 1572s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 1593s ok 1 - script failed 1593s ok 2 - pg_createcluster fails due to insufficient disk space 1593s ok 3 - does not leave files behind 1593s # Cleanup 1595s ok 4 - Cleanup: No clusters left behind 1595s ok 5 - No postgres processes left behind 1595s ok 6 - No files in /etc/postgresql left behind 1595s ok 7 - No files in /var/lib/postgresql left behind 1595s ok 8 - No files in /var/run/postgresql left behind 1595s ok 9 - No files in /var/log/postgresql left behind 1595s ok 10 - PostgreSQL TCP ports are closed 1595s ok 11 - Next free port is 5432 1595s # check disk full conditions on startup 1638s ok 12 - script failed 1638s ok 13 - pg_ctlcluster prints error message 1638s ok 14 - log file has error message 1638s # Cleanup 1639s ok 15 - Cleanup: No clusters left behind 1639s ok 16 - No postgres processes left behind 1639s ok 17 - No files in /etc/postgresql left behind 1639s ok 18 - No files in /var/lib/postgresql left behind 1639s ok 19 - No files in /var/run/postgresql left behind 1639s ok 20 - No files in /var/log/postgresql left behind 1639s ok 21 - PostgreSQL TCP ports are closed 1639s ok 22 - Next free port is 5432 1639s ### End test 031_errors_disk_full.t ### 1639s 1639s ### PostgreSQL test 032_ssl_key_permissions.t ### 1641s 1..22 1641s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 1641s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 1641s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 1660s ok 4 - pg_createcluster 17 main 1662s ok 5 - pg_ctlcluster 17 main start 1662s ok 6 - ssl key owned by nobody refused 1664s ok 7 - pg_ctlcluster 17 main start 1664s ok 8 - ssl key with permissions root:root 0644 refused 1666s ok 9 - pg_ctlcluster 17 main start 1666s ok 10 - ssl key with permissions postgres:postgres 0640 refused 2870s autopkgtest-virt-ssh [14:15:04]: ------- nova console-log 76411f92-ea65-4fc9-a9fc-fa7d53542a3c (adt-questing-riscv64-postgresql-17-20250502-111413-juju-7f2275-prod-proposed-migration-environment-21-e80aebfd-b2d9-409c-bc03-bcb3b8101340) ------ 2870s ERROR (CommandError): No server with a name or ID of '76411f92-ea65-4fc9-a9fc-fa7d53542a3c' exists. 2870s --------------------------------------------------- 2870s ------- nova show 76411f92-ea65-4fc9-a9fc-fa7d53542a3c (adt-questing-riscv64-postgresql-17-20250502-111413-juju-7f2275-prod-proposed-migration-environment-21-e80aebfd-b2d9-409c-bc03-bcb3b8101340) ------ 2870s ERROR (CommandError): No server with a name or ID of '76411f92-ea65-4fc9-a9fc-fa7d53542a3c' exists. 2870s --------------------------------------------------- 2870s 3416s nova [W] Using flock in prodstack7-riscv64 3416s Creating nova instance adt-questing-riscv64-postgresql-17-20250502-111413-juju-7f2275-prod-proposed-migration-environment-21-e80aebfd-b2d9-409c-bc03-bcb3b8101340 from image adt/ubuntu-questing-riscv64-server-20250501.img (UUID 2359bd49-b5b7-4912-915a-f8dc98a06fb2)... 3416s nova [W] Timed out waiting for 76411f92-ea65-4fc9-a9fc-fa7d53542a3c to get deleted. 3416s autopkgtest [14:24:10]: ERROR: testbed failure: testbed auxverb failed with exit code 255