there is a error: "psycopg2.errors.UndefinedTable" when asset Materialization

[wangm23456]

version: 0.11.10
PostgreSQL 13.3 docker image

main error:
psycopg2.errors.UndefinedTable: relation "asset_keys" does not exist LINE 2: FROM asset_keys ^

complete output :

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "asset_keys" does not exist LINE 2: FROM asset_keys ^ [SQL: SELECT asset_keys.asset_key FROM asset_keys] (Background on this error at: http://sqlalche.me/e/14/f405)
  File "/home/nonroot/.local/lib/python3.8/site-packages/dagster_graphql/implementation/utils.py", line 14, in _fn
    return fn(*args, **kwargs)
  File "/home/nonroot/.local/lib/python3.8/site-packages/dagster_graphql/implementation/fetch_assets.py", line 15, in get_assets
    asset_keys = instance.all_asset_keys(prefix_path=prefix_path)
  File "/home/nonroot/.local/lib/python3.8/site-packages/dagster/core/instance/__init__.py", line 955, in all_asset_keys
    return self._event_storage.get_all_asset_keys(prefix_path)
  File "/home/nonroot/.local/lib/python3.8/site-packages/dagster/core/storage/event_log/sql_event_log.py", line 612, in get_all_asset_keys
    self._lazy_migrate_secondary_index_asset_key(
  File "/home/nonroot/.local/lib/python3.8/site-packages/dagster/core/storage/event_log/sql_event_log.py", line 621, in _lazy_migrate_secondary_index_asset_key
    results = conn.execute(db.select([AssetKeyTable.c.asset_key])).fetchall()
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1262, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 329, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
    ret = self._execute_context(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
    self._handle_dbapi_exception(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
    util.raise_(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
    self.dialect.do_execute(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
    cursor.execute(statement, parameters)
The above exception was caused by the following exception:
psycopg2.errors.UndefinedTable: relation "asset_keys" does not exist LINE 2: FROM asset_keys ^
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
    self.dialect.do_execute(
  File "/home/nonroot/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
    cursor.execute(statement, parameters)

in postgreSQL

2021-05-27 09:10:00.710 UTC [112] ERROR:  relation "asset_keys" does not exist at character 35
2021-05-27 09:10:00.710 UTC [112] STATEMENT:  SELECT asset_keys.asset_key 
	FROM asset_keys

[sryza]

@prha thoughts on the best way to debug? @wangm23456 is it possible that you upgraded to a new Dagster version without running a database migration?

[prha]

@wangm23456 if you recently upgraded the dagster package from before version 0.10.0 to something post 0.10.0, you may need to run dagster instance migrate to make sure your DB schema is up to date.