0s autopkgtest [07:56:23]: starting date and time: 2025-05-02 07:56:23+0000 0s autopkgtest [07:56:23]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [07:56:23]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.rxklxqun/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 builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-8.secgroup --name adt-questing-amd64-firebird4.0-20250502-075622-juju-7f2275-prod-proposed-migration-environment-15-ed4c5f12-5040-4cb9-a4b5-4cec5258feb8 --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 60s autopkgtest [07:57:23]: testbed dpkg architecture: amd64 60s autopkgtest [07:57:23]: testbed apt version: 3.0.0 60s autopkgtest [07:57:23]: @@@@@@@@@@@@@@@@@@@@ test bed setup 60s autopkgtest [07:57:23]: testbed release detected to be: None 61s autopkgtest [07:57:24]: updating testbed package index (apt update) 62s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 62s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 62s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 62s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 62s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [57.4 kB] 62s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [2202 kB] 62s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [184 kB] 62s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [233 kB] 62s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [173 kB] 62s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [1659 kB] 63s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [800 kB] 63s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [34.2 kB] 63s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [21.4 kB] 63s Fetched 5475 kB in 1s (4201 kB/s) 64s Reading package lists... 64s autopkgtest [07:57:27]: upgrading testbed (apt dist-upgrade and autopurge) 65s Reading package lists... 65s Building dependency tree... 65s Reading state information... 65s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 65s Starting 2 pkgProblemResolver with broken count: 0 65s Done 66s Entering ResolveByKeep 66s 66s Calculating upgrade... 66s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 66s Reading package lists... 67s Building dependency tree... 67s Reading state information... 67s Starting pkgProblemResolver with broken count: 0 67s Starting 2 pkgProblemResolver with broken count: 0 67s Done 67s Solving dependencies... 67s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 70s autopkgtest [07:57:33]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 70s autopkgtest [07:57:33]: @@@@@@@@@@@@@@@@@@@@ apt-source firebird4.0 77s Get:1 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (dsc) [2860 B] 77s Get:2 http://ftpmaster.internal/ubuntu questing/universe firebird4.0 4.0.5.3140.ds6-16 (tar) [3965 kB] 77s 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 78s autopkgtest [07:57:41]: testing package firebird4.0 version 4.0.5.3140.ds6-16 79s autopkgtest [07:57:42]: build not needed 83s autopkgtest [07:57:46]: test assorted-tools: preparing testbed 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 84s Starting pkgProblemResolver with broken count: 0 84s Starting 2 pkgProblemResolver with broken count: 0 84s Done 85s The following NEW packages will be installed: 85s firebird-utils firebird4.0-common firebird4.0-common-doc 85s firebird4.0-examples firebird4.0-server-core firebird4.0-utils 85s libabsl20230802 libfbclient2 libre2-11 libtomcrypt1 libtommath1 85s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 85s Need to get 7787 kB of archives. 85s After this operation, 30.6 MB of additional disk space will be used. 85s Get:1 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird4.0-common-doc all 4.0.5.3140.ds6-16 [28.3 kB] 85s Get:2 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird4.0-common all 4.0.5.3140.ds6-16 [18.5 kB] 85s Get:3 http://ftpmaster.internal/ubuntu questing/universe amd64 libtommath1 amd64 1.3.0-1 [67.2 kB] 85s Get:4 http://ftpmaster.internal/ubuntu questing/universe amd64 libfbclient2 amd64 4.0.5.3140.ds6-16 [889 kB] 85s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 libabsl20230802 amd64 20230802.1-4.2 [567 kB] 85s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 libre2-11 amd64 20240501-3build1 [166 kB] 85s Get:7 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird4.0-utils amd64 4.0.5.3140.ds6-16 [1475 kB] 85s Get:8 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird-utils all 4.0.5.3140.ds6-16 [3714 B] 85s Get:9 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird4.0-examples all 4.0.5.3140.ds6-16 [387 kB] 85s Get:10 http://ftpmaster.internal/ubuntu questing/universe amd64 libtomcrypt1 amd64 1.18.2+dfsg-7build1 [384 kB] 85s Get:11 http://ftpmaster.internal/ubuntu questing/universe amd64 firebird4.0-server-core amd64 4.0.5.3140.ds6-16 [3802 kB] 86s Fetched 7787 kB in 1s (8528 kB/s) 86s Selecting previously unselected package firebird4.0-common-doc. 86s (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 ... 80514 files and directories currently installed.) 86s Preparing to unpack .../00-firebird4.0-common-doc_4.0.5.3140.ds6-16_all.deb ... 86s Unpacking firebird4.0-common-doc (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package firebird4.0-common. 86s Preparing to unpack .../01-firebird4.0-common_4.0.5.3140.ds6-16_all.deb ... 86s Unpacking firebird4.0-common (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package libtommath1:amd64. 86s Preparing to unpack .../02-libtommath1_1.3.0-1_amd64.deb ... 86s Unpacking libtommath1:amd64 (1.3.0-1) ... 86s Selecting previously unselected package libfbclient2:amd64. 86s Preparing to unpack .../03-libfbclient2_4.0.5.3140.ds6-16_amd64.deb ... 86s Unpacking libfbclient2:amd64 (4.0.5.3140.ds6-16) ... 86s Selecting previously unselected package libabsl20230802:amd64. 86s Preparing to unpack .../04-libabsl20230802_20230802.1-4.2_amd64.deb ... 86s Unpacking libabsl20230802:amd64 (20230802.1-4.2) ... 86s Selecting previously unselected package libre2-11:amd64. 86s Preparing to unpack .../05-libre2-11_20240501-3build1_amd64.deb ... 86s Unpacking libre2-11:amd64 (20240501-3build1) ... 86s Selecting previously unselected package firebird4.0-utils. 86s Preparing to unpack .../06-firebird4.0-utils_4.0.5.3140.ds6-16_amd64.deb ... 86s 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:amd64. 86s Preparing to unpack .../09-libtomcrypt1_1.18.2+dfsg-7build1_amd64.deb ... 86s Unpacking libtomcrypt1:amd64 (1.18.2+dfsg-7build1) ... 86s Selecting previously unselected package firebird4.0-server-core:amd64. 86s Preparing to unpack .../10-firebird4.0-server-core_4.0.5.3140.ds6-16_amd64.deb ... 86s Unpacking firebird4.0-server-core:amd64 (4.0.5.3140.ds6-16) ... 86s Setting up libtommath1:amd64 (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) ... 87s Configuring /etc/firebird/4.0/service-port.conf to use port 3050 87s Setting up libabsl20230802:amd64 (20230802.1-4.2) ... 87s Setting up libtomcrypt1:amd64 (1.18.2+dfsg-7build1) ... 87s Setting up firebird4.0-examples (4.0.5.3140.ds6-16) ... 87s Setting up libre2-11:amd64 (20240501-3build1) ... 87s Setting up libfbclient2:amd64 (4.0.5.3140.ds6-16) ... 87s Setting up firebird4.0-server-core:amd64 (4.0.5.3140.ds6-16) ... 87s Setting up firebird-utils (4.0.5.3140.ds6-16) ... 87s Setting up firebird4.0-utils (4.0.5.3140.ds6-16) ... 87s 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 87s Processing triggers for libc-bin (2.41-6ubuntu1) ... 87s Processing triggers for man-db (2.13.0-1) ... 89s autopkgtest [07:57:52]: test assorted-tools: [----------------------- 89s V: Creating employee.fdb via isql-fb -i 90s V: Backing up 90s V: Restoring the backup 90s 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 07:57 employee.sql 90s V: Running fbstat on employee.fdb 91s 91s Database "/tmp/autopkgtest.Gmveyt/assorted-tools-artifacts/employee.fdb" 91s Gstat execution time Fri May 2 07:57:53 2025 91s 91s Database header page information: 91s Flags 0 91s Generation 162 91s System Change Number 0 91s Page size 8192 91s ODS version 13.0 91s Oldest transaction 155 91s Oldest active 156 91s Oldest snapshot 156 91s Next transaction 156 91s Sequence number 0 91s Next attachment ID 9 91s Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 91s Shadow count 0 91s Page buffers 0 91s Next header page 0 91s Database dialect 3 91s Creation date May 2, 2025 7:57:52 91s Attributes force write 91s 91s Variable header data: 91s Database GUID: {5B8E7044-6579-451F-89CD-1A47C4B0D21D} 91s *END* 91s 91s 91s Database file sequence: 91s File /tmp/autopkgtest.Gmveyt/assorted-tools-artifacts/employee.fdb is the only file 91s 91s Analyzing database pages ... 91s COUNTRY (128) 91s Primary pointer page: 222, Index root page: 223 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 8% 91s Primary pages: 1, secondary pages: 0, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY1 (0) 91s Root page: 226, depth: 1, leaf buckets: 1, nodes: 16 91s Average node length: 10.44, total dup: 0, max dup: 0 91s Average key length: 8.62, compression ratio: 0.80 91s Average prefix length: 0.44, average data length: 6.44 91s Clustering factor: 1, ratio: 0.06 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s CUSTOMER (137) 91s Primary pointer page: 276, Index root page: 277 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 26% 91s Primary pages: 1, secondary pages: 0, swept pages: 1 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 1 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index CUSTNAMEX (2) 91s Root page: 290, depth: 1, leaf buckets: 1, nodes: 15 91s Average node length: 19.87, total dup: 0, max dup: 0 91s Average key length: 18.27, compression ratio: 0.90 91s Average prefix length: 0.60, average data length: 15.87 91s Clustering factor: 1, ratio: 0.07 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index CUSTREGION (3) 91s Root page: 291, depth: 1, leaf buckets: 1, nodes: 15 91s Average node length: 21.27, total dup: 0, max dup: 0 91s Average key length: 20.20, compression ratio: 0.97 91s Average prefix length: 2.33, average data length: 17.27 91s Clustering factor: 1, ratio: 0.07 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN23 (1) 91s Root page: 279, depth: 1, leaf buckets: 1, nodes: 15 91s Average node length: 8.60, total dup: 4, max dup: 4 91s Average key length: 6.93, compression ratio: 0.83 91s Average prefix length: 0.87, average data length: 4.87 91s Clustering factor: 1, ratio: 0.07 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY22 (0) 91s Root page: 278, depth: 1, leaf buckets: 1, nodes: 15 91s Average node length: 4.20, total dup: 0, max dup: 0 91s Average key length: 3.13, compression ratio: 0.96 91s Average prefix length: 1.87, average data length: 1.13 91s Clustering factor: 1, ratio: 0.07 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s DEPARTMENT (130) 91s Primary pointer page: 236, Index root page: 237 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 24% 91s Primary pages: 1, secondary pages: 0, swept pages: 1 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 1 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index BUDGETX (3) 91s Root page: 298, depth: 1, leaf buckets: 1, nodes: 21 91s Average node length: 9.05, total dup: 7, max dup: 3 91s Average key length: 8.00, compression ratio: 1.12 91s Average prefix length: 3.62, average data length: 5.38 91s Clustering factor: 1, ratio: 0.05 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$4 (0) 91s Root page: 238, depth: 1, leaf buckets: 1, nodes: 21 91s Average node length: 17.95, total dup: 0, max dup: 0 91s Average key length: 16.57, compression ratio: 1.16 91s Average prefix length: 5.29, average data length: 13.95 91s Clustering factor: 1, ratio: 0.05 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN10 (4) 91s Root page: 250, depth: 1, leaf buckets: 1, nodes: 21 91s Average node length: 4.29, total dup: 3, max dup: 3 91s Average key length: 3.24, compression ratio: 0.60 91s Average prefix length: 0.81, average data length: 1.14 91s Clustering factor: 1, ratio: 0.05 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN6 (2) 91s Root page: 240, depth: 1, leaf buckets: 1, nodes: 21 91s Average node length: 4.10, total dup: 13, max dup: 4 91s Average key length: 2.95, compression ratio: 0.97 91s Average prefix length: 2.05, average data length: 0.81 91s Clustering factor: 1, ratio: 0.05 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY5 (1) 91s Root page: 239, depth: 1, leaf buckets: 1, nodes: 21 91s Average node length: 5.24, total dup: 0, max dup: 0 91s Average key length: 4.05, compression ratio: 0.74 91s Average prefix length: 1.29, average data length: 1.71 91s Clustering factor: 1, ratio: 0.05 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s EMPLOYEE (131) 91s Primary pointer page: 243, Index root page: 244 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 44% 91s Primary pages: 1, secondary pages: 0, swept pages: 1 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 0 91s 40 - 59% = 1 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index NAMEX (3) 91s Root page: 299, depth: 1, leaf buckets: 1, nodes: 42 91s Average node length: 19.52, total dup: 0, max dup: 0 91s Average key length: 18.50, compression ratio: 0.96 91s Average prefix length: 2.17, average data length: 15.52 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN8 (1) 91s Root page: 246, depth: 1, leaf buckets: 1, nodes: 42 91s Average node length: 4.07, total dup: 23, max dup: 4 91s Average key length: 2.98, compression ratio: 1.01 91s Average prefix length: 2.19, average data length: 0.81 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN9 (2) 91s Root page: 247, depth: 1, leaf buckets: 1, nodes: 42 91s Average node length: 10.43, total dup: 15, max dup: 4 91s Average key length: 9.40, compression ratio: 1.68 91s Average prefix length: 9.05, average data length: 6.79 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY7 (0) 91s Root page: 245, depth: 1, leaf buckets: 1, nodes: 42 91s Average node length: 4.62, total dup: 0, max dup: 0 91s Average key length: 3.60, compression ratio: 0.69 91s Average prefix length: 1.17, average data length: 1.31 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s EMPLOYEE_PROJECT (134) 91s Primary pointer page: 258, Index root page: 259 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 10% 91s Primary pages: 1, secondary pages: 0, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN15 (1) 91s Root page: 261, depth: 1, leaf buckets: 1, nodes: 28 91s Average node length: 4.29, total dup: 6, max dup: 2 91s Average key length: 3.25, compression ratio: 0.74 91s Average prefix length: 1.36, average data length: 1.04 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN16 (2) 91s Root page: 262, depth: 1, leaf buckets: 1, nodes: 28 91s Average node length: 4.04, total dup: 23, max dup: 9 91s Average key length: 2.89, compression ratio: 1.73 91s Average prefix length: 4.14, average data length: 0.86 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY14 (0) 91s Root page: 260, depth: 1, leaf buckets: 1, nodes: 28 91s Average node length: 13.11, total dup: 0, max dup: 0 91s Average key length: 12.07, compression ratio: 0.99 91s Average prefix length: 2.89, average data length: 9.11 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s JOB (129) 91s Primary pointer page: 229, Index root page: 230 91s Pointer pages: 1, data page slots: 2 91s Data pages: 2, average fill: 43% 91s Primary pages: 1, secondary pages: 1, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 1 91s 40 - 59% = 1 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index MAXSALX (2) 91s Root page: 300, depth: 1, leaf buckets: 1, nodes: 31 91s Average node length: 14.74, total dup: 5, max dup: 1 91s Average key length: 13.71, compression ratio: 1.37 91s Average prefix length: 7.87, average data length: 10.90 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index MINSALX (3) 91s Root page: 301, depth: 1, leaf buckets: 1, nodes: 31 91s Average node length: 14.06, total dup: 7, max dup: 2 91s Average key length: 13.03, compression ratio: 1.44 91s Average prefix length: 8.48, average data length: 10.29 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN3 (1) 91s Root page: 232, depth: 1, leaf buckets: 1, nodes: 31 91s Average node length: 4.61, total dup: 24, max dup: 20 91s Average key length: 3.39, compression ratio: 1.23 91s Average prefix length: 2.77, average data length: 1.39 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY2 (0) 91s Root page: 231, depth: 1, leaf buckets: 1, nodes: 31 91s Average node length: 14.45, total dup: 0, max dup: 0 91s Average key length: 13.42, compression ratio: 1.24 91s Average prefix length: 6.19, average data length: 10.45 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s PROJECT (133) 91s Primary pointer page: 251, Index root page: 252 91s Pointer pages: 1, data page slots: 2 91s Data pages: 2, average fill: 7% 91s Primary pages: 1, secondary pages: 1, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 2 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index PRODTYPEX (3) 91s Root page: 302, depth: 1, leaf buckets: 1, nodes: 6 91s Average node length: 26.50, total dup: 0, max dup: 0 91s Average key length: 25.33, compression ratio: 1.05 91s Average prefix length: 4.17, average data length: 22.50 91s Clustering factor: 1, ratio: 0.17 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$11 (0) 91s Root page: 253, depth: 1, leaf buckets: 1, nodes: 6 91s Average node length: 17.33, total dup: 0, max dup: 0 91s Average key length: 15.50, compression ratio: 0.88 91s Average prefix length: 0.33, average data length: 13.33 91s Clustering factor: 1, ratio: 0.17 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN13 (2) 91s Root page: 255, depth: 1, leaf buckets: 1, nodes: 6 91s Average node length: 4.67, total dup: 0, max dup: 0 91s Average key length: 3.50, compression ratio: 0.57 91s Average prefix length: 0.67, average data length: 1.33 91s Clustering factor: 1, ratio: 0.17 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY12 (1) 91s Root page: 254, depth: 1, leaf buckets: 1, nodes: 6 91s Average node length: 8.83, total dup: 0, max dup: 0 91s Average key length: 7.00, compression ratio: 0.71 91s Average prefix length: 0.17, average data length: 4.83 91s Clustering factor: 1, ratio: 0.17 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s PROJ_DEPT_BUDGET (135) 91s Primary pointer page: 265, Index root page: 266 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 12% 91s Primary pages: 1, secondary pages: 0, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN18 (1) 91s Root page: 268, depth: 1, leaf buckets: 1, nodes: 24 91s Average node length: 3.92, total dup: 15, max dup: 5 91s Average key length: 2.79, compression ratio: 1.07 91s Average prefix length: 2.29, average data length: 0.71 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN19 (2) 91s Root page: 269, depth: 1, leaf buckets: 1, nodes: 24 91s Average node length: 4.21, total dup: 19, max dup: 8 91s Average key length: 3.04, compression ratio: 1.64 91s Average prefix length: 4.00, average data length: 1.00 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY17 (0) 91s Root page: 267, depth: 1, leaf buckets: 1, nodes: 24 91s Average node length: 10.71, total dup: 0, max dup: 0 91s Average key length: 9.67, compression ratio: 1.97 91s Average prefix length: 12.17, average data length: 6.83 91s Clustering factor: 1, ratio: 0.04 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s SALARY_HISTORY (136) 91s Primary pointer page: 270, Index root page: 271 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 30% 91s Primary pages: 1, secondary pages: 0, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 1 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index CHANGEX (2) 91s Root page: 303, depth: 1, leaf buckets: 1, nodes: 49 91s Average node length: 3.37, total dup: 46, max dup: 21 91s Average key length: 2.35, compression ratio: 2.98 91s Average prefix length: 6.69, average data length: 0.31 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN21 (1) 91s Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 91s Average node length: 4.12, total dup: 16, max dup: 2 91s Average key length: 3.10, compression ratio: 0.75 91s Average prefix length: 1.43, average data length: 0.90 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY20 (0) 91s Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 91s Average node length: 22.29, total dup: 0, max dup: 0 91s Average key length: 21.27, compression ratio: 1.06 91s Average prefix length: 4.31, average data length: 18.29 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index UPDATERX (3) 91s Root page: 304, depth: 1, leaf buckets: 1, nodes: 49 91s Average node length: 3.35, total dup: 46, max dup: 28 91s Average key length: 2.29, compression ratio: 2.48 91s Average prefix length: 5.39, average data length: 0.29 91s Clustering factor: 1, ratio: 0.02 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s SALES (138) 91s Primary pointer page: 283, Index root page: 284 91s Pointer pages: 1, data page slots: 1 91s Data pages: 1, average fill: 35% 91s Primary pages: 1, secondary pages: 0, swept pages: 0 91s Empty pages: 0, full pages: 0 91s Fill distribution: 91s 0 - 19% = 0 91s 20 - 39% = 1 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index NEEDX (3) 91s Root page: 305, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 5.97, total dup: 11, max dup: 6 91s Average key length: 4.94, compression ratio: 1.10 91s Average prefix length: 2.88, average data length: 2.55 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index QTYX (4) 91s Root page: 306, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 5.06, total dup: 11, max dup: 3 91s Average key length: 4.03, compression ratio: 3.23 91s Average prefix length: 11.18, average data length: 1.85 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN25 (1) 91s Root page: 286, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 3.55, total dup: 18, max dup: 4 91s Average key length: 2.52, compression ratio: 1.19 91s Average prefix length: 2.48, average data length: 0.52 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$FOREIGN26 (2) 91s Root page: 287, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 3.67, total dup: 25, max dup: 7 91s Average key length: 2.64, compression ratio: 1.01 91s Average prefix length: 2.21, average data length: 0.45 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index RDB$PRIMARY24 (0) 91s Root page: 285, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 8.45, total dup: 0, max dup: 0 91s Average key length: 7.42, compression ratio: 1.08 91s Average prefix length: 3.52, average data length: 4.48 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Index SALESTATX (5) 91s Root page: 307, depth: 1, leaf buckets: 1, nodes: 33 91s Average node length: 4.06, total dup: 27, max dup: 14 91s Average key length: 3.03, compression ratio: 3.56 91s Average prefix length: 9.82, average data length: 0.97 91s Clustering factor: 1, ratio: 0.03 91s Fill distribution: 91s 0 - 19% = 1 91s 20 - 39% = 0 91s 40 - 59% = 0 91s 60 - 79% = 0 91s 80 - 99% = 0 91s 91s Gstat completion time Fri May 2 07:57:54 2025 91s 91s V: Running gfix -v 91s V: Some big math 91s create table tbl1(fld1 int128); 91s insert into tbl1 values(12345); 91s select * from tbl1; 91s 91s FLD1 91s ============================================= 91s 12345 91s 91s autopkgtest [07:57:54]: test assorted-tools: -----------------------] 93s assorted-tools PASS 93s autopkgtest [07:57:56]: test assorted-tools: - - - - - - - - - - results - - - - - - - - - - 93s autopkgtest [07:57:56]: @@@@@@@@@@@@@@@@@@@@ summary 93s assorted-tools PASS 111s nova [W] Skipping flock for amd64 111s Creating nova instance adt-questing-amd64-firebird4.0-20250502-075622-juju-7f2275-prod-proposed-migration-environment-15-ed4c5f12-5040-4cb9-a4b5-4cec5258feb8 from image adt/ubuntu-questing-amd64-server-20250502.img (UUID 9956ea44-e870-4bd8-8ad1-dc5f8a09f1f9)... 111s nova [W] Timed out waiting for db90a102-49fa-4661-b4d3-72eaee786f11 to get deleted.