[MXS-4273] command "show shards" or "show databases" encoding output Created: 2022-09-05  Updated: 2022-09-07  Resolved: 2022-09-07

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: 6.4.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ivan Assignee: markus makela
Resolution: Incomplete Votes: 0
Labels: None
Environment:

OS Oracle Linux 8

Attachments: PNG File Screenshot 2022-08-10 at 09.04.19.png     Text File mysql-status.txt    

 Description   

Hi! i'm try to test schemarouter , and have several problem
When i'm connect to maxscale schemarouter service from console (mysql client) and try to run command "show shards" or "show databases" , output encoding for example 0x696E666F726D6174696F6EF736368656D61

but if i'm connected to readwritesplit , all output is ok

 Comments   
Comment by markus makela [ 2022-09-05 ]

Usachev What's the client and server character sets you are using and what is the expected output?

Comment by Ivan [ 2022-09-05 ]

@markus makela

Server version: 5.7.35-38-log Percona Server (GPL), Release 38, Revision 3692a61
-------------------------------------------------------------+

Variable_name Value

-------------------------------------------------------------+

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/percona-server/charsets/

-------------------------------------------------------------+
8 rows in set (0.00 sec)

Comment by markus makela [ 2022-09-06 ]

This is probably caused by the fact that the schemarouter uses the binary character set for the resultsets it creates to show the database names. I tested this using the mysql client from the Percona Server 5.7 docker image and it seems to work as expected and the database names are printed correctly. Can you print the output of the status command from the command line client you are using that produces these sorts of results?

Comment by Ivan [ 2022-09-07 ]

Markus , i'm try to upgrade up 6.4.2 and right now all is ok!

mysql-status.txt

Comment by markus makela [ 2022-09-07 ]

So it works OK with 6.4.2?

Comment by Ivan [ 2022-09-07 ]

yes

Comment by markus makela [ 2022-09-07 ]

In that case I'll close it as Incomplete since the problem seems to have been fixed by something else.

Comment by Ivan [ 2022-09-07 ]

yes, sure

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