Your message dated Fri, 20 Nov 2020 09:44:52 +0100 with message-id <20201120084452.ga783...@msg.df7cb.de> and subject line Re: Bug#974873: postgresql-rum: autopkgtest failure has caused the Debian Bug report #974873, regarding postgresql-rum: autopkgtest failure to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact ow...@bugs.debian.org immediately.) -- 974873: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=974873 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Re: To Sebastian Ramacher > > postgresql-rum is currently unable to migrate due to autopkgtest > > regressions on arm64 and ppc64el: > > | +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]. > > this is a transient problem because rum was compiled against the > postgresql 13.1 package in unstable which is using llvm 11 (bitcode > format 9), while PG 13.0 in testing is still using llvm 10 (bitcode > format 8). As soon as PG 13.1-1 enters testing (llvm 11 just entered, > but we are waiting for perl), this regression failure should resolve > itself. Now that 13.1 with llvm 11 is in testing, the tests in fact pass. Christoph
--- End Message ---
