0s autopkgtest [19:58:14]: starting date and time: 2024-03-16 19:58:14+0000 0s autopkgtest [19:58:14]: git checkout: b506e79c ssh-setup/nova: fix ARCH having two lines of data 0s autopkgtest [19:58:14]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.x38431xn/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:r-base,src:curl,src:glib2.0,src:libpng1.6,src:libpsl,src:libtirpc,src:libxt,src:openssl,src:orthanc-python,src:readline,src:wp2latex --apt-upgrade r-cran-rpostgresql --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=r-base/4.3.3-2build1 curl/8.5.0-2ubuntu7 glib2.0/2.79.3-3ubuntu5 libpng1.6/1.6.43-3 libpsl/0.21.2-1.1 libtirpc/1.3.4+ds-1.1 libxt/1:1.2.1-1.2 openssl/3.0.13-0ubuntu1 orthanc-python/4.1+ds-2build3 readline/8.2-3.1 wp2latex/4.4~ds-1build1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-17.secgroup --name adt-noble-arm64-r-cran-rpostgresql-20240316-195814-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --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/ 150s autopkgtest [20:00:44]: testbed dpkg architecture: arm64 151s autopkgtest [20:00:44]: testbed apt version: 2.7.12 151s autopkgtest [20:00:44]: @@@@@@@@@@@@@@@@@@@@ test bed setup 151s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 151s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [474 kB] 151s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [51.4 kB] 151s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 151s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [3704 kB] 151s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [646 kB] 151s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 151s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [33.6 kB] 151s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 151s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [4012 kB] 151s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 151s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [55.5 kB] 151s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 153s Fetched 9112 kB in 2s (5528 kB/s) 153s Reading package lists... 156s Reading package lists... 156s Building dependency tree... 156s Reading state information... 157s Calculating upgrade... 157s The following packages will be REMOVED: 157s libglib2.0-0 libssl3 157s The following NEW packages will be installed: 157s libglib2.0-0t64 libssl3t64 xdg-user-dirs 157s The following packages have been kept back: 157s curl 157s The following packages will be upgraded: 157s gir1.2-glib-2.0 libglib2.0-data libtirpc-common openssl readline-common 157s ubuntu-minimal ubuntu-standard 157s 7 upgraded, 3 newly installed, 2 to remove and 1 not upgraded. 157s Need to get 4613 kB of archives. 157s After this operation, 211 kB of additional disk space will be used. 157s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 gir1.2-glib-2.0 arm64 2.79.3-3ubuntu5 [182 kB] 158s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libglib2.0-0t64 arm64 2.79.3-3ubuntu5 [1527 kB] 158s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 openssl arm64 3.0.13-0ubuntu1 [983 kB] 158s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libssl3t64 arm64 3.0.13-0ubuntu1 [1770 kB] 158s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libglib2.0-data all 2.79.3-3ubuntu5 [46.6 kB] 158s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libtirpc-common all 1.3.4+ds-1.1 [8018 B] 158s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 readline-common all 8.2-3.1 [56.4 kB] 158s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-minimal arm64 1.536 [10.7 kB] 158s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 xdg-user-dirs arm64 0.18-1 [18.1 kB] 158s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-standard arm64 1.536 [10.7 kB] 158s Fetched 4613 kB in 1s (6140 kB/s) 159s (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.) 159s Preparing to unpack .../gir1.2-glib-2.0_2.79.3-3ubuntu5_arm64.deb ... 159s Unpacking gir1.2-glib-2.0:arm64 (2.79.3-3ubuntu5) over (2.79.2-1~ubuntu1) ... 159s dpkg: libglib2.0-0:arm64: dependency problems, but removing anyway as you requested: 159s udisks2 depends on libglib2.0-0 (>= 2.77.0). 159s shared-mime-info depends on libglib2.0-0 (>= 2.75.3). 159s python3-gi depends on libglib2.0-0 (>= 2.77.0). 159s python3-dbus depends on libglib2.0-0 (>= 2.16.0). 159s netplan.io depends on libglib2.0-0 (>= 2.70.0). 159s netplan-generator depends on libglib2.0-0 (>= 2.70.0). 159s libxmlb2:arm64 depends on libglib2.0-0 (>= 2.54.0). 159s libvolume-key1:arm64 depends on libglib2.0-0 (>= 2.18.0). 159s libudisks2-0:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libqrtr-glib0:arm64 depends on libglib2.0-0 (>= 2.56). 159s libqmi-proxy depends on libglib2.0-0 (>= 2.30.0). 159s libqmi-glib5:arm64 depends on libglib2.0-0 (>= 2.54.0). 159s libpolkit-gobject-1-0:arm64 depends on libglib2.0-0 (>= 2.38.0). 159s libpolkit-agent-1-0:arm64 depends on libglib2.0-0 (>= 2.38.0). 159s libnetplan0:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libmm-glib0:arm64 depends on libglib2.0-0 (>= 2.62.0). 159s libmbim-proxy depends on libglib2.0-0 (>= 2.56). 159s libmbim-glib4:arm64 depends on libglib2.0-0 (>= 2.56). 159s libjson-glib-1.0-0:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libjcat1:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libgusb2:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libgudev-1.0-0:arm64 depends on libglib2.0-0 (>= 2.38.0). 159s libgirepository-1.0-1:arm64 depends on libglib2.0-0 (>= 2.79.0). 159s libfwupd2:arm64 depends on libglib2.0-0 (>= 2.79.0). 159s libblockdev3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-utils3:arm64 depends on libglib2.0-0 (>= 2.75.3). 159s libblockdev-swap3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-part3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-nvme3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-mdraid3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-loop3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-fs3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s libblockdev-crypto3:arm64 depends on libglib2.0-0 (>= 2.42.2). 159s fwupd depends on libglib2.0-0 (>= 2.79.0). 159s bolt depends on libglib2.0-0 (>= 2.56.0). 159s 159s (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.) 159s Removing libglib2.0-0:arm64 (2.79.2-1~ubuntu1) ... 159s Selecting previously unselected package libglib2.0-0t64:arm64. 159s (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 ... 74733 files and directories currently installed.) 159s Preparing to unpack .../libglib2.0-0t64_2.79.3-3ubuntu5_arm64.deb ... 159s libglib2.0-0t64.preinst: Removing /var/lib/dpkg/info/libglib2.0-0:arm64.postrm to avoid loss of /usr/share/glib-2.0/schemas/gschemas.compiled... 159s removed '/var/lib/dpkg/info/libglib2.0-0:arm64.postrm' 159s Unpacking libglib2.0-0t64:arm64 (2.79.3-3ubuntu5) ... 159s Preparing to unpack .../openssl_3.0.13-0ubuntu1_arm64.deb ... 159s Unpacking openssl (3.0.13-0ubuntu1) over (3.0.10-1ubuntu4) ... 161s dpkg: libssl3:arm64: dependency problems, but removing anyway as you requested: 161s wget depends on libssl3 (>= 3.0.0). 161s u-boot-tools depends on libssl3 (>= 3.0.0). 161s tnftp depends on libssl3 (>= 3.0.0). 161s tcpdump depends on libssl3 (>= 3.0.0). 161s systemd-resolved depends on libssl3 (>= 3.0.0). 161s systemd depends on libssl3 (>= 3.0.0). 161s sudo depends on libssl3 (>= 3.0.0). 161s sbsigntool depends on libssl3 (>= 3.0.0). 161s rsync depends on libssl3 (>= 3.0.0). 161s python3-cryptography depends on libssl3 (>= 3.0.0). 161s openssh-server depends on libssl3 (>= 3.0.10). 161s openssh-client depends on libssl3 (>= 3.0.10). 161s mtd-utils depends on libssl3 (>= 3.0.0). 161s mokutil depends on libssl3 (>= 3.0.0). 161s linux-headers-6.8.0-11-generic depends on libssl3 (>= 3.0.0). 161s libsystemd-shared:arm64 depends on libssl3 (>= 3.0.0). 161s libssh-4:arm64 depends on libssl3 (>= 3.0.0). 161s libsasl2-modules:arm64 depends on libssl3 (>= 3.0.0). 161s libsasl2-2:arm64 depends on libssl3 (>= 3.0.0). 161s libpython3.12-minimal:arm64 depends on libssl3 (>= 3.0.0). 161s libnvme1 depends on libssl3 (>= 3.0.0). 161s libkrb5-3:arm64 depends on libssl3 (>= 3.0.0). 161s libkmod2:arm64 depends on libssl3 (>= 3.0.0). 161s libfido2-1:arm64 depends on libssl3 (>= 3.0.0). 161s libcurl4:arm64 depends on libssl3 (>= 3.0.0). 161s libcryptsetup12:arm64 depends on libssl3 (>= 3.0.0). 161s kmod depends on libssl3 (>= 3.0.0). 161s dhcpcd-base depends on libssl3 (>= 3.0.0). 161s bind9-libs:arm64 depends on libssl3 (>= 3.0.0). 161s 161s (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.) 161s Removing libssl3:arm64 (3.0.10-1ubuntu4) ... 161s Selecting previously unselected package libssl3t64:arm64. 161s (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 ... 74747 files and directories currently installed.) 161s Preparing to unpack .../0-libssl3t64_3.0.13-0ubuntu1_arm64.deb ... 161s Unpacking libssl3t64:arm64 (3.0.13-0ubuntu1) ... 161s Preparing to unpack .../1-libglib2.0-data_2.79.3-3ubuntu5_all.deb ... 161s Unpacking libglib2.0-data (2.79.3-3ubuntu5) over (2.79.2-1~ubuntu1) ... 161s Preparing to unpack .../2-libtirpc-common_1.3.4+ds-1.1_all.deb ... 161s Unpacking libtirpc-common (1.3.4+ds-1.1) over (1.3.4+ds-1build1) ... 161s Preparing to unpack .../3-readline-common_8.2-3.1_all.deb ... 161s Unpacking readline-common (8.2-3.1) over (8.2-3) ... 161s Preparing to unpack .../4-ubuntu-minimal_1.536_arm64.deb ... 161s Unpacking ubuntu-minimal (1.536) over (1.535) ... 161s Selecting previously unselected package xdg-user-dirs. 161s Preparing to unpack .../5-xdg-user-dirs_0.18-1_arm64.deb ... 161s Unpacking xdg-user-dirs (0.18-1) ... 161s Preparing to unpack .../6-ubuntu-standard_1.536_arm64.deb ... 161s Unpacking ubuntu-standard (1.536) over (1.535) ... 161s Setting up ubuntu-minimal (1.536) ... 161s Setting up xdg-user-dirs (0.18-1) ... 161s Setting up libssl3t64:arm64 (3.0.13-0ubuntu1) ... 161s Setting up libtirpc-common (1.3.4+ds-1.1) ... 161s Setting up ubuntu-standard (1.536) ... 161s Setting up libglib2.0-0t64:arm64 (2.79.3-3ubuntu5) ... 161s No schema files found: doing nothing. 161s Setting up libglib2.0-data (2.79.3-3ubuntu5) ... 161s Setting up gir1.2-glib-2.0:arm64 (2.79.3-3ubuntu5) ... 161s Setting up openssl (3.0.13-0ubuntu1) ... 161s Setting up readline-common (8.2-3.1) ... 161s Processing triggers for man-db (2.12.0-3) ... 161s Processing triggers for install-info (7.1-3) ... 161s Processing triggers for libc-bin (2.39-0ubuntu2) ... 161s Reading package lists... 161s Building dependency tree... 161s Reading state information... 162s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 162s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 162s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 162s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 163s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 164s Reading package lists... 164s Reading package lists... 164s Building dependency tree... 164s Reading state information... 165s Calculating upgrade... 165s The following packages have been kept back: 165s curl 165s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 165s Reading package lists... 166s Building dependency tree... 166s Reading state information... 166s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 169s autopkgtest [20:01:03]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 169s autopkgtest [20:01:03]: @@@@@@@@@@@@@@@@@@@@ apt-source r-cran-rpostgresql 171s Get:1 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (dsc) [2173 B] 171s Get:2 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (tar) [122 kB] 171s Get:3 http://ftpmaster.internal/ubuntu noble/universe r-cran-rpostgresql 0.7-6+dfsg-1 (diff) [3600 B] 172s gpgv: Signature made Thu Jan 18 13:14:53 2024 UTC 172s gpgv: using RSA key F1F007320A035541F0A663CA578A0494D1C646D1 172s gpgv: issuer "tille@debian.org" 172s gpgv: Can't check signature: No public key 172s dpkg-source: warning: cannot verify inline signature for ./r-cran-rpostgresql_0.7-6+dfsg-1.dsc: no acceptable signature found 172s autopkgtest [20:01:06]: testing package r-cran-rpostgresql version 0.7-6+dfsg-1 172s autopkgtest [20:01:06]: build not needed 173s autopkgtest [20:01:07]: test run-unit-test: preparing testbed 175s Reading package lists... 175s Building dependency tree... 175s Reading state information... 175s Starting pkgProblemResolver with broken count: 0 175s Starting 2 pkgProblemResolver with broken count: 0 175s Done 176s The following additional packages will be installed: 176s curl fontconfig fontconfig-config fonts-dejavu-core fonts-dejavu-mono 176s libblas3 libcairo2 libcurl4t64 libdatrie1 libdeflate0 libfontconfig1 176s libgfortran5 libgomp1 libgraphite2-3 libharfbuzz0b libice6 libjbig0 176s libjpeg-turbo8 libjpeg8 liblapack3 liblerc4 libpango-1.0-0 176s libpangocairo-1.0-0 libpangoft2-1.0-0 libpaper-utils libpaper1 libpixman-1-0 176s libpng16-16t64 libpq5 libpsl5t64 libreadline8t64 libsharpyuv0 libsm6 176s libtcl8.6 libthai-data libthai0 libtiff6 libtirpc3t64 libtk8.6 libwebp7 176s libxcb-render0 libxcb-shm0 libxft2 libxrender1 libxss1 libxt6t64 r-base-core 176s r-cran-dbi r-cran-littler r-cran-rpostgresql unzip x11-common xdg-utils zip 176s Suggested packages: 176s tcl8.6 tk8.6 elpa-ess r-doc-info | r-doc-pdf r-mathlib r-base-html 176s r-cran-rmysql r-cran-getopt 176s Recommended packages: 176s r-recommended r-base-dev r-doc-html libfile-mimeinfo-perl libnet-dbus-perl 176s libx11-protocol-perl x11-utils x11-xserver-utils 176s The following packages will be REMOVED: 176s libcurl4 libpng16-16 libpsl5 libreadline8 libtirpc3 176s The following NEW packages will be installed: 176s autopkgtest-satdep fontconfig fontconfig-config fonts-dejavu-core 176s fonts-dejavu-mono libblas3 libcairo2 libcurl4t64 libdatrie1 libdeflate0 176s libfontconfig1 libgfortran5 libgomp1 libgraphite2-3 libharfbuzz0b libice6 176s libjbig0 libjpeg-turbo8 libjpeg8 liblapack3 liblerc4 libpango-1.0-0 176s libpangocairo-1.0-0 libpangoft2-1.0-0 libpaper-utils libpaper1 libpixman-1-0 176s libpng16-16t64 libpq5 libpsl5t64 libreadline8t64 libsharpyuv0 libsm6 176s libtcl8.6 libthai-data libthai0 libtiff6 libtirpc3t64 libtk8.6 libwebp7 176s libxcb-render0 libxcb-shm0 libxft2 libxrender1 libxss1 libxt6t64 r-base-core 176s r-cran-dbi r-cran-littler r-cran-rpostgresql unzip x11-common xdg-utils zip 176s The following packages will be upgraded: 176s curl 176s 1 upgraded, 54 newly installed, 5 to remove and 0 not upgraded. 176s Need to get 39.1 MB/39.1 MB of archives. 176s After this operation, 78.7 MB of additional disk space will be used. 176s Get:1 /tmp/autopkgtest.ODfDuX/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [716 B] 176s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpsl5t64 arm64 0.21.2-1.1 [57.4 kB] 176s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 curl arm64 8.5.0-2ubuntu7 [222 kB] 179s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libcurl4t64 arm64 8.5.0-2ubuntu7 [332 kB] 179s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpng16-16t64 arm64 1.6.43-3 [185 kB] 179s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libreadline8t64 arm64 8.2-3.1 [153 kB] 179s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libtirpc3t64 arm64 1.3.4+ds-1.1 [83.5 kB] 179s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 fonts-dejavu-mono all 2.37-8 [502 kB] 179s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 fonts-dejavu-core all 2.37-8 [835 kB] 179s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 fontconfig-config arm64 2.15.0-1ubuntu1 [37.0 kB] 179s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 libfontconfig1 arm64 2.15.0-1ubuntu1 [142 kB] 179s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 fontconfig arm64 2.15.0-1ubuntu1 [190 kB] 179s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 libblas3 arm64 3.12.0-3 [143 kB] 179s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 libpixman-1-0 arm64 0.42.2-1 [193 kB] 179s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 libxcb-render0 arm64 1.15-1 [16.1 kB] 179s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 libxcb-shm0 arm64 1.15-1 [5780 B] 179s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libxrender1 arm64 1:0.9.10-1.1 [19.1 kB] 179s Get:18 http://ftpmaster.internal/ubuntu noble/main arm64 libcairo2 arm64 1.18.0-1 [550 kB] 179s Get:19 http://ftpmaster.internal/ubuntu noble/main arm64 libdatrie1 arm64 0.2.13-3 [21.7 kB] 179s Get:20 http://ftpmaster.internal/ubuntu noble/main arm64 libdeflate0 arm64 1.19-1 [43.4 kB] 179s Get:21 http://ftpmaster.internal/ubuntu noble/main arm64 libgfortran5 arm64 14-20240303-1ubuntu1 [444 kB] 179s Get:22 http://ftpmaster.internal/ubuntu noble/main arm64 libgomp1 arm64 14-20240303-1ubuntu1 [144 kB] 179s Get:23 http://ftpmaster.internal/ubuntu noble/main arm64 libgraphite2-3 arm64 1.3.14-2 [81.5 kB] 179s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 libharfbuzz0b arm64 8.3.0-2 [463 kB] 179s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 x11-common all 1:7.7+23ubuntu2 [23.4 kB] 179s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 libice6 arm64 2:1.0.10-1build2 [41.7 kB] 179s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-turbo8 arm64 2.1.5-2ubuntu1 [160 kB] 179s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg8 arm64 8c-2ubuntu11 [2148 B] 179s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 liblapack3 arm64 3.12.0-3 [2241 kB] 179s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 liblerc4 arm64 4.0.0+ds-4ubuntu1 [153 kB] 179s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 libthai-data all 0.1.29-2 [158 kB] 179s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 libthai0 arm64 0.1.29-2 [18.1 kB] 179s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 libpango-1.0-0 arm64 1.51.0+ds-4 [226 kB] 179s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 libpangoft2-1.0-0 arm64 1.51.0+ds-4 [41.2 kB] 179s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 libpangocairo-1.0-0 arm64 1.51.0+ds-4 [27.6 kB] 179s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 libpaper1 arm64 1.1.29 [13.1 kB] 179s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 libpaper-utils arm64 1.1.29 [8480 B] 179s Get:38 http://ftpmaster.internal/ubuntu noble/main arm64 libpq5 arm64 16.2-1 [136 kB] 179s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 libsharpyuv0 arm64 1.3.2-0.4 [14.4 kB] 179s Get:40 http://ftpmaster.internal/ubuntu noble/main arm64 libsm6 arm64 2:1.2.3-1build2 [16.1 kB] 179s Get:41 http://ftpmaster.internal/ubuntu noble/main arm64 libtcl8.6 arm64 8.6.13+dfsg-2 [980 kB] 179s Get:42 http://ftpmaster.internal/ubuntu noble/main arm64 libjbig0 arm64 2.1-6.1ubuntu1 [28.9 kB] 179s Get:43 http://ftpmaster.internal/ubuntu noble/main arm64 libwebp7 arm64 1.3.2-0.4 [191 kB] 179s Get:44 http://ftpmaster.internal/ubuntu noble/main arm64 libtiff6 arm64 4.5.1+git230720-3ubuntu1 [226 kB] 179s Get:45 http://ftpmaster.internal/ubuntu noble/main arm64 libxft2 arm64 2.3.6-1 [43.3 kB] 179s Get:46 http://ftpmaster.internal/ubuntu noble/main arm64 libxss1 arm64 1:1.2.3-1build2 [8252 B] 179s Get:47 http://ftpmaster.internal/ubuntu noble/main arm64 libtk8.6 arm64 8.6.13-2 [760 kB] 179s Get:48 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libxt6t64 arm64 1:1.2.1-1.2 [168 kB] 179s Get:49 http://ftpmaster.internal/ubuntu noble/main arm64 zip arm64 3.0-13 [172 kB] 179s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 unzip arm64 6.0-28ubuntu3 [171 kB] 179s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 xdg-utils all 1.1.3-4.1ubuntu3 [62.0 kB] 179s Get:52 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 r-base-core arm64 4.3.3-2build1 [26.8 MB] 179s Get:53 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-dbi all 1.2.2-1 [823 kB] 179s Get:54 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-littler arm64 0.3.19-1 [93.4 kB] 179s Get:55 http://ftpmaster.internal/ubuntu noble/universe arm64 r-cran-rpostgresql arm64 0.7-6+dfsg-1 [374 kB] 179s Preconfiguring packages ... 179s Fetched 39.1 MB in 2s (21.3 MB/s) 179s dpkg: libpsl5:arm64: dependency problems, but removing anyway as you requested: 179s wget depends on libpsl5 (>= 0.16.0). 179s libcurl4:arm64 depends on libpsl5 (>= 0.16.0). 179s libcurl3-gnutls:arm64 depends on libpsl5 (>= 0.16.0). 179s 179s (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 ... 74774 files and directories currently installed.) 179s Removing libpsl5:arm64 (0.21.2-1build1) ... 179s Selecting previously unselected package libpsl5t64:arm64. 179s (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 ... 74769 files and directories currently installed.) 179s Preparing to unpack .../libpsl5t64_0.21.2-1.1_arm64.deb ... 179s Unpacking libpsl5t64:arm64 (0.21.2-1.1) ... 179s Preparing to unpack .../curl_8.5.0-2ubuntu7_arm64.deb ... 179s Unpacking curl (8.5.0-2ubuntu7) over (8.5.0-2ubuntu2) ... 179s (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 ... 74775 files and directories currently installed.) 179s Removing libcurl4:arm64 (8.5.0-2ubuntu2) ... 179s Selecting previously unselected package libcurl4t64:arm64. 179s (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 ... 74770 files and directories currently installed.) 179s Preparing to unpack .../libcurl4t64_8.5.0-2ubuntu7_arm64.deb ... 179s Unpacking libcurl4t64:arm64 (8.5.0-2ubuntu7) ... 179s dpkg: libpng16-16:arm64: dependency problems, but removing anyway as you requested: 179s libplymouth5:arm64 depends on libpng16-16 (>= 1.6.2). 179s libfreetype6:arm64 depends on libpng16-16 (>= 1.6.2-1). 179s 179s (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 ... 74776 files and directories currently installed.) 179s Removing libpng16-16:arm64 (1.6.43-1) ... 179s Selecting previously unselected package libpng16-16t64:arm64. 179s (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 ... 74766 files and directories currently installed.) 179s Preparing to unpack .../libpng16-16t64_1.6.43-3_arm64.deb ... 179s Unpacking libpng16-16t64:arm64 (1.6.43-3) ... 179s dpkg: libreadline8:arm64: dependency problems, but removing anyway as you requested: 179s parted depends on libreadline8 (>= 6.0). 179s libpython3.12-stdlib:arm64 depends on libreadline8 (>= 7.0~beta). 179s gpgsm depends on libreadline8 (>= 6.0). 179s gpgconf depends on libreadline8 (>= 6.0). 179s gpg depends on libreadline8 (>= 6.0). 179s gawk depends on libreadline8 (>= 6.0). 179s fdisk depends on libreadline8 (>= 6.0). 179s 179s (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 ... 74777 files and directories currently installed.) 179s Removing libreadline8:arm64 (8.2-3) ... 179s Selecting previously unselected package libreadline8t64:arm64. 179s (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 ... 74765 files and directories currently installed.) 179s Preparing to unpack .../libreadline8t64_8.2-3.1_arm64.deb ... 179s Adding 'diversion of /lib/aarch64-linux-gnu/libhistory.so.8 to /lib/aarch64-linux-gnu/libhistory.so.8.usr-is-merged by libreadline8t64' 179s 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' 179s Adding 'diversion of /lib/aarch64-linux-gnu/libreadline.so.8 to /lib/aarch64-linux-gnu/libreadline.so.8.usr-is-merged by libreadline8t64' 179s 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' 179s Unpacking libreadline8t64:arm64 (8.2-3.1) ... 180s dpkg: libtirpc3:arm64: dependency problems, but removing anyway as you requested: 180s lsof depends on libtirpc3 (>= 1.0.2). 180s libpython3.12-stdlib:arm64 depends on libtirpc3 (>= 1.0.2). 180s libnss-nisplus:arm64 depends on libtirpc3 (>= 1.0.2). 180s libnsl2:arm64 depends on libtirpc3 (>= 1.0.2). 180s iproute2 depends on libtirpc3 (>= 1.0.2). 180s 180s (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 ... 74785 files and directories currently installed.) 180s Removing libtirpc3:arm64 (1.3.4+ds-1build1) ... 180s Selecting previously unselected package libtirpc3t64:arm64. 180s (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 ... 74779 files and directories currently installed.) 180s Preparing to unpack .../00-libtirpc3t64_1.3.4+ds-1.1_arm64.deb ... 180s Adding 'diversion of /lib/aarch64-linux-gnu/libtirpc.so.3 to /lib/aarch64-linux-gnu/libtirpc.so.3.usr-is-merged by libtirpc3t64' 180s Adding 'diversion of /lib/aarch64-linux-gnu/libtirpc.so.3.0.0 to /lib/aarch64-linux-gnu/libtirpc.so.3.0.0.usr-is-merged by libtirpc3t64' 180s Unpacking libtirpc3t64:arm64 (1.3.4+ds-1.1) ... 180s Selecting previously unselected package fonts-dejavu-mono. 180s Preparing to unpack .../01-fonts-dejavu-mono_2.37-8_all.deb ... 180s Unpacking fonts-dejavu-mono (2.37-8) ... 180s Selecting previously unselected package fonts-dejavu-core. 180s Preparing to unpack .../02-fonts-dejavu-core_2.37-8_all.deb ... 180s Unpacking fonts-dejavu-core (2.37-8) ... 180s Selecting previously unselected package fontconfig-config. 180s Preparing to unpack .../03-fontconfig-config_2.15.0-1ubuntu1_arm64.deb ... 180s Unpacking fontconfig-config (2.15.0-1ubuntu1) ... 180s Selecting previously unselected package libfontconfig1:arm64. 180s Preparing to unpack .../04-libfontconfig1_2.15.0-1ubuntu1_arm64.deb ... 180s Unpacking libfontconfig1:arm64 (2.15.0-1ubuntu1) ... 180s Selecting previously unselected package fontconfig. 180s Preparing to unpack .../05-fontconfig_2.15.0-1ubuntu1_arm64.deb ... 180s Unpacking fontconfig (2.15.0-1ubuntu1) ... 180s Selecting previously unselected package libblas3:arm64. 180s Preparing to unpack .../06-libblas3_3.12.0-3_arm64.deb ... 180s Unpacking libblas3:arm64 (3.12.0-3) ... 180s Selecting previously unselected package libpixman-1-0:arm64. 180s Preparing to unpack .../07-libpixman-1-0_0.42.2-1_arm64.deb ... 180s Unpacking libpixman-1-0:arm64 (0.42.2-1) ... 180s Selecting previously unselected package libxcb-render0:arm64. 180s Preparing to unpack .../08-libxcb-render0_1.15-1_arm64.deb ... 180s Unpacking libxcb-render0:arm64 (1.15-1) ... 180s Selecting previously unselected package libxcb-shm0:arm64. 180s Preparing to unpack .../09-libxcb-shm0_1.15-1_arm64.deb ... 180s Unpacking libxcb-shm0:arm64 (1.15-1) ... 181s Selecting previously unselected package libxrender1:arm64. 181s Preparing to unpack .../10-libxrender1_1%3a0.9.10-1.1_arm64.deb ... 181s Unpacking libxrender1:arm64 (1:0.9.10-1.1) ... 181s Selecting previously unselected package libcairo2:arm64. 181s Preparing to unpack .../11-libcairo2_1.18.0-1_arm64.deb ... 181s Unpacking libcairo2:arm64 (1.18.0-1) ... 181s Selecting previously unselected package libdatrie1:arm64. 181s Preparing to unpack .../12-libdatrie1_0.2.13-3_arm64.deb ... 181s Unpacking libdatrie1:arm64 (0.2.13-3) ... 181s Selecting previously unselected package libdeflate0:arm64. 181s Preparing to unpack .../13-libdeflate0_1.19-1_arm64.deb ... 181s Unpacking libdeflate0:arm64 (1.19-1) ... 181s Selecting previously unselected package libgfortran5:arm64. 181s Preparing to unpack .../14-libgfortran5_14-20240303-1ubuntu1_arm64.deb ... 181s Unpacking libgfortran5:arm64 (14-20240303-1ubuntu1) ... 181s Selecting previously unselected package libgomp1:arm64. 181s Preparing to unpack .../15-libgomp1_14-20240303-1ubuntu1_arm64.deb ... 181s Unpacking libgomp1:arm64 (14-20240303-1ubuntu1) ... 181s Selecting previously unselected package libgraphite2-3:arm64. 181s Preparing to unpack .../16-libgraphite2-3_1.3.14-2_arm64.deb ... 181s Unpacking libgraphite2-3:arm64 (1.3.14-2) ... 181s Selecting previously unselected package libharfbuzz0b:arm64. 181s Preparing to unpack .../17-libharfbuzz0b_8.3.0-2_arm64.deb ... 181s Unpacking libharfbuzz0b:arm64 (8.3.0-2) ... 181s Selecting previously unselected package x11-common. 181s Preparing to unpack .../18-x11-common_1%3a7.7+23ubuntu2_all.deb ... 181s Unpacking x11-common (1:7.7+23ubuntu2) ... 181s Selecting previously unselected package libice6:arm64. 181s Preparing to unpack .../19-libice6_2%3a1.0.10-1build2_arm64.deb ... 181s Unpacking libice6:arm64 (2:1.0.10-1build2) ... 181s Selecting previously unselected package libjpeg-turbo8:arm64. 181s Preparing to unpack .../20-libjpeg-turbo8_2.1.5-2ubuntu1_arm64.deb ... 181s Unpacking libjpeg-turbo8:arm64 (2.1.5-2ubuntu1) ... 181s Selecting previously unselected package libjpeg8:arm64. 181s Preparing to unpack .../21-libjpeg8_8c-2ubuntu11_arm64.deb ... 181s Unpacking libjpeg8:arm64 (8c-2ubuntu11) ... 181s Selecting previously unselected package liblapack3:arm64. 181s Preparing to unpack .../22-liblapack3_3.12.0-3_arm64.deb ... 181s Unpacking liblapack3:arm64 (3.12.0-3) ... 181s Selecting previously unselected package liblerc4:arm64. 181s Preparing to unpack .../23-liblerc4_4.0.0+ds-4ubuntu1_arm64.deb ... 181s Unpacking liblerc4:arm64 (4.0.0+ds-4ubuntu1) ... 181s Selecting previously unselected package libthai-data. 181s Preparing to unpack .../24-libthai-data_0.1.29-2_all.deb ... 181s Unpacking libthai-data (0.1.29-2) ... 181s Selecting previously unselected package libthai0:arm64. 181s Preparing to unpack .../25-libthai0_0.1.29-2_arm64.deb ... 181s Unpacking libthai0:arm64 (0.1.29-2) ... 181s Selecting previously unselected package libpango-1.0-0:arm64. 181s Preparing to unpack .../26-libpango-1.0-0_1.51.0+ds-4_arm64.deb ... 181s Unpacking libpango-1.0-0:arm64 (1.51.0+ds-4) ... 181s Selecting previously unselected package libpangoft2-1.0-0:arm64. 181s Preparing to unpack .../27-libpangoft2-1.0-0_1.51.0+ds-4_arm64.deb ... 181s Unpacking libpangoft2-1.0-0:arm64 (1.51.0+ds-4) ... 181s Selecting previously unselected package libpangocairo-1.0-0:arm64. 181s Preparing to unpack .../28-libpangocairo-1.0-0_1.51.0+ds-4_arm64.deb ... 181s Unpacking libpangocairo-1.0-0:arm64 (1.51.0+ds-4) ... 181s Selecting previously unselected package libpaper1:arm64. 181s Preparing to unpack .../29-libpaper1_1.1.29_arm64.deb ... 181s Unpacking libpaper1:arm64 (1.1.29) ... 181s Selecting previously unselected package libpaper-utils. 181s Preparing to unpack .../30-libpaper-utils_1.1.29_arm64.deb ... 181s Unpacking libpaper-utils (1.1.29) ... 181s Selecting previously unselected package libpq5:arm64. 181s Preparing to unpack .../31-libpq5_16.2-1_arm64.deb ... 181s Unpacking libpq5:arm64 (16.2-1) ... 182s Selecting previously unselected package libsharpyuv0:arm64. 182s Preparing to unpack .../32-libsharpyuv0_1.3.2-0.4_arm64.deb ... 182s Unpacking libsharpyuv0:arm64 (1.3.2-0.4) ... 182s Selecting previously unselected package libsm6:arm64. 182s Preparing to unpack .../33-libsm6_2%3a1.2.3-1build2_arm64.deb ... 182s Unpacking libsm6:arm64 (2:1.2.3-1build2) ... 182s Selecting previously unselected package libtcl8.6:arm64. 182s Preparing to unpack .../34-libtcl8.6_8.6.13+dfsg-2_arm64.deb ... 182s Unpacking libtcl8.6:arm64 (8.6.13+dfsg-2) ... 182s Selecting previously unselected package libjbig0:arm64. 182s Preparing to unpack .../35-libjbig0_2.1-6.1ubuntu1_arm64.deb ... 182s Unpacking libjbig0:arm64 (2.1-6.1ubuntu1) ... 182s Selecting previously unselected package libwebp7:arm64. 182s Preparing to unpack .../36-libwebp7_1.3.2-0.4_arm64.deb ... 182s Unpacking libwebp7:arm64 (1.3.2-0.4) ... 182s Selecting previously unselected package libtiff6:arm64. 182s Preparing to unpack .../37-libtiff6_4.5.1+git230720-3ubuntu1_arm64.deb ... 182s Unpacking libtiff6:arm64 (4.5.1+git230720-3ubuntu1) ... 182s Selecting previously unselected package libxft2:arm64. 182s Preparing to unpack .../38-libxft2_2.3.6-1_arm64.deb ... 182s Unpacking libxft2:arm64 (2.3.6-1) ... 182s Selecting previously unselected package libxss1:arm64. 182s Preparing to unpack .../39-libxss1_1%3a1.2.3-1build2_arm64.deb ... 182s Unpacking libxss1:arm64 (1:1.2.3-1build2) ... 182s Selecting previously unselected package libtk8.6:arm64. 182s Preparing to unpack .../40-libtk8.6_8.6.13-2_arm64.deb ... 182s Unpacking libtk8.6:arm64 (8.6.13-2) ... 182s Selecting previously unselected package libxt6t64:arm64. 182s Preparing to unpack .../41-libxt6t64_1%3a1.2.1-1.2_arm64.deb ... 182s Unpacking libxt6t64:arm64 (1:1.2.1-1.2) ... 182s Selecting previously unselected package zip. 182s Preparing to unpack .../42-zip_3.0-13_arm64.deb ... 182s Unpacking zip (3.0-13) ... 182s Selecting previously unselected package unzip. 182s Preparing to unpack .../43-unzip_6.0-28ubuntu3_arm64.deb ... 182s Unpacking unzip (6.0-28ubuntu3) ... 182s Selecting previously unselected package xdg-utils. 182s Preparing to unpack .../44-xdg-utils_1.1.3-4.1ubuntu3_all.deb ... 182s Unpacking xdg-utils (1.1.3-4.1ubuntu3) ... 182s Selecting previously unselected package r-base-core. 182s Preparing to unpack .../45-r-base-core_4.3.3-2build1_arm64.deb ... 182s Unpacking r-base-core (4.3.3-2build1) ... 182s Selecting previously unselected package r-cran-dbi. 182s Preparing to unpack .../46-r-cran-dbi_1.2.2-1_all.deb ... 182s Unpacking r-cran-dbi (1.2.2-1) ... 182s Selecting previously unselected package r-cran-littler. 182s Preparing to unpack .../47-r-cran-littler_0.3.19-1_arm64.deb ... 182s Unpacking r-cran-littler (0.3.19-1) ... 182s Selecting previously unselected package r-cran-rpostgresql. 182s Preparing to unpack .../48-r-cran-rpostgresql_0.7-6+dfsg-1_arm64.deb ... 182s Unpacking r-cran-rpostgresql (0.7-6+dfsg-1) ... 182s Selecting previously unselected package autopkgtest-satdep. 182s Preparing to unpack .../49-1-autopkgtest-satdep.deb ... 182s Unpacking autopkgtest-satdep (0) ... 182s Setting up libgraphite2-3:arm64 (1.3.14-2) ... 182s Setting up libpixman-1-0:arm64 (0.42.2-1) ... 182s Setting up libsharpyuv0:arm64 (1.3.2-0.4) ... 182s Setting up libpaper1:arm64 (1.1.29) ... 183s 183s Creating config file /etc/papersize with new version 183s Setting up liblerc4:arm64 (4.0.0+ds-4ubuntu1) ... 183s Setting up libxrender1:arm64 (1:0.9.10-1.1) ... 183s Setting up libdatrie1:arm64 (0.2.13-3) ... 183s Setting up libtirpc3t64:arm64 (1.3.4+ds-1.1) ... 183s Setting up libxcb-render0:arm64 (1.15-1) ... 183s Setting up unzip (6.0-28ubuntu3) ... 183s Setting up x11-common (1:7.7+23ubuntu2) ... 183s Setting up libpsl5t64:arm64 (0.21.2-1.1) ... 183s Setting up libpq5:arm64 (16.2-1) ... 183s Setting up libdeflate0:arm64 (1.19-1) ... 183s Setting up libxcb-shm0:arm64 (1.15-1) ... 183s Setting up libpaper-utils (1.1.29) ... 183s Setting up libgomp1:arm64 (14-20240303-1ubuntu1) ... 183s Setting up libjbig0:arm64 (2.1-6.1ubuntu1) ... 183s Setting up zip (3.0-13) ... 183s Setting up libblas3:arm64 (3.12.0-3) ... 183s 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 183s Setting up fonts-dejavu-mono (2.37-8) ... 183s Setting up libpng16-16t64:arm64 (1.6.43-3) ... 183s Setting up libtcl8.6:arm64 (8.6.13+dfsg-2) ... 183s Setting up fonts-dejavu-core (2.37-8) ... 183s Setting up libjpeg-turbo8:arm64 (2.1.5-2ubuntu1) ... 183s Setting up libgfortran5:arm64 (14-20240303-1ubuntu1) ... 183s Setting up libwebp7:arm64 (1.3.2-0.4) ... 183s Setting up libreadline8t64:arm64 (8.2-3.1) ... 183s Setting up libharfbuzz0b:arm64 (8.3.0-2) ... 183s Setting up libthai-data (0.1.29-2) ... 183s Setting up libxss1:arm64 (1:1.2.3-1build2) ... 183s Setting up xdg-utils (1.1.3-4.1ubuntu3) ... 183s update-alternatives: using /usr/bin/xdg-open to provide /usr/bin/open (open) in auto mode 183s Setting up libjpeg8:arm64 (8c-2ubuntu11) ... 183s Setting up libice6:arm64 (2:1.0.10-1build2) ... 183s Setting up liblapack3:arm64 (3.12.0-3) ... 183s 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 183s Setting up libcurl4t64:arm64 (8.5.0-2ubuntu7) ... 183s Setting up fontconfig-config (2.15.0-1ubuntu1) ... 184s Setting up libthai0:arm64 (0.1.29-2) ... 184s Setting up libtiff6:arm64 (4.5.1+git230720-3ubuntu1) ... 184s Setting up curl (8.5.0-2ubuntu7) ... 184s Setting up libfontconfig1:arm64 (2.15.0-1ubuntu1) ... 184s Setting up libsm6:arm64 (2:1.2.3-1build2) ... 184s Setting up fontconfig (2.15.0-1ubuntu1) ... 186s Regenerating fonts cache... done. 186s Setting up libxft2:arm64 (2.3.6-1) ... 186s Setting up libtk8.6:arm64 (8.6.13-2) ... 186s Setting up libpango-1.0-0:arm64 (1.51.0+ds-4) ... 186s Setting up libcairo2:arm64 (1.18.0-1) ... 186s Setting up libxt6t64:arm64 (1:1.2.1-1.2) ... 186s Setting up libpangoft2-1.0-0:arm64 (1.51.0+ds-4) ... 186s Setting up libpangocairo-1.0-0:arm64 (1.51.0+ds-4) ... 186s Setting up r-base-core (4.3.3-2build1) ... 186s 186s Creating config file /etc/R/Renviron with new version 186s Setting up r-cran-littler (0.3.19-1) ... 186s Setting up r-cran-dbi (1.2.2-1) ... 186s Setting up r-cran-rpostgresql (0.7-6+dfsg-1) ... 186s Setting up autopkgtest-satdep (0) ... 186s Processing triggers for man-db (2.12.0-3) ... 187s Processing triggers for install-info (7.1-3) ... 187s Processing triggers for libc-bin (2.39-0ubuntu2) ... 191s (Reading database ... 77053 files and directories currently installed.) 191s Removing autopkgtest-satdep (0) ... 191s autopkgtest [20:01:25]: test run-unit-test: [----------------------- 192s BEGIN TEST connectWithNull.R 192s 192s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 192s Copyright (C) 2024 The R Foundation for Statistical Computing 192s Platform: aarch64-unknown-linux-gnu (64-bit) 192s 192s R is free software and comes with ABSOLUTELY NO WARRANTY. 192s You are welcome to redistribute it under certain conditions. 192s Type 'license()' or 'licence()' for distribution details. 192s 192s R is a collaborative project with many contributors. 192s Type 'contributors()' for more information and 192s 'citation()' on how to cite R or R packages in publications. 192s 192s Type 'demo()' for some demos, 'help()' for on-line help, or 192s 'help.start()' for an HTML browser interface to help. 192s Type 'q()' to quit R. 192s 192s > 192s > ## connectWithNull test 192s > ## 192s > ## test for the 'Issue 2' on the Google Code issue log 192s > ## reported in April 2009, still open ? 192s > ## 192s > ## Assumes that 192s > ## a) PostgreSQL is running, and 192s > ## b) the current user can connect 192s > ## both of which are not viable for release but suitable while we test 192s > ## 192s > ## Dirk Eddelbuettel, 03 Oct 2009 192s > 192s > ## only run this if this env.var is set correctly 192s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 192s + 192s + ## try to load our module and abort if this fails 192s + stopifnot(require(RPostgreSQL)) 192s + stopifnot(require(datasets)) 192s + 192s + ## load the PostgresSQL driver 192s + drv <- dbDriver("PostgreSQL") 192s + 192s + ## connect to the default db -- replacing any of these with NULL will lead to 192s + ## a stop() call and a return to the R prompt rather than a segfault 192s + con <- dbConnect(drv, 192s + user=Sys.getenv("POSTGRES_USER"), 192s + password=Sys.getenv("POSTGRES_PASSWD"), 192s + host=Sys.getenv("POSTGRES_HOST"), 192s + dbname=Sys.getenv("POSTGRES_DATABASE"), 192s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 192s + 192s + ## do we get here? 192s + print(con) 192s + 192s + ## and disconnect 192s + dbDisconnect(con) 192s + } 192s > 192s BEGIN TEST createTableMixedCaseTest.R 192s 192s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 192s Copyright (C) 2024 The R Foundation for Statistical Computing 192s Platform: aarch64-unknown-linux-gnu (64-bit) 192s 192s R is free software and comes with ABSOLUTELY NO WARRANTY. 192s You are welcome to redistribute it under certain conditions. 192s Type 'license()' or 'licence()' for distribution details. 192s 192s R is a collaborative project with many contributors. 192s Type 'contributors()' for more information and 192s 'citation()' on how to cite R or R packages in publications. 192s 192s Type 'demo()' for some demos, 'help()' for on-line help, or 192s 'help.start()' for an HTML browser interface to help. 192s Type 'q()' to quit R. 192s 192s > 192s > ## createTableMixedCaseTest test 192s > ## 192s > ## 192s > ## Assumes that 192s > ## a) PostgreSQL is running, and 192s > ## b) the current user can connect 192s > ## both of which are not viable for release but suitable while we test 192s > ## 192s > ## Neil Tiffin, 30 Oct 2009 192s > 192s > ## only run this if this env.var is set correctly 192s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 192s + 192s + ## try to load our module and abort if this fails 192s + stopifnot(require(RPostgreSQL)) 192s + 192s + ## load the PostgresSQL driver 192s + drv <- dbDriver("PostgreSQL") 192s + 192s + ## connect to the default db 192s + con <- dbConnect(drv, 192s + user=Sys.getenv("POSTGRES_USER"), 192s + password=Sys.getenv("POSTGRES_PASSWD"), 192s + host=Sys.getenv("POSTGRES_HOST"), 192s + dbname=Sys.getenv("POSTGRES_DATABASE"), 192s + port=Sys.getenv("POSTGRES_PORT")) 192s + 192s + 192s + 192s + res <- dbGetQuery(con, "create table Foo1 (f1 int)") 192s + res <- dbGetQuery(con, "create table \"Foo2\" (f1 int)") 192s + 192s + cat("Test should create foo1 and Foo2 tables\n") 192s + ## res <- dbGetQuery(con, "SELECT * FROM information_schema.tables WHERE table_schema = 'public'") 192s + ## print res 192s + 192s + if (dbExistsTable(con, "Foo1")) { 192s + cat("FAIL - Foo1 Table exists.\n") 192s + } 192s + else { 192s + cat("Pass - Foo1 Table does not exist.\n") 192s + } 192s + 192s + if (dbExistsTable(con, "foo1")) { 192s + cat("Pass - foo1 Table exists.\n") 192s + } 192s + else { 192s + cat("FAIL - foo1 Table does not exist.\n") 192s + } 192s + 192s + if (dbExistsTable(con, "Foo2")) { 192s + cat("Pass - Foo2 Table exists.\n") 192s + } 192s + else { 192s + cat("FAIL - Foo2 Table does not exist.\n") 192s + } 192s + 192s + if (dbExistsTable(con, "foo2")) { 192s + cat("FAIL - foo2 Table exists.\n") 192s + } 192s + else { 192s + cat("Pass - foo2 Table does not exist.\n") 192s + } 192s + 192s + if (dbExistsTable(con, "\"Foo2\"")) { 192s + cat("FAIL - \"Foo2\" Table exists.\n") 192s + } 192s + else { 192s + cat("Pass - \"Foo2\" Table does not exist.\n") 192s + } 192s + 192s + if (dbExistsTable(con, "\"foo2\"")) { 192s + cat("FAIL - \"foo2\" Table exists.\n") 192s + } 192s + else { 192s + cat("Pass - \"foo2\" Table does not exist.\n") 192s + } 192s + 192s + res <- dbGetQuery(con, "drop table Foo1") 192s + res <- dbGetQuery(con, "drop table \"Foo2\"") 192s + ## and disconnect 192s + dbDisconnect(con) 192s + } 192s > 192s BEGIN TEST dataTypeTests.R 192s 192s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 192s Copyright (C) 2024 The R Foundation for Statistical Computing 192s Platform: aarch64-unknown-linux-gnu (64-bit) 192s 192s R is free software and comes with ABSOLUTELY NO WARRANTY. 192s You are welcome to redistribute it under certain conditions. 192s Type 'license()' or 'licence()' for distribution details. 192s 192s R is a collaborative project with many contributors. 192s Type 'contributors()' for more information and 192s 'citation()' on how to cite R or R packages in publications. 192s 192s Type 'demo()' for some demos, 'help()' for on-line help, or 192s 'help.start()' for an HTML browser interface to help. 192s Type 'q()' to quit R. 192s 192s > ## Test of data types, based on earlier version in inst/devTests 192s > ## 192s > ## Dirk Eddelbuettel, 21 Oct 2008 192s > 192s > if ((Sys.getenv("POSTGRES_USER") != "") & 192s + (Sys.getenv("POSTGRES_HOST") != "") & 192s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 192s + 192s + ## try to load our module and abort if this fails 192s + stopifnot(require(RPostgreSQL)) 192s + 192s + ## load the PostgresSQL driver 192s + drv <- dbDriver("PostgreSQL") 192s + ## can't print result as it contains process id which changes print(summary(drv)) 192s + 192s + ## connect to the default db 192s + con <- dbConnect(drv, 192s + user=Sys.getenv("POSTGRES_USER"), 192s + password=Sys.getenv("POSTGRES_PASSWD"), 192s + host=Sys.getenv("POSTGRES_HOST"), 192s + dbname=Sys.getenv("POSTGRES_DATABASE"), 192s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 192s + 192s + if (dbExistsTable(con, "tempostgrestable")) 192s + dbRemoveTable(con, "tempostgrestable") 192s + 192s + ## Test the numeric mapping 192s + dbGetQuery(con, "create table tempostgrestable (intcolumn integer, floatcolumn float);") 192s + 192s + i <- as.integer(10) 192s + j <- as.numeric(56.6) 192s + 192s + sql <- paste("insert into tempostgrestable ", 192s + "values (",i, "," ,j ,") ", sep="") 192s + res <- dbGetQuery(con, sql) 192s + 192s + 192s + dat <- dbReadTable(con, "tempostgrestable") 192s + dbRemoveTable(con, "tempostgrestable") 192s + cat("Read Numeric values\n") 192s + 192s + ## now test the types of the colums we got 192s + stopifnot( class(dat[,1]) == "integer" ) 192s + stopifnot( class(dat[,2]) == "numeric" ) 192s + cat("GOOD -- all numeric types are as expected\n") 192s + 192s + ## and test the values 192s + stopifnot( identical( dat[1,1], i)) 192s + stopifnot( identical( dat[1,2], j)) 192s + cat("GOOD -- all numeric values are as expected\n") 192s + 192s + ## Test the logical mapping 192s + if (dbExistsTable(con, "testlogical")) 192s + dbRemoveTable(con, "testlogical") 192s + dbGetQuery(con,"create table testlogical (col1 boolean, col2 boolean)") 192s + 192s + i <- as.logical(TRUE) 192s + j <- as.logical(FALSE) 192s + 192s + sql <- paste("insert into testlogical ", 192s + "values (",i, "," ,j ,") ", sep="") 192s + res <- dbGetQuery(con, sql); 192s + 192s + dat <- dbReadTable(con, "testlogical") 192s + dbRemoveTable(con, "testlogical") 192s + cat("Read Logical values\n") 192s + 192s + ## now test the types of the colums we got 192s + stopifnot( class(dat[,1]) == "logical" ) 192s + stopifnot( class(dat[,2]) == "logical" ) 192s + cat("GOOD -- all logical types are as expected\n") 192s + 192s + ## and test the values 192s + stopifnot( identical( dat[1,1], i)) 192s + stopifnot( identical( dat[1,2], j)) 192s + cat("GOOD -- all logical values are as expected\n") 192s + 192s + ## Test the character mapping 192s + if (dbExistsTable(con, "testchar")) 192s + dbRemoveTable(con, "testchar") 192s + dbGetQuery(con,"create table testchar (code char(3),city varchar(20),country text);") 192s + 192s + i <- as.character("IN") 192s + j <- as.character("Hyderabad") 192s + k <- as.character("India") 192s + 192s + sql <- paste("insert into testchar ", 192s + "values ('",i,"' , '",j ,"' , '",k,"') ", sep="") 192s + res <- dbGetQuery(con, sql); 192s + 192s + dat <- dbReadTable(con, "testchar") 192s + cat("Read Character values\n") 192s + 192s + ## now test the types of the colums we got 192s + stopifnot( class(dat[,1]) == "character" ) 192s + stopifnot( class(dat[,2]) == "character" ) 192s + stopifnot( class(dat[,3]) == "character" ) 192s + cat("GOOD -- all character types are as expected\n") 192s + 192s + ## and test the values 192s + ##stopifnot( identical( dat[1,1], i)) 192s + stopifnot( identical( dat[1,2], j)) 192s + stopifnot( identical( dat[1,3], k)) 192s + cat("GOOD -- all character values are as expected\n") 192s + 192s + dbRemoveTable(con, "testchar") 192s + dbRemoveTable(con, "tempostgrestable") 192s + 192s + dbDisconnect(con) 192s + dbUnloadDriver(drv) 192s + 192s + cat("DONE\n") 192s + } 192s > 192s BEGIN TEST dateTZ.R 192s 192s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 192s Copyright (C) 2024 The R Foundation for Statistical Computing 192s Platform: aarch64-unknown-linux-gnu (64-bit) 192s 192s R is free software and comes with ABSOLUTELY NO WARRANTY. 192s You are welcome to redistribute it under certain conditions. 192s Type 'license()' or 'licence()' for distribution details. 192s 192s R is a collaborative project with many contributors. 192s Type 'contributors()' for more information and 192s 'citation()' on how to cite R or R packages in publications. 192s 192s Type 'demo()' for some demos, 'help()' for on-line help, or 192s 'help.start()' for an HTML browser interface to help. 192s Type 'q()' to quit R. 192s 192s > 192s > ## Test of date and datetime types, based on earlier version in inst/devTests 192s > ## 192s > ## Dirk Eddelbuettel, 21 Oct 2008 192s > 192s > dbTypeTests <- function(con, dateclass="timestamp without time zone", tz="UTC") { 192s + cat("\n\n**** Trying with ", dateclass, "\n") 192s + 192s + if (dbExistsTable(con, "tempostgrestable")) 192s + dbRemoveTable(con, "tempostgrestable") 192s + 192s + dbGetQuery(con, paste("create table tempostgrestable (tt ", dateclass, ", zz integer);", sep="")) 192s + insstring <- '2008-07-01 14:15:16.123+00' 192s + cat(paste('inserted string 1:', insstring)) 192s + cat("\n") 192s + dbGetQuery(con, paste("insert into tempostgrestable values('", insstring, "', 1);", sep="")) 192s + 192s + # now <- ISOdatetime(2000,1,2,3,4,5.678) 192s + insstring <- '2000-01-02 03:04:05.678+00' 192s + cat(paste('inserted string 2:', insstring)) 192s + cat("\n") 192s + dbGetQuery(con, paste("insert into tempostgrestable values('", insstring, "', 2);", sep="")) 192s + 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") 192s + print(tt) 192s + 192s + dbGetQuery(con, paste("SET TIMEZONE TO '", tz, "'", sep="")) 192s + 192s + data <- dbGetQuery(con, "select tt from tempostgrestable;") 192s + 192s + times <- data[,1] 192s + print(times) 192s + if(as.double(tt[1]) == as.double(times[1])){ 192s + cat('PASS\n') 192s + }else{ 192s + cat('FAIL\n') 192s + } 192s + if(as.double(tt[2]) == as.double(times[2])){ 192s + cat('PASS\n') 192s + }else{ 192s + cat('FAIL\n') 192s + } 192s + 192s + 192s + dbRemoveTable(con, "tempostgrestable") 192s + invisible(NULL) 192s + } 192s > 192s > ## only run this if this env.var is set correctly 192s > if ((Sys.getenv("POSTGRES_USER") != "") & 192s + (Sys.getenv("POSTGRES_HOST") != "") & 192s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 192s + 192s + ## try to load our module and abort if this fails 192s + stopifnot(require(RPostgreSQL)) 192s + 192s + ## Force a timezone to make the tests comparable at different locations 192s + Sys.setenv("TZ"="UTC") 192s + 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") 192s + print(tt) 192s + 192s + ## load the PostgresSQL driver 192s + drv <- dbDriver("PostgreSQL") 192s + ## can't print result as it contains process id which changes print(summary(drv)) 192s + 192s + ## connect to the default db 192s + con <- dbConnect(drv, 192s + user=Sys.getenv("POSTGRES_USER"), 192s + password=Sys.getenv("POSTGRES_PASSWD"), 192s + host=Sys.getenv("POSTGRES_HOST"), 192s + dbname=Sys.getenv("POSTGRES_DATABASE"), 192s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 192s + 192s + cat('testing UTC') 192s + dbTypeTests(con, "timestamp") 192s + dbTypeTests(con, "timestamp with time zone") 192s + cat('testing Asia/Tokyo') 192s + dbTypeTests(con, "timestamp", tz="Asia/Tokyo") 192s + dbTypeTests(con, "timestamp with time zone", tz="Asia/Tokyo") 192s + cat('testing Australlia/South') 192s + dbTypeTests(con, "timestamp", tz="Australia/South") 192s + dbTypeTests(con, "timestamp with time zone", tz="Australia/South") 192s + cat('testing America/New_York') 192s + dbTypeTests(con, "timestamp", tz="America/New_York") 192s + dbTypeTests(con, "timestamp with time zone", tz="America/New_York") 192s + 192s + dbDisconnect(con) 192s + } 192s > 192s > 192s BEGIN TEST datetimeTests.R 192s 192s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 192s Copyright (C) 2024 The R Foundation for Statistical Computing 192s Platform: aarch64-unknown-linux-gnu (64-bit) 192s 192s R is free software and comes with ABSOLUTELY NO WARRANTY. 192s You are welcome to redistribute it under certain conditions. 192s Type 'license()' or 'licence()' for distribution details. 192s 192s R is a collaborative project with many contributors. 192s Type 'contributors()' for more information and 192s 'citation()' on how to cite R or R packages in publications. 192s 192s Type 'demo()' for some demos, 'help()' for on-line help, or 192s 'help.start()' for an HTML browser interface to help. 192s Type 'q()' to quit R. 192s 193s > 193s > ## Test of date and datetime types, based on earlier version in inst/devTests 193s > ## 193s > ## Dirk Eddelbuettel, 21 Oct 2008 193s > 193s > dbTypeTests <- function(con, dateclass="timestamp without time zone") { 193s + cat("\n\n**** Trying with ", dateclass, "\n") 193s + 193s + if (dbExistsTable(con, "tempostgrestable")) 193s + dbRemoveTable(con, "tempostgrestable") 193s + 193s + dbGetQuery(con, paste("create table tempostgrestable (tt ", dateclass, ", zz integer);", sep="")) 193s + dbGetQuery(con, "insert into tempostgrestable values('2008-07-01 14:15:16.123', 1);") 193s + 193s + now <- ISOdatetime(2000,1,2,3,4,5.678) 193s + dbGetQuery(con, paste("insert into tempostgrestable values('", format(now), "', 2);", sep="")) 193s + 193s + res <- dbReadTable(con, "tempostgrestable") 193s + print(res) 193s + 193s + res <- dbSendQuery(con, "select tt from tempostgrestable;") 193s + data <- fetch(res, n=-1) 193s + print(dbColumnInfo(res)) 193s + 193s + times <- data[,1] 193s + print(times) 193s + print(class(times[1])) 193s + 193s + print(diff(times)) 193s + 193s + dbRemoveTable(con, "tempostgrestable") 193s + invisible(NULL) 193s + } 193s > 193s > ## only run this if this env.var is set correctly 193s > if ((Sys.getenv("POSTGRES_USER") != "") & 193s + (Sys.getenv("POSTGRES_HOST") != "") & 193s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + 193s + ## Force a timezone to make the tests comparable at different locations 193s + Sys.setenv("PGDATESTYLE"="German") 193s + Sys.setenv("TZ"="UTC") 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + ## can't print result as it contains process id which changes print(summary(drv)) 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + dbTypeTests(con, "timestamp") 193s + # dbTypeTests(con, "timestamp with time zone") 193s + # output differs depending on the compute environment 193s + dbTypeTests(con, "date") 193s + 193s + dbDisconnect(con) 193s + } 193s > 193s > 193s BEGIN TEST datetimestampwrite.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 193s > ## Test of data types, based on earlier version in inst/devTests 193s > ## 193s > ## Dirk Eddelbuettel, 21 Oct 2008 193s > 193s > if ((Sys.getenv("POSTGRES_USER") != "") & 193s + (Sys.getenv("POSTGRES_HOST") != "") & 193s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + ## can't print result as it contains process id which changes print(summary(drv)) 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + if (dbExistsTable(con, "tempostgrestable")) 193s + dbRemoveTable(con, "tempostgrestable") 193s + 193s + ## Test the numeric mapping 193s + dbGetQuery(con, "create table tempostgrestable (intcolumn date, floatcolumn timestamp with time zone);") 193s + 193s + sql <- paste("insert into tempostgrestable ", 193s + "values ('2011-03-07', '2011-03-07 16:30:39') ") 193s + res <- dbGetQuery(con, sql) 193s + 193s + dat <- dbReadTable(con, "tempostgrestable") 193s + dbRemoveTable(con, "tempostgrestable") 193s + cat("Read Date and TIMESTAMP values\n") 193s + 193s + ## now test the types of the colums we got 193s + if( class(dat[1,1]) == "Date" ){ 193s + cat("PASS -- Date type is as expected\n") 193s + }else{ 193s + cat("FAIL -- Date type is other than Date: ") 193s + cat(class(dat[1,1])) 193s + cat("\n") 193s + } 193s + if( class(dat[1,2])[1] == "POSIXct" ){ 193s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 193s + }else{ 193s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 193s + cat(class(dat[1,2])) 193s + cat("\n") 193s + } 193s + 193s + dbWriteTable(con, "tempostgrestable2", dat) 193s + dat2 <- dbReadTable(con, "tempostgrestable2") 193s + dbRemoveTable(con, "tempostgrestable2") 193s + cat("Check that read after write gets the same data types\n") 193s + 193s + ## now test the types of the colums we got 193s + if( class(dat2[1,1]) == "Date" ){ 193s + cat("PASS -- Date type is as expected\n") 193s + }else{ 193s + cat("FAIL -- Date type is other than Date: ") 193s + cat(class(dat2[1,1])) 193s + cat("\n") 193s + } 193s + if( class(dat2[1,2])[1] == "POSIXct" ){ 193s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 193s + }else{ 193s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 193s + cat(class(dat2[1,2])) 193s + cat("\n") 193s + } 193s + 193s + 193s + dbDisconnect(con) 193s + dbUnloadDriver(drv) 193s + 193s + cat("DONE\n") 193s + } 193s > 193s BEGIN TEST dbColumnInfo.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 193s > 193s > ## dbWriteTable test 193s > ## 193s > ## Assumes that 193s > ## a) PostgreSQL is running, and 193s > ## b) the current user can connect 193s > ## both of which are not viable for release but suitable while we test 193s > ## 193s > ## Dirk Eddelbuettel, 10 Sep 2009 193s > 193s > ## only run this if this env.var is set correctly 193s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + 193s + # create a table 193s + res <- dbGetQuery(con, "CREATE TABLE aa (pk integer, v1 float not null, v2 float)" ) 193s + 193s + ## run a simple query and show the query result 193s + res <- dbGetQuery(con, "INSERT INTO aa VALUES(3, 2, NULL)" ) 193s + res <- dbSendQuery(con, "select pk, v1, v2, v1+v2 from aa") 193s + cat("dbColumnInfo\n") 193s + print(dbColumnInfo(res)) 193s + print(dbColumnInfo(res)) 193s + cat("SELECT result\n") 193s + df <- fetch(res, n=-1) 193s + print(df) 193s + 193s + ## cleanup 193s + cat("Removing \"AA\"\n") 193s + dbRemoveTable(con, "aa") 193s + ## and disconnect 193s + dbDisconnect(con) 193s + } 193s > 193s BEGIN TEST dbExistsIssue.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 193s > 193s > ## dbExists test with schema name: reported as Issue 3 at 193s > ## http://code.google.com/p/rpostgresql/issues/detail?id=3 193s > ## and based on an earlier email by Prasenjit Kapat 193s > ## 193s > ## Assumes that 193s > ## a) PostgreSQL is running, and 193s > ## b) the current user can connect 193s > ## both of which are not viable for release but suitable while we test 193s > ## 193s > ## Dirk Eddelbuettel, 10 Sep 2009 193s > 193s > ## only run this if this env.var is set correctly 193s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + stopifnot(require(datasets)) 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + if (dbExistsTable(con, "rockdata")) { 193s + print("Removing rockdata\n") 193s + dbRemoveTable(con, "rockdata") 193s + } 193s + 193s + dbWriteTable(con, "rockdata", rock) 193s + 193s + ## run a simple dbExists 193s + cat("Does rockdata exist? ") 193s + print(res <- dbExistsTable(con, "rockdata")) 193s + 193s + ## this should return TRUE but did not -- does now after patch 193s + cat("Does public.rockdata exist? ") 193s + print(res <- dbExistsTable(con, "public.rockdata")) 193s + 193s + ## cleanup 193s + if (dbExistsTable(con, "rockdata")) { 193s + print("Removing rockdata\n") 193s + dbRemoveTable(con, "rockdata") 193s + } 193s + 193s + ## and disconnect 193s + dbDisconnect(con) 193s + } 193s > 193s BEGIN TEST dbExistsq.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 193s > 193s > ## dbExists test with schema name: reported as Issue 3 at 193s > ## http://code.google.com/p/rpostgresql/issues/detail?id=3 193s > ## and based on an earlier email by Prasenjit Kapat 193s > ## 193s > ## Assumes that 193s > ## a) PostgreSQL is running, and 193s > ## b) the current user can connect 193s > ## both of which are not viable for release but suitable while we test 193s > ## 193s > ## Dirk Eddelbuettel, 10 Sep 2009 193s > 193s > ## only run this if this env.var is set correctly 193s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + stopifnot(require(datasets)) 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + if (dbExistsTable(con, "rock'data")) { 193s + cat("Removing rock'data\n") 193s + dbRemoveTable(con, "rock'data") 193s + } 193s + 193s + cat("Write rock'data\n") 193s + dbWriteTable(con, "rock'data", rock) 193s + 193s + ## run a simple dbExists 193s + cat("Does rock'data exist? ") 193s + print(res <- dbExistsTable(con, "rock'data")) 193s + 193s + ## this should return TRUE but did not -- does now after patch 193s + cat("Does \"public.rock'data\" exist? ") 193s + print(res <- dbExistsTable(con, "public.rock'data")) 193s + 193s + ## cleanup 193s + if (dbExistsTable(con, "rock'data")) { 193s + cat("Removing rock'data\n") 193s + dbRemoveTable(con, "rock'data") 193s + } 193s + 193s + ## and disconnect 193s + dbDisconnect(con) 193s + } 193s > 193s BEGIN TEST dbExistsqc.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 193s > 193s > ## dbExistsq test with schema name: reported as Issue 28 at 193s > ## http://code.google.com/p/rpostgresql/issues/detail?id=28 193s > ## 193s > ## Assumes that 193s > ## a) PostgreSQL is running, and 193s > ## b) the current user can connect 193s > ## both of which are not viable for release but suitable while we test 193s > ## 193s > ## Dirk Eddelbuettel, 10 Sep 2009 193s > 193s > ## only run this if this env.var is set correctly 193s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 193s + 193s + ## try to load our module and abort if this fails 193s + stopifnot(require(RPostgreSQL)) 193s + stopifnot(require(datasets)) 193s + 193s + ## load the PostgresSQL driver 193s + drv <- dbDriver("PostgreSQL") 193s + 193s + ## connect to the default db 193s + con <- dbConnect(drv, 193s + user=Sys.getenv("POSTGRES_USER"), 193s + password=Sys.getenv("POSTGRES_PASSWD"), 193s + host=Sys.getenv("POSTGRES_HOST"), 193s + dbname=Sys.getenv("POSTGRES_DATABASE"), 193s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 193s + 193s + if (dbExistsTable(con, "rock.data")) { 193s + cat("Removing rock'data\n") 193s + dbRemoveTable(con, "rock.data") 193s + } 193s + 193s + 193s + dbWriteTable(con, "rock.data", rock) 193s + ## run a simple dbExists 193s + cat("Does rock.data exist? \n") 193s + res <- dbExistsTable(con, "rock.data") 193s + if(res){ 193s + cat("PASS: true\n") 193s + }else{ 193s + cat("FAIL: false\n") 193s + } 193s + 193s + ## 193s + cat("create schema testschema and change the search_path\n") 193s + 193s + dbGetQuery(con, 'CREATE SCHEMA testschema') 193s + dbGetQuery(con, 'SET search_path TO testschema') 193s + cat("Does rock.data exist? \n") 193s + res <- dbExistsTable(con, "rock.data") 193s + if(res){ 193s + cat("FAIL: true despite search_path change\n") 193s + }else{ 193s + cat("PASS: false as the search_path changed\n") 193s + } 193s + 193s + cat("Does testschema.\"rock.data\" exist? \n") 193s + res <- dbExistsTable(con, c('testschema', "rock.data")) 193s + if(res){ 193s + cat("FAIL: true despite testschema specified\n") 193s + }else{ 193s + cat("PASS: false as the testschema specified\n") 193s + } 193s + 193s + cat("Does public.\"rock.data\" exist? \n") 193s + res <- dbExistsTable(con, c('public', "rock.data")) 193s + if(res){ 193s + cat("PASS: true despite search_path change\n") 193s + }else{ 193s + cat("FAIL: false as the search_path changed\n") 193s + } 193s + 193s + 193s + cat("write in current schema\n") 193s + dbWriteTable(con, "rock.data", rock) 193s + cat("Does rock.data exist? \n") 193s + res <- dbExistsTable(con, "rock.data") 193s + if(res){ 193s + cat("PASS: true\n") 193s + }else{ 193s + cat("FAIL: false\n") 193s + } 193s + 193s + ## cleanup 193s + dbGetQuery(con, 'DROP TABLE "public"."rock.data"') 193s + dbGetQuery(con, 'DROP TABLE "testschema"."rock.data"') 193s + dbGetQuery(con, 'DROP schema "testschema"') 193s + 193s + ## and disconnect 193s + dbDisconnect(con) 193s + } 193s > 193s BEGIN TEST dbGetQueryParams.R 193s 193s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 193s Copyright (C) 2024 The R Foundation for Statistical Computing 193s Platform: aarch64-unknown-linux-gnu (64-bit) 193s 193s R is free software and comes with ABSOLUTELY NO WARRANTY. 193s You are welcome to redistribute it under certain conditions. 193s Type 'license()' or 'licence()' for distribution details. 193s 193s R is a collaborative project with many contributors. 193s Type 'contributors()' for more information and 193s 'citation()' on how to cite R or R packages in publications. 193s 193s Type 'demo()' for some demos, 'help()' for on-line help, or 193s 'help.start()' for an HTML browser interface to help. 193s Type 'q()' to quit R. 193s 194s > ## dbGetQuery test with optional parameters 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + stopifnot(require(datasets)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## connect to the default db 194s + con <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + dbWriteTable(con, "rockdata", rock) 194s + 194s + ## run a simple query and show the query result 194s + res <- dbGetQuery(con, "SELECT * FROM rockdata WHERE peri > $1 LIMIT 10", 4000) 194s + print(res) 194s + res <- dbGetQuery(con, "SELECT * FROM rockdata WHERE peri > $1 AND shape < $2 LIMIT $3", c(4000, 0.2, 10)) 194s + print(res) 194s + 194s + 194s + ## cleanup 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + ## and disconnect 194s + dbDisconnect(con) 194s + } 194s > 194s BEGIN TEST dbListFields.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 194s > ## dbListFields test 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > ## 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## connect to the default db 194s + con <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + # create a table 194s + res <- dbGetQuery(con, "CREATE SCHEMA testschema") 194s + res <- dbGetQuery(con, "CREATE TABLE testschema.aa (pid integer, name text)") 194s + res <- dbGetQuery(con, "CREATE TABLE aa (pk integer, v1 float not null, v2 float)" ) 194s + 194s + ## run a simple query and show the query result 194s + df <- dbListFields(con, "aa") 194s + print(df) 194s + if (length(df) == 3){ 194s + cat("PASS: 3 fields returned\n") 194s + }else{ 194s + cat(paste("FAIL:", length(df), "fields returned\n")) 194s + } 194s + 194s + df <- dbListFields(con, c("testschema", "aa")) 194s + print(df) 194s + if (length(df) == 2){ 194s + cat("PASS: 2 fields returned\n") 194s + }else{ 194s + cat(paste("FAIL:", length(df), "fields returned\n")) 194s + } 194s + 194s + 194s + ## cleanup 194s + cat("Removing \"AA\"\n") 194s + dbRemoveTable(con, "aa") 194s + dbGetQuery(con, "DROP TABLE testschema.aa") 194s + dbGetQuery(con, "DROP SCHEMA testschema") 194s + ## and disconnect 194s + dbDisconnect(con) 194s + } 194s > 194s BEGIN TEST dbTransactionTests.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 194s > 194s > ## dbWriteTable test 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > ## 194s > ## Dirk Eddelbuettel, 10 Sep 2009 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + stopifnot(require(datasets)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## create two independent connections 194s + con1 <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + con2 <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + if (dbExistsTable(con1, "rockdata")) { 194s + cat("Removing rockdata\n") 194s + dbRemoveTable(con1, "rockdata") 194s + } 194s + 194s + cat("begin transaction in con1\n") 194s + dbGetQuery(con1, "BEGIN TRANSACTION") 194s + cat("create table rockdata in con1\n") 194s + dbWriteTable(con1, "rockdata", rock) 194s + if (dbExistsTable(con1, "rockdata")) { 194s + cat("PASS rockdata is visible through con1\n") 194s + }else{ 194s + cat("FAIL rockdata is invisible through con1\n") 194s + } 194s + if (dbExistsTable(con2, "rockdata")) { 194s + cat("FAIL rockdata is visible through con2\n") 194s + }else{ 194s + cat("PASS rockdata is invisible through con2\n") 194s + } 194s + cat("commit in con1\n") 194s + dbCommit(con1) 194s + if (dbExistsTable(con2, "rockdata")) { 194s + cat("PASS rockdata is visible through con2\n") 194s + }else{ 194s + cat("FAIL rockdata is invisible through con2\n") 194s + } 194s + 194s + cat("remove the table from con1\n") 194s + dbRemoveTable(con1, "rockdata") 194s + 194s + if (dbExistsTable(con2, "rockdata")) { 194s + cat("FAIL rockdata is visible through con2\n") 194s + }else{ 194s + cat("PASS rockdata is invisible through con2\n") 194s + } 194s + 194s + cat("begin transaction in con1\n") 194s + dbGetQuery(con1, "BEGIN TRANSACTION") 194s + cat("create table rockdata in con1\n") 194s + dbWriteTable(con1, "rockdata", rock) 194s + if (dbExistsTable(con1, "rockdata")) { 194s + cat("PASS rockdata is visible through con1\n") 194s + }else{ 194s + cat("FAIL rockdata is invisible through con1\n") 194s + } 194s + cat("RollBack con1\n") 194s + dbRollback(con1) 194s + if (dbExistsTable(con1, "rockdata")) { 194s + cat("FAIL rockdata is visible through con1\n") 194s + }else{ 194s + cat("PASS rockdata is invisible through con1\n") 194s + } 194s + 194s + ## and disconnect 194s + dbDisconnect(con2) 194s + dbDisconnect(con1) 194s + } 194s > 194s BEGIN TEST dbWriteTableSchema.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 194s > 194s > ## dbWriteTable test 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > ## 194s > ## Dirk Eddelbuettel, 10 Sep 2009 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + stopifnot(require(datasets)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## connect to the default db 194s + con <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + if (dbExistsTable(con, c("public", "rockdata"))) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, c("public", "rockdata")) 194s + } 194s + 194s + dbWriteTable(con, c("public", "rockdata"), rock) 194s + 194s + ## run a simple query and show the query result 194s + res <- dbGetQuery(con, "select * from public.rockdata limit 10") 194s + print(res) 194s + 194s + 194s + ## cleanup 194s + if (dbExistsTable(con, c("public", "rockdata"))) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, c("public", "rockdata")) 194s + } 194s + 194s + ## and disconnect 194s + dbDisconnect(con) 194s + } 194s > 194s BEGIN TEST dbWriteTableTest.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 194s > 194s > ## dbWriteTable test 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > ## 194s > ## Dirk Eddelbuettel, 10 Sep 2009 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + stopifnot(require(datasets)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## connect to the default db 194s + con <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + dbWriteTable(con, "rockdata", rock) 194s + 194s + ## run a simple query and show the query result 194s + res <- dbGetQuery(con, "select * from rockdata limit 10") 194s + print(res) 194s + 194s + 194s + ## cleanup 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + ## and disconnect 194s + dbDisconnect(con) 194s + } 194s > 194s BEGIN TEST dbWriteTabletypes.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 194s > ## dbWriteTable test 194s > ## 194s > ## Assumes that 194s > ## a) PostgreSQL is running, and 194s > ## b) the current user can connect 194s > ## both of which are not viable for release but suitable while we test 194s > ## 194s > ## Dirk Eddelbuettel, 10 Sep 2009 194s > 194s > ## only run this if this env.var is set correctly 194s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 194s + 194s + ## try to load our module and abort if this fails 194s + stopifnot(require(RPostgreSQL)) 194s + 194s + ## load the PostgresSQL driver 194s + drv <- dbDriver("PostgreSQL") 194s + 194s + ## connect to the default db 194s + con <- dbConnect(drv, 194s + user=Sys.getenv("POSTGRES_USER"), 194s + password=Sys.getenv("POSTGRES_PASSWD"), 194s + host=Sys.getenv("POSTGRES_HOST"), 194s + dbname=Sys.getenv("POSTGRES_DATABASE"), 194s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 194s + 194s + 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + dbGetQuery(con, "set client_encoding to 'UTF-8'") 194s + difficultstrings <- c("normal", "t\tab", "v\vertical tab", "n\newline", "r carriage \retern", "back \\ slash", "f\form feed") 194s + df <- data.frame(strings=difficultstrings) 194s + 194s + dbWriteTable(con, "rockdata", df) 194s + 194s + ## run a simple query and show the query result 194s + res <- dbGetQuery(con, "select * from rockdata") 194s + print(res) 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + 194s + difficultstringe <- c("normal", "m\u00fc\u00df") 194s + df <- data.frame(strings=difficultstringe) 194s + tryres <- try({dbWriteTable(con, "rockdata", df) 194s + res <- dbGetQuery(con, "select * from rockdata") 194s + for(n in 1:2){ 194s + cat(paste(as.character(n), "\t")) 194s + cat(res[n,2]) 194s + cat("\n") 194s + } 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + }) 194s + if(tryres != TRUE){ 194s + cat("FAIL: could not write small umlaut u and ligature sz.\n") 194s + cat(" This might be no problem for you if you don't use those special characters.\n") 194s + cat(" Otherwise, please check for the server encoding.\n") 194s + cat(" Database encoding is usually set at the time of createdb.\n") 194s + cat(" You can see for more information on how to setup at \n") 194s + cat(" http://www.postgresql.org/docs/9.1/static/multibyte.html\n\n") 194s + }else{ 194s + cat("PASS: could write small umlaut u and ligature sz\n") 194s + } 194s + 194s + difficultstringk <- c("normal", "kanji\u6f22\u5b57") 194s + df <- data.frame(strings=difficultstringk) 194s + tryres <- try({dbWriteTable(con, "rockdata", df) 194s + res <- dbGetQuery(con, "select * from rockdata") 194s + for(n in 1:2){ 194s + cat(paste(as.character(n), "\t")) 194s + cat(res[n,2]) 194s + cat("\n") 194s + } 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + }) 194s + if(tryres != TRUE){ 194s + cat("FAIL: could not write kanji.\n") 194s + cat(" This might be no problem for you if you don't use multibyte characters.\n") 194s + cat(" Otherwise, please check for the server encoding.\n") 194s + cat(" Database encoding is usually set at the time of createdb.\n") 194s + cat(" You can see for more information on how to setup at \n") 194s + cat(" http://www.postgresql.org/docs/9.1/static/multibyte.html\n\n") 194s + }else{ 194s + cat("PASS: could write kanji\n") 194s + } 194s + 194s + ## cleanup 194s + if (dbExistsTable(con, "rockdata")) { 194s + print("Removing rockdata\n") 194s + dbRemoveTable(con, "rockdata") 194s + } 194s + 194s + if (dbExistsTable(con, "tempostgrestable")) 194s + dbRemoveTable(con, "tempostgrestable") 194s + 194s + ## Test the numeric mapping 194s + dbGetQuery(con, "create table tempostgrestable (intcolumn integer, floatcolumn float);") 194s + 194s + i <- as.integer(10) 194s + j <- as.numeric(56.6) 194s + 194s + sql <- paste("insert into tempostgrestable ", 194s + "values (",i, "," ,j ,") ", sep="") 194s + res <- dbGetQuery(con, sql) 194s + 194s + dat <- dbReadTable(con, "tempostgrestable") 194s + dbRemoveTable(con, "tempostgrestable") 194s + res <- dbWriteTable(con, "numerictable", dat) 194s + dat <- dbReadTable(con, "numerictable") 194s + dbRemoveTable(con, "numerictable") 194s + cat("Read Numeric values\n") 194s + 194s + ## now test the types of the colums we got 194s + if( class(dat[,1]) == "integer" ) { 194s + cat("PASS -- all integer is as expected\n") 194s + }else{ 194s + cat(paste("FAIL -- an integer became ", class(dat[,1]), "\n")) 194s + } 194s + stopifnot( class(dat[,2]) == "numeric" ) 194s + 194s + ## and test the values 194s + if( identical( dat[1,1], i)){ 194s + cat("PASS integer value is preserved") 194s + }else{ 194s + cat(paste("FAIL:", i, "changed to", dat[1,1], "\n")) 194s + } 194s + stopifnot( identical( dat[1,2], j)) 194s + cat("GOOD -- all numeric values are as expected\n") 194s + 194s + ## Test the logical mapping 194s + if (dbExistsTable(con, "testlogical")) 194s + dbRemoveTable(con, "testlogical") 194s + dbGetQuery(con,"create table testlogical (col1 boolean, col2 boolean)") 194s + 194s + i <- as.logical(TRUE) 194s + j <- as.logical(FALSE) 194s + 194s + sql <- paste("insert into testlogical ", 194s + "values (",i, "," ,j ,") ", sep="") 194s + res <- dbGetQuery(con, sql); 194s + 194s + dat <- dbReadTable(con, "testlogical") 194s + res <- dbWriteTable(con, "logicaltable", dat) 194s + dbRemoveTable(con, "testlogical") 194s + dat2 <- dbReadTable(con,"logicaltable") 194s + dbRemoveTable(con, "logicaltable") 194s + cat("Read Logical values\n") 194s + 194s + ## now test the types of the colums we got 194s + stopifnot( class(dat2[,1]) == "logical" ) 194s + stopifnot( class(dat2[,2]) == "logical" ) 194s + cat("GOOD -- all logical types are as expected\n") 194s + 194s + ## and test the values 194s + stopifnot( identical( dat2[1,1], i)) 194s + stopifnot( identical( dat2[1,2], j)) 194s + cat("GOOD -- all logical values are as expected\n") 194s + 194s + ## Test the character mapping 194s + if (dbExistsTable(con, "testchar")) 194s + dbRemoveTable(con, "testchar") 194s + dbGetQuery(con,"create table testchar (code char(3),city varchar(20),country text);") 194s + 194s + i <- as.character("IN") 194s + j <- as.character("Hyderabad") 194s + k <- as.character("India") 194s + 194s + sql <- paste("insert into testchar ", 194s + "values ('",i,"' , '",j ,"' , '",k,"') ", sep="") 194s + res <- dbGetQuery(con, sql); 194s + 194s + dat <- dbReadTable(con, "testchar") 194s + dbRemoveTable(con, "testchar") 194s + dbWriteTable(con, "testchar", dat) 194s + dat <- dbReadTable(con, "testchar") 194s + cat("Read Character values\n") 194s + 194s + ## now test the types of the colums we got 194s + stopifnot( class(dat[,1]) == "character" ) 194s + stopifnot( class(dat[,2]) == "character" ) 194s + stopifnot( class(dat[,3]) == "character" ) 194s + cat("GOOD -- all character types are as expected\n") 194s + 194s + ## and test the values 194s + ##stopifnot( identical( dat[1,1], i)) 194s + stopifnot( identical( dat[1,2], j)) 194s + stopifnot( identical( dat[1,3], k)) 194s + cat("GOOD -- all character values are as expected\n") 194s + 194s + dbRemoveTable(con, "testchar") 194s + dbRemoveTable(con, "tempostgrestable") 194s + 194s + ## Test the numeric mapping 194s + dbGetQuery(con, "create table tempostgrestable (intcolumn date, floatcolumn timestamp with time zone);") 194s + 194s + sql <- paste("insert into tempostgrestable ", 194s + "values ('2011-03-07', '2011-03-07 16:30:39') ") 194s + res <- dbGetQuery(con, sql) 194s + 194s + dat <- dbReadTable(con, "tempostgrestable") 194s + dbRemoveTable(con, "tempostgrestable") 194s + dbWriteTable(con, "tempostgrestable2", dat) 194s + dat2 <- dbReadTable(con, "tempostgrestable2") 194s + dbRemoveTable(con, "tempostgrestable2") 194s + cat("Check that read after write gets the same data types\n") 194s + 194s + ## now test the types of the colums we got 194s + if( class(dat2[1,1]) == "Date" ){ 194s + cat("PASS -- Date type is as expected\n") 194s + }else{ 194s + cat("FAIL -- Date type is other than Date: ") 194s + cat(class(dat2[1,1])) 194s + cat("\n") 194s + } 194s + if( class(dat2[1,2])[1] == "POSIXct" ){ 194s + cat("PASS -- TIMESTAMP is received as POSIXct\n") 194s + }else{ 194s + cat("FAIL -- TIMESTAMP is other than POSIXct: ") 194s + cat(class(dat2[1,2])) 194s + cat("\n") 194s + } 194s + 194s + 194s + dbDisconnect(con) 194s + dbUnloadDriver(drv) 194s + 194s + cat("DONE\n") 194s + } 194s > 194s > 194s BEGIN TEST dbtemptable.R 194s 194s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 194s Copyright (C) 2024 The R Foundation for Statistical Computing 194s Platform: aarch64-unknown-linux-gnu (64-bit) 194s 194s R is free software and comes with ABSOLUTELY NO WARRANTY. 194s You are welcome to redistribute it under certain conditions. 194s Type 'license()' or 'licence()' for distribution details. 194s 194s R is a collaborative project with many contributors. 194s Type 'contributors()' for more information and 194s 'citation()' on how to cite R or R packages in publications. 194s 194s Type 'demo()' for some demos, 'help()' for on-line help, or 194s 'help.start()' for an HTML browser interface to help. 194s Type 'q()' to quit R. 194s 195s > 195s > ## dbWriteTable test 195s > ## 195s > ## Assumes that 195s > ## a) PostgreSQL is running, and 195s > ## b) the current user can connect 195s > ## both of which are not viable for release but suitable while we test 195s > ## 195s > ## Dirk Eddelbuettel, 10 Sep 2009 195s > 195s > ## only run this if this env.var is set correctly 195s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + stopifnot(require(datasets)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + 195s + ## connect to the default db 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + 195s + 195s + a <- dbGetQuery(con, "CREATE TABLE foo (name text)") 195s + b <- dbGetQuery(con, "INSERT INTO foo VALUES ('bar')") 195s + 195s + ## run a simple query and show the query result 195s + x <- dbSendQuery(con, "CREATE TEMPORARY TABLE xyz ON COMMIT DROP AS select * from foo limit 1; select * from xyz;") 195s + res <- fetch(x, n=-1) 195s + print(res) 195s + a <- dbGetQuery(con, "DROP TABLE foo") 195s + 195s + 195s + ## cleanup 195s + 195s + ## and disconnect 195s + dbDisconnect(con) 195s + cat("PASS -- ended without segmentation fault\n") 195s + } 195s > 195s BEGIN TEST escape.R 195s 195s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 195s Copyright (C) 2024 The R Foundation for Statistical Computing 195s Platform: aarch64-unknown-linux-gnu (64-bit) 195s 195s R is free software and comes with ABSOLUTELY NO WARRANTY. 195s You are welcome to redistribute it under certain conditions. 195s Type 'license()' or 'licence()' for distribution details. 195s 195s R is a collaborative project with many contributors. 195s Type 'contributors()' for more information and 195s 'citation()' on how to cite R or R packages in publications. 195s 195s Type 'demo()' for some demos, 'help()' for on-line help, or 195s 'help.start()' for an HTML browser interface to help. 195s Type 'q()' to quit R. 195s 195s > 195s > ## connectWithNull test 195s > ## 195s > ## test for the 'Issue 2' on the Google Code issue log 195s > ## reported in April 2009, still open ? 195s > ## 195s > ## Assumes that 195s > ## a) PostgreSQL is running, and 195s > ## b) the current user can connect 195s > ## both of which are not viable for release but suitable while we test 195s > ## 195s > ## Dirk Eddelbuettel, 03 Oct 2009 195s > 195s > ## only run this if this env.var is set correctly 195s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + stopifnot(require(datasets)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + 195s + ## connect to the default db -- replacing any of these with NULL will lead to 195s + ## a stop() call and a return to the R prompt rather than a segfault 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + st <- (postgresqlEscapeStrings(con,"aaa")) 195s + print(st) 195s + st2 <- (postgresqlEscapeStrings(con,"aa'a")) 195s + print(st2) 195s + 195s + ## and disconnect 195s + dbDisconnect(con) 195s + } 195s > 195s BEGIN TEST loadDriverAndConnect.R 195s 195s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 195s Copyright (C) 2024 The R Foundation for Statistical Computing 195s Platform: aarch64-unknown-linux-gnu (64-bit) 195s 195s R is free software and comes with ABSOLUTELY NO WARRANTY. 195s You are welcome to redistribute it under certain conditions. 195s Type 'license()' or 'licence()' for distribution details. 195s 195s R is a collaborative project with many contributors. 195s Type 'contributors()' for more information and 195s 'citation()' on how to cite R or R packages in publications. 195s 195s Type 'demo()' for some demos, 'help()' for on-line help, or 195s 'help.start()' for an HTML browser interface to help. 195s Type 'q()' to quit R. 195s 195s > 195s > ## First rough version of a test script 195s > ## 195s > ## Assumes that 195s > ## a) PostgreSQL is running, and 195s > ## b) the current user can connect 195s > ## both of which are not viable for release but suitable while we test 195s > ## 195s > ## Dirk Eddelbuettel, 02 Jul 2008 195s > ## 21 Oct 2008 make conditional on environment variables 195s > 195s > ## only run this if this env.var is set correctly 195s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + ## can't print result as it contains process id which changes print(summary(drv)) 195s + 195s + ## connect to the default db 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + ## run a simple query and show the query result 195s + res <- dbGetQuery(con, paste("select datname,encoding,datallowconn from pg_database", 195s + "where datname like 'template%' order by datname")) 195s + print(res) 195s + 195s + ## and disconnect 195s + dbDisconnect(con) 195s + } 195s > 195s BEGIN TEST openSendQuery.R 195s 195s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 195s Copyright (C) 2024 The R Foundation for Statistical Computing 195s Platform: aarch64-unknown-linux-gnu (64-bit) 195s 195s R is free software and comes with ABSOLUTELY NO WARRANTY. 195s You are welcome to redistribute it under certain conditions. 195s Type 'license()' or 'licence()' for distribution details. 195s 195s R is a collaborative project with many contributors. 195s Type 'contributors()' for more information and 195s 'citation()' on how to cite R or R packages in publications. 195s 195s Type 'demo()' for some demos, 'help()' for on-line help, or 195s 'help.start()' for an HTML browser interface to help. 195s Type 'q()' to quit R. 195s 195s > 195s > ## dbWriteTable test 195s > ## 195s > ## Assumes that 195s > ## a) PostgreSQL is running, and 195s > ## b) the current user can connect 195s > ## both of which are not viable for release but suitable while we test 195s > ## 195s > ## Dirk Eddelbuettel, 10 Sep 2009 195s > 195s > ## only run this if this env.var is set correctly 195s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + stopifnot(require(datasets)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + 195s + ## create two independent connections 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + if (dbExistsTable(con, "tmptest")) { 195s + cat("Removing tmptest\n") 195s + dbRemoveTable(con, "tmptest") 195s + } 195s + # create temporary table (as a copy of any existing one) 195s + # dbGetQuery(con, "BEGIN TRANSACTION") 195s + cat("create temp table tmptest with dbGetQuery\n") 195s + dbGetQuery(con, "CREATE TEMP TABLE tmptest (f1 int)") 195s + 195s + # query temp table 195s + rs<-dbGetQuery(con, "SELECT * from tmptest") 195s + print(rs) 195s + 195s + cat("create temp table tmptest with dbSendQuery\n") 195s + dbSendQuery(con, "CREATE TEMP TABLE tmptest2(f2 int)") 195s + 195s + # query temp table 195s + rs2<-dbGetQuery(con, "SELECT * from tmptest2") 195s + print(rs2) 195s + ## and disconnect 195s + dbDisconnect(con) 195s + 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + if (dbExistsTable(con, "tmptest")) { 195s + cat("FAIL tmptest persisted after disconnection\n") 195s + cat("Removing tmptest\n") 195s + dbRemoveTable(con, "tmptest") 195s + }else{ 195s + cat("PASS tmptest disappeared after disconnection\n") 195s + } 195s + dbDisconnect(con) 195s + } 195s > 195s BEGIN TEST selectWithAlias.R 195s 195s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 195s Copyright (C) 2024 The R Foundation for Statistical Computing 195s Platform: aarch64-unknown-linux-gnu (64-bit) 195s 195s R is free software and comes with ABSOLUTELY NO WARRANTY. 195s You are welcome to redistribute it under certain conditions. 195s Type 'license()' or 'licence()' for distribution details. 195s 195s R is a collaborative project with many contributors. 195s Type 'contributors()' for more information and 195s 'citation()' on how to cite R or R packages in publications. 195s 195s Type 'demo()' for some demos, 'help()' for on-line help, or 195s 'help.start()' for an HTML browser interface to help. 195s Type 'q()' to quit R. 195s 195s > 195s > ## selectWithAlias test 195s > ## 195s > ## test for the 'Issue 1' on the Google Code issue log 195s > ## this was reported in June and fixed by Joe Conway (svr committ r100) 195s > ## 195s > ## Assumes that 195s > ## a) PostgreSQL is running, and 195s > ## b) the current user can connect 195s > ## both of which are not viable for release but suitable while we test 195s > ## 195s > ## Dirk Eddelbuettel, 03 Oct 2009 195s > 195s > ## only run this if this env.var is set correctly 195s > if (Sys.getenv("POSTGRES_USER") != "" & Sys.getenv("POSTGRES_HOST") != "" & Sys.getenv("POSTGRES_DATABASE") != "") { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + stopifnot(require(datasets)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + 195s + ## connect to the default db 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + if (dbExistsTable(con, "rockdata")) { 195s + print("Removing rockdata\n") 195s + dbRemoveTable(con, "rockdata") 195s + } 195s + 195s + dbWriteTable(con, "rockdata", rock) 195s + 195s + ## run a simple query and show the query result 195s + res <- dbGetQuery(con, "select area as ar, peri as pe, shape as sh, perm as pr from rockdata limit 10") 195s + print(res) 195s + 195s + ## cleanup 195s + if (dbExistsTable(con, "rockdata")) { 195s + print("Removing rockdata\n") 195s + dbRemoveTable(con, "rockdata") 195s + } 195s + 195s + ## and disconnect 195s + dbDisconnect(con) 195s + } 195s > 195s BEGIN TEST utf.R 195s 195s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 195s Copyright (C) 2024 The R Foundation for Statistical Computing 195s Platform: aarch64-unknown-linux-gnu (64-bit) 195s 195s R is free software and comes with ABSOLUTELY NO WARRANTY. 195s You are welcome to redistribute it under certain conditions. 195s Type 'license()' or 'licence()' for distribution details. 195s 195s R is a collaborative project with many contributors. 195s Type 'contributors()' for more information and 195s 'citation()' on how to cite R or R packages in publications. 195s 195s Type 'demo()' for some demos, 'help()' for on-line help, or 195s 'help.start()' for an HTML browser interface to help. 195s Type 'q()' to quit R. 195s 195s > ## Test of bytea conversion with insert and retrieve to the db. 195s > ## 195s > 195s > if ((Sys.getenv("POSTGRES_USER") != "") & 195s + (Sys.getenv("POSTGRES_HOST") != "") & 195s + (Sys.getenv("POSTGRES_DATABASE") != "")) { 195s + 195s + ## try to load our module and abort if this fails 195s + stopifnot(require(RPostgreSQL)) 195s + 195s + ## load the PostgresSQL driver 195s + drv <- dbDriver("PostgreSQL") 195s + 195s + ## connect to the default db 195s + con <- dbConnect(drv, 195s + user=Sys.getenv("POSTGRES_USER"), 195s + password=Sys.getenv("POSTGRES_PASSWD"), 195s + host=Sys.getenv("POSTGRES_HOST"), 195s + dbname=Sys.getenv("POSTGRES_DATABASE"), 195s + port=ifelse((p<-Sys.getenv("POSTGRES_PORT"))!="", p, 5432)) 195s + 195s + if (dbExistsTable(con, "texttable")) 195s + dbRemoveTable(con, "texttable") 195s + 195s + x_df <- data.frame(x = c("a", "ö", "漢字"), stringsAsFactors = FALSE) 195s + 195s + dbGetQuery(con, "SHOW server_encoding") 195s + dbGetQuery(con, "SET client_encoding = 'UTF8'") 195s + dbGetQuery(con, "SHOW client_encoding") 195s + # write with client_encoding = 'UTF8' and read back what was wrote 195s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 195s + (x_db <- dbReadTable(con, "texttable")) 195s + (e <- Encoding(x_db$x)) 195s + stopifnot( e[1] == "unknown" ) 195s + stopifnot( e[2] == "UTF-8" ) 195s + stopifnot( e[3] == "UTF-8" ) 195s + cat("GOOD -- all encoding are as expected\n") 195s + 195s + x_df <- data.frame(x = c("a", "ö"), stringsAsFactors = FALSE) 195s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 195s + dbGetQuery(con, "SET client_encoding = 'LATIN1'") 195s + dbGetQuery(con, "SHOW client_encoding") 195s + # read with client_encoding = 'LATIN1' what was already in the database 195s + (x_db <- dbReadTable(con, "texttable")) 195s + (e <- Encoding(x_db$x)) 195s + stopifnot( e[1] == "unknown" ) 195s + stopifnot( e[2] == "latin1" ) 195s + cat("GOOD -- all encoding are as expected\n") 195s + 195s + # write with client_encoding = 'LATIN1' and read back what was wrote 195s + dbWriteTable(con, "texttable", x_df, overwrite = TRUE) 195s + (x_db <- dbReadTable(con, "texttable")) 195s + (e <- Encoding(x_db$x)) 195s + stopifnot( e[1] == "unknown" ) 195s + stopifnot( e[2] == "latin1" ) 195s + cat("GOOD -- all encoding are as expected\n") 195s + 195s + dbRemoveTable(con, "texttable") 195s + dbDisconnect(con) 195s + dbUnloadDriver(drv) 195s + cat("DONE\n") 195s + }else{ 195s + cat("Skip because envirinmental variables are not set to tell the connection params.\n") 195s + } 195s Skip because envirinmental variables are not set to tell the connection params. 195s > 196s autopkgtest [20:01:30]: test run-unit-test: -----------------------] 196s autopkgtest [20:01:30]: test run-unit-test: - - - - - - - - - - results - - - - - - - - - - 196s run-unit-test PASS 196s autopkgtest [20:01:30]: test pkg-r-autopkgtest: preparing testbed 199s Reading package lists... 199s Building dependency tree... 199s Reading state information... 200s Starting pkgProblemResolver with broken count: 0 200s Starting 2 pkgProblemResolver with broken count: 0 200s Done 200s The following additional packages will be installed: 200s build-essential cpp cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu 200s dctrl-tools g++ g++-13 g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 200s gcc-13 gcc-13-aarch64-linux-gnu gcc-aarch64-linux-gnu gfortran gfortran-13 200s gfortran-13-aarch64-linux-gnu gfortran-aarch64-linux-gnu icu-devtools 200s libasan8 libatomic1 libblas-dev libbz2-dev libc-dev-bin libc6-dev libcc1-0 200s libcrypt-dev libgcc-13-dev libgfortran-13-dev libhwasan0 libicu-dev libisl23 200s libitm1 libjpeg-dev libjpeg-turbo8-dev libjpeg8-dev liblapack-dev liblsan0 200s liblzma-dev libmpc3 libncurses-dev libnsl-dev libpcre2-16-0 libpcre2-32-0 200s libpcre2-dev libpcre2-posix3 libpkgconf3 libpng-dev libreadline-dev 200s libstdc++-13-dev libtirpc-dev libtsan2 libubsan1 linux-libc-dev pkg-config 200s pkg-r-autopkgtest pkgconf pkgconf-bin r-base-dev rpcsvc-proto zlib1g-dev 200s Suggested packages: 200s cpp-doc gcc-13-locales cpp-13-doc debtags gcc-13-doc gcc-multilib 200s manpages-dev autoconf automake libtool flex bison gdb gcc-doc 200s gdb-aarch64-linux-gnu gfortran-doc gfortran-13-doc libcoarrays-dev 200s liblapack-doc glibc-doc icu-doc liblzma-doc ncurses-doc readline-doc 200s libstdc++-13-doc texlive-base texlive-latex-base texlive-plain-generic 200s texlive-fonts-recommended texlive-fonts-extra texlive-extra-utils 200s texlive-latex-recommended texlive-latex-extra texinfo 200s Recommended packages: 200s bzip2-doc manpages manpages-dev libc-devtools libpng-tools 200s The following NEW packages will be installed: 200s autopkgtest-satdep build-essential cpp cpp-13 cpp-13-aarch64-linux-gnu 200s cpp-aarch64-linux-gnu dctrl-tools g++ g++-13 g++-13-aarch64-linux-gnu 200s g++-aarch64-linux-gnu gcc gcc-13 gcc-13-aarch64-linux-gnu 200s gcc-aarch64-linux-gnu gfortran gfortran-13 gfortran-13-aarch64-linux-gnu 200s gfortran-aarch64-linux-gnu icu-devtools libasan8 libatomic1 libblas-dev 200s libbz2-dev libc-dev-bin libc6-dev libcc1-0 libcrypt-dev libgcc-13-dev 200s libgfortran-13-dev libhwasan0 libicu-dev libisl23 libitm1 libjpeg-dev 200s libjpeg-turbo8-dev libjpeg8-dev liblapack-dev liblsan0 liblzma-dev libmpc3 200s libncurses-dev libnsl-dev libpcre2-16-0 libpcre2-32-0 libpcre2-dev 200s libpcre2-posix3 libpkgconf3 libpng-dev libreadline-dev libstdc++-13-dev 200s libtirpc-dev libtsan2 libubsan1 linux-libc-dev pkg-config pkg-r-autopkgtest 200s pkgconf pkgconf-bin r-base-dev rpcsvc-proto zlib1g-dev 200s 0 upgraded, 62 newly installed, 0 to remove and 0 not upgraded. 200s Need to get 92.8 MB/92.8 MB of archives. 200s After this operation, 343 MB of additional disk space will be used. 200s Get:1 /tmp/autopkgtest.ODfDuX/2-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [724 B] 200s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 libc-dev-bin arm64 2.39-0ubuntu2 [19.7 kB] 201s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 linux-libc-dev arm64 6.8.0-11.11 [1569 kB] 201s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libcrypt-dev arm64 1:4.4.36-4 [136 kB] 201s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libtirpc-dev arm64 1.3.4+ds-1.1 [201 kB] 201s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libnsl-dev arm64 1.3.0-3 [71.9 kB] 201s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 rpcsvc-proto arm64 1.4.2-0ubuntu6 [65.4 kB] 201s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 libc6-dev arm64 2.39-0ubuntu2 [1596 kB] 201s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 libisl23 arm64 0.26-3 [713 kB] 201s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libmpc3 arm64 1.3.1-1 [55.3 kB] 201s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [10.3 MB] 201s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13 arm64 13.2.0-17ubuntu2 [1028 B] 201s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [5316 B] 201s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 cpp arm64 4:13.2.0-7ubuntu1 [22.4 kB] 201s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 libcc1-0 arm64 14-20240303-1ubuntu1 [44.7 kB] 201s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 libitm1 arm64 14-20240303-1ubuntu1 [27.7 kB] 201s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 libatomic1 arm64 14-20240303-1ubuntu1 [11.4 kB] 201s Get:18 http://ftpmaster.internal/ubuntu noble/main arm64 libasan8 arm64 14-20240303-1ubuntu1 [2919 kB] 201s Get:19 http://ftpmaster.internal/ubuntu noble/main arm64 liblsan0 arm64 14-20240303-1ubuntu1 [1282 kB] 201s Get:20 http://ftpmaster.internal/ubuntu noble/main arm64 libtsan2 arm64 14-20240303-1ubuntu1 [2687 kB] 201s Get:21 http://ftpmaster.internal/ubuntu noble/main arm64 libubsan1 arm64 14-20240303-1ubuntu1 [1151 kB] 201s Get:22 http://ftpmaster.internal/ubuntu noble/main arm64 libhwasan0 arm64 14-20240303-1ubuntu1 [1597 kB] 201s Get:23 http://ftpmaster.internal/ubuntu noble/main arm64 libgcc-13-dev arm64 13.2.0-17ubuntu2 [2464 kB] 202s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [20.1 MB] 202s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13 arm64 13.2.0-17ubuntu2 [467 kB] 202s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1198 B] 202s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 gcc arm64 4:13.2.0-7ubuntu1 [5018 B] 202s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libstdc++-13-dev arm64 13.2.0-17ubuntu2 [2322 kB] 202s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [11.7 MB] 202s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13 arm64 13.2.0-17ubuntu2 [14.4 kB] 202s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 g++-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [962 B] 202s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 g++ arm64 4:13.2.0-7ubuntu1 [1082 B] 202s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 202s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 dctrl-tools arm64 2.24-3build2 [65.2 kB] 202s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 libgfortran-13-dev arm64 13.2.0-17ubuntu2 [478 kB] 202s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [10.8 MB] 203s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-13 arm64 13.2.0-17ubuntu2 [10.3 kB] 203s Get:38 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1022 B] 203s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 gfortran arm64 4:13.2.0-7ubuntu1 [1164 B] 203s Get:40 http://ftpmaster.internal/ubuntu noble/main arm64 icu-devtools arm64 74.2-1ubuntu1 [209 kB] 203s Get:41 http://ftpmaster.internal/ubuntu noble/main arm64 libblas-dev arm64 3.12.0-3 [111 kB] 203s Get:42 http://ftpmaster.internal/ubuntu noble/main arm64 libbz2-dev arm64 1.0.8-5ubuntu1 [35.8 kB] 203s Get:43 http://ftpmaster.internal/ubuntu noble/main arm64 libicu-dev arm64 74.2-1ubuntu1 [11.9 MB] 203s Get:44 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-turbo8-dev arm64 2.1.5-2ubuntu1 [304 kB] 203s Get:45 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg8-dev arm64 8c-2ubuntu11 [1484 B] 203s Get:46 http://ftpmaster.internal/ubuntu noble/main arm64 libjpeg-dev arm64 8c-2ubuntu11 [1482 B] 203s Get:47 http://ftpmaster.internal/ubuntu noble/main arm64 liblapack-dev arm64 3.12.0-3 [4293 kB] 203s Get:48 http://ftpmaster.internal/ubuntu noble/main arm64 libncurses-dev arm64 6.4+20240113-1ubuntu1 [385 kB] 203s Get:49 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-16-0 arm64 10.42-4ubuntu1 [195 kB] 203s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-32-0 arm64 10.42-4ubuntu1 [183 kB] 203s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-posix3 arm64 10.42-4ubuntu1 [6654 B] 203s Get:52 http://ftpmaster.internal/ubuntu noble/main arm64 libpcre2-dev arm64 10.42-4ubuntu1 [679 kB] 203s Get:53 http://ftpmaster.internal/ubuntu noble/main arm64 libpkgconf3 arm64 1.8.1-2 [31.2 kB] 203s Get:54 http://ftpmaster.internal/ubuntu noble/main arm64 zlib1g-dev arm64 1:1.3.dfsg-3ubuntu1 [895 kB] 203s Get:55 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libpng-dev arm64 1.6.43-3 [267 kB] 203s Get:56 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libreadline-dev arm64 8.2-3.1 [177 kB] 203s Get:57 http://ftpmaster.internal/ubuntu noble/main arm64 pkgconf-bin arm64 1.8.1-2 [20.4 kB] 203s Get:58 http://ftpmaster.internal/ubuntu noble/main arm64 pkgconf arm64 1.8.1-2 [16.7 kB] 203s Get:59 http://ftpmaster.internal/ubuntu noble/main arm64 pkg-config arm64 1.8.1-2 [7170 B] 203s Get:60 http://ftpmaster.internal/ubuntu noble/main arm64 liblzma-dev arm64 5.4.5-0.3 [209 kB] 203s Get:61 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 r-base-dev all 4.3.3-2build1 [4334 B] 203s Get:62 http://ftpmaster.internal/ubuntu noble/universe arm64 pkg-r-autopkgtest all 20231212ubuntu1 [6448 B] 204s Fetched 92.8 MB in 3s (33.1 MB/s) 204s Selecting previously unselected package libc-dev-bin. 204s (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 ... 77053 files and directories currently installed.) 204s Preparing to unpack .../00-libc-dev-bin_2.39-0ubuntu2_arm64.deb ... 204s Unpacking libc-dev-bin (2.39-0ubuntu2) ... 204s Selecting previously unselected package linux-libc-dev:arm64. 204s Preparing to unpack .../01-linux-libc-dev_6.8.0-11.11_arm64.deb ... 204s Unpacking linux-libc-dev:arm64 (6.8.0-11.11) ... 204s Selecting previously unselected package libcrypt-dev:arm64. 204s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.36-4_arm64.deb ... 204s Unpacking libcrypt-dev:arm64 (1:4.4.36-4) ... 204s Selecting previously unselected package libtirpc-dev:arm64. 204s Preparing to unpack .../03-libtirpc-dev_1.3.4+ds-1.1_arm64.deb ... 204s Unpacking libtirpc-dev:arm64 (1.3.4+ds-1.1) ... 204s Selecting previously unselected package libnsl-dev:arm64. 204s Preparing to unpack .../04-libnsl-dev_1.3.0-3_arm64.deb ... 204s Unpacking libnsl-dev:arm64 (1.3.0-3) ... 204s Selecting previously unselected package rpcsvc-proto. 204s Preparing to unpack .../05-rpcsvc-proto_1.4.2-0ubuntu6_arm64.deb ... 204s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 204s Selecting previously unselected package libc6-dev:arm64. 204s Preparing to unpack .../06-libc6-dev_2.39-0ubuntu2_arm64.deb ... 204s Unpacking libc6-dev:arm64 (2.39-0ubuntu2) ... 204s Selecting previously unselected package libisl23:arm64. 204s Preparing to unpack .../07-libisl23_0.26-3_arm64.deb ... 204s Unpacking libisl23:arm64 (0.26-3) ... 204s Selecting previously unselected package libmpc3:arm64. 204s Preparing to unpack .../08-libmpc3_1.3.1-1_arm64.deb ... 204s Unpacking libmpc3:arm64 (1.3.1-1) ... 204s Selecting previously unselected package cpp-13-aarch64-linux-gnu. 204s Preparing to unpack .../09-cpp-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 204s Unpacking cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 205s Selecting previously unselected package cpp-13. 205s Preparing to unpack .../10-cpp-13_13.2.0-17ubuntu2_arm64.deb ... 205s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 205s Selecting previously unselected package cpp-aarch64-linux-gnu. 205s Preparing to unpack .../11-cpp-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 205s Unpacking cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 205s Selecting previously unselected package cpp. 205s Preparing to unpack .../12-cpp_4%3a13.2.0-7ubuntu1_arm64.deb ... 205s Unpacking cpp (4:13.2.0-7ubuntu1) ... 205s Selecting previously unselected package libcc1-0:arm64. 205s Preparing to unpack .../13-libcc1-0_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libcc1-0:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libitm1:arm64. 205s Preparing to unpack .../14-libitm1_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libitm1:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libatomic1:arm64. 205s Preparing to unpack .../15-libatomic1_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libatomic1:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libasan8:arm64. 205s Preparing to unpack .../16-libasan8_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libasan8:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package liblsan0:arm64. 205s Preparing to unpack .../17-liblsan0_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking liblsan0:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libtsan2:arm64. 205s Preparing to unpack .../18-libtsan2_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libtsan2:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libubsan1:arm64. 205s Preparing to unpack .../19-libubsan1_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libubsan1:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libhwasan0:arm64. 205s Preparing to unpack .../20-libhwasan0_14-20240303-1ubuntu1_arm64.deb ... 205s Unpacking libhwasan0:arm64 (14-20240303-1ubuntu1) ... 205s Selecting previously unselected package libgcc-13-dev:arm64. 205s Preparing to unpack .../21-libgcc-13-dev_13.2.0-17ubuntu2_arm64.deb ... 205s Unpacking libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 205s Selecting previously unselected package gcc-13-aarch64-linux-gnu. 205s Preparing to unpack .../22-gcc-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 205s Unpacking gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package gcc-13. 206s Preparing to unpack .../23-gcc-13_13.2.0-17ubuntu2_arm64.deb ... 206s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package gcc-aarch64-linux-gnu. 206s Preparing to unpack .../24-gcc-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 206s Unpacking gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 206s Selecting previously unselected package gcc. 206s Preparing to unpack .../25-gcc_4%3a13.2.0-7ubuntu1_arm64.deb ... 206s Unpacking gcc (4:13.2.0-7ubuntu1) ... 206s Selecting previously unselected package libstdc++-13-dev:arm64. 206s Preparing to unpack .../26-libstdc++-13-dev_13.2.0-17ubuntu2_arm64.deb ... 206s Unpacking libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package g++-13-aarch64-linux-gnu. 206s Preparing to unpack .../27-g++-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 206s Unpacking g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package g++-13. 206s Preparing to unpack .../28-g++-13_13.2.0-17ubuntu2_arm64.deb ... 206s Unpacking g++-13 (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package g++-aarch64-linux-gnu. 206s Preparing to unpack .../29-g++-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 206s Unpacking g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 206s Selecting previously unselected package g++. 206s Preparing to unpack .../30-g++_4%3a13.2.0-7ubuntu1_arm64.deb ... 206s Unpacking g++ (4:13.2.0-7ubuntu1) ... 206s Selecting previously unselected package build-essential. 206s Preparing to unpack .../31-build-essential_12.10ubuntu1_arm64.deb ... 206s Unpacking build-essential (12.10ubuntu1) ... 206s Selecting previously unselected package dctrl-tools. 206s Preparing to unpack .../32-dctrl-tools_2.24-3build2_arm64.deb ... 206s Unpacking dctrl-tools (2.24-3build2) ... 206s Selecting previously unselected package libgfortran-13-dev:arm64. 206s Preparing to unpack .../33-libgfortran-13-dev_13.2.0-17ubuntu2_arm64.deb ... 206s Unpacking libgfortran-13-dev:arm64 (13.2.0-17ubuntu2) ... 206s Selecting previously unselected package gfortran-13-aarch64-linux-gnu. 207s Preparing to unpack .../34-gfortran-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 207s Unpacking gfortran-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 207s Selecting previously unselected package gfortran-13. 207s Preparing to unpack .../35-gfortran-13_13.2.0-17ubuntu2_arm64.deb ... 207s Unpacking gfortran-13 (13.2.0-17ubuntu2) ... 207s Selecting previously unselected package gfortran-aarch64-linux-gnu. 207s Preparing to unpack .../36-gfortran-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 207s Unpacking gfortran-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 207s Selecting previously unselected package gfortran. 207s Preparing to unpack .../37-gfortran_4%3a13.2.0-7ubuntu1_arm64.deb ... 207s Unpacking gfortran (4:13.2.0-7ubuntu1) ... 207s Selecting previously unselected package icu-devtools. 207s Preparing to unpack .../38-icu-devtools_74.2-1ubuntu1_arm64.deb ... 207s Unpacking icu-devtools (74.2-1ubuntu1) ... 207s Selecting previously unselected package libblas-dev:arm64. 207s Preparing to unpack .../39-libblas-dev_3.12.0-3_arm64.deb ... 207s Unpacking libblas-dev:arm64 (3.12.0-3) ... 207s Selecting previously unselected package libbz2-dev:arm64. 207s Preparing to unpack .../40-libbz2-dev_1.0.8-5ubuntu1_arm64.deb ... 207s Unpacking libbz2-dev:arm64 (1.0.8-5ubuntu1) ... 207s Selecting previously unselected package libicu-dev:arm64. 207s Preparing to unpack .../41-libicu-dev_74.2-1ubuntu1_arm64.deb ... 207s Unpacking libicu-dev:arm64 (74.2-1ubuntu1) ... 207s Selecting previously unselected package libjpeg-turbo8-dev:arm64. 207s Preparing to unpack .../42-libjpeg-turbo8-dev_2.1.5-2ubuntu1_arm64.deb ... 207s Unpacking libjpeg-turbo8-dev:arm64 (2.1.5-2ubuntu1) ... 207s Selecting previously unselected package libjpeg8-dev:arm64. 207s Preparing to unpack .../43-libjpeg8-dev_8c-2ubuntu11_arm64.deb ... 207s Unpacking libjpeg8-dev:arm64 (8c-2ubuntu11) ... 207s Selecting previously unselected package libjpeg-dev:arm64. 207s Preparing to unpack .../44-libjpeg-dev_8c-2ubuntu11_arm64.deb ... 207s Unpacking libjpeg-dev:arm64 (8c-2ubuntu11) ... 207s Selecting previously unselected package liblapack-dev:arm64. 207s Preparing to unpack .../45-liblapack-dev_3.12.0-3_arm64.deb ... 207s Unpacking liblapack-dev:arm64 (3.12.0-3) ... 208s Selecting previously unselected package libncurses-dev:arm64. 208s Preparing to unpack .../46-libncurses-dev_6.4+20240113-1ubuntu1_arm64.deb ... 208s Unpacking libncurses-dev:arm64 (6.4+20240113-1ubuntu1) ... 208s Selecting previously unselected package libpcre2-16-0:arm64. 208s Preparing to unpack .../47-libpcre2-16-0_10.42-4ubuntu1_arm64.deb ... 208s Unpacking libpcre2-16-0:arm64 (10.42-4ubuntu1) ... 208s Selecting previously unselected package libpcre2-32-0:arm64. 208s Preparing to unpack .../48-libpcre2-32-0_10.42-4ubuntu1_arm64.deb ... 208s Unpacking libpcre2-32-0:arm64 (10.42-4ubuntu1) ... 208s Selecting previously unselected package libpcre2-posix3:arm64. 208s Preparing to unpack .../49-libpcre2-posix3_10.42-4ubuntu1_arm64.deb ... 208s Unpacking libpcre2-posix3:arm64 (10.42-4ubuntu1) ... 208s Selecting previously unselected package libpcre2-dev:arm64. 208s Preparing to unpack .../50-libpcre2-dev_10.42-4ubuntu1_arm64.deb ... 208s Unpacking libpcre2-dev:arm64 (10.42-4ubuntu1) ... 208s Selecting previously unselected package libpkgconf3:arm64. 208s Preparing to unpack .../51-libpkgconf3_1.8.1-2_arm64.deb ... 208s Unpacking libpkgconf3:arm64 (1.8.1-2) ... 208s Selecting previously unselected package zlib1g-dev:arm64. 208s Preparing to unpack .../52-zlib1g-dev_1%3a1.3.dfsg-3ubuntu1_arm64.deb ... 208s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg-3ubuntu1) ... 208s Selecting previously unselected package libpng-dev:arm64. 208s Preparing to unpack .../53-libpng-dev_1.6.43-3_arm64.deb ... 208s Unpacking libpng-dev:arm64 (1.6.43-3) ... 208s Selecting previously unselected package libreadline-dev:arm64. 208s Preparing to unpack .../54-libreadline-dev_8.2-3.1_arm64.deb ... 208s Unpacking libreadline-dev:arm64 (8.2-3.1) ... 208s Selecting previously unselected package pkgconf-bin. 208s Preparing to unpack .../55-pkgconf-bin_1.8.1-2_arm64.deb ... 208s Unpacking pkgconf-bin (1.8.1-2) ... 208s Selecting previously unselected package pkgconf:arm64. 208s Preparing to unpack .../56-pkgconf_1.8.1-2_arm64.deb ... 208s Unpacking pkgconf:arm64 (1.8.1-2) ... 208s Selecting previously unselected package pkg-config:arm64. 208s Preparing to unpack .../57-pkg-config_1.8.1-2_arm64.deb ... 208s Unpacking pkg-config:arm64 (1.8.1-2) ... 208s Selecting previously unselected package liblzma-dev:arm64. 208s Preparing to unpack .../58-liblzma-dev_5.4.5-0.3_arm64.deb ... 208s Unpacking liblzma-dev:arm64 (5.4.5-0.3) ... 208s Selecting previously unselected package r-base-dev. 208s Preparing to unpack .../59-r-base-dev_4.3.3-2build1_all.deb ... 208s Unpacking r-base-dev (4.3.3-2build1) ... 208s Selecting previously unselected package pkg-r-autopkgtest. 208s Preparing to unpack .../60-pkg-r-autopkgtest_20231212ubuntu1_all.deb ... 208s Unpacking pkg-r-autopkgtest (20231212ubuntu1) ... 208s Selecting previously unselected package autopkgtest-satdep. 208s Preparing to unpack .../61-2-autopkgtest-satdep.deb ... 208s Unpacking autopkgtest-satdep (0) ... 208s Setting up linux-libc-dev:arm64 (6.8.0-11.11) ... 208s Setting up libpcre2-16-0:arm64 (10.42-4ubuntu1) ... 208s Setting up libpcre2-32-0:arm64 (10.42-4ubuntu1) ... 208s Setting up libtirpc-dev:arm64 (1.3.4+ds-1.1) ... 208s Setting up libpkgconf3:arm64 (1.8.1-2) ... 208s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 208s Setting up libmpc3:arm64 (1.3.1-1) ... 208s Setting up libatomic1:arm64 (14-20240303-1ubuntu1) ... 208s Setting up icu-devtools (74.2-1ubuntu1) ... 208s Setting up pkgconf-bin (1.8.1-2) ... 208s Setting up liblzma-dev:arm64 (5.4.5-0.3) ... 208s Setting up libubsan1:arm64 (14-20240303-1ubuntu1) ... 208s Setting up libpcre2-posix3:arm64 (10.42-4ubuntu1) ... 208s Setting up libnsl-dev:arm64 (1.3.0-3) ... 208s Setting up libhwasan0:arm64 (14-20240303-1ubuntu1) ... 208s Setting up libcrypt-dev:arm64 (1:4.4.36-4) ... 208s Setting up libasan8:arm64 (14-20240303-1ubuntu1) ... 208s Setting up libtsan2:arm64 (14-20240303-1ubuntu1) ... 208s Setting up libisl23:arm64 (0.26-3) ... 208s Setting up libc-dev-bin (2.39-0ubuntu2) ... 208s Setting up libcc1-0:arm64 (14-20240303-1ubuntu1) ... 208s Setting up liblsan0:arm64 (14-20240303-1ubuntu1) ... 208s Setting up libblas-dev:arm64 (3.12.0-3) ... 208s 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 208s Setting up dctrl-tools (2.24-3build2) ... 208s Setting up libitm1:arm64 (14-20240303-1ubuntu1) ... 208s Setting up cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 208s Setting up pkgconf:arm64 (1.8.1-2) ... 208s Setting up cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 208s Setting up liblapack-dev:arm64 (3.12.0-3) ... 208s 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 208s Setting up pkg-config:arm64 (1.8.1-2) ... 208s Setting up libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 208s Setting up libc6-dev:arm64 (2.39-0ubuntu2) ... 208s Setting up libgfortran-13-dev:arm64 (13.2.0-17ubuntu2) ... 208s Setting up libicu-dev:arm64 (74.2-1ubuntu1) ... 208s Setting up libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 208s Setting up libbz2-dev:arm64 (1.0.8-5ubuntu1) ... 208s Setting up libjpeg-turbo8-dev:arm64 (2.1.5-2ubuntu1) ... 208s Setting up libncurses-dev:arm64 (6.4+20240113-1ubuntu1) ... 208s Setting up libpcre2-dev:arm64 (10.42-4ubuntu1) ... 208s Setting up cpp-13 (13.2.0-17ubuntu2) ... 208s Setting up gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 208s Setting up libreadline-dev:arm64 (8.2-3.1) ... 208s Setting up gcc-13 (13.2.0-17ubuntu2) ... 208s Setting up zlib1g-dev:arm64 (1:1.3.dfsg-3ubuntu1) ... 208s Setting up cpp (4:13.2.0-7ubuntu1) ... 208s Setting up libjpeg8-dev:arm64 (8c-2ubuntu11) ... 208s Setting up g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 208s Setting up gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 208s Setting up g++-13 (13.2.0-17ubuntu2) ... 208s Setting up libpng-dev:arm64 (1.6.43-3) ... 208s Setting up libjpeg-dev:arm64 (8c-2ubuntu11) ... 208s Setting up gfortran-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 208s Setting up gcc (4:13.2.0-7ubuntu1) ... 208s Setting up gfortran-13 (13.2.0-17ubuntu2) ... 208s Setting up g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 208s Setting up gfortran-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 208s Setting up gfortran (4:13.2.0-7ubuntu1) ... 208s update-alternatives: using /usr/bin/gfortran to provide /usr/bin/f95 (f95) in auto mode 208s 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 208s update-alternatives: using /usr/bin/gfortran to provide /usr/bin/f77 (f77) in auto mode 208s 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 208s Setting up g++ (4:13.2.0-7ubuntu1) ... 208s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 208s Setting up build-essential (12.10ubuntu1) ... 208s Setting up r-base-dev (4.3.3-2build1) ... 208s Setting up pkg-r-autopkgtest (20231212ubuntu1) ... 208s Setting up autopkgtest-satdep (0) ... 208s Processing triggers for man-db (2.12.0-3) ... 209s Processing triggers for install-info (7.1-3) ... 209s Processing triggers for libc-bin (2.39-0ubuntu2) ... 213s (Reading database ... 80612 files and directories currently installed.) 213s Removing autopkgtest-satdep (0) ... 213s autopkgtest [20:01:47]: test pkg-r-autopkgtest: /usr/share/dh-r/pkg-r-autopkgtest 213s autopkgtest [20:01:47]: test pkg-r-autopkgtest: [----------------------- 213s Test: Try to load the R library RPostgreSQL 214s 214s R version 4.3.3 (2024-02-29) -- "Angel Food Cake" 214s Copyright (C) 2024 The R Foundation for Statistical Computing 214s Platform: aarch64-unknown-linux-gnu (64-bit) 214s 214s R is free software and comes with ABSOLUTELY NO WARRANTY. 214s You are welcome to redistribute it under certain conditions. 214s Type 'license()' or 'licence()' for distribution details. 214s 214s R is a collaborative project with many contributors. 214s Type 'contributors()' for more information and 214s 'citation()' on how to cite R or R packages in publications. 214s 214s Type 'demo()' for some demos, 'help()' for on-line help, or 214s 'help.start()' for an HTML browser interface to help. 214s Type 'q()' to quit R. 214s 214s > library('RPostgreSQL') 214s Loading required package: DBI 214s > 214s > 214s Other tests are currently unsupported! 214s They will be progressively added. 214s autopkgtest [20:01:48]: test pkg-r-autopkgtest: -----------------------] 215s autopkgtest [20:01:49]: test pkg-r-autopkgtest: - - - - - - - - - - results - - - - - - - - - - 215s pkg-r-autopkgtest PASS 215s autopkgtest [20:01:49]: @@@@@@@@@@@@@@@@@@@@ summary 215s run-unit-test PASS 215s pkg-r-autopkgtest PASS 233s Creating nova instance adt-noble-arm64-r-cran-rpostgresql-20240316-195814-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-arm64-server-20240314.img (UUID 7faf5f09-d335-4346-a441-4eab2f9c04fe)...