Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
1.0.7
-
None
-
10.4.27-MariaDB-1:10.4.27+maria~deb10-log mariadb.org binary distribution
-
3.7.3
Description
I tried to query the mysql.slow_log table and got this error:
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xed in position 6795: invalid continuation byte |
|
SystemError: <class 'UnicodeDecodeError'> returned a result with an error set |
|
The above exception was the direct cause of the following exception:
|
|
Traceback (most recent call last):
|
File "./query_slow_log.py", line 13, in <module> |
main()
|
File "./query_slow_log.py", line 9, in main |
cur.fetchall()
|
SystemError: <method 'fetchall' of 'mariadb.connection.cursor' objects> returned a result with an error set |
Here is the test script:
#!/usr/bin/env python3
|
|
import mariadb |
|
def main():
|
conn = mariadb.connect()
|
cur = conn.cursor()
|
cur.execute("SELECT * FROM mysql.slow_log") |
cur.fetchall()
|
conn.close()
|
|
if __name__=='__main__': |
main()
|
Is it possible that the slow_log's sql_text column content is 'latin-1'? And since Connection.charactar_set is always utf8mb4 this error might pop up? If that's the case is there anything I can do about it?