0s autopkgtest [14:53:09]: starting date and time: 2024-11-15 14:53:09+0000 0s autopkgtest [14:53:09]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [14:53:09]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.6sas6sg3/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-15@lcy02-10.secgroup --name adt-plucky-amd64-timescaledb-20241115-145309-juju-7f2275-prod-proposed-migration-environment-15-0e3d2d71-4230-4d88-9743-9a05ed147ec5 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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/ 53s autopkgtest [14:54:02]: testbed dpkg architecture: amd64 53s autopkgtest [14:54:02]: testbed apt version: 2.9.8 53s autopkgtest [14:54:02]: @@@@@@@@@@@@@@@@@@@@ test bed setup 53s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 54s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [96.6 kB] 54s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1067 kB] 54s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 54s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 54s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [181 kB] 54s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [113 kB] 54s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [32.6 kB] 54s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [302 kB] 54s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [843 kB] 54s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [740 B] 54s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [9416 B] 54s Fetched 2743 kB in 0s (6038 kB/s) 54s Reading package lists... 56s Reading package lists... 57s Building dependency tree... 57s Reading state information... 57s Calculating upgrade... 58s The following packages will be upgraded: 58s python3-markupsafe 58s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 58s Need to get 13.0 kB of archives. 58s After this operation, 15.4 kB of additional disk space will be used. 58s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-markupsafe amd64 2.1.5-1build3 [13.0 kB] 58s Fetched 13.0 kB in 0s (521 kB/s) 59s (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 ... 75575 files and directories currently installed.) 59s Preparing to unpack .../python3-markupsafe_2.1.5-1build3_amd64.deb ... 59s Unpacking python3-markupsafe (2.1.5-1build3) over (2.1.5-1build2) ... 59s Setting up python3-markupsafe (2.1.5-1build3) ... 59s Reading package lists... 60s Building dependency tree... 60s Reading state information... 60s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 61s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 61s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 61s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 61s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 62s Reading package lists... 62s Reading package lists... 63s Building dependency tree... 63s Reading state information... 63s Calculating upgrade... 63s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 65s autopkgtest [14:54:14]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 66s autopkgtest [14:54:15]: @@@@@@@@@@@@@@@@@@@@ apt-source timescaledb 66s Get:1 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (dsc) [2271 B] 66s Get:2 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (tar) [1298 kB] 66s Get:3 http://ftpmaster.internal/ubuntu plucky/universe timescaledb 2.17.2+dfsg-1 (diff) [4040 B] 67s gpgv: Signature made Thu Nov 7 12:39:30 2024 UTC 67s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 67s gpgv: Can't check signature: No public key 67s dpkg-source: warning: cannot verify inline signature for ./timescaledb_2.17.2+dfsg-1.dsc: no acceptable signature found 67s autopkgtest [14:54:16]: testing package timescaledb version 2.17.2+dfsg-1 67s autopkgtest [14:54:16]: build not needed 67s autopkgtest [14:54:16]: test installcheck: preparing testbed 68s Reading package lists... 69s Building dependency tree... 69s Reading state information... 69s Starting pkgProblemResolver with broken count: 0 69s Starting 2 pkgProblemResolver with broken count: 0 69s Done 70s The following additional packages will be installed: 70s build-essential clang-19 cmake cmake-data cpp cpp-14 cpp-14-x86-64-linux-gnu 70s cpp-x86-64-linux-gnu g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu 70s gcc gcc-14 gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu icu-devtools 70s libasan8 libcc1-0 libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 70s libgcc-14-dev libgomp1 libhwasan0 libicu-dev libio-pty-perl libipc-run-perl 70s libisl23 libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 70s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 70s librhash0 libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev 70s libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime 70s llvm-19-tools postgresql-17 postgresql-17-timescaledb postgresql-client-16 70s postgresql-client-17 postgresql-client-common postgresql-common 70s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 70s zlib1g-dev 70s Suggested packages: 70s clang-19-doc wasi-libc cmake-doc cmake-format elpa-cmake-mode ninja-build 70s cpp-doc gcc-14-locales cpp-14-doc g++-multilib g++-14-multilib gcc-14-doc 70s gcc-multilib manpages-dev autoconf automake libtool flex bison gdb gcc-doc 70s gcc-14-multilib gdb-x86-64-linux-gnu icu-doc liblzma-doc ncurses-doc 70s postgresql-doc-17 libssl-doc libstdc++-14-doc pkgconf llvm-19-doc 70s postgresql-16 postgresql-doc-16 70s Recommended packages: 70s libclang-rt-19-dev libjson-xs-perl 70s The following NEW packages will be installed: 70s autopkgtest-satdep build-essential clang-19 cmake cmake-data cpp cpp-14 70s cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu g++ g++-14 70s g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 70s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu icu-devtools libasan8 libcc1-0 70s libclang-common-19-dev libclang-cpp19 libffi-dev libgc1 libgcc-14-dev 70s libgomp1 libhwasan0 libicu-dev libio-pty-perl libipc-run-perl libisl23 70s libitm1 libjson-perl libjsoncpp25 liblsan0 liblzma-dev libmpc3 70s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 70s librhash0 libssl-dev libstdc++-14-dev libtsan2 libubsan1 libxml2-dev 70s libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime 70s llvm-19-tools postgresql-17 postgresql-17-timescaledb postgresql-client-16 70s postgresql-client-17 postgresql-client-common postgresql-common 70s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert tzdata-legacy 70s zlib1g-dev 70s 0 upgraded, 67 newly installed, 0 to remove and 0 not upgraded. 70s Need to get 201 MB/201 MB of archives. 70s After this operation, 953 MB of additional disk space will be used. 70s Get:1 /tmp/autopkgtest.hvKu8i/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [772 B] 70s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 70s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 70s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 70s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 70s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libisl23 amd64 0.27-1 [685 kB] 70s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 70s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-8ubuntu1 [11.9 MB] 70s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14 amd64 14.2.0-8ubuntu1 [1030 B] 70s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [5452 B] 70s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp amd64 4:14.1.0-2ubuntu1 [22.4 kB] 70s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libcc1-0 amd64 14.2.0-8ubuntu1 [47.6 kB] 70s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 libgomp1 amd64 14.2.0-8ubuntu1 [148 kB] 70s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 libitm1 amd64 14.2.0-8ubuntu1 [29.1 kB] 70s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 libasan8 amd64 14.2.0-8ubuntu1 [2998 kB] 70s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 liblsan0 amd64 14.2.0-8ubuntu1 [1317 kB] 70s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 libtsan2 amd64 14.2.0-8ubuntu1 [2732 kB] 70s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libubsan1 amd64 14.2.0-8ubuntu1 [1177 kB] 70s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 libhwasan0 amd64 14.2.0-8ubuntu1 [1634 kB] 70s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 libquadmath0 amd64 14.2.0-8ubuntu1 [153 kB] 70s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 libgcc-14-dev amd64 14.2.0-8ubuntu1 [2814 kB] 70s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-8ubuntu1 [23.3 MB] 70s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14 amd64 14.2.0-8ubuntu1 [528 kB] 70s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [1214 B] 70s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc amd64 4:14.1.0-2ubuntu1 [5000 B] 70s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 libstdc++-14-dev amd64 14.2.0-8ubuntu1 [2504 kB] 70s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-8ubuntu1 [13.3 MB] 70s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14 amd64 14.2.0-8ubuntu1 [19.9 kB] 70s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [966 B] 70s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 g++ amd64 4:14.1.0-2ubuntu1 [1100 B] 70s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 70s Get:32 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-cpp19 amd64 1:19.1.2-1ubuntu1 [14.2 MB] 71s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 71s Get:34 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc4 amd64 14.2.0-8ubuntu1 [47.1 kB] 71s Get:35 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc-14-dev amd64 14.2.0-8ubuntu1 [194 kB] 71s Get:36 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-common-19-dev amd64 1:19.1.2-1ubuntu1 [743 kB] 71s Get:37 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-linker-tools amd64 1:19.1.2-1ubuntu1 [1312 kB] 71s Get:38 http://ftpmaster.internal/ubuntu plucky/universe amd64 clang-19 amd64 1:19.1.2-1ubuntu1 [78.8 kB] 71s Get:39 http://ftpmaster.internal/ubuntu plucky/main amd64 libjsoncpp25 amd64 1.9.5-6build1 [82.8 kB] 71s Get:40 http://ftpmaster.internal/ubuntu plucky/main amd64 librhash0 amd64 1.4.3-3build1 [129 kB] 71s Get:41 http://ftpmaster.internal/ubuntu plucky/main amd64 cmake-data all 3.30.3-1 [2246 kB] 71s Get:42 http://ftpmaster.internal/ubuntu plucky/main amd64 cmake amd64 3.30.3-1 [12.0 MB] 71s Get:43 http://ftpmaster.internal/ubuntu plucky/main amd64 icu-devtools amd64 74.2-1ubuntu4 [213 kB] 71s Get:44 http://ftpmaster.internal/ubuntu plucky/main amd64 libicu-dev amd64 74.2-1ubuntu4 [11.9 MB] 71s Get:45 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 71s Get:46 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 71s Get:47 http://ftpmaster.internal/ubuntu plucky/main amd64 libncurses-dev amd64 6.5-2 [384 kB] 71s Get:48 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq5 amd64 17.1-1 [153 kB] 71s Get:49 http://ftpmaster.internal/ubuntu plucky/main amd64 libssl-dev amd64 3.3.1-2ubuntu2 [2686 kB] 71s Get:50 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq-dev amd64 17.1-1 [158 kB] 71s Get:51 http://ftpmaster.internal/ubuntu plucky/main amd64 liblzma-dev amd64 5.6.2-2 [176 kB] 71s Get:52 http://ftpmaster.internal/ubuntu plucky/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu1 [895 kB] 71s Get:53 http://ftpmaster.internal/ubuntu plucky/main amd64 libxml2-dev amd64 2.12.7+dfsg-3 [73.0 kB] 71s Get:54 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 71s Get:55 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-runtime amd64 1:19.1.2-1ubuntu1 [554 kB] 71s Get:56 http://ftpmaster.internal/ubuntu plucky/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 71s Get:57 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19 amd64 1:19.1.2-1ubuntu1 [17.8 MB] 71s Get:58 http://ftpmaster.internal/ubuntu plucky/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 71s Get:59 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-tools amd64 1:19.1.2-1ubuntu1 [539 kB] 71s Get:60 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-dev amd64 1:19.1.2-1ubuntu1 [47.3 MB] 71s Get:61 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-17 amd64 17.1-1 [1405 kB] 71s Get:62 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-17 amd64 17.1-1 [16.5 MB] 72s Get:63 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-timescaledb amd64 2.17.2+dfsg-1 [313 kB] 72s Get:64 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-16 amd64 16.4-3 [1278 kB] 72s Get:65 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-16 amd64 16.4-3 [1220 kB] 72s Get:66 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-all amd64 262 [20.7 kB] 72s Get:67 http://ftpmaster.internal/ubuntu plucky/main amd64 tzdata-legacy all 2024b-1ubuntu2 [99.9 kB] 72s Preconfiguring packages ... 72s Fetched 201 MB in 2s (107 MB/s) 72s Selecting previously unselected package libjson-perl. 72s (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 ... 75576 files and directories currently installed.) 72s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 72s Unpacking libjson-perl (4.10000-1) ... 72s Selecting previously unselected package postgresql-client-common. 72s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 72s Unpacking postgresql-client-common (262) ... 72s Selecting previously unselected package ssl-cert. 72s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 72s Unpacking ssl-cert (1.1.2ubuntu2) ... 72s Selecting previously unselected package postgresql-common. 72s Preparing to unpack .../03-postgresql-common_262_all.deb ... 72s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 72s Unpacking postgresql-common (262) ... 72s Selecting previously unselected package libisl23:amd64. 72s Preparing to unpack .../04-libisl23_0.27-1_amd64.deb ... 72s Unpacking libisl23:amd64 (0.27-1) ... 72s Selecting previously unselected package libmpc3:amd64. 72s Preparing to unpack .../05-libmpc3_1.3.1-1build2_amd64.deb ... 72s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 72s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 72s Preparing to unpack .../06-cpp-14-x86-64-linux-gnu_14.2.0-8ubuntu1_amd64.deb ... 72s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package cpp-14. 73s Preparing to unpack .../07-cpp-14_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking cpp-14 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package cpp-x86-64-linux-gnu. 73s Preparing to unpack .../08-cpp-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 73s Unpacking cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 73s Selecting previously unselected package cpp. 73s Preparing to unpack .../09-cpp_4%3a14.1.0-2ubuntu1_amd64.deb ... 73s Unpacking cpp (4:14.1.0-2ubuntu1) ... 73s Selecting previously unselected package libcc1-0:amd64. 73s Preparing to unpack .../10-libcc1-0_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libcc1-0:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libgomp1:amd64. 73s Preparing to unpack .../11-libgomp1_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libgomp1:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libitm1:amd64. 73s Preparing to unpack .../12-libitm1_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libitm1:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libasan8:amd64. 73s Preparing to unpack .../13-libasan8_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libasan8:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package liblsan0:amd64. 73s Preparing to unpack .../14-liblsan0_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking liblsan0:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libtsan2:amd64. 73s Preparing to unpack .../15-libtsan2_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libtsan2:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libubsan1:amd64. 73s Preparing to unpack .../16-libubsan1_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libubsan1:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libhwasan0:amd64. 73s Preparing to unpack .../17-libhwasan0_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libhwasan0:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libquadmath0:amd64. 73s Preparing to unpack .../18-libquadmath0_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libquadmath0:amd64 (14.2.0-8ubuntu1) ... 73s Selecting previously unselected package libgcc-14-dev:amd64. 73s Preparing to unpack .../19-libgcc-14-dev_14.2.0-8ubuntu1_amd64.deb ... 73s Unpacking libgcc-14-dev:amd64 (14.2.0-8ubuntu1) ... 74s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 74s Preparing to unpack .../20-gcc-14-x86-64-linux-gnu_14.2.0-8ubuntu1_amd64.deb ... 74s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 74s Selecting previously unselected package gcc-14. 74s Preparing to unpack .../21-gcc-14_14.2.0-8ubuntu1_amd64.deb ... 74s Unpacking gcc-14 (14.2.0-8ubuntu1) ... 74s Selecting previously unselected package gcc-x86-64-linux-gnu. 74s Preparing to unpack .../22-gcc-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 74s Unpacking gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 74s Selecting previously unselected package gcc. 74s Preparing to unpack .../23-gcc_4%3a14.1.0-2ubuntu1_amd64.deb ... 74s Unpacking gcc (4:14.1.0-2ubuntu1) ... 74s Selecting previously unselected package libstdc++-14-dev:amd64. 74s Preparing to unpack .../24-libstdc++-14-dev_14.2.0-8ubuntu1_amd64.deb ... 74s Unpacking libstdc++-14-dev:amd64 (14.2.0-8ubuntu1) ... 74s Selecting previously unselected package g++-14-x86-64-linux-gnu. 74s Preparing to unpack .../25-g++-14-x86-64-linux-gnu_14.2.0-8ubuntu1_amd64.deb ... 74s Unpacking g++-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 75s Selecting previously unselected package g++-14. 75s Preparing to unpack .../26-g++-14_14.2.0-8ubuntu1_amd64.deb ... 75s Unpacking g++-14 (14.2.0-8ubuntu1) ... 75s Selecting previously unselected package g++-x86-64-linux-gnu. 75s Preparing to unpack .../27-g++-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 75s Unpacking g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 75s Selecting previously unselected package g++. 75s Preparing to unpack .../28-g++_4%3a14.1.0-2ubuntu1_amd64.deb ... 75s Unpacking g++ (4:14.1.0-2ubuntu1) ... 75s Selecting previously unselected package build-essential. 75s Preparing to unpack .../29-build-essential_12.10ubuntu1_amd64.deb ... 75s Unpacking build-essential (12.10ubuntu1) ... 75s Selecting previously unselected package libclang-cpp19. 75s Preparing to unpack .../30-libclang-cpp19_1%3a19.1.2-1ubuntu1_amd64.deb ... 75s Unpacking libclang-cpp19 (1:19.1.2-1ubuntu1) ... 75s Selecting previously unselected package libgc1:amd64. 75s Preparing to unpack .../31-libgc1_1%3a8.2.8-1_amd64.deb ... 75s Unpacking libgc1:amd64 (1:8.2.8-1) ... 75s Selecting previously unselected package libobjc4:amd64. 75s Preparing to unpack .../32-libobjc4_14.2.0-8ubuntu1_amd64.deb ... 75s Unpacking libobjc4:amd64 (14.2.0-8ubuntu1) ... 75s Selecting previously unselected package libobjc-14-dev:amd64. 75s Preparing to unpack .../33-libobjc-14-dev_14.2.0-8ubuntu1_amd64.deb ... 75s Unpacking libobjc-14-dev:amd64 (14.2.0-8ubuntu1) ... 75s Selecting previously unselected package libclang-common-19-dev:amd64. 75s Preparing to unpack .../34-libclang-common-19-dev_1%3a19.1.2-1ubuntu1_amd64.deb ... 75s Unpacking libclang-common-19-dev:amd64 (1:19.1.2-1ubuntu1) ... 75s Selecting previously unselected package llvm-19-linker-tools. 75s Preparing to unpack .../35-llvm-19-linker-tools_1%3a19.1.2-1ubuntu1_amd64.deb ... 75s Unpacking llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 76s Selecting previously unselected package clang-19. 76s Preparing to unpack .../36-clang-19_1%3a19.1.2-1ubuntu1_amd64.deb ... 76s Unpacking clang-19 (1:19.1.2-1ubuntu1) ... 76s Selecting previously unselected package libjsoncpp25:amd64. 76s Preparing to unpack .../37-libjsoncpp25_1.9.5-6build1_amd64.deb ... 76s Unpacking libjsoncpp25:amd64 (1.9.5-6build1) ... 76s Selecting previously unselected package librhash0:amd64. 76s Preparing to unpack .../38-librhash0_1.4.3-3build1_amd64.deb ... 76s Unpacking librhash0:amd64 (1.4.3-3build1) ... 76s Selecting previously unselected package cmake-data. 76s Preparing to unpack .../39-cmake-data_3.30.3-1_all.deb ... 76s Unpacking cmake-data (3.30.3-1) ... 76s Selecting previously unselected package cmake. 76s Preparing to unpack .../40-cmake_3.30.3-1_amd64.deb ... 76s Unpacking cmake (3.30.3-1) ... 77s Selecting previously unselected package icu-devtools. 77s Preparing to unpack .../41-icu-devtools_74.2-1ubuntu4_amd64.deb ... 77s Unpacking icu-devtools (74.2-1ubuntu4) ... 77s Selecting previously unselected package libicu-dev:amd64. 77s Preparing to unpack .../42-libicu-dev_74.2-1ubuntu4_amd64.deb ... 77s Unpacking libicu-dev:amd64 (74.2-1ubuntu4) ... 77s Selecting previously unselected package libio-pty-perl. 77s Preparing to unpack .../43-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 77s Unpacking libio-pty-perl (1:1.20-1build3) ... 77s Selecting previously unselected package libipc-run-perl. 77s Preparing to unpack .../44-libipc-run-perl_20231003.0-2_all.deb ... 77s Unpacking libipc-run-perl (20231003.0-2) ... 77s Selecting previously unselected package libncurses-dev:amd64. 77s Preparing to unpack .../45-libncurses-dev_6.5-2_amd64.deb ... 77s Unpacking libncurses-dev:amd64 (6.5-2) ... 77s Selecting previously unselected package libpq5:amd64. 77s Preparing to unpack .../46-libpq5_17.1-1_amd64.deb ... 77s Unpacking libpq5:amd64 (17.1-1) ... 77s Selecting previously unselected package libssl-dev:amd64. 77s Preparing to unpack .../47-libssl-dev_3.3.1-2ubuntu2_amd64.deb ... 77s Unpacking libssl-dev:amd64 (3.3.1-2ubuntu2) ... 77s Selecting previously unselected package libpq-dev. 77s Preparing to unpack .../48-libpq-dev_17.1-1_amd64.deb ... 77s Unpacking libpq-dev (17.1-1) ... 77s Selecting previously unselected package liblzma-dev:amd64. 77s Preparing to unpack .../49-liblzma-dev_5.6.2-2_amd64.deb ... 77s Unpacking liblzma-dev:amd64 (5.6.2-2) ... 77s Selecting previously unselected package zlib1g-dev:amd64. 77s Preparing to unpack .../50-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_amd64.deb ... 77s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 77s Selecting previously unselected package libxml2-dev:amd64. 77s Preparing to unpack .../51-libxml2-dev_2.12.7+dfsg-3_amd64.deb ... 77s Unpacking libxml2-dev:amd64 (2.12.7+dfsg-3) ... 77s Selecting previously unselected package libxslt1.1:amd64. 77s Preparing to unpack .../52-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 77s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 77s Selecting previously unselected package llvm-19-runtime. 77s Preparing to unpack .../53-llvm-19-runtime_1%3a19.1.2-1ubuntu1_amd64.deb ... 77s Unpacking llvm-19-runtime (1:19.1.2-1ubuntu1) ... 77s Selecting previously unselected package libpfm4:amd64. 77s Preparing to unpack .../54-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 77s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 77s Selecting previously unselected package llvm-19. 77s Preparing to unpack .../55-llvm-19_1%3a19.1.2-1ubuntu1_amd64.deb ... 77s Unpacking llvm-19 (1:19.1.2-1ubuntu1) ... 78s Selecting previously unselected package libffi-dev:amd64. 78s Preparing to unpack .../56-libffi-dev_3.4.6-1build1_amd64.deb ... 78s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 78s Selecting previously unselected package llvm-19-tools. 78s Preparing to unpack .../57-llvm-19-tools_1%3a19.1.2-1ubuntu1_amd64.deb ... 78s Unpacking llvm-19-tools (1:19.1.2-1ubuntu1) ... 78s Selecting previously unselected package llvm-19-dev. 78s Preparing to unpack .../58-llvm-19-dev_1%3a19.1.2-1ubuntu1_amd64.deb ... 78s Unpacking llvm-19-dev (1:19.1.2-1ubuntu1) ... 80s Selecting previously unselected package postgresql-client-17. 80s Preparing to unpack .../59-postgresql-client-17_17.1-1_amd64.deb ... 80s Unpacking postgresql-client-17 (17.1-1) ... 80s Selecting previously unselected package postgresql-17. 80s Preparing to unpack .../60-postgresql-17_17.1-1_amd64.deb ... 80s Unpacking postgresql-17 (17.1-1) ... 81s Selecting previously unselected package postgresql-17-timescaledb. 81s Preparing to unpack .../61-postgresql-17-timescaledb_2.17.2+dfsg-1_amd64.deb ... 81s Unpacking postgresql-17-timescaledb (2.17.2+dfsg-1) ... 81s Selecting previously unselected package postgresql-client-16. 81s Preparing to unpack .../62-postgresql-client-16_16.4-3_amd64.deb ... 81s Unpacking postgresql-client-16 (16.4-3) ... 81s Selecting previously unselected package postgresql-server-dev-16. 81s Preparing to unpack .../63-postgresql-server-dev-16_16.4-3_amd64.deb ... 81s Unpacking postgresql-server-dev-16 (16.4-3) ... 81s Selecting previously unselected package postgresql-server-dev-all:amd64. 81s Preparing to unpack .../64-postgresql-server-dev-all_262_amd64.deb ... 81s Unpacking postgresql-server-dev-all:amd64 (262) ... 81s Selecting previously unselected package tzdata-legacy. 81s Preparing to unpack .../65-tzdata-legacy_2024b-1ubuntu2_all.deb ... 81s Unpacking tzdata-legacy (2024b-1ubuntu2) ... 82s Selecting previously unselected package autopkgtest-satdep. 82s Preparing to unpack .../66-1-autopkgtest-satdep.deb ... 82s Unpacking autopkgtest-satdep (0) ... 82s Setting up postgresql-client-common (262) ... 82s Setting up libncurses-dev:amd64 (6.5-2) ... 82s Setting up libio-pty-perl (1:1.20-1build3) ... 82s Setting up libclang-common-19-dev:amd64 (1:19.1.2-1ubuntu1) ... 82s Setting up libpq5:amd64 (17.1-1) ... 82s Setting up libgomp1:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 82s Setting up tzdata-legacy (2024b-1ubuntu2) ... 82s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 82s Setting up ssl-cert (1.1.2ubuntu2) ... 82s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 82s Setting up libquadmath0:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libssl-dev:amd64 (3.3.1-2ubuntu2) ... 82s Setting up libmpc3:amd64 (1.3.1-1build2) ... 82s Setting up libjsoncpp25:amd64 (1.9.5-6build1) ... 82s Setting up icu-devtools (74.2-1ubuntu4) ... 82s Setting up libipc-run-perl (20231003.0-2) ... 82s Setting up libgc1:amd64 (1:8.2.8-1) ... 82s Setting up liblzma-dev:amd64 (5.6.2-2) ... 82s Setting up libubsan1:amd64 (14.2.0-8ubuntu1) ... 82s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 82s Setting up libhwasan0:amd64 (14.2.0-8ubuntu1) ... 82s Setting up librhash0:amd64 (1.4.3-3build1) ... 82s Setting up libasan8:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libjson-perl (4.10000-1) ... 82s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 82s Setting up cmake-data (3.30.3-1) ... 82s Setting up llvm-19-linker-tools (1:19.1.2-1ubuntu1) ... 82s Setting up libtsan2:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libisl23:amd64 (0.27-1) ... 82s Setting up llvm-19-runtime (1:19.1.2-1ubuntu1) ... 82s Setting up llvm-19-tools (1:19.1.2-1ubuntu1) ... 82s Setting up libicu-dev:amd64 (74.2-1ubuntu4) ... 82s Setting up libcc1-0:amd64 (14.2.0-8ubuntu1) ... 82s Setting up liblsan0:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libitm1:amd64 (14.2.0-8ubuntu1) ... 82s Setting up libclang-cpp19 (1:19.1.2-1ubuntu1) ... 82s Setting up postgresql-client-17 (17.1-1) ... 83s 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 83s Setting up postgresql-client-16 (16.4-3) ... 84s Setting up libpq-dev (17.1-1) ... 84s Setting up libobjc4:amd64 (14.2.0-8ubuntu1) ... 84s Setting up libxml2-dev:amd64 (2.12.7+dfsg-3) ... 84s Setting up postgresql-common (262) ... 84s 84s Creating config file /etc/postgresql-common/createcluster.conf with new version 85s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 85s Removing obsolete dictionary files: 85s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 86s Setting up cpp-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 86s Setting up cpp-14 (14.2.0-8ubuntu1) ... 86s Setting up cmake (3.30.3-1) ... 86s Setting up llvm-19 (1:19.1.2-1ubuntu1) ... 86s Setting up libgcc-14-dev:amd64 (14.2.0-8ubuntu1) ... 86s Setting up libstdc++-14-dev:amd64 (14.2.0-8ubuntu1) ... 86s Setting up cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 86s Setting up postgresql-17 (17.1-1) ... 86s Creating new PostgreSQL cluster 17/main ... 86s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 86s The files belonging to this database system will be owned by user "postgres". 86s This user must also own the server process. 86s 86s The database cluster will be initialized with locale "C.UTF-8". 86s The default database encoding has accordingly been set to "UTF8". 86s The default text search configuration will be set to "english". 86s 86s Data page checksums are disabled. 86s 86s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 86s creating subdirectories ... ok 86s selecting dynamic shared memory implementation ... posix 86s selecting default "max_connections" ... 100 86s selecting default "shared_buffers" ... 128MB 86s selecting default time zone ... Etc/UTC 86s creating configuration files ... ok 87s running bootstrap script ... ok 87s performing post-bootstrap initialization ... ok 87s syncing data to disk ... ok 91s Setting up postgresql-17-timescaledb (2.17.2+dfsg-1) ... 91s Setting up libobjc-14-dev:amd64 (14.2.0-8ubuntu1) ... 91s Setting up clang-19 (1:19.1.2-1ubuntu1) ... 91s Setting up llvm-19-dev (1:19.1.2-1ubuntu1) ... 91s Setting up postgresql-server-dev-16 (16.4-3) ... 91s Setting up cpp (4:14.1.0-2ubuntu1) ... 91s Setting up gcc-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 91s Setting up postgresql-server-dev-all:amd64 (262) ... 91s Setting up gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 91s Setting up gcc-14 (14.2.0-8ubuntu1) ... 91s Setting up g++-14-x86-64-linux-gnu (14.2.0-8ubuntu1) ... 91s Setting up g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 91s Setting up g++-14 (14.2.0-8ubuntu1) ... 91s Setting up gcc (4:14.1.0-2ubuntu1) ... 91s Setting up g++ (4:14.1.0-2ubuntu1) ... 91s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 91s Setting up build-essential (12.10ubuntu1) ... 91s Setting up autopkgtest-satdep (0) ... 91s Processing triggers for systemd (256.5-2ubuntu4) ... 91s Processing triggers for man-db (2.13.0-1) ... 94s Processing triggers for install-info (7.1.1-1) ... 94s Processing triggers for libc-bin (2.40-1ubuntu3) ... 97s (Reading database ... 88645 files and directories currently installed.) 97s Removing autopkgtest-satdep (0) ... 98s autopkgtest [14:54:47]: test installcheck: [----------------------- 98s + id -u 98s + [ 1000 = 0 ] 98s + EXIT=0 98s + pg_buildext installed-versions 98s + echo ### PostgreSQL 17 ### 98s + rm -rf test-17 98s ### PostgreSQL 17 ### 98s + mkdir test-17 98s + cmake -B test-17 -DPG_CONFIG=/usr/lib/postgresql/17/bin/pg_config -DAPACHE_ONLY=1 98s -- The C compiler identification is GNU 14.2.0 98s -- Detecting C compiler ABI info 98s -- Detecting C compiler ABI info - done 98s -- Check for working C compiler: /usr/bin/cc - skipped 98s -- Detecting C compile features 98s -- Detecting C compile features - done 98s -- TimescaleDB version 2.17.2. Can be updated from version 2.17.1 98s -- Build type is Release 98s -- Install method is 'source' 98s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG 98s -- Performing Test CC_SUPPORTS_NO_UNUSED_CLI_ARG - Success 98s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION 98s -- Performing Test CC_SUPPORTS_NO_FORMAT_TRUNCATION - Success 98s -- Performing Test CC_STRINGOP_TRUNCATION 99s -- Performing Test CC_STRINGOP_TRUNCATION - Success 99s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH 99s -- Performing Test CC_SUPPORTS_IMPLICIT_FALLTHROUGH - Success 99s -- Performing Test CC_SUPPORTS_NEWLINE_EOF 99s -- Performing Test CC_SUPPORTS_NEWLINE_EOF - Failed 99s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN 99s -- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success 99s -- Using compiler GNU 99s -- Could NOT find Git (missing: GIT_EXECUTABLE) 99s -- Compiling against PostgreSQL version 17.1 using pg_config '/usr/lib/postgresql/17/bin/pg_config' 99s -- Assertion checks are OFF 99s -- Looking for USE_OPENSSL 99s -- Looking for USE_OPENSSL - found 99s -- Found Perl: /usr/bin/perl (found suitable version "5.40.0", minimum required is "5.8") 99s -- Using nm /usr/bin/nm 99s -- Not generating downgrade script: downgrade generation disabled. 99s -- Using pg_regress /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress 99s -- Using pg_isolation_regress /usr/lib/postgresql/17/lib/pgxs/src/test/isolation/pg_isolation_regress 99s -- Configuring done (1.5s) 100s -- Generating done (0.1s) 100s -- Build files have been written to: /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17 100s + make -C test-17/ installcheck PSQL=/usr/lib/postgresql/17/bin/psql 100s make: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[1]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[2]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[3]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[3]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[3]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s SKIPS: 100s No TAP tests to run for the current configuration, skipping... 100s make[3]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s Built target provecheck 100s make[3]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[3]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s make[3]: Entering directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 100s TESTS 100s SKIPS 100s # initializing database system by running initdb 100s # using temp instance on port 55432 with PID 5692 102s ok 1 - alter 773 ms 102s ok 2 - alternate_users 475 ms 103s ok 3 - chunk_utils 726 ms 103s ok 4 - index 524 ms 104s ok 5 - tablespace 451 ms 116s # parallel group (21 tests): baserel_cache custom_type ddl_extra ddl_errors chunks cluster-17 delete cursor create_chunks catalog_corruption copy_where create_table debug_utils ddl constraint drop_extension agg_bookends-17 create_hypertable chunk_adaptive copy append-17 116s ok 6 + agg_bookends-17 6681 ms 116s ok 7 + append-17 12517 ms 116s ok 8 + baserel_cache 5377 ms 116s ok 9 + catalog_corruption 5632 ms 116s ok 10 + chunk_adaptive 8501 ms 116s ok 11 + chunks 5588 ms 116s ok 12 + cluster-17 5598 ms 116s ok 13 + constraint 6388 ms 116s ok 14 + copy 8551 ms 116s ok 15 + copy_where 5621 ms 116s ok 16 + create_chunks 5613 ms 116s ok 17 + create_hypertable 6691 ms 116s ok 18 + create_table 5611 ms 116s ok 19 + cursor 5597 ms 116s ok 20 + custom_type 5543 ms 116s ok 21 + ddl 5719 ms 116s ok 22 + ddl_errors 5533 ms 116s ok 23 + ddl_extra 5527 ms 116s ok 24 + debug_utils 5646 ms 116s ok 25 + delete 5545 ms 116s ok 26 + drop_extension 6385 ms 131s # parallel group (21 tests): insert_returning null_exclusion-17 generated_as_identity drop_rename_hypertable hash drop_schema drop_hypertable histogram_test-17 license grant_hypertable-17 lateral dump_meta information_views partition insert_single drop_owned-17 merge extension_scripts insert_many insert-17 parallel-17 131s ok 27 + drop_hypertable 4770 ms 131s ok 28 + drop_owned-17 5107 ms 131s ok 29 + drop_rename_hypertable 4744 ms 131s ok 30 + drop_schema 4763 ms 131s ok 31 + dump_meta 4867 ms 131s ok 32 + extension_scripts 6503 ms 131s ok 33 + generated_as_identity 4720 ms 131s ok 34 + grant_hypertable-17 4787 ms 131s ok 35 + hash 4736 ms 131s ok 36 + histogram_test-17 4763 ms 131s ok 37 + information_views 4907 ms 131s ok 38 + insert-17 7410 ms 131s ok 39 + insert_many 6916 ms 131s ok 40 + insert_returning 4544 ms 131s ok 41 + insert_single 5020 ms 131s ok 42 + lateral 4757 ms 131s ok 43 + license 4748 ms 131s ok 44 + merge 5655 ms 131s ok 45 + null_exclusion-17 4670 ms 131s ok 46 + parallel-17 14269 ms 131s ok 47 + partition 4949 ms 146s # parallel group (21 tests): repair partitionwise-17 plain sort_optimization sql_query tableam_alter plan_hypertable_inline tableam timestamp-17 reloptions partitioning triggers plan_expand_hypertable-17 query-17 size_utils truncate relocate_extension plan_ordered_append-17 plan_hashagg-17 pg_join rowsecurity-17 146s not ok 48 + partitioning 10337 ms 146s # (test process exited with exit code 2) 146s # (test process exited with exit code 2) 146s not ok 49 + partitionwise-17 10309 ms 146s not ok 50 + pg_join 10519 ms 146s # (test process exited with exit code 2) 146s not ok 51 + plain 10305 ms 146s # (test process exited with exit code 2) 146s not ok 52 + plan_expand_hypertable-17 10463 ms 146s # (test process exited with exit code 2) 146s not ok 53 + plan_hashagg-17 10515 ms 146s # (test process exited with exit code 2) 146s not ok 54 + plan_hypertable_inline 10298 ms 146s # (test process exited with exit code 2) 146s not ok 55 + plan_ordered_append-17 10499 ms 146s # (test process exited with exit code 2) 146s not ok 56 + query-17 10471 ms 146s # (test process exited with exit code 2) 146s not ok 57 + relocate_extension 10482 ms 146s # (test process exited with exit code 2) 146s # (test process exited with exit code 2) 146s not ok 58 + reloptions 10300 ms 146s # (test process exited with exit code 2) 146s not ok 59 + repair 10259 ms 146s not ok 60 + rowsecurity-17 15642 ms 146s # (test process exited with exit code 2) 146s not ok 61 + size_utils 10453 ms 146s # (test process exited with exit code 2) 146s not ok 62 + sort_optimization 10271 ms 146s # (test process exited with exit code 2) 146s not ok 63 + sql_query 10270 ms 146s # (test process exited with exit code 2) 146s not ok 64 + tableam 10274 ms 146s not ok 65 + tableam_alter 10256 ms 146s not ok 66 + timestamp-17 10263 ms 146s # (test process exited with exit code 2) 146s # (test process exited with exit code 2) 146s # (test process exited with exit code 2) 146s not ok 67 + triggers 10364 ms 146s # (test process exited with exit code 2) 146s not ok 68 + truncate 10446 ms 146s # (test process exited with exit code 2) 147s # parallel group (8 tests): upsert ts_merge-17 version util update trusted_extension vacuum vacuum_parallel 147s not ok 69 + trusted_extension 367 ms 147s # (test process exited with exit code 2) 147s not ok 70 + ts_merge-17 272 ms 147s # (test process exited with exit code 2) 147s not ok 71 + update 315 ms 147s # (test process exited with exit code 2) 147s # (test process exited with exit code 2) 147s not ok 72 + upsert 248 ms 147s not ok 73 + util 305 ms 147s # (test process exited with exit code 2) 147s not ok 74 + vacuum 324 ms 147s # (test process exited with exit code 2) 147s # (test process exited with exit code 2) 147s not ok 75 + vacuum_parallel 324 ms 147s not ok 76 + version 261 ms 147s # (test process exited with exit code 2) 147s 1..76 147s # 29 of 76 tests failed. 147s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/regression.diffs". 147s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/regression.out". 147s make[3]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 147s make[3]: *** [test/CMakeFiles/regresscheck.dir/build.make:70: test/CMakeFiles/regresscheck] Error 1 147s make[2]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 147s make[1]: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 147s make[2]: *** [CMakeFiles/Makefile2:571: test/CMakeFiles/regresscheck.dir/all] Error 2 147s make: Leaving directory '/tmp/autopkgtest.hvKu8i/build.jdu/src/test-17' 147s make[1]: *** [CMakeFiles/Makefile2:710: test/CMakeFiles/installcheck.dir/rule] Error 2 147s make: *** [Makefile:273: installcheck] Error 2 147s + tail -n1000 test-17/test/log/initdb.log test-17/test/log/postmaster.log test-17/test/regression.diffs 147s ==> test-17/test/log/initdb.log <== 147s Running in no-clean mode. Mistakes will not be cleaned up. 147s The files belonging to this database system will be owned by user "ubuntu". 147s This user must also own the server process. 147s 147s The database cluster will be initialized with this locale configuration: 147s locale provider: libc 147s LC_COLLATE: C.UTF-8 147s LC_CTYPE: C.UTF-8 147s LC_MESSAGES: C 147s LC_MONETARY: C.UTF-8 147s LC_NUMERIC: C.UTF-8 147s LC_TIME: C.UTF-8 147s The default database encoding has accordingly been set to "UTF8". 147s The default text search configuration will be set to "english". 147s 147s Data page checksums are disabled. 147s 147s creating directory /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/testcluster/data ... ok 147s creating subdirectories ... ok 147s selecting dynamic shared memory implementation ... posix 147s selecting default "max_connections" ... 100 147s selecting default "shared_buffers" ... 128MB 147s selecting default time zone ... Etc/UTC 147s creating configuration files ... ok 147s running bootstrap script ... ok 147s performing post-bootstrap initialization ... ok 147s 147s Sync to disk skipped. 147s The data directory might become corrupt if the operating system crashes. 147s 147s initdb: warning: enabling "trust" authentication for local connections 147s 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. 147s 147s Success. You can now start the database server using: 147s 147s /usr/lib/postgresql/17/bin/pg_ctl -D /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/testcluster/data -l logfile start 147s 147s 147s ==> test-17/test/log/postmaster.log <== 147s 2024-11-15 14:54:49.887 UTC: [5692] LOG: redirecting log output to logging collector process 147s 2024-11-15 14:54:49.887 UTC: [5692] HINT: Future log output will appear in directory "log". 147s 147s ==> test-17/test/regression.diffs <== 147s - 1257894000000000000 | dev2 | 1.5 | 2 | | 147s - 1257894000000001000 | dev1 | 2.5 | 3 | | 147s - 1257894001000000000 | dev1 | 3.5 | 4 | | 147s - 1257894002000000000 | dev1 | 2.5 | 3 | | 147s - 1257894002000000000 | dev1 | 5.5 | 8 | | f 147s - 1257894002000000000 | dev1 | 5.5 | 8 | | t 147s - 1257897600000000000 | dev1 | 4.5 | 5 | | f 147s - 1257987600000000000 | dev1 | 1.5 | 1 | | 147s - 1257987600000000000 | dev1 | 1.5 | 2 | | 147s -(12 rows) 147s - 147s -UPDATE "one_Partition" SET series_1 = 47; 147s -UPDATE "one_Partition" SET series_bool = true; 147s -SELECT * FROM "one_Partition" ORDER BY "timeCustom", device_id, series_0, series_1, series_2; 147s - timeCustom | device_id | series_0 | series_1 | series_2 | series_bool 147s ----------------------+-----------+----------+----------+----------+------------- 147s - 1257894000000000000 | dev1 | 1.5 | 47 | 2 | t 147s - 1257894000000000000 | dev1 | 1.5 | 47 | | t 147s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 147s - 1257894000000000000 | dev2 | 1.5 | 47 | | t 147s - 1257894000000001000 | dev1 | 2.5 | 47 | | t 147s - 1257894001000000000 | dev1 | 3.5 | 47 | | t 147s - 1257894002000000000 | dev1 | 2.5 | 47 | | t 147s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 147s - 1257894002000000000 | dev1 | 5.5 | 47 | | t 147s - 1257897600000000000 | dev1 | 4.5 | 47 | | t 147s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 147s - 1257987600000000000 | dev1 | 1.5 | 47 | | t 147s -(12 rows) 147s - 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s diff -u /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/upsert.out /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/upsert.out 147s --- /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/upsert.out 2024-11-06 18:23:51.000000000 +0000 147s +++ /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/upsert.out 2024-11-15 14:55:36.090614701 +0000 147s @@ -1,643 +1,2 @@ 147s --- This file and its contents are licensed under the Apache License 2.0. 147s --- Please see the included NOTICE for copyright information and 147s --- LICENSE-APACHE for a copy of the license. 147s -CREATE TABLE upsert_test(time timestamp PRIMARY KEY, temp float, color text); 147s -SELECT create_hypertable('upsert_test', 'time'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s - create_hypertable 147s --------------------------- 147s - (1,public,upsert_test,t) 147s -(1 row) 147s - 147s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 147s -(1 row) 147s - 147s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 23.8, 'yellow') ON CONFLICT (time) 147s -DO UPDATE SET temp = 23.8 RETURNING *; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 147s -(1 row) 147s - 147s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 78.4, 'yellow') ON CONFLICT DO NOTHING; 147s -SELECT * FROM upsert_test; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 23.8 | yellow 147s -(1 row) 147s - 147s --- Test 'Tuples Inserted' and 'Conflicting Tuples' values in EXPLAIN ANALYZE 147s -EXPLAIN (VERBOSE, ANALYZE, COSTS FALSE, TIMING FALSE, SUMMARY FALSE) 147s - INSERT INTO upsert_test VALUES 147s - ('2017-01-20T09:00:01', 28.5, 'blue'), 147s - ('2017-01-20T09:00:01', 21.9, 'red'), 147s - ('2017-01-20T10:00:01', 2.4, 'pink') ON CONFLICT DO NOTHING; 147s - QUERY PLAN 147s ----------------------------------------------------------------------------------------- 147s - Custom Scan (HypertableModify) (actual rows=0 loops=1) 147s - -> Insert on public.upsert_test (actual rows=0 loops=1) 147s - Conflict Resolution: NOTHING 147s - Tuples Inserted: 1 147s - Conflicting Tuples: 2 147s - -> Custom Scan (ChunkDispatch) (actual rows=3 loops=1) 147s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 147s - -> Values Scan on "*VALUES*" (actual rows=3 loops=1) 147s - Output: "*VALUES*".column1, "*VALUES*".column2, "*VALUES*".column3 147s -(9 rows) 147s - 147s --- Test ON CONFLICT ON CONSTRAINT 147s -INSERT INTO upsert_test VALUES ('2017-01-20T09:00:01', 12.3, 'yellow') ON CONFLICT ON CONSTRAINT upsert_test_pkey 147s -DO UPDATE SET temp = 12.3 RETURNING time, temp, color; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 12.3 | yellow 147s -(1 row) 147s - 147s --- Test that update generates error on conflicts 147s -\set ON_ERROR_STOP 0 147s -INSERT INTO upsert_test VALUES ('2017-01-21T09:00:01', 22.5, 'yellow') RETURNING *; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Sat Jan 21 09:00:01 2017 | 22.5 | yellow 147s -(1 row) 147s - 147s -UPDATE upsert_test SET time = '2017-01-20T09:00:01'; 147s -ERROR: duplicate key value violates unique constraint "1_1_upsert_test_pkey" 147s -\set ON_ERROR_STOP 1 147s --- Test with UNIQUE index on multiple columns instead of PRIMARY KEY constraint 147s -CREATE TABLE upsert_test_unique(time timestamp, temp float, color text); 147s -SELECT create_hypertable('upsert_test_unique', 'time'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ---------------------------------- 147s - (2,public,upsert_test_unique,t) 147s -(1 row) 147s - 147s -CREATE UNIQUE INDEX time_color_idx ON upsert_test_unique (time, color); 147s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 22.5, 'yellow') RETURNING *; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 21.2, 'brown'); 147s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 22.5 | yellow 147s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 147s -(2 rows) 147s - 147s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 31.8, 'yellow') ON CONFLICT (time, color) 147s -DO UPDATE SET temp = 31.8; 147s -INSERT INTO upsert_test_unique VALUES ('2017-01-20T09:00:01', 54.3, 'yellow') ON CONFLICT DO NOTHING; 147s -SELECT * FROM upsert_test_unique ORDER BY time, color DESC; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 31.8 | yellow 147s - Fri Jan 20 09:00:01 2017 | 21.2 | brown 147s -(2 rows) 147s - 147s --- Test with multiple UNIQUE indexes 147s -CREATE TABLE upsert_test_multi_unique(time timestamp, temp float, color text); 147s -SELECT create_hypertable('upsert_test_multi_unique', 'time'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ---------------------------------------- 147s - (3,public,upsert_test_multi_unique,t) 147s -(1 row) 147s - 147s -ALTER TABLE upsert_test_multi_unique ADD CONSTRAINT multi_time_temp UNIQUE (time, temp); 147s -CREATE UNIQUE INDEX multi_time_color_idx ON upsert_test_multi_unique (time, color); 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'yellow'); 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 25.9, 'yellow'); 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'brown'); 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'purple') ON CONFLICT DO NOTHING; 147s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow 147s - Fri Jan 20 09:00:01 2017 | 23.5 | brown 147s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 147s -(3 rows) 147s - 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 25.9, 'blue') ON CONFLICT (time, temp) 147s -DO UPDATE SET color = 'blue'; 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 147s -DO UPDATE SET color = excluded.color; 147s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 147s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 147s - Sat Jan 21 09:00:01 2017 | 25.9 | yellow 147s -(3 rows) 147s - 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-21T09:00:01', 45.7, 'yellow') ON CONFLICT (time, color) 147s -DO UPDATE SET temp = 45.7; 147s -SELECT * FROM upsert_test_multi_unique ORDER BY time, color DESC; 147s - time | temp | color 147s ---------------------------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange 147s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 147s - Sat Jan 21 09:00:01 2017 | 45.7 | yellow 147s -(3 rows) 147s - 147s -\set ON_ERROR_STOP 0 147s --- Here the constraint in the ON CONFLICT clause is not the one that is 147s --- actually violated by the INSERT, so it should still fail. 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 23.5, 'purple') ON CONFLICT (time, color) 147s -DO UPDATE set temp = 23.5; 147s -ERROR: duplicate key value violates unique constraint "3_2_multi_time_temp" 147s -INSERT INTO upsert_test_multi_unique VALUES ('2017-01-20T09:00:01', 22.5, 'orange') ON CONFLICT ON CONSTRAINT multi_time_temp 147s -DO UPDATE set color = 'orange'; 147s -ERROR: duplicate key value violates unique constraint "_hyper_3_3_chunk_multi_time_color_idx" 147s -\set ON_ERROR_STOP 1 147s -CREATE TABLE upsert_test_space(time timestamp, device_id_1 char(20), to_drop int, temp float, color text); 147s ---drop two columns; create one. 147s -ALTER TABLE upsert_test_space DROP to_drop; 147s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id char(20); 147s -ALTER TABLE upsert_test_space ADD CONSTRAINT time_space_constraint UNIQUE (time, device_id); 147s -SELECT create_hypertable('upsert_test_space', 'time', 'device_id', 2, partitioning_func=>'_timescaledb_functions.get_partition_for_key'::regproc); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s --------------------------------- 147s - (4,public,upsert_test_space,t) 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 147s - time | temp | color | device_id 147s ---------------------------+------+--------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 25.9 | yellow | dev1 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_space (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow'); 147s -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) 147s -DO UPDATE SET color = excluded.color; 147s -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 147s -DO UPDATE SET color = excluded.color; 147s -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) 147s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 147s - time | temp | color | device_id 147s ---------------------------+------+-----------------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 147s -(1 row) 147s - 147s -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) 147s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 147s - time | temp | color | device_id 147s ---------------------------+------+-----------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 147s -(1 row) 147s - 147s -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) 147s -DO NOTHING RETURNING *; 147s - time | temp | color | device_id 147s -------+------+-------+----------- 147s -(0 rows) 147s - 147s -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) 147s -DO NOTHING RETURNING *; 147s - time | temp | color | device_id 147s ---------------------------+------+---------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev4 147s -(1 row) 147s - 147s -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) 147s -DO NOTHING RETURNING *; 147s - time | temp | color | device_id 147s ---------------------------+------+---------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5 | dev5 147s -(1 row) 147s - 147s -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 147s -DO NOTHING RETURNING *; 147s - time | temp | color | device_id 147s -------+------+-------+----------- 147s -(0 rows) 147s - 147s ---restore a column with the same name as a previously deleted one; 147s -ALTER TABLE upsert_test_space ADD device_id_1 char(20); 147s -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) 147s -DO UPDATE SET color = excluded.color||' (originally '|| upsert_test_space.color ||')' RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+--------------------------------+----------------------+------------- 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 147s -(1 row) 147s - 147s -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) 147s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s -------+------+-------+-----------+------------- 147s -(0 rows) 147s - 147s -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) 147s -DO UPDATE SET color = excluded.color WHERE excluded.temp < 20 RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s -------+------+-------+-----------+------------- 147s -(0 rows) 147s - 147s -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) 147s -DO UPDATE SET color = excluded.color, temp=excluded.temp WHERE excluded.temp < 20 RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+---------+----------------------+------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange7 | dev5 | 147s -(1 row) 147s - 147s -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) 147s -DO UPDATE SET color = excluded.color WHERE upsert_test_space.temp < 20 RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+---------+----------------------+------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | 147s -(1 row) 147s - 147s -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) 147s -DO UPDATE SET device_id_1 = excluded.device_id_1 RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+---------+----------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-1-new 147s -(1 row) 147s - 147s -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) 147s -DO UPDATE SET device_id_1 = 'device-id-1-new-2', color = 'orange9' RETURNING *; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+---------+----------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 147s -(1 row) 147s - 147s -SELECT * FROM upsert_test_space; 147s - time | temp | color | device_id | device_id_1 147s ---------------------------+------+--------------------------------+----------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 25.9 | orange | dev1 | 147s - Fri Jan 20 09:00:01 2017 | 25.9 | orange3 (originally yellow) | dev2 | 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange3.1 | dev3 | 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange5.1 (originally orange5) | dev4 | 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange9 | dev5 | device-id-1-new-2 147s -(5 rows) 147s - 147s -ALTER TABLE upsert_test_space DROP device_id_1, ADD device_id_2 char(20); 147s -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') 147s -ON CONFLICT (time, device_id) 147s -DO UPDATE SET device_id_2 = 'device-id-2-new', color = 'orange10' RETURNING *; 147s - time | temp | color | device_id | device_id_2 147s ---------------------------+------+----------+----------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange10 | dev5 | device-id-2-new 147s -(1 row) 147s - 147s ---test inserting to to a chunk already in the chunk dispatch cache again. 147s -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'), 147s -('2018-01-20T09:00:01', 'dev5', 43.5, 'orange8', 'device-id-2'), 147s -('2017-01-20T09:00:01', 'dev3', 43.5, 'orange7', 'device-id-2'), 147s -('2018-01-21T09:00:01', 'dev5', 43.5, 'orange9', 'device-id-2') 147s -ON CONFLICT (time, device_id) 147s -DO UPDATE SET device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), color = coalesce(excluded.color,current.color) RETURNING *; 147s - time | temp | color | device_id | device_id_2 147s ---------------------------+------+---------+----------------------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | 3.5 | orange8 | dev5 | device-id-2 147s - Sat Jan 20 09:00:01 2018 | 43.5 | orange8 | dev5 | device-id-2 147s - Fri Jan 20 09:00:01 2017 | 23.5 | orange7 | dev3 | device-id-2 147s - Sun Jan 21 09:00:01 2018 | 43.5 | orange9 | dev5 | device-id-2 147s -(4 rows) 147s - 147s -WITH CTE AS ( 147s - INSERT INTO upsert_test_multi_unique 147s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 147s - ON CONFLICT DO NOTHING 147s - RETURNING * 147s -) SELECT 1; 147s - ?column? 147s ----------- 147s - 1 147s -(1 row) 147s - 147s -WITH CTE AS ( 147s - INSERT INTO upsert_test_multi_unique 147s - VALUES ('2017-01-20T09:00:01', 25.9, 'purple'), 147s - ('2017-01-20T09:00:01', 29.9, 'purple1') 147s - ON CONFLICT DO NOTHING 147s - RETURNING * 147s -) SELECT * FROM CTE; 147s - time | temp | color 147s ---------------------------+------+--------- 147s - Fri Jan 20 09:00:01 2017 | 29.9 | purple1 147s -(1 row) 147s - 147s -WITH CTE AS ( 147s - INSERT INTO upsert_test_multi_unique 147s - VALUES ('2017-01-20T09:00:01', 25.9, 'blue') 147s - ON CONFLICT (time, temp) DO UPDATE SET color = 'blue' 147s - RETURNING * 147s -) 147s -SELECT * FROM CTE; 147s - time | temp | color 147s ---------------------------+------+------- 147s - Fri Jan 20 09:00:01 2017 | 25.9 | blue 147s -(1 row) 147s - 147s ---test error conditions when an index is dropped on a chunk 147s -DROP INDEX _timescaledb_internal._hyper_3_3_chunk_multi_time_color_idx; 147s ---everything is ok if not used as an arbiter index 147s -INSERT INTO upsert_test_multi_unique 147s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 147s -ON CONFLICT DO NOTHING 147s -RETURNING *; 147s - time | temp | color 147s -------+------+------- 147s -(0 rows) 147s - 147s ---errors out if used as an arbiter index 147s -\set ON_ERROR_STOP 0 147s -INSERT INTO upsert_test_multi_unique 147s -VALUES ('2017-01-20T09:00:01', 25.9, 'purple') 147s -ON CONFLICT (time, color) DO NOTHING 147s -RETURNING *; 147s -ERROR: could not find arbiter index for hypertable index "multi_time_color_idx" on chunk "_hyper_3_3_chunk" 147s -\set ON_ERROR_STOP 1 147s ---create table with one chunk that has a tup_conv_map and one that does not 147s ---to ensure this, create a chunk before altering the table this chunk will not have a tup_conv_map 147s -CREATE TABLE upsert_test_diffchunk(time timestamp, device_id char(20), to_drop int, temp float, color text); 147s -SELECT create_hypertable('upsert_test_diffchunk', 'time', chunk_time_interval=> interval '1 month'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ------------------------------------- 147s - (5,public,upsert_test_diffchunk,t) 147s -(1 row) 147s - 147s -CREATE UNIQUE INDEX time_device_idx ON upsert_test_diffchunk (time, device_id); 147s ---this is the chunk with no tup_conv_map 147s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev1', 25.9, 'yellow') RETURNING *; 147s - time | device_id | to_drop | temp | color 147s ---------------------------+----------------------+---------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | dev1 | | 25.9 | yellow 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2017-01-20T09:00:01', 'dev2', 25.9, 'yellow') RETURNING *; 147s - time | device_id | to_drop | temp | color 147s ---------------------------+----------------------+---------+------+-------- 147s - Fri Jan 20 09:00:01 2017 | dev2 | | 25.9 | yellow 147s -(1 row) 147s - 147s ---alter the table 147s -ALTER TABLE upsert_test_diffchunk DROP to_drop; 147s -ALTER TABLE upsert_test_diffchunk ADD device_id_2 char(20); 147s ---new chunk that does have a tup conv map 147s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev1', 23.5, 'orange') ; 147s -INSERT INTO upsert_test_diffchunk (time, device_id, temp, color) VALUES ('2019-01-20T09:00:01', 'dev2', 23.5, 'orange') ; 147s -select * from upsert_test_diffchunk order by time, device_id; 147s - time | device_id | temp | color | device_id_2 147s ---------------------------+----------------------+------+--------+------------- 147s - Fri Jan 20 09:00:01 2017 | dev1 | 25.9 | yellow | 147s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 147s - Sun Jan 20 09:00:01 2019 | dev1 | 23.5 | orange | 147s - Sun Jan 20 09:00:01 2019 | dev2 | 23.5 | orange | 147s -(4 rows) 147s - 147s ---make sure current works 147s -INSERT INTO upsert_test_diffchunk as current (time, device_id, temp, color, device_id_2) VALUES 147s -('2019-01-20T09:00:01', 'dev1', 43.5, 'orange2', 'device-id-2'), 147s -('2017-01-20T09:00:01', 'dev1', 43.5, 'yellow2', 'device-id-2'), 147s -('2019-01-20T09:00:01', 'dev2', 43.5, 'orange2', 'device-id-2') 147s -ON CONFLICT (time, device_id) 147s -DO UPDATE SET 147s -device_id_2 = coalesce(excluded.device_id_2,current.device_id_2), 147s -temp = coalesce(excluded.temp,current.temp) , 147s -color = coalesce(excluded.color,current.color); 147s -select * from upsert_test_diffchunk order by time, device_id; 147s - time | device_id | temp | color | device_id_2 147s ---------------------------+----------------------+------+---------+---------------------- 147s - Fri Jan 20 09:00:01 2017 | dev1 | 43.5 | yellow2 | device-id-2 147s - Fri Jan 20 09:00:01 2017 | dev2 | 25.9 | yellow | 147s - Sun Jan 20 09:00:01 2019 | dev1 | 43.5 | orange2 | device-id-2 147s - Sun Jan 20 09:00:01 2019 | dev2 | 43.5 | orange2 | device-id-2 147s -(4 rows) 147s - 147s ---arbiter index tests 147s -CREATE TABLE upsert_test_arbiter(time timestamp, to_drop int); 147s -SELECT create_hypertable('upsert_test_arbiter', 'time', chunk_time_interval=> interval '1 month'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ----------------------------------- 147s - (6,public,upsert_test_arbiter,t) 147s -(1 row) 147s - 147s ---this is the chunk with no tup_conv_map 147s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-20T09:00:01', 1) RETURNING *; 147s - time | to_drop 147s ---------------------------+--------- 147s - Fri Jan 20 09:00:01 2017 | 1 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-01-21T09:00:01', 2) RETURNING *; 147s - time | to_drop 147s ---------------------------+--------- 147s - Sat Jan 21 09:00:01 2017 | 2 147s -(1 row) 147s - 147s -INSERT INTO upsert_test_arbiter (time, to_drop) VALUES ('2017-03-20T09:00:01', 3) RETURNING *; 147s - time | to_drop 147s ---------------------------+--------- 147s - Mon Mar 20 09:00:01 2017 | 3 147s -(1 row) 147s - 147s ---alter the table 147s -ALTER TABLE upsert_test_arbiter DROP to_drop; 147s -ALTER TABLE upsert_test_arbiter ADD device_id char(20) DEFAULT 'dev1'; 147s -CREATE UNIQUE INDEX arbiter_time_device_idx ON upsert_test_arbiter (time, device_id); 147s -INSERT INTO upsert_test_arbiter as current (time, device_id) VALUES 147s - ('2018-01-21T09:00:01', 'dev1'), 147s - ('2017-01-20T09:00:01', 'dev1'), 147s - ('2017-01-21T09:00:01', 'dev2'), 147s - ('2018-01-21T09:00:01', 'dev2') 147s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = coalesce(excluded.device_id,current.device_id) 147s -RETURNING *; 147s - time | device_id 147s ---------------------------+---------------------- 147s - Sun Jan 21 09:00:01 2018 | dev1 147s - Fri Jan 20 09:00:01 2017 | dev1 147s - Sat Jan 21 09:00:01 2017 | dev2 147s - Sun Jan 21 09:00:01 2018 | dev2 147s -(4 rows) 147s - 147s -with cte as ( 147s -INSERT INTO upsert_test_arbiter (time, device_id) VALUES 147s - ('2017-01-21T09:00:01', 'dev2'), 147s - ('2018-01-21T09:00:01', 'dev2') 147s - ON CONFLICT (time, device_id) DO UPDATE SET device_id = 'dev3' 147s -RETURNING *) 147s -select * from cte; 147s - time | device_id 147s ---------------------------+---------------------- 147s - Sat Jan 21 09:00:01 2017 | dev3 147s - Sun Jan 21 09:00:01 2018 | dev3 147s -(2 rows) 147s - 147s --- test ON CONFLICT with prepared statements 147s -CREATE TABLE prepared_test(time timestamptz PRIMARY KEY, value float CHECK(value > 0)); 147s -SELECT create_hypertable('prepared_test','time'); 147s - create_hypertable 147s ----------------------------- 147s - (7,public,prepared_test,t) 147s -(1 row) 147s - 147s -CREATE TABLE source_data(time timestamptz PRIMARY KEY, value float); 147s -INSERT INTO source_data VALUES('2000-01-01',0.5), ('2001-01-01',0.5); 147s --- at some point PostgreSQL will turn the plan into a generic plan 147s --- so we execute the prepared statement 10 times 147s --- check that an error in the prepared statement does not lead to the plan becoming unusable 147s -PREPARE prep_insert_select AS INSERT INTO prepared_test select * from source_data ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s -EXECUTE prep_insert_select; 147s ---this insert will create an invalid tuple in source_data 147s ---so that future calls to prep_insert_select will fail 147s -INSERT INTO source_data VALUES('2000-01-02',-0.5); 147s -\set ON_ERROR_STOP 0 147s -EXECUTE prep_insert_select; 147s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 147s -EXECUTE prep_insert_select; 147s -ERROR: new row for relation "_hyper_7_11_chunk" violates check constraint "prepared_test_value_check" 147s -\set ON_ERROR_STOP 1 147s -DELETE FROM source_data WHERE value <= 0; 147s -EXECUTE prep_insert_select; 147s -PREPARE prep_insert AS INSERT INTO prepared_test VALUES('2000-01-01',0.5) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 147s --- at some point PostgreSQL will turn the plan into a generic plan 147s --- so we execute the prepared statement 10 times 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -EXECUTE prep_insert; 147s -SELECT * FROM prepared_test; 147s - time | value 147s -------------------------------+------- 147s - Sat Jan 01 00:00:00 2000 PST | 0.5 147s - Mon Jan 01 00:00:00 2001 PST | 0.5 147s -(2 rows) 147s - 147s -DELETE FROM prepared_test; 147s --- test ON CONFLICT with functions 147s -CREATE OR REPLACE FUNCTION test_upsert(t timestamptz, v float) RETURNS VOID AS $sql$ 147s -BEGIN 147s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = EXCLUDED.value; 147s -END; 147s -$sql$ LANGUAGE PLPGSQL; 147s --- at some point PostgreSQL will turn the plan into a generic plan 147s --- so we execute the function 10 times 147s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 147s - counter | test_upsert 147s ----------+------------- 147s - 1 | 147s - 2 | 147s - 3 | 147s - 4 | 147s - 5 | 147s - 6 | 147s - 7 | 147s - 8 | 147s - 9 | 147s - 10 | 147s -(10 rows) 147s - 147s -SELECT * FROM prepared_test; 147s - time | value 147s -------------------------------+------- 147s - Sat Jan 01 00:00:00 2000 PST | 0.5 147s -(1 row) 147s - 147s -DELETE FROM prepared_test; 147s --- at some point PostgreSQL will turn the plan into a generic plan 147s --- so we execute the function 10 times 147s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 147s - counter | test_upsert 147s ----------+------------- 147s - 1 | 147s - 2 | 147s - 3 | 147s - 4 | 147s - 5 | 147s - 6 | 147s - 7 | 147s - 8 | 147s - 9 | 147s - 10 | 147s -(10 rows) 147s - 147s -SELECT * FROM prepared_test; 147s - time | value 147s -------------------------------+------- 147s - Sat Jan 01 00:00:00 2000 PST | 0.5 147s -(1 row) 147s - 147s -DELETE FROM prepared_test; 147s --- run it again to ensure INSERT path is still working as well 147s -SELECT counter,test_upsert('2000-01-01',0.5) FROM generate_series(1,10) AS g(counter); 147s - counter | test_upsert 147s ----------+------------- 147s - 1 | 147s - 2 | 147s - 3 | 147s - 4 | 147s - 5 | 147s - 6 | 147s - 7 | 147s - 8 | 147s - 9 | 147s - 10 | 147s -(10 rows) 147s - 147s -SELECT * FROM prepared_test; 147s - time | value 147s -------------------------------+------- 147s - Sat Jan 01 00:00:00 2000 PST | 0.5 147s -(1 row) 147s - 147s -DELETE FROM prepared_test; 147s --- test ON CONFLICT with functions 147s -CREATE OR REPLACE FUNCTION test_upsert2(t timestamptz, v float) RETURNS VOID AS $sql$ 147s -BEGIN 147s -INSERT INTO prepared_test VALUES(t,v) ON CONFLICT (time) DO UPDATE SET value = prepared_test.value + 1.0; 147s -END; 147s -$sql$ LANGUAGE PLPGSQL; 147s --- at some point PostgreSQL will turn the plan into a generic plan 147s --- so we execute the function 10 times 147s -SELECT counter,test_upsert2('2000-01-01',1.0) FROM generate_series(1,10) AS g(counter); 147s - counter | test_upsert2 147s ----------+-------------- 147s - 1 | 147s - 2 | 147s - 3 | 147s - 4 | 147s - 5 | 147s - 6 | 147s - 7 | 147s - 8 | 147s - 9 | 147s - 10 | 147s -(10 rows) 147s - 147s -SELECT * FROM prepared_test; 147s - time | value 147s -------------------------------+------- 147s - Sat Jan 01 00:00:00 2000 PST | 10 147s -(1 row) 147s - 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s diff -u /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/util.out /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/util.out 147s --- /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/util.out 2024-11-06 18:23:51.000000000 +0000 147s +++ /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/util.out 2024-11-15 14:55:36.192620305 +0000 147s @@ -1,18 +1,2 @@ 147s --- This file and its contents are licensed under the Apache License 2.0. 147s --- Please see the included NOTICE for copyright information and 147s --- LICENSE-APACHE for a copy of the license. 147s -\set ECHO errors 147s - item 147s ------------------------------------- 147s - db_util_wizard=a/db_util_wizard 147s - db_util_wizard=ar/db_util_wizard 147s - db_util_wizard=a*/db_util_wizard 147s - db_util_wizard=a*r*/db_util_wizard 147s - [NULL] 147s - [NULL] 147s - [NULL] 147s - [NULL] 147s - =a*r*/db_util_wizard 147s - db_util_wizard=a*r*/0 147s -(10 rows) 147s - 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s diff -u /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/vacuum.out /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/vacuum.out 147s --- /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/vacuum.out 2024-11-06 18:23:51.000000000 +0000 147s +++ /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/vacuum.out 2024-11-15 14:55:36.260624041 +0000 147s @@ -1,228 +1,2 @@ 147s --- This file and its contents are licensed under the Apache License 2.0. 147s --- Please see the included NOTICE for copyright information and 147s --- LICENSE-APACHE for a copy of the license. 147s -CREATE TABLE vacuum_test(time timestamp, temp float); 147s --- create hypertable with three chunks 147s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s --------------------------- 147s - (1,public,vacuum_test,t) 147s -(1 row) 147s - 147s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 147s - ('2017-01-21T16:00:01', 19.1), 147s - ('2017-04-20T16:00:01', 89.5), 147s - ('2017-04-21T16:00:01', 17.1), 147s - ('2017-06-20T16:00:01', 18.5), 147s - ('2017-06-21T16:00:01', 11.0); 147s --- no stats 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -VACUUM ANALYZE vacuum_test; 147s --- stats should exist for all three chunks 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s -------------------+---------+---------------------------------------------------------+------------ 147s - _hyper_1_1_chunk | temp | {17.5,19.1} | -1 147s - _hyper_1_1_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 147s - _hyper_1_2_chunk | temp | {17.1,89.5} | -1 147s - _hyper_1_2_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 147s - _hyper_1_3_chunk | temp | {11,18.5} | -1 147s - _hyper_1_3_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 147s -(6 rows) 147s - 147s --- stats should exist on parent hypertable 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' AND tablename LIKE 'vacuum_test' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s --------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 147s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 147s - 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 147s -(2 rows) 147s - 147s -DROP TABLE vacuum_test; 147s ---test plain analyze (no_vacuum) 147s -CREATE TABLE analyze_test(time timestamp, temp float); 147s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ---------------------------- 147s - (2,public,analyze_test,t) 147s -(1 row) 147s - 147s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 147s - ('2017-01-21T16:00:01', 19.1), 147s - ('2017-04-20T16:00:01', 89.5), 147s - ('2017-04-21T16:00:01', 17.1), 147s - ('2017-06-20T16:00:01', 18.5), 147s - ('2017-06-21T16:00:01', 11.0); 147s --- no stats 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -ANALYZE VERBOSE analyze_test; 147s -INFO: analyzing "_timescaledb_internal._hyper_2_4_chunk" 147s -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 147s -INFO: analyzing "_timescaledb_internal._hyper_2_5_chunk" 147s -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 147s -INFO: analyzing "_timescaledb_internal._hyper_2_6_chunk" 147s -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 147s -INFO: analyzing "public.analyze_test" 147s -INFO: "analyze_test": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows 147s -INFO: analyzing "public.analyze_test" inheritance tree 147s -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 147s -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 147s -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 147s --- stats should exist for all three chunks 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s -------------------+---------+---------------------------------------------------------+------------ 147s - _hyper_2_4_chunk | temp | {17.5,19.1} | -1 147s - _hyper_2_4_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 147s - _hyper_2_5_chunk | temp | {17.1,89.5} | -1 147s - _hyper_2_5_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 147s - _hyper_2_6_chunk | temp | {11,18.5} | -1 147s - _hyper_2_6_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 147s -(6 rows) 147s - 147s --- stats should exist on parent hypertable 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' AND tablename LIKE 'analyze_test' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 147s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 147s - 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 147s -(2 rows) 147s - 147s -DROP TABLE analyze_test; 147s --- Run vacuum on a normal (non-hypertable) table 147s -CREATE TABLE vacuum_norm(time timestamp, temp float); 147s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 147s - ('2017-01-21T09:00:01', 19.1), 147s - ('2017-04-20T09:00:01', 89.5), 147s - ('2017-04-21T09:00:01', 17.1), 147s - ('2017-06-20T09:00:01', 18.5), 147s - ('2017-06-21T09:00:01', 11.0); 147s -VACUUM ANALYZE vacuum_norm; 147s -DROP TABLE vacuum_norm; 147s ---Similar to normal vacuum tests, but PG11 introduced ability to vacuum multiple tables at once, we make sure that works for hypertables as well. 147s -CREATE TABLE vacuum_test(time timestamp, temp float); 147s --- create hypertable with three chunks 147s -SELECT create_hypertable('vacuum_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s --------------------------- 147s - (3,public,vacuum_test,t) 147s -(1 row) 147s - 147s -INSERT INTO vacuum_test VALUES ('2017-01-20T16:00:01', 17.5), 147s - ('2017-01-21T16:00:01', 19.1), 147s - ('2017-04-20T16:00:01', 89.5), 147s - ('2017-04-21T16:00:01', 17.1), 147s - ('2017-06-20T16:00:01', 18.5), 147s - ('2017-06-21T16:00:01', 11.0); 147s -CREATE TABLE analyze_test(time timestamp, temp float); 147s -SELECT create_hypertable('analyze_test', 'time', chunk_time_interval => 2628000000000, create_default_indexes => false); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s -NOTICE: adding not-null constraint to column "time" 147s - create_hypertable 147s ---------------------------- 147s - (4,public,analyze_test,t) 147s -(1 row) 147s - 147s -INSERT INTO analyze_test VALUES ('2017-01-20T16:00:01', 17.5), 147s - ('2017-01-21T16:00:01', 19.1), 147s - ('2017-04-20T16:00:01', 89.5), 147s - ('2017-04-21T16:00:01', 17.1), 147s - ('2017-06-20T16:00:01', 18.5), 147s - ('2017-06-21T16:00:01', 11.0); 147s -CREATE TABLE vacuum_norm(time timestamp, temp float); 147s -INSERT INTO vacuum_norm VALUES ('2017-01-20T09:00:01', 17.5), 147s - ('2017-01-21T09:00:01', 19.1), 147s - ('2017-04-20T09:00:01', 89.5), 147s - ('2017-04-21T09:00:01', 17.1), 147s - ('2017-06-20T09:00:01', 18.5), 147s - ('2017-06-21T09:00:01', 11.0); 147s --- no stats 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ------------+---------+------------------+------------ 147s -(0 rows) 147s - 147s -VACUUM ANALYZE vacuum_norm, vacuum_test, analyze_test; 147s --- stats should exist for all 6 chunks 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = '_timescaledb_internal' AND tablename LIKE '_hyper_%_chunk' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s --------------------+---------+---------------------------------------------------------+------------ 147s - _hyper_3_7_chunk | temp | {17.5,19.1} | -1 147s - _hyper_3_7_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 147s - _hyper_3_8_chunk | temp | {17.1,89.5} | -1 147s - _hyper_3_8_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 147s - _hyper_3_9_chunk | temp | {11,18.5} | -1 147s - _hyper_3_9_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 147s - _hyper_4_10_chunk | temp | {17.5,19.1} | -1 147s - _hyper_4_10_chunk | time | {"Fri Jan 20 16:00:01 2017","Sat Jan 21 16:00:01 2017"} | -1 147s - _hyper_4_11_chunk | temp | {17.1,89.5} | -1 147s - _hyper_4_11_chunk | time | {"Thu Apr 20 16:00:01 2017","Fri Apr 21 16:00:01 2017"} | -1 147s - _hyper_4_12_chunk | temp | {11,18.5} | -1 147s - _hyper_4_12_chunk | time | {"Tue Jun 20 16:00:01 2017","Wed Jun 21 16:00:01 2017"} | -1 147s -(12 rows) 147s - 147s --- stats should exist on parent hypertable and normal table 147s -SELECT tablename, attname, histogram_bounds, n_distinct FROM pg_stats 147s -WHERE schemaname = 'public' 147s -ORDER BY tablename, attname, array_to_string(histogram_bounds, ','); 147s - tablename | attname | histogram_bounds | n_distinct 147s ---------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ 147s - analyze_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 147s - 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 147s - vacuum_norm | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 147s - 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 147s - vacuum_test | temp | {11,17.1,17.5,18.5,19.1,89.5} | -1 147s - 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 147s -(6 rows) 147s - 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s diff -u /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/vacuum_parallel.out /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/vacuum_parallel.out 147s --- /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/vacuum_parallel.out 2024-11-06 18:23:51.000000000 +0000 147s +++ /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/vacuum_parallel.out 2024-11-15 14:55:36.273624755 +0000 147s @@ -1,39 +1,2 @@ 147s --- This file and its contents are licensed under the Apache License 2.0. 147s --- Please see the included NOTICE for copyright information and 147s --- LICENSE-APACHE for a copy of the license. 147s --- PG13 introduced parallel VACUUM functionality. It gets invoked when a table 147s --- has two or more indexes on it. Read up more at 147s --- https://www.postgresql.org/docs/13/sql-vacuum.html#PARALLEL 147s -CREATE TABLE vacuum_test(time timestamp NOT NULL, temp1 float, temp2 int); 147s --- create hypertable 147s --- we create chunks in public schema cause otherwise we would need 147s --- elevated privileges to create indexes directly 147s -SELECT create_hypertable('vacuum_test', 'time', create_default_indexes => false, associated_schema_name => 'public'); 147s -WARNING: column type "timestamp without time zone" used for "time" does not follow best practices 147s - create_hypertable 147s --------------------------- 147s - (1,public,vacuum_test,t) 147s -(1 row) 147s - 147s --- parallel vacuum needs the index size to be larger than min_parallel_index_scan_size to kick in 147s -SET min_parallel_index_scan_size TO 0; 147s -INSERT INTO vacuum_test SELECT TIMESTAMP 'epoch' + (i * INTERVAL '4h'), 147s - i, i+1 FROM generate_series(1, 100) as T(i); 147s --- create indexes on the temp columns 147s --- we create indexes manually because otherwise vacuum verbose output 147s --- would be different between 13.2 and 13.3+ 147s --- 13.2 would try to vacuum the parent table index too while 13.3+ wouldn't 147s -CREATE INDEX ON _hyper_1_1_chunk(time); 147s -CREATE INDEX ON _hyper_1_1_chunk(temp1); 147s -CREATE INDEX ON _hyper_1_1_chunk(temp2); 147s -CREATE INDEX ON _hyper_1_2_chunk(time); 147s -CREATE INDEX ON _hyper_1_2_chunk(temp1); 147s -CREATE INDEX ON _hyper_1_2_chunk(temp2); 147s -CREATE INDEX ON _hyper_1_3_chunk(time); 147s -CREATE INDEX ON _hyper_1_3_chunk(temp1); 147s -CREATE INDEX ON _hyper_1_3_chunk(temp2); 147s --- INSERT only will not trigger vacuum on indexes for PG13.3+ 147s -UPDATE vacuum_test SET time = time + '1s'::interval, temp1 = random(), temp2 = random(); 147s --- we should see two parallel workers for each chunk 147s -VACUUM (PARALLEL 3) vacuum_test; 147s -DROP TABLE vacuum_test; 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s diff -u /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/version.out /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/version.out 147s --- /tmp/autopkgtest.hvKu8i/build.jdu/src/test/expected/version.out 2024-11-06 18:23:51.000000000 +0000 147s +++ /tmp/autopkgtest.hvKu8i/build.jdu/src/test-17/test/results/version.out 2024-11-15 14:55:36.178619536 +0000 147s @@ -1,10 +1,2 @@ 147s --- This file and its contents are licensed under the Apache License 2.0. 147s --- Please see the included NOTICE for copyright information and 147s --- LICENSE-APACHE for a copy of the license. 147s --- Test that get_os_info returns 3 x text 147s -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(); 147s - sysname_type | version_type | release_type 147s ---------------+--------------+-------------- 147s - text | text | text 147s -(1 row) 147s - 147s +psql: error: connection to server at "localhost" (::1), port 55432 failed: FATAL: the database system is not yet accepting connections 147s +DETAIL: Consistent recovery state has not been yet reached. 147s + EXIT=1 147s + exit 1 147s autopkgtest [14:55:36]: test installcheck: -----------------------] 148s installcheck FAIL non-zero exit status 1 148s autopkgtest [14:55:37]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 148s autopkgtest [14:55:37]: @@@@@@@@@@@@@@@@@@@@ summary 148s installcheck FAIL non-zero exit status 1 159s nova [W] Skipping flock for amd64 159s Creating nova instance adt-plucky-amd64-timescaledb-20241115-145309-juju-7f2275-prod-proposed-migration-environment-15-0e3d2d71-4230-4d88-9743-9a05ed147ec5 from image adt/ubuntu-plucky-amd64-server-20241115.img (UUID cc9375bb-1426-47d8-a5d8-f3536037532e)...