poetry run python -m flask db upgrade 数据库迁移失败

[shanaozi]

Self Checks

• I have searched for existing issues search for existing issues, including closed ones.
• I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
• [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:）
• Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing? Tell me about your story.

poetry run python -m flask db upgrade
D:\dify\dify-local\dify\api.venv\lib\site-packages\pydub\utils.py:170: RuntimeWarning: Couldn't find ffmpeg or avconv - defaulting to ffmpeg, but may not work
warn("Couldn't find ffmpeg or avconv - defaulting to ffmpeg, but may not work", RuntimeWarning)
2024-07-31 06:12:36,756.756 WARNING [MainThread] [ext_mail.py:50] - MAIL_TYPE is not set
Traceback (most recent call last):
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 146, in init
self._dbapi_connection = engine.raw_connection()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 3300, in raw_connection
return self.pool.connect()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout
rec = pool._do_get()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\impl.py", line 179, in _do_get
with util.safe_reraise():
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get
return self._create_connection()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 674, in init
self.__connect()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 900, in __connect
with util.safe_reraise():
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool.invoke_creator(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\default.py", line 620, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\psycopg2_init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "D:\pyenv\pyenv\pyenv-win-master\pyenv-win\versions\3.10.11\lib\runpy.py", line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File "D:\pyenv\pyenv\pyenv-win-master\pyenv-win\versions\3.10.11\lib\runpy.py", line 86, in run_code
exec(code, run_globals)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask_main.py", line 3, in
main()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask\cli.py", line 1105, in main
cli.main()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 1078, in main
rv = self.invoke(ctx)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask\cli.py", line 386, in decorator
return ctx.invoke(f, *args, **kwargs)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\click\core.py", line 783, in invoke
return _callback(*args, **kwargs)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask_migrate\cli.py", line 154, in upgrade
upgrade(directory, revision, sql, tag, x_arg)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask_migrate_init.py", line 111, in wrapped
f(*args, **kwargs)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\flask_migrate_init.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\alembic\command.py", line 406, in upgrade
script.run_env()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\alembic\script\base.py", line 582, in run_env
util.load_python_file(self.dir, "env.py")
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "", line 883, in exec_module
File "", line 241, in _call_with_frames_removed
File "D:\dify\dify-local\dify\api\migrations\env.py", line 112, in
run_migrations_online()
File "D:\dify\dify-local\dify\api\migrations\env.py", line 96, in run_migrations_online
with connectable.connect() as connection:
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 3276, in connect
return self._connection_cls(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 148, in init
Connection._handle_dbapi_exception_noconnection(
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 2440, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 146, in init
self._dbapi_connection = engine.raw_connection()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\base.py", line 3300, in raw_connection
return self.pool.connect()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout
rec = pool._do_get()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\impl.py", line 179, in _do_get
with util.safe_reraise():
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get
return self._create_connection()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 674, in init
self.__connect()
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 900, in __connect
with util.safe_reraise():
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool.invoke_creator(self)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\sqlalchemy\engine\default.py", line 620, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
File "D:\dify\dify-local\dify\api.venv\lib\site-packages\psycopg2_init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)
(Background on this error at: https://sqlalche.me/e/20/e3q8)

2. Additional context or comments

No response