Package: src:sqlreduce Version: 1.3-1 Severity: serious Tags: ftbfs forky sid
Dear maintainer: During a rebuild of all packages in unstable, this package failed to build. Below you will find the last part of the build log (probably the most relevant part, but not necessarily). If required, the full build log is available here: https://people.debian.org/~sanvila/build-logs/202511/ About the archive rebuild: The build was made on virtual machines from AWS, using sbuild and a reduced chroot with only build-essential packages. If you cannot reproduce the bug please contact me privately, as I am willing to provide ssh access to a virtual machine where the bug is fully reproducible. If this is really a bug in one of the build-depends, please use reassign and add an affects on src:sqlreduce, so that this is still visible in the BTS web page for this package. Thanks. -------------------------------------------------------------------------------- [...] debian/rules clean dh clean --with python3 --buildsystem=pybuild dh_auto_clean -O--buildsystem=pybuild I: pybuild base:311: python3.13 setup.py clean /usr/lib/python3/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated. !! ******************************************************************************** Please consider removing the following classifiers in favor of a SPDX license expression: License :: OSI Approved :: MIT License See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details. ******************************************************************************** [... snipped ...] ViewStmt: test: create view foo as select bar got: SELECT bar test: create view foo (n) as select 1, 2; select n = '' from foo got: CREATE VIEW foo (n) AS SELECT 2; SELECT n = '' FROM foo WindowDef: test: select count(*) over (partition by bar, foo) got: SELECT count(*) OVER (PARTITION BY bar) test: select count(*) over (order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) test: select count(*) over (partition by bar order by bar, foo) got: SELECT count(*) OVER (ORDER BY bar) WithClause: test: with recursive a(a) as (select 5), whatever as (select), b(b) as (select '') select a = b from a, b got: WITH a(a) AS (SELECT 5), b(b) AS (SELECT NULL) SELECT a = b FROM a, b XmlExpr: test: select xmlelement(name bar, moo) got: SELECT moo test: select xmlforest(foo, bar) got: SELECT foo XmlSerialize: test: SELECT xmlserialize(content moo as text) got: SELECT moo AlterDatabaseSetStmt: test: alter database foo reset all got: ALTER DATABASE foo RESET ALL AlterDefaultPrivilegesStmt: test: alter default privileges for role foo revoke delete on tables from bar got: ALTER DEFAULT PRIVILEGES FOR ROLE foo REVOKE DELETE ON TABLES FROM bar AlterDomainStmt: test: alter domain moo add check (value <> '') got: ALTER DOMAIN moo ADD CHECK (value <> '') AlterEventTrigStmt: test: alter event trigger foo disable got: ALTER EVENT TRIGGER foo DISABLE AlterFunctionStmt: test: alter function foo() strict got: ALTER FUNCTION foo () RETURNS NULL ON NULL INPUT AlterObjectSchemaStmt: test: alter table foo set schema bla got: ALTER TABLE foo SET SCHEMA bla AlterOwnerStmt: test: alter large object 42 owner to moo got: ALTER LARGE OBJECT 42 OWNER TO moo AlterRoleSetStmt: test: alter role foo reset all got: ALTER ROLE foo RESET ALL test: alter role foo in database bar reset all got: ALTER ROLE foo IN DATABASE bar RESET ALL AlterRoleStmt: test: alter role foo superuser got: ALTER ROLE foo SUPERUSER AlterSeqStmt: test: alter sequence foo restart 1 got: ALTER SEQUENCE foo RESTART WITH 1 AlterTableStmt: test: alter table foo drop column bar got: ALTER TABLE foo DROP COLUMN bar CommentStmt: test: comment on table foo is 'bar' got: COMMENT ON TABLE foo IS 'bar' CompositeTypeStmt: test: create type foo as (a text, b integer, c timestamp) got: CREATE TYPE foo AS (a text, b integer, c timestamp) CreateCastStmt: test: create cast (foo as bar) without function got: CREATE CAST (foo AS bar) WITHOUT FUNCTION CreateConversionStmt: test: create conversion foo for 'LATIN1' to 'UTF8' from iso8859_1_to_utf8 got: CREATE CONVERSION foo FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8 CreatedbStmt: test: create database foo got: CREATE DATABASE foo CreateDomainStmt: test: create domain foo as int not null got: CREATE DOMAIN foo AS integer NOT NULL CreateEnumStmt: test: create type foo as enum ('foo', 'bar') got: CREATE TYPE foo AS ENUM ('foo', 'bar') CreateEventTrigStmt: test: create event trigger foo on ddl_command_start execute function moo() got: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() CreateFdwStmt: test: create foreign data wrapper foo got: CREATE FOREIGN DATA WRAPPER foo CreateForeignServerStmt: test: create server bar foreign data wrapper foo got: CREATE SERVER bar FOREIGN DATA WRAPPER foo CreateForeignTableStmt: test: create foreign table foo (moo int not null) server bar got: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar CreateFunctionStmt: test: create function moo() returns void as $$ select 1 $$ language sql got: CREATE FUNCTION moo() RETURNS void AS $$ select 1 $$ LANGUAGE sql CreateRangeStmt: test: create type foo as range (subtype = bar) got: CREATE TYPE foo AS RANGE (subtype = bar) CreateOpClassStmt: test: create operator class foo for type bar using moo as storage bla got: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla CreatePublicationStmt: test: create publication foo got: CREATE PUBLICATION foo CreateRoleStmt: test: create role foo got: CREATE ROLE foo CreateSeqStmt: test: create sequence foo got: CREATE SEQUENCE foo CreateSubscriptionStmt: test: create subscription moo connection '' publication foo got: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo CreateTrigStmt: test: create trigger foo before insert on bar execute procedure moo() got: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() CreateUserMappingStmt: test: create user mapping for moo server bar got: CREATE USER MAPPING FOR moo SERVER bar DeallocateStmt: test: deallocate bar got: DEALLOCATE PREPARE bar DefineStmt: test: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') got: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') DiscardStmt: test: discard all got: DISCARD ALL DoStmt: test: do $$ begin end $$ got: DO $$ begin end $$ DropdbStmt: test: drop database foo got: DROP DATABASE foo DropOwnedStmt: test: drop owned by bar got: DROP OWNED BY bar RESTRICT DropRoleStmt: test: drop role moo got: DROP ROLE moo DropStmt: test: drop table foo got: DROP TABLE foo FetchStmt: test: fetch all in foo got: FETCH FORWARD ALL FROM foo GrantStmt: test: grant select on foo to bar got: GRANT SELECT ON TABLE foo TO bar IndexStmt: test: create index on foo(bar) got: CREATE INDEX ON foo (bar) LockStmt: test: lock foo got: LOCK foo IN ACCESS EXCLUSIVE MODE ParamRef: test: select $1 got: SELECT $1 RenameStmt: test: alter table foo rename to bar got: ALTER TABLE foo RENAME TO bar RuleStmt: test: create rule foo as on insert to moo do instead nothing got: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING TransactionStmt: test: begin got: BEGIN expect: BEGIN =========================== short test summary info ============================ FAILED tests/test_sqlreduce.py::test_rules - Exception: TransactionStmt test:... ========================= 1 failed, 2 passed in 6.15s ========================== E: pybuild pybuild:389: test: plugin distutils failed with: exit code=1: cd /<<PKGBUILDDIR>>/.pybuild/cpython3_3.13_sqlreduce/build; python3.13 -m pytest tests dh_auto_test: error: pybuild --test --test-pytest -i python{version} -p 3.13 returned exit code 13 *** /tmp/pg_virtualenv.Mrzv4V/log/postgresql-18-regress.log (last 100 lines) *** 2025-11-06 10:19:33.913 UTC [1117] sbuild@postgres ERROR: type "foo" does not exist 2025-11-06 10:19:33.913 UTC [1117] sbuild@postgres STATEMENT: CREATE CAST (foo AS bar) WITHOUT FUNCTION 2025-11-06 10:19:33.928 UTC [1120] sbuild@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-11-06 10:19:33.928 UTC [1120] sbuild@postgres STATEMENT: create database foo 2025-11-06 10:19:33.933 UTC [1121] sbuild@postgres ERROR: CREATE DATABASE cannot run inside a transaction block 2025-11-06 10:19:33.933 UTC [1121] sbuild@postgres STATEMENT: CREATE DATABASE foo 2025-11-06 10:19:33.958 UTC [1126] sbuild@postgres ERROR: function moo() does not exist 2025-11-06 10:19:33.958 UTC [1126] sbuild@postgres STATEMENT: create event trigger foo on ddl_command_start execute function moo() 2025-11-06 10:19:33.963 UTC [1127] sbuild@postgres ERROR: function moo() does not exist 2025-11-06 10:19:33.963 UTC [1127] sbuild@postgres STATEMENT: CREATE EVENT TRIGGER foo ON ddl_command_start EXECUTE PROCEDURE moo() 2025-11-06 10:19:33.977 UTC [1130] sbuild@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-11-06 10:19:33.977 UTC [1130] sbuild@postgres STATEMENT: create server bar foreign data wrapper foo 2025-11-06 10:19:33.982 UTC [1131] sbuild@postgres ERROR: foreign-data wrapper "foo" does not exist 2025-11-06 10:19:33.982 UTC [1131] sbuild@postgres STATEMENT: CREATE SERVER bar FOREIGN DATA WRAPPER foo 2025-11-06 10:19:33.987 UTC [1132] sbuild@postgres ERROR: server "bar" does not exist 2025-11-06 10:19:33.987 UTC [1132] sbuild@postgres STATEMENT: create foreign table foo (moo int not null) server bar 2025-11-06 10:19:33.992 UTC [1133] sbuild@postgres ERROR: server "bar" does not exist 2025-11-06 10:19:33.992 UTC [1133] sbuild@postgres STATEMENT: CREATE FOREIGN TABLE foo (moo integer NOT NULL) SERVER bar 2025-11-06 10:19:34.008 UTC [1136] sbuild@postgres ERROR: type "bar" does not exist 2025-11-06 10:19:34.008 UTC [1136] sbuild@postgres STATEMENT: create type foo as range (subtype = bar) 2025-11-06 10:19:34.012 UTC [1137] sbuild@postgres ERROR: type "bar" does not exist 2025-11-06 10:19:34.012 UTC [1137] sbuild@postgres STATEMENT: CREATE TYPE foo AS RANGE (subtype = bar) 2025-11-06 10:19:34.017 UTC [1138] sbuild@postgres ERROR: access method "moo" does not exist 2025-11-06 10:19:34.017 UTC [1138] sbuild@postgres STATEMENT: create operator class foo for type bar using moo as storage bla 2025-11-06 10:19:34.022 UTC [1139] sbuild@postgres ERROR: access method "moo" does not exist 2025-11-06 10:19:34.022 UTC [1139] sbuild@postgres STATEMENT: CREATE OPERATOR CLASS foo FOR TYPE bar USING moo AS STORAGE bla 2025-11-06 10:19:34.027 UTC [1140] sbuild@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-11-06 10:19:34.027 UTC [1140] sbuild@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-11-06 10:19:34.031 UTC [1141] sbuild@postgres WARNING: "wal_level" is insufficient to publish logical changes 2025-11-06 10:19:34.031 UTC [1141] sbuild@postgres HINT: Set "wal_level" to "logical" before creating subscriptions. 2025-11-06 10:19:34.057 UTC [1146] sbuild@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-11-06 10:19:34.057 UTC [1146] sbuild@postgres STATEMENT: create subscription moo connection '' publication foo 2025-11-06 10:19:34.061 UTC [1147] sbuild@postgres ERROR: CREATE SUBSCRIPTION ... WITH (create_slot = true) cannot run inside a transaction block 2025-11-06 10:19:34.061 UTC [1147] sbuild@postgres STATEMENT: CREATE SUBSCRIPTION moo CONNECTION '' PUBLICATION foo 2025-11-06 10:19:34.066 UTC [1148] sbuild@postgres ERROR: relation "bar" does not exist 2025-11-06 10:19:34.066 UTC [1148] sbuild@postgres STATEMENT: create trigger foo before insert on bar execute procedure moo() 2025-11-06 10:19:34.071 UTC [1149] sbuild@postgres ERROR: relation "bar" does not exist 2025-11-06 10:19:34.071 UTC [1149] sbuild@postgres STATEMENT: CREATE TRIGGER foo BEFORE INSERT ON bar FOR EACH STATEMENT EXECUTE PROCEDURE moo() 2025-11-06 10:19:34.076 UTC [1150] sbuild@postgres ERROR: role "moo" does not exist 2025-11-06 10:19:34.076 UTC [1150] sbuild@postgres STATEMENT: create user mapping for moo server bar 2025-11-06 10:19:34.080 UTC [1151] sbuild@postgres ERROR: role "moo" does not exist 2025-11-06 10:19:34.080 UTC [1151] sbuild@postgres STATEMENT: CREATE USER MAPPING FOR moo SERVER bar 2025-11-06 10:19:34.085 UTC [1152] sbuild@postgres ERROR: prepared statement "bar" does not exist 2025-11-06 10:19:34.085 UTC [1152] sbuild@postgres STATEMENT: deallocate bar 2025-11-06 10:19:34.089 UTC [1153] sbuild@postgres ERROR: prepared statement "bar" does not exist 2025-11-06 10:19:34.089 UTC [1153] sbuild@postgres STATEMENT: DEALLOCATE PREPARE bar 2025-11-06 10:19:34.094 UTC [1154] sbuild@postgres ERROR: function foo(integer[]) does not exist 2025-11-06 10:19:34.094 UTC [1154] sbuild@postgres STATEMENT: create aggregate moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-11-06 10:19:34.099 UTC [1155] sbuild@postgres ERROR: function foo(integer[]) does not exist 2025-11-06 10:19:34.099 UTC [1155] sbuild@postgres STATEMENT: CREATE AGGREGATE moo (*) (sfunc = foo, stype = int4[], finalfunc = bar, initcond = '{}') 2025-11-06 10:19:34.104 UTC [1156] sbuild@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-11-06 10:19:34.104 UTC [1156] sbuild@postgres STATEMENT: discard all 2025-11-06 10:19:34.108 UTC [1157] sbuild@postgres ERROR: DISCARD ALL cannot run inside a transaction block 2025-11-06 10:19:34.108 UTC [1157] sbuild@postgres STATEMENT: DISCARD ALL 2025-11-06 10:19:34.123 UTC [1160] sbuild@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-11-06 10:19:34.123 UTC [1160] sbuild@postgres STATEMENT: drop database foo 2025-11-06 10:19:34.128 UTC [1161] sbuild@postgres ERROR: DROP DATABASE cannot run inside a transaction block 2025-11-06 10:19:34.128 UTC [1161] sbuild@postgres STATEMENT: DROP DATABASE foo 2025-11-06 10:19:34.133 UTC [1162] sbuild@postgres ERROR: role "bar" does not exist 2025-11-06 10:19:34.133 UTC [1162] sbuild@postgres STATEMENT: drop owned by bar 2025-11-06 10:19:34.137 UTC [1163] sbuild@postgres ERROR: role "bar" does not exist 2025-11-06 10:19:34.137 UTC [1163] sbuild@postgres STATEMENT: DROP OWNED BY bar RESTRICT 2025-11-06 10:19:34.142 UTC [1164] sbuild@postgres ERROR: role "moo" does not exist 2025-11-06 10:19:34.142 UTC [1164] sbuild@postgres STATEMENT: drop role moo 2025-11-06 10:19:34.146 UTC [1165] sbuild@postgres ERROR: role "moo" does not exist 2025-11-06 10:19:34.146 UTC [1165] sbuild@postgres STATEMENT: DROP ROLE moo 2025-11-06 10:19:34.151 UTC [1166] sbuild@postgres ERROR: table "foo" does not exist 2025-11-06 10:19:34.151 UTC [1166] sbuild@postgres STATEMENT: drop table foo 2025-11-06 10:19:34.156 UTC [1167] sbuild@postgres ERROR: table "foo" does not exist 2025-11-06 10:19:34.156 UTC [1167] sbuild@postgres STATEMENT: DROP TABLE foo 2025-11-06 10:19:34.162 UTC [1168] sbuild@postgres ERROR: cursor "foo" does not exist 2025-11-06 10:19:34.162 UTC [1168] sbuild@postgres STATEMENT: fetch all in foo 2025-11-06 10:19:34.166 UTC [1169] sbuild@postgres ERROR: cursor "foo" does not exist 2025-11-06 10:19:34.166 UTC [1169] sbuild@postgres STATEMENT: FETCH FORWARD ALL FROM foo 2025-11-06 10:19:34.171 UTC [1170] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.171 UTC [1170] sbuild@postgres STATEMENT: grant select on foo to bar 2025-11-06 10:19:34.176 UTC [1171] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.176 UTC [1171] sbuild@postgres STATEMENT: GRANT SELECT ON TABLE foo TO bar 2025-11-06 10:19:34.182 UTC [1172] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.182 UTC [1172] sbuild@postgres STATEMENT: create index on foo(bar) 2025-11-06 10:19:34.187 UTC [1173] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.187 UTC [1173] sbuild@postgres STATEMENT: CREATE INDEX ON foo (bar) 2025-11-06 10:19:34.191 UTC [1174] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.191 UTC [1174] sbuild@postgres STATEMENT: lock foo 2025-11-06 10:19:34.196 UTC [1175] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.196 UTC [1175] sbuild@postgres STATEMENT: LOCK foo IN ACCESS EXCLUSIVE MODE 2025-11-06 10:19:34.201 UTC [1176] sbuild@postgres ERROR: there is no parameter $1 at character 8 2025-11-06 10:19:34.201 UTC [1176] sbuild@postgres STATEMENT: select $1 2025-11-06 10:19:34.207 UTC [1177] sbuild@postgres ERROR: there is no parameter $1 at character 8 2025-11-06 10:19:34.207 UTC [1177] sbuild@postgres STATEMENT: SELECT $1 2025-11-06 10:19:34.217 UTC [1179] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.217 UTC [1179] sbuild@postgres STATEMENT: alter table foo rename to bar 2025-11-06 10:19:34.221 UTC [1180] sbuild@postgres ERROR: relation "foo" does not exist 2025-11-06 10:19:34.221 UTC [1180] sbuild@postgres STATEMENT: ALTER TABLE foo RENAME TO bar 2025-11-06 10:19:34.226 UTC [1181] sbuild@postgres ERROR: relation "moo" does not exist 2025-11-06 10:19:34.226 UTC [1181] sbuild@postgres STATEMENT: create rule foo as on insert to moo do instead nothing 2025-11-06 10:19:34.231 UTC [1182] sbuild@postgres ERROR: relation "moo" does not exist 2025-11-06 10:19:34.231 UTC [1182] sbuild@postgres STATEMENT: CREATE RULE foo AS ON INSERT TO moo DO INSTEAD NOTHING 2025-11-06 10:19:34.235 UTC [1183] sbuild@postgres WARNING: there is already a transaction in progress 2025-11-06 10:19:34.240 UTC [1184] sbuild@postgres WARNING: there is already a transaction in progress Dropping cluster 18/regress ... make[1]: *** [debian/rules:8: override_dh_auto_test] Error 25 make[1]: Leaving directory '/<<PKGBUILDDIR>>' make: *** [debian/rules:21: binary] Error 2 dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2 --------------------------------------------------------------------------------
