https://bugs.kde.org/show_bug.cgi?id=475874
Bug ID: 475874
Summary: Huge mysql.err files filled with [ERROR] Incorrect
definition of table mysql.column_stats: for columns
'hist_type' at position 9 and 'histogram' at position
10
Classification: Applications
Product: digikam
Version: 8.1.0
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: steve...@gmail.com
Target Milestone: ---
Created attachment 162449
--> https://bugs.kde.org/attachment.cgi?id=162449&action=edit
MYSQL error file showing the error messages described above
SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug
symbols.
See
https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***
STEPS TO REPRODUCE
1. Run digikam
2. Look in db_data directory at the size of mysql.err file
3.
OBSERVED RESULT
mysql.err.old contains the following [pair of lines millions of times:
2023-10-20 12:48:32 14 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'hist_type' at position 9 to have type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2023-10-20 12:48:32 14 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
EXPECTED RESULT
No errors in mysql.err, only start and stop messages
SOFTWARE/OS VERSIONS
Windows: 11
macOS:
Linux/KDE Plasma:
(available in About System)
KDE Plasma Version:
KDE Frameworks Version: 5.106.0
Qt Version: 5.15.8
ADDITIONAL INFORMATION
I have tried to modify the columns to the expected definitions. HeidiSQL
confirms that the definitions are now correct, but the errors are still being
reported.
--
You are receiving this mail because:
You are watching all bug changes.
