[Bug] optuna depending on deprecated feature in sqlalchemy.

[24hours]

Optuna has updated their version to 3.1.0 due to SqlAlchemy upgrade.
optuna/optuna#4304

If installing version ~3.0.0, the follow error will occur.

self = <optuna.storages._rdb.storage._VersionManager object at 0x7f815c5d60d0>
    def get_current_version(self) -> str:
    
        context = alembic.migration.MigrationContext.configure(self.engine.connect())
        version = context.get_current_revision()
>       assert version is not None
E       AssertionError

This is because SQLAlchemy has been updated to version 2.0 and the feature is deprecated.
Hydra currently depending on version 3.0.0 will break due to the upgrade.

https://github.com/facebookresearch/hydra/blob/main/plugins/hydra_optuna_sweeper/setup.py#L32

Currently the work around is installing optuna==3.1.0.

[leezx]

or downgrade to the previous version by pip install sqlalchemy==1.4.46. This works for me.

[Jasha10]

Related to PR #2360