unexpected EOF At statement 0: -- Enable HTTP extension

[dannykorpan]

Hi,

after running "npm run chat", I get the following error. I've twice downloaded 20240108234540_setup.sql, but it seems to be normal.

> chatbot-ui@2.0.0 chat
> supabase start && npm run db-types && npm run dev

Applying migration 20240108234540_setup.sql...
unexpected EOF
At statement 0: -- Enable HTTP extension
create extension http with schema extensions
Try rerunning the command with --debug to troubleshoot the error.

Does anybody have a hint or a solution for me?

[dannykorpan]

Here is the debug output

Supabase CLI 1.144.2
Connecting to local database...
2024/02/13 18:59:39 Connect Start: tcp 127.0.0.1:5432
2024/02/13 18:59:39 Connect Done: tcp 127.0.0.1:5432
2024/02/13 18:59:39 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres"}}
2024/02/13 18:59:39 PG Recv: {"Type":"AuthenticationSASL","AuthMechanisms":["SCRAM-SHA-256"]}
2024/02/13 18:59:39 PG Send: {"Type":"SASLInitialResponse","AuthMechanism":"SCRAM-SHA-256","Data":"n,,n=,r=R1IoCTr25nzqjv9J199T+BT/"}
2024/02/13 18:59:39 PG Recv: {"Type":"AuthenticationSASLContinue","Data":"r=R1IoCTr25nzqjv9J199T+BT/9Gxhw/yliVqwqdBFhkdQ38F+,s=VxNXTe7pcpqccIBZ3ct1dA==,i=4096"}
2024/02/13 18:59:39 PG Send: {"Type":"SASLResponse","Data":"c=biws,r=R1IoCTr25nzqjv9J199T+BT/9Gxhw/yliVqwqdBFhkdQ38F+,p=r37mevOvx0FXP/4/iotUkOjFgnJtShYnDoMQPWYt/K4="}
2024/02/13 18:59:39 PG Recv: {"Type":"AuthenticationSASLFinal","Data":"v=BbLFG41pFyrSJUmR1Kbw82+Rixu5DiAdI+8nNDqEwb8="}
2024/02/13 18:59:39 PG Recv: {"Type":"AuthenticationOK"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"application_name","Value":""}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"client_encoding","Value":"UTF8"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"DateStyle","Value":"ISO, MDY"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"default_transaction_read_only","Value":"off"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"in_hot_standby","Value":"off"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"integer_datetimes","Value":"on"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"IntervalStyle","Value":"postgres"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"is_superuser","Value":"off"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"server_encoding","Value":"UTF8"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"server_version","Value":"15.1 (Ubuntu 15.1-1.pgdg20.04+1)"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"session_authorization","Value":"postgres"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"standard_conforming_strings","Value":"on"}
2024/02/13 18:59:39 PG Recv: {"Type":"ParameterStatus","Name":"TimeZone","Value":"UTC"}
2024/02/13 18:59:39 PG Recv: {"Type":"BackendKeyData","ProcessID":1986,"SecretKey":4294266142}
2024/02/13 18:59:39 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"lrupsc_1_0","Query":"SELECT version FROM supabase_migrations.schema_migrations ORDER BY version","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"S","Name":"lrupsc_1_0"}
2024/02/13 18:59:39 PG Send: {"Type":"Sync"}
2024/02/13 18:59:39 PG Recv: {"Type":"ErrorResponse","Severity":"ERROR","SeverityUnlocalized":"ERROR","Code":"42P01","Message":"relation \"supabase_migrations.schema_migrations\" does not exist","Detail":"","Hint":"","Position":21,"InternalPosition":0,"InternalQuery":"","Where":"","SchemaName":"","TableName":"","ColumnName":"","DataTypeName":"","ConstraintName":"","File":"parse_relation.c","Line":1371,"Routine":"parserOpenTable","UnknownFields":null}
2024/02/13 18:59:39 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
Applying migration 20240108234540_setup.sql...
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Enable HTTP extension\ncreate extension http with schema extensions","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Enable vector extension\ncreate extension vector with schema extensions","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to update modified column\nCREATE OR REPLACE FUNCTION update_updated_at_column()\nRETURNS TRIGGER AS $$\nBEGIN\n    NEW.updated_at = now(); \n    RETURN NEW; \nEND;\n$$ language 'plpgsql'","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a message and all following messages\nCREATE OR REPLACE FUNCTION delete_message_including_and_after(\n    p_user_id UUID, \n    p_chat_id UUID, \n    p_sequence_number INT\n)\nRETURNS VOID AS $$\nBEGIN\n    DELETE FROM messages \n    WHERE user_id = p_user_id AND chat_id = p_chat_id AND sequence_number \u003e= p_sequence_number;\nEND;\n$$ LANGUAGE plpgsql","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to create duplicate messages for a new chat\nCREATE OR REPLACE FUNCTION create_duplicate_messages_for_new_chat(old_chat_id UUID, new_chat_id UUID, new_user_id UUID)\nRETURNS VOID AS $$\nBEGIN\n    INSERT INTO messages (user_id, chat_id, content, role, model, sequence_number, tokens, created_at, updated_at)\n    SELECT new_user_id, new_chat_id, content, role, model, sequence_number, tokens, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP\n    FROM messages\n    WHERE chat_id = old_chat_id;\nEND;\n$$ LANGUAGE plpgsql","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Policy to allow users to read their own files\nCREATE POLICY \"Allow users to read their own files\"\nON storage.objects FOR SELECT\nTO authenticated\nUSING (auth.uid()::text = owner_id::text)","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a storage object\nCREATE OR REPLACE FUNCTION delete_storage_object(bucket TEXT, object TEXT, OUT status INT, OUT content TEXT)\nRETURNS RECORD\nLANGUAGE 'plpgsql'\nSECURITY DEFINER\nAS $$\nDECLARE\n  project_url TEXT := 'http://supabase_kong_chatbotui:8000';\n  service_role_key TEXT := 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU'; -- full access needed for http request to storage\n  url TEXT := project_url || '/storage/v1/object/' || bucket || '/' || object;\nBEGIN\n  SELECT\n      INTO status, content\n           result.status::INT, result.content::TEXT\n      FROM extensions.http((\n    'DELETE',\n    url,\n    ARRAY[extensions.http_header('authorization','Bearer ' || service_role_key)],\n    NULL,\n    NULL)::extensions.http_request) AS result;\nEND;\n$$","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"-- Function to delete a storage object from a bucket\nCREATE OR REPLACE FUNCTION delete_storage_object_from_bucket(bucket_name TEXT, object_path TEXT, OUT status INT, OUT content TEXT)\nRETURNS RECORD\nLANGUAGE 'plpgsql'\nSECURITY DEFINER\nAS $$\nBEGIN\n  SELECT\n      INTO status, content\n           result.status, result.content\n      FROM public.delete_storage_object(bucket_name, object_path) AS result;\nEND;\n$$","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"CREATE SCHEMA IF NOT EXISTS supabase_migrations","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 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/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"ALTER TABLE supabase_migrations.schema_migrations ADD COLUMN IF NOT EXISTS statements text[]","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Parse","Name":"","Query":"ALTER TABLE supabase_migrations.schema_migrations ADD COLUMN IF NOT EXISTS name text","ParameterOIDs":null}
2024/02/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 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/13 18:59:39 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"","ParameterFormatCodes":[0,0,0],"Parameters":[{"text":"20240108234540"},{"text":"setup"},{"text":"{-- Enable HTTP extension\ncreate extension http with schema extensions,-- Enable vector extension\ncreate extension vector with schema extensions,-- Function to update modified column\nCREATE OR REPLACE FUNCTION update_updated_at_column()\nRETURNS TRIGGER AS $$\nBEGIN\n    NEW.updated_at = now(); \n    RETURN NEW; \nEND;\n$$ language 'plpgsql',\"-- Function to delete a message and all following messages\nCREATE OR REPLACE FUNCTION delete_message_including_and_after(\n    p_user_id UUID, \n    p_chat_id UUID, \n    p_sequence_number INT\n)\nRETURNS VOID AS $$\nBEGIN\n    DELETE FROM messages \n    WHERE user_id = p_user_id AND chat_id = p_chat_id AND sequence_number \u003e= p_sequence_number;\nEND;\n$$ LANGUAGE plpgsql\",\"-- Function to create duplicate messages for a new chat\nCREATE OR REPLACE FUNCTION create_duplicate_messages_for_new_chat(old_chat_id UUID, new_chat_id UUID, new_user_id UUID)\nRETURNS VOID AS $$\nBEGIN\n    INSERT INTO messages (user_id, chat_id, content, role, model, sequence_number, tokens, created_at, updated_at)\n    SELECT new_user_id, new_chat_id, content, role, model, sequence_number, tokens, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP\n    FROM messages\n    WHERE chat_id = old_chat_id;\nEND;\n$$ LANGUAGE plpgsql\",\"-- Policy to allow users to read their own files\nCREATE POLICY \\\"Allow users to read their own files\\\"\nON storage.objects FOR SELECT\nTO authenticated\nUSING (auth.uid()::text = owner_id::text)\",\"-- Function to delete a storage object\nCREATE OR REPLACE FUNCTION delete_storage_object(bucket TEXT, object TEXT, OUT status INT, OUT content TEXT)\nRETURNS RECORD\nLANGUAGE 'plpgsql'\nSECURITY DEFINER\nAS $$\nDECLARE\n  project_url TEXT := 'http://supabase_kong_chatbotui:8000';\n  service_role_key TEXT := 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZS1kZW1vIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImV4cCI6MTk4MzgxMjk5Nn0.EGIM96RAZx35lJzdJsyH-qQwv8Hdp7fsn3W0YpN81IU'; -- full access needed for http request to storage\n  url TEXT := project_url || '/storage/v1/object/' || bucket || '/' || object;\nBEGIN\n  SELECT\n      INTO status, content\n           result.status::INT, result.content::TEXT\n      FROM extensions.http((\n    'DELETE',\n    url,\n    ARRAY[extensions.http_header('authorization','Bearer ' || service_role_key)],\n    NULL,\n    NULL)::extensions.http_request) AS result;\nEND;\n$$\",\"-- Function to delete a storage object from a bucket\nCREATE OR REPLACE FUNCTION delete_storage_object_from_bucket(bucket_name TEXT, object_path TEXT, OUT status INT, OUT content TEXT)\nRETURNS RECORD\nLANGUAGE 'plpgsql'\nSECURITY DEFINER\nAS $$\nBEGIN\n  SELECT\n      INTO status, content\n           result.status, result.content\n      FROM public.delete_storage_object(bucket_name, object_path) AS result;\nEND;\n$$\"}"}],"ResultFormatCodes":[]}
2024/02/13 18:59:39 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2024/02/13 18:59:39 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2024/02/13 18:59:39 PG Send: {"Type":"Sync"}