ERROR: key.sk_strategy is unrecognized: "3 is an unknown ScanStrategy number"

[rcontesti]

What would you like to discuss?

Not sure what is going on.

I'm trying to do a BM25 search and getting a very strange error.

Query:

SELECT hash_name
FROM documents 
WHERE content @@@ '969284242400'
ORDER BY hash_name DESC;

Index:

SELECT name, field_type FROM paradedb.schema('documents_bm25_index');
    name     | field_type 
-------------+------------
 content     | Str
 context     | JsonObject
 ctid        | U64
 graph       | JsonObject
 hash_name   | Str
 identifiers | JsonObject
(6 rows)

error:

ERROR:  `key.sk_strategy` is unrecognized: "`3` is an unknown `ScanStrategy` number"

Full Name:

Ruben Contesti

Affiliation:

None

[rebasedming]

Did this happen after an upgrade? Make sure to restart Postgres after you upgrade.

[rcontesti]

I'm using the latest docker image every time I rebuild with docker-compose. I have restarted Postgres and I'm still getting the same result. Any clues what might be going one? I understand the 3 mentioned in the error is related to @@@.

[philippemnoel]

Are you using a Docker volume? If so, you need to manually upgrade and update the ParadeDB extension(s) version(s) inside it, as per: https://docs.paradedb.com/deploy/upgrading

Could you please provide the versions of ParadeDB and of the extensions?

[rcontesti]

Yes, I'm using a docker volume.

Allow me to share the versions I had

SELECT extversion FROM pg_extension WHERE extname = 'pg_search';
-- Get the version of pg_analytics
SELECT extversion FROM pg_extension WHERE extname = 'pg_analytics';
 extversion 
------------
 0.11.0
(1 row)

 extversion 
------------
 0.2.1
(1 row)

[rcontesti]

Issue solved after upgrading. Many thanks @philippemnoel !

[philippemnoel]

Yay!