Couldn't connect worker stream

[shah-aadil]

I am using postgres 17, on my local dev mac 15 os machine, installed using homebrew. I followed this blog post

when i execute this part i get the error:

with chunks as (
  select id, unnest(
      rag_bge_small_en_v15.chunks_by_token_count(fulltext, 192, 8)
    ) as chunk
  from docs
)
insert into embeddings (doc_id, chunk, embedding) (
  select id, chunk, 
    rag_bge_small_en_v15.embedding_for_passage(chunk) 
  from chunks
);

ERROR: [rag_bge_small_en_v15] Couldn't connect worker stream /tmp/.s.pgrag.rag_bge_small_en_v15.50413: No such file or directory (os error 2)

i tried a simplified version:

SELECT rag_bge_small_en_v15.embedding_for_passage('test text');

ERROR: [rag_bge_small_en_v15] Couldn't connect worker stream /tmp/.s.pgrag.rag_bge_small_en_v15.50361: No such file or directory (os error 2)
CONTEXT: SQL function "embedding_for_passage" statement 1

airag=# \dx
List of installed extensions
Name | Version | Schema | Description
------------------------------+---------+------------+-------------------------------------------------------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
rag | 0.0.0 | public | Tools to support Retrieval-Augmented Generation: https://github.com/neondatabase-labs/pgrag
rag_bge_small_en_v15 | 0.0.0 | public | In-database embeddings generation using model bge-small-en-v1.5: https://github.com/neondatabase-labs/pgrag
rag_jina_reranker_v1_tiny_en | 0.0.0 | public | In-database reranking using model jina-reranker-v1-tiny-en: https://github.com/neondatabase-labs/pgrag
vector | 0.8.0 | public | vector data type and ivfflat and hnsw access methods
(5 rows)

restarted postgres also, didn't help.

[jawj]

Thanks for the report. For completeness, which version of Postgres is it (the second digit has gone missing above)?

I developed the extension on a Mac, so certainly it ought to work there. First thing that occurs to me is that I think I've assumed a /tmp directory exists. Could you check whether you do have an existing /tmp directory and, if not, whether creating one fixes the problem?

[shah-aadil]

Ah i have missed the second digit 😁. i should edit that first. Thank you for replying and pointing that out. postgres version is 17.2 to be specific. yes I can confirm that /tmp directory exists.

[jawj]

Sorry for the delay. Are you still having this issue?