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

Schema is not updated after migration #7574

Open PedroBern opened 3 years ago

PedroBern commented 3 years ago

Version Information

Server Version: v2.0.9-cloud.

Environment

Cloud

What is the expected behaviour?

Update schema after migrations

Keywords

Custom field, schema, introspection

What is the current behaviour?

last migration is:

-- down
ALTER TABLE "public"."wod" ALTER COLUMN "name" TYPE citext;

-- up
ALTER TABLE "public"."wod" ALTER COLUMN "name" TYPE varchar(128);

The schema should be String, but it continues to be citext see the screen shot below.

It happens for 2 of my tables.

Screenshots or Screencast

Captura de Tela 2021-09-17 às 21 03 33

Captura de Tela 2021-09-17 às 21 04 18

Possible solution

Tried reloading metadata, but didn't work.

Works locally, but not on Cloud

👆

PedroBern commented 3 years ago

Update: after 1 day, the next deployment of the cloud fixed the issue >>>> breaking the client that was using the previous schema. In this case was a simple fix, just 2 fields, but this continues to be a cloud bug.