0s autopkgtest [03:06:13]: starting date and time: 2025-05-02 03:06:13+0000 0s autopkgtest [03:06:13]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [03:06:13]: host juju-7f2275-prod-proposed-migration-environment-21; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.mccbkijj/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --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 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-arm64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-21@sto01-arm64-5.secgroup --name adt-questing-arm64-firebird4.0-20250502-030613-juju-7f2275-prod-proposed-migration-environment-21-03de4f80-236b-4ff2-a746-f47eaf2a6e69 --image adt/ubuntu-questing-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-21 --net-id=net_prod-autopkgtest-workers-arm64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 53s autopkgtest [03:07:06]: testbed dpkg architecture: arm64 53s autopkgtest [03:07:06]: testbed apt version: 3.0.0 53s autopkgtest [03:07:06]: @@@@@@@@@@@@@@@@@@@@ test bed setup 53s autopkgtest [03:07:06]: testbed release detected to be: None 54s autopkgtest [03:07:07]: updating testbed package index (apt update) 54s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 54s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 54s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 54s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 54s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2281 kB] 54s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [190 kB] 54s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 55s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 Packages [227 kB] 55s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe arm64 Packages [1341 kB] 55s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse arm64 Packages [16.5 kB] 55s Fetched 4223 kB in 1s (5921 kB/s) 56s Reading package lists... 56s autopkgtest [03:07:09]: upgrading testbed (apt dist-upgrade and autopurge) 56s Reading package lists... 57s Building dependency tree... 57s Reading state information... 57s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 57s Starting 2 pkgProblemResolver with broken count: 0 57s Done 58s Entering ResolveByKeep 58s 58s Calculating upgrade... 59s The following packages will be upgraded: 59s libperl5.40 perl perl-base perl-modules-5.40 59s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 59s Need to get 10.0 MB of archives. 59s After this operation, 0 B of additional disk space will be used. 59s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 libperl5.40 arm64 5.40.1-3 [4780 kB] 63s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl arm64 5.40.1-3 [262 kB] 63s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl-base arm64 5.40.1-3 [1786 kB] 64s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main arm64 perl-modules-5.40 all 5.40.1-3 [3217 kB] 66s Fetched 10.0 MB in 7s (1396 kB/s) 67s (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 ... 85224 files and directories currently installed.) 67s Preparing to unpack .../libperl5.40_5.40.1-3_arm64.deb ... 67s Unpacking libperl5.40:arm64 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 67s Preparing to unpack .../perl_5.40.1-3_arm64.deb ... 67s Unpacking perl (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 67s Preparing to unpack .../perl-base_5.40.1-3_arm64.deb ... 67s Unpacking perl-base (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 67s Setting up perl-base (5.40.1-3) ... 67s (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 ... 85224 files and directories currently installed.) 67s Preparing to unpack .../perl-modules-5.40_5.40.1-3_all.deb ... 67s Unpacking perl-modules-5.40 (5.40.1-3) over (5.40.1-2ubuntu0.1) ... 67s Setting up perl-modules-5.40 (5.40.1-3) ... 67s Setting up libperl5.40:arm64 (5.40.1-3) ... 67s Setting up perl (5.40.1-3) ... 67s Processing triggers for man-db (2.13.0-1) ... 68s Processing triggers for libc-bin (2.41-6ubuntu1) ... 68s Reading package lists... 68s Building dependency tree... 68s Reading state information... 69s Starting pkgProblemResolver with broken count: 0 69s Starting 2 pkgProblemResolver with broken count: 0 69s Done 69s Solving dependencies... 70s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 72s autopkgtest [03:07:25]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 14:37:51 UTC 2025 72s autopkgtest [03:07:25]: @@@@@@@@@@@@@@@@@@@@ apt-source firebird4.0 78s Get:1 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (dsc) [2860 B] 78s Get:2 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (tar) [3965 kB] 78s Get:3 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (diff) [101 kB] 78s gpgv: Signature made Mon Feb 17 08:03:03 2025 UTC 78s gpgv: using RSA key AEA0C44ECB056E93630D9D33DBBE9D4D99D2A004 78s gpgv: Can't check signature: No public key 78s dpkg-source: warning: cannot verify inline signature for ./firebird4.0_4.0.5.3140.ds6-16.dsc: no acceptable signature found 79s autopkgtest [03:07:32]: testing package firebird4.0 version 4.0.5.3140.ds6-16 80s autopkgtest [03:07:33]: build not needed 83s autopkgtest [03:07:36]: test assorted-tools: preparing testbed 83s Reading package lists... 83s Building dependency tree... 83s Reading state information... 83s Starting pkgProblemResolver with broken count: 0 83s Starting 2 pkgProblemResolver with broken count: 0 83s Done 84s The following NEW packages will be installed: 84s firebird-utils firebird4.0-common firebird4.0-common-doc 84s firebird4.0-examples firebird4.0-server-core firebird4.0-utils 84s libabsl20230802 libfbclient2 libre2-11 libtomcrypt1 libtommath1 84s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 84s Need to get 7467 kB of archives. 84s After this operation, 35.0 MB of additional disk space will be used. 84s Get:1 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird4.0-common-doc all 4.0.5.3140.ds6-16 [28.3 kB] 84s Get:2 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird4.0-common all 4.0.5.3140.ds6-16 [18.5 kB] 84s Get:3 http://ftpmaster.internal/ubuntu questing/universe arm64 libtommath1 arm64 1.3.0-1 [59.1 kB] 84s Get:4 http://ftpmaster.internal/ubuntu questing/universe arm64 libfbclient2 arm64 4.0.5.3140.ds6-16 [857 kB] 84s Get:5 http://ftpmaster.internal/ubuntu questing/main arm64 libabsl20230802 arm64 20230802.1-4.2 [491 kB] 84s Get:6 http://ftpmaster.internal/ubuntu questing/main arm64 libre2-11 arm64 20240501-3build1 [160 kB] 84s Get:7 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird4.0-utils arm64 4.0.5.3140.ds6-16 [1436 kB] 85s Get:8 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird-utils all 4.0.5.3140.ds6-16 [3714 B] 85s Get:9 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird4.0-examples all 4.0.5.3140.ds6-16 [387 kB] 85s Get:10 http://ftpmaster.internal/ubuntu questing/universe arm64 libtomcrypt1 arm64 1.18.2+dfsg-7build1 [407 kB] 85s Get:11 http://ftpmaster.internal/ubuntu questing/universe arm64 firebird4.0-server-core arm64 4.0.5.3140.ds6-16 [3620 kB] 85s Fetched 7467 kB in 1s (10.7 MB/s) 85s Selecting previously unselected package firebird4.0-common-doc. 85s (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 ... 85224 files and directories currently installed.) 85s Preparing to unpack .../00-firebird4.0-common-doc_4.0.5.3140.ds6-16_all.deb ... 85s Unpacking firebird4.0-common-doc (4.0.5.3140.ds6-16) ... 85s Selecting previously unselected package firebird4.0-common. 85s Preparing to unpack .../01-firebird4.0-common_4.0.5.3140.ds6-16_all.deb ... 85s Unpacking firebird4.0-common (4.0.5.3140.ds6-16) ... 85s Selecting previously unselected package libtommath1:arm64. 85s Preparing to unpack .../02-libtommath1_1.3.0-1_arm64.deb ... 85s Unpacking libtommath1:arm64 (1.3.0-1) ... 85s Selecting previously unselected package libfbclient2:arm64. 85s Preparing to unpack .../03-libfbclient2_4.0.5.3140.ds6-16_arm64.deb ... 85s Unpacking libfbclient2:arm64 (4.0.5.3140.ds6-16) ... 85s Selecting previously unselected package libabsl20230802:arm64. 85s Preparing to unpack .../04-libabsl20230802_20230802.1-4.2_arm64.deb ... 85s Unpacking libabsl20230802:arm64 (20230802.1-4.2) ... 85s Selecting previously unselected package libre2-11:arm64. 85s Preparing to unpack .../05-libre2-11_20240501-3build1_arm64.deb ... 85s Unpacking libre2-11:arm64 (20240501-3build1) ... 85s Selecting previously unselected package firebird4.0-utils. 85s Preparing to unpack .../06-firebird4.0-utils_4.0.5.3140.ds6-16_arm64.deb ... 85s Unpacking firebird4.0-utils (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package firebird-utils. 86s Preparing to unpack .../07-firebird-utils_4.0.5.3140.ds6-16_all.deb ... 86s Unpacking firebird-utils (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package firebird4.0-examples. 86s Preparing to unpack .../08-firebird4.0-examples_4.0.5.3140.ds6-16_all.deb ... 86s Unpacking firebird4.0-examples (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package libtomcrypt1:arm64. 86s Preparing to unpack .../09-libtomcrypt1_1.18.2+dfsg-7build1_arm64.deb ... 86s Unpacking libtomcrypt1:arm64 (1.18.2+dfsg-7build1) ... 86s Selecting previously unselected package firebird4.0-server-core:arm64. 86s Preparing to unpack .../10-firebird4.0-server-core_4.0.5.3140.ds6-16_arm64.deb ... 86s Unpacking firebird4.0-server-core:arm64 (4.0.5.3140.ds6-16) ... 86s Setting up libtommath1:arm64 (1.3.0-1) ... 86s Setting up firebird4.0-common-doc (4.0.5.3140.ds6-16) ... 86s Setting up firebird4.0-common (4.0.5.3140.ds6-16) ... 86s Configuring /etc/firebird/4.0/service-port.conf to use port 3050 86s Setting up libabsl20230802:arm64 (20230802.1-4.2) ... 86s Setting up libtomcrypt1:arm64 (1.18.2+dfsg-7build1) ... 86s Setting up firebird4.0-examples (4.0.5.3140.ds6-16) ... 86s Setting up libre2-11:arm64 (20240501-3build1) ... 86s Setting up libfbclient2:arm64 (4.0.5.3140.ds6-16) ... 86s Setting up firebird4.0-server-core:arm64 (4.0.5.3140.ds6-16) ... 86s Setting up firebird-utils (4.0.5.3140.ds6-16) ... 86s Setting up firebird4.0-utils (4.0.5.3140.ds6-16) ... 86s 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 86s Processing triggers for libc-bin (2.41-6ubuntu1) ... 86s Processing triggers for man-db (2.13.0-1) ... 87s autopkgtest [03:07:40]: test assorted-tools: [----------------------- 88s V: Creating employee.fdb via isql-fb -i 89s V: Backing up 89s V: Restoring the backup 89s V: Extracting definition of employee.fdb via isql-fb -a 90s V: Checking the size of employee.sql 90s -rw-rw-r-- 1 ubuntu ubuntu 21525 May 2 03:07 employee.sql 90s V: Running fbstat on employee.fdb 90s 90s Database "/tmp/autopkgtest.tjRIUm/assorted-tools-artifacts/employee.fdb" 90s Gstat execution time Fri May 2 03:07:42 2025 90s 90s Database header page information: 90s Flags 0 90s Generation 162 90s System Change Number 0 90s Page size 8192 90s ODS version 13.0 90s Oldest transaction 155 90s Oldest active 156 90s Oldest snapshot 156 90s Next transaction 156 90s Sequence number 0 90s Next attachment ID 9 90s Implementation HW=ARM64 little-endian OS=Linux CC=gcc 90s Shadow count 0 90s Page buffers 0 90s Next header page 0 90s Database dialect 3 90s Creation date May 2, 2025 3:07:40 90s Attributes force write 90s 90s Variable header data: 90s Database GUID: {40507FA7-6A51-4EAA-8C9C-0AED201D44C6} 90s *END* 90s 90s 90s Database file sequence: 90s File /tmp/autopkgtest.tjRIUm/assorted-tools-artifacts/employee.fdb is the only file 90s 90s Analyzing database pages ... 90s COUNTRY (128) 90s Primary pointer page: 222, Index root page: 223 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 8% 90s Primary pages: 1, secondary pages: 0, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY1 (0) 90s Root page: 226, depth: 1, leaf buckets: 1, nodes: 16 90s Average node length: 10.44, total dup: 0, max dup: 0 90s Average key length: 8.62, compression ratio: 0.80 90s Average prefix length: 0.44, average data length: 6.44 90s Clustering factor: 1, ratio: 0.06 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s CUSTOMER (137) 90s Primary pointer page: 276, Index root page: 277 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 26% 90s Primary pages: 1, secondary pages: 0, swept pages: 1 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 1 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index CUSTNAMEX (2) 90s Root page: 290, depth: 1, leaf buckets: 1, nodes: 15 90s Average node length: 19.87, total dup: 0, max dup: 0 90s Average key length: 18.27, compression ratio: 0.90 90s Average prefix length: 0.60, average data length: 15.87 90s Clustering factor: 1, ratio: 0.07 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index CUSTREGION (3) 90s Root page: 291, depth: 1, leaf buckets: 1, nodes: 15 90s Average node length: 21.27, total dup: 0, max dup: 0 90s Average key length: 20.20, compression ratio: 0.97 90s Average prefix length: 2.33, average data length: 17.27 90s Clustering factor: 1, ratio: 0.07 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN23 (1) 90s Root page: 279, depth: 1, leaf buckets: 1, nodes: 15 90s Average node length: 8.60, total dup: 4, max dup: 4 90s Average key length: 6.93, compression ratio: 0.83 90s Average prefix length: 0.87, average data length: 4.87 90s Clustering factor: 1, ratio: 0.07 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY22 (0) 90s Root page: 278, depth: 1, leaf buckets: 1, nodes: 15 90s Average node length: 4.20, total dup: 0, max dup: 0 90s Average key length: 3.13, compression ratio: 0.96 90s Average prefix length: 1.87, average data length: 1.13 90s Clustering factor: 1, ratio: 0.07 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s DEPARTMENT (130) 90s Primary pointer page: 236, Index root page: 237 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 24% 90s Primary pages: 1, secondary pages: 0, swept pages: 1 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 1 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index BUDGETX (3) 90s Root page: 298, depth: 1, leaf buckets: 1, nodes: 21 90s Average node length: 9.05, total dup: 7, max dup: 3 90s Average key length: 8.00, compression ratio: 1.12 90s Average prefix length: 3.62, average data length: 5.38 90s Clustering factor: 1, ratio: 0.05 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$4 (0) 90s Root page: 238, depth: 1, leaf buckets: 1, nodes: 21 90s Average node length: 17.95, total dup: 0, max dup: 0 90s Average key length: 16.57, compression ratio: 1.16 90s Average prefix length: 5.29, average data length: 13.95 90s Clustering factor: 1, ratio: 0.05 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN10 (4) 90s Root page: 250, depth: 1, leaf buckets: 1, nodes: 21 90s Average node length: 4.29, total dup: 3, max dup: 3 90s Average key length: 3.24, compression ratio: 0.60 90s Average prefix length: 0.81, average data length: 1.14 90s Clustering factor: 1, ratio: 0.05 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN6 (2) 90s Root page: 240, depth: 1, leaf buckets: 1, nodes: 21 90s Average node length: 4.10, total dup: 13, max dup: 4 90s Average key length: 2.95, compression ratio: 0.97 90s Average prefix length: 2.05, average data length: 0.81 90s Clustering factor: 1, ratio: 0.05 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY5 (1) 90s Root page: 239, depth: 1, leaf buckets: 1, nodes: 21 90s Average node length: 5.24, total dup: 0, max dup: 0 90s Average key length: 4.05, compression ratio: 0.74 90s Average prefix length: 1.29, average data length: 1.71 90s Clustering factor: 1, ratio: 0.05 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s EMPLOYEE (131) 90s Primary pointer page: 243, Index root page: 244 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 44% 90s Primary pages: 1, secondary pages: 0, swept pages: 1 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 0 90s 40 - 59% = 1 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index NAMEX (3) 90s Root page: 299, depth: 1, leaf buckets: 1, nodes: 42 90s Average node length: 19.52, total dup: 0, max dup: 0 90s Average key length: 18.50, compression ratio: 0.96 90s Average prefix length: 2.17, average data length: 15.52 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN8 (1) 90s Root page: 246, depth: 1, leaf buckets: 1, nodes: 42 90s Average node length: 4.07, total dup: 23, max dup: 4 90s Average key length: 2.98, compression ratio: 1.01 90s Average prefix length: 2.19, average data length: 0.81 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN9 (2) 90s Root page: 247, depth: 1, leaf buckets: 1, nodes: 42 90s Average node length: 10.43, total dup: 15, max dup: 4 90s Average key length: 9.40, compression ratio: 1.68 90s Average prefix length: 9.05, average data length: 6.79 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY7 (0) 90s Root page: 245, depth: 1, leaf buckets: 1, nodes: 42 90s Average node length: 4.62, total dup: 0, max dup: 0 90s Average key length: 3.60, compression ratio: 0.69 90s Average prefix length: 1.17, average data length: 1.31 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s EMPLOYEE_PROJECT (134) 90s Primary pointer page: 258, Index root page: 259 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 10% 90s Primary pages: 1, secondary pages: 0, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN15 (1) 90s Root page: 261, depth: 1, leaf buckets: 1, nodes: 28 90s Average node length: 4.29, total dup: 6, max dup: 2 90s Average key length: 3.25, compression ratio: 0.74 90s Average prefix length: 1.36, average data length: 1.04 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN16 (2) 90s Root page: 262, depth: 1, leaf buckets: 1, nodes: 28 90s Average node length: 4.04, total dup: 23, max dup: 9 90s Average key length: 2.89, compression ratio: 1.73 90s Average prefix length: 4.14, average data length: 0.86 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY14 (0) 90s Root page: 260, depth: 1, leaf buckets: 1, nodes: 28 90s Average node length: 13.11, total dup: 0, max dup: 0 90s Average key length: 12.07, compression ratio: 0.99 90s Average prefix length: 2.89, average data length: 9.11 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s JOB (129) 90s Primary pointer page: 229, Index root page: 230 90s Pointer pages: 1, data page slots: 2 90s Data pages: 2, average fill: 43% 90s Primary pages: 1, secondary pages: 1, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 1 90s 40 - 59% = 1 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index MAXSALX (2) 90s Root page: 300, depth: 1, leaf buckets: 1, nodes: 31 90s Average node length: 14.74, total dup: 5, max dup: 1 90s Average key length: 13.71, compression ratio: 1.37 90s Average prefix length: 7.87, average data length: 10.90 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index MINSALX (3) 90s Root page: 301, depth: 1, leaf buckets: 1, nodes: 31 90s Average node length: 14.06, total dup: 7, max dup: 2 90s Average key length: 13.03, compression ratio: 1.44 90s Average prefix length: 8.48, average data length: 10.29 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN3 (1) 90s Root page: 232, depth: 1, leaf buckets: 1, nodes: 31 90s Average node length: 4.61, total dup: 24, max dup: 20 90s Average key length: 3.39, compression ratio: 1.23 90s Average prefix length: 2.77, average data length: 1.39 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY2 (0) 90s Root page: 231, depth: 1, leaf buckets: 1, nodes: 31 90s Average node length: 14.45, total dup: 0, max dup: 0 90s Average key length: 13.42, compression ratio: 1.24 90s Average prefix length: 6.19, average data length: 10.45 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s PROJECT (133) 90s Primary pointer page: 251, Index root page: 252 90s Pointer pages: 1, data page slots: 2 90s Data pages: 2, average fill: 7% 90s Primary pages: 1, secondary pages: 1, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 2 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index PRODTYPEX (3) 90s Root page: 302, depth: 1, leaf buckets: 1, nodes: 6 90s Average node length: 26.50, total dup: 0, max dup: 0 90s Average key length: 25.33, compression ratio: 1.05 90s Average prefix length: 4.17, average data length: 22.50 90s Clustering factor: 1, ratio: 0.17 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$11 (0) 90s Root page: 253, depth: 1, leaf buckets: 1, nodes: 6 90s Average node length: 17.33, total dup: 0, max dup: 0 90s Average key length: 15.50, compression ratio: 0.88 90s Average prefix length: 0.33, average data length: 13.33 90s Clustering factor: 1, ratio: 0.17 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN13 (2) 90s Root page: 255, depth: 1, leaf buckets: 1, nodes: 6 90s Average node length: 4.67, total dup: 0, max dup: 0 90s Average key length: 3.50, compression ratio: 0.57 90s Average prefix length: 0.67, average data length: 1.33 90s Clustering factor: 1, ratio: 0.17 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY12 (1) 90s Root page: 254, depth: 1, leaf buckets: 1, nodes: 6 90s Average node length: 8.83, total dup: 0, max dup: 0 90s Average key length: 7.00, compression ratio: 0.71 90s Average prefix length: 0.17, average data length: 4.83 90s Clustering factor: 1, ratio: 0.17 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s PROJ_DEPT_BUDGET (135) 90s Primary pointer page: 265, Index root page: 266 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 12% 90s Primary pages: 1, secondary pages: 0, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN18 (1) 90s Root page: 268, depth: 1, leaf buckets: 1, nodes: 24 90s Average node length: 3.92, total dup: 15, max dup: 5 90s Average key length: 2.79, compression ratio: 1.07 90s Average prefix length: 2.29, average data length: 0.71 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN19 (2) 90s Root page: 269, depth: 1, leaf buckets: 1, nodes: 24 90s Average node length: 4.21, total dup: 19, max dup: 8 90s Average key length: 3.04, compression ratio: 1.64 90s Average prefix length: 4.00, average data length: 1.00 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY17 (0) 90s Root page: 267, depth: 1, leaf buckets: 1, nodes: 24 90s Average node length: 10.71, total dup: 0, max dup: 0 90s Average key length: 9.67, compression ratio: 1.97 90s Average prefix length: 12.17, average data length: 6.83 90s Clustering factor: 1, ratio: 0.04 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s SALARY_HISTORY (136) 90s Primary pointer page: 270, Index root page: 271 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 30% 90s Primary pages: 1, secondary pages: 0, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 1 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index CHANGEX (2) 90s Root page: 303, depth: 1, leaf buckets: 1, nodes: 49 90s Average node length: 3.37, total dup: 46, max dup: 21 90s Average key length: 2.35, compression ratio: 2.98 90s Average prefix length: 6.69, average data length: 0.31 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN21 (1) 90s Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 90s Average node length: 4.12, total dup: 16, max dup: 2 90s Average key length: 3.10, compression ratio: 0.75 90s Average prefix length: 1.43, average data length: 0.90 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY20 (0) 90s Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 90s Average node length: 22.29, total dup: 0, max dup: 0 90s Average key length: 21.27, compression ratio: 1.06 90s Average prefix length: 4.31, average data length: 18.29 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index UPDATERX (3) 90s Root page: 304, depth: 1, leaf buckets: 1, nodes: 49 90s Average node length: 3.35, total dup: 46, max dup: 28 90s Average key length: 2.29, compression ratio: 2.48 90s Average prefix length: 5.39, average data length: 0.29 90s Clustering factor: 1, ratio: 0.02 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s SALES (138) 90s Primary pointer page: 283, Index root page: 284 90s Pointer pages: 1, data page slots: 1 90s Data pages: 1, average fill: 35% 90s Primary pages: 1, secondary pages: 0, swept pages: 0 90s Empty pages: 0, full pages: 0 90s Fill distribution: 90s 0 - 19% = 0 90s 20 - 39% = 1 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index NEEDX (3) 90s Root page: 305, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 5.97, total dup: 11, max dup: 6 90s Average key length: 4.94, compression ratio: 1.10 90s Average prefix length: 2.88, average data length: 2.55 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index QTYX (4) 90s Root page: 306, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 5.06, total dup: 11, max dup: 3 90s Average key length: 4.03, compression ratio: 3.23 90s Average prefix length: 11.18, average data length: 1.85 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN25 (1) 90s Root page: 286, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 3.55, total dup: 18, max dup: 4 90s Average key length: 2.52, compression ratio: 1.19 90s Average prefix length: 2.48, average data length: 0.52 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$FOREIGN26 (2) 90s Root page: 287, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 3.67, total dup: 25, max dup: 7 90s Average key length: 2.64, compression ratio: 1.01 90s Average prefix length: 2.21, average data length: 0.45 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index RDB$PRIMARY24 (0) 90s Root page: 285, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 8.45, total dup: 0, max dup: 0 90s Average key length: 7.42, compression ratio: 1.08 90s Average prefix length: 3.52, average data length: 4.48 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Index SALESTATX (5) 90s Root page: 307, depth: 1, leaf buckets: 1, nodes: 33 90s Average node length: 4.06, total dup: 27, max dup: 14 90s Average key length: 3.03, compression ratio: 3.56 90s Average prefix length: 9.82, average data length: 0.97 90s Clustering factor: 1, ratio: 0.03 90s Fill distribution: 90s 0 - 19% = 1 90s 20 - 39% = 0 90s 40 - 59% = 0 90s 60 - 79% = 0 90s 80 - 99% = 0 90s 90s Gstat completion time Fri May 2 03:07:42 2025 90s 90s V: Running gfix -v 90s V: Some big math 90s create table tbl1(fld1 int128); 90s insert into tbl1 values(12345); 90s select * from tbl1; 90s 90s FLD1 90s ============================================= 90s 12345 90s 90s autopkgtest [03:07:43]: test assorted-tools: -----------------------] 91s assorted-tools PASS 91s autopkgtest [03:07:44]: test assorted-tools: - - - - - - - - - - results - - - - - - - - - - 91s autopkgtest [03:07:44]: @@@@@@@@@@@@@@@@@@@@ summary 91s assorted-tools PASS 95s nova [W] Using flock in prodstack7-arm64 95s Creating nova instance adt-questing-arm64-firebird4.0-20250502-030613-juju-7f2275-prod-proposed-migration-environment-21-03de4f80-236b-4ff2-a746-f47eaf2a6e69 from image adt/ubuntu-questing-arm64-server-20250501.img (UUID 137c3127-57d2-4bf2-a106-d904ad6e43f4)... 95s nova [W] Timed out waiting for 17702a58-ada7-44e7-a6a5-ce7d4c6144f6 to get deleted.