[Bug] (1146, "Table 'dbgpt.dbgpt_serve_flow' doesn't exist")

[wangjielin5]

Traceback (most recent call last): File "/workspace/ai_display_platform/DB-GPT/dbgpt/app/dbgpt_server.py", line 273, in run_webserver() File "/workspace/ai_display_platform/DB-GPT/dbgpt/app/dbgpt_server.py", line 268, in run_webserver param = initialize_app(param) File "/workspace/ai_display_platform/DB-GPT/dbgpt/app/dbgpt_server.py", line 221, in initialize_app system_app.before_start() File "/workspace/ai_display_platform/DB-GPT/dbgpt/component.py", line 264, in before_start v.before_start() File "/workspace/ai_display_platform/DB-GPT/dbgpt/serve/flow/service/service.py", line 80, in before_start self._pre_load_dag_from_db() File "/workspace/ai_display_platform/DB-GPT/dbgpt/serve/flow/service/service.py", line 177, in _pre_load_dag_from_db entities = self.dao.get_list({}) File "/workspace/ai_display_platform/DB-GPT/dbgpt/storage/metadata/_base_dao.py", line 218, in get_list result_list = self._get_entity_list(session, query_request) File "/workspace/ai_display_platform/DB-GPT/dbgpt/storage/metadata/_base_dao.py", line 231, in _get_entity_list result_list = query.all() File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2673, in all return self._iter().all() # type: ignore File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2306, in execute return self._execute_internal( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 2191, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement result = conn.execute( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1421, in execute return meth( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 514, in _execute_on_connection return connection._execute_clauseelement( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1643, in _execute_clauseelement ret = self._execute_context( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1849, in _execute_context return self._exec_single_context( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1989, in _exec_single_context self._handle_dbapi_exception( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2356, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1970, in _exec_single_context self.dialect.do_execute( File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute cursor.execute(statement, parameters) File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute result = self._query(query) File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 825, in _read_query_result result.read() File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 1199, in read first_packet = self.connection._read_packet() File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_packet packet.raise_for_error() File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "/root/anaconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'dbgpt.dbgpt_serve_flow' doesn't exist") [SQL: SELECT dbgpt_serve_flow.id AS dbgpt_serve_flow_id, dbgpt_serve_flow.uid AS dbgpt_serve_flow_uid, dbgpt_serve_flow.dag_id AS dbgpt_serve_flow_dag_id, dbgpt_serve_flow.label AS dbgpt_serve_flow_label, dbgpt_serve_flow.name AS dbgpt_serve_flow_name, dbgpt_serve_flow.flow_category AS dbgpt_serve_flow_flow_category, dbgpt_serve_flow.flow_data AS dbgpt_serve_flow_flow_data, dbgpt_serve_flow.description AS dbgpt_serve_flow_description, dbgpt_serve_flow.state AS dbgpt_serve_flow_state, dbgpt_serve_flow.error_message AS dbgpt_serve_flow_error_message, dbgpt_serve_flow.source AS dbgpt_serve_flow_source, dbgpt_serve_flow.source_url AS dbgpt_serve_flow_source_url, dbgpt_serve_flow.version AS dbgpt_serve_flow_version, dbgpt_serve_flow.define_type AS dbgpt_serve_flow_define_type, dbgpt_serve_flow.editable AS dbgpt_serve_flow_editable, dbgpt_serve_flow.user_name AS dbgpt_serve_flow_user_name, dbgpt_serve_flow.sys_code AS dbgpt_serve_flow_sys_code, dbgpt_serve_flow.gmt_created AS dbgpt_serve_flow_gmt_created, dbgpt_serve_flow.gmt_modified AS dbgpt_serve_flow_gmt_modified FROM dbgpt_serve_flow] (Background on this error at: https://sqlalche.me/e/20/f405)

[Aries-ckt]

what DB-GPT version use and What's your LOCAL_DB_TYPE in .env file?

[thor9king]

same error

dbgpt, version 0.5.10 .env设置：

MYSQL database

LOCAL_DB_TYPE=mysql LOCAL_DB_USER=gold_com_wind LOCAL_DB_PASSWORD=* LOCAL_DB_HOST=**** LOCAL_DB_PORT=3306 LOCAL_DB_NAME=gold_com_wind 启动时报错： sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'gold_com_wind.dbgpt_serve_flow' doesn't exist") [SQL: SELECT dbgpt_serve_flow.id AS dbgpt_serve_flow_id, dbgpt_serve_flow.uid AS dbgpt_serve_flow_uid, dbgpt_serve_flow.dag_id AS dbgpt_serve_flow_dag_id, dbgpt_serve_flow.label AS dbgpt_serve_flow_label, dbgpt_serve_flow.name AS dbgpt_serve_flow_name, dbgpt_serve_flow.flow_category AS dbgpt_serve_flow_flow_category, dbgpt_serve_flow.flow_data AS dbgpt_serve_flow_flow_data, dbgpt_serve_flow.description AS dbgpt_serve_flow_description, dbgpt_serve_flow.state AS dbgpt_serve_flow_state, dbgpt_serve_flow.error_message AS dbgpt_serve_flow_error_message, dbgpt_serve_flow.source AS dbgpt_serve_flow_source, dbgpt_serve_flow.source_url AS dbgpt_serve_flow_source_url, dbgpt_serve_flow.version AS dbgpt_serve_flow_version, dbgpt_serve_flow.define_type AS dbgpt_serve_flow_define_type, dbgpt_serve_flow.editable AS dbgpt_serve_flow_editable, dbgpt_serve_flow.variables AS dbgpt_serve_flow_variables, dbgpt_serve_flow.user_name AS dbgpt_serve_flow_user_name, dbgpt_serve_flow.sys_code AS dbgpt_serve_flow_sys_code, dbgpt_serve_flow.gmt_created AS dbgpt_serve_flow_gmt_created, dbgpt_serve_flow.gmt_modified AS dbgpt_serve_flow_gmt_modified FROM dbgpt_serve_flow] (Background on this error at: https://sqlalche.me/e/20/f405)