Source: postgresql-rum Version: 1.3.7-1 Severity: serious X-Debbugs-Cc: [email protected]
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
