[MXS-4955] Character set 'utf8mb3' is not supported Created: 2024-01-24  Updated: 2024-01-24  Resolved: 2024-01-24

Status: Closed
Project: MariaDB MaxScale
Component/s: readconnroute
Affects Version/s: 23.08.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Patrick Vandenbosch Assignee: markus makela
Resolution: Duplicate Votes: 0
Labels: None
Environment:

dev

Attachments: File main.py    
Issue Links:
Duplicate
duplicates MXS-4898 MaxScale sends wrong character set (s... Closed

 Description   

Hello,

I simple connection to mariadb 10.11.6 using mariadb connector python 1.1.9 with a database created with character set utf8mb3 is not working when the connection is done via maxscale 23.08.4, reporting this error :

Error connecting to the database: Character set 'utf8mb3' is not supported

Connecting to the same backend server/same db/same connector, but via maxscale 6.4.13 gives no problem

(via maxscale 23.08.4)
D:\>py D:\Downloads\maxscale\test_case\with_query\main.py
Error connecting to the database: Character set 'utf8mb3' is not supported

(via maxscale 6.4.13)
D:\>py D:\Downloads\maxscale\test_case\with_query\main.py
('10.11.6-MariaDB-log',)

Could you check please? (attached the python script example)

Thank you

 Comments   
Comment by markus makela [ 2024-01-24 ]

Can you try if adding connection_metadata=foo=bar to the listeners makes the problem go away? If it does, it might be caused by MXS-4898.

Comment by Patrick Vandenbosch [ 2024-01-24 ]

I confirm it is working with connection_metadata=foo=bar.

I guess I'll wait for version 23.08.5 then.

Comment by markus makela [ 2024-01-24 ]

Closing as a duplicate of MXS-4898. As mentioned, the workaround is to just set connection_metadata to some value that doesn't contain character_set_client.

Generated at Thu Feb 08 04:32:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.