0s autopkgtest [23:24:09]: starting date and time: 2025-05-01 23:24:09+0000 0s autopkgtest [23:24:09]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [23:24:09]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.v41ir065/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade postgresql-17 --timeout-short=1200 --timeout-copy=80000 --timeout-build=80000 --env=ADT_TEST_TRIGGERS=postgresql-common/277 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-riscv64-15.secgroup --name adt-questing-riscv64-postgresql-17-20250501-232409-juju-7f2275-prod-proposed-migration-environment-15-acf1c86e-87ca-41ee-8fa1-0100f0d970f8 --image adt/ubuntu-questing-riscv64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-riscv64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 351s autopkgtest [23:30:00]: testbed dpkg architecture: riscv64 353s autopkgtest [23:30:02]: testbed apt version: 3.0.0 357s autopkgtest [23:30:06]: @@@@@@@@@@@@@@@@@@@@ test bed setup 358s autopkgtest [23:30:07]: testbed release detected to be: None 365s autopkgtest [23:30:14]: updating testbed package index (apt update) 369s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 369s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 369s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 369s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 370s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 371s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [179 kB] 372s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2255 kB] 373s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 Packages [101 kB] 373s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe riscv64 Packages [411 kB] 374s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse riscv64 Packages [1868 B] 381s Fetched 3116 kB in 10s (312 kB/s) 405s Reading package lists... 412s autopkgtest [23:31:01]: upgrading testbed (apt dist-upgrade and autopurge) 415s Reading package lists... 418s Building dependency tree... 418s Reading state information... 422s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 423s Starting 2 pkgProblemResolver with broken count: 0 423s Done 427s Entering ResolveByKeep 429s 431s Calculating upgrade... 433s The following packages will be upgraded: 433s dpkg dpkg-dev libdpkg-perl libperl5.40 perl perl-base perl-modules-5.40 434s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 434s Need to get 12.5 MB of archives. 434s After this operation, 1024 B of additional disk space will be used. 434s Get:1 http://ftpmaster.internal/ubuntu questing/main riscv64 dpkg riscv64 1.22.18ubuntu3 [1315 kB] 434s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 libperl5.40 riscv64 5.40.1-3 [4483 kB] 435s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl riscv64 5.40.1-3 [262 kB] 436s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl-base riscv64 5.40.1-3 [1845 kB] 436s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl-modules-5.40 all 5.40.1-3 [3217 kB] 436s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 dpkg-dev all 1.22.18ubuntu3 [1089 kB] 436s Get:7 http://ftpmaster.internal/ubuntu questing/main riscv64 libdpkg-perl all 1.22.18ubuntu3 [281 kB] 444s Fetched 12.5 MB in 3s (3594 kB/s) 447s (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 ... 114049 files and directories currently installed.) 447s Preparing to unpack .../dpkg_1.22.18ubuntu3_riscv64.deb ... 447s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 452s Setting up dpkg (1.22.18ubuntu3) ... 467s (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 ... 114049 files and directories currently installed.) 467s Preparing to unpack .../libperl5.40_5.40.1-3_riscv64.deb ... 467s Unpacking libperl5.40:riscv64 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 474s Preparing to unpack .../perl_5.40.1-3_riscv64.deb ... 474s Unpacking perl (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 476s Preparing to unpack .../perl-base_5.40.1-3_riscv64.deb ... 476s Unpacking perl-base (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 480s Setting up perl-base (5.40.1-3) ... 483s (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 ... 114049 files and directories currently installed.) 483s Preparing to unpack .../perl-modules-5.40_5.40.1-3_all.deb ... 483s Unpacking perl-modules-5.40 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 492s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 492s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 495s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 495s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 496s Setting up perl-modules-5.40 (5.40.1-3) ... 496s Setting up libperl5.40:riscv64 (5.40.1-3) ... 496s Setting up perl (5.40.1-3) ... 497s Setting up libdpkg-perl (1.22.18ubuntu3) ... 497s Setting up dpkg-dev (1.22.18ubuntu3) ... 497s Processing triggers for man-db (2.13.0-1) ... 510s Processing triggers for libc-bin (2.41-6ubuntu1) ... 521s Reading package lists... 523s Building dependency tree... 523s Reading state information... 527s Starting pkgProblemResolver with broken count: 0 528s Starting 2 pkgProblemResolver with broken count: 0 528s Done 532s Solving dependencies... 535s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 539s autopkgtest [23:33:08]: rebooting testbed after setup commands that affected boot 551s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 584s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 617s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 650s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 682s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 715s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 740s autopkgtest [23:36:29]: testbed running kernel: Linux 6.14.0-13-generic #13.2-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 05:26:54 UTC 2025 763s autopkgtest [23:36:52]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 866s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (dsc) [4245 B] 866s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (tar) [21.5 MB] 866s Get:3 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (diff) [27.2 kB] 871s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 871s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 871s gpgv: Can't check signature: No public key 871s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 926s autopkgtest [23:39:35]: testing package postgresql-17 version 17.4-1 930s autopkgtest [23:39:39]: build not needed 962s autopkgtest [23:40:11]: test run-testsuite: preparing testbed 969s Reading package lists... 972s Building dependency tree... 972s Reading state information... 975s Starting pkgProblemResolver with broken count: 0 976s Starting 2 pkgProblemResolver with broken count: 0 976s Done 981s The following NEW packages will be installed: 981s autoconf automake autopoint autotools-dev build-essential cpp cpp-14 981s cpp-14-riscv64-linux-gnu cpp-riscv64-linux-gnu debhelper debugedit 981s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 981s fakeroot g++ g++-14 g++-14-riscv64-linux-gnu g++-riscv64-linux-gnu gcc 981s gcc-14 gcc-14-riscv64-linux-gnu gcc-riscv64-linux-gnu gettext hunspell-en-us 981s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libdebhelper-perl 981s libecpg-compat3 libecpg-dev libecpg6 libfakeroot 981s libfile-stripnondeterminism-perl libgcc-14-dev libgomp1 libio-pty-perl 981s libipc-run-perl libisl23 libitm1 libjson-perl liblsan0 libmpc3 libpgtypes3 981s libpq-dev libpq5 libpython3.13 libssl-dev libstdc++-14-dev libtcl8.6 libtool 981s libtsan2 libubsan1 libxslt1.1 locales-all m4 po-debconf postgresql-17 981s postgresql-client-17 postgresql-client-common postgresql-common 981s postgresql-common-dev postgresql-doc-17 postgresql-plperl-17 981s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 981s ssl-cert 982s 0 upgraded, 71 newly installed, 0 to remove and 0 not upgraded. 982s Need to get 124 MB of archives. 982s After this operation, 754 MB of additional disk space will be used. 982s Get:1 http://ftpmaster.internal/ubuntu questing/main riscv64 libjson-perl all 4.10000-1 [81.9 kB] 982s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-client-common all 277 [48.0 kB] 982s Get:3 http://ftpmaster.internal/ubuntu questing/main riscv64 libio-pty-perl riscv64 1:1.20-1build3 [31.6 kB] 982s Get:4 http://ftpmaster.internal/ubuntu questing/main riscv64 libipc-run-perl all 20231003.0-2 [91.5 kB] 982s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-common-dev all 277 [73.4 kB] 982s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 982s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-common all 277 [101 kB] 982s Get:8 http://ftpmaster.internal/ubuntu questing/main riscv64 m4 riscv64 1.4.19-7 [268 kB] 982s Get:9 http://ftpmaster.internal/ubuntu questing/main riscv64 autoconf all 2.72-3ubuntu1 [383 kB] 982s Get:10 http://ftpmaster.internal/ubuntu questing/main riscv64 autotools-dev all 20220109.1 [44.9 kB] 982s Get:11 http://ftpmaster.internal/ubuntu questing/main riscv64 automake all 1:1.17-3ubuntu1 [572 kB] 982s Get:12 http://ftpmaster.internal/ubuntu questing/main riscv64 autopoint all 0.23.1-1 [619 kB] 983s Get:13 http://ftpmaster.internal/ubuntu questing/main riscv64 libisl23 riscv64 0.27-1 [722 kB] 983s Get:14 http://ftpmaster.internal/ubuntu questing/main riscv64 libmpc3 riscv64 1.3.1-1build2 [61.5 kB] 983s Get:15 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [15.2 MB] 986s Get:16 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14 riscv64 14.2.0-19ubuntu2 [1028 B] 986s Get:17 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [5554 B] 986s Get:18 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp riscv64 4:14.2.0-1ubuntu1 [22.4 kB] 986s Get:19 http://ftpmaster.internal/ubuntu questing/main riscv64 libcc1-0 riscv64 15-20250404-0ubuntu1 [46.1 kB] 986s Get:20 http://ftpmaster.internal/ubuntu questing/main riscv64 libgomp1 riscv64 15-20250404-0ubuntu1 [149 kB] 986s Get:21 http://ftpmaster.internal/ubuntu questing/main riscv64 libitm1 riscv64 15-20250404-0ubuntu1 [29.7 kB] 986s Get:22 http://ftpmaster.internal/ubuntu questing/main riscv64 libasan8 riscv64 15-20250404-0ubuntu1 [3300 kB] 987s Get:23 http://ftpmaster.internal/ubuntu questing/main riscv64 liblsan0 riscv64 15-20250404-0ubuntu1 [1470 kB] 987s Get:24 http://ftpmaster.internal/ubuntu questing/main riscv64 libtsan2 riscv64 15-20250404-0ubuntu1 [2983 kB] 987s Get:25 http://ftpmaster.internal/ubuntu questing/main riscv64 libubsan1 riscv64 15-20250404-0ubuntu1 [1310 kB] 988s Get:26 http://ftpmaster.internal/ubuntu questing/main riscv64 libgcc-14-dev riscv64 14.2.0-19ubuntu2 [5994 kB] 989s Get:27 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [29.9 MB] 996s Get:28 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14 riscv64 14.2.0-19ubuntu2 [529 kB] 996s Get:29 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [1198 B] 996s Get:30 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc riscv64 4:14.2.0-1ubuntu1 [4998 B] 996s Get:31 http://ftpmaster.internal/ubuntu questing/main riscv64 libstdc++-14-dev riscv64 14.2.0-19ubuntu2 [6141 kB] 997s Get:32 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [16.8 MB] 1001s Get:33 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14 riscv64 14.2.0-19ubuntu2 [23.0 kB] 1001s Get:34 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [960 B] 1001s Get:35 http://ftpmaster.internal/ubuntu questing/main riscv64 g++ riscv64 4:14.2.0-1ubuntu1 [1080 B] 1001s Get:36 http://ftpmaster.internal/ubuntu questing/main riscv64 build-essential riscv64 12.12ubuntu1 [5090 B] 1001s Get:37 http://ftpmaster.internal/ubuntu questing/main riscv64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 1001s Get:38 http://ftpmaster.internal/ubuntu questing/main riscv64 libtool all 2.5.4-4 [168 kB] 1001s Get:39 http://ftpmaster.internal/ubuntu questing/main riscv64 dh-autoreconf all 20 [16.1 kB] 1001s Get:40 http://ftpmaster.internal/ubuntu questing/main riscv64 libarchive-zip-perl all 1.68-1 [90.2 kB] 1001s Get:41 http://ftpmaster.internal/ubuntu questing/main riscv64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 1001s Get:42 http://ftpmaster.internal/ubuntu questing/main riscv64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 1001s Get:43 http://ftpmaster.internal/ubuntu questing/main riscv64 debugedit riscv64 1:5.1-2 [53.9 kB] 1001s Get:44 http://ftpmaster.internal/ubuntu questing/main riscv64 dwz riscv64 0.15-1build6 [125 kB] 1001s Get:45 http://ftpmaster.internal/ubuntu questing/main riscv64 gettext riscv64 0.23.1-1 [1201 kB] 1001s Get:46 http://ftpmaster.internal/ubuntu questing/main riscv64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 1001s Get:47 http://ftpmaster.internal/ubuntu questing/main riscv64 po-debconf all 1.0.21+nmu1 [233 kB] 1001s Get:48 http://ftpmaster.internal/ubuntu questing/main riscv64 debhelper all 13.24.1ubuntu2 [895 kB] 1001s Get:49 http://ftpmaster.internal/ubuntu questing/main riscv64 emacsen-common all 3.0.7 [13.0 kB] 1001s Get:50 http://ftpmaster.internal/ubuntu questing/main riscv64 dictionaries-common all 1.30.10 [178 kB] 1001s Get:51 http://ftpmaster.internal/ubuntu questing/main riscv64 libfakeroot riscv64 1.37.1-1 [35.7 kB] 1001s Get:52 http://ftpmaster.internal/ubuntu questing/main riscv64 fakeroot riscv64 1.37.1-1 [80.6 kB] 1001s Get:53 http://ftpmaster.internal/ubuntu questing/main riscv64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 1002s Get:54 http://ftpmaster.internal/ubuntu questing/main riscv64 libpgtypes3 riscv64 17.4-1 [48.7 kB] 1002s Get:55 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq5 riscv64 17.4-1 [148 kB] 1002s Get:56 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg6 riscv64 17.4-1 [45.9 kB] 1002s Get:57 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg-compat3 riscv64 17.4-1 [12.9 kB] 1002s Get:58 http://ftpmaster.internal/ubuntu questing/main riscv64 libssl-dev riscv64 3.4.1-1ubuntu3 [6164 kB] 1003s Get:59 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq-dev riscv64 17.4-1 [307 kB] 1003s Get:60 http://ftpmaster.internal/ubuntu questing/main riscv64 libecpg-dev riscv64 17.4-1 [393 kB] 1003s Get:61 http://ftpmaster.internal/ubuntu questing/main riscv64 libpython3.13 riscv64 3.13.3-1 [2427 kB] 1004s Get:62 http://ftpmaster.internal/ubuntu questing/main riscv64 libtcl8.6 riscv64 8.6.16+dfsg-1 [1064 kB] 1004s Get:63 http://ftpmaster.internal/ubuntu questing/main riscv64 libxslt1.1 riscv64 1.1.39-0exp1ubuntu4 [178 kB] 1004s Get:64 http://ftpmaster.internal/ubuntu questing/universe riscv64 locales-all riscv64 2.41-6ubuntu1 [11.2 MB] 1007s Get:65 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-client-17 riscv64 17.4-1 [1387 kB] 1007s Get:66 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-17 riscv64 17.4-1 [5505 kB] 1008s Get:67 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-doc-17 all 17.4-1 [2131 kB] 1009s Get:68 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-plperl-17 riscv64 17.4-1 [50.9 kB] 1009s Get:69 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-plpython3-17 riscv64 17.4-1 [57.7 kB] 1009s Get:70 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-pltcl-17 riscv64 17.4-1 [30.7 kB] 1009s Get:71 http://ftpmaster.internal/ubuntu questing/universe riscv64 postgresql-server-dev-17 riscv64 17.4-1 [1663 kB] 1020s Preconfiguring packages ... 1023s Fetched 124 MB in 28s (4396 kB/s) 1024s Selecting previously unselected package libjson-perl. 1026s (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 ... 114049 files and directories currently installed.) 1026s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 1026s Unpacking libjson-perl (4.10000-1) ... 1027s Selecting previously unselected package postgresql-client-common. 1027s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 1028s Unpacking postgresql-client-common (277) ... 1028s Selecting previously unselected package libio-pty-perl. 1029s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_riscv64.deb ... 1029s Unpacking libio-pty-perl (1:1.20-1build3) ... 1029s Selecting previously unselected package libipc-run-perl. 1029s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 1029s Unpacking libipc-run-perl (20231003.0-2) ... 1030s Selecting previously unselected package postgresql-common-dev. 1030s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 1030s Unpacking postgresql-common-dev (277) ... 1032s Selecting previously unselected package ssl-cert. 1032s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 1032s Unpacking ssl-cert (1.1.3ubuntu1) ... 1032s Selecting previously unselected package postgresql-common. 1033s Preparing to unpack .../06-postgresql-common_277_all.deb ... 1033s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 1034s Unpacking postgresql-common (277) ... 1035s Selecting previously unselected package m4. 1035s Preparing to unpack .../07-m4_1.4.19-7_riscv64.deb ... 1035s Unpacking m4 (1.4.19-7) ... 1036s Selecting previously unselected package autoconf. 1036s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 1036s Unpacking autoconf (2.72-3ubuntu1) ... 1038s Selecting previously unselected package autotools-dev. 1038s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 1038s Unpacking autotools-dev (20220109.1) ... 1038s Selecting previously unselected package automake. 1039s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 1039s Unpacking automake (1:1.17-3ubuntu1) ... 1040s Selecting previously unselected package autopoint. 1040s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 1040s Unpacking autopoint (0.23.1-1) ... 1041s Selecting previously unselected package libisl23:riscv64. 1041s Preparing to unpack .../12-libisl23_0.27-1_riscv64.deb ... 1041s Unpacking libisl23:riscv64 (0.27-1) ... 1043s Selecting previously unselected package libmpc3:riscv64. 1043s Preparing to unpack .../13-libmpc3_1.3.1-1build2_riscv64.deb ... 1043s Unpacking libmpc3:riscv64 (1.3.1-1build2) ... 1044s Selecting previously unselected package cpp-14-riscv64-linux-gnu. 1045s Preparing to unpack .../14-cpp-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 1045s Unpacking cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1058s Selecting previously unselected package cpp-14. 1058s Preparing to unpack .../15-cpp-14_14.2.0-19ubuntu2_riscv64.deb ... 1058s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 1058s Selecting previously unselected package cpp-riscv64-linux-gnu. 1059s Preparing to unpack .../16-cpp-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1059s Unpacking cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1059s Selecting previously unselected package cpp. 1059s Preparing to unpack .../17-cpp_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1060s Unpacking cpp (4:14.2.0-1ubuntu1) ... 1061s Selecting previously unselected package libcc1-0:riscv64. 1061s Preparing to unpack .../18-libcc1-0_15-20250404-0ubuntu1_riscv64.deb ... 1061s Unpacking libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 1062s Selecting previously unselected package libgomp1:riscv64. 1062s Preparing to unpack .../19-libgomp1_15-20250404-0ubuntu1_riscv64.deb ... 1062s Unpacking libgomp1:riscv64 (15-20250404-0ubuntu1) ... 1063s Selecting previously unselected package libitm1:riscv64. 1063s Preparing to unpack .../20-libitm1_15-20250404-0ubuntu1_riscv64.deb ... 1063s Unpacking libitm1:riscv64 (15-20250404-0ubuntu1) ... 1064s Selecting previously unselected package libasan8:riscv64. 1064s Preparing to unpack .../21-libasan8_15-20250404-0ubuntu1_riscv64.deb ... 1064s Unpacking libasan8:riscv64 (15-20250404-0ubuntu1) ... 1068s Selecting previously unselected package liblsan0:riscv64. 1068s Preparing to unpack .../22-liblsan0_15-20250404-0ubuntu1_riscv64.deb ... 1068s Unpacking liblsan0:riscv64 (15-20250404-0ubuntu1) ... 1070s Selecting previously unselected package libtsan2:riscv64. 1071s Preparing to unpack .../23-libtsan2_15-20250404-0ubuntu1_riscv64.deb ... 1071s Unpacking libtsan2:riscv64 (15-20250404-0ubuntu1) ... 1074s Selecting previously unselected package libubsan1:riscv64. 1074s Preparing to unpack .../24-libubsan1_15-20250404-0ubuntu1_riscv64.deb ... 1074s Unpacking libubsan1:riscv64 (15-20250404-0ubuntu1) ... 1076s Selecting previously unselected package libgcc-14-dev:riscv64. 1076s Preparing to unpack .../25-libgcc-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 1076s Unpacking libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 1088s Selecting previously unselected package gcc-14-riscv64-linux-gnu. 1088s Preparing to unpack .../26-gcc-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 1088s Unpacking gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1112s Selecting previously unselected package gcc-14. 1112s Preparing to unpack .../27-gcc-14_14.2.0-19ubuntu2_riscv64.deb ... 1112s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 1113s Selecting previously unselected package gcc-riscv64-linux-gnu. 1113s Preparing to unpack .../28-gcc-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1113s Unpacking gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1114s Selecting previously unselected package gcc. 1114s Preparing to unpack .../29-gcc_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1114s Unpacking gcc (4:14.2.0-1ubuntu1) ... 1115s Selecting previously unselected package libstdc++-14-dev:riscv64. 1115s Preparing to unpack .../30-libstdc++-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 1115s Unpacking libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 1127s Selecting previously unselected package g++-14-riscv64-linux-gnu. 1127s Preparing to unpack .../31-g++-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 1127s Unpacking g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1140s Selecting previously unselected package g++-14. 1140s Preparing to unpack .../32-g++-14_14.2.0-19ubuntu2_riscv64.deb ... 1140s Unpacking g++-14 (14.2.0-19ubuntu2) ... 1141s Selecting previously unselected package g++-riscv64-linux-gnu. 1141s Preparing to unpack .../33-g++-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1141s Unpacking g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1142s Selecting previously unselected package g++. 1142s Preparing to unpack .../34-g++_4%3a14.2.0-1ubuntu1_riscv64.deb ... 1142s Unpacking g++ (4:14.2.0-1ubuntu1) ... 1143s Selecting previously unselected package build-essential. 1143s Preparing to unpack .../35-build-essential_12.12ubuntu1_riscv64.deb ... 1143s Unpacking build-essential (12.12ubuntu1) ... 1143s Selecting previously unselected package libdebhelper-perl. 1144s Preparing to unpack .../36-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 1144s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 1144s Selecting previously unselected package libtool. 1145s Preparing to unpack .../37-libtool_2.5.4-4_all.deb ... 1145s Unpacking libtool (2.5.4-4) ... 1146s Selecting previously unselected package dh-autoreconf. 1146s Preparing to unpack .../38-dh-autoreconf_20_all.deb ... 1146s Unpacking dh-autoreconf (20) ... 1146s Selecting previously unselected package libarchive-zip-perl. 1147s Preparing to unpack .../39-libarchive-zip-perl_1.68-1_all.deb ... 1147s Unpacking libarchive-zip-perl (1.68-1) ... 1147s Selecting previously unselected package libfile-stripnondeterminism-perl. 1148s Preparing to unpack .../40-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 1148s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 1148s Selecting previously unselected package dh-strip-nondeterminism. 1148s Preparing to unpack .../41-dh-strip-nondeterminism_1.14.1-2_all.deb ... 1148s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 1149s Selecting previously unselected package debugedit. 1149s Preparing to unpack .../42-debugedit_1%3a5.1-2_riscv64.deb ... 1149s Unpacking debugedit (1:5.1-2) ... 1150s Selecting previously unselected package dwz. 1151s Preparing to unpack .../43-dwz_0.15-1build6_riscv64.deb ... 1151s Unpacking dwz (0.15-1build6) ... 1151s Selecting previously unselected package gettext. 1152s Preparing to unpack .../44-gettext_0.23.1-1_riscv64.deb ... 1152s Unpacking gettext (0.23.1-1) ... 1154s Selecting previously unselected package intltool-debian. 1154s Preparing to unpack .../45-intltool-debian_0.35.0+20060710.6_all.deb ... 1154s Unpacking intltool-debian (0.35.0+20060710.6) ... 1154s Selecting previously unselected package po-debconf. 1155s Preparing to unpack .../46-po-debconf_1.0.21+nmu1_all.deb ... 1155s Unpacking po-debconf (1.0.21+nmu1) ... 1156s Selecting previously unselected package debhelper. 1156s Preparing to unpack .../47-debhelper_13.24.1ubuntu2_all.deb ... 1156s Unpacking debhelper (13.24.1ubuntu2) ... 1158s Selecting previously unselected package emacsen-common. 1158s Preparing to unpack .../48-emacsen-common_3.0.7_all.deb ... 1158s Unpacking emacsen-common (3.0.7) ... 1159s Selecting previously unselected package dictionaries-common. 1159s Preparing to unpack .../49-dictionaries-common_1.30.10_all.deb ... 1160s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 1160s Unpacking dictionaries-common (1.30.10) ... 1161s Selecting previously unselected package libfakeroot:riscv64. 1161s Preparing to unpack .../50-libfakeroot_1.37.1-1_riscv64.deb ... 1161s Unpacking libfakeroot:riscv64 (1.37.1-1) ... 1162s Selecting previously unselected package fakeroot. 1162s Preparing to unpack .../51-fakeroot_1.37.1-1_riscv64.deb ... 1162s Unpacking fakeroot (1.37.1-1) ... 1163s Selecting previously unselected package hunspell-en-us. 1163s Preparing to unpack .../52-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 1163s Unpacking hunspell-en-us (1:2020.12.07-4) ... 1164s Selecting previously unselected package libpgtypes3:riscv64. 1164s Preparing to unpack .../53-libpgtypes3_17.4-1_riscv64.deb ... 1164s Unpacking libpgtypes3:riscv64 (17.4-1) ... 1165s Selecting previously unselected package libpq5:riscv64. 1165s Preparing to unpack .../54-libpq5_17.4-1_riscv64.deb ... 1165s Unpacking libpq5:riscv64 (17.4-1) ... 1166s Selecting previously unselected package libecpg6:riscv64. 1167s Preparing to unpack .../55-libecpg6_17.4-1_riscv64.deb ... 1167s Unpacking libecpg6:riscv64 (17.4-1) ... 1167s Selecting previously unselected package libecpg-compat3:riscv64. 1168s Preparing to unpack .../56-libecpg-compat3_17.4-1_riscv64.deb ... 1168s Unpacking libecpg-compat3:riscv64 (17.4-1) ... 1168s Selecting previously unselected package libssl-dev:riscv64. 1168s Preparing to unpack .../57-libssl-dev_3.4.1-1ubuntu3_riscv64.deb ... 1168s Unpacking libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 1179s Selecting previously unselected package libpq-dev. 1179s Preparing to unpack .../58-libpq-dev_17.4-1_riscv64.deb ... 1179s Unpacking libpq-dev (17.4-1) ... 1180s Selecting previously unselected package libecpg-dev. 1181s Preparing to unpack .../59-libecpg-dev_17.4-1_riscv64.deb ... 1181s Unpacking libecpg-dev (17.4-1) ... 1182s Selecting previously unselected package libpython3.13:riscv64. 1182s Preparing to unpack .../60-libpython3.13_3.13.3-1_riscv64.deb ... 1182s Unpacking libpython3.13:riscv64 (3.13.3-1) ... 1185s Selecting previously unselected package libtcl8.6:riscv64. 1185s Preparing to unpack .../61-libtcl8.6_8.6.16+dfsg-1_riscv64.deb ... 1185s Unpacking libtcl8.6:riscv64 (8.6.16+dfsg-1) ... 1187s Selecting previously unselected package libxslt1.1:riscv64. 1187s Preparing to unpack .../62-libxslt1.1_1.1.39-0exp1ubuntu4_riscv64.deb ... 1187s Unpacking libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 1188s Selecting previously unselected package locales-all. 1188s Preparing to unpack .../63-locales-all_2.41-6ubuntu1_riscv64.deb ... 1188s Unpacking locales-all (2.41-6ubuntu1) ... 1239s Selecting previously unselected package postgresql-client-17. 1239s Preparing to unpack .../64-postgresql-client-17_17.4-1_riscv64.deb ... 1239s Unpacking postgresql-client-17 (17.4-1) ... 1241s Selecting previously unselected package postgresql-17. 1241s Preparing to unpack .../65-postgresql-17_17.4-1_riscv64.deb ... 1242s Unpacking postgresql-17 (17.4-1) ... 1248s Selecting previously unselected package postgresql-doc-17. 1248s Preparing to unpack .../66-postgresql-doc-17_17.4-1_all.deb ... 1248s Unpacking postgresql-doc-17 (17.4-1) ... 1256s Selecting previously unselected package postgresql-plperl-17. 1256s Preparing to unpack .../67-postgresql-plperl-17_17.4-1_riscv64.deb ... 1256s Unpacking postgresql-plperl-17 (17.4-1) ... 1257s Selecting previously unselected package postgresql-plpython3-17. 1257s Preparing to unpack .../68-postgresql-plpython3-17_17.4-1_riscv64.deb ... 1257s Unpacking postgresql-plpython3-17 (17.4-1) ... 1258s Selecting previously unselected package postgresql-pltcl-17. 1258s Preparing to unpack .../69-postgresql-pltcl-17_17.4-1_riscv64.deb ... 1258s Unpacking postgresql-pltcl-17 (17.4-1) ... 1259s Selecting previously unselected package postgresql-server-dev-17. 1259s Preparing to unpack .../70-postgresql-server-dev-17_17.4-1_riscv64.deb ... 1259s Unpacking postgresql-server-dev-17 (17.4-1) ... 1264s Setting up libpython3.13:riscv64 (3.13.3-1) ... 1264s Setting up postgresql-client-common (277) ... 1265s Setting up libpgtypes3:riscv64 (17.4-1) ... 1265s Setting up libio-pty-perl (1:1.20-1build3) ... 1265s Setting up libarchive-zip-perl (1.68-1) ... 1265s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 1265s Setting up postgresql-doc-17 (17.4-1) ... 1275s 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 1276s Setting up libpq5:riscv64 (17.4-1) ... 1276s Setting up m4 (1.4.19-7) ... 1276s Setting up libgomp1:riscv64 (15-20250404-0ubuntu1) ... 1276s Setting up locales-all (2.41-6ubuntu1) ... 1276s Setting up libfakeroot:riscv64 (1.37.1-1) ... 1276s Setting up fakeroot (1.37.1-1) ... 1276s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 1276s Setting up autotools-dev (20220109.1) ... 1276s Setting up emacsen-common (3.0.7) ... 1278s Setting up ssl-cert (1.1.3ubuntu1) ... 1296s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 1308s Setting up libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 1308s Setting up libmpc3:riscv64 (1.3.1-1build2) ... 1308s Setting up libtcl8.6:riscv64 (8.6.16+dfsg-1) ... 1308s Setting up autopoint (0.23.1-1) ... 1308s Setting up libipc-run-perl (20231003.0-2) ... 1308s Setting up autoconf (2.72-3ubuntu1) ... 1308s Setting up libubsan1:riscv64 (15-20250404-0ubuntu1) ... 1308s Setting up dwz (0.15-1build6) ... 1309s Setting up libasan8:riscv64 (15-20250404-0ubuntu1) ... 1309s Setting up libjson-perl (4.10000-1) ... 1309s Setting up libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 1309s Setting up debugedit (1:5.1-2) ... 1309s Setting up libecpg6:riscv64 (17.4-1) ... 1309s Setting up libtsan2:riscv64 (15-20250404-0ubuntu1) ... 1309s Setting up libisl23:riscv64 (0.27-1) ... 1309s Setting up libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 1309s Setting up liblsan0:riscv64 (15-20250404-0ubuntu1) ... 1309s Setting up libitm1:riscv64 (15-20250404-0ubuntu1) ... 1309s Setting up postgresql-common-dev (277) ... 1309s Setting up automake (1:1.17-3ubuntu1) ... 1309s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 1309s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 1309s Setting up gettext (0.23.1-1) ... 1309s Setting up libecpg-compat3:riscv64 (17.4-1) ... 1309s Setting up dictionaries-common (1.30.10) ... 1324s Setting up postgresql-client-17 (17.4-1) ... 1352s 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 1353s Setting up libpq-dev (17.4-1) ... 1353s Setting up cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1353s Setting up libecpg-dev (17.4-1) ... 1353s Setting up intltool-debian (0.35.0+20060710.6) ... 1353s Setting up postgresql-common (277) ... 1369s Creating config file /etc/postgresql-common/createcluster.conf with new version 1376s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 1376s en_us 1377s Removing obsolete dictionary files: 1399s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 1414s Setting up cpp-14 (14.2.0-19ubuntu2) ... 1414s Setting up dh-strip-nondeterminism (1.14.1-2) ... 1414s Setting up hunspell-en-us (1:2020.12.07-4) ... 1415s Setting up libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 1415s Setting up cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1416s Setting up libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 1416s Setting up postgresql-17 (17.4-1) ... 1468s Creating new PostgreSQL cluster 17/main ... 1469s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 1470s The files belonging to this database system will be owned by user "postgres". 1470s This user must also own the server process. 1470s 1470s The database cluster will be initialized with locale "C.UTF-8". 1470s The default database encoding has accordingly been set to "UTF8". 1470s The default text search configuration will be set to "english". 1470s 1470s Data page checksums are disabled. 1470s 1470s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 1470s creating subdirectories ... ok 1470s selecting dynamic shared memory implementation ... posix 1471s selecting default "max_connections" ... 100 1472s selecting default "shared_buffers" ... 128MB 1472s selecting default time zone ... Etc/UTC 1472s creating configuration files ... ok 1478s running bootstrap script ... ok 1494s performing post-bootstrap initialization ... ok 1494s syncing data to disk ... ok 1528s Setting up po-debconf (1.0.21+nmu1) ... 1528s Setting up postgresql-server-dev-17 (17.4-1) ... 1528s Setting up gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1528s Setting up postgresql-plpython3-17 (17.4-1) ... 1528s Setting up postgresql-plperl-17 (17.4-1) ... 1528s Setting up cpp (4:14.2.0-1ubuntu1) ... 1528s Setting up g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 1528s Setting up postgresql-pltcl-17 (17.4-1) ... 1529s Setting up gcc-14 (14.2.0-19ubuntu2) ... 1529s Setting up gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1529s Setting up g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 1529s Setting up g++-14 (14.2.0-19ubuntu2) ... 1529s Setting up libtool (2.5.4-4) ... 1529s Setting up gcc (4:14.2.0-1ubuntu1) ... 1529s Setting up dh-autoreconf (20) ... 1529s Setting up g++ (4:14.2.0-1ubuntu1) ... 1529s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 1529s Setting up build-essential (12.12ubuntu1) ... 1530s Setting up debhelper (13.24.1ubuntu2) ... 1530s Processing triggers for install-info (7.1.1-1) ... 1535s Processing triggers for libc-bin (2.41-6ubuntu1) ... 1536s Processing triggers for man-db (2.13.0-1) ... 1542s Processing triggers for dictionaries-common (1.30.10) ... 1584s autopkgtest [23:50:33]: test run-testsuite: [----------------------- 1602s ====== Running all tests with umask 077 ======= 1602s ### PostgreSQL test 001_packages.t ### 1605s 1..23 1605s ok 1 - /etc/os-release exists 1605s ok 2 - OS is ubuntu 1605s ok 3 - OS version is 25.10 1605s # PostgreSQL versions installed: 17 1605s # 17 1605s ok 4 - postgresql-17 installed 1605s ok 5 - postgresql-plpython3-17 installed 1606s ok 6 - postgresql-plperl-17 installed 1606s ok 7 - postgresql-pltcl-17 installed 1606s ok 8 # skip No postgresql-17-jit package for version 17 1607s ok 9 - postgresql-server-dev-17 installed 1607s ok 10 # skip No postgresql-contrib-17 package for version 17 1609s # postgresql-doc-17 installed 1609s ok 11 - At least one doc package installed 1609s ok 12 - libecpg-dev installed 1609s ok 13 - postgresql-common-dev installed 1609s ok 14 - procps installed 1609s ok 15 - netcat-openbsd installed 1610s ok 16 - hunspell-en-us installed 1610s ok 17 - system has a default UTF-8 locale 1610s ok 18 - locale ru_RU exists 1610s ok 19 - locale ru_RU.UTF-8 exists 1610s ok 20 - user postgres in the UNIX group ssl-cert 1610s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 1610s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 1610s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 1610s ### End test 001_packages.t ### 1610s 1610s ### PostgreSQL test 002_existing_clusters.t ### 1613s 1..8 1613s # Cleanup 1615s ok 1 - Cleanup: No clusters left behind 1615s ok 2 - No postgres processes left behind 1615s ok 3 - No files in /etc/postgresql left behind 1615s ok 4 - No files in /var/lib/postgresql left behind 1615s ok 5 - No files in /var/run/postgresql left behind 1615s ok 6 - No files in /var/log/postgresql left behind 1616s ok 7 - PostgreSQL TCP ports are closed 1616s ok 8 - Next free port is 5432 1616s ### End test 002_existing_clusters.t ### 1616s 1616s ### PostgreSQL test 003_alternatives.t ### 1619s 1..9 1619s # Newest PG version installed is 17 1620s ok 1 - psql.1.gz link group 1620s ok 2 - postmaster.1.gz link group does not exist 1620s ok 3 - psql.1.gz alternative 1620s ok 4 - pg_dump.1.gz alternative 1620s ok 5 - postgres.1.gz alternative 1620s ok 6 - pg_ctl.1.gz alternative 1620s # Newest PG doc version installed is 17 1621s ok 7 - SPI_connect.3.gz link group 1621s ok 8 - SPI_connect.3.gz alternative 1621s ok 9 - SPI_exec.3.gz alternative 1621s ### End test 003_alternatives.t ### 1621s 1621s ### PostgreSQL test 005_PgCommon.t ### 1624s 1..24 1624s ok 1 - correctly parsed line 'local all postgres ident sameuser' 1624s ok 2 - correctly parsed line 'local foo nobody trust' 1624s ok 3 - correctly parsed line 'local foo nobody crypt' 1624s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 1624s ok 5 - correctly parsed line 'local foo,bar nobody ident' 1624s ok 6 - correctly parsed line 'local all +foogrp password' 1624s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 1624s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 1624s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 1624s ok 10 - @expected_records has correct number of entries 1624s ok 11 - returned read_pg_hba array has correct number of records 1624s ok 12 - line 'foo all all md5' parsed as invalid 1624s ok 13 - line 'local all all foo' parsed as invalid 1624s ok 14 - line 'host all all foo' parsed as invalid 1624s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 1624s ok 16 - line 'host all all md5' parsed as invalid 1624s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 1624s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 1624s ok 19 - read_conf_file returns empty dict for nonexisting file 1624s ok 20 - read_conf_file() parsing 1625s ok 21 - read_conf_file() parsing with include directives 1625s ok 22 - set_conf_value 1625s ok 23 - disable_conf_value 1625s ok 24 - replace_conf_value 1625s ### End test 005_PgCommon.t ### 1625s 1625s ### PostgreSQL test 006_next_free_port.t ### 1628s 1..5 1628s ok 1 - next_free_port is 5432 1629s ok 2 - next_free_port detects localhost ipv4 socket 1630s ok 3 - next_free_port detects wildcard ipv4 socket 1631s ok 4 - next_free_port detects localhost ipv6 socket 1632s ok 5 - next_free_port detects wildcard ipv6 socket 1632s ### End test 006_next_free_port.t ### 1632s 1632s ### PostgreSQL test 007_pg_conftool.t ### 1634s 1..41 1635s # test without cluster 1637s ok 1 - pg_conftool show all 1637s ok 2 - correct output of pg_conftool show all 1639s ok 3 - pg_conftool foo.conf show all 1639s ok 4 - correct output of pg_conftool foo.conf show all 1641s ok 5 - pg_conftool /tmp/q5EnkOH5ua/different.conf show all 1641s ok 6 - correct output of pg_conftool /tmp/q5EnkOH5ua/different.conf show all 1642s ok 7 - pg_conftool 9.7 main show all 1642s ok 8 - correct output of pg_conftool 9.7 main show all 1642s # test show 1644s ok 9 - pg_conftool show all 1644s ok 10 - correct output of pg_conftool show all 1646s ok 11 - pg_conftool other.conf show all 1646s ok 12 - correct output of pg_conftool other.conf show all 1648s ok 13 - pg_conftool /tmp/q5EnkOH5ua/different.conf show all 1648s ok 14 - correct output of pg_conftool /tmp/q5EnkOH5ua/different.conf show all 1649s ok 15 - pg_conftool 17 main show all 1649s ok 16 - correct output of pg_conftool 17 main show all 1651s ok 17 - pg_conftool 17 main other.conf show all 1651s ok 18 - correct output of pg_conftool 17 main other.conf show all 1652s ok 19 - pg_conftool show a 1653s ok 20 - correct output of pg_conftool show a 1654s ok 21 - pg_conftool -s show a 1654s ok 22 - correct output of pg_conftool -s show a 1654s # test set 1656s ok 23 - pg_conftool set c 7 1656s ok 24 - correct output of pg_conftool set c 7 1656s ok 25 - file contains new setting 1658s ok 26 - pg_conftool set a 8 1658s ok 27 - correct output of pg_conftool set a 8 1658s ok 28 - file contains updated setting 1660s ok 29 - pg_conftool /tmp/q5EnkOH5ua/different.conf set a 9 1660s ok 30 - correct output of pg_conftool /tmp/q5EnkOH5ua/different.conf set a 9 1660s ok 31 - file with path contains updated setting 1660s # test remove 1662s ok 32 - pg_conftool remove a 1662s ok 33 - correct output of pg_conftool remove a 1662s ok 34 - setting removed from file 1664s ok 35 - pg_conftool /tmp/q5EnkOH5ua/different.conf remove a 1664s ok 36 - correct output of pg_conftool /tmp/q5EnkOH5ua/different.conf remove a 1664s ok 37 - setting removed from file with path 1664s # test edit 1665s ok 38 - pg_conftool edit 1665s ok 39 - correct output of pg_conftool edit 1667s ok 40 - pg_conftool /tmp/q5EnkOH5ua/different.conf edit 1667s ok 41 - correct output of pg_conftool /tmp/q5EnkOH5ua/different.conf edit 1667s ### End test 007_pg_conftool.t ### 1667s 1667s ### PostgreSQL test 010_defaultport_cluster.t ### 1669s 1..14 1672s ok 1 - psql --version 1672s ok 2 - pg_wrapper selects highest available version number 1674s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 1674s ok 4 - connecting to localhost fails with no clusters 1676s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 1676s ok 6 - pg_wrapper uses host and port from PGCLUSTER 1678s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 1678s ok 8 - pg_wrapper uses --cluster from the command line 1680s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 1680s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 1681s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 1681s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 1683s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 1683s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 1683s ### End test 010_defaultport_cluster.t ### 1683s 1683s ### PostgreSQL test 015_start_stop.t ### 1686s 1..71 1686s # We are running systemd 1686s # Running tests for 17 1686s # Cluster does not exist yet 1687s ok 1 - cluster 17 main does not exist 1688s ok 2 - service postgresql@17-main does not exist 1689s ok 3 - systemctl start postgresql 1691s ok 4 - cluster 17 main does not exist 1691s ok 5 - service postgresql@17-main does not exist 1692s ok 6 - systemctl start postgresql@17-main 1694s ok 7 - cluster 17 main does not exist 1695s ok 8 - service postgresql@17-main does not exist 1695s # Start/stop postgresql using system tools 1735s ok 9 - pg_createcluster 17 main 1737s ok 10 - cluster 17 main is stopped 1739s ok 11 - service postgresql@17-main is stopped 1747s ok 12 - systemctl start postgresql 1749s ok 13 - cluster 17 main is running 1749s ok 14 - service postgresql@17-main is running 1750s ok 15 - systemctl start postgresql 1752s ok 16 - cluster 17 main is already running 1752s ok 17 - service postgresql@17-main is already running 1753s ok 18 - systemctl stop postgresql 1761s ok 19 - cluster 17 main is stopped 1761s ok 20 - service postgresql@17-main is stopped 1762s ok 21 - systemctl stop postgresql 1764s ok 22 - cluster 17 main is already stopped 1764s ok 23 - service postgresql@17-main is already stopped 1764s # Start/stop specific cluster using system tools 1773s ok 24 - systemctl start postgresql@17-main 1777s ok 25 - cluster 17 main is running 1777s ok 26 - service postgresql@17-main is running 1778s ok 27 - systemctl start postgresql@17-main 1781s ok 28 - cluster 17 main is running 1783s ok 29 - service postgresql@17-main is running 1798s ok 30 - systemctl restart postgresql@17-main 1802s ok 31 - cluster 17 main is running 1803s ok 32 - service postgresql@17-main is running 1807s ok 33 - systemctl stop postgresql@17-main 1810s ok 34 - cluster 17 main is stopped 1811s ok 35 - service postgresql@17-main is stopped 1811s ok 36 - systemctl stop postgresql@17-main 1814s ok 37 - cluster 17 main is already stopped 1815s ok 38 - service postgresql@17-main is already stopped 1879s ok 39 - pg_dropcluster 17 main 1882s ok 40 - cluster 17 main does not exist 1883s ok 41 - service postgresql@17-main does not exist 1883s # Start/stop specific cluster using pg_*cluster 1885s ok 42 - pg_ctlcluster start 17 main 1888s ok 43 - cluster 17 main does not exist 1889s ok 44 - service postgresql@17-main does not exist 1958s ok 45 - pg_createcluster 17 main --start 1961s ok 46 - cluster 17 main is running 1962s ok 47 - service postgresql@17-main is running 1966s ok 48 - pg_ctlcluster 17 main start 1969s ok 49 - cluster 17 main is already running 1970s ok 50 - service postgresql@17-main is already running 1987s ok 51 - pg_ctlcluster 17-main restart 1991s ok 52 - cluster 17 main is running 1992s ok 53 - service postgresql@17-main is running 1999s ok 54 - pg_ctlcluster 17 main stop 2002s ok 55 - cluster 17 main is stopped 2003s ok 56 - service postgresql@17-main is stopped 2007s ok 57 - pg_ctlcluster 17 main stop 2011s ok 58 - cluster 17 main is already stopped 2012s ok 59 - service postgresql@17-main is already stopped 2027s ok 60 - pg_ctlcluster start 17-main 2030s ok 61 - cluster 17 main is running 2031s ok 62 - service postgresql@17-main is running 2098s ok 63 - pg_dropcluster 17 main --stop 2098s # Cleanup 2100s ok 64 - Cleanup: No clusters left behind 2101s ok 65 - No postgres processes left behind 2101s ok 66 - No files in /etc/postgresql left behind 2101s ok 67 - No files in /var/lib/postgresql left behind 2101s ok 68 - No files in /var/run/postgresql left behind 2101s ok 69 - No files in /var/log/postgresql left behind 2101s ok 70 - PostgreSQL TCP ports are closed 2101s ok 71 - Next free port is 5432 2101s ### End test 015_start_stop.t ### 2101s 2102s ### PostgreSQL test 020_create_sql_remove.t ### 2106s 1..141 2106s # Running tests for 17 2177s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.1r6StO 2177s ok 2 - pg_createcluster 17 main 2177s ok 3 - Socket and pid file are in /var/run/postgresql/ 2177s ok 4 - xlog/wal directory /tmp/17.xlog.1r6StO was created 2177s ok 5 - local method in pg_hba.conf is peer 2177s ok 6 - host method in pg_hba.conf is scram-sha-256 2177s ok 7 - Exactly one postgres master process running 2189s ok 8 - pg_ctlcluster 17 main restart 2189s ok 9 - cluster restarts with new environment file 2190s ok 10 - Exactly one postgres master process running 2191s ok 11 - correct value of PGEXTRAVAR1 in environment 2191s ok 12 - correct value of PGEXTRAVAR2 in environment 2191s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 2193s ok 14 - createdb --version 2193s ok 15 - pg_wrapper+createdb selects version number of cluster 2196s ok 16 - psql --version 2196s ok 17 - pg_wrapper+psql selects version 17 2199s ok 18 - pg_lscluster reports online cluster on port 5432 2199s ok 19 - log file is actually used 2199s ok 20 - /etc/postgresql is owned by user "postgres" 2199s ok 21 - version configuration directory file is owned by user "postgres" 2199s ok 22 - configuration directory file is owned by user "postgres" 2199s ok 23 - version data directory file is owned by user "postgres" 2199s ok 24 - data directory file is owned by user "postgres" 2199s ok 25 - log file has 0640 permissions 2199s ok 26 - log file is owned by user "postgres" 2199s ok 27 - log file is owned by group "adm" 2199s ok 28 - no log symlink by default 2199s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 2202s ok 30 - pg_lsclusters -h 2202s ok 31 - correct output of pg_lsclusters -h 2205s ok 32 - stopping cluster 2215s ok 33 - restarting cluster with nondefault log symlink 2215s ok 34 - log target is used as log file 2215s ok 35 - default log is not used 2218s ok 36 - pg_lsclusters -h 2218s ok 37 - correct output of pg_lsclusters -h 2222s ok 38 - stopping cluster 2233s ok 39 - restarting cluster with explicitly configured log file 2233s ok 40 - default log is not used 2233s ok 41 - log symlink target is used for startup message 2233s ok 42 - exactly one log file 2233s ok 43 - custom log is actually used 2236s ok 44 - pg_lsclusters -h 2236s ok 45 - correct output of pg_lsclusters -h 2240s ok 46 - stopping cluster 2242s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 2242s ok 48 - /etc/postgres-hack was not created 2252s ok 49 - restarting cluster 2253s ok 50 - ps -o tty -U postgres h 2253s ok 51 - postgres processes do not have an associated terminal 2253s ok 52 - Server is linked with SSL support 2253s ok 53 - SSL is enabled in postgresql.conf 2256s ok 54 - psql -l fails for nobody 2259s ok 55 - createuser nobody 2264s ok 56 - createdb nobodydb 2267s ok 57 - psql -ltA succeeds for nobody 2267s ok 58 - psql -ltA output 2270s ok 59 - SQL command: create table 2272s ok 60 - SQL command: insert into table values 2275s ok 61 - SQL command: insert into table values 2278s ok 62 - primary key violation 2281s ok 63 - psql -tAc "select * from phone order by name" nobodydb 2281s ok 64 - SQL command output: select -tA 2284s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 2284s ok 66 - SQL command output: select -tx 2288s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 2288s ok 68 - SQL command output: select -tAx 2291s ok 69 - CREATE EXTENSION plperlu fails for user nobody 2295s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 2295s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 2298s ok 72 - creating PL/PerlU function as user nobody fails 2301s ok 73 - creating unsafe PL/Perl function as user postgres fails 2304s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 2304s ok 75 - creating PL/PerlU function as user postgres succeeds 2307s ok 76 - psql nobodydb -Atc "select read_file()" 2307s ok 77 - calling PL/PerlU function 2310s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 2310s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 2313s ok 80 - creating unsafe PL/Perl function as user nobody fails 2316s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 2316s ok 82 - creating PL/Perl function as user nobody succeeds 2320s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 2320s ok 84 - calling PL/Perl function 2323s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 2323s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 2328s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 2328s ok 88 - creating PL/Python3 function as user postgres succeeds 2331s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 2331s ok 90 - calling PL/Python function 2335s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 2335s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 2338s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 2338s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 2340s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 2340s ok 96 - creating PL/Tcl function as user nobody succeeds 2345s 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;" 2345s ok 98 - creating PL/TclU function as user postgres succeeds 2348s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 2348s ok 100 - calling PL/Tcl function 2351s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 2351s ok 102 - calling PL/TclU function 2356s ok 103 - stopping cluster 2359s ok 104 - pg_ctlcluster 17 main start 2359s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 2370s ok 106 - pg_ctlcluster 17 main start 2370s ok 107 - cluster restarts with pgdata symlink 2374s ok 108 - postgres master has OOM killer protection 2374s ok 109 - postgres client backend has no OOM adjustment 2375s ok 110 - ps h 6564 2375s ok 111 - process title is idle 2376s ok 112 - ps h 6564 2376s ok 113 - process title is idle in transaction 2380s ok 114 - stopping cluster 2391s ok 115 - starting cluster as postgres works without a log file 2391s ok 116 - log file got recreated and used 2391s ok 117 - creating a directory in spc2 2394s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.wZ6eMB'" 2394s ok 119 - creating tablespace spc1 2399s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 2399s ok 121 - creating a table in spc1 2403s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.tzDEW5'" 2403s ok 123 - creating tablespace spc2 2406s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 2406s ok 125 - creating a table in spc2 2407s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 2407s ok 127 - Correct apt NeverAutoRemove config 2469s ok 128 - pg_dropcluster removes cluster 2469s ok 129 - xlog/wal directory /tmp/17.xlog.1r6StO was deleted 2469s ok 130 - tablespace spc1 was emptied 2469s ok 131 - tablespace spc2 was emptied 2469s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 2469s ok 133 - Correct apt NeverAutoRemove config 2469s # Cleanup 2472s ok 134 - Cleanup: No clusters left behind 2473s ok 135 - No postgres processes left behind 2473s ok 136 - No files in /etc/postgresql left behind 2473s ok 137 - No files in /var/lib/postgresql left behind 2473s ok 138 - No files in /var/run/postgresql left behind 2473s ok 139 - No files in /var/log/postgresql left behind 2473s ok 140 - PostgreSQL TCP ports are closed 2473s ok 141 - Next free port is 5432 2473s ### End test 020_create_sql_remove.t ### 2473s 2473s ### PostgreSQL test 021_pg_renamecluster.t ### 2477s 1..20 2536s ok 1 - pg_createcluster 17 main 2565s ok 2 - pg_renamecluster 17 main donau 2568s ok 3 - psql -tAc "show data_directory" 2568s ok 4 - cluster is running and data_directory was moved 2568s ok 5 - pg_hba.conf location updated 2568s ok 6 - pg_ident.conf location updated 2568s ok 7 - external_pid_file location updated 2568s ok 8 - external_pid_file exists 2568s ok 9 # skip no stats_temp_directory in 17 2568s ok 10 # skip no stats_temp_directory in 17 2568s ok 11 - cluster_name is updated 2631s ok 12 - pg_dropcluster removes cluster 2631s # Cleanup 2633s ok 13 - Cleanup: No clusters left behind 2634s ok 14 - No postgres processes left behind 2634s ok 15 - No files in /etc/postgresql left behind 2634s ok 16 - No files in /var/lib/postgresql left behind 2634s ok 17 - No files in /var/run/postgresql left behind 2634s ok 18 - No files in /var/log/postgresql left behind 2634s ok 19 - PostgreSQL TCP ports are closed 2635s ok 20 - Next free port is 5432 2635s ### End test 021_pg_renamecluster.t ### 2635s 2635s ### PostgreSQL test 022_recovery.t ### 2639s 1..17 2639s # Running tests for 17 2711s ok 1 - pg_createcluster 17 main --start >/dev/null 2718s ok 2 - pg_ctlcluster 17 main stop -m i 2731s ok 3 - pg_ctlcluster 17 main start 2737s ok 4 - psql -c '' 2744s ok 5 - pg_ctlcluster 17 main stop -m i 2744s ok 6 - create write-protected file in data directory 2757s ok 7 - pg_ctlcluster 17 main start 2762s ok 8 - psql -c '' 2815s ok 9 - pg_dropcluster removes cluster 2815s # Cleanup 2817s ok 10 - Cleanup: No clusters left behind 2818s ok 11 - No postgres processes left behind 2818s ok 12 - No files in /etc/postgresql left behind 2818s ok 13 - No files in /var/lib/postgresql left behind 2818s ok 14 - No files in /var/run/postgresql left behind 2818s ok 15 - No files in /var/log/postgresql left behind 2818s ok 16 - PostgreSQL TCP ports are closed 2819s ok 17 - Next free port is 5432 2819s ### End test 022_recovery.t ### 2819s 2819s ### PostgreSQL test 025_logging.t ### 2822s 1..55 2822s # Logging to /var/log/syslog works 2822s # Running tests for 17 2878s ok 1 - pg_createcluster 17 main 2880s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 2883s ok 3 - psql -qc "'foobar_17_7850'" 2883s ok 4 - log an error 2884s ok 5 - grep --binary-files=text foobar_17_7850 /var/log/postgresql/postgresql-17-main.log 2884s ok 6 - error appears in logfile 2887s ok 7 - pg_conftool 17 main set log_destination syslog 2887s ok 8 - set log_destination syslog 2890s ok 9 - pg_ctlcluster 17 main reload 2890s ok 10 - 17 main reload 2893s ok 11 - psql -Atc "show log_destination" 2893s ok 12 - log_destination is syslog 2894s ok 13 - pg_lscluster reports syslog 2895s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 2895s ok 15 - error appears in /var/log/syslog 2897s ok 16 - pg_conftool 17 main set logging_collector on 2897s ok 17 - set logging_collector on 2899s ok 18 - pg_conftool 17 main set log_destination csvlog 2899s ok 19 - set log_destination csvlog 2915s ok 20 - pg_ctlcluster 17 main restart 2915s ok 21 - 17 main restart 2917s ok 22 - psql -Atc "show logging_collector" 2917s ok 23 - logging_collector is on 2919s ok 24 - psql -Atc "show log_destination" 2919s ok 25 - log_destination is csvlog 2922s ok 26 - pg_lscluster reports csvlog 2924s ok 27 - psql -qc "'barbaz_17_7850'" 2924s ok 28 - log an error 2925s ok 29 - grep --binary-files=text barbaz_17_7850 /var/lib/postgresql/17/main/log/*.csv 2925s ok 30 - error appears in log/*.csv 2927s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 2927s ok 32 - set log_destination stderr,syslog,csvlog 2929s ok 33 - pg_ctlcluster 17 main reload 2929s ok 34 - 17 main reload 2932s ok 35 - psql -Atc "show log_destination" 2932s ok 36 - log_destination is stderr,syslog,csvlog 2935s ok 37 - pg_lscluster reports stderr,syslog,csvlog 2938s ok 38 - psql -qc "'moo_17_7850'" 2938s ok 39 - log an error 2939s ok 40 - grep --binary-files=text moo_17_7850 /var/lib/postgresql/17/main/log/*.log 2939s ok 41 - error appears in log/*.log 2940s ok 42 - grep --binary-files=text 'postgres.*moo_17_7850' /var/log/syslog 2940s ok 43 - error appears in /var/log/syslog 2940s ok 44 - grep --binary-files=text moo_17_7850 /var/lib/postgresql/17/main/log/*.csv 2940s ok 45 - error appears in log/*.csv 3000s ok 46 - pg_dropcluster 17 main --stop 3000s ok 47 - pg_dropcluster removes cluster 3000s # Cleanup 3003s ok 48 - Cleanup: No clusters left behind 3003s ok 49 - No postgres processes left behind 3003s ok 50 - No files in /etc/postgresql left behind 3003s ok 51 - No files in /var/lib/postgresql left behind 3003s ok 52 - No files in /var/run/postgresql left behind 3003s ok 53 - No files in /var/log/postgresql left behind 3004s ok 54 - PostgreSQL TCP ports are closed 3004s ok 55 - Next free port is 5432 3004s ### End test 025_logging.t ### 3004s 3004s ### PostgreSQL test 027_jit.t ### 3007s ok 1 - No JIT tests on riscv64 3007s 1..1 3007s ### End test 027_jit.t ### 3007s 3007s ### PostgreSQL test 030_errors.t ### 3010s 1..156 3013s ok 1 - pg_lscluster reports cluster without binaries 3057s ok 2 - pg_dropcluster 6.3 main 3104s ok 3 - pg_createcluster --socketdir 3106s ok 4 - pg_lsclusters -h 3106s ok 5 - cluster was created 3107s ok 6 - Port of created cluster is 5432 3109s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 3109s ok 8 - pg_createcluster on existing cluster 3111s ok 9 - pg_lsclusters -h 3111s ok 10 - original cluster still exists 3113s ok 11 - pg_createcluster 17 test -p foo 3113s ok 12 - pg_createcluster -p checks that port option is numeric 3115s ok 13 - pg_createcluster 17 test -p 42 3115s ok 14 - pg_createcluster -p checks valid port range 3117s ok 15 - pg_ctlcluster 17 main start 3117s ok 16 - pg_ctlcluster refuses to start root-owned cluster 3119s ok 17 - pg_ctlcluster 17 main start 3119s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 3123s ok 19 - pg_ctlcluster 17 main start 3123s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 3125s ok 21 - pg_ctlcluster 17 main start 3125s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 3136s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 3136s ok 24 - No sockets in /var/run/postgresql 3136s ok 25 - Socket is in /tmp/postgresql-testsuite/ 3143s ok 26 - cluster stops with custom unix_socket_dir 3143s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 3155s ok 28 - cluster starts after removing unix_socket_dir 3155s ok 29 - Socket is in default dir /var/run/postgresql 3155s ok 30 - No sockets in /tmp/postgresql-testsuite/ 3158s ok 31 - pg_ctlcluster 17 main stop 3158s ok 32 - pg_ctlcluster fails with corrupted PID file 3160s ok 33 - pg_lsclusters -h 3160s ok 34 - cluster is still online 3163s ok 35 - pg_ctlcluster succeeds with restored PID file 3166s ok 36 - pg_lsclusters -h 3166s ok 37 - cluster is down 3169s ok 38 - pg_ctlcluster 17 main stop 3169s ok 39 - pg_ctlcluster stop fails on stopped cluster 3178s ok 40 - pg_ctlcluster 17 main start 3178s ok 41 - pg_ctlcluster succeeds with already existing PID file 3180s ok 42 - pg_lsclusters -h 3180s ok 43 - cluster is online 3184s ok 44 - pg_ctlcluster stop succeeds 3185s ok 45 - pg_lsclusters -h 3185s ok 46 - cluster is down 3185s ok 47 - no pid file left 3188s ok 48 - pg_ctlcluster 17 main stop 3188s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 3188s ok 50 - pid file was cleaned up 3191s ok 51 - pg_ctlcluster --force 17 main stop 3191s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 3191s ok 53 - pid file was cleaned up 3194s ok 54 - pg_ctlcluster 17 main stop 3194s ok 55 - pg_ctlcluster stop succeeds with stale PID file 3194s ok 56 - pid file was cleaned up 3197s ok 57 - pg_ctlcluster --force 17 main stop 3197s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 3197s ok 59 - pid file was cleaned up 3199s ok 60 - pg_ctlcluster --force 17 main stop 3199s ok 61 - pg_ctlcluster stop succeeds with empty PID file 3199s ok 62 - pid file was cleaned up 3209s ok 63 - pg_ctlcluster 17 main start 3209s ok 64 - pg_ctlcluster succeeds with corrupted PID file 3211s ok 65 - pg_lsclusters -h 3211s ok 66 - cluster is online 3213s ok 67 - pg_ctlcluster 17 main start 3213s ok 68 - pg_ctlcluster start fails on running cluster 3216s ok 69 - pg_ctlcluster stop 3221s ok 70 - pg_ctlcluster 17 main start 3221s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 3224s ok 72 - pg_ctlcluster 17 main stop 3224s ok 73 - stopping cluster 3239s ok 74 - pg_ctlcluster 17 main start 3239s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 3241s ok 76 - pg_ctlcluster 17 main stop 3241s ok 77 - stopping cluster 3241s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 3244s ok 79 - pg_dropcluster 17 main 3244s ok 80 - pg_dropcluster works as user postgres 3286s ok 81 - pg_createcluster succeeds 3289s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 3289s ok 83 - proper error message for nonexisting /var/lib/postgresql 3297s ok 84 - pg_ctlcluster 17 main start 3298s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 3301s ok 86 - pg_ctlcluster 17 main stop 3301s ok 87 - stopping cluster 3347s ok 88 - pg_createcluster other 3356s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 3365s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 3369s ok 91 3371s ok 92 - pg_ctlcluster 17 other start 3372s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 3374s ok 94 - pg_ctlcluster 17 main stop 3374s ok 95 - stopping main cluster 3382s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 3436s ok 97 - pg_dropcluster other 3488s ok 98 - pg_dropcluster 3488s ok 99 - No sockets any more 3490s ok 100 - 'pg_lsclusters 4.5 foo' fails 3490s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 3490s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 3492s ok 103 - 'psql --cluster 4.5/foo' fails 3492s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 3492s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 3493s ok 106 - 'psql --cluster 17/foo' fails 3493s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 3493s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 3496s ok 109 - 'pg_dropcluster 4.5 foo' fails 3496s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 3496s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 3498s ok 112 - 'pg_dropcluster 17 foo' fails 3498s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 3498s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 3501s ok 115 - 'pg_upgradecluster 4.5 foo' fails 3501s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 3501s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 3504s ok 118 - 'pg_upgradecluster 17 foo' fails 3504s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 3504s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 3506s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 3506s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 3506s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 3508s ok 124 - 'pg_ctlcluster 17 foo stop' fails 3508s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 3508s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 3508s # Cleanup 3511s ok 127 - Cleanup: No clusters left behind 3511s ok 128 - No postgres processes left behind 3511s ok 129 - No files in /etc/postgresql left behind 3511s ok 130 - No files in /var/lib/postgresql left behind 3511s ok 131 - No files in /var/run/postgresql left behind 3511s ok 132 - No files in /var/log/postgresql left behind 3512s ok 133 - PostgreSQL TCP ports are closed 3512s ok 134 - Next free port is 5432 3555s ok 135 - pg_dropcluster 17 broken 3555s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 3555s # Cleanup 3557s ok 137 - Cleanup: No clusters left behind 3557s ok 138 - No postgres processes left behind 3557s ok 139 - No files in /etc/postgresql left behind 3557s ok 140 - No files in /var/lib/postgresql left behind 3557s ok 141 - No files in /var/run/postgresql left behind 3557s ok 142 - No files in /var/log/postgresql left behind 3558s ok 143 - PostgreSQL TCP ports are closed 3558s ok 144 - Next free port is 5432 3602s ok 145 - pg_dropcluster 17 broken 3602s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 3602s ok 147 - /etc/postgresql/17 was removed 3602s ok 148 - /var/lib/postgresql/17 was removed 3602s # Cleanup 3605s ok 149 - Cleanup: No clusters left behind 3605s ok 150 - No postgres processes left behind 3605s ok 151 - No files in /etc/postgresql left behind 3605s ok 152 - No files in /var/lib/postgresql left behind 3605s ok 153 - No files in /var/run/postgresql left behind 3605s ok 154 - No files in /var/log/postgresql left behind 3605s ok 155 - PostgreSQL TCP ports are closed 3605s ok 156 - Next free port is 5432 3606s ### End test 030_errors.t ### 3606s 3606s ### PostgreSQL test 031_errors_disk_full.t ### 3609s 1..22 3609s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 3656s ok 1 - script failed 3656s ok 2 - pg_createcluster fails due to insufficient disk space 3656s ok 3 - does not leave files behind 3656s # Cleanup 3657s ok 4 - Cleanup: No clusters left behind 3658s ok 5 - No postgres processes left behind 3658s ok 6 - No files in /etc/postgresql left behind 3658s ok 7 - No files in /var/lib/postgresql left behind 3658s ok 8 - No files in /var/run/postgresql left behind 3658s ok 9 - No files in /var/log/postgresql left behind 3658s ok 10 - PostgreSQL TCP ports are closed 3658s ok 11 - Next free port is 5432 3658s # check disk full conditions on startup 3753s ok 12 - script failed 3753s ok 13 - pg_ctlcluster prints error message 3753s ok 14 - log file has error message 3753s # Cleanup 3755s ok 15 - Cleanup: No clusters left behind 3756s ok 16 - No postgres processes left behind 3756s ok 17 - No files in /etc/postgresql left behind 3756s ok 18 - No files in /var/lib/postgresql left behind 3756s ok 19 - No files in /var/run/postgresql left behind 3756s ok 20 - No files in /var/log/postgresql left behind 3756s ok 21 - PostgreSQL TCP ports are closed 3756s ok 22 - Next free port is 5432 3756s ### End test 031_errors_disk_full.t ### 3756s 3756s ### PostgreSQL test 032_ssl_key_permissions.t ### 3759s 1..22 3759s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 3759s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 3759s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 3801s ok 4 - pg_createcluster 17 main 3805s ok 5 - pg_ctlcluster 17 main start 3805s ok 6 - ssl key owned by nobody refused 3809s ok 7 - pg_ctlcluster 17 main start 3809s ok 8 - ssl key with permissions root:root 0644 refused 3812s ok 9 - pg_ctlcluster 17 main start 3812s ok 10 - ssl key with permissions postgres:postgres 0640 refused 3851s ok 11 - pg_dropcluster 17 main --stop 3851s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 3851s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 3851s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 3851s # Cleanup 3852s ok 15 - Cleanup: No clusters left behind 3853s ok 16 - No postgres processes left behind 3853s ok 17 - No files in /etc/postgresql left behind 3853s ok 18 - No files in /var/lib/postgresql left behind 3853s ok 19 - No files in /var/run/postgresql left behind 3853s ok 20 - No files in /var/log/postgresql left behind 3853s ok 21 - PostgreSQL TCP ports are closed 3853s ok 22 - Next free port is 5432 3853s ### End test 032_ssl_key_permissions.t ### 3853s 3853s ### PostgreSQL test 040_upgrade.t ### 3855s 1..1 3855s ok 1 - only one major version installed, skipping upgrade tests 3855s ### End test 040_upgrade.t ### 3855s 3855s ### PostgreSQL test 041_upgrade_custompaths.t ### 3857s 1..1 3857s ok 1 - only one major version installed, skipping upgrade tests 3857s ### End test 041_upgrade_custompaths.t ### 3857s 3857s ### PostgreSQL test 042_upgrade_rename.t ### 3860s 1..15 3860s # PostgreSQL 17 3901s ok 1 - pg_createcluster 17 main --start 4028s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 4030s ok 3 - pg_lsclusters -h 4030s ok 4 - correct output of pg_lsclusters -h 4062s ok 5 - pg_dropcluster 17 main --stop 4105s ok 6 - pg_dropcluster 17 upgr --stop 4105s ok 7 - Cleaning pg_upgrade log files 4105s # Cleanup 4107s ok 8 - Cleanup: No clusters left behind 4107s ok 9 - No postgres processes left behind 4107s ok 10 - No files in /etc/postgresql left behind 4107s ok 11 - No files in /var/lib/postgresql left behind 4107s ok 12 - No files in /var/run/postgresql left behind 4107s ok 13 - No files in /var/log/postgresql left behind 4107s ok 14 - PostgreSQL TCP ports are closed 4107s ok 15 - Next free port is 5432 4107s ### End test 042_upgrade_rename.t ### 4107s 4107s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 4110s 1..1 4110s ok 1 - only one major version installed, skipping upgrade tests 4110s ### End test 043_upgrade_ssl_cert.t ### 4110s 4110s ### PostgreSQL test 045_backup.t ### 4113s # We are running systemd 4113s # PostgreSQL 17 4113s # create cluster 4155s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 4157s ok 2 - pg_lsclusters -h 4157s ok 3 - correct output of pg_lsclusters -h 4158s ok 4 - pg_conftool 17 main set work_mem 11MB 4162s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 4164s ok 6 - psql -c 'alter database mydb set search_path=public' 4166s ok 7 - psql -c 'create table foo (t text)' mydb 4167s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 4170s ok 9 - psql -c 'CREATE USER myuser' 4172s ok 10 - psql -c 'grant create on database mydb to myuser' 4174s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 4177s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 4179s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 4179s # create directory 4180s ok 14 - pg_backupcluster 17 main createdirectory 4180s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 4180s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 4180s # dump 4207s ok 17 - systemctl start pg_dump@17-main 4207s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-02T003354Z.dump 4207s ok 19 - /var/backups/postgresql/17-main/2025-05-02T003354Z.dump owned by uid postgres 4207s ok 20 - /var/backups/postgresql/17-main/2025-05-02T003354Z.dump owned by gid postgres 4207s # basebackup 4211s ok 21 - systemctl start pg_receivewal@17-main 4215s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 4215s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [] 4215s not ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 4215s # Failed test '/var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial' 4215s # at t/TestLib.pm line 159. 4218s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 4221s ok 25 - psql -c 'select pg_reload_conf()' 4262s ok 26 - systemctl start pg_basebackup@17-main 4262s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-02T003436Z.backup 4262s ok 28 - /var/backups/postgresql/17-main/2025-05-02T003436Z.backup owned by uid postgres 4262s ok 29 - /var/backups/postgresql/17-main/2025-05-02T003436Z.backup owned by gid postgres 4262s # list 4265s ok 30 - pg_backupcluster 17 main list 4265s ok 31 - correct output of pg_backupcluster 17 main list 4265s # more database changes 4267s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 4269s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 4271s ok 34 - retrieve recovery timestamp 4275s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 4276s ok 36 - systemctl stop pg_receivewal@17-main 4276s # restore /var/backups/postgresql/17-main/2025-05-02T003354Z.dump 4319s ok 37 - pg_dropcluster 17 main --stop 4401s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-02T003354Z.dump --start --datadir /var/lib/postgresql/17/snowflake 4402s ok 39 - pg_lsclusters -h 4402s ok 40 - correct output of pg_lsclusters -h 4405s ok 41 - psql -XAtl 4405s ok 42 - mydb locales 4405s ok 43 - mydb grants 4405s ok 44 - myicudb locales 4407s ok 45 - psql -XAtc 'show work_mem' 4407s ok 46 - correct output of psql -XAtc 'show work_mem' 4409s ok 47 - psql -XAtc 'select * from foo' mydb 4409s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 4412s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 4412s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 4414s ok 51 - psql -XAtc '\drds' 4414s ok 52 - correct output of psql -XAtc '\drds' 4414s # restore /var/backups/postgresql/17-main/2025-05-02T003436Z.backup 4460s ok 53 - pg_dropcluster 17 main --stop 4504s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-02T003436Z.backup --start --datadir /var/lib/postgresql/17/snowflake 4505s ok 55 - pg_lsclusters -h 4505s ok 56 - correct output of pg_lsclusters -h 4508s ok 57 - psql -XAtl 4508s ok 58 - mydb locales 4508s ok 59 - mydb grants 4508s ok 60 - myicudb locales 4509s ok 61 - psql -XAtc 'show work_mem' 4509s ok 62 - correct output of psql -XAtc 'show work_mem' 4512s ok 63 - psql -XAtc 'select * from foo' mydb 4512s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 4514s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 4514s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 4516s ok 67 - psql -XAtc '\drds' 4516s ok 68 - correct output of psql -XAtc '\drds' 4516s # restore /var/backups/postgresql/17-main/2025-05-02T003436Z.backup with WAL archive 4562s ok 69 - pg_dropcluster 17 main --stop 4611s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-02T003436Z.backup --start --archive --port 5430 4612s ok 71 - pg_lsclusters -h 4612s ok 72 - correct output of pg_lsclusters -h 4614s ok 73 - psql -XAtc 'select * from foo order by t' mydb 4614s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 4614s # restore /var/backups/postgresql/17-main/2025-05-02T003436Z.backup with PITR 4660s ok 75 - pg_dropcluster 17 main --stop 4708s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-02T003436Z.backup --start --pitr '2025-05-02 00:35:20.531098+00 4708s # ' 4710s ok 77 - pg_lsclusters -h 4710s ok 78 - correct output of pg_lsclusters -h 4712s ok 79 - psql -XAtc 'select * from foo order by t' mydb 4712s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 4755s ok 81 - pg_dropcluster 17 main --stop 4755s # Cleanup 4757s ok 82 - Cleanup: No clusters left behind 4757s ok 83 - No postgres processes left behind 4757s ok 84 - No files in /etc/postgresql left behind 4757s ok 85 - No files in /var/lib/postgresql left behind 4757s ok 86 - No files in /var/run/postgresql left behind 4757s ok 87 - No files in /var/log/postgresql left behind 4757s ok 88 - PostgreSQL TCP ports are closed 4757s ok 89 - Next free port is 5432 4757s 1..89 4757s ### End test 045_backup.t ### 4757s 4757s ### PostgreSQL test 050_encodings.t ### 4759s 1..60 4759s # Checking 17 ru_RU 4801s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 4804s ok 2 - psql -l succeeds 4804s ok 3 - template1 is not UTF-8 encoded 4807s ok 4 - creating test database 4809s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 4809s # create table t (x varchar); copy t from stdin" test 4809s ok 6 - creating table with ISO-8859-5 characters 4811s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 4811s ok 8 - correct string in UTF-8 4812s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 4812s ok 10 - correct string in ISO-8859-5 4814s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 4814s # delete from t; copy t from stdin" test 4814s ok 12 - creating table with UTF-8 characters 4816s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 4816s ok 14 - correct string in UTF-8 4818s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 4818s ok 16 - correct string in ISO-8859-1 4820s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 4820s ok 18 - Server error message has correct language and encoding 4833s ok 19 - pg_ctlcluster 17 ru_RU restart 4833s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 4873s ok 21 - Dropping cluster 4873s # Checking 17 ru_RU.UTF-8 4911s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 4914s ok 23 - psql -l succeeds 4914s ok 24 - template1 is UTF-8 encoded 4917s ok 25 - creating test database 4919s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 4919s # create table t (x varchar); copy t from stdin" test 4919s ok 27 - creating table with ISO-8859-5 characters 4922s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 4922s ok 29 - correct string in UTF-8 4923s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 4923s ok 31 - correct string in ISO-8859-5 4925s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 4925s # delete from t; copy t from stdin" test 4925s ok 33 - creating table with UTF-8 characters 4927s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 4927s ok 35 - correct string in UTF-8 4928s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 4928s ok 37 - correct string in ISO-8859-1 4930s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 4930s ok 39 - Server error message has correct language and encoding 4941s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 4941s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 4943s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 4943s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 4945s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 4945s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 4946s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 4946s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 4986s ok 48 - Dropping cluster 4986s # Check 17 locale environment variables 5029s ok 49 - pg_createcluster: LC_ALL dominates LANG 5030s ok 50 - psql -Atl --cluster 17/main 5030s ok 51 - template1 is ASCII encoded 5067s ok 52 - Dropping cluster 5067s # Cleanup 5069s ok 53 - Cleanup: No clusters left behind 5069s ok 54 - No postgres processes left behind 5069s ok 55 - No files in /etc/postgresql left behind 5069s ok 56 - No files in /var/lib/postgresql left behind 5069s ok 57 - No files in /var/run/postgresql left behind 5069s ok 58 - No files in /var/log/postgresql left behind 5070s ok 59 - PostgreSQL TCP ports are closed 5070s ok 60 - Next free port is 5432 5070s ### End test 050_encodings.t ### 5070s 5070s ### PostgreSQL test 052_upgrade_encodings.t ### 5072s 1..1 5072s ok 1 - only one major version installed, skipping upgrade tests 5072s ### End test 052_upgrade_encodings.t ### 5072s 5072s ### PostgreSQL test 060_obsolete_confparams.t ### 5073s ok 1 - only one major version installed, skipping upgrade tests 5073s 1..1 5073s ### End test 060_obsolete_confparams.t ### 5073s 5073s ### PostgreSQL test 070_non_postgres_clusters.t ### 5075s 1..40 5108s ok 1 - pg_createcluster 17 main for owner nobody 5110s ok 2 - pg_ctlcluster 17 main start 5110s ok 3 - start refused when config and data owners mismatch 5117s ok 4 - pg_ctlcluster succeeds with owner nobody 5119s ok 5 - pg_lsclusters -h 5119s ok 6 - pg_lsclusters shows running cluster 5119s ok 7 - postgres is running as user nobody 5119s ok 8 - ls /tmp/.s.PGSQL.* 5119s ok 9 - socket is in /tmp 5119s ok 10 - /var/run/postgresql is empty 5119s ok 11 - conf dir is owned by user 5119s ok 12 - conf dir is owned by user's primary group 5119s ok 13 - files are owned by user 5119s ok 14 - files are owned by user's primary group 5119s ok 15 - log file has 0640 permissions 5119s ok 16 - log file is owned by user 5119s ok 17 - log file is owned by user's primary group 5119s ok 18 - only one major version installed, skipping upgrade test 5119s ok 19 - ... 5119s ok 20 - ... 5119s ok 21 - ... 5119s ok 22 - ... 5119s ok 23 - ... 5119s ok 24 - ... 5119s ok 25 - ... 5119s ok 26 - ... 5119s ok 27 - ... 5119s ok 28 - ... 5157s ok 29 - pg_dropcluster 5158s ok 30 - pg_lsclusters -h 5158s ok 31 - No clusters left 5159s ok 32 - No postgres processes left 5159s # Cleanup 5160s ok 33 - Cleanup: No clusters left behind 5161s ok 34 - No postgres processes left behind 5161s ok 35 - No files in /etc/postgresql left behind 5161s ok 36 - No files in /var/lib/postgresql left behind 5161s ok 37 - No files in /var/run/postgresql left behind 5161s ok 38 - No files in /var/log/postgresql left behind 5161s ok 39 - PostgreSQL TCP ports are closed 5161s ok 40 - Next free port is 5432 5161s ### End test 070_non_postgres_clusters.t ### 5161s 5161s ### PostgreSQL test 080_start.conf.t ### 5163s 1..73 5200s ok 1 - pg_createcluster 17 main 5200s # start.conf auto 5200s ok 2 - get_cluster_start_conf returns auto 5200s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 5200s ok 4 - start.conf contains auto 5200s ok 5 - systemd generator links cluster 5200s ok 6 - systemd generator links correct service file 5208s ok 7 - /etc/init.d/postgresql start 17 5209s ok 8 - correct output of /etc/init.d/postgresql start 17 5210s ok 9 - pg_lsclusters -h 5210s ok 10 - cluster is online 5211s ok 11 - /etc/init.d/postgresql stop 17 5211s ok 12 - correct output of /etc/init.d/postgresql stop 17 5216s ok 13 - pg_lsclusters -h 5216s ok 14 - cluster is down 5216s # start.conf manual 5216s ok 15 - get_cluster_start_conf returns manual 5217s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 5217s ok 17 - start.conf contains manual 5222s ok 18 - systemd generator doesn't link cluster 5224s ok 19 - /etc/init.d/postgresql start 17 5224s ok 20 - correct output of /etc/init.d/postgresql start 17 5225s ok 21 - pg_lsclusters -h 5225s ok 22 - cluster is down 5233s ok 23 - pg_ctlcluster 17 main start 5233s ok 24 - correct output of pg_ctlcluster 17 main start 5234s ok 25 - pg_lsclusters -h 5234s ok 26 - cluster is online 5237s ok 27 - pg_ctlcluster 17 main stop 5237s ok 28 - correct output of pg_ctlcluster 17 main stop 5239s ok 29 - pg_lsclusters -h 5239s ok 30 - cluster is down 5239s # start.conf disabled 5239s ok 31 - get_cluster_start_conf returns disabled 5245s ok 32 - systemd generator doesn't link cluster 5246s ok 33 - /etc/init.d/postgresql start 17 5246s ok 34 - correct output of /etc/init.d/postgresql start 17 5247s ok 35 - pg_lsclusters -h 5247s ok 36 - cluster is down 5249s ok 37 - pg_ctlcluster 17 main start 5249s ok 38 - correct output of pg_ctlcluster 17 main start 5251s ok 39 - pg_lsclusters -h 5251s ok 40 - cluster is down 5257s ok 41 - pg_ctlcluster 17 main start 5257s ok 42 - correct output of pg_ctlcluster 17 main start 5259s ok 43 - pg_lsclusters -h 5259s ok 44 - cluster is online 5262s ok 45 - pg_ctlcluster 17 main stop 5262s ok 46 - correct output of pg_ctlcluster 17 main stop 5263s ok 47 - pg_lsclusters -h 5263s ok 48 - cluster is down 5270s ok 49 - pg_ctlcluster 17 main start 5270s ok 50 - correct output of pg_ctlcluster 17 main start 5272s ok 51 - pg_lsclusters -h 5272s ok 52 - cluster is online 5272s # test upgrade 5272s ok 53 - only one major version installed, skipping upgrade test 5272s ok 54 - ... 5272s ok 55 - get_cluster_start_conf for old cluster returns manual 5272s ok 56 - get_cluster_start_conf for new cluster returns manual 5272s ok 57 - ... 5304s ok 58 - dropping upgraded cluster 5306s ok 59 - pg_lsclusters -h 5306s ok 60 - no clusters any more 5307s ok 61 - pg_createcluster 17 main --start-conf foo 5307s ok 62 - pg_createcluster checks --start-conf validity 5334s ok 63 - pg_createcluster checks --start-conf manual 5334s ok 64 - get_cluster_start_conf returns manual 5365s ok 65 - dropping cluster 5365s # Cleanup 5366s ok 66 - Cleanup: No clusters left behind 5366s ok 67 - No postgres processes left behind 5366s ok 68 - No files in /etc/postgresql left behind 5366s ok 69 - No files in /var/lib/postgresql left behind 5366s ok 70 - No files in /var/run/postgresql left behind 5366s ok 71 - No files in /var/log/postgresql left behind 5368s ok 72 - PostgreSQL TCP ports are closed 5368s ok 73 - Next free port is 5432 5368s ### End test 080_start.conf.t ### 5368s 5368s ### PostgreSQL test 085_pg_ctl.conf.t ### 5370s 1..33 5370s ok 1 - prlimit --core=0:unlimited --pid=16325 5370s ok 2 - set core file size to unlimited 5371s ok 3 - sh -c 'ulimit -Hc' 5371s ok 4 - core file size is unlimited 5406s ok 5 - pg_createcluster 17 main 5406s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 5415s ok 7 - pg_ctlcluster 17 main start 5415s ok 8 - starting cluster as root 5416s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 5416s ok 10 - soft core size is 0 5416s # hard core file size limit of root-started postgres process is unlimited 5416s ok 11 - set pg_ctl default option to -c 5427s ok 12 - pg_ctlcluster 17 main restart 5427s ok 13 - restarting cluster as root 5427s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 5427s ok 15 - soft core size is unlimited 5431s ok 16 - pg_ctlcluster 17 main stop 5431s ok 17 - stopping cluster 5431s ok 18 - restored pg_ctl default option 5439s ok 19 - pg_ctlcluster 17 main start -- -c 5439s ok 20 - starting cluster with -c on the command line as postgres 5439s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 5439s ok 22 - soft core size is unlimited 5441s ok 23 - pg_ctlcluster 17 main stop 5441s ok 24 - stopping cluster 5476s ok 25 - dropping cluster 5476s # Cleanup 5478s ok 26 - Cleanup: No clusters left behind 5478s ok 27 - No postgres processes left behind 5478s ok 28 - No files in /etc/postgresql left behind 5478s ok 29 - No files in /var/lib/postgresql left behind 5478s ok 30 - No files in /var/run/postgresql left behind 5478s ok 31 - No files in /var/log/postgresql left behind 5478s ok 32 - PostgreSQL TCP ports are closed 5478s ok 33 - Next free port is 5432 5478s ### End test 085_pg_ctl.conf.t ### 5478s 5478s ### PostgreSQL test 090_multicluster.t ### 5480s 1..125 5515s ok 1 - pg_createcluster 17 old 5550s ok 2 - pg_createcluster 17 new1 5584s ok 3 - pg_createcluster 17 new2 5593s ok 4 - starting cluster 17/old 5603s ok 5 - starting cluster 17/new1 5612s ok 6 - starting cluster 17/new2 5614s ok 7 - pg_lsclusters -h | sort -k3 5614s ok 8 - clusters have the correct ports, skipping used 5433 5614s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 5616s ok 10 - createdb --version 5616s ok 11 - pg_wrapper selects port 5432 as default cluster 5618s ok 12 - createdb --cluster 17/new1 --version 5618s ok 13 - pg_wrapper --cluster works 5619s ok 14 - createdb --cluster 17/foo --version 5619s ok 15 - pg_wrapper --cluster errors out for invalid cluster 5623s ok 16 - createdb --cluster 17/new1 test 5623s ok 17 - correct output of createdb --cluster 17/new1 test 5625s ok 18 - psql -Atl --cluster 17/new1 5625s ok 19 - test db appears in cluster new1 5628s ok 20 - psql -Atl --cluster 17/new2 5628s ok 21 - test db does not appear in cluster new2 5630s ok 22 - psql -Atl 5630s ok 23 - test db does not appear in default cluster 5633s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 5633s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 5635s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 5635s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 5638s ok 28 - psql -Atl --cluster 17/localhost:5434 5638s ok 29 - test db appears in cluster 17/localhost:5434 5640s ok 30 - psql -Atl --cluster 17/localhost:5440 5640s ok 31 - test db does not appear in cluster 17/localhost:5440 5641s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 5641s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 5643s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 5643s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 5644s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 5644s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 5645s ok 38 - psql -Atl --cluster 6.4/localhost: 5645s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 5647s ok 40 - psql -Atl 5647s ok 41 - PGCLUSTER selection (1) 5649s ok 42 - psql -Atl 5649s ok 43 - PGCLUSTER selection (2) 5651s ok 44 - psql -l 5651s ok 45 - invalid PGCLUSTER value 5652s ok 46 - createdb --version 5652s ok 47 - PGCLUSTER network cluster selection (1) 5654s ok 48 - psql -Atl 5654s ok 49 - PGCLUSTER network cluster selection (2) 5657s ok 50 - psql -Atl 5657s ok 51 - PGCLUSTER network cluster selection (3) 5660s ok 52 - LC_MESSAGES=C psql -Atl 5660s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 5661s ok 54 - psql -Atc "show port" template1 5661s ok 55 - PGPORT selection (1) 5663s ok 56 - psql -Atc "show port" template1 5663s ok 57 - PGPORT selection (2) 5665s ok 58 - createdb --version 5665s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 5667s ok 60 - psql -Atc "show port" template1 5667s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 5669s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 5669s ok 63 - PGDATABASE environment variable works 5671s ok 64 - createdb --version 5671s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 5672s ok 66 - createdb --cluster 17/new1 --version 5672s ok 67 - pg_wrapper --cluster works with empty user_clusters 5674s ok 68 - createdb --version 5674s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 5676s ok 70 - psql -Atc "select current_database()" 5676s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 5678s ok 72 - psql -Atc 'select current_database()' 5678s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 5679s ok 74 - createdb --version 5679s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 5681s ok 76 - createdb --version 5681s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 5683s ok 78 - createdb --version 5683s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 5685s ok 80 - createdb --version 5685s ok 81 - pg_wrapper selects correct version with per-user user_clusters 5687s ok 82 - createdb --version 5687s ok 83 - pg_wrapper selects correct version with per-user user_clusters 5689s ok 84 - createdb --version 5689s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 5691s ok 86 - psql -Atl 5691s ok 87 - $PGHOST overrides user_clusters 5693s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 5693s ok 89 - --cluster overrides $PGHOST 5696s ok 90 - createdb --version 5696s ok 91 - pg_wrapper ignores invalid lines in user_clusters 5698s ok 92 - psql -Atc 'select current_database()' 5698s ok 93 - pg_service conf selection 1 5701s ok 94 - psql -Atc 'select current_database()' 5701s ok 95 - pg_service conf selection 2 5703s ok 96 - psql -Atc 'select current_database()' 5703s ok 97 - pg_service conf selection 3 5708s ok 98 - stopping cluster 17/old 5718s ok 99 - restarting cluster 17/old 5720s ok 100 - pg_lsclusters -h | sort -k3 5720s ok 101 - port of first cluster was successfully changed 5722s ok 102 - psql -l 5722s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 5725s ok 104 - psql -Atl --cluster 17/new1 5725s ok 105 - --cluster selects appropriate cluster 5727s ok 106 - psql -Atl -p 5434 5727s ok 107 - -p selects appropriate cluster 5729s ok 108 - psql -Atlp 5434 5729s ok 109 - -Atlp selects appropriate cluster 5731s ok 110 - psql -Atl --port 5434 5731s ok 111 - --port selects appropriate cluster 5733s ok 112 - env PGPORT=5434 psql -Atl 5733s ok 113 - $PGPORT selects appropriate cluster 5733s ok 114 - Restoring original /etc/postgresql-common/user_clusters 5783s ok 115 - dropping 17/new1 5828s ok 116 - dropping 17/new2 5874s ok 117 - dropping 17/old 5874s # Cleanup 5875s ok 118 - Cleanup: No clusters left behind 5875s ok 119 - No postgres processes left behind 5875s ok 120 - No files in /etc/postgresql left behind 5875s ok 121 - No files in /var/lib/postgresql left behind 5875s ok 122 - No files in /var/run/postgresql left behind 5875s ok 123 - No files in /var/log/postgresql left behind 5876s ok 124 - PostgreSQL TCP ports are closed 5876s ok 125 - Next free port is 5432 5876s ### End test 090_multicluster.t ### 5876s 5876s ### PostgreSQL test 110_integrate_cluster.t ### 5879s 1..32 5900s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/rb7W8JpRCe/c/postgres 5900s ok 2 - creating raw initdb cluster for user postgres 5915s ok 3 - pg_createcluster 17 postgres -d /tmp/rb7W8JpRCe/c/postgres 5915s ok 4 - integrating postgres cluster 5917s ok 5 - pg_lsclusters 5917s ok 6 - correct pg_lsclusters output 5924s ok 7 - pg_ctlcluster 17 postgres start 5924s ok 8 - starting cluster postgres 5926s ok 9 - pg_lsclusters 5926s ok 10 - correct pg_lsclusters output 5968s ok 11 - dropping cluster postgres 5968s ok 12 - No files in temporary cluster dir left behind 5990s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/rb7W8JpRCe/c/nobody 5990s ok 14 - creating raw initdb cluster for user nobody 6004s ok 15 - pg_createcluster 17 nobody -d /tmp/rb7W8JpRCe/c/nobody 6004s ok 16 - integrating nobody cluster 6005s ok 17 - pg_lsclusters 6005s ok 18 - correct pg_lsclusters output 6012s ok 19 - pg_ctlcluster 17 nobody start 6012s ok 20 - starting cluster nobody 6014s ok 21 - pg_lsclusters 6014s ok 22 - correct pg_lsclusters output 6060s ok 23 - dropping cluster nobody 6060s ok 24 - No files in temporary cluster dir left behind 6060s # Cleanup 6062s ok 25 - Cleanup: No clusters left behind 6062s ok 26 - No postgres processes left behind 6062s ok 27 - No files in /etc/postgresql left behind 6062s ok 28 - No files in /var/lib/postgresql left behind 6062s ok 29 - No files in /var/run/postgresql left behind 6062s ok 30 - No files in /var/log/postgresql left behind 6063s ok 31 - PostgreSQL TCP ports are closed 6063s ok 32 - Next free port is 5432 6063s ### End test 110_integrate_cluster.t ### 6063s 6063s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 6065s 1..1 6065s ok 1 - only one major version installed, skipping upgrade tests 6065s ### End test 120_pg_upgradecluster_scripts.t ### 6065s 6065s ### PostgreSQL test 130_nonroot_admin.t ### 6067s 1..22 6103s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 6106s ok 2 - pg_lsclusters -h 6106s ok 3 - correct output of pg_lsclusters -h 6108s ok 4 - psql -Atl 6108s ok 5 - correct output of psql -Atl 6114s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 6114s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 6114s # Cleanup 6115s ok 15 - Cleanup: No clusters left behind 6116s ok 16 - No postgres processes left behind 6116s ok 17 - No files in /etc/postgresql left behind 6116s ok 18 - No files in /var/lib/postgresql left behind 6116s ok 19 - No files in /var/run/postgresql left behind 6116s ok 20 - No files in /var/log/postgresql left behind 6116s ok 21 - PostgreSQL TCP ports are closed 6116s ok 22 - Next free port is 5432 6116s ### End test 130_nonroot_admin.t ### 6116s 6116s ### PostgreSQL test 135_pg_virtualenv.t ### 6118s 1..20 6215s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6215s ok 2 - running pg_virtualenv as root 6265s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6265s ok 4 - running pg_virtualenv as postgres 6313s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6313s ok 6 - running pg_virtualenv as nobody 6359s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6359s ok 8 - running fakeroot pg_virtualenv as root 6408s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6408s ok 10 - running fakeroot pg_virtualenv as postgres 6453s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 6453s ok 12 - running fakeroot pg_virtualenv as nobody 6453s # Cleanup 6454s ok 13 - Cleanup: No clusters left behind 6455s ok 14 - No postgres processes left behind 6455s ok 15 - No files in /etc/postgresql left behind 6455s ok 16 - No files in /var/lib/postgresql left behind 6455s ok 17 - No files in /var/run/postgresql left behind 6455s ok 18 - No files in /var/log/postgresql left behind 6455s ok 19 - PostgreSQL TCP ports are closed 6455s ok 20 - Next free port is 5432 6455s ### End test 135_pg_virtualenv.t ### 6455s 6455s ### PostgreSQL test 140_pg_config.t ### 6458s 1..38 6461s # Multiarch is enabled 6461s # checking version specific output for 17 6461s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 6461s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 6461s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 6461s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 6461s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 6461s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 6461s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 6461s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 6462s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 6462s # checking pg_config output (should behave like version 17) 6463s ok 15 - pg_config 6463s ok 16 - correct output of pg_config 6463s ok 17 - pg_config --help 6463s ok 18 - correct output of pg_config --help 6464s ok 19 - pg_config --pgxs 6464s ok 20 - correct output of pg_config --pgxs 6464s ok 21 - pg_config --libdir 6464s ok 22 - correct output of pg_config --libdir 6464s ok 23 - pg_config --pkglibdir 6464s ok 24 - correct output of pg_config --pkglibdir 6465s ok 25 - pg_config --bindir 6465s ok 26 - correct output of pg_config --bindir 6465s # checking pg_config.libpq-dev output (should behave like version 17) 6466s ok 27 - pg_config.libpq-dev 6466s ok 28 - correct output of pg_config.libpq-dev 6467s ok 29 - pg_config.libpq-dev --help 6467s ok 30 - correct output of pg_config.libpq-dev --help 6468s ok 31 - pg_config.libpq-dev --pgxs 6468s ok 32 - correct output of pg_config.libpq-dev --pgxs 6468s ok 33 - pg_config.libpq-dev --libdir 6468s ok 34 - correct output of pg_config.libpq-dev --libdir 6469s ok 35 - pg_config.libpq-dev --pkglibdir 6469s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 6470s ok 37 - pg_config.libpq-dev --bindir 6470s ok 38 - correct output of pg_config.libpq-dev --bindir 6470s ### End test 140_pg_config.t ### 6470s 6470s ### PostgreSQL test 150_tsearch_stemming.t ### 6472s 1..37 6474s ok 1 - pg_updatedicts succeeded 6474s ok 2 - pg_updatedicts created en_us.affix 6474s ok 3 - pg_updatedicts created en_us.dict 6474s ok 4 - pg_updatedicts created 17 en_us.affix symlink 6474s ok 5 - pg_updatedicts created 17 en_us.dict symlink 6521s ok 6 - pg_createcluster 17 main 6525s ok 7 - createdb fts 6525s ok 8 - correct output of createdb fts 6530s ok 9 - creating en_US full text search configuration 6535s ok 10 - creating data table and search index 6539s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 6539s ok 12 - stem search of correct word 6544s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 6544s ok 14 - stem search of correct word 6548s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 6548s ok 16 - stem search of unknown word 6550s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 6550s ok 18 - full text search, exact word 6552s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 6552s ok 20 - full text search for word stem 6554s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 6554s ok 22 - full text search for word substring fails 6557s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 6557s ok 24 - full text search, exact unicode word 6560s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 6560s ok 26 - full text search for unicode word stem 6563s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 6563s ok 28 - full text search for unicode word substring fails 6617s ok 29 6617s # Cleanup 6619s ok 30 - Cleanup: No clusters left behind 6619s ok 31 - No postgres processes left behind 6619s ok 32 - No files in /etc/postgresql left behind 6619s ok 33 - No files in /var/lib/postgresql left behind 6619s ok 34 - No files in /var/run/postgresql left behind 6619s ok 35 - No files in /var/log/postgresql left behind 6620s ok 36 - PostgreSQL TCP ports are closed 6620s ok 37 - Next free port is 5432 6620s ### End test 150_tsearch_stemming.t ### 6620s 6620s ### PostgreSQL test 160_alternate_confroot.t ### 6623s 1..28 6666s ok 1 6668s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 6668s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 6670s ok 4 - pg_lsclusters -h 6670s ok 5 - correct output of pg_lsclusters -h 6673s ok 6 - psql -Atl 6673s ok 7 - correct output of psql -Atl 6673s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 6673s ok 9 - ... 6673s ok 10 - ... 6673s ok 11 - ... 6673s ok 12 - ... 6673s ok 13 - ... 6673s ok 14 - ... 6679s ok 15 - pg_dropcluster 17 test --stop 6679s ok 16 - correct output of pg_dropcluster 17 test --stop 6681s ok 17 - pg_lsclusters -h 6681s ok 18 - correct output of pg_lsclusters -h 6681s ok 19 - No files in root/data left behind 6681s ok 20 - No cruft in root dir left behind 6681s # Cleanup 6683s ok 21 - Cleanup: No clusters left behind 6684s ok 22 - No postgres processes left behind 6684s ok 23 - No files in /etc/postgresql left behind 6684s ok 24 - No files in /var/lib/postgresql left behind 6684s ok 25 - No files in /var/run/postgresql left behind 6684s ok 26 - No files in /var/log/postgresql left behind 6684s ok 27 - PostgreSQL TCP ports are closed 6684s ok 28 - Next free port is 5432 6684s ### End test 160_alternate_confroot.t ### 6684s 6684s ### PostgreSQL test 170_extensions.t ### 6687s # Running tests for 17 6742s ok 1 - pg_createcluster 17 main 6744s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 6744s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 6747s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 6747s ok 5 - extension amcheck installs without error 6750s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 6750s ok 7 - extension amcheck removes without error 6752s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 6752s ok 9 - extension autoinc installs without error 6754s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 6754s ok 11 - extension autoinc removes without error 6756s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 6757s ok 13 - extension bloom installs without error 6759s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 6759s ok 15 - extension bloom removes without error 6763s ok 16 - psql -qc 'CREATE EXTENSION plperl' 6763s ok 17 - bool_plperl dependency plperl installs without error 6766s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 6766s ok 19 - extension bool_plperl installs without error 6768s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 6768s ok 21 - extension bool_plperl removes without error 6771s ok 22 - psql -qc 'DROP EXTENSION plperl' 6771s ok 23 - bool_plperl dependency extension plperl removes without error 6773s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 6773s ok 25 - bool_plperlu dependency plperlu installs without error 6776s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 6776s ok 27 - extension bool_plperlu installs without error 6778s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 6778s ok 29 - extension bool_plperlu removes without error 6780s ok 30 - psql -qc 'DROP EXTENSION plperlu' 6780s ok 31 - bool_plperlu dependency extension plperlu removes without error 6783s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 6783s ok 33 - extension btree_gin installs without error 6786s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 6786s ok 35 - extension btree_gin removes without error 6789s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 6789s ok 37 - extension btree_gist installs without error 6793s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 6793s ok 39 - extension btree_gist removes without error 6795s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 6795s ok 41 - extension citext installs without error 6799s ok 42 - psql -qc 'DROP EXTENSION "citext"' 6799s ok 43 - extension citext removes without error 6802s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 6802s ok 45 - extension cube installs without error 6804s ok 46 - psql -qc 'DROP EXTENSION "cube"' 6804s ok 47 - extension cube removes without error 6808s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 6808s ok 49 - extension dblink installs without error 6810s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 6810s ok 51 - extension dblink removes without error 6813s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 6813s ok 53 - extension dict_int installs without error 6815s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 6815s ok 55 - extension dict_int removes without error 6818s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 6818s ok 57 - extension dict_xsyn installs without error 6820s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 6820s ok 59 - extension dict_xsyn removes without error 6822s ok 60 - psql -qc 'CREATE EXTENSION cube' 6822s ok 61 - earthdistance dependency cube installs without error 6825s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 6825s ok 63 - extension earthdistance installs without error 6827s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 6827s ok 65 - extension earthdistance removes without error 6830s ok 66 - psql -qc 'DROP EXTENSION cube' 6830s ok 67 - earthdistance dependency extension cube removes without error 6832s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 6832s ok 69 - extension file_fdw installs without error 6835s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 6835s ok 71 - extension file_fdw removes without error 6837s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 6837s ok 73 - extension fuzzystrmatch installs without error 6840s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 6840s ok 75 - extension fuzzystrmatch removes without error 6842s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 6842s ok 77 - extension hstore installs without error 6845s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 6845s ok 79 - extension hstore removes without error 6847s ok 80 - psql -qc 'CREATE EXTENSION hstore' 6847s ok 81 - hstore_plperl dependency hstore installs without error 6850s ok 82 - psql -qc 'CREATE EXTENSION plperl' 6850s ok 83 - hstore_plperl dependency plperl installs without error 6853s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 6853s ok 85 - extension hstore_plperl installs without error 6856s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 6856s ok 87 - extension hstore_plperl removes without error 6858s ok 88 - psql -qc 'DROP EXTENSION hstore' 6858s ok 89 - hstore_plperl dependency extension hstore removes without error 6861s ok 90 - psql -qc 'DROP EXTENSION plperl' 6861s ok 91 - hstore_plperl dependency extension plperl removes without error 6863s ok 92 - psql -qc 'CREATE EXTENSION hstore' 6863s ok 93 - hstore_plperlu dependency hstore installs without error 6866s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 6866s ok 95 - hstore_plperlu dependency plperlu installs without error 6868s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 6868s ok 97 - extension hstore_plperlu installs without error 6871s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 6871s ok 99 - extension hstore_plperlu removes without error 6873s ok 100 - psql -qc 'DROP EXTENSION hstore' 6873s ok 101 - hstore_plperlu dependency extension hstore removes without error 6875s ok 102 - psql -qc 'DROP EXTENSION plperlu' 6875s ok 103 - hstore_plperlu dependency extension plperlu removes without error 6878s ok 104 - psql -qc 'CREATE EXTENSION hstore' 6878s ok 105 - hstore_plpython3u dependency hstore installs without error 6880s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 6880s ok 107 - hstore_plpython3u dependency plpython3u installs without error 6882s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 6882s ok 109 - extension hstore_plpython3u installs without error 6884s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 6884s ok 111 - extension hstore_plpython3u removes without error 6886s ok 112 - psql -qc 'DROP EXTENSION hstore' 6886s ok 113 - hstore_plpython3u dependency extension hstore removes without error 6889s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 6889s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 6891s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 6891s ok 117 - extension insert_username installs without error 6893s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 6893s ok 119 - extension insert_username removes without error 6896s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 6896s ok 121 - extension intagg installs without error 6898s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 6898s ok 123 - extension intagg removes without error 6900s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 6900s ok 125 - extension intarray installs without error 6902s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 6902s ok 127 - extension intarray removes without error 6906s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 6906s ok 129 - extension isn installs without error 6908s ok 130 - psql -qc 'DROP EXTENSION "isn"' 6908s ok 131 - extension isn removes without error 6911s ok 132 - psql -qc 'CREATE EXTENSION plperl' 6911s ok 133 - jsonb_plperl dependency plperl installs without error 6913s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 6913s ok 135 - extension jsonb_plperl installs without error 6915s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 6915s ok 137 - extension jsonb_plperl removes without error 6917s ok 138 - psql -qc 'DROP EXTENSION plperl' 6917s ok 139 - jsonb_plperl dependency extension plperl removes without error 6920s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 6920s ok 141 - jsonb_plperlu dependency plperlu installs without error 6922s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 6922s ok 143 - extension jsonb_plperlu installs without error 6924s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 6924s ok 145 - extension jsonb_plperlu removes without error 6926s ok 146 - psql -qc 'DROP EXTENSION plperlu' 6926s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 6928s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 6928s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 6931s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 6931s ok 151 - extension jsonb_plpython3u installs without error 6933s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 6933s ok 153 - extension jsonb_plpython3u removes without error 6936s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 6936s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 6938s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 6938s ok 157 - extension lo installs without error 6941s ok 158 - psql -qc 'DROP EXTENSION "lo"' 6941s ok 159 - extension lo removes without error 6944s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 6944s ok 161 - extension ltree installs without error 6946s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 6946s ok 163 - extension ltree removes without error 6949s ok 164 - psql -qc 'CREATE EXTENSION ltree' 6949s ok 165 - ltree_plpython3u dependency ltree installs without error 6952s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 6952s ok 167 - ltree_plpython3u dependency plpython3u installs without error 6955s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 6955s ok 169 - extension ltree_plpython3u installs without error 6957s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 6957s ok 171 - extension ltree_plpython3u removes without error 6959s ok 172 - psql -qc 'DROP EXTENSION ltree' 6959s ok 173 - ltree_plpython3u dependency extension ltree removes without error 6961s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 6961s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 6964s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 6964s ok 177 - extension moddatetime installs without error 6967s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 6967s ok 179 - extension moddatetime removes without error 6969s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 6969s ok 181 - extension pageinspect installs without error 6971s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 6971s ok 183 - extension pageinspect removes without error 6973s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 6973s ok 185 - extension pg_buffercache installs without error 6976s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 6976s ok 187 - extension pg_buffercache removes without error 6978s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 6978s ok 189 - extension pg_freespacemap installs without error 6981s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 6981s ok 191 - extension pg_freespacemap removes without error 6983s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 6983s ok 193 - extension pg_prewarm installs without error 6985s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 6985s ok 195 - extension pg_prewarm removes without error 6987s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 6987s ok 197 - extension pg_stat_statements installs without error 6989s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 6989s ok 199 - extension pg_stat_statements removes without error 6991s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 6991s ok 201 - extension pg_surgery installs without error 6994s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 6994s ok 203 - extension pg_surgery removes without error 6997s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 6997s ok 205 - extension pg_trgm installs without error 6999s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 6999s ok 207 - extension pg_trgm removes without error 7001s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 7001s ok 209 - extension pg_visibility installs without error 7003s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 7003s ok 211 - extension pg_visibility removes without error 7005s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 7005s ok 213 - extension pg_walinspect installs without error 7007s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 7007s ok 215 - extension pg_walinspect removes without error 7009s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 7009s ok 217 - extension pgcrypto installs without error 7012s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 7012s ok 219 - extension pgcrypto removes without error 7014s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 7014s ok 221 - extension pgrowlocks installs without error 7017s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 7017s ok 223 - extension pgrowlocks removes without error 7020s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 7020s ok 225 - extension pgstattuple installs without error 7023s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 7023s ok 227 - extension pgstattuple removes without error 7026s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 7026s ok 229 - extension plperl installs without error 7028s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 7028s ok 231 - extension plperl removes without error 7030s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 7030s ok 233 - extension plperlu installs without error 7032s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 7032s ok 235 - extension plperlu removes without error 7035s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 7035s ok 237 - extension plpython3u installs without error 7037s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 7037s ok 239 - extension plpython3u removes without error 7039s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 7039s ok 241 - extension pltcl installs without error 7041s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 7041s ok 243 - extension pltcl removes without error 7043s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 7043s ok 245 - extension pltclu installs without error 7045s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 7045s ok 247 - extension pltclu removes without error 7048s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 7048s ok 249 - extension postgres_fdw installs without error 7050s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 7050s ok 251 - extension postgres_fdw removes without error 7052s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 7052s ok 253 - extension refint installs without error 7054s ok 254 - psql -qc 'DROP EXTENSION "refint"' 7054s ok 255 - extension refint removes without error 7057s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 7057s ok 257 - extension seg installs without error 7059s ok 258 - psql -qc 'DROP EXTENSION "seg"' 7059s ok 259 - extension seg removes without error 7061s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 7061s ok 261 - extension sslinfo installs without error 7064s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 7064s ok 263 - extension sslinfo removes without error 7067s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 7067s ok 265 - extension tablefunc installs without error 7069s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 7069s ok 267 - extension tablefunc removes without error 7072s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 7072s ok 269 - extension tcn installs without error 7075s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 7075s ok 271 - extension tcn removes without error 7077s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 7077s ok 273 - extension tsm_system_rows installs without error 7079s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 7079s ok 275 - extension tsm_system_rows removes without error 7081s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 7081s ok 277 - extension tsm_system_time installs without error 7083s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 7083s ok 279 - extension tsm_system_time removes without error 7086s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 7086s ok 281 - extension unaccent installs without error 7088s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 7088s ok 283 - extension unaccent removes without error 7090s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 7090s ok 285 - extension uuid-ossp installs without error 7093s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 7093s ok 287 - extension uuid-ossp removes without error 7095s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 7096s ok 289 - extension xml2 installs without error 7097s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 7097s ok 291 - extension xml2 removes without error 7145s ok 292 - pg_dropcluster 17 main 7145s # Cleanup 7147s ok 293 - Cleanup: No clusters left behind 7147s ok 294 - No postgres processes left behind 7147s ok 295 - No files in /etc/postgresql left behind 7147s ok 296 - No files in /var/lib/postgresql left behind 7147s ok 297 - No files in /var/run/postgresql left behind 7147s ok 298 - No files in /var/log/postgresql left behind 7147s ok 299 - PostgreSQL TCP ports are closed 7147s ok 300 - Next free port is 5432 7147s 1..300 7148s ### End test 170_extensions.t ### 7148s 7148s ### PostgreSQL test 180_ecpg.t ### 7150s 1..14 7151s ok 1 - ecpg test.pgc 7151s ok 2 - ecpg processing 7155s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 7155s ok 4 - compiling ecpg output 7205s ok 5 - pg_virtualenv /tmp/tmp.JvMrgx2QPH/test 7205s ok 6 - test program runs and gives correct output 7205s # Cleanup 7207s ok 7 - Cleanup: No clusters left behind 7207s ok 8 - No postgres processes left behind 7207s ok 9 - No files in /etc/postgresql left behind 7207s ok 10 - No files in /var/lib/postgresql left behind 7207s ok 11 - No files in /var/run/postgresql left behind 7207s ok 12 - No files in /var/log/postgresql left behind 7207s ok 13 - PostgreSQL TCP ports are closed 7208s ok 14 - Next free port is 5432 7208s ### End test 180_ecpg.t ### 7208s 7208s ### PostgreSQL test 190_pg_buildext.t ### 7211s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 7211s 1..1 7211s ### End test 190_pg_buildext.t ### 7211s 7211s ### PostgreSQL test 200_maintscripts.t ### 7213s 1..15 7213s # We are running systemd 7259s ok 1 - pg_createcluster 17 main --start 7259s ok 2 - postmaster PID is 21421 7346s ok 3 - apt-get update -q 7347s # postgresql-common: 7347s # Installed: 277 7347s # Candidate: 277 7347s # Version table: 7347s # *** 277 995 7347s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 Packages 7347s # 100 /var/lib/dpkg/status 7347s # 274 500 7347s # 500 http://ftpmaster.internal/ubuntu questing/main riscv64 Packages 7437s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 7439s # postgresql-common: 7439s # Installed: 277 7439s # Candidate: 277 7439s # Version table: 7439s # *** 277 995 7439s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 Packages 7439s # 100 /var/lib/dpkg/status 7439s # 274 500 7439s # 500 http://ftpmaster.internal/ubuntu questing/main riscv64 Packages 7439s ok 5 - postmaster PID is 21421 7439s ok 6 - postmaster was not restarted 7491s ok 7 - pg_dropcluster 17 main --stop 7491s # Cleanup 7492s ok 8 - Cleanup: No clusters left behind 7493s ok 9 - No postgres processes left behind 7493s ok 10 - No files in /etc/postgresql left behind 7493s ok 11 - No files in /var/lib/postgresql left behind 7493s ok 12 - No files in /var/run/postgresql left behind 7493s ok 13 - No files in /var/log/postgresql left behind 7493s ok 14 - PostgreSQL TCP ports are closed 7493s ok 15 - Next free port is 5432 7493s ### End test 200_maintscripts.t ### 7493s 7505s autopkgtest [01:29:14]: test run-testsuite: -----------------------] 7509s run-testsuite PASS 7509s autopkgtest [01:29:18]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 7512s autopkgtest [01:29:21]: test installcheck: preparing testbed 7873s autopkgtest [01:35:22]: testbed dpkg architecture: riscv64 7874s autopkgtest [01:35:23]: testbed apt version: 3.0.0 7878s autopkgtest [01:35:27]: @@@@@@@@@@@@@@@@@@@@ test bed setup 7879s autopkgtest [01:35:28]: testbed release detected to be: questing 7887s autopkgtest [01:35:36]: updating testbed package index (apt update) 7891s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 7891s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 7891s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 7891s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 7892s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2281 kB] 7894s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [190 kB] 7894s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 7894s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 Packages [169 kB] 7894s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe riscv64 Packages [833 kB] 7895s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse riscv64 Packages [15.3 kB] 7901s Fetched 3655 kB in 9s (405 kB/s) 7924s Reading package lists... 7931s autopkgtest [01:36:20]: upgrading testbed (apt dist-upgrade and autopurge) 7934s Reading package lists... 7937s Building dependency tree... 7937s Reading state information... 7942s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 7943s Starting 2 pkgProblemResolver with broken count: 0 7943s Done 7949s Entering ResolveByKeep 7951s 7953s Calculating upgrade... 7956s The following packages will be upgraded: 7956s dpkg dpkg-dev libdpkg-perl libperl5.40 perl perl-base perl-modules-5.40 7957s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 7957s Need to get 12.5 MB of archives. 7957s After this operation, 1024 B of additional disk space will be used. 7957s Get:1 http://ftpmaster.internal/ubuntu questing/main riscv64 dpkg riscv64 1.22.18ubuntu3 [1315 kB] 7957s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 libperl5.40 riscv64 5.40.1-3 [4483 kB] 7958s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl riscv64 5.40.1-3 [262 kB] 7958s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl-base riscv64 5.40.1-3 [1845 kB] 7959s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 perl-modules-5.40 all 5.40.1-3 [3217 kB] 7960s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 dpkg-dev all 1.22.18ubuntu3 [1089 kB] 7960s Get:7 http://ftpmaster.internal/ubuntu questing/main riscv64 libdpkg-perl all 1.22.18ubuntu3 [281 kB] 7969s Fetched 12.5 MB in 4s (3239 kB/s) 7972s (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 ... 114049 files and directories currently installed.) 7972s Preparing to unpack .../dpkg_1.22.18ubuntu3_riscv64.deb ... 7972s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 7976s Setting up dpkg (1.22.18ubuntu3) ... 7993s (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 ... 114049 files and directories currently installed.) 7993s Preparing to unpack .../libperl5.40_5.40.1-3_riscv64.deb ... 7993s Unpacking libperl5.40:riscv64 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 8001s Preparing to unpack .../perl_5.40.1-3_riscv64.deb ... 8001s Unpacking perl (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 8002s Preparing to unpack .../perl-base_5.40.1-3_riscv64.deb ... 8002s Unpacking perl-base (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 8007s Setting up perl-base (5.40.1-3) ... 8009s (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 ... 114049 files and directories currently installed.) 8009s Preparing to unpack .../perl-modules-5.40_5.40.1-3_all.deb ... 8009s Unpacking perl-modules-5.40 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 8020s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 8020s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 8022s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 8022s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 8024s Setting up perl-modules-5.40 (5.40.1-3) ... 8024s Setting up libperl5.40:riscv64 (5.40.1-3) ... 8024s Setting up perl (5.40.1-3) ... 8024s Setting up libdpkg-perl (1.22.18ubuntu3) ... 8024s Setting up dpkg-dev (1.22.18ubuntu3) ... 8024s Processing triggers for man-db (2.13.0-1) ... 8036s Processing triggers for libc-bin (2.41-6ubuntu1) ... 8048s Reading package lists... 8051s Building dependency tree... 8051s Reading state information... 8054s Starting pkgProblemResolver with broken count: 0 8056s Starting 2 pkgProblemResolver with broken count: 0 8056s Done 8060s Solving dependencies... 8062s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 8065s autopkgtest [01:38:34]: rebooting testbed after setup commands that affected boot 8075s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8079s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8112s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8145s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8178s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8211s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8244s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 8306s Reading package lists... 8310s Building dependency tree... 8310s Reading state information... 8312s Starting pkgProblemResolver with broken count: 0 8313s Starting 2 pkgProblemResolver with broken count: 0 8313s Done 8317s The following NEW packages will be installed: 8317s build-essential cpp cpp-14 cpp-14-riscv64-linux-gnu cpp-riscv64-linux-gnu 8317s g++ g++-14 g++-14-riscv64-linux-gnu g++-riscv64-linux-gnu gcc gcc-14 8317s gcc-14-riscv64-linux-gnu gcc-riscv64-linux-gnu libasan8 libcc1-0 8317s libgcc-14-dev libgomp1 libio-pty-perl libipc-run-perl libisl23 libitm1 8317s libjson-perl liblsan0 libmpc3 libpq-dev libpq5 libssl-dev libstdc++-14-dev 8317s libtsan2 libubsan1 libxslt1.1 postgresql-17 postgresql-client-17 8317s postgresql-client-common postgresql-common postgresql-common-dev 8317s postgresql-server-dev-17 ssl-cert tzdata-legacy 8318s 0 upgraded, 39 newly installed, 0 to remove and 0 not upgraded. 8318s Need to get 101 MB of archives. 8318s After this operation, 465 MB of additional disk space will be used. 8318s Get:1 http://ftpmaster.internal/ubuntu questing/main riscv64 libjson-perl all 4.10000-1 [81.9 kB] 8318s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-client-common all 277 [48.0 kB] 8318s Get:3 http://ftpmaster.internal/ubuntu questing/main riscv64 libio-pty-perl riscv64 1:1.20-1build3 [31.6 kB] 8318s Get:4 http://ftpmaster.internal/ubuntu questing/main riscv64 libipc-run-perl all 20231003.0-2 [91.5 kB] 8318s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-common-dev all 277 [73.4 kB] 8318s Get:6 http://ftpmaster.internal/ubuntu questing/main riscv64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 8319s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main riscv64 postgresql-common all 277 [101 kB] 8319s Get:8 http://ftpmaster.internal/ubuntu questing/main riscv64 libisl23 riscv64 0.27-1 [722 kB] 8319s Get:9 http://ftpmaster.internal/ubuntu questing/main riscv64 libmpc3 riscv64 1.3.1-1build2 [61.5 kB] 8319s Get:10 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [15.2 MB] 8321s Get:11 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-14 riscv64 14.2.0-19ubuntu2 [1028 B] 8321s Get:12 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [5554 B] 8321s Get:13 http://ftpmaster.internal/ubuntu questing/main riscv64 cpp riscv64 4:14.2.0-1ubuntu1 [22.4 kB] 8321s Get:14 http://ftpmaster.internal/ubuntu questing/main riscv64 libcc1-0 riscv64 15-20250404-0ubuntu1 [46.1 kB] 8321s Get:15 http://ftpmaster.internal/ubuntu questing/main riscv64 libgomp1 riscv64 15-20250404-0ubuntu1 [149 kB] 8322s Get:16 http://ftpmaster.internal/ubuntu questing/main riscv64 libitm1 riscv64 15-20250404-0ubuntu1 [29.7 kB] 8322s Get:17 http://ftpmaster.internal/ubuntu questing/main riscv64 libasan8 riscv64 15-20250404-0ubuntu1 [3300 kB] 8322s Get:18 http://ftpmaster.internal/ubuntu questing/main riscv64 liblsan0 riscv64 15-20250404-0ubuntu1 [1470 kB] 8323s Get:19 http://ftpmaster.internal/ubuntu questing/main riscv64 libtsan2 riscv64 15-20250404-0ubuntu1 [2983 kB] 8323s Get:20 http://ftpmaster.internal/ubuntu questing/main riscv64 libubsan1 riscv64 15-20250404-0ubuntu1 [1310 kB] 8323s Get:21 http://ftpmaster.internal/ubuntu questing/main riscv64 libgcc-14-dev riscv64 14.2.0-19ubuntu2 [5994 kB] 8325s Get:22 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [29.9 MB] 8330s Get:23 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-14 riscv64 14.2.0-19ubuntu2 [529 kB] 8330s Get:24 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [1198 B] 8330s Get:25 http://ftpmaster.internal/ubuntu questing/main riscv64 gcc riscv64 4:14.2.0-1ubuntu1 [4998 B] 8330s Get:26 http://ftpmaster.internal/ubuntu questing/main riscv64 libstdc++-14-dev riscv64 14.2.0-19ubuntu2 [6141 kB] 8331s Get:27 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14-riscv64-linux-gnu riscv64 14.2.0-19ubuntu2 [16.8 MB] 8334s Get:28 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-14 riscv64 14.2.0-19ubuntu2 [23.0 kB] 8334s Get:29 http://ftpmaster.internal/ubuntu questing/main riscv64 g++-riscv64-linux-gnu riscv64 4:14.2.0-1ubuntu1 [960 B] 8334s Get:30 http://ftpmaster.internal/ubuntu questing/main riscv64 g++ riscv64 4:14.2.0-1ubuntu1 [1080 B] 8334s Get:31 http://ftpmaster.internal/ubuntu questing/main riscv64 build-essential riscv64 12.12ubuntu1 [5090 B] 8334s Get:32 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq5 riscv64 17.4-1 [148 kB] 8334s Get:33 http://ftpmaster.internal/ubuntu questing/main riscv64 libssl-dev riscv64 3.4.1-1ubuntu3 [6164 kB] 8335s Get:34 http://ftpmaster.internal/ubuntu questing/main riscv64 libpq-dev riscv64 17.4-1 [307 kB] 8335s Get:35 http://ftpmaster.internal/ubuntu questing/main riscv64 libxslt1.1 riscv64 1.1.39-0exp1ubuntu4 [178 kB] 8335s Get:36 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-client-17 riscv64 17.4-1 [1387 kB] 8336s Get:37 http://ftpmaster.internal/ubuntu questing/main riscv64 postgresql-17 riscv64 17.4-1 [5505 kB] 8337s Get:38 http://ftpmaster.internal/ubuntu questing/universe riscv64 postgresql-server-dev-17 riscv64 17.4-1 [1663 kB] 8337s Get:39 http://ftpmaster.internal/ubuntu questing/main riscv64 tzdata-legacy all 2025b-1ubuntu1 [99.2 kB] 8348s Preconfiguring packages ... 8350s Fetched 101 MB in 20s (5057 kB/s) 8350s Selecting previously unselected package libjson-perl. 8353s (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 ... 114049 files and directories currently installed.) 8353s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 8353s Unpacking libjson-perl (4.10000-1) ... 8353s Selecting previously unselected package postgresql-client-common. 8354s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 8354s Unpacking postgresql-client-common (277) ... 8355s Selecting previously unselected package libio-pty-perl. 8355s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_riscv64.deb ... 8355s Unpacking libio-pty-perl (1:1.20-1build3) ... 8356s Selecting previously unselected package libipc-run-perl. 8356s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 8356s Unpacking libipc-run-perl (20231003.0-2) ... 8357s Selecting previously unselected package postgresql-common-dev. 8357s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 8357s Unpacking postgresql-common-dev (277) ... 8358s Selecting previously unselected package ssl-cert. 8358s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 8358s Unpacking ssl-cert (1.1.3ubuntu1) ... 8359s Selecting previously unselected package postgresql-common. 8359s Preparing to unpack .../06-postgresql-common_277_all.deb ... 8359s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 8360s Unpacking postgresql-common (277) ... 8362s Selecting previously unselected package libisl23:riscv64. 8362s Preparing to unpack .../07-libisl23_0.27-1_riscv64.deb ... 8362s Unpacking libisl23:riscv64 (0.27-1) ... 8364s Selecting previously unselected package libmpc3:riscv64. 8364s Preparing to unpack .../08-libmpc3_1.3.1-1build2_riscv64.deb ... 8364s Unpacking libmpc3:riscv64 (1.3.1-1build2) ... 8365s Selecting previously unselected package cpp-14-riscv64-linux-gnu. 8365s Preparing to unpack .../09-cpp-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 8365s Unpacking cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8380s Selecting previously unselected package cpp-14. 8380s Preparing to unpack .../10-cpp-14_14.2.0-19ubuntu2_riscv64.deb ... 8380s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 8380s Selecting previously unselected package cpp-riscv64-linux-gnu. 8381s Preparing to unpack .../11-cpp-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8381s Unpacking cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8381s Selecting previously unselected package cpp. 8382s Preparing to unpack .../12-cpp_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8382s Unpacking cpp (4:14.2.0-1ubuntu1) ... 8383s Selecting previously unselected package libcc1-0:riscv64. 8383s Preparing to unpack .../13-libcc1-0_15-20250404-0ubuntu1_riscv64.deb ... 8383s Unpacking libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 8383s Selecting previously unselected package libgomp1:riscv64. 8384s Preparing to unpack .../14-libgomp1_15-20250404-0ubuntu1_riscv64.deb ... 8384s Unpacking libgomp1:riscv64 (15-20250404-0ubuntu1) ... 8384s Selecting previously unselected package libitm1:riscv64. 8385s Preparing to unpack .../15-libitm1_15-20250404-0ubuntu1_riscv64.deb ... 8385s Unpacking libitm1:riscv64 (15-20250404-0ubuntu1) ... 8386s Selecting previously unselected package libasan8:riscv64. 8386s Preparing to unpack .../16-libasan8_15-20250404-0ubuntu1_riscv64.deb ... 8386s Unpacking libasan8:riscv64 (15-20250404-0ubuntu1) ... 8390s Selecting previously unselected package liblsan0:riscv64. 8390s Preparing to unpack .../17-liblsan0_15-20250404-0ubuntu1_riscv64.deb ... 8390s Unpacking liblsan0:riscv64 (15-20250404-0ubuntu1) ... 8392s Selecting previously unselected package libtsan2:riscv64. 8393s Preparing to unpack .../18-libtsan2_15-20250404-0ubuntu1_riscv64.deb ... 8393s Unpacking libtsan2:riscv64 (15-20250404-0ubuntu1) ... 8396s Selecting previously unselected package libubsan1:riscv64. 8396s Preparing to unpack .../19-libubsan1_15-20250404-0ubuntu1_riscv64.deb ... 8396s Unpacking libubsan1:riscv64 (15-20250404-0ubuntu1) ... 8398s Selecting previously unselected package libgcc-14-dev:riscv64. 8398s Preparing to unpack .../20-libgcc-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 8398s Unpacking libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 8411s Selecting previously unselected package gcc-14-riscv64-linux-gnu. 8411s Preparing to unpack .../21-gcc-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 8411s Unpacking gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8439s Selecting previously unselected package gcc-14. 8439s Preparing to unpack .../22-gcc-14_14.2.0-19ubuntu2_riscv64.deb ... 8439s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 8440s Selecting previously unselected package gcc-riscv64-linux-gnu. 8440s Preparing to unpack .../23-gcc-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8440s Unpacking gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8441s Selecting previously unselected package gcc. 8441s Preparing to unpack .../24-gcc_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8441s Unpacking gcc (4:14.2.0-1ubuntu1) ... 8442s Selecting previously unselected package libstdc++-14-dev:riscv64. 8442s Preparing to unpack .../25-libstdc++-14-dev_14.2.0-19ubuntu2_riscv64.deb ... 8442s Unpacking libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 8457s Selecting previously unselected package g++-14-riscv64-linux-gnu. 8457s Preparing to unpack .../26-g++-14-riscv64-linux-gnu_14.2.0-19ubuntu2_riscv64.deb ... 8457s Unpacking g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8472s Selecting previously unselected package g++-14. 8472s Preparing to unpack .../27-g++-14_14.2.0-19ubuntu2_riscv64.deb ... 8472s Unpacking g++-14 (14.2.0-19ubuntu2) ... 8473s Selecting previously unselected package g++-riscv64-linux-gnu. 8473s Preparing to unpack .../28-g++-riscv64-linux-gnu_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8473s Unpacking g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8474s Selecting previously unselected package g++. 8474s Preparing to unpack .../29-g++_4%3a14.2.0-1ubuntu1_riscv64.deb ... 8474s Unpacking g++ (4:14.2.0-1ubuntu1) ... 8475s Selecting previously unselected package build-essential. 8475s Preparing to unpack .../30-build-essential_12.12ubuntu1_riscv64.deb ... 8475s Unpacking build-essential (12.12ubuntu1) ... 8476s Selecting previously unselected package libpq5:riscv64. 8476s Preparing to unpack .../31-libpq5_17.4-1_riscv64.deb ... 8476s Unpacking libpq5:riscv64 (17.4-1) ... 8477s Selecting previously unselected package libssl-dev:riscv64. 8477s Preparing to unpack .../32-libssl-dev_3.4.1-1ubuntu3_riscv64.deb ... 8477s Unpacking libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 8487s Selecting previously unselected package libpq-dev. 8488s Preparing to unpack .../33-libpq-dev_17.4-1_riscv64.deb ... 8488s Unpacking libpq-dev (17.4-1) ... 8489s Selecting previously unselected package libxslt1.1:riscv64. 8489s Preparing to unpack .../34-libxslt1.1_1.1.39-0exp1ubuntu4_riscv64.deb ... 8489s Unpacking libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 8490s Selecting previously unselected package postgresql-client-17. 8490s Preparing to unpack .../35-postgresql-client-17_17.4-1_riscv64.deb ... 8490s Unpacking postgresql-client-17 (17.4-1) ... 8492s Selecting previously unselected package postgresql-17. 8493s Preparing to unpack .../36-postgresql-17_17.4-1_riscv64.deb ... 8493s Unpacking postgresql-17 (17.4-1) ... 8499s Selecting previously unselected package postgresql-server-dev-17. 8499s Preparing to unpack .../37-postgresql-server-dev-17_17.4-1_riscv64.deb ... 8499s Unpacking postgresql-server-dev-17 (17.4-1) ... 8504s Selecting previously unselected package tzdata-legacy. 8504s Preparing to unpack .../38-tzdata-legacy_2025b-1ubuntu1_all.deb ... 8504s Unpacking tzdata-legacy (2025b-1ubuntu1) ... 8506s Setting up postgresql-client-common (277) ... 8507s Setting up libio-pty-perl (1:1.20-1build3) ... 8507s Setting up libpq5:riscv64 (17.4-1) ... 8507s Setting up libgomp1:riscv64 (15-20250404-0ubuntu1) ... 8507s Setting up tzdata-legacy (2025b-1ubuntu1) ... 8507s Setting up ssl-cert (1.1.3ubuntu1) ... 8523s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 8535s Setting up libssl-dev:riscv64 (3.4.1-1ubuntu3) ... 8535s Setting up libmpc3:riscv64 (1.3.1-1build2) ... 8535s Setting up libipc-run-perl (20231003.0-2) ... 8535s Setting up libubsan1:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up libasan8:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up libjson-perl (4.10000-1) ... 8535s Setting up libxslt1.1:riscv64 (1.1.39-0exp1ubuntu4) ... 8535s Setting up libtsan2:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up libisl23:riscv64 (0.27-1) ... 8535s Setting up libcc1-0:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up liblsan0:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up libitm1:riscv64 (15-20250404-0ubuntu1) ... 8535s Setting up postgresql-common-dev (277) ... 8535s Setting up postgresql-client-17 (17.4-1) ... 8564s 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 8565s Setting up libpq-dev (17.4-1) ... 8565s Setting up cpp-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8565s Setting up postgresql-common (277) ... 8582s Creating config file /etc/postgresql-common/createcluster.conf with new version 8589s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 8589s Removing obsolete dictionary files: 8611s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 8626s Setting up cpp-14 (14.2.0-19ubuntu2) ... 8626s Setting up libgcc-14-dev:riscv64 (14.2.0-19ubuntu2) ... 8626s Setting up cpp-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8626s Setting up libstdc++-14-dev:riscv64 (14.2.0-19ubuntu2) ... 8626s Setting up postgresql-17 (17.4-1) ... 8674s Creating new PostgreSQL cluster 17/main ... 8675s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 8676s The files belonging to this database system will be owned by user "postgres". 8676s This user must also own the server process. 8676s 8676s The database cluster will be initialized with locale "C.UTF-8". 8676s The default database encoding has accordingly been set to "UTF8". 8676s The default text search configuration will be set to "english". 8676s 8676s Data page checksums are disabled. 8676s 8676s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 8676s creating subdirectories ... ok 8676s selecting dynamic shared memory implementation ... posix 8677s selecting default "max_connections" ... 100 8678s selecting default "shared_buffers" ... 128MB 8678s selecting default time zone ... Etc/UTC 8678s creating configuration files ... ok 8684s running bootstrap script ... ok 8699s performing post-bootstrap initialization ... ok 8700s syncing data to disk ... ok 8734s Setting up postgresql-server-dev-17 (17.4-1) ... 8734s Setting up gcc-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8734s Setting up cpp (4:14.2.0-1ubuntu1) ... 8735s Setting up g++-14-riscv64-linux-gnu (14.2.0-19ubuntu2) ... 8735s Setting up gcc-14 (14.2.0-19ubuntu2) ... 8735s Setting up gcc-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8735s Setting up g++-riscv64-linux-gnu (4:14.2.0-1ubuntu1) ... 8735s Setting up g++-14 (14.2.0-19ubuntu2) ... 8735s Setting up gcc (4:14.2.0-1ubuntu1) ... 8736s Setting up g++ (4:14.2.0-1ubuntu1) ... 8736s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 8736s Setting up build-essential (12.12ubuntu1) ... 8736s Processing triggers for man-db (2.13.0-1) ... 8749s Processing triggers for libc-bin (2.41-6ubuntu1) ... 8834s autopkgtest [01:51:23]: test installcheck: [----------------------- 8837s + dpkg-parsechangelog -SSource 8840s + SOURCE=postgresql-17 8840s + MAJOR=17 8840s + top_srcdir=/tmp/autopkgtest.wuRKcD/build.R1x/src 8840s + cd src/test/regress 8840s + make -f /tmp/autopkgtest.wuRKcD/build.R1x/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 8841s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -fdebug-prefix-map=/build/postgresql-17-ZlkJUv/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.wuRKcD/build.R1x/src/debian/tests/ -I/usr/include/postgresql/17/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 8866s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -fdebug-prefix-map=/build/postgresql-17-ZlkJUv/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/riscv64-linux-gnu -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -fvisibility=hidden 8867s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.wuRKcD/build.R1x/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/predicate.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/sqljson_jsontable.sql sql/sqljson_queryfuncs.sql sql/stats.sql sql/stats_ext.sql sql/strings.sql sql/subscription.sql sql/subselect.sql sql/sysviews.sql sql/tablesample.sql sql/tablespace.sql sql/temp.sql sql/test_setup.sql sql/text.sql sql/tid.sql sql/tidrangescan.sql sql/tidscan.sql sql/time.sql sql/timestamp.sql sql/timestamptz.sql sql/timetz.sql sql/transactions.sql sql/triggers.sql sql/truncate.sql sql/tsdicts.sql sql/tsearch.sql sql/tsrf.sql sql/tstypes.sql sql/tuplesort.sql sql/txid.sql sql/type_sanity.sql sql/typed_table.sql sql/unicode.sql sql/union.sql sql/updatable_views.sql sql/update.sql sql/uuid.sql sql/vacuum.sql sql/vacuum_parallel.sql sql/varchar.sql sql/window.sql sql/with.sql sql/write_parallel.sql sql/xid.sql sql/xml.sql sql/xmlmap.sql expected/advisory_lock.out expected/aggregates.out expected/alter_generic.out expected/alter_operator.out expected/alter_table.out expected/amutils.out expected/arrays.out expected/async.out expected/bit.out expected/bitmapops.out expected/boolean.out expected/box.out expected/brin.out expected/brin_bloom.out expected/brin_multi.out expected/btree_index.out expected/case.out expected/char.out expected/char_1.out expected/char_2.out expected/circle.out expected/cluster.out expected/collate.icu.utf8.out expected/collate.icu.utf8_1.out expected/collate.linux.utf8.out expected/collate.linux.utf8_1.out expected/collate.out expected/collate.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/matview.out expected/md5.out expected/md5_1.out expected/memoize.out expected/merge.out expected/misc.out expected/misc_functions.out expected/misc_sanity.out expected/money.out expected/multirangetypes.out expected/mvcc.out expected/name.out expected/namespace.out expected/numeric.out expected/numeric_big.out expected/numerology.out expected/object_address.out expected/oid.out expected/oidjoins.out expected/opr_sanity.out expected/partition_aggregate.out expected/partition_info.out expected/partition_join.out expected/partition_prune.out expected/password.out expected/password_1.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/strings.out expected/subscription.out expected/subselect.out expected/sysviews.out expected/tablesample.out expected/tablespace.out expected/temp.out expected/test_setup.out expected/text.out expected/tid.out expected/tidrangescan.out expected/tidscan.out expected/time.out expected/timestamp.out expected/timestamptz.out expected/timetz.out expected/transactions.out expected/triggers.out expected/truncate.out expected/tsdicts.out expected/tsearch.out expected/tsrf.out expected/tstypes.out expected/tuplesort.out expected/txid.out expected/type_sanity.out expected/typed_table.out expected/unicode.out expected/unicode_1.out expected/union.out expected/updatable_views.out expected/update.out expected/uuid.out expected/vacuum.out expected/vacuum_parallel.out expected/varchar.out expected/varchar_1.out expected/varchar_2.out expected/window.out expected/with.out expected/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 8873s + id -u 8873s + [ 1000 = 0 ] 8873s + SU=sh 8873s + sh 8873s + mktemp -d /tmp/regress.XXXXXX 8873s + OUTPUT=/tmp/regress.hW3T6H 8873s + trap rm -rf /tmp/regress.hW3T6H EXIT 8873s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.hW3T6H --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 8876s Creating new PostgreSQL cluster 17/regress ... 8910s # using postmaster on localhost, port 5433 8920s ok 1 - test_setup 5729 ms 8944s # parallel group (20 tests): int2 int4 text int8 varchar char name txid pg_lsn oid float8 boolean money regproc float4 uuid bit enum numeric rangetypes 8944s ok 2 + boolean 15371 ms 8944s ok 3 + char 13294 ms 8945s ok 4 + name 14203 ms 8945s ok 5 + varchar 12802 ms 8945s ok 6 + text 11232 ms 8945s ok 7 + int2 10849 ms 8945s ok 8 + int4 10962 ms 8945s ok 9 + int8 11484 ms 8945s ok 10 + oid 14399 ms 8945s ok 11 + float4 15877 ms 8946s ok 12 + float8 14532 ms 8946s ok 13 + bit 17097 ms 8946s ok 14 + numeric 23602 ms 8946s ok 15 + txid 13978 ms 8946s ok 16 + uuid 15994 ms 8946s ok 17 + enum 17019 ms 8946s ok 18 + money 14791 ms 8947s ok 19 + rangetypes 23991 ms 8947s ok 20 + pg_lsn 13777 ms 8947s ok 21 + regproc 14792 ms 8973s # parallel group (20 tests): md5 lseg circle path line time timetz macaddr macaddr8 point numerology date inet timestamp interval timestamptz strings multirangetypes box polygon 8973s ok 22 + strings 21606 ms 8974s ok 23 + md5 10375 ms 8974s ok 24 + numerology 15496 ms 8974s ok 25 + point 14909 ms 8974s ok 26 + lseg 10735 ms 8974s ok 27 + line 12814 ms 8974s ok 28 + box 25824 ms 8975s ok 29 + path 12652 ms 8975s ok 30 + polygon 26168 ms 8975s ok 31 + circle 11856 ms 8975s ok 32 + date 16329 ms 8975s ok 33 + time 12902 ms 8975s ok 34 + timetz 13839 ms 8975s ok 35 + timestamp 17020 ms 8976s ok 36 + timestamptz 19723 ms 8976s ok 37 + interval 19654 ms 8976s ok 38 + inet 16178 ms 8976s ok 39 + macaddr 13776 ms 8976s ok 40 + macaddr8 13980 ms 8976s ok 41 + multirangetypes 25269 ms 8999s # parallel group (13 tests): comments misc_sanity unicode xid tstypes expressions mvcc horology type_sanity geometry opr_sanity regex database 8999s ok 42 + geometry 14951 ms 9000s ok 43 + horology 13310 ms 9000s ok 44 + tstypes 10339 ms 9000s ok 45 + regex 22509 ms 9000s ok 46 + type_sanity 14823 ms 9000s ok 47 + opr_sanity 20539 ms 9000s ok 48 + misc_sanity 6947 ms 9000s ok 49 + comments 5501 ms 9001s ok 50 + expressions 10637 ms 9001s ok 51 + unicode 7472 ms 9001s ok 52 + xid 9384 ms 9001s ok 53 + mvcc 12321 ms 9001s ok 54 + database 22561 ms 9013s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 9014s ok 55 + copy 7564 ms 9014s ok 56 + copyselect 5381 ms 9014s ok 57 + copydml 5433 ms 9014s ok 58 + insert 12146 ms 9014s ok 59 + insert_conflict 8632 ms 9025s # parallel group (7 tests): create_function_c create_operator create_schema create_type create_misc create_procedure create_table 9025s ok 60 + create_function_c 3621 ms 9025s ok 61 + create_misc 5856 ms 9026s ok 62 + create_operator 4214 ms 9026s ok 63 + create_procedure 5811 ms 9026s ok 64 + create_table 10780 ms 9026s ok 65 + create_type 5354 ms 9026s ok 66 + create_schema 5117 ms 9055s # parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 9055s ok 67 + create_index 28305 ms 9055s ok 68 + create_index_spgist 20834 ms 9055s ok 69 + create_view 15808 ms 9055s ok 70 + index_including 12551 ms 9055s ok 71 + index_including_gist 18050 ms 9098s # parallel group (16 tests): create_cast create_aggregate errors roleattributes hash_func select drop_if_exists typed_table create_function_sql create_am constraints vacuum infinite_recurse updatable_views inherit triggers 9098s ok 72 + create_aggregate 10364 ms 9098s ok 73 + create_function_sql 16672 ms 9098s ok 74 + create_cast 8774 ms 9098s ok 75 + constraints 21654 ms 9098s ok 76 + triggers 42054 ms 9098s ok 77 + select 12807 ms 9099s ok 78 + inherit 38967 ms 9099s ok 79 + typed_table 15818 ms 9099s ok 80 + vacuum 29648 ms 9099s ok 81 + drop_if_exists 12770 ms 9099s ok 82 + updatable_views 38461 ms 9099s ok 83 + roleattributes 10680 ms 9100s ok 84 + create_am 18312 ms 9100s ok 85 + hash_func 10678 ms 9100s ok 86 + errors 10410 ms 9100s ok 87 + infinite_recurse 30187 ms 9105s ok 88 - sanity_check 4114 ms 9177s # parallel group (20 tests): select_distinct_on select_having delete select_implicit case namespace select_into prepared_xacts random transactions select_distinct portals union arrays subselect update join aggregates hash_index btree_index 9178s ok 89 + select_into 18984 ms 9178s ok 90 + select_distinct 26301 ms 9178s ok 91 + select_distinct_on 12431 ms 9178s ok 92 + select_implicit 14657 ms 9178s ok 93 + select_having 13302 ms 9178s ok 94 + subselect 33578 ms 9178s ok 95 + union 29912 ms 9179s ok 96 + case 15831 ms 9179s ok 97 + join 54967 ms 9179s ok 98 + aggregates 56303 ms 9179s ok 99 + transactions 24455 ms 9179s ok 100 + random 20297 ms 9179s ok 101 + portals 29043 ms 9180s ok 102 + arrays 32326 ms 9180s ok 103 + btree_index 72201 ms 9180s ok 104 + hash_index 57618 ms 9180s ok 105 + update 44921 ms 9180s ok 106 + delete 13546 ms 9180s ok 107 + namespace 18197 ms 9181s ok 108 + prepared_xacts 19786 ms 9297s # parallel group (20 tests): init_privs drop_operator security_label lock tablesample object_address collate password replica_identity identity matview generated groupingsets rowsecurity spgist gin gist join_hash brin privileges 9297s ok 109 + brin 102993 ms 9297s ok 110 + gin 79199 ms 9297s ok 111 + gist 89351 ms 9297s ok 112 + spgist 75951 ms 9297s ok 113 + privileges 115720 ms 9298s ok 114 + init_privs 13028 ms 9298s ok 115 + security_label 15644 ms 9298s ok 116 + collate 31052 ms 9298s ok 117 + matview 55547 ms 9300s ok 118 + lock 21497 ms 9300s ok 119 + replica_identity 32134 ms 9300s ok 120 + rowsecurity 70764 ms 9300s ok 121 + object_address 26806 ms 9300s ok 122 + tablesample 22063 ms 9300s ok 123 + groupingsets 67934 ms 9300s ok 124 + drop_operator 14557 ms 9300s ok 125 + password 31275 ms 9300s ok 126 + identity 54443 ms 9300s ok 127 + generated 66084 ms 9300s ok 128 + join_hash 102251 ms 9306s # parallel group (2 tests): brin_bloom brin_multi 9306s ok 129 + brin_bloom 3656 ms 9306s ok 130 + brin_multi 6510 ms 9331s # parallel group (17 tests): async dbsize collate.utf8 tidrangescan tsrf alter_operator tid tidscan create_role sysviews alter_generic misc_functions misc incremental_sort create_table_like merge collate.icu.utf8 9332s ok 131 + create_table_like 24163 ms 9332s ok 132 + alter_generic 17922 ms 9332s ok 133 + alter_operator 11935 ms 9333s ok 134 + misc 18777 ms 9333s ok 135 + async 7812 ms 9333s ok 136 + dbsize 9589 ms 9333s ok 137 + merge 24465 ms 9333s ok 138 + misc_functions 18366 ms 9333s ok 139 + sysviews 17670 ms 9334s ok 140 + tsrf 11689 ms 9334s ok 141 + tid 12457 ms 9334s ok 142 + tidscan 13204 ms 9334s ok 143 + tidrangescan 11554 ms 9334s ok 144 + collate.utf8 10111 ms 9334s ok 145 + collate.icu.utf8 24552 ms 9334s ok 146 + incremental_sort 18361 ms 9335s ok 147 + create_role 14758 ms 9373s # parallel group (7 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab rules psql stats_ext 9373s ok 148 + rules 16237 ms 9373s ok 149 + psql 16685 ms 9373s ok 150 + psql_crosstab 6054 ms 9374s ok 151 + amutils 5292 ms 9374s ok 152 + stats_ext 38286 ms 9374s ok 153 + collate.linux.utf8 4492 ms 9374s ok 154 + collate.windows.win1252 4653 ms 9414s ok 155 - select_parallel 39339 ms 9418s ok 156 - write_parallel 4354 ms 9422s ok 157 - vacuum_parallel 3768 ms 9431s # parallel group (2 tests): subscription publication 9431s ok 158 + publication 7561 ms 9431s ok 159 + subscription 1900 ms 9481s # parallel group (17 tests): portals_p2 advisory_lock combocid functional_deps xmlmap tsdicts equivclass guc dependency select_views window tsearch indirect_toast bitmapops cluster foreign_data foreign_key 9481s ok 160 + select_views 23907 ms 9482s ok 161 + portals_p2 9674 ms 9482s ok 162 + foreign_key 50869 ms 9483s ok 163 + cluster 37510 ms 9483s ok 164 + dependency 16615 ms 9483s ok 165 + guc 16355 ms 9483s ok 166 + bitmapops 36172 ms 9483s ok 167 + combocid 11761 ms 9483s ok 168 + tsearch 32627 ms 9483s ok 169 + tsdicts 15115 ms 9484s ok 170 + foreign_data 40792 ms 9484s ok 171 + window 31792 ms 9484s ok 172 + xmlmap 14474 ms 9484s ok 173 + functional_deps 14268 ms 9484s ok 174 + advisory_lock 10879 ms 9484s ok 175 + indirect_toast 35703 ms 9485s ok 176 + equivclass 14954 ms 9500s # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson sqljson_jsontable sqljson_queryfuncs json jsonb_jsonpath jsonb 9501s ok 177 + json 12573 ms 9501s ok 178 + jsonb 15792 ms 9501s ok 179 + json_encoding 5772 ms 9501s ok 180 + jsonpath 7428 ms 9501s ok 181 + jsonpath_encoding 5339 ms 9501s ok 182 + jsonb_jsonpath 12600 ms 9502s ok 183 + sqljson 10080 ms 9502s ok 184 + sqljson_queryfuncs 12141 ms 9502s ok 185 + sqljson_jsontable 10525 ms 9569s # parallel group (18 tests): prepare returning limit plancache conversion temp sequence polymorphism copy2 largeobject rowtypes truncate with rangefuncs domain plpgsql xml alter_table 9569s ok 186 + plancache 22586 ms 9569s ok 187 + limit 21394 ms 9569s ok 188 + plpgsql 53193 ms 9570s ok 189 + copy2 35036 ms 9570s ok 190 + temp 34343 ms 9570s ok 191 + domain 41573 ms 9570s ok 192 + rangefuncs 38870 ms 9570s ok 193 + prepare 15253 ms 9570s ok 194 + conversion 27013 ms 9570s ok 195 + truncate 38108 ms 9571s ok 196 + alter_table 66689 ms 9571s ok 197 + sequence 34539 ms 9571s ok 198 + polymorphism 34613 ms 9571s ok 199 + rowtypes 36124 ms 9571s ok 200 + returning 18063 ms 9571s ok 201 + largeobject 35671 ms 9571s ok 202 + with 37897 ms 9572s ok 203 + xml 53534 ms 9636s # parallel group (13 tests): predicate hash_part reloptions partition_info explain memoize compression stats partition_aggregate indexing partition_join partition_prune tuplesort 9637s ok 204 + partition_join 58178 ms 9637s ok 205 + partition_prune 59167 ms 9637s ok 206 + reloptions 11986 ms 9637s ok 207 + hash_part 10622 ms 9637s ok 208 + indexing 56719 ms 9637s ok 209 + partition_aggregate 54199 ms 9637s ok 210 + partition_info 14339 ms 9637s ok 211 + tuplesort 64610 ms 9638s ok 212 + explain 15776 ms 9638s ok 213 + compression 23332 ms 9638s ok 214 + memoize 20111 ms 9638s ok 215 + stats 49899 ms 9638s ok 216 + predicate 9787 ms 9643s # parallel group (2 tests): oidjoins event_trigger 9643s ok 217 + oidjoins 4373 ms 9644s ok 218 + event_trigger 4891 ms 9646s ok 219 - event_trigger_login 2679 ms 9650s ok 220 - fast_default 3535 ms 9657s ok 221 - tablespace 7314 ms 9657s 1..221 9657s # All 221 tests passed. 9658s Dropping cluster 17/regress ... 9664s + rm -rf /tmp/regress.hW3T6H 9666s autopkgtest [02:05:15]: test installcheck: -----------------------] 9670s installcheck PASS 9670s autopkgtest [02:05:19]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 9674s autopkgtest [02:05:23]: @@@@@@@@@@@@@@@@@@@@ summary 9674s run-testsuite PASS 9674s installcheck PASS 9698s nova [W] Using flock in prodstack6-riscv64 9698s Creating nova instance adt-questing-riscv64-postgresql-17-20250501-232409-juju-7f2275-prod-proposed-migration-environment-15-acf1c86e-87ca-41ee-8fa1-0100f0d970f8 from image adt/ubuntu-questing-riscv64-server-20250501.img (UUID 28434505-3236-402d-af35-96aea5d030b9)... 9698s nova [W] Timed out waiting for 7ec7cc9f-c77a-40f7-b37e-af45a7761900 to get deleted. 9698s nova [W] Using flock in prodstack6-riscv64 9698s Creating nova instance adt-questing-riscv64-postgresql-17-20250501-232409-juju-7f2275-prod-proposed-migration-environment-15-acf1c86e-87ca-41ee-8fa1-0100f0d970f8 from image adt/ubuntu-questing-riscv64-server-20250501.img (UUID 28434505-3236-402d-af35-96aea5d030b9)... 9698s nova [W] Timed out waiting for 75926325-1dd0-4e7e-9743-dc7a23404434 to get deleted.