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
Hi,
my system is Windows 10 64bit with Docker 4.27.2 installed.
I followed the Readme instructions but on step "superbase start" in the chatbot-ui folder, superbase gives me the error:
Applying migration 20240108234540_setup.sql...
unexpected EOF
tatement 0: -- Enable HTTP extension
create extension http with schema extensions
Try rerunning the command with --debug to troubleshoot the error.
So when I continue, registering in the webinterface, I get an throw error that some profile is not existing (DB?)
How I installed:
Cloning into 'chatbot-ui'...
remote: Enumerating objects: 4513, done.
remote: Counting objects: 100% (20/20), done.
remote: Compressing objects: 100% (18/18), done.
remote: Total 4513 (delta 4), reused 7 (delta 2), pack-reused 4493
Receiving objects: 100% (4513/4513), 2.91 MiB | 16.96 MiB/s, done.
Resolving deltas: 100% (2570/2570), done.
>cd chatbot-ui
>npm install
npm WARN deprecated [email protected]: This package has been deprecated and is no longer maintained. Please use @rollup/plugin-terser
npm WARN deprecated [email protected]: Use your platform's native atob() and btoa() methods instead
npm WARN deprecated [email protected]: Please use @jridgewell/sourcemap-codec instead
npm WARN deprecated [email protected]: Use your platform's native DOMException instead
npm WARN deprecated [email protected]: [email protected]
> [email protected] prepare
> husky install
husky - Git hooks installed
added 1454 packages, and audited 1455 packages in 1m
295 packages are looking for funding
run `npm fund` for details
found 0 vulnerabilities
>scoop install supabase
Installing 'supabase' (1.145.4) [64bit] from main bucket
Loading supabase_windows_amd64.tar.gz from cache
Checking hash of supabase_windows_amd64.tar.gz ... ok.
Extracting supabase_windows_amd64.tar.gz ... done.
Linking ~\scoop\apps\supabase\current => ~\scoop\apps\supabase\1.145.4
Creating shim for 'supabase'.
'supabase' (1.145.4) was installed successfully!
>supabase status
Error response from daemon: No such container: supabase_db_chatbotui
Try rerunning the command with --debug to troubleshoot the error.
>supabase start
15.1.0.147: Pulling from supabase/postgres
25ad149ed3cf: Pull complete
14f90cf66c68: Pull complete
50947b8b9d23: Pull complete
84c8818bb266: Pull complete
0193a6672d0f: Pull complete
54457cfcc0b1: Pull complete
86d67435e240: Pull complete
5241087a446f: Pull complete
b3d9db1b125e: Pull complete
103ad6b15fce: Pull complete
a94f97c95c74: Pull complete
32571cb33575: Pull complete
4680a9e12204: Pull complete
2cd0cc61b3ea: Pull complete
1c7ade17b757: Pull complete
fd1eabcd334d: Pull complete
73b45d9f32ff: Pull complete
0b875606ffed: Pull complete
5ebd8615e81b: Pull complete
a90419bbb41d: Pull complete
Pull complete abase...
340bdfd12933: Pull complete
4f970f6ed0d2: Pull complete
23247bd83a46: Pull complete
Digest: sha256:5a8cb2e4acf7845a50e557bff8dcfb3e3c73b410e66c3cd011105fc09d8ff13b
Status: Downloaded newer image for public.ecr.aws/supabase/postgres:15.1.0.147
v0.46.4: Pulling from supabase/storage-api
661ff4d9561e: Pull complete
0f158788f409: Pull complete
f028dff98271: Pull complete
18f25c33705d: Pull complete
4a290a6237c1: Pull complete
ca8d2d0daa24: Pull complete
87d05ea306d0: Pull complete
8befee2cdf1f: Pull complete
60de495b4978: Pull complete
Digest: sha256:3aed9cc6df7c0e8060d1bf7dafc15edb085e68cc158a3dbe966be6ca5ac0d726
Status: Downloaded newer image for public.ecr.aws/supabase/storage-api:v0.46.4
v2.132.3: Pulling from supabase/gotrue
1207c741d8c9: Pull complete
191d68e665ef: Pull complete
110fd131e583: Pull complete
5253307f0a05: Pull complete
ee693b52cb04: Pull complete
5e57375bb022: Pull complete
Digest: sha256:1bfae25acead513fbd459679a08463a1fc679769e6586c773cfc32d26c5b6dcf
Status: Downloaded newer image for public.ecr.aws/supabase/gotrue:v2.132.3
Applying migration 20240108234540_setup.sql...
unexpected EOF
tatement 0: -- Enable HTTP extension
create extension http with schema extensions
Try rerunning the command with --debug to troubleshoot the error.
>
--debug
>supabase start --debug
Supabase CLI 1.145.4
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Sent Header: Content-Length [310]
2024/02/28 01:18:49 Sent Header: Content-Type [application/json]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte ⣽ Starting database...
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Sent Header: Content-Length [125]
2024/02/28 01:18:49 Sent Header: Content-Type [application/json]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Sent Header: Content-Length [129]
2024/02/28 01:18:49 Sent Header: Content-Type [application/json]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Sent Header: Content-Length [12278]
2024/02/28 01:18:49 Sent Header: Content-Type [application/json]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:49 Recv First Byte
2024/02/28 01:18:49 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:49 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:49 Sent Header: Content-Length [0]
2024/02/28 01:18:49 Sent Header: Content-Type [text/plain]
2024/02/28 01:18:49 Send Done
2024/02/28 01:18:50 Recv First Byte
2024/02/28 01:18:50 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:50 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:50 Send Done
2024/02/28 01:18:50 Recv First Byte
2024/02/28 01:18:51 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:51 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:51 Send Done
2024/02/28 01:18:51 Recv First Byte
2024/02/28 01:18:52 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:52 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:52 Send Done
2024/02/28 01:18:52 Recv First Byte
2024/02/28 01:18:53 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:53 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:53 Send Done
2024/02/28 01:18:53 Recv First Byte
2024/02/28 01:18:54 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:54 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:54 Send Done
2024/02/28 01:18:54 Recv First Byte
2024/02/28 01:18:55 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:55 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:55 Send Done
2024/02/28 01:18:55 Recv First Byte
2024/02/28 01:18:56 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:56 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:56 Send Done
2024/02/28 01:18:56 Recv First Byte
2024/02/28 01:18:57 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:57 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:57 Send Done
2024/02/28 01:18:57 Recv First Byte
2024/02/28 01:18:58 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:58 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:58 Send Done
2024/02/28 01:18:58 Recv First Byte
2024/02/28 01:18:59 Sent Header: Host [api.moby.localhost]
2024/02/28 01:18:59 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:18:59 Send Done
2024/02/28 01:18:59 Recv First Byte
2024/02/28 01:19:00 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:00 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:00 Send Done
2024/02/28 01:19:00 Recv First Byte
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:01 Connect Start: tcp 127.0.0.1:54322
2024/02/28 01:19:01 Connect Done: tcp 127.0.0.1:54322
2024/02/28 01:19:01 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres"}}
2024/02/28 01:19:01 PG Recv: {"Type":"AuthenticationSASL","AuthMechanisms":["SCRAM-SHA-256"]}
2024/02/28 01:19:01 PG Send: {"Type":"SASLInitialResponse","AuthMechanism":"SCRAM-SHA-256","Data":"n,,n=,r=HFn4pjZPGTheBYmsD4OtYOFf"}
2024/02/28 01:19:01 PG Recv: {"Type":"AuthenticationSASLContinue","Data":"r=HFn4pjZPGTheBYmsD4OtYOFf674dJvibVmuPLampN+hZPXaQ,s=lqQXvE+CdsvmoPKFhufF2g==,i=4096"}
2024/02/28 01:19:01 PG Send: {"Type":"SASLResponse","Data":"c=biws,r=HFn4pjZPGTheBYmsD4OtYOFf674dJvibVmuPLampN+hZPXaQ,p=LFOFwNjWzzoEwE23iYi6rFxVnVlvN1zKAfUtb97wRVE="}
2024/02/28 01:19:01 PG Recv: {"Type":"AuthenticationSASLFinal","Data":"v=yy/1gvPe3fouWZHyTs/cBoN4TEnmpUp+amFKISsbYms="}
2024/02/28 01:19:01 PG Recv: {"Type":"AuthenticationOK"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"application_name","Value":""}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"client_encoding","Value":"UTF8"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"DateStyle","Value":"ISO, MDY"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"default_transaction_read_only","Value":"off"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"in_hot_standby","Value":"off"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"integer_datetimes","Value":"on"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"IntervalStyle","Value":"postgres"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"is_superuser","Value":"off"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"server_encoding","Value":"UTF8"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"server_version","Value":"15.1 (Ubuntu 15.1-1.pgdg20.04+1)"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"session_authorization","Value":"postgres"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"standard_conforming_strings","Value":"on"}
2024/02/28 01:19:01 PG Recv: {"Type":"ParameterStatus","Name":"TimeZone","Value":"UTC"}
2024/02/28 01:19:01 PG Recv: {"Type":"BackendKeyData","ProcessID":172,"SecretKey":3761606524}
2024/02/28 01:19:01 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Sent Header: Content-Length [310]
2024/02/28 01:19:01 Sent Header: Content-Type [application/json]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Sent Header: Content-Length [2311]
2024/02/28 01:19:01 Sent Header: Content-Type [application/json]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Sent Header: Content-Length [0]
2024/02/28 01:19:01 Sent Header: Content-Type [text/plain]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:01 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:01 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:01 Send Done
2024/02/28 01:19:01 Recv First Byte
2024/02/28 01:19:03 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:03 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:03 Send Done
2024/02/28 01:19:03 Recv First Byte
2024/02/28 01:19:03 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:03 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:03 Send Done
2024/02/28 01:19:03 Recv First Byte
2024/02/28 01:19:03 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:03 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:03 Sent Header: Content-Length [310]
2024/02/28 01:19:03 Sent Header: Content-Type [application/json]
2024/02/28 01:19:03 Send Done
2024/02/28 01:19:03 Recv First Byte
2024/02/28 01:19:03 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:03 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:03 Sent Header: Content-Length [1969]
2024/02/28 01:19:03 Sent Header: Content-Type [application/json]
2024/02/28 01:19:03 Send Done
2024/02/28 01:19:03 Recv First Byte
2024/02/28 01:19:03 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:03 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:03 Sent Header: Content-Length [0]
2024/02/28 01:19:03 Sent Header: Content-Type [text/plain]
2024/02/28 01:19:03 Send Done
2024/02/28 01:19:04 Recv First Byte
2024/02/28 01:19:04 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:04 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:04 Send Done
2024/02/28 01:19:04 Recv First Byte
2024/02/28 01:19:05 Sent Header: Host [api.moby.localhost]
2024/02/28 01:19:05 Sent Header: User-Agent [Docker-Client/unknown-version (windows)]
2024/02/28 01:19:05 Send Done
2024/02/28 01:19:05 Recv First Byte
Applying migration 20240108234540_setup.sql...
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Enable HTTP extension\r\ncreate extension http with schema extensions","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Enable vector extension\r\ncreate extension vector with schema extensions","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to update modified column\r\nCREATE OR REPLACE FUNCTION update_updated_at_column()\r\nRETURNS TRIGGER AS $$\r\nBEGIN\r\n NEW.updated_at = now(); \r\n RETURN NEW; \r\nEND;\r\n$$ language 'plpgsql'","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a message and all following messages\r\nCREATE OR REPLACE FUNCTION delete_message_including_and_after(\r\n p_user_id UUID, \r\n p_chat_id UUID, \r\n p_sequence_number INT\r\n)\r\nRETURNS VOID AS $$\r\nBEGIN\r\n DELETE FROM messages \r\n WHERE user_id = p_user_id AND chat_id = p_chat_id AND sequence_number \u003e= p_sequence_number;\r\nEND;\r\n$$ LANGUAGE plpgsql","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to create duplicate messages for a new chat\r\nCREATE OR REPLACE FUNCTION create_duplicate_messages_for_new_chat(old_chat_id UUID, new_chat_id UUID, new_user_id UUID)\r\nRETURNS VOID AS $$\r\nBEGIN\r\n INSERT INTO messages (user_id, chat_id, content, role, model, sequence_number, tokens, created_at, updated_at)\r\n SELECT new_user_id, new_chat_id, content, role, model, sequence_number, tokens, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP\r\n FROM messages\r\n WHERE chat_id = old_chat_id;\r\nEND;\r\n$$ LANGUAGE plpgsql","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Policy to allow users to read their own files\r\nCREATE POLICY \"Allow users to read their own files\"\r\nON storage.objects FOR SELECT\r\nTO authenticated\r\nUSING (auth.uid()::text = owner_id::text)","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a storage object\r\nCREATE OR REPLACE FUNCTION delete_storage_object(bucket TEXT, object TEXT, OUT status INT, OUT content TEXT)\r\nRETURNS RECORD\r\nLANGUAGE 'plpgsql'\r\nSECURITY DEFINER\r\nAS $$\r\nDECLARE\r\n project_url TEXT := 'http://supabase_kong_chatbotui:8000';\r\n service_role_key TEXT := 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU'; -- full access needed for http request to storage\r\n url TEXT := project_url || '/storage/v1/object/' || bucket || '/' || object;\r\nBEGIN\r\n SELECT\r\n INTO status, content\r\n result.status::INT, result.content::TEXT\r\n FROM extensions.http((\r\n 'DELETE',\r\n url,\r\n ARRAY[extensions.http_header('authorization','Bearer ' || service_role_key)],\r\n NULL,\r\n NULL)::extensions.http_request) AS result;\r\nEND;\r\n$$","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a storage object from a bucket\r\nCREATE OR REPLACE FUNCTION delete_storage_object_from_bucket(bucket_name TEXT, object_path TEXT, OUT status INT, OUT content TEXT)\r\nRETURNS RECORD\r\nLANGUAGE 'plpgsql'\r\nSECURITY DEFINER\r\nAS $$\r\nBEGIN\r\n SELECT\r\n INTO status, content\r\n result.status, result.content\r\n FROM public.delete_storage_object(bucket_name, object_path) AS result;\r\nEND;\r\n$$","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"CREATE SCHEMA IF NOT EXISTS supabase_migrations","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"CREATE TABLE IF NOT EXISTS supabase_migrations.schema_migrations (version text NOT NULL PRIMARY KEY)","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"ALTER TABLE supabase_migrations.schema_migrations ADD COLUMN IF NOT EXISTS statements text[]","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"ALTER TABLE supabase_migrations.schema_migrations ADD COLUMN IF NOT EXISTS name text","ParameterOIDs":null}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Parse","Name":"","Query":"INSERT INTO supabase_migrations.schema_migrations(version, name, statements) VALUES($1, $2, $3)","ParameterOIDs":[25,25,1009]}
2024/02/28 01:19:05 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":[0,0,0],"Parameters":[{"text":"20240108234540"},{"text":"setup"},{"text":"{-- Enable HTTP extension\r\ncreate extension http with schema extensions,-- Enable vector extension\r\ncreate extension vector with schema extensions,-- Function to update modified column\r\nCREATE OR REPLACE FUNCTION update_updated_at_column()\r\nRETURNS TRIGGER AS $$\r\nBEGIN\r\n NEW.updated_at = now(); \r\n RETURN NEW; \r\nEND;\r\n$$ language 'plpgsql',\"-- Function to delete a message and all following messages\r\nCREATE OR REPLACE FUNCTION delete_message_including_and_after(\r\n p_user_id UUID, \r\n p_chat_id UUID, \r\n p_sequence_number INT\r\n)\r\nRETURNS VOID AS $$\r\nBEGIN\r\n DELETE FROM messages \r\n WHERE user_id = p_user_id AND chat_id = p_chat_id AND sequence_number \u003e= p_sequence_number;\r\nEND;\r\n$$ LANGUAGE plpgsql\",\"-- Function to create duplicate messages for a new chat\r\nCREATE OR REPLACE FUNCTION create_duplicate_messages_for_new_chat(old_chat_id UUID, new_chat_id UUID, new_user_id UUID)\r\nRETURNS VOID AS $$\r\nBEGIN\r\n INSERT INTO messages (user_id, chat_id, content, role, model, sequence_number, tokens, created_at, updated_at)\r\n SELECT new_user_id, new_chat_id, content, role, model, sequence_number, tokens, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP\r\n FROM messages\r\n WHERE chat_id = old_chat_id;\r\nEND;\r\n$$ LANGUAGE plpgsql\",\"-- Policy to allow users to read their own files\r\nCREATE POLICY \\\"Allow users to read their own files\\\"\r\nON storage.objects FOR SELECT\r\nTO authenticated\r\nUSING (auth.uid()::text = owner_id::text)\",\"-- Function to delete a storage object\r\nCREATE OR REPLACE FUNCTION delete_storage_object(bucket TEXT, object TEXT, OUT status INT, OUT content TEXT)\r\nRETURNS RECORD\r\nLANGUAGE 'plpgsql'\r\nSECURITY DEFINER\r\nAS $$\r\nDECLARE\r\n project_url TEXT := 'http://supabase_kong_chatbotui:8000';\r\n service_role_key TEXT := 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU'; -- full access needed for http request to storage\r\n url TEXT := project_url || '/storage/v1/object/' || bucket || '/' || object;\r\nBEGIN\r\n SELECT\r\n INTO status, content\r\n result.status::INT, result.content::TEXT\r\n FROM extensions.http((\r\n 'DELETE',\r\n url,\r\n ARRAY[extensions.http_header('authorization','Bearer ' || service_role_key)],\r\n NULL,\r\n NULL)::extensions.http_request) AS result;\r\nEND;\r\n$$\",\"-- Function to delete a storage object from a bucket\r\nCREATE OR REPLACE FUNCTION delete_storage_object_from_bucket(bucket_name TEXT, object_path TEXT, OUT status INT, OUT content TEXT)\r\nRETURNS RECORD\r\nLANGUAGE 'plpgsql'\r\nSECURITY DEFINER\r\nAS $$\r\nBEGIN\r\n SELECT\r\n INTO status, content\r\n result.status, result.content\r\n FROM public.delete_storage_object(bucket_name, object_path) AS result;\r\nEND;\r\n$$\"}"}],"ResultFormatCodes":[]}
2024/02/28 01:19:05 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/28 01:19:05 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/28 01:19:05 PG Send: {"Type":"Sync"}
2024/02/29 20:58:20 PG Send: {"Type":"Terminate"}
^C
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi,
my system is Windows 10 64bit with Docker 4.27.2 installed.
I followed the Readme instructions but on step "superbase start" in the chatbot-ui folder, superbase gives me the error:
So when I continue, registering in the webinterface, I get an throw error that some profile is not existing (DB?)
How I installed:
--debug
Beta Was this translation helpful? Give feedback.
All reactions