Description:
I try to use mysql utilities 1.6.5 in CentOS 7.2(python 2.7)+mysql 8.0.11,
but it does work as shown:
[root@localhost ~]# mysqldiskusage --server=root:123456@localhost
WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ...
Traceback (most recent call last):
File "/usr/bin/mysqldiskusage", line 126, in <module>
servers = connect_servers(source_values, None)
File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 489, in connect_servers
source = get_server(src_name, src_dict, quiet, verbose=verbose)
File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 336, in get_server
server_conn.connect()
File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1104, in connect
res = self.show_server_variable('character_set_client')
File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1391, in show_server_variable
return self.exec_query("SHOW VARIABLES LIKE '%s'" % variable)
File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1327, in exec_query
cur.close()
File "/usr/lib64/python2.7/site-packages/mysql/connector/cursor.py", line 395, in close
self._connection.handle_unread_result()
File "/usr/lib64/python2.7/site-packages/mysql/connector/connection_cext.py", line 599, in handle_unread_result
raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found
How to repeat:
[root@localhost ~]# rpm -qa|grep mysql
mysql-connector-python-cext-8.0.11-1.el7.x86_64
mysql-connector-python-8.0.11-1.el7.x86_64
mysql-utilities-1.6.5-1.el7.noarch
[root@localhost ~]# python
Python 2.7.5 (default, Nov 20 2015, 02:00:19)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>>
[root@localhost ~]# uname -a
Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
Description: I try to use mysql utilities 1.6.5 in CentOS 7.2(python 2.7)+mysql 8.0.11, but it does work as shown: [root@localhost ~]# mysqldiskusage --server=root:123456@localhost WARNING: Using a password on the command line interface can be insecure. # Source on localhost: ... Traceback (most recent call last): File "/usr/bin/mysqldiskusage", line 126, in <module> servers = connect_servers(source_values, None) File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 489, in connect_servers source = get_server(src_name, src_dict, quiet, verbose=verbose) File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 336, in get_server server_conn.connect() File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1104, in connect res = self.show_server_variable('character_set_client') File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1391, in show_server_variable return self.exec_query("SHOW VARIABLES LIKE '%s'" % variable) File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1327, in exec_query cur.close() File "/usr/lib64/python2.7/site-packages/mysql/connector/cursor.py", line 395, in close self._connection.handle_unread_result() File "/usr/lib64/python2.7/site-packages/mysql/connector/connection_cext.py", line 599, in handle_unread_result raise errors.InternalError("Unread result found") mysql.connector.errors.InternalError: Unread result found How to repeat: [root@localhost ~]# rpm -qa|grep mysql mysql-connector-python-cext-8.0.11-1.el7.x86_64 mysql-connector-python-8.0.11-1.el7.x86_64 mysql-utilities-1.6.5-1.el7.noarch [root@localhost ~]# python Python 2.7.5 (default, Nov 20 2015, 02:00:19) [GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> [root@localhost ~]# uname -a Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux [root@localhost ~]# cat /etc/redhat-release CentOS Linux release 7.2.1511 (Core)