0s autopkgtest [03:17:21]: starting date and time: 2024-11-15 03:17:21+0000 0s autopkgtest [03:17:21]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [03:17:21]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.0vo3whe5/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-arm64-26.secgroup --name adt-plucky-arm64-timescaledb-20241115-031721-juju-7f2275-prod-proposed-migration-environment-20-04111cab-024d-4bd7-bbd3-8b24a946bf6b --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration -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/ 77s autopkgtest [03:18:38]: testbed dpkg architecture: arm64 77s autopkgtest [03:18:38]: testbed apt version: 2.9.8 77s autopkgtest [03:18:38]: @@@@@@@@@@@@@@@@@@@@ test bed setup 78s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 78s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1030 kB] 79s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 79s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 79s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 79s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [164 kB] 79s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [50.3 kB] 79s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [773 kB] 79s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [6116 B] 79s Fetched 2220 kB in 1s (2733 kB/s) 79s Reading package lists... 81s Reading package lists... 82s Building dependency tree... 82s Reading state information... 82s Calculating upgrade... 83s The following packages will be upgraded: 83s firmware-sof-signed libcap-ng0 libexpat1 lxd-installer man-db pastebinit 83s python3-systemd xfsprogs 83s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s Need to get 9481 kB of archives. 83s After this operation, 549 kB of additional disk space will be used. 83s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 firmware-sof-signed all 2024.06-1ubuntu2 [7083 kB] 83s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libcap-ng0 arm64 0.8.5-3build1 [15.0 kB] 83s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libexpat1 arm64 2.6.4-1 [76.6 kB] 83s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 man-db arm64 2.13.0-1 [1320 kB] 83s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 lxd-installer all 9 [5084 B] 83s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 pastebinit all 1.7.1-1 [14.9 kB] 83s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-systemd arm64 235-1build5 [46.7 kB] 83s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 xfsprogs arm64 6.8.0-2.2ubuntu2 [919 kB] 84s Preconfiguring packages ... 84s Fetched 9481 kB in 1s (11.0 MB/s) 84s (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 ... 79925 files and directories currently installed.) 84s Preparing to unpack .../firmware-sof-signed_2024.06-1ubuntu2_all.deb ... 84s Unpacking firmware-sof-signed (2024.06-1ubuntu2) over (2024.06-1ubuntu1) ... 84s Preparing to unpack .../libcap-ng0_0.8.5-3build1_arm64.deb ... 84s Unpacking libcap-ng0:arm64 (0.8.5-3build1) over (0.8.5-1) ... 84s Setting up libcap-ng0:arm64 (0.8.5-3build1) ... 84s (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 ... 79951 files and directories currently installed.) 84s Preparing to unpack .../0-libexpat1_2.6.4-1_arm64.deb ... 84s Unpacking libexpat1:arm64 (2.6.4-1) over (2.6.2-2) ... 84s Preparing to unpack .../1-man-db_2.13.0-1_arm64.deb ... 84s Unpacking man-db (2.13.0-1) over (2.12.1-3) ... 85s Preparing to unpack .../2-lxd-installer_9_all.deb ... 85s Unpacking lxd-installer (9) over (8) ... 85s Preparing to unpack .../3-pastebinit_1.7.1-1_all.deb ... 85s Unpacking pastebinit (1.7.1-1) over (1.7.0-1) ... 85s Preparing to unpack .../4-python3-systemd_235-1build5_arm64.deb ... 85s Unpacking python3-systemd (235-1build5) over (235-1build4) ... 85s Preparing to unpack .../5-xfsprogs_6.8.0-2.2ubuntu2_arm64.deb ... 85s Unpacking xfsprogs (6.8.0-2.2ubuntu2) over (6.8.0-2.2ubuntu1) ... 85s Setting up libexpat1:arm64 (2.6.4-1) ... 85s Setting up firmware-sof-signed (2024.06-1ubuntu2) ... 85s Setting up pastebinit (1.7.1-1) ... 85s Setting up man-db (2.13.0-1) ... 85s Updating database of manual pages ... 87s man-db.service is a disabled or a static unit not running, not starting it. 87s Setting up xfsprogs (6.8.0-2.2ubuntu2) ... 87s update-initramfs: deferring update (trigger activated) 88s Setting up lxd-installer (9) ... 88s Setting up python3-systemd (235-1build5) ... 88s Processing triggers for libc-bin (2.40-1ubuntu3) ... 88s Processing triggers for initramfs-tools (0.142ubuntu34) ... 88s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 88s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 104s System running in EFI mode, skipping. 104s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 106s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 106s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 106s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 106s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 107s Reading package lists... 107s Reading package lists... 107s Building dependency tree... 107s Reading state information... 108s Calculating upgrade... 108s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s Reading package lists... 108s Building dependency tree... 108s Reading state information... 109s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 109s autopkgtest [03:19:10]: rebooting testbed after setup commands that affected boot 113s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 136s autopkgtest [03:19:37]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 138s autopkgtest [03:19:39]: @@@@@@@@@@@@@@@@@@@@ apt-source timescaledb 140s Get:1 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (dsc) [2271 B] 140s Get:2 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (tar) [1298 kB] 140s Get:3 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (diff) [4040 B] 141s gpgv: Signature made Thu Nov 7 12:39:30 2024 UTC 141s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 141s gpgv: Can't check signature: No public key 141s dpkg-source: warning: cannot verify inline signature for ./timescaledb_2.17.2+dfsg-1.dsc: no acceptable signature found 141s autopkgtest [03:19:42]: testing package timescaledb version 2.17.2+dfsg-1 141s autopkgtest [03:19:42]: build not needed 142s autopkgtest [03:19:43]: test installcheck: preparing testbed 146s Reading package lists... 146s Building dependency tree... 146s Reading state information... 147s Starting pkgProblemResolver with broken count: 0 147s Starting 2 pkgProblemResolver with broken count: 0 147s Done 147s The following additional packages will be installed: 147s build-essential clang-19 cmake cmake-data cpp cpp-14 147s cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu g++ g++-14 147s g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc gcc-14 147s gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu icu-devtools libasan8 147s libcc1-0 libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 147s libgcc-14-dev libgomp1 libhwasan0 libicu-dev libio-pty-perl libipc-run-perl 147s libisl23 libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 147s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 librhash0 147s libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev libxslt1.1 147s llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime llvm-19-tools 147s postgresql-17 postgresql-17-timescaledb postgresql-client-16 147s postgresql-client-17 postgresql-client-common postgresql-common 147s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 147s zlib1g-dev 147s Suggested packages: 147s clang-19-doc wasi-libc cmake-doc cmake-format elpa-cmake-mode ninja-build 147s cpp-doc gcc-14-locales cpp-14-doc gcc-14-doc gcc-multilib manpages-dev 147s autoconf automake libtool flex bison gdb gcc-doc gdb-aarch64-linux-gnu 147s icu-doc liblzma-doc ncurses-doc postgresql-doc-17 libssl-doc 147s libstdc++-14-doc pkgconf llvm-19-doc postgresql-16 postgresql-doc-16 147s Recommended packages: 147s libclang-rt-19-dev libjson-xs-perl 148s The following NEW packages will be installed: 148s autopkgtest-satdep build-essential clang-19 cmake cmake-data cpp cpp-14 148s cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu g++ g++-14 148s g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc gcc-14 148s gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu icu-devtools libasan8 148s libcc1-0 libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 148s libgcc-14-dev libgomp1 libhwasan0 libicu-dev libio-pty-perl libipc-run-perl 148s libisl23 libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 148s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 librhash0 148s libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev libxslt1.1 148s llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime llvm-19-tools 148s postgresql-17 postgresql-17-timescaledb postgresql-client-16 148s postgresql-client-17 postgresql-client-common postgresql-common 148s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 148s zlib1g-dev 148s 0 upgraded, 66 newly installed, 0 to remove and 0 not upgraded. 148s Need to get 190 MB/190 MB of archives. 148s After this operation, 925 MB of additional disk space will be used. 148s Get:1 /tmp/autopkgtest.znLjvU/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [780 B] 148s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 148s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 148s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 148s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 148s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 148s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 148s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-8ubuntu1 [10.6 MB] 148s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-8ubuntu1 [1028 B] 148s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [5452 B] 148s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.1.0-2ubuntu1 [22.5 kB] 148s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 14.2.0-8ubuntu1 [49.7 kB] 148s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 14.2.0-8ubuntu1 [145 kB] 148s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 14.2.0-8ubuntu1 [27.8 kB] 148s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 14.2.0-8ubuntu1 [2893 kB] 148s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 14.2.0-8ubuntu1 [1283 kB] 149s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 14.2.0-8ubuntu1 [2686 kB] 149s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 14.2.0-8ubuntu1 [1151 kB] 149s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 14.2.0-8ubuntu1 [1598 kB] 149s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-8ubuntu1 [2594 kB] 149s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-8ubuntu1 [20.9 MB] 149s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-8ubuntu1 [518 kB] 149s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [1200 B] 149s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.1.0-2ubuntu1 [4994 B] 149s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-8ubuntu1 [2476 kB] 149s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-8ubuntu1 [12.1 MB] 150s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-8ubuntu1 [19.9 kB] 150s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [958 B] 150s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.1.0-2ubuntu1 [1080 B] 150s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 150s Get:31 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp19 arm64 1:19.1.2-1ubuntu1 [13.8 MB] 150s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 150s Get:33 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 14.2.0-8ubuntu1 [45.3 kB] 150s Get:34 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-8ubuntu1 [190 kB] 150s Get:35 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-19-dev arm64 1:19.1.2-1ubuntu1 [743 kB] 150s Get:36 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-linker-tools arm64 1:19.1.2-1ubuntu1 [1232 kB] 150s Get:37 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-19 arm64 1:19.1.2-1ubuntu1 [77.3 kB] 150s Get:38 http://ftpmaster.internal/ubuntu plucky/main arm64 libjsoncpp25 arm64 1.9.5-6build1 [78.2 kB] 150s Get:39 http://ftpmaster.internal/ubuntu plucky/main arm64 librhash0 arm64 1.4.3-3build1 [126 kB] 150s Get:40 http://ftpmaster.internal/ubuntu plucky/main arm64 cmake-data all 3.30.3-1 [2246 kB] 150s Get:41 http://ftpmaster.internal/ubuntu plucky/main arm64 cmake arm64 3.30.3-1 [10.9 MB] 150s Get:42 http://ftpmaster.internal/ubuntu plucky/main arm64 icu-devtools arm64 74.2-1ubuntu4 [210 kB] 150s Get:43 http://ftpmaster.internal/ubuntu plucky/main arm64 libicu-dev arm64 74.2-1ubuntu4 [11.9 MB] 151s Get:44 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 151s Get:45 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 151s Get:46 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5-2 [385 kB] 151s Get:47 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libpq5 arm64 17.1-1 [140 kB] 151s Get:48 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.3.1-2ubuntu2 [3176 kB] 151s Get:49 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libpq-dev arm64 17.1-1 [158 kB] 151s Get:50 http://ftpmaster.internal/ubuntu plucky/main arm64 liblzma-dev arm64 5.6.2-2 [179 kB] 151s Get:51 http://ftpmaster.internal/ubuntu plucky/main arm64 zlib1g-dev arm64 1:1.3.dfsg+really1.3.1-1ubuntu1 [894 kB] 151s Get:52 http://ftpmaster.internal/ubuntu plucky/main arm64 libxml2-dev arm64 2.12.7+dfsg-3 [73.0 kB] 151s Get:53 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu1 [167 kB] 151s Get:54 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-runtime arm64 1:19.1.2-1ubuntu1 [532 kB] 151s Get:55 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 151s Get:56 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19 arm64 1:19.1.2-1ubuntu1 [17.0 MB] 151s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.6-1build1 [59.5 kB] 151s Get:58 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-tools arm64 1:19.1.2-1ubuntu1 [539 kB] 151s Get:59 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-dev arm64 1:19.1.2-1ubuntu1 [45.1 MB] 152s Get:60 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-client-17 arm64 17.1-1 [1317 kB] 152s Get:61 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-17 arm64 17.1-1 [15.5 MB] 153s Get:62 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-timescaledb arm64 2.17.2+dfsg-1 [308 kB] 153s Get:63 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-16 arm64 16.4-3 [1269 kB] 153s Get:64 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-16 arm64 16.4-3 [1221 kB] 153s Get:65 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-all arm64 262 [20.7 kB] 153s Get:66 http://ftpmaster.internal/ubuntu plucky/main arm64 tzdata-legacy all 2024b-1ubuntu2 [99.9 kB] 153s Preconfiguring packages ... 153s Fetched 190 MB in 5s (37.2 MB/s) 153s Selecting previously unselected package libjson-perl. 153s (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 ... 79957 files and directories currently installed.) 153s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 153s Unpacking libjson-perl (4.10000-1) ... 153s Selecting previously unselected package postgresql-client-common. 153s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 153s Unpacking postgresql-client-common (262) ... 153s Selecting previously unselected package ssl-cert. 153s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 153s Unpacking ssl-cert (1.1.2ubuntu2) ... 153s Selecting previously unselected package postgresql-common. 153s Preparing to unpack .../03-postgresql-common_262_all.deb ... 154s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 154s Unpacking postgresql-common (262) ... 154s Selecting previously unselected package libisl23:arm64. 154s Preparing to unpack .../04-libisl23_0.27-1_arm64.deb ... 154s Unpacking libisl23:arm64 (0.27-1) ... 154s Selecting previously unselected package libmpc3:arm64. 154s Preparing to unpack .../05-libmpc3_1.3.1-1build2_arm64.deb ... 154s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 154s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 154s Preparing to unpack .../06-cpp-14-aarch64-linux-gnu_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package cpp-14. 154s Preparing to unpack .../07-cpp-14_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking cpp-14 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package cpp-aarch64-linux-gnu. 154s Preparing to unpack .../08-cpp-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 154s Unpacking cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 154s Selecting previously unselected package cpp. 154s Preparing to unpack .../09-cpp_4%3a14.1.0-2ubuntu1_arm64.deb ... 154s Unpacking cpp (4:14.1.0-2ubuntu1) ... 154s Selecting previously unselected package libcc1-0:arm64. 154s Preparing to unpack .../10-libcc1-0_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libcc1-0:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libgomp1:arm64. 154s Preparing to unpack .../11-libgomp1_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libgomp1:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libitm1:arm64. 154s Preparing to unpack .../12-libitm1_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libitm1:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libasan8:arm64. 154s Preparing to unpack .../13-libasan8_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libasan8:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package liblsan0:arm64. 154s Preparing to unpack .../14-liblsan0_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking liblsan0:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libtsan2:arm64. 154s Preparing to unpack .../15-libtsan2_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libtsan2:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libubsan1:arm64. 154s Preparing to unpack .../16-libubsan1_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libubsan1:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libhwasan0:arm64. 154s Preparing to unpack .../17-libhwasan0_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libhwasan0:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package libgcc-14-dev:arm64. 154s Preparing to unpack .../18-libgcc-14-dev_14.2.0-8ubuntu1_arm64.deb ... 154s Unpacking libgcc-14-dev:arm64 (14.2.0-8ubuntu1) ... 154s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 155s Preparing to unpack .../19-gcc-14-aarch64-linux-gnu_14.2.0-8ubuntu1_arm64.deb ... 155s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 155s Selecting previously unselected package gcc-14. 155s Preparing to unpack .../20-gcc-14_14.2.0-8ubuntu1_arm64.deb ... 155s Unpacking gcc-14 (14.2.0-8ubuntu1) ... 155s Selecting previously unselected package gcc-aarch64-linux-gnu. 155s Preparing to unpack .../21-gcc-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 155s Unpacking gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 155s Selecting previously unselected package gcc. 155s Preparing to unpack .../22-gcc_4%3a14.1.0-2ubuntu1_arm64.deb ... 155s Unpacking gcc (4:14.1.0-2ubuntu1) ... 155s Selecting previously unselected package libstdc++-14-dev:arm64. 155s Preparing to unpack .../23-libstdc++-14-dev_14.2.0-8ubuntu1_arm64.deb ... 155s Unpacking libstdc++-14-dev:arm64 (14.2.0-8ubuntu1) ... 155s Selecting previously unselected package g++-14-aarch64-linux-gnu. 155s Preparing to unpack .../24-g++-14-aarch64-linux-gnu_14.2.0-8ubuntu1_arm64.deb ... 155s Unpacking g++-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 155s Selecting previously unselected package g++-14. 155s Preparing to unpack .../25-g++-14_14.2.0-8ubuntu1_arm64.deb ... 155s Unpacking g++-14 (14.2.0-8ubuntu1) ... 155s Selecting previously unselected package g++-aarch64-linux-gnu. 156s Preparing to unpack .../26-g++-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 156s Unpacking g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 156s Selecting previously unselected package g++. 156s Preparing to unpack .../27-g++_4%3a14.1.0-2ubuntu1_arm64.deb ... 156s Unpacking g++ (4:14.1.0-2ubuntu1) ... 156s Selecting previously unselected package build-essential. 156s Preparing to unpack .../28-build-essential_12.10ubuntu1_arm64.deb ... 156s Unpacking build-essential (12.10ubuntu1) ... 156s Selecting previously unselected package libclang-cpp19. 156s Preparing to unpack .../29-libclang-cpp19_1%3a19.1.2-1ubuntu1_arm64.deb ... 156s Unpacking libclang-cpp19 (1:19.1.2-1ubuntu1) ... 156s Selecting previously unselected package libgc1:arm64. 156s Preparing to unpack .../30-libgc1_1%3a8.2.8-1_arm64.deb ... 156s Unpacking libgc1:arm64 (1:8.2.8-1) ... 156s Selecting previously unselected package libobjc4:arm64. 156s Preparing to unpack .../31-libobjc4_14.2.0-8ubuntu1_arm64.deb ... 156s Unpacking libobjc4:arm64 (14.2.0-8ubuntu1) ... 156s Selecting previously unselected package libobjc-14-dev:arm64. 156s Preparing to unpack .../32-libobjc-14-dev_14.2.0-8ubuntu1_arm64.deb ... 156s Unpacking libobjc-14-dev:arm64 (14.2.0-8ubuntu1) ... 156s Selecting previously unselected package libclang-common-19-dev:arm64. 156s Preparing to unpack .../33-libclang-common-19-dev_1%3a19.1.2-1ubuntu1_arm64.deb ... 156s Unpacking libclang-common-19-dev:arm64 (1:19.1.2-1ubuntu1) ... 156s Selecting previously unselected package llvm-19-linker-tools. 156s Preparing to unpack .../34-llvm-19-linker-tools_1%3a19.1.2-1ubuntu1_arm64.deb ... 156s Unpacking llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 156s Selecting previously unselected package clang-19. 156s Preparing to unpack .../35-clang-19_1%3a19.1.2-1ubuntu1_arm64.deb ... 156s Unpacking clang-19 (1:19.1.2-1ubuntu1) ... 156s Selecting previously unselected package libjsoncpp25:arm64. 156s Preparing to unpack .../36-libjsoncpp25_1.9.5-6build1_arm64.deb ... 156s Unpacking libjsoncpp25:arm64 (1.9.5-6build1) ... 156s Selecting previously unselected package librhash0:arm64. 156s Preparing to unpack .../37-librhash0_1.4.3-3build1_arm64.deb ... 156s Unpacking librhash0:arm64 (1.4.3-3build1) ... 156s Selecting previously unselected package cmake-data. 156s Preparing to unpack .../38-cmake-data_3.30.3-1_all.deb ... 156s Unpacking cmake-data (3.30.3-1) ... 157s Selecting previously unselected package cmake. 157s Preparing to unpack .../39-cmake_3.30.3-1_arm64.deb ... 157s Unpacking cmake (3.30.3-1) ... 157s Selecting previously unselected package icu-devtools. 157s Preparing to unpack .../40-icu-devtools_74.2-1ubuntu4_arm64.deb ... 157s Unpacking icu-devtools (74.2-1ubuntu4) ... 157s Selecting previously unselected package libicu-dev:arm64. 157s Preparing to unpack .../41-libicu-dev_74.2-1ubuntu4_arm64.deb ... 157s Unpacking libicu-dev:arm64 (74.2-1ubuntu4) ... 157s Selecting previously unselected package libio-pty-perl. 157s Preparing to unpack .../42-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 157s Unpacking libio-pty-perl (1:1.20-1build3) ... 157s Selecting previously unselected package libipc-run-perl. 157s Preparing to unpack .../43-libipc-run-perl_20231003.0-2_all.deb ... 157s Unpacking libipc-run-perl (20231003.0-2) ... 157s Selecting previously unselected package libncurses-dev:arm64. 157s Preparing to unpack .../44-libncurses-dev_6.5-2_arm64.deb ... 157s Unpacking libncurses-dev:arm64 (6.5-2) ... 157s Selecting previously unselected package libpq5:arm64. 157s Preparing to unpack .../45-libpq5_17.1-1_arm64.deb ... 157s Unpacking libpq5:arm64 (17.1-1) ... 157s Selecting previously unselected package libssl-dev:arm64. 157s Preparing to unpack .../46-libssl-dev_3.3.1-2ubuntu2_arm64.deb ... 157s Unpacking libssl-dev:arm64 (3.3.1-2ubuntu2) ... 157s Selecting previously unselected package libpq-dev. 158s Preparing to unpack .../47-libpq-dev_17.1-1_arm64.deb ... 158s Unpacking libpq-dev (17.1-1) ... 158s Selecting previously unselected package liblzma-dev:arm64. 158s Preparing to unpack .../48-liblzma-dev_5.6.2-2_arm64.deb ... 158s Unpacking liblzma-dev:arm64 (5.6.2-2) ... 158s Selecting previously unselected package zlib1g-dev:arm64. 158s Preparing to unpack .../49-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_arm64.deb ... 158s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 158s Selecting previously unselected package libxml2-dev:arm64. 158s Preparing to unpack .../50-libxml2-dev_2.12.7+dfsg-3_arm64.deb ... 158s Unpacking libxml2-dev:arm64 (2.12.7+dfsg-3) ... 158s Selecting previously unselected package libxslt1.1:arm64. 158s Preparing to unpack .../51-libxslt1.1_1.1.39-0exp1ubuntu1_arm64.deb ... 158s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 158s Selecting previously unselected package llvm-19-runtime. 158s Preparing to unpack .../52-llvm-19-runtime_1%3a19.1.2-1ubuntu1_arm64.deb ... 158s Unpacking llvm-19-runtime (1:19.1.2-1ubuntu1) ... 158s Selecting previously unselected package libpfm4:arm64. 158s Preparing to unpack .../53-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 158s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 158s Selecting previously unselected package llvm-19. 158s Preparing to unpack .../54-llvm-19_1%3a19.1.2-1ubuntu1_arm64.deb ... 158s Unpacking llvm-19 (1:19.1.2-1ubuntu1) ... 158s Selecting previously unselected package libffi-dev:arm64. 158s Preparing to unpack .../55-libffi-dev_3.4.6-1build1_arm64.deb ... 158s Unpacking libffi-dev:arm64 (3.4.6-1build1) ... 158s Selecting previously unselected package llvm-19-tools. 158s Preparing to unpack .../56-llvm-19-tools_1%3a19.1.2-1ubuntu1_arm64.deb ... 158s Unpacking llvm-19-tools (1:19.1.2-1ubuntu1) ... 158s Selecting previously unselected package llvm-19-dev. 158s Preparing to unpack .../57-llvm-19-dev_1%3a19.1.2-1ubuntu1_arm64.deb ... 158s Unpacking llvm-19-dev (1:19.1.2-1ubuntu1) ... 160s Selecting previously unselected package postgresql-client-17. 160s Preparing to unpack .../58-postgresql-client-17_17.1-1_arm64.deb ... 160s Unpacking postgresql-client-17 (17.1-1) ... 160s Selecting previously unselected package postgresql-17. 160s Preparing to unpack .../59-postgresql-17_17.1-1_arm64.deb ... 160s Unpacking postgresql-17 (17.1-1) ... 161s Selecting previously unselected package postgresql-17-timescaledb. 161s Preparing to unpack .../60-postgresql-17-timescaledb_2.17.2+dfsg-1_arm64.deb ... 161s Unpacking postgresql-17-timescaledb (2.17.2+dfsg-1) ... 161s Selecting previously unselected package postgresql-client-16. 161s Preparing to unpack .../61-postgresql-client-16_16.4-3_arm64.deb ... 161s Unpacking postgresql-client-16 (16.4-3) ... 161s Selecting previously unselected package postgresql-server-dev-16. 161s Preparing to unpack .../62-postgresql-server-dev-16_16.4-3_arm64.deb ... 161s Unpacking postgresql-server-dev-16 (16.4-3) ... 161s Selecting previously unselected package postgresql-server-dev-all:arm64. 161s Preparing to unpack .../63-postgresql-server-dev-all_262_arm64.deb ... 161s Unpacking postgresql-server-dev-all:arm64 (262) ... 161s Selecting previously unselected package tzdata-legacy. 161s Preparing to unpack .../64-tzdata-legacy_2024b-1ubuntu2_all.deb ... 161s Unpacking tzdata-legacy (2024b-1ubuntu2) ... 161s Selecting previously unselected package autopkgtest-satdep. 161s Preparing to unpack .../65-1-autopkgtest-satdep.deb ... 161s Unpacking autopkgtest-satdep (0) ... 161s Setting up postgresql-client-common (262) ... 161s Setting up libncurses-dev:arm64 (6.5-2) ... 161s Setting up libio-pty-perl (1:1.20-1build3) ... 161s Setting up libclang-common-19-dev:arm64 (1:19.1.2-1ubuntu1) ... 161s Setting up libpq5:arm64 (17.1-1) ... 161s Setting up libgomp1:arm64 (14.2.0-8ubuntu1) ... 161s Setting up libffi-dev:arm64 (3.4.6-1build1) ... 161s Setting up tzdata-legacy (2024b-1ubuntu2) ... 161s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 161s Setting up ssl-cert (1.1.2ubuntu2) ... 162s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 162s Setting up libssl-dev:arm64 (3.3.1-2ubuntu2) ... 162s Setting up libmpc3:arm64 (1.3.1-1build2) ... 162s Setting up libjsoncpp25:arm64 (1.9.5-6build1) ... 162s Setting up icu-devtools (74.2-1ubuntu4) ... 162s Setting up libipc-run-perl (20231003.0-2) ... 162s Setting up libgc1:arm64 (1:8.2.8-1) ... 162s Setting up liblzma-dev:arm64 (5.6.2-2) ... 162s Setting up libubsan1:arm64 (14.2.0-8ubuntu1) ... 162s Setting up zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 162s Setting up libhwasan0:arm64 (14.2.0-8ubuntu1) ... 162s Setting up librhash0:arm64 (1.4.3-3build1) ... 162s Setting up libasan8:arm64 (14.2.0-8ubuntu1) ... 162s Setting up libjson-perl (4.10000-1) ... 162s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu1) ... 162s Setting up cmake-data (3.30.3-1) ... 162s Setting up llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 162s Setting up libtsan2:arm64 (14.2.0-8ubuntu1) ... 162s Setting up libisl23:arm64 (0.27-1) ... 162s Setting up llvm-19-runtime (1:19.1.2-1ubuntu1) ... 162s Setting up llvm-19-tools (1:19.1.2-1ubuntu1) ... 162s Setting up libicu-dev:arm64 (74.2-1ubuntu4) ... 162s Setting up libcc1-0:arm64 (14.2.0-8ubuntu1) ... 162s Setting up liblsan0:arm64 (14.2.0-8ubuntu1) ... 162s Setting up libitm1:arm64 (14.2.0-8ubuntu1) ... 162s Setting up libclang-cpp19 (1:19.1.2-1ubuntu1) ... 162s Setting up postgresql-client-17 (17.1-1) ... 162s 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 162s Setting up postgresql-client-16 (16.4-3) ... 163s Setting up libpq-dev (17.1-1) ... 163s Setting up libobjc4:arm64 (14.2.0-8ubuntu1) ... 163s Setting up libxml2-dev:arm64 (2.12.7+dfsg-3) ... 163s Setting up postgresql-common (262) ... 163s 163s Creating config file /etc/postgresql-common/createcluster.conf with new version 164s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 164s Removing obsolete dictionary files: 164s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 164s Setting up cpp-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 164s Setting up cmake (3.30.3-1) ... 164s Setting up llvm-19 (1:19.1.2-1ubuntu1) ... 164s Setting up libgcc-14-dev:arm64 (14.2.0-8ubuntu1) ... 164s Setting up libstdc++-14-dev:arm64 (14.2.0-8ubuntu1) ... 164s Setting up postgresql-17 (17.1-1) ... 165s Creating new PostgreSQL cluster 17/main ... 165s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 165s The files belonging to this database system will be owned by user "postgres". 165s This user must also own the server process. 165s 165s The database cluster will be initialized with locale "C.UTF-8". 165s The default database encoding has accordingly been set to "UTF8". 165s The default text search configuration will be set to "english". 165s 165s Data page checksums are disabled. 165s 165s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 165s creating subdirectories ... ok 165s selecting dynamic shared memory implementation ... posix 165s selecting default "max_connections" ... 100 165s selecting default "shared_buffers" ... 128MB 165s selecting default time zone ... Etc/UTC 165s creating configuration files ... ok 165s running bootstrap script ... ok 165s performing post-bootstrap initialization ... ok 165s syncing data to disk ... ok 169s Setting up postgresql-17-timescaledb (2.17.2+dfsg-1) ... 169s Setting up libobjc-14-dev:arm64 (14.2.0-8ubuntu1) ... 169s Setting up clang-19 (1:19.1.2-1ubuntu1) ... 169s Setting up cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 169s Setting up llvm-19-dev (1:19.1.2-1ubuntu1) ... 169s Setting up postgresql-server-dev-16 (16.4-3) ... 169s Setting up cpp-14 (14.2.0-8ubuntu1) ... 169s Setting up cpp (4:14.1.0-2ubuntu1) ... 169s Setting up gcc-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 169s Setting up postgresql-server-dev-all:arm64 (262) ... 169s Setting up gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 169s Setting up g++-14-aarch64-linux-gnu (14.2.0-8ubuntu1) ... 169s Setting up gcc-14 (14.2.0-8ubuntu1) ... 169s Setting up g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 169s Setting up g++-14 (14.2.0-8ubuntu1) ... 169s Setting up gcc (4:14.1.0-2ubuntu1) ... 169s Setting up g++ (4:14.1.0-2ubuntu1) ... 169s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 169s Setting up build-essential (12.10ubuntu1) ... 169s Setting up autopkgtest-satdep (0) ... 169s Processing triggers for systemd (256.5-2ubuntu4) ... 169s Processing triggers for man-db (2.13.0-1) ... 171s Processing triggers for install-info (7.1.1-1) ... 171s Processing triggers for libc-bin (2.40-1ubuntu3) ... 174s (Reading database ... 92909 files and directories currently installed.) 174s Removing autopkgtest-satdep (0) ... 175s autopkgtest [03:20:16]: test installcheck: [----------------------- 175s + id -u 175s + [ 1000 = 0 ] 175s + EXIT=0 175s + pg_buildext installed-versions 175s ### PostgreSQL 17 ### 175s + echo ### PostgreSQL 17 ### 175s + rm -rf test-17 175s + mkdir test-17 175s + cmake -B test-17 -DPG_CONFIG=/usr/lib/postgresql/17/bin/pg_config -DAPACHE_ONLY=1 175s -- The C compiler identification is GNU 14.2.0 175s -- Detecting C compiler ABI info 175s -- Detecting C compiler ABI info - done 175s -- Check for working C compiler: /usr/bin/cc - skipped 175s -- Detecting C compile features 175s -- Detecting C compile features - done 175s -- TimescaleDB version 2.17.2. Can be updated from version 2.17.1 175s -- Build type is Release 175s -- Install method is 'source' 175s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG 176s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG - Success 176s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION 176s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION - Success 176s -- Performing Test CC_STRINGOP_TRUNCATION 176s -- Performing Test CC_STRINGOP_TRUNCATION - Success 176s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH 176s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH - Success 176s -- Performing Test CC_SUPPORTS_NEWLINE_EOF 176s -- Performing Test CC_SUPPORTS_NEWLINE_EOF - Failed 176s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN 176s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success 176s -- Using compiler GNU 176s -- Could NOT find Git (missing: GIT_EXECUTABLE) 176s -- Compiling against PostgreSQL version 17.1 using pg_config '/usr/lib/postgresql/17/bin/pg_config' 176s -- Assertion checks are OFF 176s -- Looking for USE_OPENSSL 176s -- Looking for USE_OPENSSL - found 176s -- Found Perl: /usr/bin/perl (found suitable version "5.40.0", minimum required is "5.8") 176s -- Using nm /usr/bin/nm 176s -- Not generating downgrade script: downgrade generation disabled. 176s -- Using pg_regress /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress 176s -- Using pg_isolation_regress /usr/lib/postgresql/17/lib/pgxs/src/test/isolation/pg_isolation_regress 176s -- Configuring done (1.3s) 176s -- Generating done (0.1s) 176s -- Build files have been written to: /tmp/autopkgtest.znLjvU/build.KI6/src/test-17 176s + make -C test-17/ installcheck PSQL=/usr/lib/postgresql/17/bin/psql 176s make: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 176s make[1]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[2]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[3]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[3]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[3]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s SKIPS: 177s No TAP tests to run for the current configuration, skipping... 177s make[3]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s Built target provecheck 177s make[3]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[3]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s make[3]: Entering directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 177s TESTS 177s SKIPS 177s # initializing database system by running initdb 177s # using temp instance on port 55432 with PID 4937 178s ok 1 - alter 527 ms 178s ok 2 - alternate_users 391 ms 179s ok 3 - chunk_utils 642 ms 180s ok 4 - index 441 ms 180s ok 5 - tablespace 377 ms 191s # parallel group (21 tests): custom_type catalog_corruption create_chunks copy_where chunks cluster-17 ddl_extra ddl_errors cursor baserel_cache create_table delete ddl debug_utils constraint drop_extension create_hypertable agg_bookends-17 copy chunk_adaptive append-17 191s ok 6 + agg_bookends-17 5307 ms 191s ok 7 + append-17 11138 ms 191s ok 8 + baserel_cache 4224 ms 191s ok 9 + catalog_corruption 4185 ms 191s ok 10 + chunk_adaptive 7182 ms 191s ok 11 + chunks 4199 ms 191s ok 12 + cluster-17 4200 ms 191s ok 13 + constraint 4990 ms 191s ok 14 + copy 6584 ms 191s ok 15 + copy_where 4195 ms 191s ok 16 + create_chunks 4172 ms 191s ok 17 + create_hypertable 5268 ms 191s ok 18 + create_table 4206 ms 191s ok 19 + cursor 4204 ms 191s ok 20 + custom_type 4041 ms 191s ok 21 + ddl 4815 ms 191s ok 22 + ddl_errors 4178 ms 191s ok 23 + ddl_extra 4177 ms 191s ok 24 + debug_utils 4855 ms 191s ok 25 + delete 4189 ms 191s ok 26 + drop_extension 5024 ms 205s # parallel group (21 tests): generated_as_identity insert_returning information_views drop_schema drop_hypertable drop_rename_hypertable lateral histogram_test-17 dump_meta null_exclusion-17 hash partition grant_hypertable-17 license drop_owned-17 insert_single merge extension_scripts insert_many insert-17 parallel-17 205s ok 27 + drop_hypertable 4355 ms 205s ok 28 + drop_owned-17 4812 ms 205s ok 29 + drop_rename_hypertable 4354 ms 205s ok 30 + drop_schema 4342 ms 205s ok 31 + dump_meta 4363 ms 205s ok 32 + extension_scripts 5547 ms 205s ok 33 + generated_as_identity 3876 ms 205s ok 34 + grant_hypertable-17 4375 ms 205s ok 35 + hash 4366 ms 205s ok 36 + histogram_test-17 4350 ms 205s ok 37 + information_views 4332 ms 205s ok 38 + insert-17 6662 ms 205s ok 39 + insert_many 6103 ms 205s ok 40 + insert_returning 4318 ms 205s ok 41 + insert_single 4789 ms 205s ok 42 + lateral 4326 ms 205s ok 43 + license 4361 ms 205s ok 44 + merge 4994 ms 205s ok 45 + null_exclusion-17 4333 ms 205s ok 46 + parallel-17 13086 ms 205s ok 47 + partition 4341 ms 217s # parallel group (21 tests): partitioning repair sort_optimization timestamp-17 plain plan_hypertable_inline sql_query tableam tableam_alter partitionwise-17 reloptions truncate plan_expand_hypertable-17 relocate_extension query-17 triggers size_utils plan_hashagg-17 plan_ordered_append-17 pg_join rowsecurity-17 217s not ok 48 + partitioning 8900 ms 217s # (test process exited with exit code 2) 217s not ok 49 + partitionwise-17 8925 ms 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s not ok 50 + pg_join 9065 ms 217s # (test process exited with exit code 2) 217s not ok 51 + plain 8903 ms 217s not ok 52 + plan_expand_hypertable-17 9022 ms 217s not ok 53 + plan_hashagg-17 9043 ms 217s not ok 54 + plan_hypertable_inline 8896 ms 217s not ok 55 + plan_ordered_append-17 9043 ms 217s not ok 56 + query-17 9026 ms 217s not ok 57 + relocate_extension 9008 ms 217s not ok 58 + reloptions 8907 ms 217s not ok 59 + repair 8877 ms 217s not ok 60 + rowsecurity-17 12961 ms 217s not ok 61 + size_utils 9018 ms 217s not ok 62 + sort_optimization 8858 ms 217s not ok 63 + sql_query 8862 ms 217s not ok 64 + tableam 8873 ms 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s not ok 65 + tableam_alter 8873 ms 217s # (test process exited with exit code 2) 217s not ok 66 + timestamp-17 8857 ms 217s # (test process exited with exit code 2) 217s not ok 67 + triggers 8979 ms 217s # (test process exited with exit code 2) 217s not ok 68 + truncate 8959 ms 217s # parallel group (8 tests): # (test process exited with exit code 2) 217s vacuum update trusted_extension ts_merge-17 vacuum_parallel version upsert util 217s not ok 69 + trusted_extension 152 ms 217s # (test process exited with exit code 2) 217s # (test process exited with exit code 2) 217s not ok 70 + ts_merge-17 158 ms 217s # (test process exited with exit code 2) 217s not ok 71 + update 146 ms 217s # (test process exited with exit code 2) 217s not ok 72 + upsert 147 ms 217s # (test process exited with exit code 2) 217s not ok 73 + util 151 ms 217s # (test process exited with exit code 2) 217s not ok 74 + vacuum 116 ms 217s # (test process exited with exit code 2) 217s not ok 75 + vacuum_parallel 131 ms 217s # (test process exited with exit code 2) 217s not ok 76 + version 134 ms 218s 1..76 218s # 29 of 76 tests failed. 218s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/regression.diffs". 218s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/regression.out". 218s make[3]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 218s make[3]: *** [test/CMakeFiles/regresscheck.dir/build.make:70: test/CMakeFiles/regresscheck] Error 1 218s make[2]: *** [CMakeFiles/Makefile2:571: test/CMakeFiles/regresscheck.dir/all] Error 2 218s make[2]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 218s make[1]: *** [CMakeFiles/Makefile2:710: test/CMakeFiles/installcheck.dir/rule] Error 2 218s make[1]: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 218s make: Leaving directory '/tmp/autopkgtest.znLjvU/build.KI6/src/test-17' 218s make: *** [Makefile:273: installcheck] Error 2 218s + tail -n1000 test-17/test/log/initdb.log test-17/test/log/postmaster.log test-17/test/regression.diffs 218s ==> test-17/test/log/initdb.log <== 218s Running in no-clean mode. Mistakes will not be cleaned up. 218s The files belonging to this database system will be owned by user "ubuntu". 218s This user must also own the server process. 218s 218s The database cluster will be initialized with this locale configuration: 218s locale provider: libc 218s LC_COLLATE: C.UTF-8 218s LC_CTYPE: C.UTF-8 218s LC_MESSAGES: C 218s LC_MONETARY: C.UTF-8 218s LC_NUMERIC: C.UTF-8 218s LC_TIME: C.UTF-8 218s The default database encoding has accordingly been set to "UTF8". 218s The default text search configuration will be set to "english". 218s 218s Data page checksums are disabled. 218s 218s creating directory /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/testcluster/data ... ok 218s creating subdirectories ... ok 218s selecting dynamic shared memory implementation ... posix 218s selecting default "max_connections" ... 100 218s selecting default "shared_buffers" ... 128MB 218s selecting default time zone ... Etc/UTC 218s creating configuration files ... ok 218s running bootstrap script ... ok 218s performing post-bootstrap initialization ... ok 218s 218s Sync to disk skipped. 218s The data directory might become corrupt if the operating system crashes. 218s 218s initdb: warning: enabling "trust" authentication for local connections 218s 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. 218s 218s Success. You can now start the database server using: 218s 218s /usr/lib/postgresql/17/bin/pg_ctl -D /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/testcluster/data -l logfile start 218s 218s 218s ==> test-17/test/log/postmaster.log <== 218s 2024-11-15 03:20:18.680 UTC: [4937] LOG: redirecting log output to logging collector process 218s 2024-11-15 03:20:18.680 UTC: [4937] HINT: Future log output will appear in directory "log". 218s 218s ==> test-17/test/regression.diffs <== 218s - 1257894000000000000 | dev2 | 1.5 | 2 | | 218s - 1257894000000001000 | dev1 | 2.5 | 3 | | 218s - 1257894001000000000 | dev1 | 3.5 | 4 | | 218s - 1257894002000000000 | dev1 | 2.5 | 3 | | 218s - 1257894002000000000 | dev1 | 5.5 | 8 | | f 218s - 1257894002000000000 | dev1 | 5.5 | 8 | | t 218s - 1257897600000000000 | dev1 | 4.5 | 5 | | f 218s - 1257987600000000000 | dev1 | 1.5 | 1 | | 218s - 1257987600000000000 | dev1 | 1.5 | 2 | | 218s -(12 rows) 218s - 218s -UPDATE "one_Partition" SET series_1 = 47; 218s -UPDATE "one_Partition" SET series_bool = true; 218s -SELECT * FROM "one_Partition" ORDER BY "timeCustom", device_id, series_0, series_1, series_2; 218s - timeCustom | device_id | series_0 | series_1 | series_2 | series_bool 218s ----------------------+-----------+----------+----------+----------+------------- 218s - 1257894000000000000 | dev1 | 1.5 | 47 | 2 | t 218s - 1257894000000000000 | dev1 | 1.5 | 47 | | t 218s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 218s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 218s - 1257894000000001000 | dev1 | 2.5 | 47 | | t 218s - 1257894001000000000 | dev1 | 3.5 | 47 | | t 218s - 1257894002000000000 | dev1 | 2.5 | 47 | | t 218s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 218s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 218s - 1257897600000000000 | dev1 | 4.5 | 47 | | t 218s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 218s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 218s -(12 rows) 218s - 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s diff -u /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/upsert.out /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/upsert.out 218s --- /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/upsert.out 2024-11-06 18:23:51.000000000 +0000 218s +++ /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/upsert.out 2024-11-15 03:20:58.859157709 +0000 218s @@ -1,643 +1,2 @@ 218s --- This file and its contents are licensed under the Apache License 2.0. 218s --- Please see the included NOTICE for copyright information and 218s --- LICENSE-APACHE for a copy of the license. 218s -CREATE TABLE upsert_test(time timestamp PRIMARY KEY, temp float, color text); 218s -SELECT create_hypertable('upsert_test', 'time'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s - create_hypertable 218s --------------------------- 218s - (1,public,upsert_test,t) 218s -(1 row) 218s - 218s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 218s -(1 row) 218s - 218s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 23.8, 'yellow') ON CONFLICT (time) 218s -DO UPDATE SET temp = 23.8 RETURNING *; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 218s -(1 row) 218s - 218s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 78.4, 'yellow') ON CONFLICT DO NOTHING; 218s -SELECT * FROM upsert_test; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 218s -(1 row) 218s - 218s --- Test 'Tuples Inserted' and 'Conflicting Tuples' values in EXPLAIN ANALYZE 218s -EXPLAIN (VERBOSE, ANALYZE, COSTS FALSE, TIMING FALSE, SUMMARY FALSE) 218s - INSERT INTO upsert_test VALUES 218s - ('2017-01-20T09:00:01', 28.5, 'blue'), 218s - ('2017-01-20T09:00:01', 21.9, 'red'), 218s - ('2017-01-20T10:00:01', 2.4, 'pink') ON CONFLICT DO NOTHING; 218s - QUERY PLAN 218s ----------------------------------------------------------------------------------------- 218s - Custom Scan (HypertableModify) (actual rows=0 loops=1) 218s - -> Insert on public.upsert_test (actual rows=0 loops=1) 218s - Conflict Resolution: NOTHING 218s - Tuples Inserted: 1 218s - Conflicting Tuples: 2 218s - -> Custom Scan (ChunkDispatch) (actual rows=3 loops=1) 218s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 218s - -> Values Scan on "*VALUES*" (actual rows=3 loops=1) 218s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 218s -(9 rows) 218s - 218s --- Test ON CONFLICT ON CONSTRAINT 218s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 12.3, 'yellow') ON CONFLICT ON CONSTRAINT upsert_test_pkey 218s -DO UPDATE SET temp = 12.3 RETURNING time, temp, color; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 12.3 | yellow 218s -(1 row) 218s - 218s --- Test that update generates error on conflicts 218s -\set ON_ERROR_STOP 0 218s -INSERT INTO upsert_test VALUES ('2017-01-21T09:00:01', 22.5, 'yellow') RETURNING *; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Sat Jan 21 09:00:01 2017 | 22.5 | yellow 218s -(1 row) 218s - 218s -UPDATE upsert_test SET time = '2017-01-20T09:00:01'; 218s -ERROR: duplicate key value violates unique constraint "1_1_upsert_test_pkey" 218s -\set ON_ERROR_STOP 1 218s --- Test with UNIQUE index on multiple columns instead of PRIMARY KEY constraint 218s -CREATE TABLE upsert_test_unique(time timestamp, temp float, color text); 218s -SELECT create_hypertable('upsert_test_unique', 'time'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ---------------------------------- 218s - (2,public,upsert_test_unique,t) 218s -(1 row) 218s - 218s -CREATE UNIQUE INDEX time_color_idx ON upsert_test_unique (time, color); 218s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 21.2, 'brown'); 218s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 218s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 218s -(2 rows) 218s - 218s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 31.8, 'yellow') ON CONFLICT (time, color) 218s -DO UPDATE SET temp = 31.8; 218s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 54.3, 'yellow') ON CONFLICT DO NOTHING; 218s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 31.8 | yellow 218s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 218s -(2 rows) 218s - 218s --- Test with multiple UNIQUE indexes 218s -CREATE TABLE upsert_test_multi_unique(time timestamp, temp float, color text); 218s -SELECT create_hypertable('upsert_test_multi_unique', 'time'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ---------------------------------------- 218s - (3,public,upsert_test_multi_unique,t) 218s -(1 row) 218s - 218s -ALTER TABLE upsert_test_multi_unique ADD CONSTRAINT multi_time_temp UNIQUE (time, temp); 218s -CREATE UNIQUE INDEX multi_time_color_idx ON upsert_test_multi_unique (time, color); 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'yellow'); 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 25.9, 'yellow'); 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'brown'); 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'purple') ON CONFLICT DO NOTHING; 218s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow 218s - Fri Jan 20 09:00:01 2017 | 23.5 | brown 218s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 218s -(3 rows) 218s - 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'blue') ON CONFLICT (time, temp) 218s -DO UPDATE SET color = 'blue'; 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 218s -DO UPDATE SET color = excluded.color; 218s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 218s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 218s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 218s -(3 rows) 218s - 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 45.7, 'yellow') ON CONFLICT (time, color) 218s -DO UPDATE SET temp = 45.7; 218s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 218s - time | temp | color 218s ---------------------------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 218s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 218s - Sat Jan 21 09:00:01 2017 | 45.7 | yellow 218s -(3 rows) 218s - 218s -\set ON_ERROR_STOP 0 218s --- Here the constraint in the ON CONFLICT clause is not the one that is 218s --- actually violated by the INSERT, so it should still fail. 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'purple') ON CONFLICT (time, color) 218s -DO UPDATE set temp = 23.5; 218s -ERROR: duplicate key value violates unique constraint "3_2_multi_time_temp" 218s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 22.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 218s -DO UPDATE set color = 'orange'; 218s -ERROR: duplicate key value violates unique constraint "_hyper_3_3_chunk_multi_time_color_idx" 218s -\set ON_ERROR_STOP 1 218s -CREATE TABLE upsert_test_space(time timestamp, device_id_1 char(20), to_drop int, temp float, color text); 218s ---drop two columns; create one. 218s -ALTER TABLE upsert_test_space DROP to_drop; 218s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id char(20); 218s -ALTER TABLE upsert_test_space ADD CONSTRAINT time_space_constraint UNIQUE (time, device_id); 218s -SELECT create_hypertable('upsert_test_space', 'time', 'device_id', 2, partitioning_func=>'_timescaledb_functions.get_partition_for_key'::regproc); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s --------------------------------- 218s - (4,public,upsert_test_space,t) 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 218s - time | temp | color | device_id 218s ---------------------------+------+--------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow | dev1 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow'); 218s -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) 218s -DO UPDATE SET color = excluded.color; 218s -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 218s -DO UPDATE SET color = excluded.color; 218s -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) 218s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 218s - time | temp | color | device_id 218s ---------------------------+------+-----------------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 218s -(1 row) 218s - 218s -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) 218s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 218s - time | temp | color | device_id 218s ---------------------------+------+-----------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 218s -(1 row) 218s - 218s -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) 218s -DO NOTHING RETURNING *; 218s - time | temp | color | device_id 218s -------+------+-------+----------- 218s -(0 rows) 218s - 218s -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) 218s -DO NOTHING RETURNING *; 218s - time | temp | color | device_id 218s ---------------------------+------+---------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev4 218s -(1 row) 218s - 218s -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) 218s -DO NOTHING RETURNING *; 218s - time | temp | color | device_id 218s ---------------------------+------+---------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev5 218s -(1 row) 218s - 218s -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 218s -DO NOTHING RETURNING *; 218s - time | temp | color | device_id 218s -------+------+-------+----------- 218s -(0 rows) 218s - 218s ---restore a column with the same name as a previously deleted one; 218s -ALTER TABLE upsert_test_space ADD device_id_1 char(20); 218s -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) 218s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+--------------------------------+----------------------+------------- 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 218s -(1 row) 218s - 218s -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) 218s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s -------+------+-------+-----------+------------- 218s -(0 rows) 218s - 218s -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) 218s -DO UPDATE SET color = excluded.color WHERE excluded.temp < 20 RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s -------+------+-------+-----------+------------- 218s -(0 rows) 218s - 218s -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) 218s -DO UPDATE SET color = excluded.color, temp=excluded.temp WHERE excluded.temp < 20 RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+---------+----------------------+------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange7 | dev5 | 218s -(1 row) 218s - 218s -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) 218s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+---------+----------------------+------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | 218s -(1 row) 218s - 218s -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) 218s -DO UPDATE SET device_id_1 = excluded.device_id_1 RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+---------+----------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-1-new 218s -(1 row) 218s - 218s -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) 218s -DO UPDATE SET device_id_1 = 'device-id-1-new-2', color = 'orange9' RETURNING *; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+---------+----------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 218s -(1 row) 218s - 218s -SELECT * FROM upsert_test_space; 218s - time | temp | color | device_id | device_id_1 218s ---------------------------+------+--------------------------------+----------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 25.9 | orange | dev1 | 218s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 | 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 | 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 218s -(5 rows) 218s - 218s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id_2 char(20); 218s -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') 218s -ON CONFLICT (time, device_id) 218s -DO UPDATE SET device_id_2 = 'device-id-2-new', color = 'orange10' RETURNING *; 218s - time | temp | color | device_id | device_id_2 218s ---------------------------+------+----------+----------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange10 | dev5 | device-id-2-new 218s -(1 row) 218s - 218s ---test inserting to to a chunk already in the chunk dispatch cache again. 218s -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'), 218s -('2018-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-2'), 218s -('2017-01-20T09:00:01', 'dev3', 43.5, 'orange7', 'device-id-2'), 218s -('2018-01-21T09:00:01', 'dev5', 43.5, 'orange9', 'device-id-2') 218s -ON CONFLICT (time, device_id) 218s -DO UPDATE SET device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), color = coalesce(excluded.color,current.color) RETURNING *; 218s - time | temp | color | device_id | device_id_2 218s ---------------------------+------+---------+----------------------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-2 218s - Sat Jan 20 09:00:01 2018 | 43.5 | orange8 | dev5 | device-id-2 218s - Fri Jan 20 09:00:01 2017 | 23.5 | orange7 | dev3 | device-id-2 218s - Sun Jan 21 09:00:01 2018 | 43.5 | orange9 | dev5 | device-id-2 218s -(4 rows) 218s - 218s -WITH CTE AS ( 218s - INSERT INTO upsert_test_multi_unique 218s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 218s - ON CONFLICT DO NOTHING 218s - RETURNING * 218s -) SELECT 1; 218s - ?column? 218s ----------- 218s - 1 218s -(1 row) 218s - 218s -WITH CTE AS ( 218s - INSERT INTO upsert_test_multi_unique 218s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple'), 218s - ('2017-01-20T09:00:01', 29.9, 'purple1') 218s - ON CONFLICT DO NOTHING 218s - RETURNING * 218s -) SELECT * FROM CTE; 218s - time | temp | color 218s ---------------------------+------+--------- 218s - Fri Jan 20 09:00:01 2017 | 29.9 | purple1 218s -(1 row) 218s - 218s -WITH CTE AS ( 218s - INSERT INTO upsert_test_multi_unique 218s - VALUES ('2017-01-20T09:00:01', 25.9, 'blue') 218s - ON CONFLICT (time, temp) DO UPDATE SET color = 'blue' 218s - RETURNING * 218s -) 218s -SELECT * FROM CTE; 218s - time | temp | color 218s ---------------------------+------+------- 218s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 218s -(1 row) 218s - 218s ---test error conditions when an index is dropped on a chunk 218s -DROP INDEX _timescaledb_internal._hyper_3_3_chunk_multi_time_color_idx; 218s ---everything is ok if not used as an arbiter index 218s -INSERT INTO upsert_test_multi_unique 218s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 218s -ON CONFLICT DO NOTHING 218s -RETURNING *; 218s - time | temp | color 218s -------+------+------- 218s -(0 rows) 218s - 218s ---errors out if used as an arbiter index 218s -\set ON_ERROR_STOP 0 218s -INSERT INTO upsert_test_multi_unique 218s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 218s -ON CONFLICT (time, color) DO NOTHING 218s -RETURNING *; 218s -ERROR: could not find arbiter index for hypertable index "multi_time_color_idx" on chunk "_hyper_3_3_chunk" 218s -\set ON_ERROR_STOP 1 218s ---create table with one chunk that has a tup_conv_map and one that does not 218s ---to ensure this, create a chunk before altering the table this chunk will not have a tup_conv_map 218s -CREATE TABLE upsert_test_diffchunk(time timestamp, device_id char(20), to_drop int, temp float, color text); 218s -SELECT create_hypertable('upsert_test_diffchunk', 'time', chunk_time_interval=> interval '1 month'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ------------------------------------- 218s - (5,public,upsert_test_diffchunk,t) 218s -(1 row) 218s - 218s -CREATE UNIQUE INDEX time_device_idx ON upsert_test_diffchunk (time, device_id); 218s ---this is the chunk with no tup_conv_map 218s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 218s - time | device_id | to_drop | temp | color 218s ---------------------------+----------------------+---------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | dev1 | | 25.9 | yellow 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow') RETURNING *; 218s - time | device_id | to_drop | temp | color 218s ---------------------------+----------------------+---------+------+-------- 218s - Fri Jan 20 09:00:01 2017 | dev2 | | 25.9 | yellow 218s -(1 row) 218s - 218s ---alter the table 218s -ALTER TABLE upsert_test_diffchunk DROP to_drop; 218s -ALTER TABLE upsert_test_diffchunk ADD device_id_2 char(20); 218s ---new chunk that does have a tup conv map 218s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev1', 23.5, 'orange') ; 218s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev2', 23.5, 'orange') ; 218s -select * from upsert_test_diffchunk order by time, device_id; 218s - time | device_id | temp | color | device_id_2 218s ---------------------------+----------------------+------+--------+------------- 218s - Fri Jan 20 09:00:01 2017 | dev1 | 25.9 | yellow | 218s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 218s - Sun Jan 20 09:00:01 2019 | dev1 | 23.5 | orange | 218s - Sun Jan 20 09:00:01 2019 | dev2 | 23.5 | orange | 218s -(4 rows) 218s - 218s ---make sure current works 218s -INSERT INTO upsert_test_diffchunk as current (time, device_id, temp, color, device_id_2) VALUES 218s -('2019-01-20T09:00:01', 'dev1', 43.5, 'orange2', 'device-id-2'), 218s -('2017-01-20T09:00:01', 'dev1', 43.5, 'yellow2', 'device-id-2'), 218s -('2019-01-20T09:00:01', 'dev2', 43.5, 'orange2', 'device-id-2') 218s -ON CONFLICT (time, device_id) 218s -DO UPDATE SET 218s -device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), 218s -temp = coalesce(excluded.temp,current.temp) , 218s -color = coalesce(excluded.color,current.color); 218s -select * from upsert_test_diffchunk order by time, device_id; 218s - time | device_id | temp | color | device_id_2 218s ---------------------------+----------------------+------+---------+---------------------- 218s - Fri Jan 20 09:00:01 2017 | dev1 | 43.5 | yellow2 | device-id-2 218s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 218s - Sun Jan 20 09:00:01 2019 | dev1 | 43.5 | orange2 | device-id-2 218s - Sun Jan 20 09:00:01 2019 | dev2 | 43.5 | orange2 | device-id-2 218s -(4 rows) 218s - 218s ---arbiter index tests 218s -CREATE TABLE upsert_test_arbiter(time timestamp, to_drop int); 218s -SELECT create_hypertable('upsert_test_arbiter', 'time', chunk_time_interval=> interval '1 month'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ----------------------------------- 218s - (6,public,upsert_test_arbiter,t) 218s -(1 row) 218s - 218s ---this is the chunk with no tup_conv_map 218s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-20T09:00:01', 1) RETURNING *; 218s - time | to_drop 218s ---------------------------+--------- 218s - Fri Jan 20 09:00:01 2017 | 1 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-21T09:00:01', 2) RETURNING *; 218s - time | to_drop 218s ---------------------------+--------- 218s - Sat Jan 21 09:00:01 2017 | 2 218s -(1 row) 218s - 218s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-03-20T09:00:01', 3) RETURNING *; 218s - time | to_drop 218s ---------------------------+--------- 218s - Mon Mar 20 09:00:01 2017 | 3 218s -(1 row) 218s - 218s ---alter the table 218s -ALTER TABLE upsert_test_arbiter DROP to_drop; 218s -ALTER TABLE upsert_test_arbiter ADD device_id char(20) DEFAULT 'dev1'; 218s -CREATE UNIQUE INDEX arbiter_time_device_idx ON upsert_test_arbiter (time, device_id); 218s -INSERT INTO upsert_test_arbiter as current (time, device_id) VALUES 218s - ('2018-01-21T09:00:01', 'dev1'), 218s - ('2017-01-20T09:00:01', 'dev1'), 218s - ('2017-01-21T09:00:01', 'dev2'), 218s - ('2018-01-21T09:00:01', 'dev2') 218s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = coalesce(excluded.device_id,current.device_id) 218s -RETURNING *; 218s - time | device_id 218s ---------------------------+---------------------- 218s - Sun Jan 21 09:00:01 2018 | dev1 218s - Fri Jan 20 09:00:01 2017 | dev1 218s - Sat Jan 21 09:00:01 2017 | dev2 218s - Sun Jan 21 09:00:01 2018 | dev2 218s -(4 rows) 218s - 218s -with cte as ( 218s -INSERT INTO upsert_test_arbiter (time, device_id) VALUES 218s - ('2017-01-21T09:00:01', 'dev2'), 218s - ('2018-01-21T09:00:01', 'dev2') 218s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = 'dev3' 218s -RETURNING *) 218s -select * from cte; 218s - time | device_id 218s ---------------------------+---------------------- 218s - Sat Jan 21 09:00:01 2017 | dev3 218s - Sun Jan 21 09:00:01 2018 | dev3 218s -(2 rows) 218s - 218s --- test ON CONFLICT with prepared statements 218s -CREATE TABLE prepared_test(time timestamptz PRIMARY KEY, value float CHECK(value > 0)); 218s -SELECT create_hypertable('prepared_test','time'); 218s - create_hypertable 218s ----------------------------- 218s - (7,public,prepared_test,t) 218s -(1 row) 218s - 218s -CREATE TABLE source_data(time timestamptz PRIMARY KEY, value float); 218s -INSERT INTO source_data VALUES('2000-01-01',0.5), ('2001-01-01',0.5); 218s --- at some point PostgreSQL will turn the plan into a generic plan 218s --- so we execute the prepared statement 10 times 218s --- check that an error in the prepared statement does not lead to the plan becoming unusable 218s -PREPARE prep_insert_select AS INSERT INTO prepared_test select * from source_data ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s -EXECUTE prep_insert_select; 218s ---this insert will create an invalid tuple in source_data 218s ---so that future calls to prep_insert_select will fail 218s -INSERT INTO source_data VALUES('2000-01-02',-0.5); 218s -\set ON_ERROR_STOP 0 218s -EXECUTE prep_insert_select; 218s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 218s -EXECUTE prep_insert_select; 218s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 218s -\set ON_ERROR_STOP 1 218s -DELETE FROM source_data WHERE value <= 0; 218s -EXECUTE prep_insert_select; 218s -PREPARE prep_insert AS INSERT INTO prepared_test VALUES('2000-01-01',0.5) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 218s --- at some point PostgreSQL will turn the plan into a generic plan 218s --- so we execute the prepared statement 10 times 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -EXECUTE prep_insert; 218s -SELECT * FROM prepared_test; 218s - time | value 218s -------------------------------+------- 218s - Sat Jan 01 00:00:00 2000 PST | 0.5 218s - Mon Jan 01 00:00:00 2001 PST | 0.5 218s -(2 rows) 218s - 218s -DELETE FROM prepared_test; 218s --- test ON CONFLICT with functions 218s -CREATE OR REPLACE FUNCTION test_upsert(t timestamptz, v float) RETURNS VOID AS $sql$ 218s -BEGIN 218s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 218s -END; 218s -$sql$ LANGUAGE PLPGSQL; 218s --- at some point PostgreSQL will turn the plan into a generic plan 218s --- so we execute the function 10 times 218s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 218s - counter | test_upsert 218s ----------+------------- 218s - 1 | 218s - 2 | 218s - 3 | 218s - 4 | 218s - 5 | 218s - 6 | 218s - 7 | 218s - 8 | 218s - 9 | 218s - 10 | 218s -(10 rows) 218s - 218s -SELECT * FROM prepared_test; 218s - time | value 218s -------------------------------+------- 218s - Sat Jan 01 00:00:00 2000 PST | 0.5 218s -(1 row) 218s - 218s -DELETE FROM prepared_test; 218s --- at some point PostgreSQL will turn the plan into a generic plan 218s --- so we execute the function 10 times 218s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 218s - counter | test_upsert 218s ----------+------------- 218s - 1 | 218s - 2 | 218s - 3 | 218s - 4 | 218s - 5 | 218s - 6 | 218s - 7 | 218s - 8 | 218s - 9 | 218s - 10 | 218s -(10 rows) 218s - 218s -SELECT * FROM prepared_test; 218s - time | value 218s -------------------------------+------- 218s - Sat Jan 01 00:00:00 2000 PST | 0.5 218s -(1 row) 218s - 218s -DELETE FROM prepared_test; 218s --- run it again to ensure INSERT path is still working as well 218s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 218s - counter | test_upsert 218s ----------+------------- 218s - 1 | 218s - 2 | 218s - 3 | 218s - 4 | 218s - 5 | 218s - 6 | 218s - 7 | 218s - 8 | 218s - 9 | 218s - 10 | 218s -(10 rows) 218s - 218s -SELECT * FROM prepared_test; 218s - time | value 218s -------------------------------+------- 218s - Sat Jan 01 00:00:00 2000 PST | 0.5 218s -(1 row) 218s - 218s -DELETE FROM prepared_test; 218s --- test ON CONFLICT with functions 218s -CREATE OR REPLACE FUNCTION test_upsert2(t timestamptz, v float) RETURNS VOID AS $sql$ 218s -BEGIN 218s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = prepared_test.value + 1.0; 218s -END; 218s -$sql$ LANGUAGE PLPGSQL; 218s --- at some point PostgreSQL will turn the plan into a generic plan 218s --- so we execute the function 10 times 218s -SELECT counter,test_upsert2('2000-01-01',1.0) FROM generate_series(1,10) AS g(counter); 218s - counter | test_upsert2 218s ----------+-------------- 218s - 1 | 218s - 2 | 218s - 3 | 218s - 4 | 218s - 5 | 218s - 6 | 218s - 7 | 218s - 8 | 218s - 9 | 218s - 10 | 218s -(10 rows) 218s - 218s -SELECT * FROM prepared_test; 218s - time | value 218s -------------------------------+------- 218s - Sat Jan 01 00:00:00 2000 PST | 10 218s -(1 row) 218s - 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s diff -u /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/util.out /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/util.out 218s --- /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/util.out 2024-11-06 18:23:51.000000000 +0000 218s +++ /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/util.out 2024-11-15 03:20:58.906163562 +0000 218s @@ -1,18 +1,2 @@ 218s --- This file and its contents are licensed under the Apache License 2.0. 218s --- Please see the included NOTICE for copyright information and 218s --- LICENSE-APACHE for a copy of the license. 218s -\set ECHO errors 218s - item 218s ------------------------------------- 218s - db_util_wizard=a/db_util_wizard 218s - db_util_wizard=ar/db_util_wizard 218s - db_util_wizard=a*/db_util_wizard 218s - db_util_wizard=a*r*/db_util_wizard 218s - [NULL] 218s - [NULL] 218s - [NULL] 218s - [NULL] 218s - =a*r*/db_util_wizard 218s - db_util_wizard=a*r*/0 218s -(10 rows) 218s - 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s diff -u /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/vacuum.out /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/vacuum.out 218s --- /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/vacuum.out 2024-11-06 18:23:51.000000000 +0000 218s +++ /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/vacuum.out 2024-11-15 03:20:58.870159079 +0000 218s @@ -1,228 +1,2 @@ 218s --- This file and its contents are licensed under the Apache License 2.0. 218s --- Please see the included NOTICE for copyright information and 218s --- LICENSE-APACHE for a copy of the license. 218s -CREATE TABLE vacuum_test(time timestamp, temp float); 218s --- create hypertable with three chunks 218s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s --------------------------- 218s - (1,public,vacuum_test,t) 218s -(1 row) 218s - 218s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 218s - ('2017-01-21T16:00:01', 19.1), 218s - ('2017-04-20T16:00:01', 89.5), 218s - ('2017-04-21T16:00:01', 17.1), 218s - ('2017-06-20T16:00:01', 18.5), 218s - ('2017-06-21T16:00:01', 11.0); 218s --- no stats 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -VACUUM ANALYZE vacuum_test; 218s --- stats should exist for all three chunks 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s -------------------+---------+---------------------------------------------------------+------------ 218s - _hyper_1_1_chunk | temp | {17.5,19.1} | -1 218s - _hyper_1_1_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 218s - _hyper_1_2_chunk | temp | {17.1,89.5} | -1 218s - _hyper_1_2_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 218s - _hyper_1_3_chunk | temp | {11,18.5} | -1 218s - _hyper_1_3_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 218s -(6 rows) 218s - 218s --- stats should exist on parent hypertable 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s --------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 218s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 218s - 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 218s -(2 rows) 218s - 218s -DROP TABLE vacuum_test; 218s ---test plain analyze (no_vacuum) 218s -CREATE TABLE analyze_test(time timestamp, temp float); 218s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ---------------------------- 218s - (2,public,analyze_test,t) 218s -(1 row) 218s - 218s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 218s - ('2017-01-21T16:00:01', 19.1), 218s - ('2017-04-20T16:00:01', 89.5), 218s - ('2017-04-21T16:00:01', 17.1), 218s - ('2017-06-20T16:00:01', + EXIT=1 218s + exit 1 218s 18.5), 218s - ('2017-06-21T16:00:01', 11.0); 218s --- no stats 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -ANALYZE VERBOSE analyze_test; 218s -INFO: analyzing "_timescaledb_internal._hyper_2_4_chunk" 218s -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 218s -INFO: analyzing "_timescaledb_internal._hyper_2_5_chunk" 218s -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 218s -INFO: analyzing "_timescaledb_internal._hyper_2_6_chunk" 218s -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 218s -INFO: analyzing "public.analyze_test" 218s -INFO: "analyze_test": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows 218s -INFO: analyzing "public.analyze_test" inheritance tree 218s -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 218s -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 218s -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 218s --- stats should exist for all three chunks 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s -------------------+---------+---------------------------------------------------------+------------ 218s - _hyper_2_4_chunk | temp | {17.5,19.1} | -1 218s - _hyper_2_4_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 218s - _hyper_2_5_chunk | temp | {17.1,89.5} | -1 218s - _hyper_2_5_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 218s - _hyper_2_6_chunk | temp | {11,18.5} | -1 218s - _hyper_2_6_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 218s -(6 rows) 218s - 218s --- stats should exist on parent hypertable 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 218s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 218s - 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 218s -(2 rows) 218s - 218s -DROP TABLE analyze_test; 218s --- Run vacuum on a normal (non-hypertable) table 218s -CREATE TABLE vacuum_norm(time timestamp, temp float); 218s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 218s - ('2017-01-21T09:00:01', 19.1), 218s - ('2017-04-20T09:00:01', 89.5), 218s - ('2017-04-21T09:00:01', 17.1), 218s - ('2017-06-20T09:00:01', 18.5), 218s - ('2017-06-21T09:00:01', 11.0); 218s -VACUUM ANALYZE vacuum_norm; 218s -DROP TABLE vacuum_norm; 218s ---Similar to normal vacuum tests, but PG11 introduced ability to vacuum multiple tables at once, we make sure that works for hypertables as well. 218s -CREATE TABLE vacuum_test(time timestamp, temp float); 218s --- create hypertable with three chunks 218s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s --------------------------- 218s - (3,public,vacuum_test,t) 218s -(1 row) 218s - 218s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 218s - ('2017-01-21T16:00:01', 19.1), 218s - ('2017-04-20T16:00:01', 89.5), 218s - ('2017-04-21T16:00:01', 17.1), 218s - ('2017-06-20T16:00:01', 18.5), 218s - ('2017-06-21T16:00:01', 11.0); 218s -CREATE TABLE analyze_test(time timestamp, temp float); 218s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s -NOTICE: adding not-null constraint to column "time" 218s - create_hypertable 218s ---------------------------- 218s - (4,public,analyze_test,t) 218s -(1 row) 218s - 218s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 218s - ('2017-01-21T16:00:01', 19.1), 218s - ('2017-04-20T16:00:01', 89.5), 218s - ('2017-04-21T16:00:01', 17.1), 218s - ('2017-06-20T16:00:01', 18.5), 218s - ('2017-06-21T16:00:01', 11.0); 218s -CREATE TABLE vacuum_norm(time timestamp, temp float); 218s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 218s - ('2017-01-21T09:00:01', 19.1), 218s - ('2017-04-20T09:00:01', 89.5), 218s - ('2017-04-21T09:00:01', 17.1), 218s - ('2017-06-20T09:00:01', 18.5), 218s - ('2017-06-21T09:00:01', 11.0); 218s --- no stats 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ------------+---------+------------------+------------ 218s -(0 rows) 218s - 218s -VACUUM ANALYZE vacuum_norm, vacuum_test, analyze_test; 218s --- stats should exist for all 6 chunks 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s --------------------+---------+---------------------------------------------------------+------------ 218s - _hyper_3_7_chunk | temp | {17.5,19.1} | -1 218s - _hyper_3_7_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 218s - _hyper_3_8_chunk | temp | {17.1,89.5} | -1 218s - _hyper_3_8_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 218s - _hyper_3_9_chunk | temp | {11,18.5} | -1 218s - _hyper_3_9_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 218s - _hyper_4_10_chunk | temp | {17.5,19.1} | -1 218s - _hyper_4_10_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 218s - _hyper_4_11_chunk | temp | {17.1,89.5} | -1 218s - _hyper_4_11_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 218s - _hyper_4_12_chunk | temp | {11,18.5} | -1 218s - _hyper_4_12_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 218s -(12 rows) 218s - 218s --- stats should exist on parent hypertable and normal table 218s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 218s -WHERE schemaname = 'public' 218s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 218s - tablename | attname | histogram_bounds | n_distinct 218s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 218s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 218s - 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 218s - vacuum_norm | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 218s - 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 218s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 218s - 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 218s -(6 rows) 218s - 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s diff -u /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/vacuum_parallel.out /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/vacuum_parallel.out 218s --- /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/vacuum_parallel.out 2024-11-06 18:23:51.000000000 +0000 218s +++ /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/vacuum_parallel.out 2024-11-15 03:20:58.885160947 +0000 218s @@ -1,39 +1,2 @@ 218s --- This file and its contents are licensed under the Apache License 2.0. 218s --- Please see the included NOTICE for copyright information and 218s --- LICENSE-APACHE for a copy of the license. 218s --- PG13 introduced parallel VACUUM functionality. It gets invoked when a table 218s --- has two or more indexes on it. Read up more at 218s --- https://www.postgresql.org/docs/13/sql-vacuum.html#PARALLEL 218s -CREATE TABLE vacuum_test(time timestamp NOT NULL, temp1 float, temp2 int); 218s --- create hypertable 218s --- we create chunks in public schema cause otherwise we would need 218s --- elevated privileges to create indexes directly 218s -SELECT create_hypertable('vacuum_test', 'time', create_default_indexes => false, associated_schema_name => 'public'); 218s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 218s - create_hypertable 218s --------------------------- 218s - (1,public,vacuum_test,t) 218s -(1 row) 218s - 218s --- parallel vacuum needs the index size to be larger than min_parallel_index_scan_size to kick in 218s -SET min_parallel_index_scan_size TO 0; 218s -INSERT INTO vacuum_test SELECT TIMESTAMP 'epoch' + (i * INTERVAL '4h'), 218s - i, i+1 FROM generate_series(1, 100) as T(i); 218s --- create indexes on the temp columns 218s --- we create indexes manually because otherwise vacuum verbose output 218s --- would be different between 13.2 and 13.3+ 218s --- 13.2 would try to vacuum the parent table index too while 13.3+ wouldn't 218s -CREATE INDEX ON _hyper_1_1_chunk(time); 218s -CREATE INDEX ON _hyper_1_1_chunk(temp1); 218s -CREATE INDEX ON _hyper_1_1_chunk(temp2); 218s -CREATE INDEX ON _hyper_1_2_chunk(time); 218s -CREATE INDEX ON _hyper_1_2_chunk(temp1); 218s -CREATE INDEX ON _hyper_1_2_chunk(temp2); 218s -CREATE INDEX ON _hyper_1_3_chunk(time); 218s -CREATE INDEX ON _hyper_1_3_chunk(temp1); 218s -CREATE INDEX ON _hyper_1_3_chunk(temp2); 218s --- INSERT only will not trigger vacuum on indexes for PG13.3+ 218s -UPDATE vacuum_test SET time = time + '1s'::interval, temp1 = random(), temp2 = random(); 218s --- we should see two parallel workers for each chunk 218s -VACUUM (PARALLEL 3) vacuum_test; 218s -DROP TABLE vacuum_test; 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s diff -u /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/version.out /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/version.out 218s --- /tmp/autopkgtest.znLjvU/build.KI6/src/test/expected/version.out 2024-11-06 18:23:51.000000000 +0000 218s +++ /tmp/autopkgtest.znLjvU/build.KI6/src/test-17/test/results/version.out 2024-11-15 03:20:58.880160324 +0000 218s @@ -1,10 +1,2 @@ 218s --- This file and its contents are licensed under the Apache License 2.0. 218s --- Please see the included NOTICE for copyright information and 218s --- LICENSE-APACHE for a copy of the license. 218s --- Test that get_os_info returns 3 x text 218s -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(); 218s - sysname_type | version_type | release_type 218s ---------------+--------------+-------------- 218s - text | text | text 218s -(1 row) 218s - 218s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 218s +DETAIL: Consistent recovery state has not been yet reached. 218s autopkgtest [03:20:59]: test installcheck: -----------------------] 218s autopkgtest [03:20:59]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 218s installcheck FAIL non-zero exit status 1 219s autopkgtest [03:21:00]: @@@@@@@@@@@@@@@@@@@@ summary 219s installcheck FAIL non-zero exit status 1 224s nova [W] Skipping flock in bos03-arm64 224s Creating nova instance adt-plucky-arm64-timescaledb-20241115-031721-juju-7f2275-prod-proposed-migration-environment-20-04111cab-024d-4bd7-bbd3-8b24a946bf6b from image adt/ubuntu-plucky-arm64-server-20241114.img (UUID 4472f5f7-859f-4441-9e8e-9550fb35f210)...