0s autopkgtest [06:47:40]: starting date and time: 2025-02-22 06:47:40+0000 0s autopkgtest [06:47:40]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:47:40]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.nmx61uk8/out --timeout-copy=6000 -a i386 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade mimeo --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-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-22.secgroup --name adt-plucky-i386-mimeo-20250222-064740-juju-7f2275-prod-proposed-migration-environment-15-185b7639-434d-4b2f-b79b-5d49c3f39ee4 --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,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 166s autopkgtest [06:50:26]: testbed dpkg architecture: amd64 166s autopkgtest [06:50:26]: testbed apt version: 2.9.30ubuntu1 167s autopkgtest [06:50:27]: @@@@@@@@@@@@@@@@@@@@ test bed setup 167s autopkgtest [06:50:27]: testbed release detected to be: None 168s autopkgtest [06:50:28]: updating testbed package index (apt update) 168s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 168s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 168s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 168s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 168s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 168s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 168s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 168s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 169s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [129 kB] 169s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [98.8 kB] 169s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [7984 B] 169s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2412 B] 169s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [453 kB] 169s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [223 kB] 169s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [8844 B] 169s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [20.9 kB] 169s Fetched 1656 kB in 1s (1871 kB/s) 170s Reading package lists... 170s + lsb_release --codename --short 170s + RELEASE=plucky 170s + cat 170s + [ plucky != trusty ] 170s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 170s Reading package lists... 170s Building dependency tree... 170s Reading state information... 171s Calculating upgrade... 171s Calculating upgrade... 171s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 171s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 171s + /usr/lib/apt/apt-helper analyze-pattern ?true 171s + uname -r 171s + sed s/\./\\./g 171s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 171s + apt list ?obsolete 171s + tail -n+2 171s + cut -d/ -f1 171s + grep -v ^linux-.*6\.12\.0-15-generic.* 171s + true 171s + obsolete_pkgs= 171s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 171s Reading package lists... 171s Building dependency tree... 171s Reading state information... 172s Solving dependencies... 172s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 172s + grep -q trusty /etc/lsb-release 172s + [ ! -d /usr/share/doc/unattended-upgrades ] 172s + [ ! -d /usr/share/doc/lxd ] 172s + [ ! -d /usr/share/doc/lxd-client ] 172s + [ ! -d /usr/share/doc/snapd ] 172s + type iptables 172s + cat 172s + chmod 755 /etc/rc.local 172s + . /etc/rc.local 172s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 172s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 172s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 172s + uname -m 172s + [ x86_64 = ppc64le ] 172s + [ -d /run/systemd/system ] 172s + systemd-detect-virt --quiet --vm 172s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 172s + cat 172s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 172s + echo COMPRESS=lz4 172s autopkgtest [06:50:32]: upgrading testbed (apt dist-upgrade and autopurge) 172s Reading package lists... 172s Building dependency tree... 172s Reading state information... 173s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 173s Starting 2 pkgProblemResolver with broken count: 0 173s Done 173s Entering ResolveByKeep 173s 174s Calculating upgrade... 174s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 174s Reading package lists... 174s Building dependency tree... 174s Reading state information... 174s Starting pkgProblemResolver with broken count: 0 174s Starting 2 pkgProblemResolver with broken count: 0 174s Done 175s Solving dependencies... 175s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 177s autopkgtest [06:50:37]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Tue Feb 4 16:02:16 UTC 2025 177s autopkgtest [06:50:37]: @@@@@@@@@@@@@@@@@@@@ apt-source mimeo 179s Get:1 http://ftpmaster.internal/ubuntu plucky/universe mimeo 1.5.1-19 (dsc) [2076 B] 179s Get:2 http://ftpmaster.internal/ubuntu plucky/universe mimeo 1.5.1-19 (tar) [591 kB] 179s Get:3 http://ftpmaster.internal/ubuntu plucky/universe mimeo 1.5.1-19 (diff) [3632 B] 179s gpgv: Signature made Thu Sep 19 08:31:01 2024 UTC 179s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 179s gpgv: Can't check signature: No public key 179s dpkg-source: warning: cannot verify inline signature for ./mimeo_1.5.1-19.dsc: no acceptable signature found 179s autopkgtest [06:50:39]: testing package mimeo version 1.5.1-19 180s autopkgtest [06:50:40]: build not needed 180s autopkgtest [06:50:40]: test prove: preparing testbed 180s Reading package lists... 181s Building dependency tree... 181s Reading state information... 181s Starting pkgProblemResolver with broken count: 0 181s Starting 2 pkgProblemResolver with broken count: 0 181s Done 181s The following NEW packages will be installed: 181s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 181s libtap-parser-sourcehandler-pgtap-perl libxslt1.1 postgresql-17 181s postgresql-17-mimeo postgresql-17-pgtap postgresql-client-17 181s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 181s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 181s Need to get 49.4 MB of archives. 181s After this operation, 206 MB of additional disk space will be used. 181s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 182s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 273 [47.5 kB] 182s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 182s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 182s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common-dev all 273 [72.9 kB] 182s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 182s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 273 [101 kB] 182s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 libllvm20 amd64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [30.5 MB] 184s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpq5 amd64 17.4-1 [155 kB] 184s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 184s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 184s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 185s Get:13 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-mimeo all 1.5.1-19 [107 kB] 185s Get:14 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 185s Get:15 http://ftpmaster.internal/ubuntu plucky/universe amd64 libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 185s Preconfiguring packages ... 185s Fetched 49.4 MB in 3s (14.2 MB/s) 185s Selecting previously unselected package libjson-perl. 185s (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 ... 108975 files and directories currently installed.) 185s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 185s Unpacking libjson-perl (4.10000-1) ... 185s Selecting previously unselected package postgresql-client-common. 185s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 185s Unpacking postgresql-client-common (273) ... 185s Selecting previously unselected package libio-pty-perl. 185s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 185s Unpacking libio-pty-perl (1:1.20-1build3) ... 185s Selecting previously unselected package libipc-run-perl. 186s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 186s Unpacking libipc-run-perl (20231003.0-2) ... 186s Selecting previously unselected package postgresql-common-dev. 186s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 186s Unpacking postgresql-common-dev (273) ... 186s Selecting previously unselected package ssl-cert. 186s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 186s Unpacking ssl-cert (1.1.3ubuntu1) ... 186s Selecting previously unselected package postgresql-common. 186s Preparing to unpack .../06-postgresql-common_273_all.deb ... 186s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 186s Unpacking postgresql-common (273) ... 186s Selecting previously unselected package libllvm20:amd64. 186s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_amd64.deb ... 186s Unpacking libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 186s Selecting previously unselected package libpq5:amd64. 186s Preparing to unpack .../08-libpq5_17.4-1_amd64.deb ... 186s Unpacking libpq5:amd64 (17.4-1) ... 186s Selecting previously unselected package libxslt1.1:amd64. 186s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 186s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 186s Selecting previously unselected package postgresql-client-17. 186s Preparing to unpack .../10-postgresql-client-17_17.4-1_amd64.deb ... 186s Unpacking postgresql-client-17 (17.4-1) ... 186s Selecting previously unselected package postgresql-17. 186s Preparing to unpack .../11-postgresql-17_17.4-1_amd64.deb ... 186s Unpacking postgresql-17 (17.4-1) ... 187s Selecting previously unselected package postgresql-17-mimeo. 187s Preparing to unpack .../12-postgresql-17-mimeo_1.5.1-19_all.deb ... 187s Unpacking postgresql-17-mimeo (1.5.1-19) ... 187s Selecting previously unselected package postgresql-17-pgtap. 187s Preparing to unpack .../13-postgresql-17-pgtap_1.3.3-3_all.deb ... 187s Unpacking postgresql-17-pgtap (1.3.3-3) ... 187s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 187s Preparing to unpack .../14-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 187s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 187s Setting up postgresql-client-common (273) ... 187s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 187s Setting up libio-pty-perl (1:1.20-1build3) ... 187s Setting up libpq5:amd64 (17.4-1) ... 187s Setting up ssl-cert (1.1.3ubuntu1) ... 187s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 187s Setting up libllvm20:amd64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 187s Setting up libipc-run-perl (20231003.0-2) ... 187s Setting up libjson-perl (4.10000-1) ... 187s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 187s Setting up postgresql-common-dev (273) ... 187s Setting up postgresql-client-17 (17.4-1) ... 188s 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 188s Setting up postgresql-common (273) ... 188s Creating config file /etc/postgresql-common/createcluster.conf with new version 188s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 188s Removing obsolete dictionary files: 189s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 189s Setting up postgresql-17 (17.4-1) ... 190s Creating new PostgreSQL cluster 17/main ... 190s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 190s The files belonging to this database system will be owned by user "postgres". 190s This user must also own the server process. 190s 190s The database cluster will be initialized with locale "C.UTF-8". 190s The default database encoding has accordingly been set to "UTF8". 190s The default text search configuration will be set to "english". 190s 190s Data page checksums are disabled. 190s 190s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 190s creating subdirectories ... ok 190s selecting dynamic shared memory implementation ... posix 190s selecting default "max_connections" ... 100 190s selecting default "shared_buffers" ... 128MB 190s selecting default time zone ... Etc/UTC 190s creating configuration files ... ok 190s running bootstrap script ... ok 191s performing post-bootstrap initialization ... ok 191s syncing data to disk ... ok 193s Setting up postgresql-17-pgtap (1.3.3-3) ... 193s Setting up postgresql-17-mimeo (1.5.1-19) ... 193s Processing triggers for libc-bin (2.40-4ubuntu1) ... 193s Processing triggers for man-db (2.13.0-1) ... 197s autopkgtest [06:50:57]: testbed environment configured for cross-architecture building 197s autopkgtest [06:50:57]: test prove: [----------------------- 197s + service postgresql stop 197s + export TZ=UTC 197s + pg_buildext -o port=5432 virtualenv 197s ### PostgreSQL 17 virtualenv ### 197s Creating new PostgreSQL cluster 17/regress ... 200s + set -ex 200s + psql -Xc 'CREATE EXTENSION pgtap' 200s CREATE EXTENSION 200s + psql -Xc 'CREATE SCHEMA dblink' 200s CREATE SCHEMA 200s + psql -Xc 'CREATE EXTENSION dblink WITH SCHEMA dblink' 200s CREATE EXTENSION 200s + psql -Xc 'CREATE SCHEMA mimeo' 200s CREATE SCHEMA 200s + psql -Xc 'CREATE EXTENSION mimeo WITH SCHEMA mimeo' 201s CREATE EXTENSION 201s + pg_prove -v -f test/test01_setup.sql 201s Duplicate specification "psql-bin|b=s" for option "b" 201s Duplicate specification "host|h=s" for option "h" 201s Duplicate specification "port|p=s" for option "p" 201s Duplicate specification "pset|P=s%" for option "P" 201s Duplicate specification "schema|s=s" for option "s" 201s Duplicate specification "version|V" for option "version" 201s Duplicate specification "version|V" for option "V" 201s Duplicate specification "help|H|?" for option "help" 201s Duplicate specification "help|H|?" for option "H" 201s Duplicate specification "help|H|?" for option "?" 201s Duplicate specification "man|m" for option "man" 201s Duplicate specification "man|m" for option "m" 201s psql:test/test01_setup.sql:4: NOTICE: database "mimeo_source" does not exist, skipping 201s test/test01_setup.sql .. 201s mimeo, dblink, public 201s 1..7 201s ok 1 - Create mimeo test role 201s ok 2 - Create mimeo dumb role 201s ok 3 - Create mimeo dumber role to test nonstandard strings 201s ok 4 - Create test schema for default destination tables 201s ok 5 - Create test schema for named destination tables 201s ok 6 - Configure remote host for testing 201s ok 7 - Configure password for remote testing role 201s ok 201s All tests successful. 201s Files=1, Tests=7, 0 wallclock secs ( 0.02 usr 0.01 sys + 0.02 cusr 0.01 csys = 0.06 CPU) 201s Result: PASS 201s + pg_prove -v -f test/test02_setup_remote_tables.sql 201s Duplicate specification "psql-bin|b=s" for option "b" 201s Duplicate specification "host|h=s" for option "h" 201s Duplicate specification "port|p=s" for option "p" 201s Duplicate specification "pset|P=s%" for option "P" 201s Duplicate specification "schema|s=s" for option "s" 201s Duplicate specification "version|V" for option "version" 201s Duplicate specification "version|V" for option "V" 201s Duplicate specification "help|H|?" for option "help" 201s Duplicate specification "help|H|?" for option "H" 201s Duplicate specification "help|H|?" for option "?" 201s Duplicate specification "man|m" for option "man" 201s Duplicate specification "man|m" for option "m" 201s test/test02_setup_remote_tables.sql .. 201s mimeo, dblink, public 201s 1..2 201s OK 201s ok 1 - Remote database connection established 201s # Creating source schema & roles 201s CREATE SCHEMA 201s GRANT 201s GRANT 201s GRANT 201s CREATE SCHEMA 201s ALTER SCHEMA 201s # Creating source table: mimeo_source.snap_test_source 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s # Creating source table: mimeo_source.snap_test_source_empty 201s CREATE TABLE 201s # Creating source table: mimeo_source.snap_test_source_change_col 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s CREATE INDEX 201s # Creating source table: mimeo_source."Snap-test-Source" 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s # Creating source view: mimeo_source.snap_test_source_view 201s CREATE VIEW 201s # Creating source table: mimeo_source.inserter_test_source 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s # Creating source table: mimeo_source.inserter_test_source_empty 201s CREATE TABLE 201s # Creating source table: mimeo_source."Inserter-Test-Source" 201s CREATE TABLE 201s CREATE INDEX 201s INSERT 0 10000 201s # Creating source view: mimeo_source.inserter_test_source_view 201s CREATE VIEW 201s # Creating source table: mimeo_source.updater_test_source 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s CREATE INDEX 201s # Creating source table: mimeo_source.updater_test_source_empty 201s CREATE TABLE 201s # Creating source table: mimeo_source."Updater-Test-Source" 201s CREATE TABLE 201s CREATE INDEX 201s INSERT 0 10000 201s # Creating source view: mimeo_source.updater_test_source_view 201s CREATE VIEW 201s # Creating source table: mimeo_source.dml_test_source 201s CREATE TABLE 201s CREATE INDEX 201s INSERT 0 10000 201s # Creating source table: mimeo_source.dml_test_source2 201s CREATE TABLE 201s INSERT 0 10000 201s INSERT 0 1 201s INSERT 0 1 201s INSERT 0 1 201s GRANT 201s # Creating source table: mimeo_source.dml_test_source_nodata 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.dml_test_source_filter 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.dml_test_source_condition 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.dml_test_source_empty 201s CREATE TABLE 201s # Creating source table: mimeo_source.Dml-Test-Source 201s CREATE TABLE 201s CREATE INDEX 201s INSERT 0 10000 201s # Creating source table: mimeo_source.logdel_test_source 201s CREATE TABLE 201s INSERT 0 10000 201s CREATE INDEX 201s # Creating source table: mimeo_source.logdel_test_source2 201s CREATE TABLE 201s INSERT 0 10000 201s INSERT 0 1 201s INSERT 0 1 201s INSERT 0 1 201s GRANT 201s # Creating source table: mimeo_source.logdel_test_source_nodata 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.logdel_test_source_filter 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.logdel_test_source_condition 201s CREATE TABLE 201s INSERT 0 10000 201s # Creating source table: mimeo_source.logdel_test_source_empty 201s CREATE TABLE 201s # Creating source table: mimeo_source."LogDel-Test-Source" 201s CREATE TABLE 201s CREATE INDEX 201s INSERT 0 10000 201s # Setting source table privileges. 201s GRANT 201s GRANT 201s GRANT 201s OK 201s ok 2 - Completed remote table setup 201s ok 201s All tests successful. 201s Files=1, Tests=2, 0 wallclock secs ( 0.02 usr 0.01 sys + 0.03 cusr 0.01 csys = 0.07 CPU) 201s Result: PASS 201s + pg_prove -v -f test/test03_run_maker_functions.sql 201s Duplicate specification "psql-bin|b=s" for option "b" 201s Duplicate specification "host|h=s" for option "h" 201s Duplicate specification "port|p=s" for option "p" 201s Duplicate specification "pset|P=s%" for option "P" 201s Duplicate specification "schema|s=s" for option "s" 201s Duplicate specification "version|V" for option "version" 201s Duplicate specification "version|V" for option "V" 201s Duplicate specification "help|H|?" for option "help" 201s Duplicate specification "help|H|?" for option "H" 201s Duplicate specification "help|H|?" for option "?" 201s Duplicate specification "man|m" for option "man" 201s Duplicate specification "man|m" for option "m" 202s psql:test/test03_run_maker_functions.sql:9: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:9: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:9: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:11: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:11: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:11: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:13: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:13: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:13: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:15: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:15: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:15: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:17: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:17: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:17: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:19: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:19: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:19: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:21: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:21: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:21: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:23: NOTICE: attempting first snapshot 202s psql:test/test03_run_maker_functions.sql:23: NOTICE: attempting second snapshot 202s psql:test/test03_run_maker_functions.sql:23: NOTICE: Done 202s psql:test/test03_run_maker_functions.sql:32: NOTICE: attempting first snapshot 203s psql:test/test03_run_maker_functions.sql:32: NOTICE: attempting second snapshot 203s psql:test/test03_run_maker_functions.sql:32: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:44: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:44: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:46: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:48: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:48: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:50: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:50: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:52: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:52: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:54: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:54: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:56: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:56: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:64: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:66: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:68: NOTICE: Analyzing destination table... 203s psql:test/test03_run_maker_functions.sql:68: NOTICE: Getting the maximum destination timestamp... 203s psql:test/test03_run_maker_functions.sql:68: NOTICE: Done 203s psql:test/test03_run_maker_functions.sql:70: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:72: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:74: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:76: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:78: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:82: NOTICE: Pulling all data from source... 203s psql:test/test03_run_maker_functions.sql:84: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:86: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:90: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:92: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:94: NOTICE: Analyzing destination table... 204s psql:test/test03_run_maker_functions.sql:94: NOTICE: Getting the maximum destination timestamp... 204s psql:test/test03_run_maker_functions.sql:94: NOTICE: Done 204s psql:test/test03_run_maker_functions.sql:96: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:98: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:100: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:102: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:104: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:108: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:110: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:112: NOTICE: Pulling all data from source... 204s psql:test/test03_run_maker_functions.sql:116: NOTICE: Creating objects on source database (function, trigger & queue table)... 204s psql:test/test03_run_maker_functions.sql:116: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:118: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:118: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:122: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:122: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:124: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:124: NOTICE: Analyzing destination table... 205s psql:test/test03_run_maker_functions.sql:124: NOTICE: Done 205s psql:test/test03_run_maker_functions.sql:126: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:126: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:128: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:128: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:130: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:130: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:132: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:132: NOTICE: Pulling data from source... 205s psql:test/test03_run_maker_functions.sql:136: NOTICE: Inserting data into config table 205s psql:test/test03_run_maker_functions.sql:136: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:136: NOTICE: Pulling all data from source... 205s psql:test/test03_run_maker_functions.sql:138: NOTICE: Inserting data into config table 205s psql:test/test03_run_maker_functions.sql:138: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:138: NOTICE: Pulling all data from source... 205s psql:test/test03_run_maker_functions.sql:143: NOTICE: Inserting data into config table 205s psql:test/test03_run_maker_functions.sql:143: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:143: NOTICE: Pulling all data from source... 205s psql:test/test03_run_maker_functions.sql:145: NOTICE: Inserting data into config table 205s psql:test/test03_run_maker_functions.sql:145: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:145: NOTICE: Analyzing destination table... 205s psql:test/test03_run_maker_functions.sql:145: NOTICE: Done 205s psql:test/test03_run_maker_functions.sql:147: NOTICE: Inserting data into config table 205s psql:test/test03_run_maker_functions.sql:147: NOTICE: Creating objects on source database (function, trigger & queue table)... 205s psql:test/test03_run_maker_functions.sql:147: NOTICE: Pulling all data from source... 206s psql:test/test03_run_maker_functions.sql:149: NOTICE: Inserting data into config table 206s psql:test/test03_run_maker_functions.sql:149: NOTICE: Creating objects on source database (function, trigger & queue table)... 206s psql:test/test03_run_maker_functions.sql:149: NOTICE: Pulling all data from source... 206s psql:test/test03_run_maker_functions.sql:151: NOTICE: Inserting data into config table 206s psql:test/test03_run_maker_functions.sql:151: NOTICE: Creating objects on source database (function, trigger & queue table)... 206s psql:test/test03_run_maker_functions.sql:151: NOTICE: Pulling all data from source... 206s psql:test/test03_run_maker_functions.sql:153: NOTICE: Inserting data into config table 206s psql:test/test03_run_maker_functions.sql:153: NOTICE: Creating objects on source database (function, trigger & queue table)... 206s psql:test/test03_run_maker_functions.sql:153: NOTICE: Pulling all data from source... 246s test/test03_run_maker_functions.sql .. 246s mimeo, dblink, public 246s 1..1 246s # Running maker for destination: mimeo_source.snap_test_source 246s # Running maker for destination: mimeo_dest.snap_test_dest 246s # Running maker for destination: mimeo_dest.snap_test_dest_nodata 246s # Running maker for destination: mimeo_dest.snap_test_dest_filter 246s # Running maker for destination: mimeo_dest.snap_test_dest_condition 246s # Running maker for destination: mimeo_source.snap_test_source_empty 246s # Running maker for destination: mimeo_source.snap_test_source_change_col 246s # Running maker for destination: mimeo_source.snap_test_source_view 246s # Running maker for destination: mimeo_source.Snap-test-Source 246s # Running maker for destination: mimeo_dest.table_test_dest 246s # Running maker for destination: mimeo_dest.table_test_dest_nodata 246s # Running maker for destination: mimeo_dest.table_test_dest_filter 246s # Running maker for destination: mimeo_dest.table_test_dest_condition 246s # Running maker for destination: mimeo_dest.table_test_dest_empty 246s # Running maker for destination: mimeo_dest.Table-test-Source 246s # Running maker for destination: mimeo_dest.table_test_dest_view 246s # Running maker for destination: mimeo_source.inserter_test_source 246s # Running maker for destination: mimeo_dest.inserter_test_dest 246s # Running maker for destination: mimeo_dest.inserter_test_dest_nodata 246s # Running maker for destination: mimeo_dest.inserter_test_dest_filter 246s 246s # Running maker for destination: mimeo_dest.inserter_test_dest_condition 246s # Running maker for destination: mimeo_source.inserter_test_source_empty 246s # Running maker for destination: mimeo_source.Inserter-Test-Source 246s # Running maker for destination: mimeo_source.inserter_test_source_view 246s # Running maker for destination: mimeo_dest.inserter_test_dest_serial 246s # Running maker for destination: mimeo_dest.Inserter-Test-Source_Serial 246s # Running maker for destination: mimeo_dest.inserter_test_dest_serial_view 246s # Running maker for destination: mimeo_source.updater_test_source 246s # Running maker for destination: mimeo_dest.updater_test_dest 246s # Running maker for destination: mimeo_dest.updater_test_dest_nodata 246s # Running maker for destination: mimeo_dest.updater_test_dest_filter 246s # Running maker for destination: mimeo_dest.updater_test_dest_condition 246s # Running maker for destination: mimeo_source.updater_test_source_empty 246s # Running maker for destination: mimeo_source.Updater-Test-Source 246s # Running maker for destination: mimeo_source.updater_test_source_view 246s # Running maker for destination: mimeo_dest.updater_test_dest_serial 246s # Running maker for destination: mimeo_dest.Updater-Test-Source_Serial 246s # Running maker for destination: mimeo_dest.updater_test_dest_serial_view 246s # Running maker for destination: mimeo_source.dml_test_source 246s # Running maker for destination: mimeo_dest.dml_test_dest 246s # Running maker for destination: mimeo_dest.dml_test_dest_multi 246s # Running maker for destination: mimeo_dest.dml_test_dest_nodata 246s # Running maker for destination: mimeo_dest.dml_test_dest_filter 246s # Running maker for destination: mimeo_dest.dml_test_dest_condition 246s # Running maker for destination: mimeo_source.dml_test_source_empty 246s # Running maker for destination: mimeo_source.Dml-Test-Source 246s # Running maker for destination: mimeo_source.logdel_test_source 246s # Running maker for destination: mimeo_dest.logdel_test_dest 246s # Running maker for destination: mimeo_dest.logdel_test_dest_multi 246s # Running maker for destination: mimeo_dest.logdel_test_dest_nodata 246s # Running maker for destination: mimeo_dest.logdel_test_dest_filter 246s # Running maker for destination: mimeo_dest.logdel_test_dest_condition 246s # Running maker for destination: mimeo_source.logdel_test_source_empty 246s # Running maker for destination: mimeo_source.LogDel-Test-Source 246s ok 1 - Maker functions finished. Sleeping for 40 seconds to ensure gap for incremental tests... 246s ok 246s All tests successful. 246s Files=1, Tests=1, 45 wallclock secs ( 0.03 usr 0.00 sys + 0.03 cusr 0.01 csys = 0.07 CPU) 246s Result: PASS 246s + pg_prove -v -f test/test98_run_destroyer_functions.sql 246s Duplicate specification "psql-bin|b=s" for option "b" 246s Duplicate specification "host|h=s" for option "h" 246s Duplicate specification "port|p=s" for option "p" 246s Duplicate specification "pset|P=s%" for option "P" 246s Duplicate specification "schema|s=s" for option "s" 246s Duplicate specification "version|V" for option "version" 246s Duplicate specification "version|V" for option "V" 246s Duplicate specification "help|H|?" for option "help" 246s Duplicate specification "help|H|?" for option "H" 246s Duplicate specification "help|H|?" for option "?" 246s Duplicate specification "man|m" for option "man" 246s Duplicate specification "man|m" for option "m" 246s psql:test/test98_run_destroyer_functions.sql:12: NOTICE: Destination table NOT destroyed: mimeo_dest.snap_test_dest. Changed from a view into a plain table 246s psql:test/test98_run_destroyer_functions.sql:12: NOTICE: table "snap_test_dest_snap2" does not exist, skipping 246s psql:test/test98_run_destroyer_functions.sql:20: NOTICE: Destination table destroyed: mimeo_source.snap_test_source 246s psql:test/test98_run_destroyer_functions.sql:25: NOTICE: Destination table destroyed: mimeo_dest.snap_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:30: NOTICE: Destination table destroyed: mimeo_dest.snap_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:35: NOTICE: Destination table destroyed: mimeo_dest.snap_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:40: NOTICE: Destination table destroyed: mimeo_source.snap_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:45: NOTICE: Destination table destroyed: mimeo_dest.snap_test_dest_change_col 246s psql:test/test98_run_destroyer_functions.sql:50: NOTICE: Destination table NOT destroyed: mimeo_source.Snap-test-Source. Changed from a view into a plain table 246s psql:test/test98_run_destroyer_functions.sql:50: NOTICE: table "Snap-test-Source_snap2" does not exist, skipping 246s psql:test/test98_run_destroyer_functions.sql:58: NOTICE: Destination table destroyed: mimeo_source.snap_test_source_view 246s psql:test/test98_run_destroyer_functions.sql:64: NOTICE: Destination table NOT destroyed: mimeo_dest.table_test_dest 246s psql:test/test98_run_destroyer_functions.sql:69: NOTICE: Destination table destroyed: mimeo_dest.table_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:71: NOTICE: Destination table destroyed: mimeo_dest.table_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:73: NOTICE: Destination table destroyed: mimeo_dest.table_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:75: NOTICE: Destination table destroyed: mimeo_dest.table_test_dest_empty 246s psql:test/test98_run_destroyer_functions.sql:77: NOTICE: Destination table destroyed: mimeo_dest.Table-test-Source 246s psql:test/test98_run_destroyer_functions.sql:79: NOTICE: Destination table destroyed: mimeo_dest.table_test_dest_view 246s psql:test/test98_run_destroyer_functions.sql:84: NOTICE: Destination table NOT destroyed: mimeo_dest.inserter_test_dest 246s psql:test/test98_run_destroyer_functions.sql:89: NOTICE: Destination table destroyed: mimeo_source.inserter_test_source 246s psql:test/test98_run_destroyer_functions.sql:89: NOTICE: DROP TABLE IF EXISTS mimeo_source.inserter_test_source 246s psql:test/test98_run_destroyer_functions.sql:91: NOTICE: Destination table destroyed: mimeo_dest.inserter_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:91: NOTICE: DROP TABLE IF EXISTS mimeo_dest.inserter_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:93: NOTICE: Destination table destroyed: mimeo_dest.inserter_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:93: NOTICE: DROP TABLE IF EXISTS mimeo_dest.inserter_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:95: NOTICE: Destination table destroyed: mimeo_dest.inserter_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:95: NOTICE: DROP TABLE IF EXISTS mimeo_dest.inserter_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:97: NOTICE: Destination table destroyed: mimeo_source.inserter_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:97: NOTICE: DROP TABLE IF EXISTS mimeo_source.inserter_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:99: NOTICE: Destination table destroyed: mimeo_source.inserter_test_source_view 246s psql:test/test98_run_destroyer_functions.sql:99: NOTICE: DROP TABLE IF EXISTS mimeo_source.inserter_test_source_view 246s psql:test/test98_run_destroyer_functions.sql:102: NOTICE: Destination table NOT destroyed: mimeo_source.Inserter-Test-Source 246s psql:test/test98_run_destroyer_functions.sql:107: NOTICE: Destination table destroyed: mimeo_dest.inserter_test_dest_serial 246s psql:test/test98_run_destroyer_functions.sql:107: NOTICE: DROP TABLE IF EXISTS mimeo_dest.inserter_test_dest_serial 246s psql:test/test98_run_destroyer_functions.sql:109: NOTICE: Destination table destroyed: mimeo_dest.inserter_test_dest_serial_view 246s psql:test/test98_run_destroyer_functions.sql:109: NOTICE: DROP TABLE IF EXISTS mimeo_dest.inserter_test_dest_serial_view 246s psql:test/test98_run_destroyer_functions.sql:112: NOTICE: Destination table destroyed: mimeo_dest.Inserter-Test-Source_Serial 246s psql:test/test98_run_destroyer_functions.sql:112: NOTICE: DROP TABLE IF EXISTS mimeo_dest."Inserter-Test-Source_Serial" 246s psql:test/test98_run_destroyer_functions.sql:116: NOTICE: Destination table NOT destroyed: mimeo_dest.updater_test_dest 246s psql:test/test98_run_destroyer_functions.sql:121: NOTICE: Destination table destroyed: mimeo_source.updater_test_source 246s psql:test/test98_run_destroyer_functions.sql:121: NOTICE: DROP TABLE IF EXISTS mimeo_source.updater_test_source 246s psql:test/test98_run_destroyer_functions.sql:123: NOTICE: Destination table destroyed: mimeo_dest.updater_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:123: NOTICE: DROP TABLE IF EXISTS mimeo_dest.updater_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:125: NOTICE: Destination table destroyed: mimeo_dest.updater_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:125: NOTICE: DROP TABLE IF EXISTS mimeo_dest.updater_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:127: NOTICE: Destination table destroyed: mimeo_dest.updater_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:127: NOTICE: DROP TABLE IF EXISTS mimeo_dest.updater_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:129: NOTICE: Destination table destroyed: mimeo_source.updater_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:129: NOTICE: DROP TABLE IF EXISTS mimeo_source.updater_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:131: NOTICE: Destination table destroyed: mimeo_source.updater_test_source_view 246s psql:test/test98_run_destroyer_functions.sql:131: NOTICE: DROP TABLE IF EXISTS mimeo_source.updater_test_source_view 246s psql:test/test98_run_destroyer_functions.sql:134: NOTICE: Destination table NOT destroyed: mimeo_source.Updater-Test-Source 246s psql:test/test98_run_destroyer_functions.sql:139: NOTICE: Destination table destroyed: mimeo_dest.updater_test_dest_serial 246s psql:test/test98_run_destroyer_functions.sql:139: NOTICE: DROP TABLE IF EXISTS mimeo_dest.updater_test_dest_serial 246s psql:test/test98_run_destroyer_functions.sql:141: NOTICE: Destination table destroyed: mimeo_dest.updater_test_dest_serial_view 246s psql:test/test98_run_destroyer_functions.sql:141: NOTICE: DROP TABLE IF EXISTS mimeo_dest.updater_test_dest_serial_view 246s psql:test/test98_run_destroyer_functions.sql:143: NOTICE: Destination table destroyed: mimeo_dest.Updater-Test-Source_Serial 246s psql:test/test98_run_destroyer_functions.sql:143: NOTICE: DROP TABLE IF EXISTS mimeo_dest."Updater-Test-Source_Serial" 246s psql:test/test98_run_destroyer_functions.sql:158: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:158: NOTICE: Destination table NOT destroyed (if it existed): mimeo_dest.dml_test_dest 246s psql:test/test98_run_destroyer_functions.sql:158: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:158: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:163: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:163: NOTICE: Destination table destroyed: mimeo_dest.dml_test_dest_multi 246s psql:test/test98_run_destroyer_functions.sql:163: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:163: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:165: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:165: NOTICE: Destination table destroyed: mimeo_source.dml_test_source 246s psql:test/test98_run_destroyer_functions.sql:165: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:165: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:167: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:167: NOTICE: Destination table destroyed: mimeo_dest.dml_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:167: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:167: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:169: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:169: NOTICE: Destination table destroyed: mimeo_dest.dml_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:169: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:169: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:171: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:171: NOTICE: Destination table destroyed: mimeo_dest.dml_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:171: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:171: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:173: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:173: NOTICE: Destination table destroyed: mimeo_source.dml_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:173: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:173: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:175: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:175: NOTICE: Destination table destroyed: mimeo_source.Dml-Test-Source 246s psql:test/test98_run_destroyer_functions.sql:175: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:175: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:190: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:190: NOTICE: Destination table NOT destroyed (if it existed): mimeo_dest.logdel_test_dest 246s psql:test/test98_run_destroyer_functions.sql:190: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:190: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:195: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:195: NOTICE: Destination table destroyed: mimeo_dest.logdel_test_dest_multi 246s psql:test/test98_run_destroyer_functions.sql:195: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:195: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:197: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:197: NOTICE: Destination table destroyed: mimeo_source.logdel_test_source 246s psql:test/test98_run_destroyer_functions.sql:197: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:197: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:199: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:199: NOTICE: Destination table destroyed: mimeo_dest.logdel_test_dest_nodata 246s psql:test/test98_run_destroyer_functions.sql:199: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:199: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:201: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:201: NOTICE: Destination table destroyed: mimeo_dest.logdel_test_dest_filter 246s psql:test/test98_run_destroyer_functions.sql:201: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:201: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:203: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:203: NOTICE: Destination table destroyed: mimeo_dest.logdel_test_dest_condition 246s psql:test/test98_run_destroyer_functions.sql:203: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:203: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:205: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:205: NOTICE: Destination table destroyed: mimeo_source.logdel_test_source_empty 246s psql:test/test98_run_destroyer_functions.sql:205: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:205: NOTICE: Done 246s psql:test/test98_run_destroyer_functions.sql:207: NOTICE: Removing mimeo objects from source database if they exist (trigger, function, queue table) 246s psql:test/test98_run_destroyer_functions.sql:207: NOTICE: Destination table destroyed: mimeo_source.LogDel-Test-Source 246s psql:test/test98_run_destroyer_functions.sql:207: NOTICE: Removing config data 246s psql:test/test98_run_destroyer_functions.sql:207: NOTICE: Done 246s test/test98_run_destroyer_functions.sql .. 246s mimeo, dblink, public 246s 1..87 246s OK 246s ok 1 - Remote database connection established 246s ok 2 - Check snapshot_destroyer changed view into table: mimeo_dest.snap_test_dest 246s ok 3 - Check snapshot_destroyer dropped view: mimeo_dest.snap_test_dest 246s ok 4 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_snap1 246s ok 5 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_snap2 246s ok 6 - Check table dropped: mimeo_dest.snap_test_dest 246s ok 7 - Check snapshot_destroyer dropped view: mimeo_source.snap_test_source 246s ok 8 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_snap1 246s ok 9 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_snap2 246s ok 10 - Check snapshot_destroyer dropped view: mimeo_dest.snap_test_dest_nodata 246s ok 11 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_nodata_snap1 246s ok 12 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_nodata_snap2 246s ok 13 - Check snapshot_destroyer dropped view: mimeo_dest.snap_test_dest_filter 246s ok 14 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_filter_snap1 246s ok 15 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_filter_snap2 246s ok 16 - Check snapshot_destroyer dropped view: mimeo_dest.snap_test_dest_condition 246s ok 17 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_condition_snap1 246s ok 18 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_condition_snap2 246s ok 19 - Check snapshot_destroyer dropped view: mimeo_source.snap_test_source_empty 246s ok 20 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_empty_snap1 246s ok 21 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_empty_snap2 246s ok 22 - Check snapshot_destroyer dropped view: mimeo_dest.snap_test_dest_change_col 246s ok 23 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_change_col_snap1 246s ok 24 - Check snapshot_destroyer dropped table: mimeo_dest.snap_test_dest_change_col_snap2 246s ok 25 - Check snapshot_destroyer changed view into table: mimeo_source.Snap-test-Source 246s ok 26 - Check snapshot_destroyer dropped view: mimeo_source.Snap-test-Source 246s ok 27 - Check snapshot_destroyer dropped table: mimeo_source.Snap-test-Source_snap1 246s ok 28 - Check snapshot_destroyer dropped table: mimeo_source.Snap-test-Source_snap2 246s ok 29 - Check table dropped: mimeo_source.Snap-test-Source 246s ok 30 - Check snapshot_destroyer dropped view: mimeo_source.snap_test_source_view 246s ok 31 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_view_snap1 246s ok 32 - Check snapshot_destroyer dropped table: mimeo_source.snap_test_source_view_snap2 246s ok 33 - Check table_destroyer kept destination table: mimeo_dest.table_test_dest 246s ok 34 - Check table dropped: mimeo_dest.table_test_dest 246s ok 35 - Check table_destroyer dropped table: mimeo_dest.table_test_dest_nodata 246s ok 36 - Check table_destroyer dropped table: mimeo_dest.table_test_dest_filter 246s ok 37 - Check table_destroyer dropped table: mimeo_dest.table_test_dest_condition 246s ok 38 - Check table_destroyer dropped table: mimeo_dest.table_test_source_empty 246s ok 39 - Check table_destroyer dropped table: mimeo_dest.Table-test-Source 246s ok 40 - Check table dropped: mimeo_dest.table_test_dest_view 246s ok 41 - Check inserter_destroyer kept destination table: mimeo_dest.inserter_test_dest 246s ok 42 - Check table dropped: mimeo_dest.inserter_test_dest 246s ok 43 - Check inserter_destroyer dropped table: mimeo_source.inserter_test_source 246s ok 44 - Check inserter_destroyer dropped table: mimeo_dest.inserter_test_dest_nodata 246s ok 45 - Check inserter_destroyer dropped table: mimeo_dest.inserter_test_dest_filter 246s ok 46 - Check inserter_destroyer dropped table: mimeo_dest.inserter_test_dest_condition 246s ok 47 - Check inserter_destroyer dropped table: mimeo_source.inserter_test_source_empty 246s ok 48 - Check inserter_destroyer dropped table: mimeo_source.inserter_test_source_view 246s ok 49 - Check inserter_destroyer kept destination table: mimeo_source.Inserter-Test-Source 246s ok 50 - Check table dropped: mimeo_source.Inserter-Test-Source 246s ok 51 - Check inserter_destroyer dropped table: mimeo_source.inserter_test_dest_serial 246s ok 52 - Check inserter_destroyer dropped table: mimeo_source.inserter_test_dest_serial_view 246s ok 53 - Check inserter_destroyer dropped table: mimeo_dest.Inserter-Test-Source_Serial 246s ok 54 - Check updater_destroyer kept destination table: mimeo_dest.updater_test_dest 246s ok 55 - Check table dropped: mimeo_dest.updater_test_dest 246s ok 56 - Check updater_destroyer dropped table: mimeo_source.updater_test_source 246s ok 57 - Check updater_destroyer dropped table: mimeo_dest.updater_test_dest_nodata 246s ok 58 - Check updater_destroyer dropped table: mimeo_dest.updater_test_dest_filter 246s ok 59 - Check updater_destroyer dropped table: mimeo_dest.updater_test_dest_condition 246s ok 60 - Check updater_destroyer dropped table: mimeo_source.updater_test_source_empty 246s ok 61 - Check updater_destroyer dropped table: mimeo_source.updater_test_source_view 246s ok 62 - Check updater_destroyer kept destination table: mimeo_source.Updater-Test-Source 246s ok 63 - Check table dropped: mimeo_source.Updater-Test-Source 246s ok 64 - Check updater_destroyer dropped table: mimeo_dest.updater_test_dest_serial 246s ok 65 - Check updater_destroyer dropped table: mimeo_dest.updater_test_dest_serial_view 246s ok 66 - Check updater_destroyer dropped table: mimeo_dest.Updater-Test-Source_Serial 246s ok 67 - Testing that error is thrown if mimeo does not own source table on dml_destroyer() call 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ok 68 - Check dml_destroyer kept destination table: mimeo_dest.dml_test_dest 246s ok 69 - Check table dropped: mimeo_dest.dml_test_dest 246s ok 70 - Check dml_destroyer dropped table: mimeo_dest.dml_test_dest_multi 246s ok 71 - Check dml_destroyer dropped table: mimeo_source.dml_test_source 246s ok 72 - Check dml_destroyer dropped table: mimeo_dest.dml_test_dest_nodata 246s ok 73 - Check dml_destroyer dropped table: mimeo_dest.dml_test_dest_filter 246s ok 74 - Check dml_destroyer dropped table: mimeo_dest.dml_test_dest_condition 246s ok 75 - Check dml_destroyer dropped table: mimeo_source.dml_test_source_empty 246s ok 76 - Check dml_destroyer dropped table: mimeo_source.Dml-Test-Source 246s ok 77 - Testing that error is thrown if mimeo does not own source table on logdel_destroyer() call 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ALTER TABLE 246s ok 78 - Check logdel_destroyer kept destination table: mimeo_dest.logdel_test_dest 246s ok 79 - Check table dropped: mimeo_dest.logdel_test_dest 246s ok 80 - Check logdel_destroyer dropped table: mimeo_dest.logdel_test_dest_multi 246s ok 81 - Check logdel_destroyer dropped table: mimeo_source.logdel_test_source 246s ok 82 - Check logdel_destroyer dropped table: mimeo_dest.logdel_test_dest_nodata 246s ok 83 - Check logdel_destroyer dropped table: mimeo_dest.logdel_test_dest_filter 246s ok 84 - Check logdel_destroyer dropped table: mimeo_dest.logdel_test_dest_condition 246s ok 85 - Check logdel_destroyer dropped table: mimeo_source.logdel_test_source_empty 246s ok 86 - Check logdel_destroyer dropped table: mimeo_source.LogDel-Test-Source 246s ok 87 - Checking that test config data has been cleared from refresh.config 246s ok 246s All tests successful. 246s Files=1, Tests=87, 0 wallclock secs ( 0.04 usr 0.00 sys + 0.03 cusr 0.01 csys = 0.08 CPU) 246s Result: PASS 246s + pg_prove -v -f test/test99_cleanup.sql 246s Duplicate specification "psql-bin|b=s" for option "b" 246s Duplicate specification "host|h=s" for option "h" 246s Duplicate specification "port|p=s" for option "p" 246s Duplicate specification "pset|P=s%" for option "P" 246s Duplicate specification "schema|s=s" for option "s" 246s Duplicate specification "version|V" for option "version" 246s Duplicate specification "version|V" for option "V" 246s Duplicate specification "help|H|?" for option "help" 246s Duplicate specification "help|H|?" for option "H" 246s Duplicate specification "help|H|?" for option "?" 246s Duplicate specification "man|m" for option "man" 246s Duplicate specification "man|m" for option "m" 247s psql:test/test99_cleanup.sql:9: NOTICE: drop cascades to 2 other objects 247s DETAIL: drop cascades to sequence mimeo_dest.col1_seq 247s drop cascades to sequence mimeo_dest."PRIMARY-seq" 247s test/test99_cleanup.sql .. 247s mimeo, dblink, public 247s 1..7 247s ok 1 - Cleanup schema 'mimeo_source' 247s ok 2 - Cleanup schema 'mimeo_dest' 247s ok 3 - Cleanup mimeo_test role from dblink_mapping_mimeo 247s ok 4 - Drop 'mimeo_owner' role 247s ok 5 - Drop 'mimeo_test' role 247s ok 6 - Drop 'mimeo_dumb_role' role 247s ok 7 - Drop 'mimeo-dumb-role' role 247s ok 247s All tests successful. 247s Files=1, Tests=7, 1 wallclock secs ( 0.01 usr 0.01 sys + 0.02 cusr 0.01 csys = 0.05 CPU) 247s Result: PASS 247s Dropping cluster 17/regress ... 247s ### End 17 virtualenv ### 247s autopkgtest [06:51:47]: test prove: -----------------------] 248s autopkgtest [06:51:48]: test prove: - - - - - - - - - - results - - - - - - - - - - 248s prove PASS 248s autopkgtest [06:51:48]: @@@@@@@@@@@@@@@@@@@@ summary 248s prove PASS 478s nova [W] Skipping flock for amd64 478s Creating nova instance adt-plucky-i386-mimeo-20250222-064740-juju-7f2275-prod-proposed-migration-environment-15-185b7639-434d-4b2f-b79b-5d49c3f39ee4 from image adt/ubuntu-plucky-amd64-server-20250222.img (UUID 16f5f362-6b73-4ce4-aa83-c13d69c08def)... 478s nova [W] Timed out waiting for b43e430c-5b2c-44d0-8f0e-1a87bf51e79a to get deleted.