hasura / hasura/graphql-engine

Migration: git deployment with ENUM table causes metadata inconsistency

Open
#7,420 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

After git deployment or the migration using Hasura CLI of projects with ENUM table causes the metadata to be inconsistent.

It is because ENUM tables cannot be empty.
But when I click on the ENUM table, I am sent to the error screen.
And upon refresh redirected to the metadata inconsistency page.

I resolved the problem by adding the ENUM table entries by executing Raw SQL queries.
But I believe the Hasura UI could be improved to allow data insertion.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing a git deployment or Hasura CLI migration for a project with an empty ENUM table, then follow the UI path from clicking the table to the error screen and metadata inconsistency page. Done means the UI allows ENUM table entries to be inserted and the deployment or migration no longer leaves metadata inconsistent.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres, typescript
Domain
database, frontend
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.