Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql connector utf8 problem #1

Open
iagapov opened this issue Aug 24, 2022 · 0 comments
Open

mysql connector utf8 problem #1

iagapov opened this issue Aug 24, 2022 · 0 comments

Comments

@iagapov
Copy link
Collaborator

iagapov commented Aug 24, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant