© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•9mo ago•
14 replies
Kapxy

Realtime logs has a lot of errors like this

PoolingReplicationError: %Postgrex.Error{
  message: nil,
  postgres: %{
    code: :syntax_error,
    line: "1188",
    message: "syntax error at or near \"-\"",
    file: "scan.l",
    unknown: "ERROR",
    where: "invalid type name \"-1597984915\"\nPL/pgSQL function realtime.apply_rls(jsonb,integer) line 51 at assignment\nSQL function \"list_changes\" statement 1",
    severity: "ERROR",
    pg_code: "42601",
    internal_query: "columns =\n    array_agg(\n        (\n            x->>'name',\n            x->>'type',\n            x->>'typeoid',\n            realtime.cast(\n                (x->'value') #>> '{}',\n                coalesce(\n                    (x->>'typeoid')::regtype, -- null when wal2json version <= 2.4\n                    (x->>'type')::regtype\n                )\n            ),\n            (pks ->> 'name') is not null,\n            true\n        )::realtime.wal_column\n    )\n    from\n        jsonb_array_elements(wal -> 'columns') x\n        left join jsonb_array_elements(wal -> 'pk') pks\n            on (x ->> 'name') = (pks ->> 'name')",
    internal_position: "1",
    routine: "scanner_yyerror"
  },
  connection_id: 221656,
  query: nil
}
PoolingReplicationError: %Postgrex.Error{
  message: nil,
  postgres: %{
    code: :syntax_error,
    line: "1188",
    message: "syntax error at or near \"-\"",
    file: "scan.l",
    unknown: "ERROR",
    where: "invalid type name \"-1597984915\"\nPL/pgSQL function realtime.apply_rls(jsonb,integer) line 51 at assignment\nSQL function \"list_changes\" statement 1",
    severity: "ERROR",
    pg_code: "42601",
    internal_query: "columns =\n    array_agg(\n        (\n            x->>'name',\n            x->>'type',\n            x->>'typeoid',\n            realtime.cast(\n                (x->'value') #>> '{}',\n                coalesce(\n                    (x->>'typeoid')::regtype, -- null when wal2json version <= 2.4\n                    (x->>'type')::regtype\n                )\n            ),\n            (pks ->> 'name') is not null,\n            true\n        )::realtime.wal_column\n    )\n    from\n        jsonb_array_elements(wal -> 'columns') x\n        left join jsonb_array_elements(wal -> 'pk') pks\n            on (x ->> 'name') = (pks ->> 'name')",
    internal_position: "1",
    routine: "scanner_yyerror"
  },
  connection_id: 221656,
  query: nil
}
`

anyone know whats up?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Getting a lot of Logs every minute
SupabaseSSupabase / help-and-questions
4y ago
Realtime has stopped working
SupabaseSSupabase / help-and-questions
2d ago
Generating a lot of stress
SupabaseSSupabase / help-and-questions
8mo ago
REALTIME access token has expired
SupabaseSSupabase / help-and-questions
4y ago