[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #17 from Steve Franks --- I think the problem is due to the digikan data directory being empty. I have no idea where the data disappeared to, but will retrieve it from backup and try again. Sorry for troubling you Regards Steve On Sun, 12 Nov 2023 at 16:10, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=475874 > > --- Comment #16 from Maik Qualmann --- > Another thing, the path to "mysql_upgrade" is in your home directory. The > server uses the same instance as the path or the same MariaDB version? > > Maik > > -- > You are receiving this mail because: > You reported the bug. > You are on the CC list for the bug. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #16 from Maik Qualmann --- Another thing, the path to "mysql_upgrade" is in your home directory. The server uses the same instance as the path or the same MariaDB version? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #15 from Maik Qualmann --- If the "mysql_upgrade" fails, the database may not be clean. We need to do this upgrade due to the many changes to the internal database structure with almost every new MariaDB release. Other projects that manage an internal database also do this (e.g. Akonadi). Are there any messages in the MySQL error log in the database directory? Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #14 from Steve Franks --- My Windows laptop is working fine with 8.2. I didn’t modify the Linux data, simply downloaded the 8.2 appimage and ran it. It surprised me when it displayed the missing MySQL dialogue. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #13 from Maik Qualmann --- While you changed the system tables manually, you certainly created a backup. You could use this now. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #12 from Maik Qualmann --- We now run "mysql_upgrade" at every start in order to adapt the database when the server software is updated. Since you have already tried to correct the system tables of the database manually, the "mysql_upgrade" will fail here because the database version does not match the changes. I think you need to start with a new database in this case. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 caulier.gil...@gmail.com changed: What|Removed |Added Version|8.1.0 |8.2.0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #11 from Steve Franks --- I tried again with Mariadb 11.3 Alpha and it displayed the same error. Regards Steve On Thu, 26 Oct 2023 at 17:54, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=475874 > > --- Comment #9 from Maik Qualmann --- > The problem is that when users have problems with MySQL, they start digiKam > more often and then we only have the last log. The old error log file is > now > deleted after 100MB and starts again from the beginning. We can of course > reduce 100MB, but I don't think it's too big at the moment. > > Maik > > -- > You are receiving this mail because: > You are on the CC list for the bug. > You reported the bug. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #10 from Steve Franks --- I downloaded 8.2.0 appimage for Linux. I have not updated Mariadb, because I already have a recent version. When I start the appimage it says that it can't find Mariadb. I found and set the correct folders, but then the upgrade fails with an unknown error (see attached screenshot). Regards Steve On Thu, 26 Oct 2023 at 17:54, Maik Qualmann wrote: > https://bugs.kde.org/show_bug.cgi?id=475874 > > --- Comment #9 from Maik Qualmann --- > The problem is that when users have problems with MySQL, they start digiKam > more often and then we only have the last log. The old error log file is > now > deleted after 100MB and starts again from the beginning. We can of course > reduce 100MB, but I don't think it's too big at the moment. > > Maik > > -- > You are receiving this mail because: > You are on the CC list for the bug. > You reported the bug. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #9 from Maik Qualmann --- The problem is that when users have problems with MySQL, they start digiKam more often and then we only have the last log. The old error log file is now deleted after 100MB and starts again from the beginning. We can of course reduce 100MB, but I don't think it's too big at the moment. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #8 from Steve Franks --- The mysql.err file is currently about 2mb, the mysql.err.old file grows after every digikam session. Would it not be better to delete the old file and rename mysql.err to mysql.err.old at the beginning of each digikam session. I can't think of a reason to keep for nearly 2 weeks (mysql.err.old contains messages from 14th October to today (26th October)) -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #7 from Maik Qualmann --- Git commit 51f425ecf2647e5f4a97eb275055a4f031904c4c by Maik Qualmann. Committed on 22/10/2023 at 21:12. Pushed by mqualmann into branch 'master'. limit the file size to 100MB of the old MySQL error log file M +7-1core/libs/database/server/databaseserver.cpp https://invent.kde.org/graphics/digikam/-/commit/51f425ecf2647e5f4a97eb275055a4f031904c4c -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #6 from Maik Qualmann --- Git commit d5d923389605ffe66be61f73d10ed88d4bcfc161 by Maik Qualmann. Committed on 21/10/2023 at 14:20. Pushed by mqualmann into branch 'master'. add the mysql upgrade command as required binary M +6-3core/libs/album/manager/albummanager_database.cpp M +2-1core/libs/database/CMakeLists.txt M +135 -120 core/libs/database/engine/dbengineparameters.cpp M +9-2core/libs/database/engine/dbengineparameters.h M +25 -17 core/libs/database/server/databaseserver.cpp M +9-6core/libs/database/utils/widgets/dbsettingswidget.cpp M +5-3core/libs/database/utils/widgets/dbsettingswidget_p.h C +3-3core/libs/database/utils/widgets/mysqlserverbinary.cpp [from: core/libs/database/utils/widgets/mysqlservbinary.cpp - 089% similarity] C +7-7core/libs/database/utils/widgets/mysqlserverbinary.h [from: core/libs/database/utils/widgets/mysqlservbinary.h - 068% similarity] R +8-8core/libs/database/utils/widgets/mysqlupgradebinary.cpp [from: core/libs/database/utils/widgets/mysqlservbinary.cpp - 059% similarity] R +10 -10 core/libs/database/utils/widgets/mysqlupgradebinary.h [from: core/libs/database/utils/widgets/mysqlservbinary.h - 050% similarity] M +36 -26 core/tests/database/databasemysqlinit_utest.cpp M +36 -26 core/tests/database/databaseswitch_utest.cpp https://invent.kde.org/graphics/digikam/-/commit/d5d923389605ffe66be61f73d10ed88d4bcfc161 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #5 from Maik Qualmann --- Note: I can't say whether an upgrade to the current server version is still possible for you because you have already edited the internal MySQL system table. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added Version Fixed In||8.2.0 Resolution|--- |FIXED Status|REPORTED|RESOLVED Latest Commit||https://invent.kde.org/grap ||hics/digikam/-/commit/020aa ||6b7c3f7f5de7fa40a146a3a9918 ||ace6a2a0 --- Comment #4 from Maik Qualmann --- Git commit 020aa6b7c3f7f5de7fa40a146a3a9918ace6a2a0 by Maik Qualmann. Committed on 20/10/2023 at 23:01. Pushed by mqualmann into branch 'master'. always perform a MySQL database upgrade If the server version is not newer than the database, no upgrade will be carried out automatically. In the case of a newer server version, an upgrade is carried out and a simple progress dialog is displayed. FIXED-IN: 8.2.0 M +1-1NEWS M +63 -68 core/libs/database/server/databaseserver.cpp M +2-2core/libs/database/server/databaseserver.h https://invent.kde.org/graphics/digikam/-/commit/020aa6b7c3f7f5de7fa40a146a3a9918ace6a2a0 -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] Huge mysql.err files filled with [ERROR] Incorrect definition of table mysql.column_stats.
https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added Summary|Huge mysql.err files filled |Huge mysql.err files filled |with [ERROR] Incorrect |with [ERROR] Incorrect |definition of table |definition of table |mysql.column_stats: for |mysql.column_stats. |columns 'hist_type' at | |position 9 and 'histogram' | |at position 10 | -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] 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
https://bugs.kde.org/show_bug.cgi?id=475874 Maik Qualmann changed: What|Removed |Added CC||metzping...@gmail.com --- Comment #3 from Maik Qualmann --- After the log, use the internal MySQL server from digiKam. You have installed newer versions from the server without a "MySQL_upgrade" command for the database. We only do this in an absolute error if the server no longer starts. We will probably have to do it in the future at every start. Maik -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] 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
https://bugs.kde.org/show_bug.cgi?id=475874 Steve Franks changed: What|Removed |Added CC||steve...@gmail.com -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] 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
https://bugs.kde.org/show_bug.cgi?id=475874 --- Comment #2 from Steve Franks --- MariaDB 11.0.2 and 11.2.1. This does not seem to affect the working of digikam, but mysql.err.old has grown to 6.3gb, which is a waste of space. -- You are receiving this mail because: You are watching all bug changes.
[digikam] [Bug 475874] 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
https://bugs.kde.org/show_bug.cgi?id=475874 caulier.gil...@gmail.com changed: What|Removed |Added CC||caulier.gil...@gmail.com --- Comment #1 from caulier.gil...@gmail.com --- Which Mysql or MariaDb version did you use exactly ? Gilles Caulier -- You are receiving this mail because: You are watching all bug changes.
