Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

vector extension did not work correctly #934

Open
zhaojunfeng opened this issue Apr 4, 2024 · 0 comments
Open

vector extension did not work correctly #934

zhaojunfeng opened this issue Apr 4, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@zhaojunfeng
Copy link

zhaojunfeng commented Apr 4, 2024

Bug report

Describe the bug

vector extension did not work correctly, when I exec query :select '[0,0.4345234,0.3434]'<=>'[0,0.234324,0.23123]', respond with error msg 'Error: Connection terminated unexpectedly'.

select '[0,0.4345234,0.3434]'<=>'[0,0.234324,0.23123]'
2024-04-04T06:22:07.952635613Z
2024-04-04T06:22:07.952673563Z 2024-04-04 06:22:07.952 UTC [10] LOG: terminating any other active server processes
2024-04-04T06:22:07.956696604Z 2024-04-04 06:22:07.956 UTC [10] LOG: all server processes terminated; reinitializing
2024-04-04T06:22:08.120490768Z 2024-04-04 06:22:08.120 UTC [7479] LOG: database system was interrupted; last known up at 2024-04-04 03:42:01 UTC
2024-04-04T06:22:08.121614013Z 192.168.240.7 2024-04-04 06:22:08.121 UTC [7482] authenticator@postgres FATAL: the database system is in recovery mode
2024-04-04T06:22:08.122010281Z 192.168.240.7 2024-04-04 06:22:08.121 UTC [7483] authenticator@postgres FATAL: the database system is in recovery mode
2024-04-04T06:22:08.122262572Z 192.168.240.8 2024-04-04 06:22:08.122 UTC [7484] supabase_storage_admin@postgres FATAL: the database system is in recovery mode
2024-04-04T06:22:08.202609044Z 2024-04-04 06:22:08.202 UTC [7479] LOG: database system was not properly shut down; automatic recovery in progress

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

exec query 'select '[0,0.4345234,0.3434]'<=>'[0,0.234324,0.23123]' in supabase 'SQL Editor'.
1712213376385

Expected behavior

return correct result

System information

  • OS: [centos 7.9]
    -supabase cli: 1.153.3 (self hosting with docker)

Additional context

init with pgvector 0.51

1712213726262

@zhaojunfeng zhaojunfeng added the bug Something isn't working label Apr 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant