Error Message "Can't validate argument 'dialect_options'; can't locate any SQLAlchemy dialect named 'dialect'"

[jvanderen1]

PGSync version

Version: 3.1.0

Postgres version

14.5

Elasticsearch/OpenSearch version

Elasticsearch 8.5.3

Redis version

7.0.15

Python version

3.11.6

Problem Description

I notice when I start pgsync, I get the following message at the beginning:

.python_venv/lib/python3.11/site-packages/pgsync/base.py:220: SAWarning: Can't validate argument 'dialect_options'; can't locate any SQLAlchemy dialect named 'dialect'

Everything seems to be running fine, but this error is concerning.

[toluaina]

Can't seem to be able to replicate this. any idea what version of SQLAlchemy was used?

[jvanderen1]

@toluaina Here is a subset of my Python packages:

pgsync==3.1.0 \
    --hash=sha256:f6183d51adeb5ac0dc3ab9620d1c21f32afc5cc38b4baf013fa61b157f55976b
elasticsearch==8.11.1 \
    --hash=sha256:a98309cee11fef8d6750f388683e9a8005da94bdfd940b36ef85cb6cc53186c7
sqlalchemy==2.0.25 \
    --hash=sha256:29049e2c299b5ace92cbed0c1610a7a236f3baf4c6b66eb9547c01179f638ec5
sqlparse==0.4.4 \
    --hash=sha256:5430a4fe2ac7d0f93e66f1efc6e1338a41884b7ddf2a350cedd20ccc4d9d28f3