0s autopkgtest [17:35:07]: starting date: 2024-03-11 0s autopkgtest [17:35:07]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [17:35:07]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.hxu2xnlr/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:postgresql-16,src:db5.3,src:gdbm,src:llvm-toolchain-17,src:mmdebstrap,src:openssl,src:perl,src:python3.12,src:readline --apt-upgrade r-cran-rpostgresql --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=postgresql-16/16.2-1ubuntu2 db5.3/5.3.28+dfsg2-5 gdbm/1.23-5.1 llvm-toolchain-17/1:17.0.6-8ubuntu1.1 mmdebstrap/1.4.3-6 openssl/3.0.13-0ubuntu1 perl/5.38.2-3.2 python3.12/3.12.2-4build2 readline/8.2-3.1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@bos03-arm64-17.secgroup --name adt-noble-arm64-r-cran-rpostgresql-20240311-173506-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-3 --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,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 98s autopkgtest [17:36:45]: @@@@@@@@@@@@@@@@@@@@ test bed setup 99s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 99s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 99s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [38.0 kB] 99s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2673 kB] 100s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [452 kB] 100s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [593 kB] 100s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 100s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [20.3 kB] 100s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 100s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [2980 kB] 100s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 100s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [39.6 kB] 100s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 102s Fetched 6929 kB in 2s (4121 kB/s) 102s Reading package lists... 105s Reading package lists... 106s Building dependency tree... 106s Reading state information... 107s Calculating upgrade... 107s The following packages will be REMOVED: 107s libdb5.3 libgdbm-compat4 libgdbm6 libperl5.38 libreadline8 libssl3 107s The following NEW packages will be installed: 107s libdb5.3t64 libgdbm-compat4t64 libgdbm6t64 libperl5.38t64 libreadline8t64 107s libssl3t64 107s The following packages will be upgraded: 107s klibc-utils libklibc libpython3.12-minimal libpython3.12-stdlib openssl perl 107s perl-base perl-modules-5.38 python3.12 python3.12-minimal readline-common 108s 11 upgraded, 6 newly installed, 6 to remove and 0 not upgraded. 108s Need to get 19.4 MB of archives. 108s After this operation, 275 kB of additional disk space will be used. 108s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 openssl arm64 3.0.13-0ubuntu1 [983 kB] 108s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libssl3t64 arm64 3.0.13-0ubuntu1 [1770 kB] 108s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 python3.12 arm64 3.12.2-4build2 [645 kB] 108s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 python3.12-minimal arm64 3.12.2-4build2 [2189 kB] 108s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpython3.12-minimal arm64 3.12.2-4build2 [829 kB] 109s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libreadline8t64 arm64 8.2-3.1 [153 kB] 109s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpython3.12-stdlib arm64 3.12.2-4build2 [2002 kB] 109s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libdb5.3t64 arm64 5.3.28+dfsg2-5 [719 kB] 109s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm6t64 arm64 1.23-5.1 [34.3 kB] 109s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm-compat4t64 arm64 1.23-5.1 [6576 B] 109s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libperl5.38t64 arm64 5.38.2-3.2 [4771 kB] 109s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl arm64 5.38.2-3.2 [231 kB] 109s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-base arm64 5.38.2-3.2 [1777 kB] 109s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-modules-5.38 all 5.38.2-3.2 [3110 kB] 109s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 readline-common all 8.2-3.1 [56.4 kB] 109s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 klibc-utils arm64 2.0.13-4 [114 kB] 109s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libklibc arm64 2.0.13-4 [51.4 kB] 110s Fetched 19.4 MB in 2s (12.4 MB/s) 111s (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 ... 74748 files and directories currently installed.) 111s Preparing to unpack .../openssl_3.0.13-0ubuntu1_arm64.deb ... 111s Unpacking openssl (3.0.13-0ubuntu1) over (3.0.10-1ubuntu4) ... 111s dpkg: libssl3:arm64: dependency problems, but removing anyway as you requested: 111s wget depends on libssl3 (>= 3.0.0). 111s u-boot-tools depends on libssl3 (>= 3.0.0). 111s tnftp depends on libssl3 (>= 3.0.0). 111s tcpdump depends on libssl3 (>= 3.0.0). 111s systemd-resolved depends on libssl3 (>= 3.0.0). 111s systemd depends on libssl3 (>= 3.0.0). 111s sudo depends on libssl3 (>= 3.0.0). 111s sbsigntool depends on libssl3 (>= 3.0.0). 111s rsync depends on libssl3 (>= 3.0.0). 111s python3-cryptography depends on libssl3 (>= 3.0.0). 111s openssh-server depends on libssl3 (>= 3.0.10). 111s openssh-client depends on libssl3 (>= 3.0.10). 111s mtd-utils depends on libssl3 (>= 3.0.0). 111s mokutil depends on libssl3 (>= 3.0.0). 111s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 111s libsystemd-shared:arm64 depends on libssl3 (>= 3.0.0). 111s libssh-4:arm64 depends on libssl3 (>= 3.0.0). 111s libsasl2-modules:arm64 depends on libssl3 (>= 3.0.0). 111s libsasl2-2:arm64 depends on libssl3 (>= 3.0.0). 111s libpython3.12-minimal:arm64 depends on libssl3 (>= 3.0.0). 111s libnvme1 depends on libssl3 (>= 3.0.0). 111s libkrb5-3:arm64 depends on libssl3 (>= 3.0.0). 111s libkmod2:arm64 depends on libssl3 (>= 3.0.0). 111s libfido2-1:arm64 depends on libssl3 (>= 3.0.0). 111s libcurl4:arm64 depends on libssl3 (>= 3.0.0). 111s libcryptsetup12:arm64 depends on libssl3 (>= 3.0.0). 111s kmod depends on libssl3 (>= 3.0.0). 111s dhcpcd-base depends on libssl3 (>= 3.0.0). 111s bind9-libs:arm64 depends on libssl3 (>= 3.0.0). 111s 111s (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 ... 74748 files and directories currently installed.) 111s Removing libssl3:arm64 (3.0.10-1ubuntu4) ... 111s Selecting previously unselected package libssl3t64:arm64. 111s (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 ... 74737 files and directories currently installed.) 111s Preparing to unpack .../libssl3t64_3.0.13-0ubuntu1_arm64.deb ... 111s Unpacking libssl3t64:arm64 (3.0.13-0ubuntu1) ... 111s Preparing to unpack .../python3.12_3.12.2-4build2_arm64.deb ... 111s Unpacking python3.12 (3.12.2-4build2) over (3.12.2-1) ... 113s Preparing to unpack .../python3.12-minimal_3.12.2-4build2_arm64.deb ... 113s Unpacking python3.12-minimal (3.12.2-4build2) over (3.12.2-1) ... 113s Preparing to unpack .../libpython3.12-minimal_3.12.2-4build2_arm64.deb ... 113s Unpacking libpython3.12-minimal:arm64 (3.12.2-4build2) over (3.12.2-1) ... 113s dpkg: libreadline8:arm64: dependency problems, but removing anyway as you requested: 113s parted depends on libreadline8 (>= 6.0). 113s libpython3.12-stdlib:arm64 depends on libreadline8 (>= 7.0~beta). 113s gpgsm depends on libreadline8 (>= 6.0). 113s gpgconf depends on libreadline8 (>= 6.0). 113s gpg depends on libreadline8 (>= 6.0). 113s gawk depends on libreadline8 (>= 6.0). 113s fdisk depends on libreadline8 (>= 6.0). 113s 113s (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 ... 74750 files and directories currently installed.) 113s Removing libreadline8:arm64 (8.2-3) ... 113s Selecting previously unselected package libreadline8t64:arm64. 113s (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 ... 74738 files and directories currently installed.) 113s Preparing to unpack .../libreadline8t64_8.2-3.1_arm64.deb ... 113s Adding 'diversion of /lib/aarch64-linux-gnu/libhistory.so.8 to /lib/aarch64-linux-gnu/libhistory.so.8.usr-is-merged by libreadline8t64' 113s Adding 'diversion of /lib/aarch64-linux-gnu/libhistory.so.8.2 to /lib/aarch64-linux-gnu/libhistory.so.8.2.usr-is-merged by libreadline8t64' 113s Adding 'diversion of /lib/aarch64-linux-gnu/libreadline.so.8 to /lib/aarch64-linux-gnu/libreadline.so.8.usr-is-merged by libreadline8t64' 113s Adding 'diversion of /lib/aarch64-linux-gnu/libreadline.so.8.2 to /lib/aarch64-linux-gnu/libreadline.so.8.2.usr-is-merged by libreadline8t64' 113s Unpacking libreadline8t64:arm64 (8.2-3.1) ... 113s Preparing to unpack .../libpython3.12-stdlib_3.12.2-4build2_arm64.deb ... 113s Unpacking libpython3.12-stdlib:arm64 (3.12.2-4build2) over (3.12.2-1) ... 113s dpkg: libperl5.38:arm64: dependency problems, but removing anyway as you requested: 113s perl depends on libperl5.38 (= 5.38.2-3). 113s 113s (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 ... 74756 files and directories currently installed.) 113s Removing libperl5.38:arm64 (5.38.2-3) ... 113s dpkg: libdb5.3:arm64: dependency problems, but removing anyway as you requested: 113s libsasl2-modules-db:arm64 depends on libdb5.3. 113s libpam-modules:arm64 depends on libdb5.3. 113s iproute2 depends on libdb5.3. 113s apt-utils depends on libdb5.3. 113s 113s Removing libdb5.3:arm64 (5.3.28+dfsg2-4) ... 113s Selecting previously unselected package libdb5.3t64:arm64. 114s (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 ... 74221 files and directories currently installed.) 114s Preparing to unpack .../libdb5.3t64_5.3.28+dfsg2-5_arm64.deb ... 114s Unpacking libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 114s (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 ... 74227 files and directories currently installed.) 114s Removing libgdbm-compat4:arm64 (1.23-5) ... 114s dpkg: libgdbm6:arm64: dependency problems, but removing anyway as you requested: 114s python3-gdbm:arm64 depends on libgdbm6 (>= 1.16). 114s man-db depends on libgdbm6 (>= 1.16). 114s 114s Removing libgdbm6:arm64 (1.23-5) ... 114s Selecting previously unselected package libgdbm6t64:arm64. 114s (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 ... 74217 files and directories currently installed.) 114s Preparing to unpack .../libgdbm6t64_1.23-5.1_arm64.deb ... 114s Unpacking libgdbm6t64:arm64 (1.23-5.1) ... 114s Selecting previously unselected package libgdbm-compat4t64:arm64. 114s Preparing to unpack .../libgdbm-compat4t64_1.23-5.1_arm64.deb ... 114s Unpacking libgdbm-compat4t64:arm64 (1.23-5.1) ... 114s Selecting previously unselected package libperl5.38t64:arm64. 114s Preparing to unpack .../libperl5.38t64_5.38.2-3.2_arm64.deb ... 114s Unpacking libperl5.38t64:arm64 (5.38.2-3.2) ... 114s Preparing to unpack .../perl_5.38.2-3.2_arm64.deb ... 114s Unpacking perl (5.38.2-3.2) over (5.38.2-3) ... 114s Preparing to unpack .../perl-base_5.38.2-3.2_arm64.deb ... 114s Unpacking perl-base (5.38.2-3.2) over (5.38.2-3) ... 115s Setting up perl-base (5.38.2-3.2) ... 115s (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 ... 74758 files and directories currently installed.) 115s Preparing to unpack .../perl-modules-5.38_5.38.2-3.2_all.deb ... 115s Unpacking perl-modules-5.38 (5.38.2-3.2) over (5.38.2-3) ... 115s Preparing to unpack .../readline-common_8.2-3.1_all.deb ... 115s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 115s Preparing to unpack .../klibc-utils_2.0.13-4_arm64.deb ... 115s Unpacking klibc-utils (2.0.13-4) over (2.0.13-2ubuntu1) ... 115s Preparing to unpack .../libklibc_2.0.13-4_arm64.deb ... 115s Unpacking libklibc:arm64 (2.0.13-4) over (2.0.13-2ubuntu1) ... 115s Setting up libgdbm6t64:arm64 (1.23-5.1) ... 115s Setting up libgdbm-compat4t64:arm64 (1.23-5.1) ... 115s Setting up libssl3t64:arm64 (3.0.13-0ubuntu1) ... 115s Setting up libpython3.12-minimal:arm64 (3.12.2-4build2) ... 115s Setting up libklibc:arm64 (2.0.13-4) ... 115s Setting up perl-modules-5.38 (5.38.2-3.2) ... 115s Setting up libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 115s Setting up libperl5.38t64:arm64 (5.38.2-3.2) ... 115s Setting up klibc-utils (2.0.13-4) ... 115s Setting up openssl (3.0.13-0ubuntu1) ... 115s Setting up readline-common (8.2-3.1) ... 115s Setting up python3.12-minimal (3.12.2-4build2) ... 117s Setting up perl (5.38.2-3.2) ... 117s Setting up libreadline8t64:arm64 (8.2-3.1) ... 117s Setting up libpython3.12-stdlib:arm64 (3.12.2-4build2) ... 117s Setting up python3.12 (3.12.2-4build2) ... 119s Processing triggers for systemd (255.2-3ubuntu2) ... 119s Processing triggers for man-db (2.12.0-3) ... 119s Processing triggers for install-info (7.1-3) ... 120s Processing triggers for initramfs-tools (0.142ubuntu20) ... 120s update-initramfs: Generating /boot/initrd.img-6.8.0-11-generic 120s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 139s System running in EFI mode, skipping. 139s Processing triggers for libc-bin (2.39-0ubuntu2) ... 139s Reading package lists... 140s Building dependency tree... 140s Reading state information... 140s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 141s sh: Attempting to set up Debian/Ubuntu apt sources automatically 141s sh: Distribution appears to be Ubuntu 142s Reading package lists... 142s Building dependency tree... 142s Reading state information... 143s eatmydata is already the newest version (131-1). 143s dbus is already the newest version (1.14.10-4ubuntu1). 143s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s rng-tools-debian is already the newest version (2.4). 143s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 143s Reading package lists... 144s Building dependency tree... 144s Reading state information... 144s haveged is already the newest version (1.9.14-1ubuntu1). 144s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 144s Reading package lists... 144s Building dependency tree... 144s Reading state information... 145s The following packages will be REMOVED: 145s cloud-init* python3-configobj* python3-debconf* 145s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 145s After this operation, 3248 kB disk space will be freed. 145s (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 ... 74758 files and directories currently installed.) 145s Removing cloud-init (24.1-0ubuntu1) ... 146s Removing python3-configobj (5.0.8-3) ... 146s Removing python3-debconf (1.5.86) ... 146s Processing triggers for man-db (2.12.0-3) ... 147s (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 ... 74369 files and directories currently installed.) 147s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 147s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 147s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 148s Reading package lists... 148s Building dependency tree... 148s Reading state information... 148s linux-generic is already the newest version (6.8.0-11.11+1). 148s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 149s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 149s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 149s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 149s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 151s Reading package lists... 151s Reading package lists... 151s Building dependency tree... 151s Reading state information... 151s Calculating upgrade... 152s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 152s Reading package lists... 152s Building dependency tree... 152s Reading state information... 153s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 153s autopkgtest [17:37:40]: rebooting testbed after setup commands that affected boot 397s autopkgtest [17:41:44]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 398s autopkgtest [17:41:45]: testbed dpkg architecture: arm64 399s autopkgtest [17:41:46]: @@@@@@@@@@@@@@@@@@@@ apt-source r-cran-rpostgresql 402s Get:1 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (dsc) [2173 B] 402s Get:2 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (tar) [122 kB] 402s Get:3 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (diff) [3600 B] 402s gpgv: Signature made Thu Jan 18 13:14:53 2024 UTC 402s gpgv: using RSA key F1F007320A035541F0A663CA578A0494D1C646D1 402s gpgv: issuer "tille@debian.org" 402s gpgv: Can't check signature: No public key 402s dpkg-source: warning: cannot verify inline signature for ./r-cran-rpostgresql_0.7-6+dfsg-1.dsc: no acceptable signature found 402s autopkgtest [17:41:49]: testing package r-cran-rpostgresql version 0.7-6+dfsg-1 402s autopkgtest [17:41:49]: build not needed 405s autopkgtest [17:41:52]: test run-unit-test: preparing testbed 409s Reading package lists... 409s Building dependency tree... 409s Reading state information... 410s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 410s Starting 2 pkgProblemResolver with broken count: 0 410s Done 410s Done 410s Starting pkgProblemResolver with broken count: 0 411s Starting 2 pkgProblemResolver with broken count: 0 411s Done 411s The following additional packages will be installed: 411s fontconfig fontconfig-config fonts-dejavu-core fonts-dejavu-mono libblas3 411s libcairo2 libdatrie1 libdeflate0 libfontconfig1 libgfortran5 libgomp1 411s libgraphite2-3 libharfbuzz0b libice6 libjbig0 libjpeg-turbo8 libjpeg8 411s liblapack3 liblerc4 libpango-1.0-0 libpangocairo-1.0-0 libpangoft2-1.0-0 411s libpaper-utils libpaper1 libpixman-1-0 libpq5 libsharpyuv0 libsm6 libtcl8.6 411s libthai-data libthai0 libtiff6 libtk8.6 libwebp7 libxcb-render0 libxcb-shm0 411s libxft2 libxrender1 libxss1 libxt6 r-base-core r-cran-dbi r-cran-littler 411s r-cran-rpostgresql unzip x11-common xdg-utils zip 411s Suggested packages: 411s tcl8.6 tk8.6 elpa-ess r-doc-info | r-doc-pdf r-mathlib r-base-html 411s r-cran-rmysql r-cran-getopt 411s Recommended packages: 411s r-recommended r-base-dev r-doc-html libfile-mimeinfo-perl libnet-dbus-perl 411s libx11-protocol-perl x11-utils x11-xserver-utils 411s The following NEW packages will be installed: 411s fontconfig fontconfig-config fonts-dejavu-core fonts-dejavu-mono libblas3 411s libcairo2 libdatrie1 libdeflate0 libfontconfig1 libgfortran5 libgomp1 411s libgraphite2-3 libharfbuzz0b libice6 libjbig0 libjpeg-turbo8 libjpeg8 411s liblapack3 liblerc4 libpango-1.0-0 libpangocairo-1.0-0 libpangoft2-1.0-0 411s libpaper-utils libpaper1 libpixman-1-0 libpq5 libsharpyuv0 libsm6 libtcl8.6 411s libthai-data libthai0 libtiff6 libtk8.6 libwebp7 libxcb-render0 libxcb-shm0 411s libxft2 libxrender1 libxss1 libxt6 r-base-core r-cran-dbi r-cran-littler 411s r-cran-rpostgresql unzip x11-common xdg-utils zip 412s 0 upgraded, 48 newly installed, 0 to remove and 0 not upgraded. 412s 1 not fully installed or removed. 412s Need to get 38.0 MB of archives. 412s After this operation, 78.6 MB of additional disk space will be used. 412s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 zip arm64 3.0-13 [172 kB] 412s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 unzip arm64 6.0-28ubuntu3 [171 kB] 412s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 libpaper1 arm64 1.1.29 [13.1 kB] 412s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libpaper-utils arm64 1.1.29 [8480 B] 412s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 xdg-utils all 1.1.3-4.1ubuntu3 [62.0 kB] 412s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libblas3 arm64 3.12.0-3 [143 kB] 412s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 fonts-dejavu-mono all 2.37-8 [502 kB] 412s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 fonts-dejavu-core all 2.37-8 [835 kB] 412s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 fontconfig-config arm64 2.15.0-1ubuntu1 [37.0 kB] 412s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libfontconfig1 arm64 2.15.0-1ubuntu1 [142 kB] 412s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 libpixman-1-0 arm64 0.42.2-1 [193 kB] 412s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 libxcb-render0 arm64 1.15-1 [16.1 kB] 412s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 libxcb-shm0 arm64 1.15-1 [5780 B] 412s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 libxrender1 arm64 1:0.9.10-1.1 [19.1 kB] 412s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 libcairo2 arm64 1.18.0-1 [550 kB] 412s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 libgomp1 arm64 14-20240303-1ubuntu1 [144 kB] 412s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-turbo8 arm64 2.1.5-2ubuntu1 [160 kB] 412s Get:18 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg8 arm64 8c-2ubuntu11 [2148 B] 412s Get:19 http://ftpmaster.internal/ubuntu noble/main arm64 libgfortran5 arm64 14-20240303-1ubuntu1 [444 kB] 412s Get:20 http://ftpmaster.internal/ubuntu noble/main arm64 liblapack3 arm64 3.12.0-3 [2241 kB] 412s Get:21 http://ftpmaster.internal/ubuntu noble/main arm64 fontconfig arm64 2.15.0-1ubuntu1 [190 kB] 412s Get:22 http://ftpmaster.internal/ubuntu noble/main arm64 libgraphite2-3 arm64 1.3.14-2 [81.5 kB] 412s Get:23 http://ftpmaster.internal/ubuntu noble/main arm64 libharfbuzz0b arm64 8.3.0-2 [463 kB] 412s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 libthai-data all 0.1.29-2 [158 kB] 412s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 libdatrie1 arm64 0.2.13-3 [21.7 kB] 412s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 libthai0 arm64 0.1.29-2 [18.1 kB] 412s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 libpango-1.0-0 arm64 1.51.0+ds-4 [226 kB] 412s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libpangoft2-1.0-0 arm64 1.51.0+ds-4 [41.2 kB] 412s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 libpangocairo-1.0-0 arm64 1.51.0+ds-4 [27.6 kB] 412s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 libtcl8.6 arm64 8.6.13+dfsg-2 [980 kB] 412s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 libdeflate0 arm64 1.19-1 [43.4 kB] 412s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 libjbig0 arm64 2.1-6.1ubuntu1 [28.9 kB] 412s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 liblerc4 arm64 4.0.0+ds-4ubuntu1 [153 kB] 412s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 libsharpyuv0 arm64 1.3.2-0.4 [14.4 kB] 412s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 libwebp7 arm64 1.3.2-0.4 [191 kB] 412s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 libtiff6 arm64 4.5.1+git230720-3ubuntu1 [226 kB] 412s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 libxft2 arm64 2.3.6-1 [43.3 kB] 412s Get:38 http://ftpmaster.internal/ubuntu noble/main arm64 x11-common all 1:7.7+23ubuntu2 [23.4 kB] 413s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 libxss1 arm64 1:1.2.3-1build2 [8252 B] 413s Get:40 http://ftpmaster.internal/ubuntu noble/main arm64 libtk8.6 arm64 8.6.13-2 [760 kB] 413s Get:41 http://ftpmaster.internal/ubuntu noble/main arm64 libice6 arm64 2:1.0.10-1build2 [41.7 kB] 413s Get:42 http://ftpmaster.internal/ubuntu noble/main arm64 libsm6 arm64 2:1.2.3-1build2 [16.1 kB] 413s Get:43 http://ftpmaster.internal/ubuntu noble/main arm64 libxt6 arm64 1:1.2.1-1.1 [167 kB] 413s Get:44 http://ftpmaster.internal/ubuntu noble/universe arm64 r-base-core arm64 4.3.2-1build1 [26.8 MB] 414s Get:45 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-dbi all 1.2.2-1 [823 kB] 414s Get:46 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpq5 arm64 16.2-1ubuntu2 [137 kB] 414s Get:47 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-littler arm64 0.3.19-1 [93.4 kB] 414s Get:48 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-rpostgresql arm64 0.7-6+dfsg-1 [374 kB] 416s Preconfiguring packages ... 416s Fetched 38.0 MB in 2s (17.7 MB/s) 416s Selecting previously unselected package zip. 416s (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 ... 74314 files and directories currently installed.) 416s Preparing to unpack .../00-zip_3.0-13_arm64.deb ... 416s Unpacking zip (3.0-13) ... 416s Selecting previously unselected package unzip. 416s Preparing to unpack .../01-unzip_6.0-28ubuntu3_arm64.deb ... 416s Unpacking unzip (6.0-28ubuntu3) ... 416s Selecting previously unselected package libpaper1:arm64. 417s Preparing to unpack .../02-libpaper1_1.1.29_arm64.deb ... 417s Unpacking libpaper1:arm64 (1.1.29) ... 417s Selecting previously unselected package libpaper-utils. 417s Preparing to unpack .../03-libpaper-utils_1.1.29_arm64.deb ... 417s Unpacking libpaper-utils (1.1.29) ... 417s Selecting previously unselected package xdg-utils. 417s Preparing to unpack .../04-xdg-utils_1.1.3-4.1ubuntu3_all.deb ... 417s Unpacking xdg-utils (1.1.3-4.1ubuntu3) ... 417s Selecting previously unselected package libblas3:arm64. 417s Preparing to unpack .../05-libblas3_3.12.0-3_arm64.deb ... 417s Unpacking libblas3:arm64 (3.12.0-3) ... 417s Selecting previously unselected package fonts-dejavu-mono. 417s Preparing to unpack .../06-fonts-dejavu-mono_2.37-8_all.deb ... 417s Unpacking fonts-dejavu-mono (2.37-8) ... 417s Selecting previously unselected package fonts-dejavu-core. 417s Preparing to unpack .../07-fonts-dejavu-core_2.37-8_all.deb ... 417s Unpacking fonts-dejavu-core (2.37-8) ... 417s Selecting previously unselected package fontconfig-config. 417s Preparing to unpack .../08-fontconfig-config_2.15.0-1ubuntu1_arm64.deb ... 418s Unpacking fontconfig-config (2.15.0-1ubuntu1) ... 418s Selecting previously unselected package libfontconfig1:arm64. 418s Preparing to unpack .../09-libfontconfig1_2.15.0-1ubuntu1_arm64.deb ... 418s Unpacking libfontconfig1:arm64 (2.15.0-1ubuntu1) ... 418s Selecting previously unselected package libpixman-1-0:arm64. 418s Preparing to unpack .../10-libpixman-1-0_0.42.2-1_arm64.deb ... 418s Unpacking libpixman-1-0:arm64 (0.42.2-1) ... 418s Selecting previously unselected package libxcb-render0:arm64. 418s Preparing to unpack .../11-libxcb-render0_1.15-1_arm64.deb ... 418s Unpacking libxcb-render0:arm64 (1.15-1) ... 418s Selecting previously unselected package libxcb-shm0:arm64. 418s Preparing to unpack .../12-libxcb-shm0_1.15-1_arm64.deb ... 418s Unpacking libxcb-shm0:arm64 (1.15-1) ... 418s Selecting previously unselected package libxrender1:arm64. 418s Preparing to unpack .../13-libxrender1_1%3a0.9.10-1.1_arm64.deb ... 418s Unpacking libxrender1:arm64 (1:0.9.10-1.1) ... 418s Selecting previously unselected package libcairo2:arm64. 418s Preparing to unpack .../14-libcairo2_1.18.0-1_arm64.deb ... 418s Unpacking libcairo2:arm64 (1.18.0-1) ... 418s Selecting previously unselected package libgomp1:arm64. 418s Preparing to unpack .../15-libgomp1_14-20240303-1ubuntu1_arm64.deb ... 418s Unpacking libgomp1:arm64 (14-20240303-1ubuntu1) ... 418s Selecting previously unselected package libjpeg-turbo8:arm64. 418s Preparing to unpack .../16-libjpeg-turbo8_2.1.5-2ubuntu1_arm64.deb ... 418s Unpacking libjpeg-turbo8:arm64 (2.1.5-2ubuntu1) ... 418s Selecting previously unselected package libjpeg8:arm64. 418s Preparing to unpack .../17-libjpeg8_8c-2ubuntu11_arm64.deb ... 418s Unpacking libjpeg8:arm64 (8c-2ubuntu11) ... 418s Selecting previously unselected package libgfortran5:arm64. 418s Preparing to unpack .../18-libgfortran5_14-20240303-1ubuntu1_arm64.deb ... 418s Unpacking libgfortran5:arm64 (14-20240303-1ubuntu1) ... 418s Selecting previously unselected package liblapack3:arm64. 418s Preparing to unpack .../19-liblapack3_3.12.0-3_arm64.deb ... 418s Unpacking liblapack3:arm64 (3.12.0-3) ... 418s Selecting previously unselected package fontconfig. 418s Preparing to unpack .../20-fontconfig_2.15.0-1ubuntu1_arm64.deb ... 418s Unpacking fontconfig (2.15.0-1ubuntu1) ... 418s Selecting previously unselected package libgraphite2-3:arm64. 418s Preparing to unpack .../21-libgraphite2-3_1.3.14-2_arm64.deb ... 418s Unpacking libgraphite2-3:arm64 (1.3.14-2) ... 418s Selecting previously unselected package libharfbuzz0b:arm64. 418s Preparing to unpack .../22-libharfbuzz0b_8.3.0-2_arm64.deb ... 418s Unpacking libharfbuzz0b:arm64 (8.3.0-2) ... 419s Selecting previously unselected package libthai-data. 419s Preparing to unpack .../23-libthai-data_0.1.29-2_all.deb ... 419s Unpacking libthai-data (0.1.29-2) ... 419s Selecting previously unselected package libdatrie1:arm64. 419s Preparing to unpack .../24-libdatrie1_0.2.13-3_arm64.deb ... 419s Unpacking libdatrie1:arm64 (0.2.13-3) ... 419s Selecting previously unselected package libthai0:arm64. 419s Preparing to unpack .../25-libthai0_0.1.29-2_arm64.deb ... 419s Unpacking libthai0:arm64 (0.1.29-2) ... 419s Selecting previously unselected package libpango-1.0-0:arm64. 419s Preparing to unpack .../26-libpango-1.0-0_1.51.0+ds-4_arm64.deb ... 419s Unpacking libpango-1.0-0:arm64 (1.51.0+ds-4) ... 419s Selecting previously unselected package libpangoft2-1.0-0:arm64. 419s Preparing to unpack .../27-libpangoft2-1.0-0_1.51.0+ds-4_arm64.deb ... 419s Unpacking libpangoft2-1.0-0:arm64 (1.51.0+ds-4) ... 419s Selecting previously unselected package libpangocairo-1.0-0:arm64. 419s Preparing to unpack .../28-libpangocairo-1.0-0_1.51.0+ds-4_arm64.deb ... 419s Unpacking libpangocairo-1.0-0:arm64 (1.51.0+ds-4) ... 419s Selecting previously unselected package libtcl8.6:arm64. 419s Preparing to unpack .../29-libtcl8.6_8.6.13+dfsg-2_arm64.deb ... 419s Unpacking libtcl8.6:arm64 (8.6.13+dfsg-2) ... 419s Selecting previously unselected package libdeflate0:arm64. 419s Preparing to unpack .../30-libdeflate0_1.19-1_arm64.deb ... 419s Unpacking libdeflate0:arm64 (1.19-1) ... 419s Selecting previously unselected package libjbig0:arm64. 419s Preparing to unpack .../31-libjbig0_2.1-6.1ubuntu1_arm64.deb ... 419s Unpacking libjbig0:arm64 (2.1-6.1ubuntu1) ... 419s Selecting previously unselected package liblerc4:arm64. 419s Preparing to unpack .../32-liblerc4_4.0.0+ds-4ubuntu1_arm64.deb ... 419s Unpacking liblerc4:arm64 (4.0.0+ds-4ubuntu1) ... 419s Selecting previously unselected package libsharpyuv0:arm64. 419s Preparing to unpack .../33-libsharpyuv0_1.3.2-0.4_arm64.deb ... 419s Unpacking libsharpyuv0:arm64 (1.3.2-0.4) ... 419s Selecting previously unselected package libwebp7:arm64. 419s Preparing to unpack .../34-libwebp7_1.3.2-0.4_arm64.deb ... 419s Unpacking libwebp7:arm64 (1.3.2-0.4) ... 419s Selecting previously unselected package libtiff6:arm64. 419s Preparing to unpack .../35-libtiff6_4.5.1+git230720-3ubuntu1_arm64.deb ... 419s Unpacking libtiff6:arm64 (4.5.1+git230720-3ubuntu1) ... 420s Selecting previously unselected package libxft2:arm64. 420s Preparing to unpack .../36-libxft2_2.3.6-1_arm64.deb ... 420s Unpacking libxft2:arm64 (2.3.6-1) ... 420s Selecting previously unselected package x11-common. 420s Preparing to unpack .../37-x11-common_1%3a7.7+23ubuntu2_all.deb ... 420s Unpacking x11-common (1:7.7+23ubuntu2) ... 420s Selecting previously unselected package libxss1:arm64. 420s Preparing to unpack .../38-libxss1_1%3a1.2.3-1build2_arm64.deb ... 420s Unpacking libxss1:arm64 (1:1.2.3-1build2) ... 420s Selecting previously unselected package libtk8.6:arm64. 420s Preparing to unpack .../39-libtk8.6_8.6.13-2_arm64.deb ... 420s Unpacking libtk8.6:arm64 (8.6.13-2) ... 420s Selecting previously unselected package libice6:arm64. 420s Preparing to unpack .../40-libice6_2%3a1.0.10-1build2_arm64.deb ... 420s Unpacking libice6:arm64 (2:1.0.10-1build2) ... 420s Selecting previously unselected package libsm6:arm64. 420s Preparing to unpack .../41-libsm6_2%3a1.2.3-1build2_arm64.deb ... 420s Unpacking libsm6:arm64 (2:1.2.3-1build2) ... 420s Selecting previously unselected package libxt6:arm64. 420s Preparing to unpack .../42-libxt6_1%3a1.2.1-1.1_arm64.deb ... 420s Unpacking libxt6:arm64 (1:1.2.1-1.1) ... 420s Selecting previously unselected package r-base-core. 420s Preparing to unpack .../43-r-base-core_4.3.2-1build1_arm64.deb ... 420s Unpacking r-base-core (4.3.2-1build1) ... 420s Selecting previously unselected package r-cran-dbi. 420s Preparing to unpack .../44-r-cran-dbi_1.2.2-1_all.deb ... 420s Unpacking r-cran-dbi (1.2.2-1) ... 420s Selecting previously unselected package libpq5:arm64. 420s Preparing to unpack .../45-libpq5_16.2-1ubuntu2_arm64.deb ... 420s Unpacking libpq5:arm64 (16.2-1ubuntu2) ... 420s Selecting previously unselected package r-cran-littler. 420s Preparing to unpack .../46-r-cran-littler_0.3.19-1_arm64.deb ... 420s Unpacking r-cran-littler (0.3.19-1) ... 421s Selecting previously unselected package r-cran-rpostgresql. 421s Preparing to unpack .../47-r-cran-rpostgresql_0.7-6+dfsg-1_arm64.deb ... 421s Unpacking r-cran-rpostgresql (0.7-6+dfsg-1) ... 421s Setting up libgraphite2-3:arm64 (1.3.14-2) ... 421s Setting up libpixman-1-0:arm64 (0.42.2-1) ... 421s Setting up libsharpyuv0:arm64 (1.3.2-0.4) ... 421s Setting up libpaper1:arm64 (1.1.29) ... 421s 421s Creating config file /etc/papersize with new version 421s Setting up liblerc4:arm64 (4.0.0+ds-4ubuntu1) ... 421s Setting up libxrender1:arm64 (1:0.9.10-1.1) ... 421s Setting up libdatrie1:arm64 (0.2.13-3) ... 421s Setting up libxcb-render0:arm64 (1.15-1) ... 421s Setting up unzip (6.0-28ubuntu3) ... 421s Setting up x11-common (1:7.7+23ubuntu2) ... 422s Setting up libpq5:arm64 (16.2-1ubuntu2) ... 422s Setting up libdeflate0:arm64 (1.19-1) ... 422s Setting up libxcb-shm0:arm64 (1.15-1) ... 422s Setting up libpaper-utils (1.1.29) ... 422s Setting up libgomp1:arm64 (14-20240303-1ubuntu1) ... 422s Setting up libjbig0:arm64 (2.1-6.1ubuntu1) ... 422s Setting up zip (3.0-13) ... 422s Setting up libblas3:arm64 (3.12.0-3) ... 422s update-alternatives: using /usr/lib/aarch64-linux-gnu/blas/libblas.so.3 to provide /usr/lib/aarch64-linux-gnu/libblas.so.3 (libblas.so.3-aarch64-linux-gnu) in auto mode 422s Setting up fonts-dejavu-mono (2.37-8) ... 422s Setting up libtcl8.6:arm64 (8.6.13+dfsg-2) ... 422s Setting up fonts-dejavu-core (2.37-8) ... 422s Setting up libjpeg-turbo8:arm64 (2.1.5-2ubuntu1) ... 422s Setting up libgfortran5:arm64 (14-20240303-1ubuntu1) ... 422s Setting up libwebp7:arm64 (1.3.2-0.4) ... 422s Setting up libharfbuzz0b:arm64 (8.3.0-2) ... 422s Setting up libthai-data (0.1.29-2) ... 422s Setting up libxss1:arm64 (1:1.2.3-1build2) ... 422s Setting up xdg-utils (1.1.3-4.1ubuntu3) ... 422s update-alternatives: using /usr/bin/xdg-open to provide /usr/bin/open (open) in auto mode 422s Setting up libjpeg8:arm64 (8c-2ubuntu11) ... 422s Setting up libice6:arm64 (2:1.0.10-1build2) ... 422s Setting up liblapack3:arm64 (3.12.0-3) ... 422s update-alternatives: using /usr/lib/aarch64-linux-gnu/lapack/liblapack.so.3 to provide /usr/lib/aarch64-linux-gnu/liblapack.so.3 (liblapack.so.3-aarch64-linux-gnu) in auto mode 422s Setting up fontconfig-config (2.15.0-1ubuntu1) ... 422s Setting up libthai0:arm64 (0.1.29-2) ... 422s Setting up libtiff6:arm64 (4.5.1+git230720-3ubuntu1) ... 422s Setting up libfontconfig1:arm64 (2.15.0-1ubuntu1) ... 422s Setting up libsm6:arm64 (2:1.2.3-1build2) ... 422s Setting up fontconfig (2.15.0-1ubuntu1) ... 424s Regenerating fonts cache... done. 424s Setting up libxft2:arm64 (2.3.6-1) ... 424s Setting up libtk8.6:arm64 (8.6.13-2) ... 424s Setting up libpango-1.0-0:arm64 (1.51.0+ds-4) ... 425s Setting up libcairo2:arm64 (1.18.0-1) ... 425s Setting up libxt6:arm64 (1:1.2.1-1.1) ... 425s Setting up libpangoft2-1.0-0:arm64 (1.51.0+ds-4) ... 425s Setting up libpangocairo-1.0-0:arm64 (1.51.0+ds-4) ... 425s Setting up r-base-core (4.3.2-1build1) ... 425s 425s Creating config file /etc/R/Renviron with new version 425s Setting up r-cran-littler (0.3.19-1) ... 425s Setting up r-cran-dbi (1.2.2-1) ... 425s Setting up r-cran-rpostgresql (0.7-6+dfsg-1) ... 425s Setting up autopkgtest-satdep (0) ... 425s Processing triggers for man-db (2.12.0-3) ... 426s Processing triggers for install-info (7.1-3) ... 426s Processing triggers for libc-bin (2.39-0ubuntu2) ... 432s (Reading database ... 76576 files and directories currently installed.) 432s Removing autopkgtest-satdep (0) ... 433s autopkgtest [17:42:20]: test run-unit-test: [----------------------- 433s BEGIN TEST connectWithNull.R 434s 434s R version 4.3.2 (2023-10-31) -- "Eye Holes" 434s Copyright (C) 2023 The R Foundation for Statistical Computing 434s Platform: aarch64-unknown-linux-gnu (64-bit) 434s 434s R is free software and comes with ABSOLUTELY NO WARRANTY. 434s You are welcome to redistribute it under certain conditions. 434s Type 'license()' or 'licence()' for distribution details. 434s 434s R is a collaborative project with many contributors. 434s Type 'contributors()' for more information and 434s 'citation()' on how to cite R or R packages in publications. 434s 434s Type 'demo()' for some demos, 'help()' for on-line help, or 434s 'help.start()' for an HTML browser interface to help. 434s Type 'q()' to quit R. 434s 434s > 434s > ## connectWithNull test 434s > ## 434s > ## test for the 'Issue 2' on the Google Code issue log 434s > ## reported in April 2009, still open ? 434s > ## 434s > ## Assumes that 434s > ## a) PostgreSQL is running, and 434s > ## b) the current user can connect 434s > ## both of which are not viable for release but suitable while we test 434s > ## 434s > ## Dirk Eddelbuettel, 03 Oct 2009 434s > 434s > ## only run this if this env.var is set correctly 434s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 434s + 434s + ## try to load our module and abort if this fails 434s + stopifnot(require(RPostgreSQL)) 434s + stopifnot(require(datasets)) 434s + 434s + ## load the PostgresSQL driver 434s + drv <- dbDriver("PostgreSQL") 434s + 434s + ## connect to the default db -- replacing any of these with NULL will lead to 434s + ## a stop() call and a return to the R prompt rather than a segfault 434s + con <- dbConnect(drv, 434s + user=Sys.getenv("POSTGRES_USER"), 434s + password=Sys.getenv("POSTGRES_PASSWD"), 434s + host=Sys.getenv("POSTGRES_HOST"), 434s + dbname=Sys.getenv("POSTGRES_DATABASE"), 434s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 434s + 434s + ## do we get here? 434s + print(con) 434s + 434s + ## and disconnect 434s + dbDisconnect(con) 434s + } 434s > 434s BEGIN TEST createTableMixedCaseTest.R 434s 434s R version 4.3.2 (2023-10-31) -- "Eye Holes" 434s Copyright (C) 2023 The R Foundation for Statistical Computing 434s Platform: aarch64-unknown-linux-gnu (64-bit) 434s 434s R is free software and comes with ABSOLUTELY NO WARRANTY. 434s You are welcome to redistribute it under certain conditions. 434s Type 'license()' or 'licence()' for distribution details. 434s 434s R is a collaborative project with many contributors. 434s Type 'contributors()' for more information and 434s 'citation()' on how to cite R or R packages in publications. 434s 434s Type 'demo()' for some demos, 'help()' for on-line help, or 434s 'help.start()' for an HTML browser interface to help. 434s Type 'q()' to quit R. 434s 434s > 434s > ## createTableMixedCaseTest test 434s > ## 434s > ## 434s > ## Assumes that 434s > ## a) PostgreSQL is running, and 434s > ## b) the current user can connect 434s > ## both of which are not viable for release but suitable while we test 434s > ## 434s > ## Neil Tiffin, 30 Oct 2009 434s > 434s > ## only run this if this env.var is set correctly 434s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 434s + 434s + ## try to load our module and abort if this fails 434s + stopifnot(require(RPostgreSQL)) 434s + 434s + ## load the PostgresSQL driver 434s + drv <- dbDriver("PostgreSQL") 434s + 434s + ## connect to the default db 434s + con <- dbConnect(drv, 434s + user=Sys.getenv("POSTGRES_USER"), 434s + password=Sys.getenv("POSTGRES_PASSWD"), 434s + host=Sys.getenv("POSTGRES_HOST"), 434s + dbname=Sys.getenv("POSTGRES_DATABASE"), 434s + port=Sys.getenv("POSTGRES_PORT")) 434s + 434s + 434s + 434s + res <- dbGetQuery(con, "create table Foo1 (f1 int)") 434s + res <- dbGetQuery(con, "create table \"Foo2\" (f1 int)") 434s + 434s + cat("Test should create foo1 and Foo2 tables\n") 434s + ## res <- dbGetQuery(con, "SELECT * FROM information_schema.tables WHERE table_schema = 'public'") 434s + ## print res 434s + 434s + if (dbExistsTable(con, "Foo1")) { 434s + cat("FAIL - Foo1 Table exists.\n") 434s + } 434s + else { 434s + cat("Pass - Foo1 Table does not exist.\n") 434s + } 434s + 434s + if (dbExistsTable(con, "foo1")) { 434s + cat("Pass - foo1 Table exists.\n") 434s + } 434s + else { 434s + cat("FAIL - foo1 Table does not exist.\n") 434s + } 434s + 434s + if (dbExistsTable(con, "Foo2")) { 434s + cat("Pass - Foo2 Table exists.\n") 434s + } 434s + else { 434s + cat("FAIL - Foo2 Table does not exist.\n") 434s + } 434s + 434s + if (dbExistsTable(con, "foo2")) { 434s + cat("FAIL - foo2 Table exists.\n") 434s + } 434s + else { 434s + cat("Pass - foo2 Table does not exist.\n") 434s + } 434s + 434s + if (dbExistsTable(con, "\"Foo2\"")) { 434s + cat("FAIL - \"Foo2\" Table exists.\n") 434s + } 434s + else { 434s + cat("Pass - \"Foo2\" Table does not exist.\n") 434s + } 434s + 434s + if (dbExistsTable(con, "\"foo2\"")) { 434s + cat("FAIL - \"foo2\" Table exists.\n") 434s + } 434s + else { 434s + cat("Pass - \"foo2\" Table does not exist.\n") 434s + } 434s + 434s + res <- dbGetQuery(con, "drop table Foo1") 434s + res <- dbGetQuery(con, "drop table \"Foo2\"") 434s + ## and disconnect 434s + dbDisconnect(con) 434s + } 434s > 434s BEGIN TEST dataTypeTests.R 434s 434s R version 4.3.2 (2023-10-31) -- "Eye Holes" 434s Copyright (C) 2023 The R Foundation for Statistical Computing 434s Platform: aarch64-unknown-linux-gnu (64-bit) 434s 434s R is free software and comes with ABSOLUTELY NO WARRANTY. 434s You are welcome to redistribute it under certain conditions. 434s Type 'license()' or 'licence()' for distribution details. 434s 434s R is a collaborative project with many contributors. 434s Type 'contributors()' for more information and 434s 'citation()' on how to cite R or R packages in publications. 434s 434s Type 'demo()' for some demos, 'help()' for on-line help, or 434s 'help.start()' for an HTML browser interface to help. 434s Type 'q()' to quit R. 434s 434s > ## Test of data types, based on earlier version in inst/devTests 434s > ## 434s > ## Dirk Eddelbuettel, 21 Oct 2008 434s > 434s > if ((Sys.getenv("POSTGRES_USER") != "") & 434s + (Sys.getenv("POSTGRES_HOST") != "") & 434s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 434s + 434s + ## try to load our module and abort if this fails 434s + stopifnot(require(RPostgreSQL)) 434s + 434s + ## load the PostgresSQL driver 434s + drv <- dbDriver("PostgreSQL") 434s + ## can't print result as it contains process id which changes print(summary(drv)) 434s + 434s + ## connect to the default db 434s + con <- dbConnect(drv, 434s + user=Sys.getenv("POSTGRES_USER"), 434s + password=Sys.getenv("POSTGRES_PASSWD"), 434s + host=Sys.getenv("POSTGRES_HOST"), 434s + dbname=Sys.getenv("POSTGRES_DATABASE"), 434s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 434s + 434s + if (dbExistsTable(con, "tempostgrestable")) 434s + dbRemoveTable(con, "tempostgrestable") 434s + 434s + ## Test the numeric mapping 434s + dbGetQuery(con, "create table tempostgrestable (intcolumn integer, floatcolumn float);") 434s + 434s + i <- as.integer(10) 434s + j <- as.numeric(56.6) 434s + 434s + sql <- paste("insert into tempostgrestable ", 434s + "values (",i, "," ,j ,") ", sep="") 434s + res <- dbGetQuery(con, sql) 434s + 434s + 434s + dat <- dbReadTable(con, "tempostgrestable") 434s + dbRemoveTable(con, "tempostgrestable") 434s + cat("Read Numeric values\n") 434s + 434s + ## now test the types of the colums we got 434s + stopifnot( class(dat[,1]) == "integer" ) 434s + stopifnot( class(dat[,2]) == "numeric" ) 434s + cat("GOOD -- all numeric types are as expected\n") 434s + 434s + ## and test the values 434s + stopifnot( identical( dat[1,1], i)) 434s + stopifnot( identical( dat[1,2], j)) 434s + cat("GOOD -- all numeric values are as expected\n") 434s + 434s + ## Test the logical mapping 434s + if (dbExistsTable(con, "testlogical")) 434s + dbRemoveTable(con, "testlogical") 434s + dbGetQuery(con,"create table testlogical (col1 boolean, col2 boolean)") 434s + 434s + i <- as.logical(TRUE) 434s + j <- as.logical(FALSE) 434s + 434s + sql <- paste("insert into testlogical ", 434s + "values (",i, "," ,j ,") ", sep="") 434s + res <- dbGetQuery(con, sql); 434s + 434s + dat <- dbReadTable(con, "testlogical") 434s + dbRemoveTable(con, "testlogical") 434s + cat("Read Logical values\n") 434s + 434s + ## now test the types of the colums we got 434s + stopifnot( class(dat[,1]) == "logical" ) 434s + stopifnot( class(dat[,2]) == "logical" ) 434s + cat("GOOD -- all logical types are as expected\n") 434s + 434s + ## and test the values 434s + stopifnot( identical( dat[1,1], i)) 434s + stopifnot( identical( dat[1,2], j)) 434s + cat("GOOD -- all logical values are as expected\n") 434s + 434s + ## Test the character mapping 434s + if (dbExistsTable(con, "testchar")) 434s + dbRemoveTable(con, "testchar") 434s + dbGetQuery(con,"create table testchar (code char(3),city varchar(20),country text);") 434s + 434s + i <- as.character("IN") 434s + j <- as.character("Hyderabad") 434s + k <- as.character("India") 434s + 434s + sql <- paste("insert into testchar ", 434s + "values ('",i,"' , '",j ,"' , '",k,"') ", sep="") 434s + res <- dbGetQuery(con, sql); 434s + 434s + dat <- dbReadTable(con, "testchar") 434s + cat("Read Character values\n") 434s + 434s + ## now test the types of the colums we got 434s + stopifnot( class(dat[,1]) == "character" ) 434s + stopifnot( class(dat[,2]) == "character" ) 434s + stopifnot( class(dat[,3]) == "character" ) 434s + cat("GOOD -- all character types are as expected\n") 434s + 434s + ## and test the values 434s + ##stopifnot( identical( dat[1,1], i)) 434s + stopifnot( identical( dat[1,2], j)) 434s + stopifnot( identical( dat[1,3], k)) 434s + cat("GOOD -- all character values are as expected\n") 434s + 434s + dbRemoveTable(con, "testchar") 434s + dbRemoveTable(con, "tempostgrestable") 434s + 434s + dbDisconnect(con) 434s + dbUnloadDriver(drv) 434s + 434s + cat("DONE\n") 434s + } 434s > 434s BEGIN TEST dateTZ.R 435s 435s R version 4.3.2 (2023-10-31) -- "Eye Holes" 435s Copyright (C) 2023 The R Foundation for Statistical Computing 435s Platform: aarch64-unknown-linux-gnu (64-bit) 435s 435s R is free software and comes with ABSOLUTELY NO WARRANTY. 435s You are welcome to redistribute it under certain conditions. 435s Type 'license()' or 'licence()' for distribution details. 435s 435s R is a collaborative project with many contributors. 435s Type 'contributors()' for more information and 435s 'citation()' on how to cite R or R packages in publications. 435s 435s Type 'demo()' for some demos, 'help()' for on-line help, or 435s 'help.start()' for an HTML browser interface to help. 435s Type 'q()' to quit R. 435s 435s > 435s > ## Test of date and datetime types, based on earlier version in inst/devTests 435s > ## 435s > ## Dirk Eddelbuettel, 21 Oct 2008 435s > 435s > dbTypeTests <- function(con, dateclass="timestamp without time zone", tz="UTC") { 435s + cat("\n\n**** Trying with ", dateclass, "\n") 435s + 435s + if (dbExistsTable(con, "tempostgrestable")) 435s + dbRemoveTable(con, "tempostgrestable") 435s + 435s + dbGetQuery(con, paste("create table tempostgrestable (tt ", dateclass, ", zz integer);", sep="")) 435s + insstring <- '2008-07-01 14:15:16.123+00' 435s + cat(paste('inserted string 1:', insstring)) 435s + cat("\n") 435s + dbGetQuery(con, paste("insert into tempostgrestable values('", insstring, "', 1);", sep="")) 435s + 435s + # now <- ISOdatetime(2000,1,2,3,4,5.678) 435s + insstring <- '2000-01-02 03:04:05.678+00' 435s + cat(paste('inserted string 2:', insstring)) 435s + cat("\n") 435s + dbGetQuery(con, paste("insert into tempostgrestable values('", insstring, "', 2);", sep="")) 435s + tt<-as.POSIXct(c("2008-07-01 23:45:16.123+0930","2000-01-02 13:34:05.678+1030"), format="%Y-%m-%d %H:%M:%OS%z") 435s + print(tt) 435s + 435s + dbGetQuery(con, paste("SET TIMEZONE TO '", tz, "'", sep="")) 435s + 435s + data <- dbGetQuery(con, "select tt from tempostgrestable;") 435s + 435s + times <- data[,1] 435s + print(times) 435s + if(as.double(tt[1]) == as.double(times[1])){ 435s + cat('PASS\n') 435s + }else{ 435s + cat('FAIL\n') 435s + } 435s + if(as.double(tt[2]) == as.double(times[2])){ 435s + cat('PASS\n') 435s + }else{ 435s + cat('FAIL\n') 435s + } 435s + 435s + 435s + dbRemoveTable(con, "tempostgrestable") 435s + invisible(NULL) 435s + } 435s > 435s > ## only run this if this env.var is set correctly 435s > if ((Sys.getenv("POSTGRES_USER") != "") & 435s + (Sys.getenv("POSTGRES_HOST") != "") & 435s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 435s + 435s + ## try to load our module and abort if this fails 435s + stopifnot(require(RPostgreSQL)) 435s + 435s + ## Force a timezone to make the tests comparable at different locations 435s + Sys.setenv("TZ"="UTC") 435s + tt<-as.POSIXct(c("2008-07-01 23:45:16.123+0930","2000-01-02 13:34:05.678+1030"), format="%Y-%m-%d %H:%M:%OS%z") 435s + print(tt) 435s + 435s + ## load the PostgresSQL driver 435s + drv <- dbDriver("PostgreSQL") 435s + ## can't print result as it contains process id which changes print(summary(drv)) 435s + 435s + ## connect to the default db 435s + con <- dbConnect(drv, 435s + user=Sys.getenv("POSTGRES_USER"), 435s + password=Sys.getenv("POSTGRES_PASSWD"), 435s + host=Sys.getenv("POSTGRES_HOST"), 435s + dbname=Sys.getenv("POSTGRES_DATABASE"), 435s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 435s + 435s + cat('testing UTC') 435s + dbTypeTests(con, "timestamp") 435s + dbTypeTests(con, "timestamp with time zone") 435s + cat('testing Asia/Tokyo') 435s + dbTypeTests(con, "timestamp", tz="Asia/Tokyo") 435s + dbTypeTests(con, "timestamp with time zone", tz="Asia/Tokyo") 435s + cat('testing Australlia/South') 435s + dbTypeTests(con, "timestamp", tz="Australia/South") 435s + dbTypeTests(con, "timestamp with time zone", tz="Australia/South") 435s + cat('testing America/New_York') 435s + dbTypeTests(con, "timestamp", tz="America/New_York") 435s + dbTypeTests(con, "timestamp with time zone", tz="America/New_York") 435s + 435s + dbDisconnect(con) 435s + } 435s > 435s > 436s BEGIN TEST datetimeTests.R 436s 436s R version 4.3.2 (2023-10-31) -- "Eye Holes" 436s Copyright (C) 2023 The R Foundation for Statistical Computing 436s Platform: aarch64-unknown-linux-gnu (64-bit) 436s 436s R is free software and comes with ABSOLUTELY NO WARRANTY. 436s You are welcome to redistribute it under certain conditions. 436s Type 'license()' or 'licence()' for distribution details. 436s 436s R is a collaborative project with many contributors. 436s Type 'contributors()' for more information and 436s 'citation()' on how to cite R or R packages in publications. 436s 436s Type 'demo()' for some demos, 'help()' for on-line help, or 436s 'help.start()' for an HTML browser interface to help. 436s Type 'q()' to quit R. 436s 436s > 436s > ## Test of date and datetime types, based on earlier version in inst/devTests 436s > ## 436s > ## Dirk Eddelbuettel, 21 Oct 2008 436s > 436s > dbTypeTests <- function(con, dateclass="timestamp without time zone") { 436s + cat("\n\n**** Trying with ", dateclass, "\n") 436s + 436s + if (dbExistsTable(con, "tempostgrestable")) 436s + dbRemoveTable(con, "tempostgrestable") 436s + 436s + dbGetQuery(con, paste("create table tempostgrestable (tt ", dateclass, ", zz integer);", sep="")) 436s + dbGetQuery(con, "insert into tempostgrestable values('2008-07-01 14:15:16.123', 1);") 436s + 436s + now <- ISOdatetime(2000,1,2,3,4,5.678) 436s + dbGetQuery(con, paste("insert into tempostgrestable values('", format(now), "', 2);", sep="")) 436s + 436s + res <- dbReadTable(con, "tempostgrestable") 436s + print(res) 436s + 436s + res <- dbSendQuery(con, "select tt from tempostgrestable;") 436s + data <- fetch(res, n=-1) 436s + print(dbColumnInfo(res)) 436s + 436s + times <- data[,1] 436s + print(times) 436s + print(class(times[1])) 436s + 436s + print(diff(times)) 436s + 436s + dbRemoveTable(con, "tempostgrestable") 436s + invisible(NULL) 436s + } 436s > 436s > ## only run this if this env.var is set correctly 436s > if ((Sys.getenv("POSTGRES_USER") != "") & 436s + (Sys.getenv("POSTGRES_HOST") != "") & 436s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 436s + 436s + ## try to load our module and abort if this fails 436s + stopifnot(require(RPostgreSQL)) 436s + 436s + ## Force a timezone to make the tests comparable at different locations 436s + Sys.setenv("PGDATESTYLE"="German") 436s + Sys.setenv("TZ"="UTC") 436s + 436s + ## load the PostgresSQL driver 436s + drv <- dbDriver("PostgreSQL") 436s + ## can't print result as it contains process id which changes print(summary(drv)) 436s + 436s + ## connect to the default db 436s + con <- dbConnect(drv, 436s + user=Sys.getenv("POSTGRES_USER"), 436s + password=Sys.getenv("POSTGRES_PASSWD"), 436s + host=Sys.getenv("POSTGRES_HOST"), 436s + dbname=Sys.getenv("POSTGRES_DATABASE"), 436s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 436s + 436s + dbTypeTests(con, "timestamp") 436s + # dbTypeTests(con, "timestamp with time zone") 436s + # output differs depending on the compute environment 436s + dbTypeTests(con, "date") 436s + 436s + dbDisconnect(con) 436s + } 436s > 436s > 436s BEGIN TEST datetimestampwrite.R 436s 436s R version 4.3.2 (2023-10-31) -- "Eye Holes" 436s Copyright (C) 2023 The R Foundation for Statistical Computing 436s Platform: aarch64-unknown-linux-gnu (64-bit) 436s 436s R is free software and comes with ABSOLUTELY NO WARRANTY. 436s You are welcome to redistribute it under certain conditions. 436s Type 'license()' or 'licence()' for distribution details. 436s 436s R is a collaborative project with many contributors. 436s Type 'contributors()' for more information and 436s 'citation()' on how to cite R or R packages in publications. 436s 436s Type 'demo()' for some demos, 'help()' for on-line help, or 436s 'help.start()' for an HTML browser interface to help. 436s Type 'q()' to quit R. 436s 436s > ## Test of data types, based on earlier version in inst/devTests 436s > ## 436s > ## Dirk Eddelbuettel, 21 Oct 2008 436s > 436s > if ((Sys.getenv("POSTGRES_USER") != "") & 436s + (Sys.getenv("POSTGRES_HOST") != "") & 436s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 436s + 436s + ## try to load our module and abort if this fails 436s + stopifnot(require(RPostgreSQL)) 436s + 436s + ## load the PostgresSQL driver 436s + drv <- dbDriver("PostgreSQL") 436s + ## can't print result as it contains process id which changes print(summary(drv)) 436s + 436s + ## connect to the default db 436s + con <- dbConnect(drv, 436s + user=Sys.getenv("POSTGRES_USER"), 436s + password=Sys.getenv("POSTGRES_PASSWD"), 436s + host=Sys.getenv("POSTGRES_HOST"), 436s + dbname=Sys.getenv("POSTGRES_DATABASE"), 436s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 436s + 436s + if (dbExistsTable(con, "tempostgrestable")) 436s + dbRemoveTable(con, "tempostgrestable") 436s + 436s + ## Test the numeric mapping 436s + dbGetQuery(con, "create table tempostgrestable (intcolumn date, floatcolumn timestamp with time zone);") 436s + 436s + sql <- paste("insert into tempostgrestable ", 436s + "values ('2011-03-07', '2011-03-07 16:30:39') ") 436s + res <- dbGetQuery(con, sql) 436s + 436s + dat <- dbReadTable(con, "tempostgrestable") 436s + dbRemoveTable(con, "tempostgrestable") 436s + cat("Read Date and TIMESTAMP values\n") 436s + 436s + ## now test the types of the colums we got 436s + if( class(dat[1,1]) == "Date" ){ 436s + cat("PASS -- Date type is as expected\n") 436s + }else{ 436s + cat("FAIL -- Date type is other than Date: ") 436s + cat(class(dat[1,1])) 436s + cat("\n") 436s + } 436s + if( class(dat[1,2])[1] == "POSIXct" ){ 436s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 436s + }else{ 436s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 436s + cat(class(dat[1,2])) 436s + cat("\n") 436s + } 436s + 436s + dbWriteTable(con, "tempostgrestable2", dat) 436s + dat2 <- dbReadTable(con, "tempostgrestable2") 436s + dbRemoveTable(con, "tempostgrestable2") 436s + cat("Check that read after write gets the same data types\n") 436s + 436s + ## now test the types of the colums we got 436s + if( class(dat2[1,1]) == "Date" ){ 436s + cat("PASS -- Date type is as expected\n") 436s + }else{ 436s + cat("FAIL -- Date type is other than Date: ") 436s + cat(class(dat2[1,1])) 436s + cat("\n") 436s + } 436s + if( class(dat2[1,2])[1] == "POSIXct" ){ 436s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 436s + }else{ 436s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 436s + cat(class(dat2[1,2])) 436s + cat("\n") 436s + } 436s + 436s + 436s + dbDisconnect(con) 436s + dbUnloadDriver(drv) 436s + 436s + cat("DONE\n") 436s + } 436s > 436s BEGIN TEST dbColumnInfo.R 436s 436s R version 4.3.2 (2023-10-31) -- "Eye Holes" 436s Copyright (C) 2023 The R Foundation for Statistical Computing 436s Platform: aarch64-unknown-linux-gnu (64-bit) 436s 436s R is free software and comes with ABSOLUTELY NO WARRANTY. 436s You are welcome to redistribute it under certain conditions. 436s Type 'license()' or 'licence()' for distribution details. 436s 436s R is a collaborative project with many contributors. 436s Type 'contributors()' for more information and 436s 'citation()' on how to cite R or R packages in publications. 436s 436s Type 'demo()' for some demos, 'help()' for on-line help, or 436s 'help.start()' for an HTML browser interface to help. 436s Type 'q()' to quit R. 436s 436s > 436s > ## dbWriteTable test 436s > ## 436s > ## Assumes that 436s > ## a) PostgreSQL is running, and 436s > ## b) the current user can connect 436s > ## both of which are not viable for release but suitable while we test 436s > ## 436s > ## Dirk Eddelbuettel, 10 Sep 2009 436s > 436s > ## only run this if this env.var is set correctly 436s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 436s + 436s + ## try to load our module and abort if this fails 436s + stopifnot(require(RPostgreSQL)) 436s + 436s + ## load the PostgresSQL driver 436s + drv <- dbDriver("PostgreSQL") 436s + 436s + ## connect to the default db 436s + con <- dbConnect(drv, 436s + user=Sys.getenv("POSTGRES_USER"), 436s + password=Sys.getenv("POSTGRES_PASSWD"), 436s + host=Sys.getenv("POSTGRES_HOST"), 436s + dbname=Sys.getenv("POSTGRES_DATABASE"), 436s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 436s + 436s + 436s + # create a table 436s + res <- dbGetQuery(con, "CREATE TABLE aa (pk integer, v1 float not null, v2 float)" ) 436s + 436s + ## run a simple query and show the query result 436s + res <- dbGetQuery(con, "INSERT INTO aa VALUES(3, 2, NULL)" ) 436s + res <- dbSendQuery(con, "select pk, v1, v2, v1+v2 from aa") 436s + cat("dbColumnInfo\n") 436s + print(dbColumnInfo(res)) 436s + print(dbColumnInfo(res)) 436s + cat("SELECT result\n") 436s + df <- fetch(res, n=-1) 436s + print(df) 436s + 436s + ## cleanup 436s + cat("Removing \"AA\"\n") 436s + dbRemoveTable(con, "aa") 436s + ## and disconnect 436s + dbDisconnect(con) 436s + } 436s > 436s BEGIN TEST dbExistsIssue.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > 437s > ## dbExists test with schema name: reported as Issue 3 at 437s > ## http://code.google.com/p/rpostgresql/issues/detail?id=3 437s > ## and based on an earlier email by Prasenjit Kapat 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > ## 437s > ## Dirk Eddelbuettel, 10 Sep 2009 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + stopifnot(require(datasets)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## connect to the default db 437s + con <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + if (dbExistsTable(con, "rockdata")) { 437s + print("Removing rockdata\n") 437s + dbRemoveTable(con, "rockdata") 437s + } 437s + 437s + dbWriteTable(con, "rockdata", rock) 437s + 437s + ## run a simple dbExists 437s + cat("Does rockdata exist? ") 437s + print(res <- dbExistsTable(con, "rockdata")) 437s + 437s + ## this should return TRUE but did not -- does now after patch 437s + cat("Does public.rockdata exist? ") 437s + print(res <- dbExistsTable(con, "public.rockdata")) 437s + 437s + ## cleanup 437s + if (dbExistsTable(con, "rockdata")) { 437s + print("Removing rockdata\n") 437s + dbRemoveTable(con, "rockdata") 437s + } 437s + 437s + ## and disconnect 437s + dbDisconnect(con) 437s + } 437s > 437s BEGIN TEST dbExistsq.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > 437s > ## dbExists test with schema name: reported as Issue 3 at 437s > ## http://code.google.com/p/rpostgresql/issues/detail?id=3 437s > ## and based on an earlier email by Prasenjit Kapat 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > ## 437s > ## Dirk Eddelbuettel, 10 Sep 2009 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + stopifnot(require(datasets)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## connect to the default db 437s + con <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + if (dbExistsTable(con, "rock'data")) { 437s + cat("Removing rock'data\n") 437s + dbRemoveTable(con, "rock'data") 437s + } 437s + 437s + cat("Write rock'data\n") 437s + dbWriteTable(con, "rock'data", rock) 437s + 437s + ## run a simple dbExists 437s + cat("Does rock'data exist? ") 437s + print(res <- dbExistsTable(con, "rock'data")) 437s + 437s + ## this should return TRUE but did not -- does now after patch 437s + cat("Does \"public.rock'data\" exist? ") 437s + print(res <- dbExistsTable(con, "public.rock'data")) 437s + 437s + ## cleanup 437s + if (dbExistsTable(con, "rock'data")) { 437s + cat("Removing rock'data\n") 437s + dbRemoveTable(con, "rock'data") 437s + } 437s + 437s + ## and disconnect 437s + dbDisconnect(con) 437s + } 437s > 437s BEGIN TEST dbExistsqc.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > 437s > ## dbExistsq test with schema name: reported as Issue 28 at 437s > ## http://code.google.com/p/rpostgresql/issues/detail?id=28 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > ## 437s > ## Dirk Eddelbuettel, 10 Sep 2009 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + stopifnot(require(datasets)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## connect to the default db 437s + con <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + if (dbExistsTable(con, "rock.data")) { 437s + cat("Removing rock'data\n") 437s + dbRemoveTable(con, "rock.data") 437s + } 437s + 437s + 437s + dbWriteTable(con, "rock.data", rock) 437s + ## run a simple dbExists 437s + cat("Does rock.data exist? \n") 437s + res <- dbExistsTable(con, "rock.data") 437s + if(res){ 437s + cat("PASS: true\n") 437s + }else{ 437s + cat("FAIL: false\n") 437s + } 437s + 437s + ## 437s + cat("create schema testschema and change the search_path\n") 437s + 437s + dbGetQuery(con, 'CREATE SCHEMA testschema') 437s + dbGetQuery(con, 'SET search_path TO testschema') 437s + cat("Does rock.data exist? \n") 437s + res <- dbExistsTable(con, "rock.data") 437s + if(res){ 437s + cat("FAIL: true despite search_path change\n") 437s + }else{ 437s + cat("PASS: false as the search_path changed\n") 437s + } 437s + 437s + cat("Does testschema.\"rock.data\" exist? \n") 437s + res <- dbExistsTable(con, c('testschema', "rock.data")) 437s + if(res){ 437s + cat("FAIL: true despite testschema specified\n") 437s + }else{ 437s + cat("PASS: false as the testschema specified\n") 437s + } 437s + 437s + cat("Does public.\"rock.data\" exist? \n") 437s + res <- dbExistsTable(con, c('public', "rock.data")) 437s + if(res){ 437s + cat("PASS: true despite search_path change\n") 437s + }else{ 437s + cat("FAIL: false as the search_path changed\n") 437s + } 437s + 437s + 437s + cat("write in current schema\n") 437s + dbWriteTable(con, "rock.data", rock) 437s + cat("Does rock.data exist? \n") 437s + res <- dbExistsTable(con, "rock.data") 437s + if(res){ 437s + cat("PASS: true\n") 437s + }else{ 437s + cat("FAIL: false\n") 437s + } 437s + 437s + ## cleanup 437s + dbGetQuery(con, 'DROP TABLE "public"."rock.data"') 437s + dbGetQuery(con, 'DROP TABLE "testschema"."rock.data"') 437s + dbGetQuery(con, 'DROP schema "testschema"') 437s + 437s + ## and disconnect 437s + dbDisconnect(con) 437s + } 437s > 437s BEGIN TEST dbGetQueryParams.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > ## dbGetQuery test with optional parameters 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + stopifnot(require(datasets)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## connect to the default db 437s + con <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + 437s + if (dbExistsTable(con, "rockdata")) { 437s + print("Removing rockdata\n") 437s + dbRemoveTable(con, "rockdata") 437s + } 437s + 437s + dbWriteTable(con, "rockdata", rock) 437s + 437s + ## run a simple query and show the query result 437s + res <- dbGetQuery(con, "SELECT * FROM rockdata WHERE peri > $1 LIMIT 10", 4000) 437s + print(res) 437s + res <- dbGetQuery(con, "SELECT * FROM rockdata WHERE peri > $1 AND shape < $2 LIMIT $3", c(4000, 0.2, 10)) 437s + print(res) 437s + 437s + 437s + ## cleanup 437s + if (dbExistsTable(con, "rockdata")) { 437s + print("Removing rockdata\n") 437s + dbRemoveTable(con, "rockdata") 437s + } 437s + 437s + ## and disconnect 437s + dbDisconnect(con) 437s + } 437s > 437s BEGIN TEST dbListFields.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > ## dbListFields test 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > ## 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## connect to the default db 437s + con <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + 437s + # create a table 437s + res <- dbGetQuery(con, "CREATE SCHEMA testschema") 437s + res <- dbGetQuery(con, "CREATE TABLE testschema.aa (pid integer, name text)") 437s + res <- dbGetQuery(con, "CREATE TABLE aa (pk integer, v1 float not null, v2 float)" ) 437s + 437s + ## run a simple query and show the query result 437s + df <- dbListFields(con, "aa") 437s + print(df) 437s + if (length(df) == 3){ 437s + cat("PASS: 3 fields returned\n") 437s + }else{ 437s + cat(paste("FAIL:", length(df), "fields returned\n")) 437s + } 437s + 437s + df <- dbListFields(con, c("testschema", "aa")) 437s + print(df) 437s + if (length(df) == 2){ 437s + cat("PASS: 2 fields returned\n") 437s + }else{ 437s + cat(paste("FAIL:", length(df), "fields returned\n")) 437s + } 437s + 437s + 437s + ## cleanup 437s + cat("Removing \"AA\"\n") 437s + dbRemoveTable(con, "aa") 437s + dbGetQuery(con, "DROP TABLE testschema.aa") 437s + dbGetQuery(con, "DROP SCHEMA testschema") 437s + ## and disconnect 437s + dbDisconnect(con) 437s + } 437s > 437s BEGIN TEST dbTransactionTests.R 437s 437s R version 4.3.2 (2023-10-31) -- "Eye Holes" 437s Copyright (C) 2023 The R Foundation for Statistical Computing 437s Platform: aarch64-unknown-linux-gnu (64-bit) 437s 437s R is free software and comes with ABSOLUTELY NO WARRANTY. 437s You are welcome to redistribute it under certain conditions. 437s Type 'license()' or 'licence()' for distribution details. 437s 437s R is a collaborative project with many contributors. 437s Type 'contributors()' for more information and 437s 'citation()' on how to cite R or R packages in publications. 437s 437s Type 'demo()' for some demos, 'help()' for on-line help, or 437s 'help.start()' for an HTML browser interface to help. 437s Type 'q()' to quit R. 437s 437s > 437s > ## dbWriteTable test 437s > ## 437s > ## Assumes that 437s > ## a) PostgreSQL is running, and 437s > ## b) the current user can connect 437s > ## both of which are not viable for release but suitable while we test 437s > ## 437s > ## Dirk Eddelbuettel, 10 Sep 2009 437s > 437s > ## only run this if this env.var is set correctly 437s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 437s + 437s + ## try to load our module and abort if this fails 437s + stopifnot(require(RPostgreSQL)) 437s + stopifnot(require(datasets)) 437s + 437s + ## load the PostgresSQL driver 437s + drv <- dbDriver("PostgreSQL") 437s + 437s + ## create two independent connections 437s + con1 <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + con2 <- dbConnect(drv, 437s + user=Sys.getenv("POSTGRES_USER"), 437s + password=Sys.getenv("POSTGRES_PASSWD"), 437s + host=Sys.getenv("POSTGRES_HOST"), 437s + dbname=Sys.getenv("POSTGRES_DATABASE"), 437s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 437s + 437s + 437s + if (dbExistsTable(con1, "rockdata")) { 437s + cat("Removing rockdata\n") 437s + dbRemoveTable(con1, "rockdata") 437s + } 437s + 437s + cat("begin transaction in con1\n") 437s + dbGetQuery(con1, "BEGIN TRANSACTION") 437s + cat("create table rockdata in con1\n") 437s + dbWriteTable(con1, "rockdata", rock) 437s + if (dbExistsTable(con1, "rockdata")) { 437s + cat("PASS rockdata is visible through con1\n") 437s + }else{ 437s + cat("FAIL rockdata is invisible through con1\n") 437s + } 437s + if (dbExistsTable(con2, "rockdata")) { 437s + cat("FAIL rockdata is visible through con2\n") 437s + }else{ 437s + cat("PASS rockdata is invisible through con2\n") 437s + } 437s + cat("commit in con1\n") 437s + dbCommit(con1) 437s + if (dbExistsTable(con2, "rockdata")) { 437s + cat("PASS rockdata is visible through con2\n") 437s + }else{ 437s + cat("FAIL rockdata is invisible through con2\n") 437s + } 437s + 437s + cat("remove the table from con1\n") 437s + dbRemoveTable(con1, "rockdata") 437s + 437s + if (dbExistsTable(con2, "rockdata")) { 437s + cat("FAIL rockdata is visible through con2\n") 437s + }else{ 437s + cat("PASS rockdata is invisible through con2\n") 437s + } 437s + 437s + cat("begin transaction in con1\n") 437s + dbGetQuery(con1, "BEGIN TRANSACTION") 437s + cat("create table rockdata in con1\n") 437s + dbWriteTable(con1, "rockdata", rock) 437s + if (dbExistsTable(con1, "rockdata")) { 437s + cat("PASS rockdata is visible through con1\n") 437s + }else{ 437s + cat("FAIL rockdata is invisible through con1\n") 437s + } 437s + cat("RollBack con1\n") 437s + dbRollback(con1) 437s + if (dbExistsTable(con1, "rockdata")) { 437s + cat("FAIL rockdata is visible through con1\n") 437s + }else{ 437s + cat("PASS rockdata is invisible through con1\n") 437s + } 437s + 437s + ## and disconnect 437s + dbDisconnect(con2) 437s + dbDisconnect(con1) 437s + } 437s > 437s BEGIN TEST dbWriteTableSchema.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > 438s > ## dbWriteTable test 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 10 Sep 2009 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + stopifnot(require(datasets)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + 438s + ## connect to the default db 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + 438s + if (dbExistsTable(con, c("public", "rockdata"))) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, c("public", "rockdata")) 438s + } 438s + 438s + dbWriteTable(con, c("public", "rockdata"), rock) 438s + 438s + ## run a simple query and show the query result 438s + res <- dbGetQuery(con, "select * from public.rockdata limit 10") 438s + print(res) 438s + 438s + 438s + ## cleanup 438s + if (dbExistsTable(con, c("public", "rockdata"))) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, c("public", "rockdata")) 438s + } 438s + 438s + ## and disconnect 438s + dbDisconnect(con) 438s + } 438s > 438s BEGIN TEST dbWriteTableTest.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > 438s > ## dbWriteTable test 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 10 Sep 2009 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + stopifnot(require(datasets)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + 438s + ## connect to the default db 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + 438s + if (dbExistsTable(con, "rockdata")) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + } 438s + 438s + dbWriteTable(con, "rockdata", rock) 438s + 438s + ## run a simple query and show the query result 438s + res <- dbGetQuery(con, "select * from rockdata limit 10") 438s + print(res) 438s + 438s + 438s + ## cleanup 438s + if (dbExistsTable(con, "rockdata")) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + } 438s + 438s + ## and disconnect 438s + dbDisconnect(con) 438s + } 438s > 438s BEGIN TEST dbWriteTabletypes.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > ## dbWriteTable test 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 10 Sep 2009 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + 438s + ## connect to the default db 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + 438s + if (dbExistsTable(con, "rockdata")) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + } 438s + 438s + dbGetQuery(con, "set client_encoding to 'UTF-8'") 438s + difficultstrings <- c("normal", "t\tab", "v\vertical tab", "n\newline", "r carriage \retern", "back \\ slash", "f\form feed") 438s + df <- data.frame(strings=difficultstrings) 438s + 438s + dbWriteTable(con, "rockdata", df) 438s + 438s + ## run a simple query and show the query result 438s + res <- dbGetQuery(con, "select * from rockdata") 438s + print(res) 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + 438s + difficultstringe <- c("normal", "m\u00fc\u00df") 438s + df <- data.frame(strings=difficultstringe) 438s + tryres <- try({dbWriteTable(con, "rockdata", df) 438s + res <- dbGetQuery(con, "select * from rockdata") 438s + for(n in 1:2){ 438s + cat(paste(as.character(n), "\t")) 438s + cat(res[n,2]) 438s + cat("\n") 438s + } 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + }) 438s + if(tryres != TRUE){ 438s + cat("FAIL: could not write small umlaut u and ligature sz.\n") 438s + cat(" This might be no problem for you if you don't use those special characters.\n") 438s + cat(" Otherwise, please check for the server encoding.\n") 438s + cat(" Database encoding is usually set at the time of createdb.\n") 438s + cat(" You can see for more information on how to setup at \n") 438s + cat(" http://www.postgresql.org/docs/9.1/static/multibyte.html\n\n") 438s + }else{ 438s + cat("PASS: could write small umlaut u and ligature sz\n") 438s + } 438s + 438s + difficultstringk <- c("normal", "kanji\u6f22\u5b57") 438s + df <- data.frame(strings=difficultstringk) 438s + tryres <- try({dbWriteTable(con, "rockdata", df) 438s + res <- dbGetQuery(con, "select * from rockdata") 438s + for(n in 1:2){ 438s + cat(paste(as.character(n), "\t")) 438s + cat(res[n,2]) 438s + cat("\n") 438s + } 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + }) 438s + if(tryres != TRUE){ 438s + cat("FAIL: could not write kanji.\n") 438s + cat(" This might be no problem for you if you don't use multibyte characters.\n") 438s + cat(" Otherwise, please check for the server encoding.\n") 438s + cat(" Database encoding is usually set at the time of createdb.\n") 438s + cat(" You can see for more information on how to setup at \n") 438s + cat(" http://www.postgresql.org/docs/9.1/static/multibyte.html\n\n") 438s + }else{ 438s + cat("PASS: could write kanji\n") 438s + } 438s + 438s + ## cleanup 438s + if (dbExistsTable(con, "rockdata")) { 438s + print("Removing rockdata\n") 438s + dbRemoveTable(con, "rockdata") 438s + } 438s + 438s + if (dbExistsTable(con, "tempostgrestable")) 438s + dbRemoveTable(con, "tempostgrestable") 438s + 438s + ## Test the numeric mapping 438s + dbGetQuery(con, "create table tempostgrestable (intcolumn integer, floatcolumn float);") 438s + 438s + i <- as.integer(10) 438s + j <- as.numeric(56.6) 438s + 438s + sql <- paste("insert into tempostgrestable ", 438s + "values (",i, "," ,j ,") ", sep="") 438s + res <- dbGetQuery(con, sql) 438s + 438s + dat <- dbReadTable(con, "tempostgrestable") 438s + dbRemoveTable(con, "tempostgrestable") 438s + res <- dbWriteTable(con, "numerictable", dat) 438s + dat <- dbReadTable(con, "numerictable") 438s + dbRemoveTable(con, "numerictable") 438s + cat("Read Numeric values\n") 438s + 438s + ## now test the types of the colums we got 438s + if( class(dat[,1]) == "integer" ) { 438s + cat("PASS -- all integer is as expected\n") 438s + }else{ 438s + cat(paste("FAIL -- an integer became ", class(dat[,1]), "\n")) 438s + } 438s + stopifnot( class(dat[,2]) == "numeric" ) 438s + 438s + ## and test the values 438s + if( identical( dat[1,1], i)){ 438s + cat("PASS integer value is preserved") 438s + }else{ 438s + cat(paste("FAIL:", i, "changed to", dat[1,1], "\n")) 438s + } 438s + stopifnot( identical( dat[1,2], j)) 438s + cat("GOOD -- all numeric values are as expected\n") 438s + 438s + ## Test the logical mapping 438s + if (dbExistsTable(con, "testlogical")) 438s + dbRemoveTable(con, "testlogical") 438s + dbGetQuery(con,"create table testlogical (col1 boolean, col2 boolean)") 438s + 438s + i <- as.logical(TRUE) 438s + j <- as.logical(FALSE) 438s + 438s + sql <- paste("insert into testlogical ", 438s + "values (",i, "," ,j ,") ", sep="") 438s + res <- dbGetQuery(con, sql); 438s + 438s + dat <- dbReadTable(con, "testlogical") 438s + res <- dbWriteTable(con, "logicaltable", dat) 438s + dbRemoveTable(con, "testlogical") 438s + dat2 <- dbReadTable(con,"logicaltable") 438s + dbRemoveTable(con, "logicaltable") 438s + cat("Read Logical values\n") 438s + 438s + ## now test the types of the colums we got 438s + stopifnot( class(dat2[,1]) == "logical" ) 438s + stopifnot( class(dat2[,2]) == "logical" ) 438s + cat("GOOD -- all logical types are as expected\n") 438s + 438s + ## and test the values 438s + stopifnot( identical( dat2[1,1], i)) 438s + stopifnot( identical( dat2[1,2], j)) 438s + cat("GOOD -- all logical values are as expected\n") 438s + 438s + ## Test the character mapping 438s + if (dbExistsTable(con, "testchar")) 438s + dbRemoveTable(con, "testchar") 438s + dbGetQuery(con,"create table testchar (code char(3),city varchar(20),country text);") 438s + 438s + i <- as.character("IN") 438s + j <- as.character("Hyderabad") 438s + k <- as.character("India") 438s + 438s + sql <- paste("insert into testchar ", 438s + "values ('",i,"' , '",j ,"' , '",k,"') ", sep="") 438s + res <- dbGetQuery(con, sql); 438s + 438s + dat <- dbReadTable(con, "testchar") 438s + dbRemoveTable(con, "testchar") 438s + dbWriteTable(con, "testchar", dat) 438s + dat <- dbReadTable(con, "testchar") 438s + cat("Read Character values\n") 438s + 438s + ## now test the types of the colums we got 438s + stopifnot( class(dat[,1]) == "character" ) 438s + stopifnot( class(dat[,2]) == "character" ) 438s + stopifnot( class(dat[,3]) == "character" ) 438s + cat("GOOD -- all character types are as expected\n") 438s + 438s + ## and test the values 438s + ##stopifnot( identical( dat[1,1], i)) 438s + stopifnot( identical( dat[1,2], j)) 438s + stopifnot( identical( dat[1,3], k)) 438s + cat("GOOD -- all character values are as expected\n") 438s + 438s + dbRemoveTable(con, "testchar") 438s + dbRemoveTable(con, "tempostgrestable") 438s + 438s + ## Test the numeric mapping 438s + dbGetQuery(con, "create table tempostgrestable (intcolumn date, floatcolumn timestamp with time zone);") 438s + 438s + sql <- paste("insert into tempostgrestable ", 438s + "values ('2011-03-07', '2011-03-07 16:30:39') ") 438s + res <- dbGetQuery(con, sql) 438s + 438s + dat <- dbReadTable(con, "tempostgrestable") 438s + dbRemoveTable(con, "tempostgrestable") 438s + dbWriteTable(con, "tempostgrestable2", dat) 438s + dat2 <- dbReadTable(con, "tempostgrestable2") 438s + dbRemoveTable(con, "tempostgrestable2") 438s + cat("Check that read after write gets the same data types\n") 438s + 438s + ## now test the types of the colums we got 438s + if( class(dat2[1,1]) == "Date" ){ 438s + cat("PASS -- Date type is as expected\n") 438s + }else{ 438s + cat("FAIL -- Date type is other than Date: ") 438s + cat(class(dat2[1,1])) 438s + cat("\n") 438s + } 438s + if( class(dat2[1,2])[1] == "POSIXct" ){ 438s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 438s + }else{ 438s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 438s + cat(class(dat2[1,2])) 438s + cat("\n") 438s + } 438s + 438s + 438s + dbDisconnect(con) 438s + dbUnloadDriver(drv) 438s + 438s + cat("DONE\n") 438s + } 438s > 438s > 438s BEGIN TEST dbtemptable.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > 438s > ## dbWriteTable test 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 10 Sep 2009 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + stopifnot(require(datasets)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + 438s + ## connect to the default db 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + 438s + 438s + a <- dbGetQuery(con, "CREATE TABLE foo (name text)") 438s + b <- dbGetQuery(con, "INSERT INTO foo VALUES ('bar')") 438s + 438s + ## run a simple query and show the query result 438s + x <- dbSendQuery(con, "CREATE TEMPORARY TABLE xyz ON COMMIT DROP AS select * from foo limit 1; select * from xyz;") 438s + res <- fetch(x, n=-1) 438s + print(res) 438s + a <- dbGetQuery(con, "DROP TABLE foo") 438s + 438s + 438s + ## cleanup 438s + 438s + ## and disconnect 438s + dbDisconnect(con) 438s + cat("PASS -- ended without segmentation fault\n") 438s + } 438s > 438s BEGIN TEST escape.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > 438s > ## connectWithNull test 438s > ## 438s > ## test for the 'Issue 2' on the Google Code issue log 438s > ## reported in April 2009, still open ? 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 03 Oct 2009 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + stopifnot(require(datasets)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + 438s + ## connect to the default db -- replacing any of these with NULL will lead to 438s + ## a stop() call and a return to the R prompt rather than a segfault 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + st <- (postgresqlEscapeStrings(con,"aaa")) 438s + print(st) 438s + st2 <- (postgresqlEscapeStrings(con,"aa'a")) 438s + print(st2) 438s + 438s + ## and disconnect 438s + dbDisconnect(con) 438s + } 438s > 438s BEGIN TEST loadDriverAndConnect.R 438s 438s R version 4.3.2 (2023-10-31) -- "Eye Holes" 438s Copyright (C) 2023 The R Foundation for Statistical Computing 438s Platform: aarch64-unknown-linux-gnu (64-bit) 438s 438s R is free software and comes with ABSOLUTELY NO WARRANTY. 438s You are welcome to redistribute it under certain conditions. 438s Type 'license()' or 'licence()' for distribution details. 438s 438s R is a collaborative project with many contributors. 438s Type 'contributors()' for more information and 438s 'citation()' on how to cite R or R packages in publications. 438s 438s Type 'demo()' for some demos, 'help()' for on-line help, or 438s 'help.start()' for an HTML browser interface to help. 438s Type 'q()' to quit R. 438s 438s > 438s > ## First rough version of a test script 438s > ## 438s > ## Assumes that 438s > ## a) PostgreSQL is running, and 438s > ## b) the current user can connect 438s > ## both of which are not viable for release but suitable while we test 438s > ## 438s > ## Dirk Eddelbuettel, 02 Jul 2008 438s > ## 21 Oct 2008 make conditional on environment variables 438s > 438s > ## only run this if this env.var is set correctly 438s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 438s + 438s + ## try to load our module and abort if this fails 438s + stopifnot(require(RPostgreSQL)) 438s + 438s + ## load the PostgresSQL driver 438s + drv <- dbDriver("PostgreSQL") 438s + ## can't print result as it contains process id which changes print(summary(drv)) 438s + 438s + ## connect to the default db 438s + con <- dbConnect(drv, 438s + user=Sys.getenv("POSTGRES_USER"), 438s + password=Sys.getenv("POSTGRES_PASSWD"), 438s + host=Sys.getenv("POSTGRES_HOST"), 438s + dbname=Sys.getenv("POSTGRES_DATABASE"), 438s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 438s + 438s + ## run a simple query and show the query result 438s + res <- dbGetQuery(con, paste("select datname,encoding,datallowconn from pg_database", 438s + "where datname like 'template%' order by datname")) 438s + print(res) 438s + 438s + ## and disconnect 438s + dbDisconnect(con) 438s + } 438s > 438s BEGIN TEST openSendQuery.R 439s 439s R version 4.3.2 (2023-10-31) -- "Eye Holes" 439s Copyright (C) 2023 The R Foundation for Statistical Computing 439s Platform: aarch64-unknown-linux-gnu (64-bit) 439s 439s R is free software and comes with ABSOLUTELY NO WARRANTY. 439s You are welcome to redistribute it under certain conditions. 439s Type 'license()' or 'licence()' for distribution details. 439s 439s R is a collaborative project with many contributors. 439s Type 'contributors()' for more information and 439s 'citation()' on how to cite R or R packages in publications. 439s 439s Type 'demo()' for some demos, 'help()' for on-line help, or 439s 'help.start()' for an HTML browser interface to help. 439s Type 'q()' to quit R. 439s 439s > 439s > ## dbWriteTable test 439s > ## 439s > ## Assumes that 439s > ## a) PostgreSQL is running, and 439s > ## b) the current user can connect 439s > ## both of which are not viable for release but suitable while we test 439s > ## 439s > ## Dirk Eddelbuettel, 10 Sep 2009 439s > 439s > ## only run this if this env.var is set correctly 439s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 439s + 439s + ## try to load our module and abort if this fails 439s + stopifnot(require(RPostgreSQL)) 439s + stopifnot(require(datasets)) 439s + 439s + ## load the PostgresSQL driver 439s + drv <- dbDriver("PostgreSQL") 439s + 439s + ## create two independent connections 439s + con <- dbConnect(drv, 439s + user=Sys.getenv("POSTGRES_USER"), 439s + password=Sys.getenv("POSTGRES_PASSWD"), 439s + host=Sys.getenv("POSTGRES_HOST"), 439s + dbname=Sys.getenv("POSTGRES_DATABASE"), 439s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 439s + 439s + if (dbExistsTable(con, "tmptest")) { 439s + cat("Removing tmptest\n") 439s + dbRemoveTable(con, "tmptest") 439s + } 439s + # create temporary table (as a copy of any existing one) 439s + # dbGetQuery(con, "BEGIN TRANSACTION") 439s + cat("create temp table tmptest with dbGetQuery\n") 439s + dbGetQuery(con, "CREATE TEMP TABLE tmptest (f1 int)") 439s + 439s + # query temp table 439s + rs<-dbGetQuery(con, "SELECT * from tmptest") 439s + print(rs) 439s + 439s + cat("create temp table tmptest with dbSendQuery\n") 439s + dbSendQuery(con, "CREATE TEMP TABLE tmptest2(f2 int)") 439s + 439s + # query temp table 439s + rs2<-dbGetQuery(con, "SELECT * from tmptest2") 439s + print(rs2) 439s + ## and disconnect 439s + dbDisconnect(con) 439s + 439s + con <- dbConnect(drv, 439s + user=Sys.getenv("POSTGRES_USER"), 439s + password=Sys.getenv("POSTGRES_PASSWD"), 439s + host=Sys.getenv("POSTGRES_HOST"), 439s + dbname=Sys.getenv("POSTGRES_DATABASE"), 439s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 439s + 439s + if (dbExistsTable(con, "tmptest")) { 439s + cat("FAIL tmptest persisted after disconnection\n") 439s + cat("Removing tmptest\n") 439s + dbRemoveTable(con, "tmptest") 439s + }else{ 439s + cat("PASS tmptest disappeared after disconnection\n") 439s + } 439s + dbDisconnect(con) 439s + } 439s > 439s BEGIN TEST selectWithAlias.R 439s 439s R version 4.3.2 (2023-10-31) -- "Eye Holes" 439s Copyright (C) 2023 The R Foundation for Statistical Computing 439s Platform: aarch64-unknown-linux-gnu (64-bit) 439s 439s R is free software and comes with ABSOLUTELY NO WARRANTY. 439s You are welcome to redistribute it under certain conditions. 439s Type 'license()' or 'licence()' for distribution details. 439s 439s R is a collaborative project with many contributors. 439s Type 'contributors()' for more information and 439s 'citation()' on how to cite R or R packages in publications. 439s 439s Type 'demo()' for some demos, 'help()' for on-line help, or 439s 'help.start()' for an HTML browser interface to help. 439s Type 'q()' to quit R. 439s 439s > 439s > ## selectWithAlias test 439s > ## 439s > ## test for the 'Issue 1' on the Google Code issue log 439s > ## this was reported in June and fixed by Joe Conway (svr committ r100) 439s > ## 439s > ## Assumes that 439s > ## a) PostgreSQL is running, and 439s > ## b) the current user can connect 439s > ## both of which are not viable for release but suitable while we test 439s > ## 439s > ## Dirk Eddelbuettel, 03 Oct 2009 439s > 439s > ## only run this if this env.var is set correctly 439s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 439s + 439s + ## try to load our module and abort if this fails 439s + stopifnot(require(RPostgreSQL)) 439s + stopifnot(require(datasets)) 439s + 439s + ## load the PostgresSQL driver 439s + drv <- dbDriver("PostgreSQL") 439s + 439s + ## connect to the default db 439s + con <- dbConnect(drv, 439s + user=Sys.getenv("POSTGRES_USER"), 439s + password=Sys.getenv("POSTGRES_PASSWD"), 439s + host=Sys.getenv("POSTGRES_HOST"), 439s + dbname=Sys.getenv("POSTGRES_DATABASE"), 439s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 439s + 439s + if (dbExistsTable(con, "rockdata")) { 439s + print("Removing rockdata\n") 439s + dbRemoveTable(con, "rockdata") 439s + } 439s + 439s + dbWriteTable(con, "rockdata", rock) 439s + 439s + ## run a simple query and show the query result 439s + res <- dbGetQuery(con, "select area as ar, peri as pe, shape as sh, perm as pr from rockdata limit 10") 439s + print(res) 439s + 439s + ## cleanup 439s + if (dbExistsTable(con, "rockdata")) { 439s + print("Removing rockdata\n") 439s + dbRemoveTable(con, "rockdata") 439s + } 439s + 439s + ## and disconnect 439s + dbDisconnect(con) 439s + } 439s > 439s BEGIN TEST utf.R 439s 439s R version 4.3.2 (2023-10-31) -- "Eye Holes" 439s Copyright (C) 2023 The R Foundation for Statistical Computing 439s Platform: aarch64-unknown-linux-gnu (64-bit) 439s 439s R is free software and comes with ABSOLUTELY NO WARRANTY. 439s You are welcome to redistribute it under certain conditions. 439s Type 'license()' or 'licence()' for distribution details. 439s 439s R is a collaborative project with many contributors. 439s Type 'contributors()' for more information and 439s 'citation()' on how to cite R or R packages in publications. 439s 439s Type 'demo()' for some demos, 'help()' for on-line help, or 439s 'help.start()' for an HTML browser interface to help. 439s Type 'q()' to quit R. 439s 439s > ## Test of bytea conversion with insert and retrieve to the db. 439s > ## 439s > 439s > if ((Sys.getenv("POSTGRES_USER") != "") & 439s + (Sys.getenv("POSTGRES_HOST") != "") & 439s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 439s + 439s + ## try to load our module and abort if this fails 439s + stopifnot(require(RPostgreSQL)) 439s + 439s + ## load the PostgresSQL driver 439s + drv <- dbDriver("PostgreSQL") 439s + 439s + ## connect to the default db 439s + con <- dbConnect(drv, 439s + user=Sys.getenv("POSTGRES_USER"), 439s + password=Sys.getenv("POSTGRES_PASSWD"), 439s + host=Sys.getenv("POSTGRES_HOST"), 439s + dbname=Sys.getenv("POSTGRES_DATABASE"), 439s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 439s + 439s + if (dbExistsTable(con, "texttable")) 439s + dbRemoveTable(con, "texttable") 439s + 439s + x_df <- data.frame(x = c("a", "ö", "漢字"), stringsAsFactors = FALSE) 439s + 439s + dbGetQuery(con, "SHOW server_encoding") 439s + dbGetQuery(con, "SET client_encoding = 'UTF8'") 439s + dbGetQuery(con, "SHOW client_encoding") 439s + # write with client_encoding = 'UTF8' and read back what was wrote 439s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 439s + (x_db <- dbReadTable(con, "texttable")) 439s + (e <- Encoding(x_db$x)) 439s + stopifnot( e[1] == "unknown" ) 439s + stopifnot( e[2] == "UTF-8" ) 439s + stopifnot( e[3] == "UTF-8" ) 439s + cat("GOOD -- all encoding are as expected\n") 439s + 439s + x_df <- data.frame(x = c("a", "ö"), stringsAsFactors = FALSE) 439s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 439s + dbGetQuery(con, "SET client_encoding = 'LATIN1'") 439s + dbGetQuery(con, "SHOW client_encoding") 439s + # read with client_encoding = 'LATIN1' what was already in the database 439s + (x_db <- dbReadTable(con, "texttable")) 439s + (e <- Encoding(x_db$x)) 439s + stopifnot( e[1] == "unknown" ) 439s + stopifnot( e[2] == "latin1" ) 439s + cat("GOOD -- all encoding are as expected\n") 439s + 439s + # write with client_encoding = 'LATIN1' and read back what was wrote 439s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 439s + (x_db <- dbReadTable(con, "texttable")) 439s + (e <- Encoding(x_db$x)) 439s + stopifnot( e[1] == "unknown" ) 439s + stopifnot( e[2] == "latin1" ) 439s + cat("GOOD -- all encoding are as expected\n") 439s + 439s + dbRemoveTable(con, "texttable") 439s + dbDisconnect(con) 439s + dbUnloadDriver(drv) 439s + cat("DONE\n") 439s + }else{ 439s + cat("Skip because envirinmental variables are not set to tell the connection params.\n") 439s + } 439s Skip because envirinmental variables are not set to tell the connection params. 439s > 439s autopkgtest [17:42:26]: test run-unit-test: -----------------------] 440s autopkgtest [17:42:27]: test run-unit-test: - - - - - - - - - - results - - - - - - - - - - 440s run-unit-test PASS 440s autopkgtest [17:42:27]: test pkg-r-autopkgtest: preparing testbed 446s Reading package lists... 446s Building dependency tree... 446s Reading state information... 446s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 446s Starting 2 pkgProblemResolver with broken count: 0 446s Done 447s Done 447s Starting pkgProblemResolver with broken count: 0 447s Starting 2 pkgProblemResolver with broken count: 0 447s Done 448s The following additional packages will be installed: 448s build-essential cpp cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu 448s dctrl-tools g++ g++-13 g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 448s gcc-13 gcc-13-aarch64-linux-gnu gcc-aarch64-linux-gnu gfortran gfortran-13 448s gfortran-13-aarch64-linux-gnu gfortran-aarch64-linux-gnu icu-devtools 448s libasan8 libatomic1 libblas-dev libbz2-dev libc-dev-bin libc6-dev libcc1-0 448s libcrypt-dev libgcc-13-dev libgfortran-13-dev libhwasan0 libicu-dev libisl23 448s libitm1 libjpeg-dev libjpeg-turbo8-dev libjpeg8-dev liblapack-dev liblsan0 448s liblzma-dev libmpc3 libncurses-dev libnsl-dev libpcre2-16-0 libpcre2-32-0 448s libpcre2-dev libpcre2-posix3 libpkgconf3 libpng-dev libreadline-dev 448s libstdc++-13-dev libtirpc-dev libtsan2 libubsan1 linux-libc-dev pkg-config 448s pkg-r-autopkgtest pkgconf pkgconf-bin r-base-dev rpcsvc-proto zlib1g-dev 448s Suggested packages: 448s cpp-doc gcc-13-locales cpp-13-doc debtags gcc-13-doc gcc-multilib 448s manpages-dev autoconf automake libtool flex bison gdb gcc-doc 448s gdb-aarch64-linux-gnu gfortran-doc gfortran-13-doc libcoarrays-dev 448s liblapack-doc glibc-doc icu-doc liblzma-doc ncurses-doc readline-doc 448s libstdc++-13-doc texlive-base texlive-latex-base texlive-plain-generic 448s texlive-fonts-recommended texlive-fonts-extra texlive-extra-utils 448s texlive-latex-recommended texlive-latex-extra texinfo 448s Recommended packages: 448s bzip2-doc manpages manpages-dev libc-devtools libpng-tools 448s The following NEW packages will be installed: 448s build-essential cpp cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu 448s dctrl-tools g++ g++-13 g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 448s gcc-13 gcc-13-aarch64-linux-gnu gcc-aarch64-linux-gnu gfortran gfortran-13 448s gfortran-13-aarch64-linux-gnu gfortran-aarch64-linux-gnu icu-devtools 448s libasan8 libatomic1 libblas-dev libbz2-dev libc-dev-bin libc6-dev libcc1-0 448s libcrypt-dev libgcc-13-dev libgfortran-13-dev libhwasan0 libicu-dev libisl23 448s libitm1 libjpeg-dev libjpeg-turbo8-dev libjpeg8-dev liblapack-dev liblsan0 448s liblzma-dev libmpc3 libncurses-dev libnsl-dev libpcre2-16-0 libpcre2-32-0 448s libpcre2-dev libpcre2-posix3 libpkgconf3 libpng-dev libreadline-dev 448s libstdc++-13-dev libtirpc-dev libtsan2 libubsan1 linux-libc-dev pkg-config 448s pkg-r-autopkgtest pkgconf pkgconf-bin r-base-dev rpcsvc-proto zlib1g-dev 448s 0 upgraded, 61 newly installed, 0 to remove and 0 not upgraded. 448s 1 not fully installed or removed. 448s Need to get 92.9 MB of archives. 448s After this operation, 343 MB of additional disk space will be used. 448s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 dctrl-tools arm64 2.24-3build2 [65.2 kB] 448s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 libc-dev-bin arm64 2.39-0ubuntu2 [19.7 kB] 448s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 linux-libc-dev arm64 6.8.0-11.11 [1569 kB] 448s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libcrypt-dev arm64 1:4.4.36-4 [136 kB] 448s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 libtirpc-dev arm64 1.3.4+ds-1build1 [232 kB] 448s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libnsl-dev arm64 1.3.0-3 [71.9 kB] 448s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 rpcsvc-proto arm64 1.4.2-0ubuntu6 [65.4 kB] 448s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 libc6-dev arm64 2.39-0ubuntu2 [1596 kB] 448s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 libisl23 arm64 0.26-3 [713 kB] 449s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libmpc3 arm64 1.3.1-1 [55.3 kB] 449s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [10.3 MB] 449s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13 arm64 13.2.0-17ubuntu2 [1028 B] 449s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [5316 B] 449s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 cpp arm64 4:13.2.0-7ubuntu1 [22.4 kB] 449s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 libcc1-0 arm64 14-20240303-1ubuntu1 [44.7 kB] 449s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 libitm1 arm64 14-20240303-1ubuntu1 [27.7 kB] 449s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libatomic1 arm64 14-20240303-1ubuntu1 [11.4 kB] 449s Get:18 http://ftpmaster.internal/ubuntu noble/main arm64 libasan8 arm64 14-20240303-1ubuntu1 [2919 kB] 449s Get:19 http://ftpmaster.internal/ubuntu noble/main arm64 liblsan0 arm64 14-20240303-1ubuntu1 [1282 kB] 449s Get:20 http://ftpmaster.internal/ubuntu noble/main arm64 libtsan2 arm64 14-20240303-1ubuntu1 [2687 kB] 449s Get:21 http://ftpmaster.internal/ubuntu noble/main arm64 libubsan1 arm64 14-20240303-1ubuntu1 [1151 kB] 449s Get:22 http://ftpmaster.internal/ubuntu noble/main arm64 libhwasan0 arm64 14-20240303-1ubuntu1 [1597 kB] 449s Get:23 http://ftpmaster.internal/ubuntu noble/main arm64 libgcc-13-dev arm64 13.2.0-17ubuntu2 [2464 kB] 449s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [20.1 MB] 450s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13 arm64 13.2.0-17ubuntu2 [467 kB] 450s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1198 B] 450s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 gcc arm64 4:13.2.0-7ubuntu1 [5018 B] 450s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libstdc++-13-dev arm64 13.2.0-17ubuntu2 [2322 kB] 450s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [11.7 MB] 450s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13 arm64 13.2.0-17ubuntu2 [14.4 kB] 450s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 g++-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [962 B] 450s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 g++ arm64 4:13.2.0-7ubuntu1 [1082 B] 450s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 450s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 libgfortran-13-dev arm64 13.2.0-17ubuntu2 [478 kB] 450s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [10.8 MB] 450s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-13 arm64 13.2.0-17ubuntu2 [10.3 kB] 450s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1022 B] 450s Get:38 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran arm64 4:13.2.0-7ubuntu1 [1164 B] 450s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 libblas-dev arm64 3.12.0-3 [111 kB] 450s Get:40 http://ftpmaster.internal/ubuntu noble/main arm64 liblapack-dev arm64 3.12.0-3 [4293 kB] 450s Get:41 http://ftpmaster.internal/ubuntu noble/main arm64 libncurses-dev arm64 6.4+20240113-1ubuntu1 [385 kB] 450s Get:42 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libreadline-dev arm64 8.2-3.1 [177 kB] 450s Get:43 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-turbo8-dev arm64 2.1.5-2ubuntu1 [304 kB] 450s Get:44 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg8-dev arm64 8c-2ubuntu11 [1484 B] 450s Get:45 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-dev arm64 8c-2ubuntu11 [1482 B] 450s Get:46 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-16-0 arm64 10.42-4ubuntu1 [195 kB] 450s Get:47 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-32-0 arm64 10.42-4ubuntu1 [183 kB] 450s Get:48 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-posix3 arm64 10.42-4ubuntu1 [6654 B] 450s Get:49 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-dev arm64 10.42-4ubuntu1 [679 kB] 451s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 zlib1g-dev arm64 1:1.3.dfsg-3ubuntu1 [895 kB] 451s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 libpng-dev arm64 1.6.43-1 [266 kB] 451s Get:52 http://ftpmaster.internal/ubuntu noble/main arm64 libbz2-dev arm64 1.0.8-5ubuntu1 [35.8 kB] 451s Get:53 http://ftpmaster.internal/ubuntu noble/main arm64 liblzma-dev arm64 5.4.5-0.3 [209 kB] 451s Get:54 http://ftpmaster.internal/ubuntu noble/main arm64 icu-devtools arm64 74.2-1ubuntu1 [209 kB] 451s Get:55 http://ftpmaster.internal/ubuntu noble/main arm64 libicu-dev arm64 74.2-1ubuntu1 [11.9 MB] 451s Get:56 http://ftpmaster.internal/ubuntu noble/main arm64 libpkgconf3 arm64 1.8.1-2 [31.2 kB] 451s Get:57 http://ftpmaster.internal/ubuntu noble/main arm64 pkgconf-bin arm64 1.8.1-2 [20.4 kB] 451s Get:58 http://ftpmaster.internal/ubuntu noble/main arm64 pkgconf arm64 1.8.1-2 [16.7 kB] 451s Get:59 http://ftpmaster.internal/ubuntu noble/main arm64 pkg-config arm64 1.8.1-2 [7170 B] 451s Get:60 http://ftpmaster.internal/ubuntu noble/universe arm64 r-base-dev all 4.3.2-1build1 [4336 B] 451s Get:61 http://ftpmaster.internal/ubuntu noble/universe arm64 pkg-r-autopkgtest all 20231212ubuntu1 [6448 B] 452s Fetched 92.9 MB in 3s (30.3 MB/s) 452s Selecting previously unselected package dctrl-tools. 452s (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 ... 76576 files and directories currently installed.) 452s Preparing to unpack .../00-dctrl-tools_2.24-3build2_arm64.deb ... 452s Unpacking dctrl-tools (2.24-3build2) ... 452s Selecting previously unselected package libc-dev-bin. 452s Preparing to unpack .../01-libc-dev-bin_2.39-0ubuntu2_arm64.deb ... 452s Unpacking libc-dev-bin (2.39-0ubuntu2) ... 452s Selecting previously unselected package linux-libc-dev:arm64. 452s Preparing to unpack .../02-linux-libc-dev_6.8.0-11.11_arm64.deb ... 452s Unpacking linux-libc-dev:arm64 (6.8.0-11.11) ... 452s Selecting previously unselected package libcrypt-dev:arm64. 452s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.36-4_arm64.deb ... 452s Unpacking libcrypt-dev:arm64 (1:4.4.36-4) ... 452s Selecting previously unselected package libtirpc-dev:arm64. 452s Preparing to unpack .../04-libtirpc-dev_1.3.4+ds-1build1_arm64.deb ... 452s Unpacking libtirpc-dev:arm64 (1.3.4+ds-1build1) ... 452s Selecting previously unselected package libnsl-dev:arm64. 452s Preparing to unpack .../05-libnsl-dev_1.3.0-3_arm64.deb ... 452s Unpacking libnsl-dev:arm64 (1.3.0-3) ... 452s Selecting previously unselected package rpcsvc-proto. 452s Preparing to unpack .../06-rpcsvc-proto_1.4.2-0ubuntu6_arm64.deb ... 452s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 452s Selecting previously unselected package libc6-dev:arm64. 452s Preparing to unpack .../07-libc6-dev_2.39-0ubuntu2_arm64.deb ... 452s Unpacking libc6-dev:arm64 (2.39-0ubuntu2) ... 452s Selecting previously unselected package libisl23:arm64. 452s Preparing to unpack .../08-libisl23_0.26-3_arm64.deb ... 452s Unpacking libisl23:arm64 (0.26-3) ... 452s Selecting previously unselected package libmpc3:arm64. 452s Preparing to unpack .../09-libmpc3_1.3.1-1_arm64.deb ... 452s Unpacking libmpc3:arm64 (1.3.1-1) ... 452s Selecting previously unselected package cpp-13-aarch64-linux-gnu. 452s Preparing to unpack .../10-cpp-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 452s Unpacking cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 453s Selecting previously unselected package cpp-13. 453s Preparing to unpack .../11-cpp-13_13.2.0-17ubuntu2_arm64.deb ... 453s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 453s Selecting previously unselected package cpp-aarch64-linux-gnu. 453s Preparing to unpack .../12-cpp-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 453s Unpacking cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 453s Selecting previously unselected package cpp. 453s Preparing to unpack .../13-cpp_4%3a13.2.0-7ubuntu1_arm64.deb ... 453s Unpacking cpp (4:13.2.0-7ubuntu1) ... 453s Selecting previously unselected package libcc1-0:arm64. 453s Preparing to unpack .../14-libcc1-0_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libcc1-0:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libitm1:arm64. 453s Preparing to unpack .../15-libitm1_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libitm1:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libatomic1:arm64. 453s Preparing to unpack .../16-libatomic1_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libatomic1:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libasan8:arm64. 453s Preparing to unpack .../17-libasan8_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libasan8:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package liblsan0:arm64. 453s Preparing to unpack .../18-liblsan0_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking liblsan0:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libtsan2:arm64. 453s Preparing to unpack .../19-libtsan2_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libtsan2:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libubsan1:arm64. 453s Preparing to unpack .../20-libubsan1_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libubsan1:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libhwasan0:arm64. 453s Preparing to unpack .../21-libhwasan0_14-20240303-1ubuntu1_arm64.deb ... 453s Unpacking libhwasan0:arm64 (14-20240303-1ubuntu1) ... 453s Selecting previously unselected package libgcc-13-dev:arm64. 453s Preparing to unpack .../22-libgcc-13-dev_13.2.0-17ubuntu2_arm64.deb ... 453s Unpacking libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 453s Selecting previously unselected package gcc-13-aarch64-linux-gnu. 453s Preparing to unpack .../23-gcc-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 453s Unpacking gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 454s Selecting previously unselected package gcc-13. 454s Preparing to unpack .../24-gcc-13_13.2.0-17ubuntu2_arm64.deb ... 454s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 454s Selecting previously unselected package gcc-aarch64-linux-gnu. 454s Preparing to unpack .../25-gcc-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 454s Unpacking gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 454s Selecting previously unselected package gcc. 454s Preparing to unpack .../26-gcc_4%3a13.2.0-7ubuntu1_arm64.deb ... 454s Unpacking gcc (4:13.2.0-7ubuntu1) ... 454s Selecting previously unselected package libstdc++-13-dev:arm64. 454s Preparing to unpack .../27-libstdc++-13-dev_13.2.0-17ubuntu2_arm64.deb ... 454s Unpacking libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 454s Selecting previously unselected package g++-13-aarch64-linux-gnu. 454s Preparing to unpack .../28-g++-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 454s Unpacking g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 454s Selecting previously unselected package g++-13. 454s Preparing to unpack .../29-g++-13_13.2.0-17ubuntu2_arm64.deb ... 454s Unpacking g++-13 (13.2.0-17ubuntu2) ... 454s Selecting previously unselected package g++-aarch64-linux-gnu. 454s Preparing to unpack .../30-g++-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 454s Unpacking g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 454s Selecting previously unselected package g++. 455s Preparing to unpack .../31-g++_4%3a13.2.0-7ubuntu1_arm64.deb ... 455s Unpacking g++ (4:13.2.0-7ubuntu1) ... 455s Selecting previously unselected package build-essential. 455s Preparing to unpack .../32-build-essential_12.10ubuntu1_arm64.deb ... 455s Unpacking build-essential (12.10ubuntu1) ... 455s Selecting previously unselected package libgfortran-13-dev:arm64. 455s Preparing to unpack .../33-libgfortran-13-dev_13.2.0-17ubuntu2_arm64.deb ... 455s Unpacking libgfortran-13-dev:arm64 (13.2.0-17ubuntu2) ... 455s Selecting previously unselected package gfortran-13-aarch64-linux-gnu. 455s Preparing to unpack .../34-gfortran-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 455s Unpacking gfortran-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 455s Selecting previously unselected package gfortran-13. 455s Preparing to unpack .../35-gfortran-13_13.2.0-17ubuntu2_arm64.deb ... 455s Unpacking gfortran-13 (13.2.0-17ubuntu2) ... 455s Selecting previously unselected package gfortran-aarch64-linux-gnu. 455s Preparing to unpack .../36-gfortran-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 455s Unpacking gfortran-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 455s Selecting previously unselected package gfortran. 455s Preparing to unpack .../37-gfortran_4%3a13.2.0-7ubuntu1_arm64.deb ... 455s Unpacking gfortran (4:13.2.0-7ubuntu1) ... 455s Selecting previously unselected package libblas-dev:arm64. 455s Preparing to unpack .../38-libblas-dev_3.12.0-3_arm64.deb ... 455s Unpacking libblas-dev:arm64 (3.12.0-3) ... 455s Selecting previously unselected package liblapack-dev:arm64. 455s Preparing to unpack .../39-liblapack-dev_3.12.0-3_arm64.deb ... 455s Unpacking liblapack-dev:arm64 (3.12.0-3) ... 455s Selecting previously unselected package libncurses-dev:arm64. 455s Preparing to unpack .../40-libncurses-dev_6.4+20240113-1ubuntu1_arm64.deb ... 455s Unpacking libncurses-dev:arm64 (6.4+20240113-1ubuntu1) ... 455s Selecting previously unselected package libreadline-dev:arm64. 455s Preparing to unpack .../41-libreadline-dev_8.2-3.1_arm64.deb ... 455s Unpacking libreadline-dev:arm64 (8.2-3.1) ... 455s Selecting previously unselected package libjpeg-turbo8-dev:arm64. 455s Preparing to unpack .../42-libjpeg-turbo8-dev_2.1.5-2ubuntu1_arm64.deb ... 455s Unpacking libjpeg-turbo8-dev:arm64 (2.1.5-2ubuntu1) ... 455s Selecting previously unselected package libjpeg8-dev:arm64. 455s Preparing to unpack .../43-libjpeg8-dev_8c-2ubuntu11_arm64.deb ... 455s Unpacking libjpeg8-dev:arm64 (8c-2ubuntu11) ... 455s Selecting previously unselected package libjpeg-dev:arm64. 455s Preparing to unpack .../44-libjpeg-dev_8c-2ubuntu11_arm64.deb ... 455s Unpacking libjpeg-dev:arm64 (8c-2ubuntu11) ... 455s Selecting previously unselected package libpcre2-16-0:arm64. 455s Preparing to unpack .../45-libpcre2-16-0_10.42-4ubuntu1_arm64.deb ... 455s Unpacking libpcre2-16-0:arm64 (10.42-4ubuntu1) ... 456s Selecting previously unselected package libpcre2-32-0:arm64. 456s Preparing to unpack .../46-libpcre2-32-0_10.42-4ubuntu1_arm64.deb ... 456s Unpacking libpcre2-32-0:arm64 (10.42-4ubuntu1) ... 456s Selecting previously unselected package libpcre2-posix3:arm64. 456s Preparing to unpack .../47-libpcre2-posix3_10.42-4ubuntu1_arm64.deb ... 456s Unpacking libpcre2-posix3:arm64 (10.42-4ubuntu1) ... 456s Selecting previously unselected package libpcre2-dev:arm64. 456s Preparing to unpack .../48-libpcre2-dev_10.42-4ubuntu1_arm64.deb ... 456s Unpacking libpcre2-dev:arm64 (10.42-4ubuntu1) ... 456s Selecting previously unselected package zlib1g-dev:arm64. 456s Preparing to unpack .../49-zlib1g-dev_1%3a1.3.dfsg-3ubuntu1_arm64.deb ... 456s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg-3ubuntu1) ... 456s Selecting previously unselected package libpng-dev:arm64. 456s Preparing to unpack .../50-libpng-dev_1.6.43-1_arm64.deb ... 456s Unpacking libpng-dev:arm64 (1.6.43-1) ... 456s Selecting previously unselected package libbz2-dev:arm64. 456s Preparing to unpack .../51-libbz2-dev_1.0.8-5ubuntu1_arm64.deb ... 456s Unpacking libbz2-dev:arm64 (1.0.8-5ubuntu1) ... 456s Selecting previously unselected package liblzma-dev:arm64. 456s Preparing to unpack .../52-liblzma-dev_5.4.5-0.3_arm64.deb ... 456s Unpacking liblzma-dev:arm64 (5.4.5-0.3) ... 456s Selecting previously unselected package icu-devtools. 456s Preparing to unpack .../53-icu-devtools_74.2-1ubuntu1_arm64.deb ... 456s Unpacking icu-devtools (74.2-1ubuntu1) ... 456s Selecting previously unselected package libicu-dev:arm64. 456s Preparing to unpack .../54-libicu-dev_74.2-1ubuntu1_arm64.deb ... 456s Unpacking libicu-dev:arm64 (74.2-1ubuntu1) ... 457s Selecting previously unselected package libpkgconf3:arm64. 457s Preparing to unpack .../55-libpkgconf3_1.8.1-2_arm64.deb ... 457s Unpacking libpkgconf3:arm64 (1.8.1-2) ... 457s Selecting previously unselected package pkgconf-bin. 457s Preparing to unpack .../56-pkgconf-bin_1.8.1-2_arm64.deb ... 457s Unpacking pkgconf-bin (1.8.1-2) ... 457s Selecting previously unselected package pkgconf:arm64. 457s Preparing to unpack .../57-pkgconf_1.8.1-2_arm64.deb ... 457s Unpacking pkgconf:arm64 (1.8.1-2) ... 457s Selecting previously unselected package pkg-config:arm64. 457s Preparing to unpack .../58-pkg-config_1.8.1-2_arm64.deb ... 457s Unpacking pkg-config:arm64 (1.8.1-2) ... 457s Selecting previously unselected package r-base-dev. 458s Preparing to unpack .../59-r-base-dev_4.3.2-1build1_all.deb ... 458s Unpacking r-base-dev (4.3.2-1build1) ... 458s Selecting previously unselected package pkg-r-autopkgtest. 458s Preparing to unpack .../60-pkg-r-autopkgtest_20231212ubuntu1_all.deb ... 458s Unpacking pkg-r-autopkgtest (20231212ubuntu1) ... 458s Setting up linux-libc-dev:arm64 (6.8.0-11.11) ... 458s Setting up libpcre2-16-0:arm64 (10.42-4ubuntu1) ... 458s Setting up libpcre2-32-0:arm64 (10.42-4ubuntu1) ... 458s Setting up libtirpc-dev:arm64 (1.3.4+ds-1build1) ... 458s Setting up libpkgconf3:arm64 (1.8.1-2) ... 458s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 458s Setting up libmpc3:arm64 (1.3.1-1) ... 458s Setting up libatomic1:arm64 (14-20240303-1ubuntu1) ... 458s Setting up icu-devtools (74.2-1ubuntu1) ... 458s Setting up pkgconf-bin (1.8.1-2) ... 458s Setting up liblzma-dev:arm64 (5.4.5-0.3) ... 458s Setting up libubsan1:arm64 (14-20240303-1ubuntu1) ... 458s Setting up libpcre2-posix3:arm64 (10.42-4ubuntu1) ... 458s Setting up libnsl-dev:arm64 (1.3.0-3) ... 458s Setting up libhwasan0:arm64 (14-20240303-1ubuntu1) ... 458s Setting up libcrypt-dev:arm64 (1:4.4.36-4) ... 458s Setting up libasan8:arm64 (14-20240303-1ubuntu1) ... 458s Setting up libtsan2:arm64 (14-20240303-1ubuntu1) ... 458s Setting up libisl23:arm64 (0.26-3) ... 458s Setting up libc-dev-bin (2.39-0ubuntu2) ... 458s Setting up libcc1-0:arm64 (14-20240303-1ubuntu1) ... 458s Setting up liblsan0:arm64 (14-20240303-1ubuntu1) ... 458s Setting up libblas-dev:arm64 (3.12.0-3) ... 458s update-alternatives: using /usr/lib/aarch64-linux-gnu/blas/libblas.so to provide /usr/lib/aarch64-linux-gnu/libblas.so (libblas.so-aarch64-linux-gnu) in auto mode 458s Setting up dctrl-tools (2.24-3build2) ... 458s Setting up libitm1:arm64 (14-20240303-1ubuntu1) ... 458s Setting up cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 458s Setting up pkgconf:arm64 (1.8.1-2) ... 458s Setting up cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 458s Setting up liblapack-dev:arm64 (3.12.0-3) ... 458s update-alternatives: using /usr/lib/aarch64-linux-gnu/lapack/liblapack.so to provide /usr/lib/aarch64-linux-gnu/liblapack.so (liblapack.so-aarch64-linux-gnu) in auto mode 458s Setting up pkg-config:arm64 (1.8.1-2) ... 458s Setting up libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 458s Setting up libc6-dev:arm64 (2.39-0ubuntu2) ... 458s Setting up libgfortran-13-dev:arm64 (13.2.0-17ubuntu2) ... 458s Setting up libicu-dev:arm64 (74.2-1ubuntu1) ... 458s Setting up libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 458s Setting up libbz2-dev:arm64 (1.0.8-5ubuntu1) ... 458s Setting up libjpeg-turbo8-dev:arm64 (2.1.5-2ubuntu1) ... 458s Setting up libncurses-dev:arm64 (6.4+20240113-1ubuntu1) ... 458s Setting up libpcre2-dev:arm64 (10.42-4ubuntu1) ... 458s Setting up cpp-13 (13.2.0-17ubuntu2) ... 458s Setting up gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 458s Setting up libreadline-dev:arm64 (8.2-3.1) ... 458s Setting up gcc-13 (13.2.0-17ubuntu2) ... 458s Setting up zlib1g-dev:arm64 (1:1.3.dfsg-3ubuntu1) ... 458s Setting up cpp (4:13.2.0-7ubuntu1) ... 458s Setting up libjpeg8-dev:arm64 (8c-2ubuntu11) ... 458s Setting up g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 458s Setting up gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 458s Setting up g++-13 (13.2.0-17ubuntu2) ... 458s Setting up libpng-dev:arm64 (1.6.43-1) ... 458s Setting up libjpeg-dev:arm64 (8c-2ubuntu11) ... 458s Setting up gfortran-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 458s Setting up gcc (4:13.2.0-7ubuntu1) ... 458s Setting up gfortran-13 (13.2.0-17ubuntu2) ... 458s Setting up g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 458s Setting up gfortran-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 458s Setting up gfortran (4:13.2.0-7ubuntu1) ... 458s update-alternatives: using /usr/bin/gfortran to provide /usr/bin/f95 (f95) in auto mode 458s update-alternatives: warning: skip creation of /usr/share/man/man1/f95.1.gz because associated file /usr/share/man/man1/gfortran.1.gz (of link group f95) doesn't exist 458s update-alternatives: using /usr/bin/gfortran to provide /usr/bin/f77 (f77) in auto mode 458s update-alternatives: warning: skip creation of /usr/share/man/man1/f77.1.gz because associated file /usr/share/man/man1/gfortran.1.gz (of link group f77) doesn't exist 458s Setting up g++ (4:13.2.0-7ubuntu1) ... 458s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 458s Setting up build-essential (12.10ubuntu1) ... 458s Setting up r-base-dev (4.3.2-1build1) ... 458s Setting up pkg-r-autopkgtest (20231212ubuntu1) ... 458s Setting up autopkgtest-satdep (0) ... 458s Processing triggers for man-db (2.12.0-3) ... 459s Processing triggers for install-info (7.1-3) ... 459s Processing triggers for libc-bin (2.39-0ubuntu2) ... 463s (Reading database ... 80135 files and directories currently installed.) 463s Removing autopkgtest-satdep (0) ... 464s autopkgtest [17:42:51]: test pkg-r-autopkgtest: /usr/share/dh-r/pkg-r-autopkgtest 464s autopkgtest [17:42:51]: test pkg-r-autopkgtest: [----------------------- 465s Test: Try to load the R library RPostgreSQL 465s 465s R version 4.3.2 (2023-10-31) -- "Eye Holes" 465s Copyright (C) 2023 The R Foundation for Statistical Computing 465s Platform: aarch64-unknown-linux-gnu (64-bit) 465s 465s R is free software and comes with ABSOLUTELY NO WARRANTY. 465s You are welcome to redistribute it under certain conditions. 465s Type 'license()' or 'licence()' for distribution details. 465s 465s R is a collaborative project with many contributors. 465s Type 'contributors()' for more information and 465s 'citation()' on how to cite R or R packages in publications. 465s 465s Type 'demo()' for some demos, 'help()' for on-line help, or 465s 'help.start()' for an HTML browser interface to help. 465s Type 'q()' to quit R. 465s 465s > library('RPostgreSQL') 465s Loading required package: DBI 465s > 465s > 465s Other tests are currently unsupported! 465s They will be progressively added. 466s autopkgtest [17:42:53]: test pkg-r-autopkgtest: -----------------------] 467s autopkgtest [17:42:54]: test pkg-r-autopkgtest: - - - - - - - - - - results - - - - - - - - - - 467s pkg-r-autopkgtest PASS 467s autopkgtest [17:42:54]: @@@@@@@@@@@@@@@@@@@@ summary 467s run-unit-test PASS 467s pkg-r-autopkgtest PASS 479s Creating nova instance adt-noble-arm64-r-cran-rpostgresql-20240311-173506-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-arm64-server-20240311.img (UUID 900cfff9-7f1a-42c7-81a7-22635cd2a5f9)...