An error was reported during migration

[pfinal-nc]

IMPORTANT: Sorry, there was a database connection failure while running the migration,Specifically as follows

To Reproduce

1. Run command python manage.py db upgrade An error occurred:

Traceback (most recent call last):
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3288, in raw_connection
    return self.pool.connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 1268, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
    rec = pool._do_get()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 283, in _do_get
    return self._create_connection()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
    self.__connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 903, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 147, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 616, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 352, in __init__
    self.connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 636, in connect
    self._request_authentication()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 911, in _request_authentication
    auth_packet = self._read_packet()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 729, in _read_packet
    packet.raise_for_error()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'172.100.0.1' (using password: YES)")

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

Traceback (most recent call last):
  File "manage.py", line 15, in <module>
    manage.run()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/flask_script/__init__.py", line 417, in run
    result = self.handle(argv[0], argv[1:])
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/flask_script/__init__.py", line 386, in handle
    res = handle(*args, **config)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/flask_script/commands.py", line 216, in __call__
    return self.run(*args, **kwargs)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/flask_migrate/__init__.py", line 96, in wrapped
    f(*args, **kwargs)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/flask_migrate/__init__.py", line 271, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/alembic/command.py", line 378, in upgrade
    script.run_env()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/alembic/script/base.py", line 576, in run_env
    util.load_python_file(self.dir, "env.py")
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
    module = load_module_py(module_id, path)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "migrations/env.py", line 96, in <module>
    run_migrations_online()
  File "migrations/env.py", line 81, in run_migrations_online
    with connectable.connect() as connection:
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3264, in connect
    return self._connection_cls(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 148, in __init__
    err, dialect, engine
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2426, in _handle_dbapi_exception_noconnection
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3288, in raw_connection
    return self.pool.connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 1268, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
    rec = pool._do_get()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 283, in _do_get
    return self._create_connection()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
    self.__connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 903, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 147, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 616, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 352, in __init__
    self.connect()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 636, in connect
    self._request_authentication()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 911, in _request_authentication
    auth_packet = self._read_packet()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/connections.py", line 729, in _read_packet
    packet.raise_for_error()
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "//Users/pfinal/.pyenv/versions/3.7.16/envs/base3.7/lib/python3.7/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'172.100.0.1' (using password: YES)")
(Background on this error at: https://sqlalche.me/e/20/e3q8)

2. But this is true when using other linked databases

   res = db.session.execute(text('show databases'))
    print(res.fetchall())

[('information_schema',), ('crm',), ('mysql',), ('performance_schema',), ('smm',), ('sys',)]

Use is Flask-Migrate==2.6.0, Flask-SQLAlchemy==3.0.3

[miguelgrinberg]

Please do not write issues when you do not have a concrete bug to report. The proper procedure is to ask in the discussions board. If an issue is discovered, it can be filed at the time.

Your exception indicates that you have permission issues yourself, this does not appear to be anything related to Flask-Migrate:

pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'172.100.0.1' (using password: YES)")

[pfinal-nc]

Yeah, I combed through the env file and found it

config.set_main_option(
    'sqlalchemy.url',
    str(current_app.extensions['migrate'].db.engine.url).replace('%', '%%')) 

sqlalchemy.url The database password is hidden Replaced with ***

[miguelgrinberg]

Okay, great. Please see #505, hopefully that will address this issue.

[pfinal-nc]

I replaced the *** with my own password by.replace('%', '%'),I just don't think it's elegant if there's a better solution。

Thx

[miguelgrinberg]

There is a newer env.py that you can use. To make the update, save your migration scripts, delete your migration repository, make a new one, then restore your migration scripts. See the referenced issue for additional context.

[pfinal-nc]

This is how the problem has been solved for now. Thank you