graphql-engine icon indicating copy to clipboard operation
graphql-engine copied to clipboard

Event Trigger - No trigger, fetching invocation info loop

Open tapeo opened this issue 3 years ago • 3 comments

Version Information

Server Version: v2.1.0-beta.3, v2.0.10

Environment

OSS

What is the expected behaviour?

Event Trigger not triggered even manually on console

Keywords

event trigger not delivered

What is the current behaviour?

From console: Loop with the text "fetching invocation info"

No delivered when triggered (if triggered)

How to reproduce the issue?

Only reproducible in production environment, on my same docker file on local env it's all ok.

Screenshots or Screencast

Schermata 2021-12-13 alle 15 30 29 Schermata 2021-12-13 alle 15 29 46

Additional info

Network query response

{ "result_type": "TuplesOk", "result": [ [ "id", "event_id", "status", "request", "response", "created_at", "id", "schema_name", "table_name", "trigger_name", "payload", "delivered", "error", "tries", "created_at", "locked", "next_retry_at", "archived" ] ] }

tapeo avatar Dec 13 '21 14:12 tapeo

Solved temporary by changing column locked of the table hdb_catalog.event_log, from bool to timestamp with time zone

tapeo avatar Dec 14 '21 12:12 tapeo

Hi! How did you update your Hasura instance to v2.0/v2.1?

In Hasura v2.0, the hdb_catalog.event_log table is supposed to have locked column as timestamp with time zone automatically.

tirumaraiselvan avatar Dec 14 '21 12:12 tirumaraiselvan

Maybe is due to the fact that I have created a new instance from scratch and then migrated all the data from the old hasura version!

tapeo avatar Dec 14 '21 14:12 tapeo