Skip to content

mysql connector utf8 problem #1

@iagapov

Description

@iagapov

petra = PetraMachineAdapter.create_for_simulation() throws an exception in mysql connecto, like so

cnx = mysql.connector.connect(user="root", password="admin", host="localhost", port=3306, database="sim_db")
Traceback (most recent call last):
File "", line 1, in
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/pooling.py", line 287, in connect
"Failed adding connection; queue is full")
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/connection.py", line 137, in init
[str(x) for x in version.VERSION[0:3]]
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/abstracts.py", line 1095, in connect
isolation_level=None, readonly=None):
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/connection.py", line 544, in _open_connection

File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/abstracts.py", line 1271, in set_converter_class

File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/conversion.py", line 136, in init
Escapes special characters as they are expected to by when MySQL
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/conversion.py", line 59, in init
self.str_fallback = str_fallback
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/conversion.py", line 73, in set_charset
def set_unicode(self, value=True):
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/constants.py", line 775, in get_charset_info
NO_UNSIGNED_SUBTRACTION = 'NO_UNSIGNED_SUBTRACTION'
File "/Users/ia/workspace/ml/acss/acss-services/demos/.venv/lib/python3.8/site-packages/mysql/connector/constants.py", line 746, in get_default_collation
@classmethod
mysql.connector.errors.ProgrammingError: Character set 'utf8' unsupported

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions