You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
When I upgrade Appflowy-Cloud from 0.4.x to 0.5.3
I already pull new docker image and git pull repository.
run docker compose up -d to recreate container.
appflowy_cloud log
Error: Failed to initialize application state: Failed to run migrations: while executing migrations: error returned from database: extension "vector" is not available
postgres log
2024-06-04 09:06:22.439 UTC [42] ERROR: extension "vector" is not available
2024-06-04 09:06:22.439 UTC [42] DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/vector.control": No such file or directory.
2024-06-04 09:06:22.439 UTC [42] HINT: The extension must first be installed on the system where PostgreSQL is running.
2024-06-04 09:06:22.439 UTC [42] STATEMENT: -- Add migration script here
CREATE EXTENSION IF NOT EXISTS vector;
-- create table to store collab embeddings
CREATE TABLE IF NOT EXISTS af_collab_embeddings
(
fragment_id TEXT NOT NULL PRIMARY KEY,
oid TEXT NOT NULL,
partition_key INTEGER NOT NULL,
content_type INTEGER NOT NULL,
indexed_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT (NOW()),
content TEXT,
embedding VECTOR(1536),
FOREIGN KEY (oid, partition_key) REFERENCES af_collab (oid, partition_key) ON DELETE CASCADE
);
CREATE INDEX IF NOT EXISTS af_collab_embeddings_similarity_idx ON af_collab_embeddings USING hnsw (embedding vector_cosine_ops);
2024-06-04 09:06:22.439 UTC [42] LOG: could not receive data from client: Connection reset by peer
It possable miss the "pgvector" extension, but I don't have any idea how to install the extension for postgres.
Screenshots
Server :
OS: DSM(Synology NAS)
Version: 7.2
Docker version: Docker version 20.10.23, build 876964a
The text was updated successfully, but these errors were encountered:
oh, It my bad
I forgot build the postgres image.
It possable that build a postgres image for NAS mechine, that NAS can pull the image to start postgres without build.
Describe the bug
When I upgrade Appflowy-Cloud from 0.4.x to 0.5.3
I already pull new docker image and git pull repository.
run
docker compose up -d
to recreate container.appflowy_cloud log
postgres log
It possable miss the "pgvector" extension, but I don't have any idea how to install the extension for postgres.
Screenshots
![image](https://private-user-images.githubusercontent.com/12424898/336389047-345ea0fc-a02b-4750-a4e6-15f08878aa61.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3MDI3NDUsIm5iZiI6MTcxOTcwMjQ0NSwicGF0aCI6Ii8xMjQyNDg5OC8zMzYzODkwNDctMzQ1ZWEwZmMtYTAyYi00NzUwLWE0ZTYtMTVmMDg4NzhhYTYxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjI5VDIzMDcyNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWQ4YTM2NTU4ZGRmNTAzZjE1M2JkMzQ3NWU5NDQxMTU0MDk5ZGI4MmQ1Y2Q3NjZmNDU3ZDE0OTUyZGVhZjAzZTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.64sGbkhKBm7t8ktIXETBsm-ZYmb0Pf7DuToFx0of4pE)
Server :
The text was updated successfully, but these errors were encountered: