Source: postgresql-mysql-fdw Version: 2.7.0-1 X-Debbugs-CC: debian...@lists.debian.org Severity: serious User: debian...@lists.debian.org Usertags: regression
Dear maintainer(s),With a recent upload of postgresql-mysql-fdw the autopkgtest of postgresql-mysql-fdw fails in testing when that autopkgtest is run with the binary packages of postgresql-mysql-fdw from unstable. It passes when run with only packages from testing. In tabular form:
pass fail postgresql-mysql-fdw from testing 2.7.0-1 all others from testing from testing I copied some of the output at the bottom of this report.Currently this regression is blocking the migration to testing [1]. Can you please investigate the situation and fix it?
More information about this bug and the reason for filing it can be found on https://wiki.debian.org/ContinuousIntegration/RegressionEmailInformation Paul [1] https://qa.debian.org/excuses.php?package=postgresql-mysql-fdw https://ci.debian.net/data/autopkgtest/testing/i386/p/postgresql-mysql-fdw/17609222/log.gz == creating the MySQL test database -------------- CREATE DATABASE mysql_fdw_regress -------------- -------------- CREATE DATABASE mysql_fdw_regress1 -------------- -------------- CREATE USER 'edb'@'localhost' IDENTIFIED BY 'edb' -------------- -------------- GRANT ALL PRIVILEGES ON mysql_fdw_regress.* TO 'edb'@'localhost' -------------- -------------- GRANT ALL PRIVILEGES ON mysql_fdw_regress1.* TO 'edb'@'localhost' -------------- ### PostgreSQL 14 installcheck ### Creating new PostgreSQL cluster 14/regress .../usr/lib/postgresql/14/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/14/bin' --dbname=contrib_regression server_options connection_validation dml select pushdown join_pushdown aggregate_pushdown
(using postmaster on localhost, port 5433) ============== dropping database "contrib_regression" ============== NOTICE: database "contrib_regression" does not exist, skipping DROP DATABASE ============== creating database "contrib_regression" ============== CREATE DATABASE ALTER DATABASE ============== running regression test queries ============== test server_options ... ok 107 ms test connection_validation ... ok 70 ms test dml ... ok 132 ms test select ... ok 555 ms test pushdown ... ok 123 ms test join_pushdown ... ok 1620 ms test aggregate_pushdown ... FAILED 2824 ms ====================== 1 of 7 tests failed. ====================== The differences that caused some tests to fail can be viewed in thefile "/tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/regression.diffs". A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/regression.out".
make: *** [/usr/lib/postgresql/14/lib/pgxs/src/makefiles/pgxs.mk:433: installcheck] Error 1 *** /tmp/pg_virtualenv.joAylJ/log/postgresql-14-regress.log (last 100 lines) *** 2021-12-16 10:13:48.401 UTC [4153] LOG: starting PostgreSQL 14.1 (Debian 14.1-1) on i686-pc-linux-gnu, compiled by gcc (Debian 11.2.0-10) 11.2.0, 32-bit 2021-12-16 10:13:48.402 UTC [4153] LOG: listening on IPv6 address "::1", port 5433 2021-12-16 10:13:48.402 UTC [4153] LOG: listening on IPv4 address "127.0.0.1", port 5433 2021-12-16 10:13:48.402 UTC [4153] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5433" 2021-12-16 10:13:48.403 UTC [4154] LOG: database system was shut down at 2021-12-16 10:13:48 UTC 2021-12-16 10:13:48.407 UTC [4153] LOG: database system is ready to accept connections 2021-12-16 10:13:50.785 UTC [4205] postgres@contrib_regression WARNING: MySQL secure authentication is off 2021-12-16 10:13:50.791 UTC [4205] postgres@contrib_regression ERROR: "fetch_size" requires an integer value between 1 to 4294967295 2021-12-16 10:13:50.791 UTC [4205] postgres@contrib_regression STATEMENT: ALTER FOREIGN TABLE table30000 OPTIONS ( SET fetch_size '-60000'); 2021-12-16 10:13:50.792 UTC [4205] postgres@contrib_regression ERROR: "fetch_size" requires an integer value between 1 to 4294967295 2021-12-16 10:13:50.792 UTC [4205] postgres@contrib_regression STATEMENT: ALTER FOREIGN TABLE table30000 OPTIONS ( SET fetch_size '123abc'); 2021-12-16 10:13:50.792 UTC [4205] postgres@contrib_regression ERROR: "fetch_size" requires an integer value between 1 to 4294967295 2021-12-16 10:13:50.792 UTC [4205] postgres@contrib_regression STATEMENT: ALTER FOREIGN TABLE table30000 OPTIONS ( SET fetch_size '999999999999999999999'); 2021-12-16 10:13:50.794 UTC [4205] postgres@contrib_regression ERROR: reconnect requires a Boolean value 2021-12-16 10:13:50.794 UTC [4205] postgres@contrib_regression STATEMENT: ALTER SERVER reconnect1 OPTIONS ( SET reconnect 'abc1' ); 2021-12-16 10:13:50.950 UTC [4228] postgres@contrib_regression ERROR: first column of remote table must be unique for INSERT/UPDATE/DELETE operation 2021-12-16 10:13:50.950 UTC [4228] postgres@contrib_regression STATEMENT: INSERT INTO fdw126_ft3 VALUES(1, 'One'); 2021-12-16 10:13:50.952 UTC [4228] postgres@contrib_regression ERROR: first column of remote table must be unique for INSERT/UPDATE/DELETE operation 2021-12-16 10:13:50.952 UTC [4228] postgres@contrib_regression STATEMENT: UPDATE fdw126_ft3 SET b = 'one' WHERE a = 1; 2021-12-16 10:13:50.953 UTC [4228] postgres@contrib_regression ERROR: first column of remote table must be unique for INSERT/UPDATE/DELETE operation 2021-12-16 10:13:50.953 UTC [4228] postgres@contrib_regression STATEMENT: DELETE FROM fdw126_ft3 WHERE a = 1; 2021-12-16 10:13:50.954 UTC [4228] postgres@contrib_regression ERROR: relation mysql_fdw_regress1.nosuchtable does not exist 2021-12-16 10:13:50.954 UTC [4228] postgres@contrib_regression STATEMENT: ANALYZE fdw126_ft4; 2021-12-16 10:13:50.954 UTC [4228] postgres@contrib_regression ERROR: relation mysql_fdw_regress2.numbers does not exist 2021-12-16 10:13:50.954 UTC [4228] postgres@contrib_regression STATEMENT: ANALYZE fdw126_ft5; 2021-12-16 10:13:50.965 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot vacuum non-tables or special system tables 2021-12-16 10:13:50.965 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot vacuum non-tables or special system tables 2021-12-16 10:13:50.966 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot vacuum non-tables or special system tables 2021-12-16 10:13:50.966 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot analyze this foreign table 2021-12-16 10:13:50.967 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot analyze this foreign table 2021-12-16 10:13:50.967 UTC [4228] postgres@contrib_regression WARNING: skipping "f_empdata" --- cannot vacuum non-tables or special system tables 2021-12-16 10:13:50.975 UTC [4228] postgres@contrib_regression ERROR: row identifier column update is not supported 2021-12-16 10:13:50.975 UTC [4228] postgres@contrib_regression STATEMENT: UPDATE fdw126_ft1 SET stu_dept = 201, stu_id = 10 WHERE stu_id = 1; 2021-12-16 10:13:50.977 UTC [4228] postgres@contrib_regression ERROR: row identifier column update is not supported 2021-12-16 10:13:50.977 UTC [4228] postgres@contrib_regression STATEMENT: UPDATE fdw126_ft1 SET stu_dept = 301 WHERE stu_id = 1; 2021-12-16 10:13:50.986 UTC [4228] postgres@contrib_regression ERROR: row identifier column update is not supported 2021-12-16 10:13:50.986 UTC [4228] postgres@contrib_regression STATEMENT: UPDATE fdw193_ft1 SET stu_dept = 301 WHERE stu_id = 'aa'; 2021-12-16 10:13:50.988 UTC [4228] postgres@contrib_regression ERROR: row identifier column update is not supported 2021-12-16 10:13:50.988 UTC [4228] postgres@contrib_regression STATEMENT: UPDATE fdw193_ft1 SET stu_dept = 401 WHERE stu_id = 'aa'; 2021-12-16 10:13:50.988 UTC [4228] postgres@contrib_regression ERROR: cannot copy from foreign table "f_mysql_test" 2021-12-16 10:13:50.988 UTC [4228] postgres@contrib_regression HINT: Try the COPY (SELECT ...) TO variant. 2021-12-16 10:13:50.988 UTC [4228] postgres@contrib_regression STATEMENT: COPY f_mysql_test TO stdout; 2021-12-16 10:13:50.989 UTC [4228] postgres@contrib_regression ERROR: cannot copy from foreign table "f_mysql_test" 2021-12-16 10:13:50.989 UTC [4228] postgres@contrib_regression HINT: Try the COPY (SELECT ...) TO variant. 2021-12-16 10:13:50.989 UTC [4228] postgres@contrib_regression STATEMENT: COPY f_mysql_test (a) TO stdout; 2021-12-16 10:13:51.388 UTC [4237] postgres@contrib_regression ERROR: invalid reference to FROM-clause entry for table "t1" at character 88 2021-12-16 10:13:51.388 UTC [4237] postgres@contrib_regression DETAIL: The combining JOIN type must be INNER or LEFT for a LATERAL reference. 2021-12-16 10:13:51.388 UTC [4237] postgres@contrib_regression STATEMENT: SELECT t1.c1, t3.c1, t3.t1_c8 FROM f_test_tbl1 t1 RIGHT JOIN LATERAL (
SELECT t2.c1, t1.c8 AS t1_c8 FROM f_test_tbl2 t2) t3 ON t3.c1 = t3.t1_c8 ORDER BY 1, 2, 3;2021-12-16 10:13:51.421 UTC [4237] postgres@contrib_regression ERROR: invalid input value for enum size_t: "big" at character 34 2021-12-16 10:13:51.421 UTC [4237] postgres@contrib_regression STATEMENT: INSERT INTO f_enum_t1 VALUES (4, 'big'); 2021-12-16 10:13:51.476 UTC [4237] postgres@contrib_regression ERROR: system attribute "xmin" can't be fetched from remote relation 2021-12-16 10:13:51.476 UTC [4237] postgres@contrib_regression STATEMENT: SELECT xmin FROM f_test_tbl1; 2021-12-16 10:13:51.476 UTC [4237] postgres@contrib_regression ERROR: system attribute "ctid" can't be fetched from remote relation 2021-12-16 10:13:51.476 UTC [4237] postgres@contrib_regression STATEMENT: SELECT ctid, xmax, tableoid FROM f_test_tbl1; 2021-12-16 10:13:51.477 UTC [4237] postgres@contrib_regression ERROR: system attribute "xmax" can't be fetched from remote relation 2021-12-16 10:13:51.477 UTC [4237] postgres@contrib_regression STATEMENT: SELECT xmax, c1 FROM f_test_tbl1; 2021-12-16 10:13:51.477 UTC [4237] postgres@contrib_regression ERROR: system attribute "tableoid" can't be fetched from remote relation 2021-12-16 10:13:51.477 UTC [4237] postgres@contrib_regression STATEMENT: SELECT count(tableoid) FROM f_test_tbl1; 2021-12-16 10:13:51.504 UTC [4237] postgres@contrib_regression WARNING: skipping import for relation "test_set" 2021-12-16 10:13:51.504 UTC [4237] postgres@contrib_regression DETAIL: MySQL SET columns are not supported. 2021-12-16 10:13:54.618 UTC [4265] postgres@contrib_regression WARNING: failed to resolve name __mulodi4 2021-12-16 10:13:54.619 UTC [4265] postgres@contrib_regression ERROR: failed to look up symbol "evalexpr_19_0" 2021-12-16 10:13:54.619 UTC [4265] postgres@contrib_regression STATEMENT: SELECT sum(c2) * (random() <= 1)::int AS sum FROM fdw132_t1 ORDER BY 1;
Dropping cluster 14/regress ... **** regression.diffs ****diff -U3 /tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/expected/aggregate_pushdown.out /tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/results/aggregate_pushdown.out --- /tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/expected/aggregate_pushdown.out 2021-11-18 08:59:41.000000000 +0000 +++ /tmp/autopkgtest-lxc.r_7rxru0/downtmp/build.z8H/src/results/aggregate_pushdown.out 2021-12-16 10:13:56.127310576 +0000
@@ -629,11 +629,8 @@ (7 rows) SELECT sum(c2) * (random() <= 1)::int AS sum FROM fdw132_t1 ORDER BY 1; - sum ------ - 300 -(1 row) - +WARNING: failed to resolve name __mulodi4 +ERROR: failed to look up symbol "evalexpr_19_0" -- LATERAL join, with parameterization EXPLAIN (VERBOSE, COSTS OFF)SELECT c2, sum FROM fdw132_t1 t1, lateral (SELECT sum(t2.c1 + t1.c1) sum FROM fdw132_t2 t2 GROUP BY t2.c1) qry WHERE t1.c2 * 2 = qry.sum and t1.c2 > 10 ORDER BY 1;
### End 14 installcheck (FAILED with exit code 1) ### == dropping the MySQL test database -------------- DROP USER 'edb'@'localhost' -------------- -------------- DROP DATABASE mysql_fdw_regress -------------- -------------- DROP DATABASE mysql_fdw_regress1 -------------- autopkgtest [10:13:57]: test installcheck
OpenPGP_signature
Description: OpenPGP digital signature