Source: postgresql-rum Version: 1.3.7-1 Severity: serious X-Debbugs-Cc: sramac...@debian.org
postgresql-rum is currently unable to migrate due to autopkgtest regressions on arm64 and ppc64el: | --- Test multicolumn index | -RESET enable_indexscan; | -RESET enable_indexonlyscan; | -RESET enable_bitmapscan; | -SET enable_seqscan = off; | -DROP INDEX tstsh_idx; | -CREATE INDEX tstsh_id_idx ON tsts USING rum (t rum_tsvector_addon_ops, id, d) | - WITH (attach = 'd', to = 't'); | -EXPLAIN (costs off) | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | - QUERY PLAN | ------------------------------------------------------------------------------------ | - Limit | - -> Index Scan using tstsh_id_idx on tsts | - Index Cond: ((t @@ '''wr'' & ''qh'''::tsquery) AND (id = 1)) | - Order By: (d <=> 'Mon May 16 14:21:25 2016'::timestamp without time zone) | -(4 rows) | - | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 1::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | -ERROR: doesn't support order by over pass-by-reference column | -EXPLAIN (costs off) | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | - QUERY PLAN | ------------------------------------------------------------------------------------ | - Limit | - -> Index Scan using tstsh_id_idx on tsts | - Index Cond: ((t @@ '''wr'' & ''qh'''::tsquery) AND (id = 355)) | - Order By: (d <=> 'Mon May 16 14:21:25 2016'::timestamp without time zone) | -(4 rows) | - | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND id = 355::int ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | -ERROR: doesn't support order by over pass-by-reference column | -EXPLAIN (costs off) | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | - QUERY PLAN | ----------------------------------------------------------------------------------------------------------------------------------- | - Limit | - -> Index Scan using tstsh_id_idx on tsts | - Index Cond: ((t @@ '''wr'' & ''qh'''::tsquery) AND (d = 'Wed May 11 11:21:22.326724 2016'::timestamp without time zone)) | - Order By: (d <=> 'Mon May 16 14:21:25 2016'::timestamp without time zone) | -(4 rows) | - | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2016-05-11 11:21:22.326724'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | -ERROR: doesn't support order by over pass-by-reference column | -EXPLAIN (costs off) | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | - QUERY PLAN | ---------------------------------------------------------------------------------------------------------------------------- | - Limit | - -> Index Scan using tstsh_id_idx on tsts | - Index Cond: ((t @@ '''wr'' & ''qh'''::tsquery) AND (d = 'Mon May 01 00:00:00 2000'::timestamp without time zone)) | - Order By: (d <=> 'Mon May 16 14:21:25 2016'::timestamp without time zone) | -(4 rows) | - | -SELECT id, d FROM tsts WHERE t @@ 'wr&qh' AND d = '2000-05-01'::timestamp ORDER BY d <=> '2016-05-16 14:21:25' LIMIT 5; | -ERROR: doesn't support order by over pass-by-reference column | +FATAL: failed to load summary "/usr/lib/postgresql/13/lib/bitcode/rum.index.bc": Invalid summary version 9. Version should be in the range [1-8]. | +server closed the connection unexpectedly | + This probably means the server terminated abnormally | + before or while processing the request. | +connection to server was lost https://ci.debian.net/data/autopkgtest/testing/arm64/p/postgresql-rum/8183353/log.gz And also on i386 and armhf: | -EXPLAIN (costs off) | -SELECT id FROM test_int8_h_a WHERE t @@ 'wr&qh' AND id >= 400::int8 ORDER BY id; | - QUERY PLAN | -------------------------------------------------------------------------------- | - Sort | - Sort Key: id | - -> Seq Scan on test_int8_h_a | - Filter: ((t @@ '''wr'' & ''qh'''::tsquery) AND (id >= '400'::bigint)) | -(4 rows) | - | -SELECT id FROM test_int8_h_a WHERE t @@ 'wr&qh' AND id >= 400::int8 ORDER BY id; | - id | ------ | - 406 | - 415 | - 428 | - 457 | - 458 | - 484 | - 496 | -(7 rows) | - | -CREATE TABLE test_int8_id_t AS SELECT id::int8, t FROM tsts; | -CREATE INDEX test_int8_id_t_idx ON test_int8_o USING rum | - (t rum_tsvector_ops, id); | -EXPLAIN (costs off) | -SELECT id FROM test_int8_h_a WHERE t @@ 'wr&qh' AND id <= 400::int8 ORDER BY id <=> 400::int8; | - QUERY PLAN | -------------------------------------------------------------------------------- | - Sort | - Sort Key: ((id <=> '400'::bigint)) | - -> Seq Scan on test_int8_h_a | - Filter: ((t @@ '''wr'' & ''qh'''::tsquery) AND (id <= '400'::bigint)) | -(4 rows) | - | -SELECT id FROM test_int8_h_a WHERE t @@ 'wr&qh' AND id <= 400::int8 ORDER BY id <=> 400::int8; | - id | ------ | - 371 | - 355 | - 354 | - 252 | - 232 | - 168 | - 135 | - 71 | - 39 | - 16 | -(10 rows) | - | +FATAL: failed to load summary "/usr/lib/postgresql/13/lib/bitcode/rum.index.bc": Invalid summary version 9. Version should be in the range [1-8]. | +server closed the connection unexpectedly | + This probably means the server terminated abnormally | + before or while processing the request. | +connection to server was lost https://ci.debian.net/data/autopkgtest/testing/i386/p/postgresql-rum/8151790/log.gz Cheers -- Sebastian Ramacher
signature.asc
Description: PGP signature