0s autopkgtest [22:14:04]: starting date and time: 2025-02-15 22:14:04+0000 0s autopkgtest [22:14:04]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [22:14:04]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.rbop3yqt/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc,src:iproute2,src:php-twig,src:postgresql-17,src:postgresql-common,src:roundcube --apt-upgrade firebird4.0 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu1 iproute2/6.13.0-1ubuntu1 php-twig/3.19.0-1 postgresql-17/17.3-2 postgresql-common/273 roundcube/1.6.10+dfsg-1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-25.secgroup --name adt-plucky-arm64-firebird4.0-20250215-221403-juju-7f2275-prod-proposed-migration-environment-2-a3641233-e457-4104-b955-c5454b212631 --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 175s autopkgtest [22:16:59]: testbed dpkg architecture: arm64 175s autopkgtest [22:16:59]: testbed apt version: 2.9.28 175s autopkgtest [22:16:59]: @@@@@@@@@@@@@@@@@@@@ test bed setup 176s autopkgtest [22:16:59]: testbed release detected to be: None 177s autopkgtest [22:17:01]: updating testbed package index (apt update) 177s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 178s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 178s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 178s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 178s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [74.3 kB] 178s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 178s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.1 kB] 178s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [828 kB] 178s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [163 kB] 178s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [7960 B] 178s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [942 kB] 178s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [10.0 kB] 178s Fetched 2151 kB in 1s (1748 kB/s) 180s Reading package lists... 180s Reading package lists... 181s Building dependency tree... 181s Reading state information... 181s Calculating upgrade... 182s The following packages will be upgraded: 182s dash libtasn1-6 libxdmcp6 182s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 182s Need to get 151 kB of archives. 182s After this operation, 17.4 kB of additional disk space will be used. 182s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 dash arm64 0.5.12-12ubuntu1 [96.1 kB] 182s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libtasn1-6 arm64 4.20.0-2 [43.9 kB] 182s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libxdmcp6 arm64 1:1.1.5-1 [10.7 kB] 183s Preconfiguring packages ... 183s Fetched 151 kB in 0s (333 kB/s) 183s (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 ... 116609 files and directories currently installed.) 183s Preparing to unpack .../dash_0.5.12-12ubuntu1_arm64.deb ... 183s Unpacking dash (0.5.12-12ubuntu1) over (0.5.12-9ubuntu1) ... 183s Setting up dash (0.5.12-12ubuntu1) ... 184s (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 ... 116609 files and directories currently installed.) 184s Preparing to unpack .../libtasn1-6_4.20.0-2_arm64.deb ... 184s Unpacking libtasn1-6:arm64 (4.20.0-2) over (4.19.0-3build1) ... 184s Preparing to unpack .../libxdmcp6_1%3a1.1.5-1_arm64.deb ... 184s Unpacking libxdmcp6:arm64 (1:1.1.5-1) over (1:1.1.3-0ubuntu6) ... 184s Setting up libxdmcp6:arm64 (1:1.1.5-1) ... 184s Setting up libtasn1-6:arm64 (4.20.0-2) ... 184s Processing triggers for libc-bin (2.40-4ubuntu1) ... 184s Processing triggers for man-db (2.13.0-1) ... 185s Processing triggers for debianutils (5.21) ... 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 186s 0 upgraded, 0 newly installed, 0 to remove and 6 not upgraded. 186s autopkgtest [22:17:10]: upgrading testbed (apt dist-upgrade and autopurge) 186s Reading package lists... 187s Building dependency tree... 187s Reading state information... 187s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 187s Starting 2 pkgProblemResolver with broken count: 0 187s Done 188s Entering ResolveByKeep 189s 189s The following packages will be upgraded: 189s iproute2 libc-bin libc-dev-bin libc6 libc6-dev locales 189s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 189s Need to get 10.7 MB of archives. 189s After this operation, 358 kB of additional disk space will be used. 189s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu1 [24.0 kB] 189s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu1 [1750 kB] 190s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu1 [4246 kB] 190s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu1 [2910 kB] 190s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu1 [600 kB] 190s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 iproute2 arm64 6.13.0-1ubuntu1 [1158 kB] 191s Preconfiguring packages ... 191s Fetched 10.7 MB in 1s (9826 kB/s) 191s (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 ... 116609 files and directories currently installed.) 191s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu1_arm64.deb ... 191s Unpacking libc-dev-bin (2.41-1ubuntu1) over (2.40-4ubuntu1) ... 191s Preparing to unpack .../libc6-dev_2.41-1ubuntu1_arm64.deb ... 191s Unpacking libc6-dev:arm64 (2.41-1ubuntu1) over (2.40-4ubuntu1) ... 191s Preparing to unpack .../locales_2.41-1ubuntu1_all.deb ... 191s Unpacking locales (2.41-1ubuntu1) over (2.40-4ubuntu1) ... 192s Preparing to unpack .../libc6_2.41-1ubuntu1_arm64.deb ... 192s Checking for services that may need to be restarted... 192s Checking init scripts... 192s Checking for services that may need to be restarted... 192s Checking init scripts... 192s Stopping some services possibly affected by the upgrade (will be restarted later): 192s cron: stopping...done. 192s 192s Unpacking libc6:arm64 (2.41-1ubuntu1) over (2.40-4ubuntu1) ... 192s Setting up libc6:arm64 (2.41-1ubuntu1) ... 192s Checking for services that may need to be restarted... 192s Checking init scripts... 192s Restarting services possibly affected by the upgrade: 193s cron: restarting...done. 193s 193s Services restarted successfully. 193s (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 ... 116610 files and directories currently installed.) 193s Preparing to unpack .../libc-bin_2.41-1ubuntu1_arm64.deb ... 193s Unpacking libc-bin (2.41-1ubuntu1) over (2.40-4ubuntu1) ... 193s Setting up libc-bin (2.41-1ubuntu1) ... 193s (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 ... 116610 files and directories currently installed.) 193s Preparing to unpack .../iproute2_6.13.0-1ubuntu1_arm64.deb ... 194s Unpacking iproute2 (6.13.0-1ubuntu1) over (6.10.0-2ubuntu1) ... 194s Setting up iproute2 (6.13.0-1ubuntu1) ... 194s Setting up locales (2.41-1ubuntu1) ... 194s Installing new version of config file /etc/locale.alias ... 195s Generating locales (this might take a while)... 198s en_US.UTF-8... done 198s Generation complete. 198s Setting up libc-dev-bin (2.41-1ubuntu1) ... 198s Setting up libc6-dev:arm64 (2.41-1ubuntu1) ... 198s Processing triggers for man-db (2.13.0-1) ... 199s Processing triggers for systemd (257.2-3ubuntu1) ... 200s Reading package lists... 201s Building dependency tree... 201s Reading state information... 201s Starting pkgProblemResolver with broken count: 0 201s Starting 2 pkgProblemResolver with broken count: 0 201s Done 202s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 205s autopkgtest [22:17:29]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Tue Feb 4 15:49:33 UTC 2025 205s autopkgtest [22:17:29]: @@@@@@@@@@@@@@@@@@@@ apt-source firebird4.0 214s Get:1 http://ftpmaster.internal/ubuntu plucky/universe firebird4.0 4.0.5.3140.ds6-15 (dsc) [2860 B] 214s Get:2 http://ftpmaster.internal/ubuntu plucky/universe firebird4.0 4.0.5.3140.ds6-15 (tar) [3965 kB] 214s Get:3 http://ftpmaster.internal/ubuntu plucky/universe firebird4.0 4.0.5.3140.ds6-15 (diff) [101 kB] 214s gpgv: Signature made Sat Feb 8 11:59:35 2025 UTC 214s gpgv: using RSA key AEA0C44ECB056E93630D9D33DBBE9D4D99D2A004 214s gpgv: Can't check signature: No public key 214s dpkg-source: warning: cannot verify inline signature for ./firebird4.0_4.0.5.3140.ds6-15.dsc: no acceptable signature found 215s autopkgtest [22:17:39]: testing package firebird4.0 version 4.0.5.3140.ds6-15 216s autopkgtest [22:17:40]: build not needed 222s autopkgtest [22:17:46]: test assorted-tools: preparing testbed 222s Reading package lists... 222s Building dependency tree... 222s Reading state information... 223s Starting pkgProblemResolver with broken count: 0 223s Starting 2 pkgProblemResolver with broken count: 0 223s Done 224s The following NEW packages will be installed: 224s firebird-utils firebird4.0-common firebird4.0-common-doc 224s firebird4.0-examples firebird4.0-server-core firebird4.0-utils 224s libabsl20230802 libfbclient2 libre2-11 libtomcrypt1 libtommath1 224s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 224s Need to get 7463 kB of archives. 224s After this operation, 34.9 MB of additional disk space will be used. 224s Get:1 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird4.0-common-doc all 4.0.5.3140.ds6-15 [28.3 kB] 224s Get:2 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird4.0-common all 4.0.5.3140.ds6-15 [18.5 kB] 224s Get:3 http://ftpmaster.internal/ubuntu plucky/universe arm64 libtommath1 arm64 1.3.0-1 [59.1 kB] 224s Get:4 http://ftpmaster.internal/ubuntu plucky/universe arm64 libfbclient2 arm64 4.0.5.3140.ds6-15 [857 kB] 224s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 libabsl20230802 arm64 20230802.1-4ubuntu2 [487 kB] 224s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 libre2-11 arm64 20240501-3build1 [160 kB] 224s Get:7 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird4.0-utils arm64 4.0.5.3140.ds6-15 [1436 kB] 224s Get:8 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird-utils all 4.0.5.3140.ds6-15 [3714 B] 224s Get:9 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird4.0-examples all 4.0.5.3140.ds6-15 [387 kB] 224s Get:10 http://ftpmaster.internal/ubuntu plucky/universe arm64 libtomcrypt1 arm64 1.18.2+dfsg-7build1 [407 kB] 224s Get:11 http://ftpmaster.internal/ubuntu plucky/universe arm64 firebird4.0-server-core arm64 4.0.5.3140.ds6-15 [3620 kB] 225s Fetched 7463 kB in 1s (6642 kB/s) 225s Selecting previously unselected package firebird4.0-common-doc. 225s (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 ... 116611 files and directories currently installed.) 225s Preparing to unpack .../00-firebird4.0-common-doc_4.0.5.3140.ds6-15_all.deb ... 225s Unpacking firebird4.0-common-doc (4.0.5.3140.ds6-15) ... 225s Selecting previously unselected package firebird4.0-common. 225s Preparing to unpack .../01-firebird4.0-common_4.0.5.3140.ds6-15_all.deb ... 225s Unpacking firebird4.0-common (4.0.5.3140.ds6-15) ... 225s Selecting previously unselected package libtommath1:arm64. 226s Preparing to unpack .../02-libtommath1_1.3.0-1_arm64.deb ... 226s Unpacking libtommath1:arm64 (1.3.0-1) ... 226s Selecting previously unselected package libfbclient2:arm64. 226s Preparing to unpack .../03-libfbclient2_4.0.5.3140.ds6-15_arm64.deb ... 226s Unpacking libfbclient2:arm64 (4.0.5.3140.ds6-15) ... 226s Selecting previously unselected package libabsl20230802:arm64. 226s Preparing to unpack .../04-libabsl20230802_20230802.1-4ubuntu2_arm64.deb ... 226s Unpacking libabsl20230802:arm64 (20230802.1-4ubuntu2) ... 226s Selecting previously unselected package libre2-11:arm64. 226s Preparing to unpack .../05-libre2-11_20240501-3build1_arm64.deb ... 226s Unpacking libre2-11:arm64 (20240501-3build1) ... 226s Selecting previously unselected package firebird4.0-utils. 226s Preparing to unpack .../06-firebird4.0-utils_4.0.5.3140.ds6-15_arm64.deb ... 226s Unpacking firebird4.0-utils (4.0.5.3140.ds6-15) ... 226s Selecting previously unselected package firebird-utils. 226s Preparing to unpack .../07-firebird-utils_4.0.5.3140.ds6-15_all.deb ... 226s Unpacking firebird-utils (4.0.5.3140.ds6-15) ... 226s Selecting previously unselected package firebird4.0-examples. 226s Preparing to unpack .../08-firebird4.0-examples_4.0.5.3140.ds6-15_all.deb ... 226s Unpacking firebird4.0-examples (4.0.5.3140.ds6-15) ... 226s Selecting previously unselected package libtomcrypt1:arm64. 226s Preparing to unpack .../09-libtomcrypt1_1.18.2+dfsg-7build1_arm64.deb ... 226s Unpacking libtomcrypt1:arm64 (1.18.2+dfsg-7build1) ... 226s Selecting previously unselected package firebird4.0-server-core:arm64. 226s Preparing to unpack .../10-firebird4.0-server-core_4.0.5.3140.ds6-15_arm64.deb ... 226s Unpacking firebird4.0-server-core:arm64 (4.0.5.3140.ds6-15) ... 227s Setting up libtommath1:arm64 (1.3.0-1) ... 227s Setting up firebird4.0-common-doc (4.0.5.3140.ds6-15) ... 227s Setting up firebird4.0-common (4.0.5.3140.ds6-15) ... 227s Configuring /etc/firebird/4.0/service-port.conf to use port 3050 227s Setting up libabsl20230802:arm64 (20230802.1-4ubuntu2) ... 227s Setting up libtomcrypt1:arm64 (1.18.2+dfsg-7build1) ... 227s Setting up firebird4.0-examples (4.0.5.3140.ds6-15) ... 227s Setting up libre2-11:arm64 (20240501-3build1) ... 227s Setting up libfbclient2:arm64 (4.0.5.3140.ds6-15) ... 227s Setting up firebird4.0-server-core:arm64 (4.0.5.3140.ds6-15) ... 227s Setting up firebird-utils (4.0.5.3140.ds6-15) ... 227s Setting up firebird4.0-utils (4.0.5.3140.ds6-15) ... 227s 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 227s Processing triggers for libc-bin (2.41-1ubuntu1) ... 227s Processing triggers for man-db (2.13.0-1) ... 229s autopkgtest [22:17:53]: test assorted-tools: [----------------------- 229s V: Creating employee.fdb via isql-fb -i 231s V: Backing up 232s V: Restoring the backup 232s V: Extracting definition of employee.fdb via isql-fb -a 232s V: Checking the size of employee.sql 232s -rw-rw-r-- 1 ubuntu ubuntu 21525 Feb 15 22:17 employee.sql 232s V: Running fbstat on employee.fdb 232s 232s Database "/tmp/autopkgtest.F31OzK/assorted-tools-artifacts/employee.fdb" 232s Gstat execution time Sat Feb 15 22:17:56 2025 232s 232s Database header page information: 232s Flags 0 232s Generation 162 232s System Change Number 0 232s Page size 8192 232s ODS version 13.0 232s Oldest transaction 155 232s Oldest active 156 232s Oldest snapshot 156 232s Next transaction 156 232s Sequence number 0 232s Next attachment ID 9 232s Implementation HW=ARM64 little-endian OS=Linux CC=gcc 232s Shadow count 0 232s Page buffers 0 232s Next header page 0 232s Database dialect 3 232s Creation date Feb 15, 2025 22:17:53 232s Attributes force write 232s 232s Variable header data: 232s Database GUID: {E8BDFE89-A6F4-462C-8E64-C06C854A89FA} 232s *END* 232s 232s 232s Database file sequence: 232s File /tmp/autopkgtest.F31OzK/assorted-tools-artifacts/employee.fdb is the only file 232s 232s Analyzing database pages ... 232s COUNTRY (128) 232s Primary pointer page: 222, Index root page: 223 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 8% 232s Primary pages: 1, secondary pages: 0, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY1 (0) 232s Root page: 226, depth: 1, leaf buckets: 1, nodes: 16 232s Average node length: 10.44, total dup: 0, max dup: 0 232s Average key length: 8.62, compression ratio: 0.80 232s Average prefix length: 0.44, average data length: 6.44 232s Clustering factor: 1, ratio: 0.06 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s CUSTOMER (137) 232s Primary pointer page: 276, Index root page: 277 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 26% 232s Primary pages: 1, secondary pages: 0, swept pages: 1 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 1 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index CUSTNAMEX (2) 232s Root page: 290, depth: 1, leaf buckets: 1, nodes: 15 232s Average node length: 19.87, total dup: 0, max dup: 0 232s Average key length: 18.27, compression ratio: 0.90 232s Average prefix length: 0.60, average data length: 15.87 232s Clustering factor: 1, ratio: 0.07 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index CUSTREGION (3) 232s Root page: 291, depth: 1, leaf buckets: 1, nodes: 15 232s Average node length: 21.27, total dup: 0, max dup: 0 232s Average key length: 20.20, compression ratio: 0.97 232s Average prefix length: 2.33, average data length: 17.27 232s Clustering factor: 1, ratio: 0.07 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN23 (1) 232s Root page: 279, depth: 1, leaf buckets: 1, nodes: 15 232s Average node length: 8.60, total dup: 4, max dup: 4 232s Average key length: 6.93, compression ratio: 0.83 232s Average prefix length: 0.87, average data length: 4.87 232s Clustering factor: 1, ratio: 0.07 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY22 (0) 232s Root page: 278, depth: 1, leaf buckets: 1, nodes: 15 232s Average node length: 4.20, total dup: 0, max dup: 0 232s Average key length: 3.13, compression ratio: 0.96 232s Average prefix length: 1.87, average data length: 1.13 232s Clustering factor: 1, ratio: 0.07 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s DEPARTMENT (130) 232s Primary pointer page: 236, Index root page: 237 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 24% 232s Primary pages: 1, secondary pages: 0, swept pages: 1 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 1 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index BUDGETX (3) 232s Root page: 298, depth: 1, leaf buckets: 1, nodes: 21 232s Average node length: 9.05, total dup: 7, max dup: 3 232s Average key length: 8.00, compression ratio: 1.12 232s Average prefix length: 3.62, average data length: 5.38 232s Clustering factor: 1, ratio: 0.05 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$4 (0) 232s Root page: 238, depth: 1, leaf buckets: 1, nodes: 21 232s Average node length: 17.95, total dup: 0, max dup: 0 232s Average key length: 16.57, compression ratio: 1.16 232s Average prefix length: 5.29, average data length: 13.95 232s Clustering factor: 1, ratio: 0.05 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN10 (4) 232s Root page: 250, depth: 1, leaf buckets: 1, nodes: 21 232s Average node length: 4.29, total dup: 3, max dup: 3 232s Average key length: 3.24, compression ratio: 0.60 232s Average prefix length: 0.81, average data length: 1.14 232s Clustering factor: 1, ratio: 0.05 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN6 (2) 232s Root page: 240, depth: 1, leaf buckets: 1, nodes: 21 232s Average node length: 4.10, total dup: 13, max dup: 4 232s Average key length: 2.95, compression ratio: 0.97 232s Average prefix length: 2.05, average data length: 0.81 232s Clustering factor: 1, ratio: 0.05 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY5 (1) 232s Root page: 239, depth: 1, leaf buckets: 1, nodes: 21 232s Average node length: 5.24, total dup: 0, max dup: 0 232s Average key length: 4.05, compression ratio: 0.74 232s Average prefix length: 1.29, average data length: 1.71 232s Clustering factor: 1, ratio: 0.05 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s EMPLOYEE (131) 232s Primary pointer page: 243, Index root page: 244 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 44% 232s Primary pages: 1, secondary pages: 0, swept pages: 1 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 0 232s 40 - 59% = 1 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index NAMEX (3) 232s Root page: 299, depth: 1, leaf buckets: 1, nodes: 42 232s Average node length: 19.52, total dup: 0, max dup: 0 232s Average key length: 18.50, compression ratio: 0.96 232s Average prefix length: 2.17, average data length: 15.52 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN8 (1) 232s Root page: 246, depth: 1, leaf buckets: 1, nodes: 42 232s Average node length: 4.07, total dup: 23, max dup: 4 232s Average key length: 2.98, compression ratio: 1.01 232s Average prefix length: 2.19, average data length: 0.81 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN9 (2) 232s Root page: 247, depth: 1, leaf buckets: 1, nodes: 42 232s Average node length: 10.43, total dup: 15, max dup: 4 232s Average key length: 9.40, compression ratio: 1.68 232s Average prefix length: 9.05, average data length: 6.79 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY7 (0) 232s Root page: 245, depth: 1, leaf buckets: 1, nodes: 42 232s Average node length: 4.62, total dup: 0, max dup: 0 232s Average key length: 3.60, compression ratio: 0.69 232s Average prefix length: 1.17, average data length: 1.31 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s EMPLOYEE_PROJECT (134) 232s Primary pointer page: 258, Index root page: 259 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 10% 232s Primary pages: 1, secondary pages: 0, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN15 (1) 232s Root page: 261, depth: 1, leaf buckets: 1, nodes: 28 232s Average node length: 4.29, total dup: 6, max dup: 2 232s Average key length: 3.25, compression ratio: 0.74 232s Average prefix length: 1.36, average data length: 1.04 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN16 (2) 232s Root page: 262, depth: 1, leaf buckets: 1, nodes: 28 232s Average node length: 4.04, total dup: 23, max dup: 9 232s Average key length: 2.89, compression ratio: 1.73 232s Average prefix length: 4.14, average data length: 0.86 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY14 (0) 232s Root page: 260, depth: 1, leaf buckets: 1, nodes: 28 232s Average node length: 13.11, total dup: 0, max dup: 0 232s Average key length: 12.07, compression ratio: 0.99 232s Average prefix length: 2.89, average data length: 9.11 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s JOB (129) 232s Primary pointer page: 229, Index root page: 230 232s Pointer pages: 1, data page slots: 2 232s Data pages: 2, average fill: 43% 232s Primary pages: 1, secondary pages: 1, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 1 232s 40 - 59% = 1 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index MAXSALX (2) 232s Root page: 300, depth: 1, leaf buckets: 1, nodes: 31 232s Average node length: 14.74, total dup: 5, max dup: 1 232s Average key length: 13.71, compression ratio: 1.37 232s Average prefix length: 7.87, average data length: 10.90 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index MINSALX (3) 232s Root page: 301, depth: 1, leaf buckets: 1, nodes: 31 232s Average node length: 14.06, total dup: 7, max dup: 2 232s Average key length: 13.03, compression ratio: 1.44 232s Average prefix length: 8.48, average data length: 10.29 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN3 (1) 232s Root page: 232, depth: 1, leaf buckets: 1, nodes: 31 232s Average node length: 4.61, total dup: 24, max dup: 20 232s Average key length: 3.39, compression ratio: 1.23 232s Average prefix length: 2.77, average data length: 1.39 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY2 (0) 232s Root page: 231, depth: 1, leaf buckets: 1, nodes: 31 232s Average node length: 14.45, total dup: 0, max dup: 0 232s Average key length: 13.42, compression ratio: 1.24 232s Average prefix length: 6.19, average data length: 10.45 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s PROJECT (133) 232s Primary pointer page: 251, Index root page: 252 232s Pointer pages: 1, data page slots: 2 232s Data pages: 2, average fill: 7% 232s Primary pages: 1, secondary pages: 1, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 2 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index PRODTYPEX (3) 232s Root page: 302, depth: 1, leaf buckets: 1, nodes: 6 232s Average node length: 26.50, total dup: 0, max dup: 0 232s Average key length: 25.33, compression ratio: 1.05 232s Average prefix length: 4.17, average data length: 22.50 232s Clustering factor: 1, ratio: 0.17 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$11 (0) 232s Root page: 253, depth: 1, leaf buckets: 1, nodes: 6 232s Average node length: 17.33, total dup: 0, max dup: 0 232s Average key length: 15.50, compression ratio: 0.88 232s Average prefix length: 0.33, average data length: 13.33 232s Clustering factor: 1, ratio: 0.17 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN13 (2) 232s Root page: 255, depth: 1, leaf buckets: 1, nodes: 6 232s Average node length: 4.67, total dup: 0, max dup: 0 232s Average key length: 3.50, compression ratio: 0.57 232s Average prefix length: 0.67, average data length: 1.33 232s Clustering factor: 1, ratio: 0.17 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY12 (1) 232s Root page: 254, depth: 1, leaf buckets: 1, nodes: 6 232s Average node length: 8.83, total dup: 0, max dup: 0 232s Average key length: 7.00, compression ratio: 0.71 232s Average prefix length: 0.17, average data length: 4.83 232s Clustering factor: 1, ratio: 0.17 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s PROJ_DEPT_BUDGET (135) 232s Primary pointer page: 265, Index root page: 266 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 12% 232s Primary pages: 1, secondary pages: 0, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN18 (1) 232s Root page: 268, depth: 1, leaf buckets: 1, nodes: 24 232s Average node length: 3.92, total dup: 15, max dup: 5 232s Average key length: 2.79, compression ratio: 1.07 232s Average prefix length: 2.29, average data length: 0.71 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN19 (2) 232s Root page: 269, depth: 1, leaf buckets: 1, nodes: 24 232s Average node length: 4.21, total dup: 19, max dup: 8 232s Average key length: 3.04, compression ratio: 1.64 232s Average prefix length: 4.00, average data length: 1.00 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY17 (0) 232s Root page: 267, depth: 1, leaf buckets: 1, nodes: 24 232s Average node length: 10.71, total dup: 0, max dup: 0 232s Average key length: 9.67, compression ratio: 1.97 232s Average prefix length: 12.17, average data length: 6.83 232s Clustering factor: 1, ratio: 0.04 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s SALARY_HISTORY (136) 232s Primary pointer page: 270, Index root page: 271 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 30% 232s Primary pages: 1, secondary pages: 0, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 1 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index CHANGEX (2) 232s Root page: 303, depth: 1, leaf buckets: 1, nodes: 49 232s Average node length: 3.37, total dup: 46, max dup: 21 232s Average key length: 2.35, compression ratio: 2.98 232s Average prefix length: 6.69, average data length: 0.31 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN21 (1) 232s Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 232s Average node length: 4.12, total dup: 16, max dup: 2 232s Average key length: 3.10, compression ratio: 0.75 232s Average prefix length: 1.43, average data length: 0.90 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY20 (0) 232s Root page: 272, depth: 1, leaf buckets: 1, nodes: 49 232s Average node length: 22.29, total dup: 0, max dup: 0 232s Average key length: 21.27, compression ratio: 1.06 232s Average prefix length: 4.31, average data length: 18.29 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index UPDATERX (3) 232s Root page: 304, depth: 1, leaf buckets: 1, nodes: 49 232s Average node length: 3.35, total dup: 46, max dup: 28 232s Average key length: 2.29, compression ratio: 2.48 232s Average prefix length: 5.39, average data length: 0.29 232s Clustering factor: 1, ratio: 0.02 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s SALES (138) 232s Primary pointer page: 283, Index root page: 284 232s Pointer pages: 1, data page slots: 1 232s Data pages: 1, average fill: 35% 232s Primary pages: 1, secondary pages: 0, swept pages: 0 232s Empty pages: 0, full pages: 0 232s Fill distribution: 232s 0 - 19% = 0 232s 20 - 39% = 1 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index NEEDX (3) 232s Root page: 305, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 5.97, total dup: 11, max dup: 6 232s Average key length: 4.94, compression ratio: 1.10 232s Average prefix length: 2.88, average data length: 2.55 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index QTYX (4) 232s Root page: 306, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 5.06, total dup: 11, max dup: 3 232s Average key length: 4.03, compression ratio: 3.23 232s Average prefix length: 11.18, average data length: 1.85 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN25 (1) 232s Root page: 286, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 3.55, total dup: 18, max dup: 4 232s Average key length: 2.52, compression ratio: 1.19 232s Average prefix length: 2.48, average data length: 0.52 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$FOREIGN26 (2) 232s Root page: 287, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 3.67, total dup: 25, max dup: 7 232s Average key length: 2.64, compression ratio: 1.01 232s Average prefix length: 2.21, average data length: 0.45 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index RDB$PRIMARY24 (0) 232s Root page: 285, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 8.45, total dup: 0, max dup: 0 232s Average key length: 7.42, compression ratio: 1.08 232s Average prefix length: 3.52, average data length: 4.48 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Index SALESTATX (5) 232s Root page: 307, depth: 1, leaf buckets: 1, nodes: 33 232s Average node length: 4.06, total dup: 27, max dup: 14 232s Average key length: 3.03, compression ratio: 3.56 232s Average prefix length: 9.82, average data length: 0.97 232s Clustering factor: 1, ratio: 0.03 232s Fill distribution: 232s 0 - 19% = 1 232s 20 - 39% = 0 232s 40 - 59% = 0 232s 60 - 79% = 0 232s 80 - 99% = 0 232s 232s Gstat completion time Sat Feb 15 22:17:56 2025 232s 232s V: Running gfix -v 232s V: Some big math 233s create table tbl1(fld1 int128); 233s insert into tbl1 values(12345); 233s select * from tbl1; 233s 233s FLD1 233s ============================================= 233s 12345 233s 233s autopkgtest [22:17:57]: test assorted-tools: -----------------------] 234s assorted-tools PASS 234s autopkgtest [22:17:58]: test assorted-tools: - - - - - - - - - - results - - - - - - - - - - 235s autopkgtest [22:17:59]: @@@@@@@@@@@@@@@@@@@@ summary 235s assorted-tools PASS 253s nova [W] Using flock in prodstack6-arm64 253s Creating nova instance adt-plucky-arm64-firebird4.0-20250215-221403-juju-7f2275-prod-proposed-migration-environment-2-a3641233-e457-4104-b955-c5454b212631 from image adt/ubuntu-plucky-arm64-server-20250215.img (UUID 8f82fa69-4462-4e93-a46b-73be9ea2c381)... 253s nova [W] Timed out waiting for 6bdb45db-a198-4f71-a9d0-5484656093de to get deleted.