pymysql error 1193 Unknown system variable tx_isolation

[ifuchs]

I just upgraded MySQL to the current version 8 (from a very old version) and now I find that I am getting an error on engine.connect of the form (pymysql.err.internalError) (1193, Unknown system variable' tx_isolation). I am running sqlalchemy v 13.13 and pymysql v 0.9.3.

[zzzeek]

hi there -

something about your MySQL server is not sending out a version detection string that is expected. Can you go to your MySQL console and send the results of:

"SELECT VERSION()"

example:

Server version: 8.0.16 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.16    |
+-----------+
1 row in set (0.006 sec)

[zzzeek]

also please indicate if you are using any kind of high level proxy servers like ProxySQL or MaxScale.

[ifuchs]

mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.19 | +-----------+ 1 row in set (0.00 sec) I am not running any proxy servers.

…

On Feb 18, 2020, at 8:34 PM, mike bayer ***@***.***> wrote: hi there - something about your MySQL server is not sending out a version detection string that is expected. Can you go to your MySQL console and send the results of: "SELECT VERSION()" example: Server version: 8.0.16 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> SELECT VERSION(); +-----------+ | VERSION() | +-----------+ | 8.0.16 | +-----------+ 1 row in set (0.006 sec) — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#5161?email_source=notifications&email_token=ABLDPSBELSNFVYNDIS364ZLRDSEDXA5CNFSM4KXPXYXKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMGAJMI#issuecomment-587990193>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABLDPSCWLRITNHF6TVYVLSTRDSEDXANCNFSM4KXPXYXA>.

[ifuchs]

Not sure how or why, but it is now working.

…

On Feb 18, 2020, at 8:53 PM, Ira Fuchs ***@***.***> wrote: mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.19 | +-----------+ 1 row in set (0.00 sec) I am not running any proxy servers. > On Feb 18, 2020, at 8:34 PM, mike bayer ***@***.*** ***@***.***>> wrote: > > hi there - > > something about your MySQL server is not sending out a version detection string that is expected. Can you go to your MySQL console and send the results of: > > "SELECT VERSION()" > > example: > > Server version: 8.0.16 MySQL Community Server - GPL > > Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > > MySQL [(none)]> SELECT VERSION(); > +-----------+ > | VERSION() | > +-----------+ > | 8.0.16 | > +-----------+ > 1 row in set (0.006 sec) > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub <#5161?email_source=notifications&email_token=ABLDPSBELSNFVYNDIS364ZLRDSEDXA5CNFSM4KXPXYXKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMGAJMI#issuecomment-587990193>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABLDPSCWLRITNHF6TVYVLSTRDSEDXANCNFSM4KXPXYXA>. >

[zzzeek]

yes I have a feeling you were running an old SQLAlchemy somehwere. do you have a stack trace from the error scenario?

[zzzeek]

no issue here

[Skyler1017]

same issue here...
I am using mysql 5.6.28

[Skyler1017]

upgrade sqlalchemy and the problem is solved!
1.1.0 -> 1.3.18

hope this helps.