forc index start --embedded-database issue "relation \"index_registry\" does not exist",

[SilentCicero]

I ran into this issue:

~/github/fuel-index$ forc index start     --embedded-database

✅ Successfully started the indexer service at PID 1683
▪▪▪▪▪ ⏱  Setting up database...
                                                                                                                  2023-07-11T11:08:44.907500Z  INFO fuel_indexer::commands::run: 65: Configuration: IndexerConfig { indexer_handler_timeout: 5, log_level: "info", verbose: false, local_fuel_node: false, indexer_net_config: false, fuel_node: FuelClientConfig { host: "localhost", port: "4000" }, graphql_api: GraphQLConfig { host: "localhost", port: "29987", max_body_size: 5242880 }, database: PostgresConfig { user: "postgres", password: "XXXX", host: "localhost", port: "5432", database: "postgres", verbose: "false" }, metrics: false, stop_idle_indexers: false, run_migrations: false, authentication: AuthenticationConfig { enabled: false, strategy: None, jwt_secret: "XXXX", jwt_issuer: None, jwt_expiry: None }, rate_limit: RateLimitConfig { enabled: false, request_count: None, window_size: None }, replace_indexer: false }
2023-07-11T11:08:44.925395Z  INFO pg_embed::command_executor: 144: 2023-07-11 12:08:44.925 WEST [1716] ERROR:  relation "index_registry" does not exist at character 15    
2023-07-11T11:08:44.925410Z  INFO pg_embed::command_executor: 144: 2023-07-11 12:08:44.925 WEST [1716] STATEMENT:  SELECT * FROM index_registry    
Error: Error from sqlx: Database(
    PgDatabaseError {
        severity: Error,
        code: "42P01",
        message: "relation \"index_registry\" does not exist",
        detail: None,
        hint: None,
        position: Some(
            Original(
                15,
            ),
        ),
        where: None,
        schema: None,
        table: None,
        column: None,
        data_type: None,
        constraint: None,
        file: Some(
            "parse_relation.c",
        ),
        line: Some(
            1384,
        ),
        routine: Some(
            "parserOpenTable",
        ),
    },
)

Caused by:
    0: error returned from database: relation "index_registry" does not exist
    1: relation "index_registry" does not exist
^C

This seemed to help resolve it:

# stop it
> forc index postgres stop postgres

# drop it
> forc index postgres drop postgres --remove-persisted

# bop it
> forc index start --embedded-database --fuel-node-host beta-3.fuel.network --fuel-node-port 80 --run-migrations