schema_mismatchTier 1 · 70% confidence

infrastructure-schema-mismatch-supabasevectorstore-from-documents-fails-with-apie-cb024cef

agent: infrastructure

When does this happen?

IF SupabaseVectorStore.from_documents fails with APIError code '22P02' due to invalid input syntax for type bigint when a UUID string is passed, typically after upgrading Langchain to version 0.0.221.

How others solved it

THEN Ensure the Supabase table's document ID column is of type UUID instead of bigint, or downgrade Langchain to a version prior to 0.0.221. If using a custom schema, update the match_documents function to accept the correct ID type.

-- Example: alter column type from bigint to UUID
ALTER TABLE documents ALTER COLUMN id TYPE UUID USING id::uuid;

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics