search

hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
31.18k stars 2.77k forks source link

function hdb_catalog.notify_hasura_comments_UPDATE() does not exist #9270

Open loremru opened 1 year ago

loremru commented 1 year ago

VERSIONS:

postgres: image: postgres:12 graphql-engine: image: hasura/graphql-engine:v2.10.1

ERROR:

WARN Metadata is inconsistent WARN Use 'hasura metadata ic list' command to list inconsistent objects ERRO skipping applying migrations on database gunza, encountered: { "code": "postgres-error", "error": "query execution failed", "internal": { "arguments": [], "error": { "description": null, "exec_status": "FatalError", "hint": null, "message": "function hdb_catalog.notify_hasura_comments_UPDATE() does not exist", "status_code": "42883" }, "prepared": false,

Error occures when i trying to deploy my metadata/migrations to new clear hasura with same version. On the current hasura migrations are set properly

image

BenoitRanque commented 1 year ago

Have you tried reloading metadata? It causes triggers associated with event triggers to be recreated and can help with these kinds of problems

loremru commented 1 year ago

@BenoitRanque

Have you tried reloading metadata? It causes triggers associated with event triggers to be recreated and can help with these kinds of problems

Yes, I did. I tried to recreate metadata/migrations, upload them one more time, but nothing helps. Same error.