0s autopkgtest [04:54:32]: starting date and time: 2025-05-02 04:54:32+0000 0s autopkgtest [04:54:32]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [04:54:32]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ehhbv8er/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_proxy=127.0.0.1,127.0.1.1,localhost,localdomain,internal,login.ubuntu.com,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com\n" >> /etc/environment' --apt-pocket=proposed=src:firebird3.0 --apt-upgrade firebird4.0 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=firebird3.0/3.0.12.ds7-13 -- lxd -r lxd-armhf-10.145.243.39 lxd-armhf-10.145.243.39:autopkgtest/ubuntu/questing/armhf 20s autopkgtest [04:54:52]: testbed dpkg architecture: armhf 22s autopkgtest [04:54:54]: testbed apt version: 3.0.0 26s autopkgtest [04:54:58]: @@@@@@@@@@@@@@@@@@@@ test bed setup 28s autopkgtest [04:55:00]: testbed release detected to be: None 35s autopkgtest [04:55:07]: updating testbed package index (apt update) 37s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 37s Get:2 http://ftpmaster.internal/ubuntu questing InRelease [110 kB] 38s Get:3 http://ftpmaster.internal/ubuntu questing-updates InRelease [110 kB] 38s Get:4 http://ftpmaster.internal/ubuntu questing-security InRelease [110 kB] 38s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2202 kB] 38s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 38s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [184 kB] 38s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main armhf Packages [206 kB] 38s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe armhf Packages [1383 kB] 38s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse armhf Packages [15.1 kB] 38s Get:11 http://ftpmaster.internal/ubuntu questing/universe Sources [21.1 MB] 42s Get:12 http://ftpmaster.internal/ubuntu questing/main Sources [1385 kB] 42s Get:13 http://ftpmaster.internal/ubuntu questing/main armhf Packages [1358 kB] 42s Get:14 http://ftpmaster.internal/ubuntu questing/universe armhf Packages [15.0 MB] 46s Fetched 43.3 MB in 9s (4652 kB/s) 47s Reading package lists... 53s autopkgtest [04:55:25]: upgrading testbed (apt dist-upgrade and autopurge) 55s Reading package lists... 55s Building dependency tree... 55s Reading state information... 56s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 56s Starting 2 pkgProblemResolver with broken count: 0 56s Done 57s Entering ResolveByKeep 57s 57s Calculating upgrade... 57s The following packages will be upgraded: 57s base-files distro-info-data dpkg dpkg-dev libdpkg-perl motd-news-config 57s ubuntu-pro-client ubuntu-pro-client-l10n 58s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 58s Need to get 2989 kB of archives. 58s After this operation, 1024 B of additional disk space will be used. 58s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf motd-news-config all 13.7ubuntu1 [5260 B] 58s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf base-files armhf 13.7ubuntu1 [75.4 kB] 58s Get:3 http://ftpmaster.internal/ubuntu questing/main armhf dpkg armhf 1.22.18ubuntu3 [1254 kB] 58s Get:4 http://ftpmaster.internal/ubuntu questing/main armhf distro-info-data all 0.64 [6664 B] 58s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf ubuntu-pro-client-l10n armhf 35.1ubuntu0 [19.7 kB] 58s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf ubuntu-pro-client armhf 35.1ubuntu0 [258 kB] 58s Get:7 http://ftpmaster.internal/ubuntu questing/main armhf dpkg-dev all 1.22.18ubuntu3 [1089 kB] 59s Get:8 http://ftpmaster.internal/ubuntu questing/main armhf libdpkg-perl all 1.22.18ubuntu3 [281 kB] 59s Fetched 2989 kB in 1s (2655 kB/s) 59s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 63953 files and directories currently installed.) 59s Preparing to unpack .../motd-news-config_13.7ubuntu1_all.deb ... 59s Unpacking motd-news-config (13.7ubuntu1) over (13.6ubuntu2) ... 59s Preparing to unpack .../base-files_13.7ubuntu1_armhf.deb ... 60s Unpacking base-files (13.7ubuntu1) over (13.6ubuntu2) ... 60s Setting up base-files (13.7ubuntu1) ... 60s Installing new version of config file /etc/issue ... 60s Installing new version of config file /etc/issue.net ... 60s Installing new version of config file /etc/lsb-release ... 60s motd-news.service is a disabled or a static unit not running, not starting it. 60s (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 ... 63953 files and directories currently installed.) 60s Preparing to unpack .../dpkg_1.22.18ubuntu3_armhf.deb ... 60s Unpacking dpkg (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 61s Setting up dpkg (1.22.18ubuntu3) ... 61s (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 ... 63953 files and directories currently installed.) 61s Preparing to unpack .../distro-info-data_0.64_all.deb ... 61s Unpacking distro-info-data (0.64) over (0.63) ... 61s Preparing to unpack .../ubuntu-pro-client-l10n_35.1ubuntu0_armhf.deb ... 61s Unpacking ubuntu-pro-client-l10n (35.1ubuntu0) over (35) ... 61s Preparing to unpack .../ubuntu-pro-client_35.1ubuntu0_armhf.deb ... 61s Unpacking ubuntu-pro-client (35.1ubuntu0) over (35) ... 61s Preparing to unpack .../dpkg-dev_1.22.18ubuntu3_all.deb ... 61s Unpacking dpkg-dev (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 61s Preparing to unpack .../libdpkg-perl_1.22.18ubuntu3_all.deb ... 61s Unpacking libdpkg-perl (1.22.18ubuntu3) over (1.22.18ubuntu2) ... 61s Setting up motd-news-config (13.7ubuntu1) ... 61s Setting up distro-info-data (0.64) ... 61s Setting up libdpkg-perl (1.22.18ubuntu3) ... 61s Setting up ubuntu-pro-client (35.1ubuntu0) ... 62s apparmor_parser: Unable to replace "ubuntu_pro_apt_news". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 62s 62s apparmor_parser: Unable to replace "apt_methods". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 62s 62s apparmor_parser: Unable to replace "ubuntu_pro_esm_cache". apparmor_parser: Access denied. You need policy admin privileges to manage profiles. 62s 63s Setting up ubuntu-pro-client-l10n (35.1ubuntu0) ... 63s Setting up dpkg-dev (1.22.18ubuntu3) ... 63s Processing triggers for install-info (7.1.1-1) ... 63s Processing triggers for man-db (2.13.0-1) ... 65s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-2ubuntu7) ... 65s Processing triggers for initramfs-tools (0.147ubuntu1) ... 67s Reading package lists... 67s Building dependency tree... 67s Reading state information... 67s Starting pkgProblemResolver with broken count: 0 68s Starting 2 pkgProblemResolver with broken count: 0 68s Done 68s Solving dependencies... 69s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 71s autopkgtest [04:55:43]: rebooting testbed after setup commands that affected boot 110s autopkgtest [04:56:22]: testbed running kernel: Linux 6.8.0-58-generic #60~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 28 14:48:37 UTC 2 134s autopkgtest [04:56:46]: @@@@@@@@@@@@@@@@@@@@ apt-source firebird4.0 184s Get:1 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (dsc) [2860 B] 184s Get:2 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (tar) [3965 kB] 184s Get:3 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (diff) [101 kB] 184s gpgv: Signature made Mon Feb 17 08:03:03 2025 UTC 184s gpgv: using RSA key AEA0C44ECB056E93630D9D33DBBE9D4D99D2A004 184s gpgv: Can't check signature: No public key 184s dpkg-source: warning: cannot verify inline signature for ./firebird4.0_4.0.5.3140.ds6-16.dsc: no acceptable signature found 185s autopkgtest [04:57:37]: testing package firebird4.0 version 4.0.5.3140.ds6-16 188s autopkgtest [04:57:40]: build not needed 191s autopkgtest [04:57:43]: test assorted-tools: preparing testbed 193s Reading package lists... 193s Building dependency tree... 193s Reading state information... 194s Starting pkgProblemResolver with broken count: 0 194s Starting 2 pkgProblemResolver with broken count: 0 194s Done 195s The following NEW packages will be installed: 195s firebird-utils firebird4.0-common firebird4.0-common-doc 195s firebird4.0-examples firebird4.0-server-core firebird4.0-utils 195s libabsl20230802 libfbclient2 libre2-11 libtomcrypt1 libtommath1 195s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 195s Need to get 6878 kB of archives. 195s After this operation, 25.0 MB of additional disk space will be used. 195s Get:1 http://ftpmaster.internal/ubuntu questing/universe armhf firebird4.0-common-doc all 4.0.5.3140.ds6-16 [28.3 kB] 195s Get:2 http://ftpmaster.internal/ubuntu questing/universe armhf firebird4.0-common all 4.0.5.3140.ds6-16 [18.5 kB] 195s Get:3 http://ftpmaster.internal/ubuntu questing/universe armhf libtommath1 armhf 1.3.0-1 [45.8 kB] 195s Get:4 http://ftpmaster.internal/ubuntu questing/universe armhf libfbclient2 armhf 4.0.5.3140.ds6-16 [766 kB] 196s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf libabsl20230802 armhf 20230802.1-4.2 [472 kB] 197s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf libre2-11 armhf 20240501-3build1 [182 kB] 197s Get:7 http://ftpmaster.internal/ubuntu questing/universe armhf firebird4.0-utils armhf 4.0.5.3140.ds6-16 [1305 kB] 199s Get:8 http://ftpmaster.internal/ubuntu questing/universe armhf firebird-utils all 4.0.5.3140.ds6-16 [3714 B] 199s Get:9 http://ftpmaster.internal/ubuntu questing/universe armhf firebird4.0-examples all 4.0.5.3140.ds6-16 [387 kB] 199s Get:10 http://ftpmaster.internal/ubuntu questing/universe armhf libtomcrypt1 armhf 1.18.2+dfsg-7build1 [377 kB] 200s Get:11 http://ftpmaster.internal/ubuntu questing/universe armhf firebird4.0-server-core armhf 4.0.5.3140.ds6-16 [3293 kB] 204s Fetched 6878 kB in 9s (747 kB/s) 204s Selecting previously unselected package firebird4.0-common-doc. 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 ... 63953 files and directories currently installed.) 204s Preparing to unpack .../00-firebird4.0-common-doc_4.0.5.3140.ds6-16_all.deb ... 204s Unpacking firebird4.0-common-doc (4.0.5.3140.ds6-16) ... 204s Selecting previously unselected package firebird4.0-common. 204s Preparing to unpack .../01-firebird4.0-common_4.0.5.3140.ds6-16_all.deb ... 204s Unpacking firebird4.0-common (4.0.5.3140.ds6-16) ... 204s Selecting previously unselected package libtommath1:armhf. 204s Preparing to unpack .../02-libtommath1_1.3.0-1_armhf.deb ... 204s Unpacking libtommath1:armhf (1.3.0-1) ... 204s Selecting previously unselected package libfbclient2:armhf. 204s Preparing to unpack .../03-libfbclient2_4.0.5.3140.ds6-16_armhf.deb ... 204s Unpacking libfbclient2:armhf (4.0.5.3140.ds6-16) ... 204s Selecting previously unselected package libabsl20230802:armhf. 204s Preparing to unpack .../04-libabsl20230802_20230802.1-4.2_armhf.deb ... 204s Unpacking libabsl20230802:armhf (20230802.1-4.2) ... 205s Selecting previously unselected package libre2-11:armhf. 205s Preparing to unpack .../05-libre2-11_20240501-3build1_armhf.deb ... 205s Unpacking libre2-11:armhf (20240501-3build1) ... 205s Selecting previously unselected package firebird4.0-utils. 205s Preparing to unpack .../06-firebird4.0-utils_4.0.5.3140.ds6-16_armhf.deb ... 205s Unpacking firebird4.0-utils (4.0.5.3140.ds6-16) ... 205s Selecting previously unselected package firebird-utils. 205s Preparing to unpack .../07-firebird-utils_4.0.5.3140.ds6-16_all.deb ... 205s Unpacking firebird-utils (4.0.5.3140.ds6-16) ... 205s Selecting previously unselected package firebird4.0-examples. 205s Preparing to unpack .../08-firebird4.0-examples_4.0.5.3140.ds6-16_all.deb ... 205s Unpacking firebird4.0-examples (4.0.5.3140.ds6-16) ... 205s Selecting previously unselected package libtomcrypt1:armhf. 205s Preparing to unpack .../09-libtomcrypt1_1.18.2+dfsg-7build1_armhf.deb ... 205s Unpacking libtomcrypt1:armhf (1.18.2+dfsg-7build1) ... 205s Selecting previously unselected package firebird4.0-server-core:armhf. 205s Preparing to unpack .../10-firebird4.0-server-core_4.0.5.3140.ds6-16_armhf.deb ... 205s Unpacking firebird4.0-server-core:armhf (4.0.5.3140.ds6-16) ... 205s Setting up libtommath1:armhf (1.3.0-1) ... 205s Setting up firebird4.0-common-doc (4.0.5.3140.ds6-16) ... 205s Setting up firebird4.0-common (4.0.5.3140.ds6-16) ... 205s Configuring /etc/firebird/4.0/service-port.conf to use port 3050 205s Setting up libabsl20230802:armhf (20230802.1-4.2) ... 205s Setting up libtomcrypt1:armhf (1.18.2+dfsg-7build1) ... 205s Setting up firebird4.0-examples (4.0.5.3140.ds6-16) ... 205s Setting up libre2-11:armhf (20240501-3build1) ... 205s Setting up libfbclient2:armhf (4.0.5.3140.ds6-16) ... 205s Setting up firebird4.0-server-core:armhf (4.0.5.3140.ds6-16) ... 205s Setting up firebird-utils (4.0.5.3140.ds6-16) ... 205s Setting up firebird4.0-utils (4.0.5.3140.ds6-16) ... 205s update-alternatives: using /usr/share/firebird/4.0/man/man8/firebird.8.gz to provide /usr/share/man/man8/firebird.8.gz (firebird) in auto mode 205s Processing triggers for libc-bin (2.41-6ubuntu1) ... 205s Processing triggers for man-db (2.13.0-1) ... 217s autopkgtest [04:58:09]: test assorted-tools: [----------------------- 219s V: Creating employee.fdb via isql-fb -i 223s V: Backing up 223s V: Restoring the backup 224s V: Extracting definition of employee.fdb via isql-fb -a 224s V: Checking the size of employee.sql 224s -rw-rw-r-- 1 ubuntu ubuntu 21525 May 2 04:58 employee.sql 224s V: Running fbstat on employee.fdb 224s 224s Database "/tmp/autopkgtest.NQYz4V/assorted-tools-artifacts/employee.fdb" 224s Gstat execution time Fri May 2 04:58:16 2025 224s 224s Database header page information: 224s Flags 0 224s Generation 162 224s System Change Number 0 224s Page size 8192 224s ODS version 13.0 224s Oldest transaction 155 224s Oldest active 156 224s Oldest snapshot 156 224s Next transaction 156 224s Sequence number 0 224s Next attachment ID 9 224s Implementation HW=ARM little-endian OS=Linux CC=gcc 224s Shadow count 0 224s Page buffers 0 224s Next header page 0 224s Database dialect 3 224s Creation date May 2, 2025 4:58:11 224s Attributes force write 224s 224s Variable header data: 224s Database GUID: {CBA996C5-87A7-49B0-AAC0-979E32EE8F7C} 224s *END* 224s 224s 224s Database file sequence: 224s File /tmp/autopkgtest.NQYz4V/assorted-tools-artifacts/employee.fdb is the only file 224s 224s Analyzing database pages ... 224s COUNTRY (128) 224s Primary pointer page: 222, Index root page: 223 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 8% 224s Primary pages: 1, secondary pages: 0, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY1 (0) 224s Root page: 226, depth: 1, leaf buckets: 1, nodes: 16 224s Average node length: 10.44, total dup: 0, max dup: 0 224s Average key length: 8.62, compression ratio: 0.80 224s Average prefix length: 0.44, average data length: 6.44 224s Clustering factor: 1, ratio: 0.06 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s CUSTOMER (137) 224s Primary pointer page: 276, Index root page: 277 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 26% 224s Primary pages: 1, secondary pages: 0, swept pages: 1 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 1 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index CUSTNAMEX (2) 224s Root page: 290, depth: 1, leaf buckets: 1, nodes: 15 224s Average node length: 19.87, total dup: 0, max dup: 0 224s Average key length: 18.27, compression ratio: 0.90 224s Average prefix length: 0.60, average data length: 15.87 224s Clustering factor: 1, ratio: 0.07 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index CUSTREGION (3) 224s Root page: 291, depth: 1, leaf buckets: 1, nodes: 15 224s Average node length: 21.27, total dup: 0, max dup: 0 224s Average key length: 20.20, compression ratio: 0.97 224s Average prefix length: 2.33, average data length: 17.27 224s Clustering factor: 1, ratio: 0.07 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN23 (1) 224s Root page: 279, depth: 1, leaf buckets: 1, nodes: 15 224s Average node length: 8.60, total dup: 4, max dup: 4 224s Average key length: 6.93, compression ratio: 0.83 224s Average prefix length: 0.87, average data length: 4.87 224s Clustering factor: 1, ratio: 0.07 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY22 (0) 224s Root page: 278, depth: 1, leaf buckets: 1, nodes: 15 224s Average node length: 4.20, total dup: 0, max dup: 0 224s Average key length: 3.13, compression ratio: 0.96 224s Average prefix length: 1.87, average data length: 1.13 224s Clustering factor: 1, ratio: 0.07 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s DEPARTMENT (130) 224s Primary pointer page: 236, Index root page: 237 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 24% 224s Primary pages: 1, secondary pages: 0, swept pages: 1 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 1 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index BUDGETX (3) 224s Root page: 298, depth: 1, leaf buckets: 1, nodes: 21 224s Average node length: 9.05, total dup: 7, max dup: 3 224s Average key length: 8.00, compression ratio: 1.12 224s Average prefix length: 3.62, average data length: 5.38 224s Clustering factor: 1, ratio: 0.05 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$4 (0) 224s Root page: 238, depth: 1, leaf buckets: 1, nodes: 21 224s Average node length: 17.95, total dup: 0, max dup: 0 224s Average key length: 16.57, compression ratio: 1.16 224s Average prefix length: 5.29, average data length: 13.95 224s Clustering factor: 1, ratio: 0.05 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN10 (4) 224s Root page: 250, depth: 1, leaf buckets: 1, nodes: 21 224s Average node length: 4.29, total dup: 3, max dup: 3 224s Average key length: 3.24, compression ratio: 0.60 224s Average prefix length: 0.81, average data length: 1.14 224s Clustering factor: 1, ratio: 0.05 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN6 (2) 224s Root page: 240, depth: 1, leaf buckets: 1, nodes: 21 224s Average node length: 4.10, total dup: 13, max dup: 4 224s Average key length: 2.95, compression ratio: 0.97 224s Average prefix length: 2.05, average data length: 0.81 224s Clustering factor: 1, ratio: 0.05 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY5 (1) 224s Root page: 239, depth: 1, leaf buckets: 1, nodes: 21 224s Average node length: 5.24, total dup: 0, max dup: 0 224s Average key length: 4.05, compression ratio: 0.74 224s Average prefix length: 1.29, average data length: 1.71 224s Clustering factor: 1, ratio: 0.05 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s EMPLOYEE (131) 224s Primary pointer page: 243, Index root page: 244 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 44% 224s Primary pages: 1, secondary pages: 0, swept pages: 1 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 0 224s 40 - 59% = 1 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index NAMEX (3) 224s Root page: 299, depth: 1, leaf buckets: 1, nodes: 42 224s Average node length: 19.52, total dup: 0, max dup: 0 224s Average key length: 18.50, compression ratio: 0.96 224s Average prefix length: 2.17, average data length: 15.52 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN8 (1) 224s Root page: 246, depth: 1, leaf buckets: 1, nodes: 42 224s Average node length: 4.07, total dup: 23, max dup: 4 224s Average key length: 2.98, compression ratio: 1.01 224s Average prefix length: 2.19, average data length: 0.81 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN9 (2) 224s Root page: 247, depth: 1, leaf buckets: 1, nodes: 42 224s Average node length: 10.43, total dup: 15, max dup: 4 224s Average key length: 9.40, compression ratio: 1.68 224s Average prefix length: 9.05, average data length: 6.79 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY7 (0) 224s Root page: 245, depth: 1, leaf buckets: 1, nodes: 42 224s Average node length: 4.62, total dup: 0, max dup: 0 224s Average key length: 3.60, compression ratio: 0.69 224s Average prefix length: 1.17, average data length: 1.31 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s EMPLOYEE_PROJECT (134) 224s Primary pointer page: 258, Index root page: 259 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 10% 224s Primary pages: 1, secondary pages: 0, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN15 (1) 224s Root page: 261, depth: 1, leaf buckets: 1, nodes: 28 224s Average node length: 4.29, total dup: 6, max dup: 2 224s Average key length: 3.25, compression ratio: 0.74 224s Average prefix length: 1.36, average data length: 1.04 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN16 (2) 224s Root page: 262, depth: 1, leaf buckets: 1, nodes: 28 224s Average node length: 4.04, total dup: 23, max dup: 9 224s Average key length: 2.89, compression ratio: 1.73 224s Average prefix length: 4.14, average data length: 0.86 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY14 (0) 224s Root page: 260, depth: 1, leaf buckets: 1, nodes: 28 224s Average node length: 13.11, total dup: 0, max dup: 0 224s Average key length: 12.07, compression ratio: 0.99 224s Average prefix length: 2.89, average data length: 9.11 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s JOB (129) 224s Primary pointer page: 229, Index root page: 230 224s Pointer pages: 1, data page slots: 2 224s Data pages: 2, average fill: 43% 224s Primary pages: 1, secondary pages: 1, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 1 224s 40 - 59% = 1 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index MAXSALX (2) 224s Root page: 300, depth: 1, leaf buckets: 1, nodes: 31 224s Average node length: 14.74, total dup: 5, max dup: 1 224s Average key length: 13.71, compression ratio: 1.37 224s Average prefix length: 7.87, average data length: 10.90 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index MINSALX (3) 224s Root page: 301, depth: 1, leaf buckets: 1, nodes: 31 224s Average node length: 14.06, total dup: 7, max dup: 2 224s Average key length: 13.03, compression ratio: 1.44 224s Average prefix length: 8.48, average data length: 10.29 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN3 (1) 224s Root page: 232, depth: 1, leaf buckets: 1, nodes: 31 224s Average node length: 4.61, total dup: 24, max dup: 20 224s Average key length: 3.39, compression ratio: 1.23 224s Average prefix length: 2.77, average data length: 1.39 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY2 (0) 224s Root page: 231, depth: 1, leaf buckets: 1, nodes: 31 224s Average node length: 14.45, total dup: 0, max dup: 0 224s Average key length: 13.42, compression ratio: 1.24 224s Average prefix length: 6.19, average data length: 10.45 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s PROJECT (133) 224s Primary pointer page: 251, Index root page: 252 224s Pointer pages: 1, data page slots: 2 224s Data pages: 2, average fill: 7% 224s Primary pages: 1, secondary pages: 1, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 2 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index PRODTYPEX (3) 224s Root page: 302, depth: 1, leaf buckets: 1, nodes: 6 224s Average node length: 26.50, total dup: 0, max dup: 0 224s Average key length: 25.33, compression ratio: 1.05 224s Average prefix length: 4.17, average data length: 22.50 224s Clustering factor: 1, ratio: 0.17 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$11 (0) 224s Root page: 253, depth: 1, leaf buckets: 1, nodes: 6 224s Average node length: 17.33, total dup: 0, max dup: 0 224s Average key length: 15.50, compression ratio: 0.88 224s Average prefix length: 0.33, average data length: 13.33 224s Clustering factor: 1, ratio: 0.17 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN13 (2) 224s Root page: 255, depth: 1, leaf buckets: 1, nodes: 6 224s Average node length: 4.67, total dup: 0, max dup: 0 224s Average key length: 3.50, compression ratio: 0.57 224s Average prefix length: 0.67, average data length: 1.33 224s Clustering factor: 1, ratio: 0.17 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY12 (1) 224s Root page: 254, depth: 1, leaf buckets: 1, nodes: 6 224s Average node length: 8.83, total dup: 0, max dup: 0 224s Average key length: 7.00, compression ratio: 0.71 224s Average prefix length: 0.17, average data length: 4.83 224s Clustering factor: 1, ratio: 0.17 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s PROJ_DEPT_BUDGET (135) 224s Primary pointer page: 265, Index root page: 266 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 12% 224s Primary pages: 1, secondary pages: 0, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN18 (1) 224s Root page: 268, depth: 1, leaf buckets: 1, nodes: 24 224s Average node length: 3.92, total dup: 15, max dup: 5 224s Average key length: 2.79, compression ratio: 1.07 224s Average prefix length: 2.29, average data length: 0.71 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN19 (2) 224s Root page: 269, depth: 1, leaf buckets: 1, nodes: 24 224s Average node length: 4.21, total dup: 19, max dup: 8 224s Average key length: 3.04, compression ratio: 1.64 224s Average prefix length: 4.00, average data length: 1.00 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY17 (0) 224s Root page: 267, depth: 1, leaf buckets: 1, nodes: 24 224s Average node length: 10.71, total dup: 0, max dup: 0 224s Average key length: 9.67, compression ratio: 1.97 224s Average prefix length: 12.17, average data length: 6.83 224s Clustering factor: 1, ratio: 0.04 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s SALARY_HISTORY (136) 224s Primary pointer page: 270, Index root page: 271 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 30% 224s Primary pages: 1, secondary pages: 0, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 1 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index CHANGEX (2) 224s Root page: 303, depth: 1, leaf buckets: 1, nodes: 49 224s Average node length: 3.37, total dup: 46, max dup: 21 224s Average key length: 2.35, compression ratio: 2.98 224s Average prefix length: 6.69, average data length: 0.31 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN21 (1) 224s Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 224s Average node length: 4.12, total dup: 16, max dup: 2 224s Average key length: 3.10, compression ratio: 0.75 224s Average prefix length: 1.43, average data length: 0.90 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY20 (0) 224s Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 224s Average node length: 22.29, total dup: 0, max dup: 0 224s Average key length: 21.27, compression ratio: 1.06 224s Average prefix length: 4.31, average data length: 18.29 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index UPDATERX (3) 224s Root page: 304, depth: 1, leaf buckets: 1, nodes: 49 224s Average node length: 3.35, total dup: 46, max dup: 28 224s Average key length: 2.29, compression ratio: 2.48 224s Average prefix length: 5.39, average data length: 0.29 224s Clustering factor: 1, ratio: 0.02 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s SALES (138) 224s Primary pointer page: 283, Index root page: 284 224s Pointer pages: 1, data page slots: 1 224s Data pages: 1, average fill: 35% 224s Primary pages: 1, secondary pages: 0, swept pages: 0 224s Empty pages: 0, full pages: 0 224s Fill distribution: 224s 0 - 19% = 0 224s 20 - 39% = 1 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index NEEDX (3) 224s Root page: 305, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 5.97, total dup: 11, max dup: 6 224s Average key length: 4.94, compression ratio: 1.10 224s Average prefix length: 2.88, average data length: 2.55 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index QTYX (4) 224s Root page: 306, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 5.06, total dup: 11, max dup: 3 224s Average key length: 4.03, compression ratio: 3.23 224s Average prefix length: 11.18, average data length: 1.85 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN25 (1) 224s Root page: 286, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 3.55, total dup: 18, max dup: 4 224s Average key length: 2.52, compression ratio: 1.19 224s Average prefix length: 2.48, average data length: 0.52 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$FOREIGN26 (2) 224s Root page: 287, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 3.67, total dup: 25, max dup: 7 224s Average key length: 2.64, compression ratio: 1.01 224s Average prefix length: 2.21, average data length: 0.45 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index RDB$PRIMARY24 (0) 224s Root page: 285, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 8.45, total dup: 0, max dup: 0 224s Average key length: 7.42, compression ratio: 1.08 224s Average prefix length: 3.52, average data length: 4.48 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Index SALESTATX (5) 224s Root page: 307, depth: 1, leaf buckets: 1, nodes: 33 224s Average node length: 4.06, total dup: 27, max dup: 14 224s Average key length: 3.03, compression ratio: 3.56 224s Average prefix length: 9.82, average data length: 0.97 224s Clustering factor: 1, ratio: 0.03 224s Fill distribution: 224s 0 - 19% = 1 224s 20 - 39% = 0 224s 40 - 59% = 0 224s 60 - 79% = 0 224s 80 - 99% = 0 224s 224s Gstat completion time Fri May 2 04:58:16 2025 224s 224s V: Running gfix -v 224s V: Some big math 224s create table tbl1(fld1 int128); 224s insert into tbl1 values(12345); 224s select * from tbl1; 224s 224s FLD1 224s ============================================= 224s 12345 224s 225s autopkgtest [04:58:17]: test assorted-tools: -----------------------] 229s assorted-tools PASS 229s autopkgtest [04:58:21]: test assorted-tools: - - - - - - - - - - results - - - - - - - - - - 233s autopkgtest [04:58:25]: @@@@@@@@@@@@@@@@@@@@ summary 233s assorted-tools PASS