0s autopkgtest [14:48:46]: starting date and time: 2024-11-15 14:48:46+0000 0s autopkgtest [14:48:46]: git checkout: 6f3be7a8 Fix armhf LXD image generation for plucky 0s autopkgtest [14:48:46]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.29kuazkr/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pg-catcheck --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.1-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-23.secgroup --name adt-plucky-amd64-pg-catcheck-20241115-144846-juju-7f2275-prod-proposed-migration-environment-15-9c28e173-ea9f-4d3b-b479-bb4b0c466b16 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -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'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 54s autopkgtest [14:49:40]: testbed dpkg architecture: amd64 54s autopkgtest [14:49:40]: testbed apt version: 2.9.8 54s autopkgtest [14:49:40]: @@@@@@@@@@@@@@@@@@@@ test bed setup 55s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 55s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [94.2 kB] 55s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [1062 kB] 55s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [7016 B] 55s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.5 kB] 55s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [174 kB] 55s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [108 kB] 55s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [32.6 kB] 55s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [840 kB] 55s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [300 kB] 55s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [9416 B] 55s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [740 B] 56s Fetched 2718 kB in 1s (3315 kB/s) 56s Reading package lists... 58s Reading package lists... 58s Building dependency tree... 58s Reading state information... 58s Calculating upgrade... 58s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 58s Reading package lists... 59s Building dependency tree... 59s Reading state information... 59s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 59s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 59s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 59s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 59s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 60s Reading package lists... 60s Reading package lists... 60s Building dependency tree... 60s Reading state information... 61s Calculating upgrade... 61s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 61s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s autopkgtest [14:49:50]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 64s autopkgtest [14:49:50]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-catcheck 65s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-catcheck 1.5.0-1 (dsc) [2140 B] 65s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-catcheck 1.5.0-1 (tar) [33.2 kB] 65s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-catcheck 1.5.0-1 (diff) [3108 B] 65s gpgv: Signature made Tue Sep 24 19:43:53 2024 UTC 65s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 65s gpgv: Can't check signature: No public key 65s dpkg-source: warning: cannot verify inline signature for ./pg-catcheck_1.5.0-1.dsc: no acceptable signature found 65s autopkgtest [14:49:51]: testing package pg-catcheck version 1.5.0-1 66s autopkgtest [14:49:52]: build not needed 66s autopkgtest [14:49:52]: test catcheck: preparing testbed 68s Reading package lists... 68s Building dependency tree... 68s Reading state information... 68s Starting pkgProblemResolver with broken count: 0 68s Starting 2 pkgProblemResolver with broken count: 0 68s Done 68s The following additional packages will be installed: 68s libjson-perl libpq5 libxslt1.1 postgresql-17 postgresql-17-pg-catcheck 68s postgresql-client-17 postgresql-client-common postgresql-common ssl-cert 68s Suggested packages: 68s postgresql-doc-17 68s Recommended packages: 68s libjson-xs-perl 68s The following NEW packages will be installed: 68s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql-17 68s postgresql-17-pg-catcheck postgresql-client-17 postgresql-client-common 68s postgresql-common ssl-cert 69s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 69s Need to get 18.6 MB/18.6 MB of archives. 69s After this operation, 55.4 MB of additional disk space will be used. 69s Get:1 /tmp/autopkgtest.6ME9ki/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [720 B] 69s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 69s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 69s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 69s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 69s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq5 amd64 17.1-1 [153 kB] 69s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 69s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-17 amd64 17.1-1 [1405 kB] 69s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-17 amd64 17.1-1 [16.5 MB] 70s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-pg-catcheck amd64 1.5.0-1 [38.4 kB] 70s Preconfiguring packages ... 70s Fetched 18.6 MB in 1s (17.6 MB/s) 70s Selecting previously unselected package libjson-perl. 70s (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 ... 75576 files and directories currently installed.) 70s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 70s Unpacking libjson-perl (4.10000-1) ... 70s Selecting previously unselected package postgresql-client-common. 70s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 70s Unpacking postgresql-client-common (262) ... 70s Selecting previously unselected package ssl-cert. 70s Preparing to unpack .../2-ssl-cert_1.1.2ubuntu2_all.deb ... 70s Unpacking ssl-cert (1.1.2ubuntu2) ... 70s Selecting previously unselected package postgresql-common. 70s Preparing to unpack .../3-postgresql-common_262_all.deb ... 70s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 70s Unpacking postgresql-common (262) ... 70s Selecting previously unselected package libpq5:amd64. 70s Preparing to unpack .../4-libpq5_17.1-1_amd64.deb ... 70s Unpacking libpq5:amd64 (17.1-1) ... 70s Selecting previously unselected package libxslt1.1:amd64. 70s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 70s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 70s Selecting previously unselected package postgresql-client-17. 70s Preparing to unpack .../6-postgresql-client-17_17.1-1_amd64.deb ... 70s Unpacking postgresql-client-17 (17.1-1) ... 70s Selecting previously unselected package postgresql-17. 70s Preparing to unpack .../7-postgresql-17_17.1-1_amd64.deb ... 70s Unpacking postgresql-17 (17.1-1) ... 71s Selecting previously unselected package postgresql-17-pg-catcheck. 71s Preparing to unpack .../8-postgresql-17-pg-catcheck_1.5.0-1_amd64.deb ... 71s Unpacking postgresql-17-pg-catcheck (1.5.0-1) ... 71s Selecting previously unselected package autopkgtest-satdep. 71s Preparing to unpack .../9-1-autopkgtest-satdep.deb ... 71s Unpacking autopkgtest-satdep (0) ... 71s Setting up postgresql-client-common (262) ... 71s Setting up libpq5:amd64 (17.1-1) ... 71s Setting up ssl-cert (1.1.2ubuntu2) ... 71s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 71s Setting up libjson-perl (4.10000-1) ... 71s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 71s Setting up postgresql-client-17 (17.1-1) ... 72s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 72s Setting up postgresql-common (262) ... 72s 72s Creating config file /etc/postgresql-common/createcluster.conf with new version 72s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 72s Removing obsolete dictionary files: 73s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 73s Setting up postgresql-17 (17.1-1) ... 73s Creating new PostgreSQL cluster 17/main ... 73s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 73s The files belonging to this database system will be owned by user "postgres". 73s This user must also own the server process. 73s 73s The database cluster will be initialized with locale "C.UTF-8". 73s The default database encoding has accordingly been set to "UTF8". 73s The default text search configuration will be set to "english". 73s 73s Data page checksums are disabled. 73s 73s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 73s creating subdirectories ... ok 73s selecting dynamic shared memory implementation ... posix 73s selecting default "max_connections" ... 100 73s selecting default "shared_buffers" ... 128MB 73s selecting default time zone ... Etc/UTC 73s creating configuration files ... ok 74s running bootstrap script ... ok 74s performing post-bootstrap initialization ... ok 74s syncing data to disk ... ok 77s Setting up postgresql-17-pg-catcheck (1.5.0-1) ... 77s Setting up autopkgtest-satdep (0) ... 77s Processing triggers for man-db (2.13.0-1) ... 78s Processing triggers for libc-bin (2.40-1ubuntu3) ... 80s (Reading database ... 77530 files and directories currently installed.) 80s Removing autopkgtest-satdep (0) ... 81s autopkgtest [14:50:07]: test catcheck: [----------------------- 81s + pg_buildext installed-versions 81s + pg_virtualenv -v 17 /usr/lib/postgresql/17/bin/pg_catcheck -v 81s Creating new PostgreSQL cluster 17/regress ... 84s verbose: detected server version 170001 84s verbose: detected PostgreSQL server 84s verbose: preloading table pg_authid because it is required in order to check pg_namespace 84s verbose: loading table pg_namespace 84s verbose: checking table pg_namespace (4 rows) 84s verbose: loading table pg_collation 84s verbose: checking table pg_collation (861 rows) 84s verbose: loading table pg_tablespace 84s verbose: checking table pg_tablespace (2 rows) 84s verbose: loading table pg_language 84s verbose: checking table pg_language (4 rows) 84s verbose: loading table pg_database 84s verbose: checking table pg_database (3 rows) 84s verbose: loading table pg_largeobject_metadata 84s verbose: checking table pg_largeobject_metadata (0 rows) 84s verbose: loading table pg_publication 84s verbose: checking table pg_publication (0 rows) 84s verbose: loading table pg_subscription 84s verbose: checking table pg_subscription (0 rows) 84s verbose: loading table pg_default_acl 84s verbose: checking table pg_default_acl (0 rows) 84s verbose: loading table pg_largeobject 84s verbose: checked table pg_largeobject (0 rows) 84s verbose: loading table pg_db_role_setting 84s verbose: checked table pg_db_role_setting (0 rows) 84s verbose: loading table pg_auth_members 84s verbose: checked table pg_auth_members (3 rows) 84s verbose: preloading table pg_class because it is required in order to check pg_type 84s verbose: loading table pg_type 84s verbose: checking table pg_type (617 rows) 84s verbose: loading table pg_proc 84s verbose: checking table pg_proc (3330 rows) 84s verbose: loading table pg_operator 84s verbose: checking table pg_operator (799 rows) 84s verbose: loading table pg_ts_parser 84s verbose: checking table pg_ts_parser (1 rows) 84s verbose: loading table pg_ts_config 84s verbose: checking table pg_ts_config (29 rows) 84s verbose: loading table pg_ts_template 84s verbose: checking table pg_ts_template (5 rows) 84s verbose: loading table pg_ts_dict 84s verbose: checking table pg_ts_dict (29 rows) 84s verbose: loading table pg_foreign_data_wrapper 84s verbose: checking table pg_foreign_data_wrapper (0 rows) 84s verbose: loading table pg_foreign_server 84s verbose: checking table pg_foreign_server (0 rows) 84s verbose: loading table pg_statistic_ext 84s verbose: checking table pg_statistic_ext (0 rows) 84s verbose: loading table pg_cast 84s verbose: checking table pg_cast (229 rows) 84s verbose: loading table pg_conversion 84s verbose: checking table pg_conversion (128 rows) 84s verbose: loading table pg_extension 84s verbose: checking table pg_extension (1 rows) 84s verbose: loading table pg_enum 84s verbose: checking table pg_enum (0 rows) 84s verbose: loading table pg_user_mapping 84s verbose: checking table pg_user_mapping (0 rows) 84s verbose: loading table pg_event_trigger 84s verbose: checking table pg_event_trigger (0 rows) 84s verbose: loading table pg_rewrite 84s verbose: checking table pg_rewrite (145 rows) 84s verbose: loading table pg_attrdef 84s verbose: checking table pg_attrdef (0 rows) 84s verbose: loading table pg_policy 84s verbose: checking table pg_policy (0 rows) 84s verbose: loading table pg_publication_rel 84s verbose: checking table pg_publication_rel (0 rows) 84s verbose: loading table pg_transform 84s verbose: checking table pg_transform (0 rows) 84s verbose: loading table pg_attribute 84s verbose: checking table pg_attribute (3126 rows) 84s verbose: loading table pg_foreign_table 84s verbose: checked table pg_foreign_table (0 rows) 84s verbose: loading table pg_inherits 84s verbose: checked table pg_inherits (0 rows) 84s verbose: loading table pg_aggregate 84s verbose: checked table pg_aggregate (157 rows) 84s verbose: loading table pg_ts_config_map 84s verbose: checked table pg_ts_config_map (551 rows) 84s verbose: loading table pg_statistic 84s verbose: checked table pg_statistic (410 rows) 84s verbose: loading table pg_init_privs 84s verbose: checked table pg_init_privs (223 rows) 84s verbose: loading table pg_sequence 84s verbose: checked table pg_sequence (0 rows) 84s verbose: loading table pg_subscription_rel 84s verbose: checked table pg_subscription_rel (0 rows) 84s verbose: loading table pg_statistic_ext_data 84s verbose: checked table pg_statistic_ext_data (0 rows) 84s verbose: preloading table pg_am because it is required in order to check pg_opfamily 84s verbose: loading table pg_opfamily 84s verbose: checking table pg_opfamily (146 rows) 84s verbose: checking table pg_class (415 rows) 84s verbose: loading table pg_opclass 84s verbose: checking table pg_opclass (177 rows) 84s verbose: loading table pg_amop 84s verbose: checking table pg_amop (945 rows) 84s verbose: loading table pg_amproc 84s verbose: checking table pg_amproc (696 rows) 84s verbose: loading table pg_index 84s verbose: checking table pg_index (164 rows) 84s verbose: loading table pg_constraint 84s verbose: checking table pg_constraint (112 rows) 84s verbose: loading table pg_trigger 84s verbose: checking table pg_trigger (0 rows) 84s verbose: loading table pg_range 84s verbose: checked table pg_range (6 rows) 84s verbose: loading table pg_depend 84s verbose: checked table pg_depend (1709 rows) 84s verbose: loading table pg_shdepend 84s verbose: checked table pg_shdepend (0 rows) 84s verbose: loading table pg_description 84s verbose: checked table pg_description (5268 rows) 84s verbose: loading table pg_shdescription 84s verbose: checked table pg_shdescription (3 rows) 84s verbose: loading table pg_seclabel 84s verbose: checked table pg_seclabel (0 rows) 84s verbose: loading table pg_shseclabel 84s verbose: checked table pg_shseclabel (0 rows) 84s verbose: loading table pg_partitioned_table 84s verbose: checked table pg_partitioned_table (0 rows) 84s progress: done (0 inconsistencies, 0 warnings, 0 errors) 84s Dropping cluster 17/regress ... 84s autopkgtest [14:50:10]: test catcheck: -----------------------] 85s autopkgtest [14:50:11]: test catcheck: - - - - - - - - - - results - - - - - - - - - - 85s catcheck PASS 85s autopkgtest [14:50:11]: @@@@@@@@@@@@@@@@@@@@ summary 85s catcheck PASS 98s nova [W] Skipping flock for amd64 98s Creating nova instance adt-plucky-amd64-pg-catcheck-20241115-144846-juju-7f2275-prod-proposed-migration-environment-15-9c28e173-ea9f-4d3b-b479-bb4b0c466b16 from image adt/ubuntu-plucky-amd64-server-20241115.img (UUID 9bb4dd9c-454f-45da-a125-77b9d27ed145)...