0s autopkgtest [05:19:27]: starting date and time: 2024-11-15 05:19:27+0000 0s autopkgtest [05:19:27]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [05:19:27]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.s6vu2vmb/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade timescaledb --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.1-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-29.secgroup --name adt-plucky-ppc64el-timescaledb-20241115-051927-juju-7f2275-prod-proposed-migration-environment-20-391633d2-76e7-4ce8-9338-36e8a2c6dfc4 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 112s autopkgtest [05:21:19]: testbed dpkg architecture: ppc64el 112s autopkgtest [05:21:19]: testbed apt version: 2.9.8 112s autopkgtest [05:21:19]: @@@@@@@@@@@@@@@@@@@@ test bed setup 113s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 113s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [97.2 kB] 113s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 113s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1055 kB] 113s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [174 kB] 113s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [775 kB] 113s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [8632 B] 114s Fetched 2206 kB in 1s (2147 kB/s) 114s Reading package lists... 116s Reading package lists... 116s Building dependency tree... 116s Reading state information... 117s Calculating upgrade... 117s The following packages will be upgraded: 117s bpfcc-tools bpftrace firmware-sof-signed grub-common grub-ieee1275 117s grub-ieee1275-bin grub2-common libbpfcc libcap-ng0 libexpat1 libgnutls30t64 117s libjson-glib-1.0-0 libjson-glib-1.0-common libnewt0.52 libutempter0 117s lxd-installer man-db pastebinit python3-bpfcc python3-newt python3-systemd 117s whiptail xfsprogs 117s 23 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 117s Need to get 18.1 MB of archives. 117s After this operation, 1019 kB of additional disk space will be used. 117s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 118s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcap-ng0 ppc64el 0.8.5-3build1 [16.3 kB] 118s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgnutls30t64 ppc64el 3.8.8-2ubuntu1 [1072 kB] 118s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libexpat1 ppc64el 2.6.4-1 [98.1 kB] 118s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-newt ppc64el 0.52.24-2ubuntu4 [21.8 kB] 118s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libnewt0.52 ppc64el 0.52.24-2ubuntu4 [62.1 kB] 118s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el whiptail ppc64el 0.52.24-2ubuntu4 [19.5 kB] 118s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el man-db ppc64el 2.13.0-1 [1361 kB] 118s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el libbpfcc ppc64el 0.30.0+ds-1ubuntu5 [696 kB] 118s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-bpfcc all 0.30.0+ds-1ubuntu5 [40.4 kB] 118s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpfcc-tools all 0.30.0+ds-1ubuntu5 [697 kB] 118s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el bpftrace ppc64el 0.21.2-2ubuntu2 [1898 kB] 118s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el grub-ieee1275 ppc64el 2.12-5ubuntu7 [63.1 kB] 118s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el grub2-common ppc64el 2.12-5ubuntu7 [751 kB] 118s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el grub-ieee1275-bin ppc64el 2.12-5ubuntu7 [689 kB] 118s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el grub-common ppc64el 2.12-5ubuntu7 [2341 kB] 119s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-common all 1.10.0+ds-3 [5586 B] 119s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-glib-1.0-0 ppc64el 1.10.0+ds-3 [76.0 kB] 119s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el libutempter0 ppc64el 1.2.1-4 [9850 B] 119s Get:20 http://ftpmaster.internal/ubuntu plucky/main ppc64el lxd-installer all 9 [5084 B] 119s Get:21 http://ftpmaster.internal/ubuntu plucky/main ppc64el pastebinit all 1.7.1-1 [14.9 kB] 119s Get:22 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-systemd ppc64el 235-1build5 [48.7 kB] 119s Get:23 http://ftpmaster.internal/ubuntu plucky/main ppc64el xfsprogs ppc64el 6.8.0-2.2ubuntu2 [995 kB] 119s Preconfiguring packages ... 119s Fetched 18.1 MB in 2s (9525 kB/s) 120s (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 ... 73767 files and directories currently installed.) 120s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 120s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 120s Preparing to unpack .../libcap-ng0_0.8.5-3build1_ppc64el.deb ... 120s Unpacking libcap-ng0:ppc64el (0.8.5-3build1) over (0.8.5-1) ... 120s Setting up libcap-ng0:ppc64el (0.8.5-3build1) ... 120s (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 ... 73793 files and directories currently installed.) 120s Preparing to unpack .../libgnutls30t64_3.8.8-2ubuntu1_ppc64el.deb ... 120s Unpacking libgnutls30t64:ppc64el (3.8.8-2ubuntu1) over (3.8.6-2ubuntu1) ... 120s Setting up libgnutls30t64:ppc64el (3.8.8-2ubuntu1) ... 120s (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 ... 73793 files and directories currently installed.) 120s Preparing to unpack .../00-libexpat1_2.6.4-1_ppc64el.deb ... 120s Unpacking libexpat1:ppc64el (2.6.4-1) over (2.6.2-2) ... 120s Preparing to unpack .../01-python3-newt_0.52.24-2ubuntu4_ppc64el.deb ... 120s Unpacking python3-newt:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 120s Preparing to unpack .../02-libnewt0.52_0.52.24-2ubuntu4_ppc64el.deb ... 120s Unpacking libnewt0.52:ppc64el (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 120s Preparing to unpack .../03-whiptail_0.52.24-2ubuntu4_ppc64el.deb ... 120s Unpacking whiptail (0.52.24-2ubuntu4) over (0.52.24-2ubuntu3) ... 120s Preparing to unpack .../04-man-db_2.13.0-1_ppc64el.deb ... 120s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 121s Preparing to unpack .../05-libbpfcc_0.30.0+ds-1ubuntu5_ppc64el.deb ... 121s Unpacking libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 121s Preparing to unpack .../06-python3-bpfcc_0.30.0+ds-1ubuntu5_all.deb ... 121s Unpacking python3-bpfcc (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 121s Preparing to unpack .../07-bpfcc-tools_0.30.0+ds-1ubuntu5_all.deb ... 121s Unpacking bpfcc-tools (0.30.0+ds-1ubuntu5) over (0.30.0+ds-1ubuntu4) ... 121s Preparing to unpack .../08-bpftrace_0.21.2-2ubuntu2_ppc64el.deb ... 121s Unpacking bpftrace (0.21.2-2ubuntu2) over (0.21.2-2) ... 121s Preparing to unpack .../09-grub-ieee1275_2.12-5ubuntu7_ppc64el.deb ... 121s Unpacking grub-ieee1275 (2.12-5ubuntu7) over (2.12-5ubuntu5.1) ... 121s Preparing to unpack .../10-grub2-common_2.12-5ubuntu7_ppc64el.deb ... 121s Unpacking grub2-common (2.12-5ubuntu7) over (2.12-5ubuntu5.1) ... 121s Preparing to unpack .../11-grub-ieee1275-bin_2.12-5ubuntu7_ppc64el.deb ... 121s Unpacking grub-ieee1275-bin (2.12-5ubuntu7) over (2.12-5ubuntu5.1) ... 121s Preparing to unpack .../12-grub-common_2.12-5ubuntu7_ppc64el.deb ... 121s Unpacking grub-common (2.12-5ubuntu7) over (2.12-5ubuntu5.1) ... 122s Preparing to unpack .../13-libjson-glib-1.0-common_1.10.0+ds-3_all.deb ... 122s Unpacking libjson-glib-1.0-common (1.10.0+ds-3) over (1.10.0+ds-2) ... 122s Preparing to unpack .../14-libjson-glib-1.0-0_1.10.0+ds-3_ppc64el.deb ... 122s Unpacking libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) over (1.10.0+ds-2) ... 122s Preparing to unpack .../15-libutempter0_1.2.1-4_ppc64el.deb ... 122s Unpacking libutempter0:ppc64el (1.2.1-4) over (1.2.1-3build1) ... 122s Preparing to unpack .../16-lxd-installer_9_all.deb ... 122s Unpacking lxd-installer (9) over (8) ... 122s Preparing to unpack .../17-pastebinit_1.7.1-1_all.deb ... 122s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 122s Preparing to unpack .../18-python3-systemd_235-1build5_ppc64el.deb ... 122s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 122s Preparing to unpack .../19-xfsprogs_6.8.0-2.2ubuntu2_ppc64el.deb ... 122s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 122s Setting up libexpat1:ppc64el (2.6.4-1) ... 122s Setting up libnewt0.52:ppc64el (0.52.24-2ubuntu4) ... 122s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 122s Setting up pastebinit (1.7.1-1) ... 122s Setting up python3-newt:ppc64el (0.52.24-2ubuntu4) ... 122s Setting up man-db (2.13.0-1) ... 122s Updating database of manual pages ... 126s man-db.service is a disabled or a static unit not running, not starting it. 126s Setting up grub-common (2.12-5ubuntu7) ... 126s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 126s update-initramfs: deferring update (trigger activated) 127s Setting up lxd-installer (9) ... 127s Setting up libutempter0:ppc64el (1.2.1-4) ... 127s Setting up whiptail (0.52.24-2ubuntu4) ... 127s Setting up libjson-glib-1.0-common (1.10.0+ds-3) ... 127s Setting up libbpfcc:ppc64el (0.30.0+ds-1ubuntu5) ... 127s Setting up python3-bpfcc (0.30.0+ds-1ubuntu5) ... 128s Setting up python3-systemd (235-1build5) ... 128s Setting up bpftrace (0.21.2-2ubuntu2) ... 128s Setting up grub2-common (2.12-5ubuntu7) ... 128s Setting up grub-ieee1275-bin (2.12-5ubuntu7) ... 128s Setting up libjson-glib-1.0-0:ppc64el (1.10.0+ds-3) ... 128s Setting up bpfcc-tools (0.30.0+ds-1ubuntu5) ... 128s Setting up grub-ieee1275 (2.12-5ubuntu7) ... 128s Installing for powerpc-ieee1275 platform. 128s Installation finished. No error reported. 128s Sourcing file `/etc/default/grub' 128s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 128s Generating grub configuration file ... 129s Found linux image: /boot/vmlinux-6.11.0-8-generic 129s Found initrd image: /boot/initrd.img-6.11.0-8-generic 129s Warning: os-prober will not be executed to detect other bootable partitions. 129s Systems on them will not be added to the GRUB boot configuration. 129s Check GRUB_DISABLE_OS_PROBER documentation entry. 129s Adding boot menu entry for UEFI Firmware Settings ... 129s done 129s Processing triggers for install-info (7.1.1-1) ... 129s Processing triggers for libc-bin (2.40-1ubuntu3) ... 129s Processing triggers for initramfs-tools (0.142ubuntu34) ... 129s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 129s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 138s Reading package lists... 138s Building dependency tree... 138s Reading state information... 138s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 139s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 139s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 139s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 139s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 140s Reading package lists... 140s Reading package lists... 140s Building dependency tree... 140s Reading state information... 140s Calculating upgrade... 141s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 141s Reading package lists... 141s Building dependency tree... 141s Reading state information... 141s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 141s autopkgtest [05:21:48]: rebooting testbed after setup commands that affected boot 145s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 178s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 184s autopkgtest [05:22:31]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 13:49:23 UTC 2024 186s autopkgtest [05:22:33]: @@@@@@@@@@@@@@@@@@@@ apt-source timescaledb 189s Get:1 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (dsc) [2271 B] 189s Get:2 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (tar) [1298 kB] 189s Get:3 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (diff) [4040 B] 189s gpgv: Signature made Thu Nov 7 12:39:30 2024 UTC 189s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 189s gpgv: Can't check signature: No public key 189s dpkg-source: warning: cannot verify inline signature for ./timescaledb_2.17.2+dfsg-1.dsc: no acceptable signature found 189s autopkgtest [05:22:36]: testing package timescaledb version 2.17.2+dfsg-1 189s autopkgtest [05:22:36]: build not needed 190s autopkgtest [05:22:37]: test installcheck: preparing testbed 194s Reading package lists... 194s Building dependency tree... 194s Reading state information... 194s Starting pkgProblemResolver with broken count: 0 195s Starting 2 pkgProblemResolver with broken count: 0 195s Done 195s The following additional packages will be installed: 195s build-essential clang-19 cmake cmake-data cpp cpp-14 195s cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu g++ g++-14 195s g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-14 195s gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu icu-devtools libasan8 195s libcc1-0 libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 195s libgcc-14-dev libgomp1 libicu-dev libio-pty-perl libipc-run-perl libisl23 195s libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 195s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 195s librhash0 libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev 195s libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime 195s llvm-19-tools postgresql-17 postgresql-17-timescaledb postgresql-client-16 195s postgresql-client-17 postgresql-client-common postgresql-common 195s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 195s zlib1g-dev 195s Suggested packages: 195s clang-19-doc wasi-libc cmake-doc cmake-format elpa-cmake-mode ninja-build 195s cpp-doc gcc-14-locales cpp-14-doc gcc-14-doc gcc-multilib manpages-dev 195s autoconf automake libtool flex bison gdb gcc-doc gdb-powerpc64le-linux-gnu 195s icu-doc liblzma-doc ncurses-doc postgresql-doc-17 libssl-doc 195s libstdc++-14-doc pkgconf llvm-19-doc postgresql-16 postgresql-doc-16 195s Recommended packages: 195s libclang-rt-19-dev libjson-xs-perl 195s The following NEW packages will be installed: 195s autopkgtest-satdep build-essential clang-19 cmake cmake-data cpp cpp-14 195s cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu g++ g++-14 195s g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-14 195s gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu icu-devtools libasan8 195s libcc1-0 libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 195s libgcc-14-dev libgomp1 libicu-dev libio-pty-perl libipc-run-perl libisl23 195s libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 195s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 195s librhash0 libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev 195s libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime 195s llvm-19-tools postgresql-17 postgresql-17-timescaledb postgresql-client-16 195s postgresql-client-17 postgresql-client-common postgresql-common 195s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 195s zlib1g-dev 195s 0 upgraded, 66 newly installed, 0 to remove and 0 not upgraded. 195s Need to get 196 MB/196 MB of archives. 195s After this operation, 976 MB of additional disk space will be used. 195s Get:1 /tmp/autopkgtest.TJBJPZ/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [776 B] 195s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 195s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 262 [36.7 kB] 195s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.2ubuntu2 [18.0 kB] 195s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 262 [162 kB] 196s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 196s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 196s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-8ubuntu1 [10.5 MB] 196s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14 ppc64el 14.2.0-8ubuntu1 [1034 B] 196s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [5456 B] 196s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp ppc64el 4:14.1.0-2ubuntu1 [22.5 kB] 196s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcc1-0 ppc64el 14.2.0-8ubuntu1 [48.1 kB] 196s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgomp1 ppc64el 14.2.0-8ubuntu1 [161 kB] 196s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el libitm1 ppc64el 14.2.0-8ubuntu1 [31.9 kB] 196s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el libasan8 ppc64el 14.2.0-8ubuntu1 [2945 kB] 196s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el liblsan0 ppc64el 14.2.0-8ubuntu1 [1322 kB] 196s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtsan2 ppc64el 14.2.0-8ubuntu1 [2695 kB] 196s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el libubsan1 ppc64el 14.2.0-8ubuntu1 [1191 kB] 196s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el libquadmath0 ppc64el 14.2.0-8ubuntu1 [158 kB] 196s Get:20 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgcc-14-dev ppc64el 14.2.0-8ubuntu1 [1619 kB] 196s Get:21 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-8ubuntu1 [20.6 MB] 197s Get:22 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14 ppc64el 14.2.0-8ubuntu1 [528 kB] 197s Get:23 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [1222 B] 197s Get:24 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc ppc64el 4:14.1.0-2ubuntu1 [5006 B] 197s Get:25 http://ftpmaster.internal/ubuntu plucky/main ppc64el libstdc++-14-dev ppc64el 14.2.0-8ubuntu1 [2673 kB] 197s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-8ubuntu1 [12.0 MB] 197s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14 ppc64el 14.2.0-8ubuntu1 [19.9 kB] 197s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [968 B] 197s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++ ppc64el 4:14.1.0-2ubuntu1 [1090 B] 197s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el build-essential ppc64el 12.10ubuntu1 [4936 B] 197s Get:31 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-cpp19 ppc64el 1:19.1.2-1ubuntu1 [15.2 MB] 198s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 198s Get:33 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc4 ppc64el 14.2.0-8ubuntu1 [52.7 kB] 198s Get:34 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc-14-dev ppc64el 14.2.0-8ubuntu1 [202 kB] 198s Get:35 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-common-19-dev ppc64el 1:19.1.2-1ubuntu1 [743 kB] 198s Get:36 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-linker-tools ppc64el 1:19.1.2-1ubuntu1 [1373 kB] 198s Get:37 http://ftpmaster.internal/ubuntu plucky/universe ppc64el clang-19 ppc64el 1:19.1.2-1ubuntu1 [82.3 kB] 198s Get:38 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjsoncpp25 ppc64el 1.9.5-6build1 [89.0 kB] 198s Get:39 http://ftpmaster.internal/ubuntu plucky/main ppc64el librhash0 ppc64el 1.4.3-3build1 [147 kB] 198s Get:40 http://ftpmaster.internal/ubuntu plucky/main ppc64el cmake-data all 3.30.3-1 [2246 kB] 198s Get:41 http://ftpmaster.internal/ubuntu plucky/main ppc64el cmake ppc64el 3.30.3-1 [12.1 MB] 199s Get:42 http://ftpmaster.internal/ubuntu plucky/main ppc64el icu-devtools ppc64el 74.2-1ubuntu4 [248 kB] 199s Get:43 http://ftpmaster.internal/ubuntu plucky/main ppc64el libicu-dev ppc64el 74.2-1ubuntu4 [12.5 MB] 199s Get:44 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 199s Get:45 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 199s Get:46 http://ftpmaster.internal/ubuntu plucky/main ppc64el libncurses-dev ppc64el 6.5-2 [480 kB] 199s Get:47 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.1-1 [172 kB] 199s Get:48 http://ftpmaster.internal/ubuntu plucky/main ppc64el libssl-dev ppc64el 3.3.1-2ubuntu2 [2985 kB] 199s Get:49 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq-dev ppc64el 17.1-1 [177 kB] 199s Get:50 http://ftpmaster.internal/ubuntu plucky/main ppc64el liblzma-dev ppc64el 5.6.2-2 [206 kB] 199s Get:51 http://ftpmaster.internal/ubuntu plucky/main ppc64el zlib1g-dev ppc64el 1:1.3.dfsg+really1.3.1-1ubuntu1 [902 kB] 199s Get:52 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg-3 [73.1 kB] 199s Get:53 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu1 [191 kB] 199s Get:54 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-runtime ppc64el 1:19.1.2-1ubuntu1 [589 kB] 199s Get:55 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 199s Get:56 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19 ppc64el 1:19.1.2-1ubuntu1 [19.5 MB] 200s Get:57 http://ftpmaster.internal/ubuntu plucky/main ppc64el libffi-dev ppc64el 3.4.6-1build1 [67.5 kB] 200s Get:58 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-tools ppc64el 1:19.1.2-1ubuntu1 [618 kB] 200s Get:59 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-dev ppc64el 1:19.1.2-1ubuntu1 [45.4 MB] 201s Get:60 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.1-1 [1464 kB] 201s Get:61 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.1-1 [17.1 MB] 202s Get:62 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-timescaledb ppc64el 2.17.2+dfsg-1 [340 kB] 202s Get:63 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-16 ppc64el 16.4-3 [1400 kB] 202s Get:64 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-16 ppc64el 16.4-3 [1263 kB] 202s Get:65 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-all ppc64el 262 [20.7 kB] 202s Get:66 http://ftpmaster.internal/ubuntu plucky/main ppc64el tzdata-legacy all 2024b-1ubuntu2 [99.9 kB] 203s Preconfiguring packages ... 203s Fetched 196 MB in 7s (27.9 MB/s) 203s Selecting previously unselected package libjson-perl. 203s (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 ... 73801 files and directories currently installed.) 203s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 203s Unpacking libjson-perl (4.10000-1) ... 203s Selecting previously unselected package postgresql-client-common. 203s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 203s Unpacking postgresql-client-common (262) ... 203s Selecting previously unselected package ssl-cert. 203s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 203s Unpacking ssl-cert (1.1.2ubuntu2) ... 203s Selecting previously unselected package postgresql-common. 203s Preparing to unpack .../03-postgresql-common_262_all.deb ... 203s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 203s Unpacking postgresql-common (262) ... 203s Selecting previously unselected package libisl23:ppc64el. 203s Preparing to unpack .../04-libisl23_0.27-1_ppc64el.deb ... 203s Unpacking libisl23:ppc64el (0.27-1) ... 203s Selecting previously unselected package libmpc3:ppc64el. 203s Preparing to unpack .../05-libmpc3_1.3.1-1build2_ppc64el.deb ... 203s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 203s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 203s Preparing to unpack .../06-cpp-14-powerpc64le-linux-gnu_14.2.0-8ubuntu1_ppc64el.deb ... 203s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 203s Selecting previously unselected package cpp-14. 203s Preparing to unpack .../07-cpp-14_14.2.0-8ubuntu1_ppc64el.deb ... 203s Unpacking cpp-14 (14.2.0-8ubuntu1) ... 203s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 203s Preparing to unpack .../08-cpp-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 203s Unpacking cpp-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 203s Selecting previously unselected package cpp. 203s Preparing to unpack .../09-cpp_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 203s Unpacking cpp (4:14.1.0-2ubuntu1) ... 203s Selecting previously unselected package libcc1-0:ppc64el. 203s Preparing to unpack .../10-libcc1-0_14.2.0-8ubuntu1_ppc64el.deb ... 203s Unpacking libcc1-0:ppc64el (14.2.0-8ubuntu1) ... 203s Selecting previously unselected package libgomp1:ppc64el. 204s Preparing to unpack .../11-libgomp1_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libgomp1:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libitm1:ppc64el. 204s Preparing to unpack .../12-libitm1_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libitm1:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libasan8:ppc64el. 204s Preparing to unpack .../13-libasan8_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libasan8:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package liblsan0:ppc64el. 204s Preparing to unpack .../14-liblsan0_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking liblsan0:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libtsan2:ppc64el. 204s Preparing to unpack .../15-libtsan2_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libtsan2:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libubsan1:ppc64el. 204s Preparing to unpack .../16-libubsan1_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libubsan1:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libquadmath0:ppc64el. 204s Preparing to unpack .../17-libquadmath0_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libquadmath0:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package libgcc-14-dev:ppc64el. 204s Preparing to unpack .../18-libgcc-14-dev_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libgcc-14-dev:ppc64el (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 204s Preparing to unpack .../19-gcc-14-powerpc64le-linux-gnu_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package gcc-14. 204s Preparing to unpack .../20-gcc-14_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking gcc-14 (14.2.0-8ubuntu1) ... 204s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 204s Preparing to unpack .../21-gcc-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 204s Unpacking gcc-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package gcc. 204s Preparing to unpack .../22-gcc_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 204s Unpacking gcc (4:14.1.0-2ubuntu1) ... 204s Selecting previously unselected package libstdc++-14-dev:ppc64el. 204s Preparing to unpack .../23-libstdc++-14-dev_14.2.0-8ubuntu1_ppc64el.deb ... 204s Unpacking libstdc++-14-dev:ppc64el (14.2.0-8ubuntu1) ... 205s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 205s Preparing to unpack .../24-g++-14-powerpc64le-linux-gnu_14.2.0-8ubuntu1_ppc64el.deb ... 205s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 205s Selecting previously unselected package g++-14. 205s Preparing to unpack .../25-g++-14_14.2.0-8ubuntu1_ppc64el.deb ... 205s Unpacking g++-14 (14.2.0-8ubuntu1) ... 205s Selecting previously unselected package g++-powerpc64le-linux-gnu. 205s Preparing to unpack .../26-g++-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 205s Unpacking g++-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 205s Selecting previously unselected package g++. 205s Preparing to unpack .../27-g++_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 205s Unpacking g++ (4:14.1.0-2ubuntu1) ... 205s Selecting previously unselected package build-essential. 205s Preparing to unpack .../28-build-essential_12.10ubuntu1_ppc64el.deb ... 205s Unpacking build-essential (12.10ubuntu1) ... 205s Selecting previously unselected package libclang-cpp19. 205s Preparing to unpack .../29-libclang-cpp19_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 205s Unpacking libclang-cpp19 (1:19.1.2-1ubuntu1) ... 205s Selecting previously unselected package libgc1:ppc64el. 205s Preparing to unpack .../30-libgc1_1%3a8.2.8-1_ppc64el.deb ... 205s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 205s Selecting previously unselected package libobjc4:ppc64el. 205s Preparing to unpack .../31-libobjc4_14.2.0-8ubuntu1_ppc64el.deb ... 205s Unpacking libobjc4:ppc64el (14.2.0-8ubuntu1) ... 206s Selecting previously unselected package libobjc-14-dev:ppc64el. 206s Preparing to unpack .../32-libobjc-14-dev_14.2.0-8ubuntu1_ppc64el.deb ... 206s Unpacking libobjc-14-dev:ppc64el (14.2.0-8ubuntu1) ... 206s Selecting previously unselected package libclang-common-19-dev:ppc64el. 206s Preparing to unpack .../33-libclang-common-19-dev_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 206s Unpacking libclang-common-19-dev:ppc64el (1:19.1.2-1ubuntu1) ... 206s Selecting previously unselected package llvm-19-linker-tools. 206s Preparing to unpack .../34-llvm-19-linker-tools_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 206s Unpacking llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 206s Selecting previously unselected package clang-19. 206s Preparing to unpack .../35-clang-19_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 206s Unpacking clang-19 (1:19.1.2-1ubuntu1) ... 206s Selecting previously unselected package libjsoncpp25:ppc64el. 206s Preparing to unpack .../36-libjsoncpp25_1.9.5-6build1_ppc64el.deb ... 206s Unpacking libjsoncpp25:ppc64el (1.9.5-6build1) ... 206s Selecting previously unselected package librhash0:ppc64el. 206s Preparing to unpack .../37-librhash0_1.4.3-3build1_ppc64el.deb ... 206s Unpacking librhash0:ppc64el (1.4.3-3build1) ... 206s Selecting previously unselected package cmake-data. 206s Preparing to unpack .../38-cmake-data_3.30.3-1_all.deb ... 206s Unpacking cmake-data (3.30.3-1) ... 206s Selecting previously unselected package cmake. 206s Preparing to unpack .../39-cmake_3.30.3-1_ppc64el.deb ... 206s Unpacking cmake (3.30.3-1) ... 207s Selecting previously unselected package icu-devtools. 207s Preparing to unpack .../40-icu-devtools_74.2-1ubuntu4_ppc64el.deb ... 207s Unpacking icu-devtools (74.2-1ubuntu4) ... 207s Selecting previously unselected package libicu-dev:ppc64el. 207s Preparing to unpack .../41-libicu-dev_74.2-1ubuntu4_ppc64el.deb ... 207s Unpacking libicu-dev:ppc64el (74.2-1ubuntu4) ... 207s Selecting previously unselected package libio-pty-perl. 207s Preparing to unpack .../42-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 207s Unpacking libio-pty-perl (1:1.20-1build3) ... 207s Selecting previously unselected package libipc-run-perl. 207s Preparing to unpack .../43-libipc-run-perl_20231003.0-2_all.deb ... 207s Unpacking libipc-run-perl (20231003.0-2) ... 207s Selecting previously unselected package libncurses-dev:ppc64el. 207s Preparing to unpack .../44-libncurses-dev_6.5-2_ppc64el.deb ... 207s Unpacking libncurses-dev:ppc64el (6.5-2) ... 207s Selecting previously unselected package libpq5:ppc64el. 207s Preparing to unpack .../45-libpq5_17.1-1_ppc64el.deb ... 207s Unpacking libpq5:ppc64el (17.1-1) ... 207s Selecting previously unselected package libssl-dev:ppc64el. 207s Preparing to unpack .../46-libssl-dev_3.3.1-2ubuntu2_ppc64el.deb ... 207s Unpacking libssl-dev:ppc64el (3.3.1-2ubuntu2) ... 207s Selecting previously unselected package libpq-dev. 207s Preparing to unpack .../47-libpq-dev_17.1-1_ppc64el.deb ... 207s Unpacking libpq-dev (17.1-1) ... 208s Selecting previously unselected package liblzma-dev:ppc64el. 208s Preparing to unpack .../48-liblzma-dev_5.6.2-2_ppc64el.deb ... 208s Unpacking liblzma-dev:ppc64el (5.6.2-2) ... 208s Selecting previously unselected package zlib1g-dev:ppc64el. 208s Preparing to unpack .../49-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_ppc64el.deb ... 208s Unpacking zlib1g-dev:ppc64el (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 208s Selecting previously unselected package libxml2-dev:ppc64el. 208s Preparing to unpack .../50-libxml2-dev_2.12.7+dfsg-3_ppc64el.deb ... 208s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg-3) ... 208s Selecting previously unselected package libxslt1.1:ppc64el. 208s Preparing to unpack .../51-libxslt1.1_1.1.39-0exp1ubuntu1_ppc64el.deb ... 208s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 208s Selecting previously unselected package llvm-19-runtime. 208s Preparing to unpack .../52-llvm-19-runtime_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 208s Unpacking llvm-19-runtime (1:19.1.2-1ubuntu1) ... 208s Selecting previously unselected package libpfm4:ppc64el. 208s Preparing to unpack .../53-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 208s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 208s Selecting previously unselected package llvm-19. 208s Preparing to unpack .../54-llvm-19_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 208s Unpacking llvm-19 (1:19.1.2-1ubuntu1) ... 208s Selecting previously unselected package libffi-dev:ppc64el. 208s Preparing to unpack .../55-libffi-dev_3.4.6-1build1_ppc64el.deb ... 208s Unpacking libffi-dev:ppc64el (3.4.6-1build1) ... 208s Selecting previously unselected package llvm-19-tools. 208s Preparing to unpack .../56-llvm-19-tools_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 208s Unpacking llvm-19-tools (1:19.1.2-1ubuntu1) ... 208s Selecting previously unselected package llvm-19-dev. 208s Preparing to unpack .../57-llvm-19-dev_1%3a19.1.2-1ubuntu1_ppc64el.deb ... 208s Unpacking llvm-19-dev (1:19.1.2-1ubuntu1) ... 211s Selecting previously unselected package postgresql-client-17. 211s Preparing to unpack .../58-postgresql-client-17_17.1-1_ppc64el.deb ... 211s Unpacking postgresql-client-17 (17.1-1) ... 211s Selecting previously unselected package postgresql-17. 211s Preparing to unpack .../59-postgresql-17_17.1-1_ppc64el.deb ... 211s Unpacking postgresql-17 (17.1-1) ... 211s Selecting previously unselected package postgresql-17-timescaledb. 211s Preparing to unpack .../60-postgresql-17-timescaledb_2.17.2+dfsg-1_ppc64el.deb ... 211s Unpacking postgresql-17-timescaledb (2.17.2+dfsg-1) ... 211s Selecting previously unselected package postgresql-client-16. 211s Preparing to unpack .../61-postgresql-client-16_16.4-3_ppc64el.deb ... 211s Unpacking postgresql-client-16 (16.4-3) ... 211s Selecting previously unselected package postgresql-server-dev-16. 211s Preparing to unpack .../62-postgresql-server-dev-16_16.4-3_ppc64el.deb ... 211s Unpacking postgresql-server-dev-16 (16.4-3) ... 211s Selecting previously unselected package postgresql-server-dev-all:ppc64el. 211s Preparing to unpack .../63-postgresql-server-dev-all_262_ppc64el.deb ... 211s Unpacking postgresql-server-dev-all:ppc64el (262) ... 211s Selecting previously unselected package tzdata-legacy. 211s Preparing to unpack .../64-tzdata-legacy_2024b-1ubuntu2_all.deb ... 211s Unpacking tzdata-legacy (2024b-1ubuntu2) ... 212s Selecting previously unselected package autopkgtest-satdep. 212s Preparing to unpack .../65-1-autopkgtest-satdep.deb ... 212s Unpacking autopkgtest-satdep (0) ... 212s Setting up postgresql-client-common (262) ... 212s Setting up libncurses-dev:ppc64el (6.5-2) ... 212s Setting up libio-pty-perl (1:1.20-1build3) ... 212s Setting up libclang-common-19-dev:ppc64el (1:19.1.2-1ubuntu1) ... 212s Setting up libpq5:ppc64el (17.1-1) ... 212s Setting up libgomp1:ppc64el (14.2.0-8ubuntu1) ... 212s Setting up libffi-dev:ppc64el (3.4.6-1build1) ... 212s Setting up tzdata-legacy (2024b-1ubuntu2) ... 212s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 212s Setting up ssl-cert (1.1.2ubuntu2) ... 212s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 213s Setting up libquadmath0:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up libssl-dev:ppc64el (3.3.1-2ubuntu2) ... 213s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 213s Setting up libjsoncpp25:ppc64el (1.9.5-6build1) ... 213s Setting up icu-devtools (74.2-1ubuntu4) ... 213s Setting up libipc-run-perl (20231003.0-2) ... 213s Setting up libgc1:ppc64el (1:8.2.8-1) ... 213s Setting up liblzma-dev:ppc64el (5.6.2-2) ... 213s Setting up libubsan1:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up zlib1g-dev:ppc64el (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 213s Setting up librhash0:ppc64el (1.4.3-3build1) ... 213s Setting up libasan8:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up libjson-perl (4.10000-1) ... 213s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu1) ... 213s Setting up cmake-data (3.30.3-1) ... 213s Setting up llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 213s Setting up libtsan2:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up libisl23:ppc64el (0.27-1) ... 213s Setting up llvm-19-runtime (1:19.1.2-1ubuntu1) ... 213s Setting up llvm-19-tools (1:19.1.2-1ubuntu1) ... 213s Setting up libicu-dev:ppc64el (74.2-1ubuntu4) ... 213s Setting up libcc1-0:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up liblsan0:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up libitm1:ppc64el (14.2.0-8ubuntu1) ... 213s Setting up libclang-cpp19 (1:19.1.2-1ubuntu1) ... 213s Setting up postgresql-client-17 (17.1-1) ... 213s 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 213s Setting up postgresql-client-16 (16.4-3) ... 214s Setting up libpq-dev (17.1-1) ... 214s Setting up libobjc4:ppc64el (14.2.0-8ubuntu1) ... 214s Setting up libxml2-dev:ppc64el (2.12.7+dfsg-3) ... 214s Setting up postgresql-common (262) ... 214s 214s Creating config file /etc/postgresql-common/createcluster.conf with new version 214s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 214s Removing obsolete dictionary files: 215s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 216s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 216s Setting up cpp-14 (14.2.0-8ubuntu1) ... 216s Setting up cmake (3.30.3-1) ... 216s Setting up llvm-19 (1:19.1.2-1ubuntu1) ... 216s Setting up libgcc-14-dev:ppc64el (14.2.0-8ubuntu1) ... 216s Setting up libstdc++-14-dev:ppc64el (14.2.0-8ubuntu1) ... 216s Setting up cpp-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 216s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 216s Setting up postgresql-17 (17.1-1) ... 216s Creating new PostgreSQL cluster 17/main ... 216s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 216s The files belonging to this database system will be owned by user "postgres". 216s This user must also own the server process. 216s 216s The database cluster will be initialized with locale "C.UTF-8". 216s The default database encoding has accordingly been set to "UTF8". 216s The default text search configuration will be set to "english". 216s 216s Data page checksums are disabled. 216s 216s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 216s creating subdirectories ... ok 216s selecting dynamic shared memory implementation ... posix 216s selecting default "max_connections" ... 100 216s selecting default "shared_buffers" ... 128MB 216s selecting default time zone ... Etc/UTC 216s creating configuration files ... ok 216s running bootstrap script ... ok 217s performing post-bootstrap initialization ... ok 217s syncing data to disk ... ok 221s Setting up postgresql-17-timescaledb (2.17.2+dfsg-1) ... 221s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-8ubuntu1) ... 221s Setting up libobjc-14-dev:ppc64el (14.2.0-8ubuntu1) ... 221s Setting up clang-19 (1:19.1.2-1ubuntu1) ... 221s Setting up gcc-14 (14.2.0-8ubuntu1) ... 221s Setting up gcc-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 221s Setting up llvm-19-dev (1:19.1.2-1ubuntu1) ... 221s Setting up postgresql-server-dev-16 (16.4-3) ... 221s Setting up cpp (4:14.1.0-2ubuntu1) ... 221s Setting up g++-14 (14.2.0-8ubuntu1) ... 221s Setting up postgresql-server-dev-all:ppc64el (262) ... 221s Setting up g++-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 221s Setting up gcc (4:14.1.0-2ubuntu1) ... 221s Setting up g++ (4:14.1.0-2ubuntu1) ... 221s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 221s Setting up build-essential (12.10ubuntu1) ... 221s Setting up autopkgtest-satdep (0) ... 221s Processing triggers for systemd (256.5-2ubuntu4) ... 221s Processing triggers for man-db (2.13.0-1) ... 224s Processing triggers for install-info (7.1.1-1) ... 224s Processing triggers for libc-bin (2.40-1ubuntu3) ... 227s (Reading database ... 86767 files and directories currently installed.) 227s Removing autopkgtest-satdep (0) ... 227s autopkgtest [05:23:14]: test installcheck: [----------------------- 228s + id -u 228s + [ 1000 = 0 ] 228s + EXIT=0 228s + pg_buildext installed-versions 228s ### PostgreSQL 17 ### 228s + echo ### PostgreSQL 17 ### 228s + rm -rf test-17 228s + mkdir test-17 228s + cmake -B test-17 -DPG_CONFIG=/usr/lib/postgresql/17/bin/pg_config -DAPACHE_ONLY=1 228s -- The C compiler identification is GNU 14.2.0 228s -- Detecting C compiler ABI info 228s -- Detecting C compiler ABI info - done 228s -- Check for working C compiler: /usr/bin/cc - skipped 228s -- Detecting C compile features 228s -- Detecting C compile features - done 228s -- TimescaleDB version 2.17.2. Can be updated from version 2.17.1 228s -- Build type is Release 228s -- Install method is 'source' 228s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG 228s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG - Success 228s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION 228s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION - Success 228s -- Performing Test CC_STRINGOP_TRUNCATION 228s -- Performing Test CC_STRINGOP_TRUNCATION - Success 228s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH 228s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH - Success 228s -- Performing Test CC_SUPPORTS_NEWLINE_EOF 228s -- Performing Test CC_SUPPORTS_NEWLINE_EOF - Failed 228s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN 229s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success 229s -- Using compiler GNU 229s -- Could NOT find Git (missing: GIT_EXECUTABLE) 229s -- Compiling against PostgreSQL version 17.1 using pg_config '/usr/lib/postgresql/17/bin/pg_config' 229s -- Assertion checks are OFF 229s -- Looking for USE_OPENSSL 229s -- Looking for USE_OPENSSL - found 229s -- Found Perl: /usr/bin/perl (found suitable version "5.40.0", minimum required is "5.8") 229s -- Using nm /usr/bin/nm 229s -- Not generating downgrade script: downgrade generation disabled. 229s -- Using pg_regress /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress 229s -- Using pg_isolation_regress /usr/lib/postgresql/17/lib/pgxs/src/test/isolation/pg_isolation_regress 229s -- Configuring done (1.2s) 229s -- Generating done (0.1s) 229s -- Build files have been written to: /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17 229s + make -C test-17/ installcheck PSQL=/usr/lib/postgresql/17/bin/psql 229s make: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[1]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[2]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[3]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[3]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[3]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s SKIPS: 229s No TAP tests to run for the current configuration, skipping... 229s make[3]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s Built target provecheck 229s make[3]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[3]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s make[3]: Entering directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 229s TESTS 229s SKIPS 229s # initializing database system by running initdb 230s # using temp instance on port 55432 with PID 5037 231s ok 1 - alter 619 ms 231s ok 2 - alternate_users 483 ms 232s ok 3 - chunk_utils 949 ms 233s ok 4 - index 769 ms 234s ok 5 - tablespace 519 ms 249s # parallel group (21 tests): catalog_corruption chunks cursor delete baserel_cache ddl_errors copy_where custom_type create_table cluster-17 ddl_extra create_chunks drop_extension ddl debug_utils constraint create_hypertable agg_bookends-17 copy chunk_adaptive append-17 249s ok 6 + agg_bookends-17 6172 ms 249s ok 7 + append-17 15760 ms 249s ok 8 + baserel_cache 5011 ms 249s ok 9 + catalog_corruption 4804 ms 249s ok 10 + chunk_adaptive 9199 ms 249s ok 11 + chunks 4999 ms 249s ok 12 + cluster-17 5058 ms 249s ok 13 + constraint 5990 ms 249s ok 14 + copy 7780 ms 249s ok 15 + copy_where 5013 ms 249s ok 16 + create_chunks 5094 ms 249s ok 17 + create_hypertable 6063 ms 249s ok 18 + create_table 5032 ms 249s ok 19 + cursor 4973 ms 249s ok 20 + custom_type 5030 ms 249s ok 21 + ddl 5610 ms 249s ok 22 + ddl_errors 4993 ms 249s ok 23 + ddl_extra 5038 ms 249s ok 24 + debug_utils 5847 ms 249s ok 25 + delete 4963 ms 249s ok 26 + drop_extension 5512 ms 263s # parallel group (21 tests): drop_hypertable license null_exclusion-17 hash generated_as_identity dump_meta drop_schema lateral histogram_test-17 insert_returning drop_rename_hypertable information_views grant_hypertable-17 partition drop_owned-17 insert_single merge extension_scripts insert_many insert-17 parallel-17 263s ok 27 + drop_hypertable 4321 ms 263s ok 28 + drop_owned-17 5018 ms 263s ok 29 + drop_rename_hypertable 4553 ms 263s ok 30 + drop_schema 4423 ms 263s ok 31 + dump_meta 4406 ms 263s ok 32 + extension_scripts 6185 ms 263s ok 33 + generated_as_identity 4364 ms 263s ok 34 + grant_hypertable-17 4591 ms 263s ok 35 + hash 4327 ms 263s ok 36 + histogram_test-17 4427 ms 263s ok 37 + information_views 4578 ms 263s ok 38 + insert-17 7493 ms 263s ok 39 + insert_many 6982 ms 263s ok 40 + insert_returning 4419 ms 263s ok 41 + insert_single 5169 ms 263s ok 42 + lateral 4411 ms 263s ok 43 + license 4302 ms 263s ok 44 + merge 5408 ms 263s ok 45 + null_exclusion-17 4305 ms 263s ok 46 + parallel-17 13505 ms 263s ok 47 + partition 4943 ms 278s # parallel group (21 tests): partitionwise-17 plain plan_hypertable_inline repair sql_query tableam tableam_alter timestamp-17 sort_optimization partitioning reloptions plan_expand_hypertable-17 triggers truncate query-17 relocate_extension plan_hashagg-17 plan_ordered_append-17 size_utils pg_join rowsecurity-17 278s # (test process exited with exit code 2) 278s not ok 48 + partitioning 9710 ms 278s not ok 49 + partitionwise-17 9705 ms 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s not ok 50 + pg_join 9780 ms 278s not ok 51 + plain 9705 ms 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s not ok 52 + plan_expand_hypertable-17 9745 ms 278s not ok 53 + plan_hashagg-17 9757 ms 278s not ok 54 + plan_hypertable_inline 9691 ms 278s not ok 55 + plan_ordered_append-17 9757 ms 278s not ok 56 + query-17 9752 ms 278s not ok 57 + relocate_extension 9751 ms 278s not ok 58 + reloptions 9695 ms 278s not ok 59 + repair 9683 ms 278s not ok 60 + rowsecurity-17 14784 ms 278s # (test process exited with exit code 2)not ok 61 + size_utils 9755 ms 278s 278s # (test process exited with exit code 2) 278s not ok 62 + sort_optimization 9683 ms 278s not ok 63 + sql_query 9682 ms 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s not ok 64 + tableam 9682 ms 278s not ok 65 + tableam_alter 9682 ms 278s not ok 66 + timestamp-17 9664 ms 278s # (test process exited with exit code 2) 278s # (test process exited with exit code 2) 278s not ok 67 + triggers 9707 ms 278s not ok 68 + truncate 9711 ms 278s # (test process exited with exit code 2) 278s # parallel group (8 tests): trusted_extension update util ts_merge-17 upsert vacuum vacuum_parallel version 278s # (test process exited with exit code 2) 278s not ok 69 + trusted_extension 63 ms 278s # (test process exited with exit code 2) 278s not ok 70 + ts_merge-17 85 ms 278s # (test process exited with exit code 2) 278s not ok 71 + update 74 ms 278s # (test process exited with exit code 2) 278s not ok 72 + upsert 86 ms 278s # (test process exited with exit code 2) 278s not ok 73 + util 83 ms 278s # (test process exited with exit code 2) 278s not ok 74 + vacuum 89 ms 278s # (test process exited with exit code 2) 278s not ok 75 + vacuum_parallel 85 ms 278s not ok 76 + version 86 ms 278s # (test process exited with exit code 2) 278s 1..76 278s # 29 of 76 tests failed. 278s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/regression.diffs". 278s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/regression.out". 278s make[3]: *** [test/CMakeFiles/regresscheck.dir/build.make:70: test/CMakeFiles/regresscheck] Error 1 278s make[3]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 278s make[2]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 278s make[2]: *** [CMakeFiles/Makefile2:571: test/CMakeFiles/regresscheck.dir/all] Error 2 278s make[1]: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 278s make[1]: *** [CMakeFiles/Makefile2:710: test/CMakeFiles/installcheck.dir/rule] Error 2 278s make: *** [Makefile:273: installcheck] Error 2 278s make: Leaving directory '/tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17' 278s + tail -n1000 test-17/test/log/initdb.log test-17/test/log/postmaster.log test-17/test/regression.diffs 278s ==> test-17/test/log/initdb.log <== 278s Running in no-clean mode. Mistakes will not be cleaned up. 278s The files belonging to this database system will be owned by user "ubuntu". 278s This user must also own the server process. 278s 278s The database cluster will be initialized with this locale configuration: 278s locale provider: libc 278s LC_COLLATE: C.UTF-8 278s LC_CTYPE: C.UTF-8 278s LC_MESSAGES: C 278s LC_MONETARY: C.UTF-8 278s LC_NUMERIC: C.UTF-8 278s LC_TIME: C.UTF-8 278s The default database encoding has accordingly been set to "UTF8". 278s The default text search configuration will be set to "english". 278s 278s Data page checksums are disabled. 278s 278s creating directory /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/testcluster/data ... ok 278s creating subdirectories ... ok 278s selecting dynamic shared memory implementation ... posix 278s selecting default "max_connections" ... 100 278s selecting default "shared_buffers" ... 128MB 278s selecting default time zone ... Etc/UTC 278s creating configuration files ... ok 278s running bootstrap script ... ok 278s performing post-bootstrap initialization ... ok 278s 278s Sync to disk skipped. 278s The data directory might become corrupt if the operating system crashes. 278s 278s initdb: warning: enabling "trust" authentication for local connections 278s initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. 278s 278s Success. You can now start the database server using: 278s 278s /usr/lib/postgresql/17/bin/pg_ctl -D /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/testcluster/data -l logfile start 278s 278s 278s ==> test-17/test/log/postmaster.log <== 278s 2024-11-15 05:23:17.386 UTC: [5037] LOG: redirecting log output to logging collector process 278s 2024-11-15 05:23:17.386 UTC: [5037] HINT: Future log output will appear in directory "log". 278s 278s ==> test-17/test/regression.diffs <== 278s - 1257894000000000000 | dev2 | 1.5 | 2 | | 278s - 1257894000000001000 | dev1 | 2.5 | 3 | | 278s - 1257894001000000000 | dev1 | 3.5 | 4 | | 278s - 1257894002000000000 | dev1 | 2.5 | 3 | | 278s - 1257894002000000000 | dev1 | 5.5 | 8 | | f 278s - 1257894002000000000 | dev1 | 5.5 | 8 | | t 278s - 1257897600000000000 | dev1 | 4.5 | 5 | | f 278s - 1257987600000000000 | dev1 | 1.5 | 1 | | 278s - 1257987600000000000 | dev1 | 1.5 | 2 | | 278s -(12 rows) 278s - 278s -UPDATE "one_Partition" SET series_1 = 47; 278s -UPDATE "one_Partition" SET series_bool = true; 278s -SELECT * FROM "one_Partition" ORDER BY "timeCustom", device_id, series_0, series_1, series_2; 278s - timeCustom | device_id | series_0 | series_1 | series_2 | series_bool 278s ----------------------+-----------+----------+----------+----------+------------- 278s - 1257894000000000000 | dev1 | 1.5 | 47 | 2 | t 278s - 1257894000000000000 | dev1 | 1.5 | 47 | | t 278s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 278s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 278s - 1257894000000001000 | dev1 | 2.5 | 47 | | t 278s - 1257894001000000000 | dev1 | 3.5 | 47 | | t 278s - 1257894002000000000 | dev1 | 2.5 | 47 | | t 278s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 278s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 278s - 1257897600000000000 | dev1 | 4.5 | 47 | | t 278s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 278s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 278s -(12 rows) 278s - 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s diff -u /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/upsert.out /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/upsert.out 278s --- /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/upsert.out 2024-11-06 18:23:51.000000000 +0000 278s +++ /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/upsert.out 2024-11-15 05:24:05.343468085 +0000 278s @@ -1,643 +1,2 @@ 278s --- This file and its contents are licensed under the Apache License 2.0. 278s --- Please see the included NOTICE for copyright information and 278s --- LICENSE-APACHE for a copy of the license. 278s -CREATE TABLE upsert_test(time timestamp PRIMARY KEY, temp float, color text); 278s -SELECT create_hypertable('upsert_test', 'time'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s - create_hypertable 278s --------------------------- 278s - (1,public,upsert_test,t) 278s -(1 row) 278s - 278s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 278s -(1 row) 278s - 278s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 23.8, 'yellow') ON CONFLICT (time) 278s -DO UPDATE SET temp = 23.8 RETURNING *; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 278s -(1 row) 278s - 278s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 78.4, 'yellow') ON CONFLICT DO NOTHING; 278s -SELECT * FROM upsert_test; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 278s -(1 row) 278s - 278s --- Test 'Tuples Inserted' and 'Conflicting Tuples' values in EXPLAIN ANALYZE 278s -EXPLAIN (VERBOSE, ANALYZE, COSTS FALSE, TIMING FALSE, SUMMARY FALSE) 278s - INSERT INTO upsert_test VALUES 278s - ('2017-01-20T09:00:01', 28.5, 'blue'), 278s - ('2017-01-20T09:00:01', 21.9, 'red'), 278s - ('2017-01-20T10:00:01', 2.4, 'pink') ON CONFLICT DO NOTHING; 278s - QUERY PLAN 278s ----------------------------------------------------------------------------------------- 278s - Custom Scan (HypertableModify) (actual rows=0 loops=1) 278s - -> Insert on public.upsert_test (actual rows=0 loops=1) 278s - Conflict Resolution: NOTHING 278s - Tuples Inserted: 1 278s - Conflicting Tuples: 2 278s - -> Custom Scan (ChunkDispatch) (actual rows=3 loops=1) 278s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 278s - -> Values Scan on "*VALUES*" (actual rows=3 loops=1) 278s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 278s -(9 rows) 278s - 278s --- Test ON CONFLICT ON CONSTRAINT 278s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 12.3, 'yellow') ON CONFLICT ON CONSTRAINT upsert_test_pkey 278s -DO UPDATE SET temp = 12.3 RETURNING time, temp, color; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 12.3 | yellow 278s -(1 row) 278s - 278s --- Test that update generates error on conflicts 278s -\set ON_ERROR_STOP 0 278s -INSERT INTO upsert_test VALUES ('2017-01-21T09:00:01', 22.5, 'yellow') RETURNING *; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Sat Jan 21 09:00:01 2017 | 22.5 | yellow 278s -(1 row) 278s - 278s -UPDATE upsert_test SET time = '2017-01-20T09:00:01'; 278s -ERROR: duplicate key value violates unique constraint "1_1_upsert_test_pkey" 278s -\set ON_ERROR_STOP 1 278s --- Test with UNIQUE index on multiple columns instead of PRIMARY KEY constraint 278s -CREATE TABLE upsert_test_unique(time timestamp, temp float, color text); 278s -SELECT create_hypertable('upsert_test_unique', 'time'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ---------------------------------- 278s - (2,public,upsert_test_unique,t) 278s -(1 row) 278s - 278s -CREATE UNIQUE INDEX time_color_idx ON upsert_test_unique (time, color); 278s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 21.2, 'brown'); 278s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 278s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 278s -(2 rows) 278s - 278s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 31.8, 'yellow') ON CONFLICT (time, color) 278s -DO UPDATE SET temp = 31.8; 278s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 54.3, 'yellow') ON CONFLICT DO NOTHING; 278s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 31.8 | yellow 278s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 278s -(2 rows) 278s - 278s --- Test with multiple UNIQUE indexes 278s -CREATE TABLE upsert_test_multi_unique(time timestamp, temp float, color text); 278s -SELECT create_hypertable('upsert_test_multi_unique', 'time'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ---------------------------------------- 278s - (3,public,upsert_test_multi_unique,t) 278s -(1 row) 278s - 278s -ALTER TABLE upsert_test_multi_unique ADD CONSTRAINT multi_time_temp UNIQUE (time, temp); 278s -CREATE UNIQUE INDEX multi_time_color_idx ON upsert_test_multi_unique (time, color); 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'yellow'); 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 25.9, 'yellow'); 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'brown'); 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'purple') ON CONFLICT DO NOTHING; 278s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow 278s - Fri Jan 20 09:00:01 2017 | 23.5 | brown 278s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 278s -(3 rows) 278s - 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'blue') ON CONFLICT (time, temp) 278s -DO UPDATE SET color = 'blue'; 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 278s -DO UPDATE SET color = excluded.color; 278s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 278s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 278s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 278s -(3 rows) 278s - 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 45.7, 'yellow') ON CONFLICT (time, color) 278s -DO UPDATE SET temp = 45.7; 278s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 278s - time | temp | color 278s ---------------------------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 278s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 278s - Sat Jan 21 09:00:01 2017 | 45.7 | yellow 278s -(3 rows) 278s - 278s -\set ON_ERROR_STOP 0 278s --- Here the constraint in the ON CONFLICT clause is not the one that is 278s --- actually violated by the INSERT, so it should still fail. 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'purple') ON CONFLICT (time, color) 278s -DO UPDATE set temp = 23.5; 278s -ERROR: duplicate key value violates unique constraint "3_2_multi_time_temp" 278s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 22.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 278s -DO UPDATE set color = 'orange'; 278s -ERROR: duplicate key value violates unique constraint "_hyper_3_3_chunk_multi_time_color_idx" 278s -\set ON_ERROR_STOP 1 278s -CREATE TABLE upsert_test_space(time timestamp, device_id_1 char(20), to_drop int, temp float, color text); 278s ---drop two columns; create one. 278s -ALTER TABLE upsert_test_space DROP to_drop; 278s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id char(20); 278s -ALTER TABLE upsert_test_space ADD CONSTRAINT time_space_constraint UNIQUE (time, device_id); 278s -SELECT create_hypertable('upsert_test_space', 'time', 'device_id', 2, partitioning_func=>'_timescaledb_functions.get_partition_for_key'::regproc); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s --------------------------------- 278s - (4,public,upsert_test_space,t) 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 278s - time | temp | color | device_id 278s ---------------------------+------+--------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow | dev1 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow'); 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 23.5, 'green') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color; 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 23.5, 'orange') ON CONFLICT ON CONSTRAINT time_space_constraint 278s -DO UPDATE SET color = excluded.color; 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 23.5, 'orange3') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 278s - time | temp | color | device_id 278s ---------------------------+------+-----------------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev3', 23.5, 'orange3.1') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 278s - time | temp | color | device_id 278s ---------------------------+------+-----------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 23.5, 'orange4') ON CONFLICT (time, device_id) 278s -DO NOTHING RETURNING *; 278s - time | temp | color | device_id 278s -------+------+-------+----------- 278s -(0 rows) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev4', 23.5, 'orange5') ON CONFLICT (time, device_id) 278s -DO NOTHING RETURNING *; 278s - time | temp | color | device_id 278s ---------------------------+------+---------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev4 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 23.5, 'orange5') ON CONFLICT (time, device_id) 278s -DO NOTHING RETURNING *; 278s - time | temp | color | device_id 278s ---------------------------+------+---------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev5 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 23.5, 'orange6') ON CONFLICT ON CONSTRAINT time_space_constraint 278s -DO NOTHING RETURNING *; 278s - time | temp | color | device_id 278s -------+------+-------+----------- 278s -(0 rows) 278s - 278s ---restore a column with the same name as a previously deleted one; 278s -ALTER TABLE upsert_test_space ADD device_id_1 char(20); 278s -INSERT INTO upsert_test_space (time, device_id, temp, color, device_id_1) VALUES ('2017-01-20T09:00:01', 'dev4', 23.5, 'orange5.1', 'dev-id-1') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+--------------------------------+----------------------+------------- 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 23.5, 'orange6') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s -------+------+-------+-----------+------------- 278s -(0 rows) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 23.5, 'orange7') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color WHERE excluded.temp < 20 RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s -------+------+-------+-----------+------------- 278s -(0 rows) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 3.5, 'orange7') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color, temp=excluded.temp WHERE excluded.temp < 20 RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+---------+----------------------+------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange7 | dev5 | 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev5', 43.5, 'orange8') ON CONFLICT (time, device_id) 278s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+---------+----------------------+------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color, device_id_1) VALUES ('2017-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-1-new') ON CONFLICT (time, device_id) 278s -DO UPDATE SET device_id_1 = excluded.device_id_1 RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+---------+----------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-1-new 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_space (time, device_id, temp, color, device_id_1) VALUES ('2017-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-1-new') ON CONFLICT (time, device_id) 278s -DO UPDATE SET device_id_1 = 'device-id-1-new-2', color = 'orange9' RETURNING *; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+---------+----------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 278s -(1 row) 278s - 278s -SELECT * FROM upsert_test_space; 278s - time | temp | color | device_id | device_id_1 278s ---------------------------+------+--------------------------------+----------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 25.9 | orange | dev1 | 278s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 | 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 | 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 278s -(5 rows) 278s - 278s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id_2 char(20); 278s -INSERT INTO upsert_test_space (time, device_id, temp, color, device_id_2) VALUES ('2017-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-2') 278s -ON CONFLICT (time, device_id) 278s -DO UPDATE SET device_id_2 = 'device-id-2-new', color = 'orange10' RETURNING *; 278s - time | temp | color | device_id | device_id_2 278s ---------------------------+------+----------+----------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange10 | dev5 | device-id-2-new 278s -(1 row) 278s - 278s ---test inserting to to a chunk already in the chunk dispatch cache again. 278s -INSERT INTO upsert_test_space as current (time, device_id, temp, color, device_id_2) VALUES ('2017-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-2'), 278s -('2018-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-2'), 278s -('2017-01-20T09:00:01', 'dev3', 43.5, 'orange7', 'device-id-2'), 278s -('2018-01-21T09:00:01', 'dev5', 43.5, 'orange9', 'device-id-2') 278s -ON CONFLICT (time, device_id) 278s -DO UPDATE SET device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), color = coalesce(excluded.color,current.color) RETURNING *; 278s - time | temp | color | device_id | device_id_2 278s ---------------------------+------+---------+----------------------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-2 278s - Sat Jan 20 09:00:01 2018 | 43.5 | orange8 | dev5 | device-id-2 278s - Fri Jan 20 09:00:01 2017 | 23.5 | orange7 | dev3 | device-id-2 278s - Sun Jan 21 09:00:01 2018 | 43.5 | orange9 | dev5 | device-id-2 278s -(4 rows) 278s - 278s -WITH CTE AS ( 278s - INSERT INTO upsert_test_multi_unique 278s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 278s - ON CONFLICT DO NOTHING 278s - RETURNING * 278s -) SELECT 1; 278s - ?column? 278s ----------- 278s - 1 278s -(1 row) 278s - 278s -WITH CTE AS ( 278s - INSERT INTO upsert_test_multi_unique 278s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple'), 278s - ('2017-01-20T09:00:01', 29.9, 'purple1') 278s - ON CONFLICT DO NOTHING 278s - RETURNING * 278s -) SELECT * FROM CTE; 278s - time | temp | color 278s ---------------------------+------+--------- 278s - Fri Jan 20 09:00:01 2017 | 29.9 | purple1 278s -(1 row) 278s - 278s -WITH CTE AS ( 278s - INSERT INTO upsert_test_multi_unique 278s - VALUES ('2017-01-20T09:00:01', 25.9, 'blue') 278s - ON CONFLICT (time, temp) DO UPDATE SET color = 'blue' 278s - RETURNING * 278s -) 278s -SELECT * FROM CTE; 278s - time | temp | color 278s ---------------------------+------+------- 278s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 278s -(1 row) 278s - 278s ---test error conditions when an index is dropped on a chunk 278s -DROP INDEX _timescaledb_internal._hyper_3_3_chunk_multi_time_color_idx; 278s ---everything is ok if not used as an arbiter index 278s -INSERT INTO upsert_test_multi_unique 278s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 278s -ON CONFLICT DO NOTHING 278s -RETURNING *; 278s - time | temp | color 278s -------+------+------- 278s -(0 rows) 278s - 278s ---errors out if used as an arbiter index 278s -\set ON_ERROR_STOP 0 278s -INSERT INTO upsert_test_multi_unique 278s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 278s -ON CONFLICT (time, color) DO NOTHING 278s -RETURNING *; 278s -ERROR: could not find arbiter index for hypertable index "multi_time_color_idx" on chunk "_hyper_3_3_chunk" 278s -\set ON_ERROR_STOP 1 278s ---create table with one chunk that has a tup_conv_map and one that does not 278s ---to ensure this, create a chunk before altering the table this chunk will not have a tup_conv_map 278s -CREATE TABLE upsert_test_diffchunk(time timestamp, device_id char(20), to_drop int, temp float, color text); 278s -SELECT create_hypertable('upsert_test_diffchunk', 'time', chunk_time_interval=> interval '1 month'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ------------------------------------- 278s - (5,public,upsert_test_diffchunk,t) 278s -(1 row) 278s - 278s -CREATE UNIQUE INDEX time_device_idx ON upsert_test_diffchunk (time, device_id); 278s ---this is the chunk with no tup_conv_map 278s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 278s - time | device_id | to_drop | temp | color 278s ---------------------------+----------------------+---------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | dev1 | | 25.9 | yellow 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow') RETURNING *; 278s - time | device_id | to_drop | temp | color 278s ---------------------------+----------------------+---------+------+-------- 278s - Fri Jan 20 09:00:01 2017 | dev2 | | 25.9 | yellow 278s -(1 row) 278s - 278s ---alter the table 278s -ALTER TABLE upsert_test_diffchunk DROP to_drop; 278s -ALTER TABLE upsert_test_diffchunk ADD device_id_2 char(20); 278s ---new chunk that does have a tup conv map 278s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev1', 23.5, 'orange') ; 278s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev2', 23.5, 'orange') ; 278s -select * from upsert_test_diffchunk order by time, device_id; 278s - time | device_id | temp | color | device_id_2 278s ---------------------------+----------------------+------+--------+------------- 278s - Fri Jan 20 09:00:01 2017 | dev1 | 25.9 | yellow | 278s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 278s - Sun Jan 20 09:00:01 2019 | dev1 | 23.5 | orange | 278s - Sun Jan 20 09:00:01 2019 | dev2 | 23.5 | orange | 278s -(4 rows) 278s - 278s ---make sure current works 278s -INSERT INTO upsert_test_diffchunk as current (time, device_id, temp, color, device_id_2) VALUES 278s -('2019-01-20T09:00:01', 'dev1', 43.5, 'orange2', 'device-id-2'), 278s -('2017-01-20T09:00:01', 'dev1', 43.5, 'yellow2', 'device-id-2'), 278s -('2019-01-20T09:00:01', 'dev2', 43.5, 'orange2', 'device-id-2') 278s -ON CONFLICT (time, device_id) 278s -DO UPDATE SET 278s -device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), 278s -temp = coalesce(excluded.temp,current.temp) , 278s -color = coalesce(excluded.color,current.color); 278s -select * from upsert_test_diffchunk order by time, device_id; 278s - time | device_id | temp | color | device_id_2 278s ---------------------------+----------------------+------+---------+---------------------- 278s - Fri Jan 20 09:00:01 2017 | dev1 | 43.5 | yellow2 | device-id-2 278s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 278s - Sun Jan 20 09:00:01 2019 | dev1 | 43.5 | orange2 | device-id-2 278s - Sun Jan 20 09:00:01 2019 | dev2 | 43.5 | orange2 | device-id-2 278s -(4 rows) 278s - 278s ---arbiter index tests 278s -CREATE TABLE upsert_test_arbiter(time timestamp, to_drop int); 278s -SELECT create_hypertable('upsert_test_arbiter', 'time', chunk_time_interval=> interval '1 month'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ----------------------------------- 278s - (6,public,upsert_test_arbiter,t) 278s -(1 row) 278s - 278s ---this is the chunk with no tup_conv_map 278s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-20T09:00:01', 1) RETURNING *; 278s - time | to_drop 278s ---------------------------+--------- 278s - Fri Jan 20 09:00:01 2017 | 1 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-21T09:00:01', 2) RETURNING *; 278s - time | to_drop 278s ---------------------------+--------- 278s - Sat Jan 21 09:00:01 2017 | 2 278s -(1 row) 278s - 278s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-03-20T09:00:01', 3) RETURNING *; 278s - time | to_drop 278s ---------------------------+--------- 278s - Mon Mar 20 09:00:01 2017 | 3 278s -(1 row) 278s - 278s ---alter the table 278s -ALTER TABLE upsert_test_arbiter DROP to_drop; 278s -ALTER TABLE upsert_test_arbiter ADD device_id char(20) DEFAULT 'dev1'; 278s -CREATE UNIQUE INDEX arbiter_time_device_idx ON upsert_test_arbiter (time, device_id); 278s -INSERT INTO upsert_test_arbiter as current (time, device_id) VALUES 278s - ('2018-01-21T09:00:01', 'dev1'), 278s - ('2017-01-20T09:00:01', 'dev1'), 278s - ('2017-01-21T09:00:01', 'dev2'), 278s - ('2018-01-21T09:00:01', 'dev2') 278s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = coalesce(excluded.device_id,current.device_id) 278s -RETURNING *; 278s - time | device_id 278s ---------------------------+---------------------- 278s - Sun Jan 21 09:00:01 2018 | dev1 278s - Fri Jan 20 09:00:01 2017 | dev1 278s - Sat Jan 21 09:00:01 2017 | dev2 278s - Sun Jan 21 09:00:01 2018 | dev2 278s -(4 rows) 278s - 278s -with cte as ( 278s -INSERT INTO upsert_test_arbiter (time, device_id) VALUES 278s - ('2017-01-21T09:00:01', 'dev2'), 278s - ('2018-01-21T09:00:01', 'dev2') 278s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = 'dev3' 278s -RETURNING *) 278s -select * from cte; 278s - time | device_id 278s ---------------------------+---------------------- 278s - Sat Jan 21 09:00:01 2017 | dev3 278s - Sun Jan 21 09:00:01 2018 | dev3 278s -(2 rows) 278s - 278s --- test ON CONFLICT with prepared statements 278s -CREATE TABLE prepared_test(time timestamptz PRIMARY KEY, value float CHECK(value > 0)); 278s -SELECT create_hypertable('prepared_test','time'); 278s - create_hypertable 278s ----------------------------- 278s - (7,public,prepared_test,t) 278s -(1 row) 278s - 278s -CREATE TABLE source_data(time timestamptz PRIMARY KEY, value float); 278s -INSERT INTO source_data VALUES('2000-01-01',0.5), ('2001-01-01',0.5); 278s --- at some point PostgreSQL will turn the plan into a generic plan 278s --- so we execute the prepared statement 10 times 278s --- check that an error in the prepared statement does not lead to the plan becoming unusable 278s -PREPARE prep_insert_select AS INSERT INTO prepared_test select * from source_data ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s -EXECUTE prep_insert_select; 278s ---this insert will create an invalid tuple in source_data 278s ---so that future calls to prep_insert_select will fail 278s -INSERT INTO source_data VALUES('2000-01-02',-0.5); 278s -\set ON_ERROR_STOP 0 278s -EXECUTE prep_insert_select; 278s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 278s -EXECUTE prep_insert_select; 278s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 278s -\set ON_ERROR_STOP 1 278s -DELETE FROM source_data WHERE value <= 0; 278s -EXECUTE prep_insert_select; 278s -PREPARE prep_insert AS INSERT INTO prepared_test VALUES('2000-01-01',0.5) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 278s --- at some point PostgreSQL will turn the plan into a generic plan 278s --- so we execute the prepared statement 10 times 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -EXECUTE prep_insert; 278s -SELECT * FROM prepared_test; 278s - time | value 278s -------------------------------+------- 278s - Sat Jan 01 00:00:00 2000 PST | 0.5 278s - Mon Jan 01 00:00:00 2001 PST | 0.5 278s -(2 rows) 278s - 278s -DELETE FROM prepared_test; 278s --- test ON CONFLICT with functions 278s -CREATE OR REPLACE FUNCTION test_upsert(t timestamptz, v float) RETURNS VOID AS $sql$ 278s -BEGIN 278s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 278s -END; 278s -$sql$ LANGUAGE PLPGSQL; 278s --- at some point PostgreSQL will turn the plan into a generic plan 278s --- so we execute the function 10 times 278s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 278s - counter | test_upsert 278s ----------+------------- 278s - 1 | 278s - 2 | 278s - 3 | 278s - 4 | 278s - 5 | 278s - 6 | 278s - 7 | 278s - 8 | 278s - 9 | 278s - 10 | 278s -(10 rows) 278s - 278s -SELECT * FROM prepared_test; 278s - time | value 278s -------------------------------+------- 278s - Sat Jan 01 00:00:00 2000 PST | 0.5 278s -(1 row) 278s - 278s -DELETE FROM prepared_test; 278s --- at some point PostgreSQL will turn the plan into a generic plan 278s --- so we execute the function 10 times 278s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 278s - counter | test_upsert 278s ----------+------------- 278s - 1 | 278s - 2 | 278s - 3 | 278s - 4 | 278s - 5 | 278s - 6 | 278s - 7 | 278s - 8 | 278s - 9 | 278s - 10 | 278s -(10 rows) 278s - 278s -SELECT * FROM prepared_test; 278s - time | value 278s -------------------------------+------- 278s - Sat Jan 01 00:00:00 2000 PST | 0.5 278s -(1 row) 278s - 278s -DELETE FROM prepared_test; 278s --- run it again to ensure INSERT path is still working as well 278s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 278s - counter | test_upsert 278s ----------+------------- 278s - 1 | 278s - 2 | 278s - 3 | 278s - 4 | 278s - 5 | 278s - 6 | 278s - 7 | 278s - 8 | 278s - 9 | 278s - 10 | 278s -(10 rows) 278s - 278s -SELECT * FROM prepared_test; 278s - time | value 278s -------------------------------+------- 278s - Sat Jan 01 00:00:00 2000 PST | 0.5 278s -(1 row) 278s - 278s -DELETE FROM prepared_test; 278s --- test ON CONFLICT with functions 278s -CREATE OR REPLACE FUNCTION test_upsert2(t timestamptz, v float) RETURNS VOID AS $sql$ 278s -BEGIN 278s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = prepared_test.value + 1.0; 278s -END; 278s -$sql$ LANGUAGE PLPGSQL; 278s --- at some point PostgreSQL will turn the plan into a generic plan 278s --- so we execute the function 10 times 278s -SELECT counter,test_upsert2('2000-01-01',1.0) FROM generate_series(1,10) AS g(counter); 278s - counter | test_upsert2 278s ----------+-------------- 278s - 1 | 278s - 2 | 278s - 3 | 278s - 4 | 278s - 5 | 278s - 6 | 278s - 7 | 278s - 8 | 278s - 9 | 278s - 10 | 278s -(10 rows) 278s - 278s -SELECT * FROM prepared_test; 278s - time | value 278s -------------------------------+------- 278s - Sat Jan 01 00:00:00 2000 PST | 10 278s -(1 row) 278s - 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s diff -u /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/util.out /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/util.out 278s --- /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/util.out 2024-11-06 18:23:51.000000000 +0000 278s +++ /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/util.out 2024-11-15 05:24:05.351466340 +0000 278s @@ -1,18 +1,2 @@ 278s --- This file and its contents are licensed under the Apache License 2.0. 278s --- Please see the included NOTICE for copyright information and 278s --- LICENSE-APACHE for a copy of the license. 278s -\set ECHO errors 278s - item 278s ------------------------------------- 278s - db_util_wizard=a/db_util_wizard 278s - db_util_wizard=ar/db_util_wizard 278s - db_util_wizard=a*/db_util_wizard 278s - db_util_wizard=a*r*/db_util_wizard 278s - [NULL] 278s - [NULL] 278s - [NULL] 278s - [NULL] 278s - =a*r*/db_util_wizard 278s - db_util_wizard=a*r*/0 278s -(10 rows) 278s - 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s diff -u /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/vacuum.out /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/vacuum.out 278s --- /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/vacuum.out 2024-11-06 18:23:51.000000000 +0000 278s +++ /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/vacuum.out 2024-11-15 05:24:05.343468085 +0000 278s @@ -1,228 +1,2 @@ 278s --- This file and its contents are licensed under the Apache License 2.0. 278s --- Please see the included NOTICE for copyright information and 278s --- LICENSE-APACHE for a copy of the license. 278s -CREATE TABLE vacuum_test(time timestamp, temp float); 278s --- create hypertable with three chunks 278s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s --------------------------- 278s - (1,public,vacuum_test,t) 278s -(1 row) 278s - 278s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 278s - ('2017-01-21T16:00:01', 19.1), 278s - ('2017-04-20T16:00:01', 89.5), 278s - ('2017-04-21T16:00:01', 17.1), 278s - ('2017-06-20T16:00:01', 18.5), 278s - ('2017-06-21T16:00:01', 11.0); 278s --- no stats 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -VACUUM ANALYZE vacuum_test; 278s --- stats should exist for all three chunks 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s -------------------+---------+---------------------------------------------------------+------------ 278s - _hyper_1_1_chunk | temp | {17.5,19.1} | -1 278s - _hyper_1_1_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 278s - _hyper_1_2_chunk | temp | {17.1,89.5} | -1 278s - _hyper_1_2_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 278s - _hyper_1_3_chunk | temp | {11,18.5} | -1 278s - _hyper_1_3_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(6 rows) 278s - 278s --- stats should exist on parent hypertable 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s --------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 278s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 278s - vacuum_test | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017","Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017","Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(2 rows) 278s - 278s -DROP TABLE vacuum_test; 278s ---test plain analyze (no_vacuum) 278s -CREATE TABLE analyze_test(time timestamp, temp float); 278s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ---------------------------- 278s - (2,public,analyze_test,t) 278s -(1 row) 278s - 278s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 278s - ('2017-01-21T16:00:01', 19.1), 278s - ('2017-04-20T16:00:01', 89.5), 278s - ('2017-04-21T16:00:01', 17.1), 278s - ('2017-06-20T16:00:01', 18.5), 278s - ('2017-06-21T16:00:01', 11.0); 278s --- no stats 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -ANALYZE VERBOSE analyze_test; 278s -INFO: analyzing "_timescaledb_internal._hyper_2_4_chunk" 278s -INFO: "_hyper_2_4_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s -INFO: analyzing "_timescaledb_internal._hyper_2_5_chunk" 278s -INFO: "_hyper_2_5_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s -INFO: analyzing "_timescaledb_internal._hyper_2_6_chunk" 278s -INFO: "_hyper_2_6_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s -INFO: analyzing "public.analyze_test" 278s -INFO: "analyze_test": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows 278s -INFO: analyzing "public.analyze_test" inheritance tree 278s -INFO: "_hyper_2_4_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s -INFO: "_hyper_2_5_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s -INFO: "_hyper_2_6_chunk": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows 278s --- stats should exist for all three chunks 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s -------------------+---------+---------------------------------------------------------+------------ 278s - _hyper_2_4_chunk | temp | {17.5,19.1} | -1 278s - _hyper_2_4_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 278s - _hyper_2_5_chunk | temp | {17.1,89.5} | -1 278s - _hyper_2_5_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 278s - _hyper_2_6_chunk | temp | {11,18.5} | -1 278s - _hyper_2_6_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(6 rows) 278s - 278s --- stats should exist on parent hypertable 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 278s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 278s - analyze_test | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017","Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017","Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(2 rows) 278s - 278s -DROP TABLE analyze_test; 278s --- Run vacuum on a normal (non-hypertable) table 278s -CREATE TABLE vacuum_norm(time timestamp, temp float); 278s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 278s - ('2017-01-21T09:00:01', 19.1), 278s - ('2017-04-20T09:00:01', 89.5), 278s - ('2017-04-21T09:00:01', 17.1), 278s - ('2017-06-20T09:00:01', 18.5), 278s - ('2017-06-21T09:00:01', 11.0); 278s -VACUUM ANALYZE vacuum_norm; 278s -DROP TABLE vacuum_norm; 278s ---Similar to normal vacuum tests, but PG11 introduced ability to vacuum multiple tables at once, we make sure that works for hypertables as well. 278s -CREATE TABLE vacuum_test(time timestamp, temp float); 278s --- create hypertable with three chunks 278s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s --------------------------- 278s - (3,public,vacuum_test,t) 278s -(1 row) 278s - 278s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 278s - ('2017-01-21T16:00:01', 19.1), 278s - ('2017-04-20T16:00:01', 89.5), 278s - ('2017-04-21T16:00:01', 17.1), 278s - ('2017-06-20T16:00:01', 18.5), 278s - ('2017-06-21T16:00:01', 11.0); 278s -CREATE TABLE analyze_test(time timestamp, temp float); 278s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s -NOTICE: adding not-null constraint to column "time" 278s - create_hypertable 278s ---------------------------- 278s - (4,public,analyze_test,t) 278s -(1 row) 278s - 278s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 278s - ('2017-01-21T16:00:01', 19.1), 278s - ('2017-04-20T16:00:01', 89.5), 278s - ('2017-04-21T16:00:01', 17.1), 278s - ('2017-06-20T16:00:01', 18.5), 278s - ('2017-06-21T16:00:01', 11.0); 278s -CREATE TABLE vacuum_norm(time timestamp, temp float); 278s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 278s - ('2017-01-21T09:00:01', 19.1), 278s - ('2017-04-20T09:00:01', 89.5), 278s - ('2017-04-21T09:00:01', 17.1), 278s - ('2017-06-20T09:00:01', 18.5), 278s - ('2017-06-21T09:00:01', 11.0); 278s --- no stats 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ------------+---------+------------------+------------ 278s -(0 rows) 278s - 278s -VACUUM ANALYZE vacuum_norm, vacuum_test, analyze_test; 278s --- stats should exist for all 6 chunks 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s --------------------+---------+---------------------------------------------------------+------------ 278s - _hyper_3_7_chunk | temp | {17.5,19.1} | -1 278s - _hyper_3_7_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 278s - _hyper_3_8_chunk | temp | {17.1,89.5} | -1 278s - _hyper_3_8_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 278s - _hyper_3_9_chunk | temp | {11,18.5} | -1 278s - _hyper_3_9_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s - _hyper_4_10_chunk | temp | {17.5,19.1} | -1 278s - _hyper_4_10_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 278s - _hyper_4_11_chunk | temp | {17.1,89.5} | -1 278s - _hyper_4_11_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 278s - _hyper_4_12_chunk | temp | {11,18.5} | -1 278s - _hyper_4_12_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(12 rows) 278s - 278s --- stats should exist on parent hypertable and normal table 278s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 278s -WHERE schemaname = 'public' 278s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 278s - tablename | attname | histogram_bounds | n_distinct 278s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 278s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 278s - analyze_test | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017","Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017","Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s - vacuum_norm | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 278s - vacuum_norm | time | {"Fri Jan 20 09:00:01 2017","Sat Jan 21 09:00:01 2017","Thu Apr 20 09:00:01 2017","Fri Apr 21 09:00:01 2017","Tue Jun 20 09:00:01 2017","Wed Jun 21 09:00:01 2017"} | -1 278s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 278s - vacuum_test | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017","Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017","Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 278s -(6 rows) 278s - 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s diff -u /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/vacuum_parallel.out /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/vacuum_parallel.out 278s --- /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/vacuum_parallel.out 2024-11-06 18:23:51.000000000 +0000 278s +++ /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/vacuum_parallel.out 2024-11-15 05:24:05.359464595 +0000 278s @@ -1,39 +1,2 @@ 278s --- This file and its contents are licensed under the Apache License 2.0. 278s --- Please see the included NOTICE for copyright information and 278s --- LICENSE-APACHE for a copy of the license. 278s --- PG13 introduced parallel VACUUM functionality. It gets invoked when a table 278s --- has two or more indexes on it. Read up more at 278s --- https://www.postgresql.org/docs/13/sql-vacuum.html#PARALLEL 278s -CREATE TABLE vacuum_test(time timestamp NOT NULL, temp1 float, temp2 int); 278s --- create hypertable 278s --- we create chunks in public schema cause otherwise we would need 278s --- elevated privileges to create indexes directly 278s -SELECT create_hypertable('vacuum_test', 'time', create_default_indexes => false, associated_schema_name => 'public'); 278s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 278s - create_hypertable 278s --------------------------- 278s - (1,public,vacuum_test,t) 278s -(1 row) 278s - 278s --- parallel vacuum needs the index size to be larger than min_parallel_index_scan_size to kick in 278s -SET min_parallel_index_scan_size TO 0; 278s -INSERT INTO vacuum_test SELECT TIMESTAMP 'epoch' + (i * INTERVAL '4h'), 278s - i, i+1 FROM generate_series(1, 100) as T(i); 278s --- create indexes on the temp columns 278s --- we create indexes manually because otherwise vacuum verbose output 278s --- would be different between 13.2 and 13.3+ 278s --- 13.2 would try to vacuum the parent table index too while 13.3+ wouldn't 278s -CREATE INDEX ON _hyper_1_1_chunk(time); 278s -CREATE INDEX ON _hyper_1_1_chunk(temp1); 278s -CREATE INDEX ON _hyper_1_1_chunk(temp2); 278s -CREATE INDEX ON _hyper_1_2_chunk(time); 278s -CREATE INDEX ON _hyper_1_2_chunk(temp1); 278s -CREATE INDEX ON _hyper_1_2_chunk(temp2); 278s -CREATE INDEX ON _hyper_1_3_chunk(time); 278s -CREATE INDEX ON _hyper_1_3_chunk(temp1); 278s -CREATE INDEX ON _hyper_1_3_chunk(temp2); 278s --- INSERT only will not trigger vacuum on indexes for PG13.3+ 278s -UPDATE vacuum_test SET time = time + '1s'::interval, temp1 = random(), temp2 = random(); 278s --- we should see two parallel workers for each chunk 278s -VACUUM (PARALLEL 3) vacuum_test; 278s -DROP TABLE vacuum_test; 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s diff -u /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/version.out /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/version.out 278s --- /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test/expected/version.out 2024-11-06 18:23:51.000000000 +0000 278s +++ /tmp/autopkgtest.TJBJPZ/build.5MJ/src/test-17/test/results/version.out 2024-11-15 05:24:05.351466340 +0000 278s @@ -1,10 +1,2 @@ 278s --- This file and its contents are licensed under the Apache License 2.0. 278s --- Please see the included NOTICE for copyright information and 278s --- LICENSE-APACHE for a copy of the license. 278s --- Test that get_os_info returns 3 x text 278s -select pg_typeof(sysname) AS sysname_type,pg_typeof(version) AS version_type,pg_typeof(release) AS release_type from _timescaledb_functions.get_os_info(); 278s - sysname_type | version_type | release_type 278s ---------------+--------------+-------------- 278s - text | text | text 278s -(1 row) 278s - 278s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 278s +DETAIL: Consistent recovery state has not been yet reached. 278s + EXIT=1 278s + exit 1 278s autopkgtest [05:24:05]: test installcheck: -----------------------] 279s autopkgtest [05:24:06]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 279s installcheck FAIL non-zero exit status 1 279s autopkgtest [05:24:06]: @@@@@@@@@@@@@@@@@@@@ summary 279s installcheck FAIL non-zero exit status 1 284s nova [W] Using flock in prodstack6-ppc64el 284s Creating nova instance adt-plucky-ppc64el-timescaledb-20241115-051927-juju-7f2275-prod-proposed-migration-environment-20-391633d2-76e7-4ce8-9338-36e8a2c6dfc4 from image adt/ubuntu-plucky-ppc64el-server-20241113.img (UUID 0c5715b6-5cca-4485-b8bf-b85dfd917a5f)...