Metadata inconsistent

[Magicloud]

Bug description

While importing metadata to GraphQL, got this warning.

Steps to reproduce

In Ubuntu container env,

apt update -y
apt install -y git wget netcat
wget https://github.com/hasura/graphql-engine/releases/download/v2.12.0/cli-hasura-linux-amd64 -O /usr/bin/hasura
chmod a+x /usr/bin/hasura
git clone --filter=tree:0 -b v3.2.0 https://github.com/forbole/bdjuno
cd bdjuno/hasura
hasura metadata apply --endpoint "http://${HASURA_GRAPHQL_ENDPOINT}:8080" --admin-secret "${HASURA_GRAPHQL_ADMIN_SECRET}"
hasura metadata ic list --endpoint "http://${HASURA_GRAPHQL_ENDPOINT}:8080"

Expected behavior

I do not know what is the proper output. hasura metadata apply warned me

{"level":"warning","msg":"Metadata is inconsistent","time":"2022-10-11T16:22:09Z"}
{"level":"warning","msg":"Use 'hasura metadata ic list' command to list inconsistent objects","time":"2022-10-11T16:22:09Z"}

I ran hasura metadata ic list and got this:

  NAME                                TYPE      DESCRIPTION                                            REASON                                

  genesis                             table     {"name":"genesis","schema":"public"}...                Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "genesis"                             
  token_price_history                 table     {"name":"token_price_history","schema":"public"}...    Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "token_price_history"                 
  community_pool                      table     {"name":"community_pool","schema":"public"}...         Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "community_pool"                      
  average_block_time_per_day          table     {"name":"average_block_time_per_day","schema":"pub...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "average_block_time_per_day"          
  slashing_params                     table     {"name":"slashing_params","schema":"public"}...        Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "slashing_params"                     
  validator_description               table     {"name":"validator_description","schema":"public"}...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_description"               
  average_block_time_from_genesis     table     {"name":"average_block_time_from_genesis","schema"...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "average_block_time_from_genesis"     
  mint_params                         table     {"name":"mint_params","schema":"public"}...            Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "mint_params"                         
  validator_info                      table     {"name":"validator_info","schema":"public"}...         Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_info"                      
  average_block_time_per_hour         table     {"name":"average_block_time_per_hour","schema":"pu...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "average_block_time_per_hour"         
  fee_grant_allowance                 table     {"name":"fee_grant_allowance","schema":"public"}...    Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "fee_grant_allowance"                 
  validator                           table     {"name":"validator","schema":"public"}...              Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator"                           
  staking_pool                        table     {"name":"staking_pool","schema":"public"}...           Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "staking_pool"                        
  validator_voting_power              table     {"name":"validator_voting_power","schema":"public"...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_voting_power"              
  staking_params                      table     {"name":"staking_params","schema":"public"}...         Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "staking_params"                      
  proposal_staking_pool_snapshot      table     {"name":"proposal_staking_pool_snapshot","schema":...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal_staking_pool_snapshot"      
  transaction                         table     {"name":"transaction","schema":"public"}...            Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "transaction"                         
  validator_signing_info              table     {"name":"validator_signing_info","schema":"public"...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_signing_info"              
  proposal_deposit                    table     {"name":"proposal_deposit","schema":"public"}...       Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal_deposit"                    
  modules                             table     {"name":"modules","schema":"public"}...                Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "modules"                             
  proposal                            table     {"name":"proposal","schema":"public"}...               Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal"                            
  double_sign_evidence                table     {"name":"double_sign_evidence","schema":"public"}...   Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "double_sign_evidence"                
  proposal_tally_result               table     {"name":"proposal_tally_result","schema":"public"}...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal_tally_result"               
  block                               table     {"name":"block","schema":"public"}...                  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "block"                               
  vesting_account                     table     {"name":"vesting_account","schema":"public"}...        Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "vesting_account"                     
  distribution_params                 table     {"name":"distribution_params","schema":"public"}...    Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "distribution_params"                 
  token_price                         table     {"name":"token_price","schema":"public"}...            Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "token_price"                         
  vesting_period                      table     {"name":"vesting_period","schema":"public"}...         Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "vesting_period"                      
  token                               table     {"name":"token","schema":"public"}...                  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "token"                               
  message                             table     {"name":"message","schema":"public"}...                Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "message"                             
  validator_commission                table     {"name":"validator_commission","schema":"public"}...   Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_commission"                
  token_unit                          table     {"name":"token_unit","schema":"public"}...             Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "token_unit"                          
  supply                              table     {"name":"supply","schema":"public"}...                 Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "supply"                              
  validator_status                    table     {"name":"validator_status","schema":"public"}...       Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "validator_status"                    
  average_block_time_per_minute       table     {"name":"average_block_time_per_minute","schema":"...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "average_block_time_per_minute"       
  double_sign_vote                    table     {"name":"double_sign_vote","schema":"public"}...       Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "double_sign_vote"                    
  pre_commit                          table     {"name":"pre_commit","schema":"public"}...             Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "pre_commit"                          
  account                             table     {"name":"account","schema":"public"}...                Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "account"                             
  proposal_validator_status_snapshot  table     {"name":"proposal_validator_status_snapshot","sche...  Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal_validator_status_snapshot"  
  inflation                           table     {"name":"inflation","schema":"public"}...              Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "inflation"                           
  gov_params                          table     {"name":"gov_params","schema":"public"}...             Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "gov_params"                          
  proposal_vote                       table     {"name":"proposal_vote","schema":"public"}...          Inconsistent object: no such          
                                                                                                       table/view exists in source:          
                                                                                                       "proposal_vote"                       
  messages_by_address                 function  {"name":"messages_by_address","schema":"public"}...    Inconsistent                          
                                                                                                       object: in function                   
                                                                                                       "messages_by_address":                
                                                                                                       no such function exists:              
                                                                                                       "messages_by_address"

[Magicloud]

Seems like just my misconfiguration.

[piotr-sikora-v]

@Magicloud Hi, I have same problem... how do you fixed this ?

[Magicloud]

@Magicloud Hi, I have same problem... how do you fixed this ?

@piotr-sikora-v I cannot remember exactly. I think the cause was that the graphql init started before DB init job finished.

[Maksat-luci]

@Magicloud Hi, I have same problem... how do you fixed this ?

hey bro how you fix that?

[Magicloud]

@Magicloud Hi, I have same problem... how do you fixed this ?

hey bro how you fix that?

@Maksat-luci I did not actually figure out the cause. Just follow the document exactly, and ensured every step finished before I started next step.