[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Christophe Giboudeaux changed: What|Removed |Added CC||timo...@mindspring.com --- Comment #15 from Christophe Giboudeaux --- *** Bug 440777 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #14 from Thiago Macieira --- Fix in Qt: https://codereview.qt-project.org/c/qt/qtbase/+/363880 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #13 from Stefan --- > Looks like opensuse packages mariadb-connector-c separately, instead of using > the bundled one in mariadb. So you'll be affected if you update > mariadb-connector-c to 3.2.3, regardless of the mariadb package version. Thank you very much for your analysis, your right. This was a real monday-challenge for a common simple user like me. At first i was confused because no package "mariadb-connector-c" found on my machine. The package is (also?) called libmariadb3 (https://software.opensuse.org/package/libmariadb3) cat /var/log/zypp/history | grep libmariadb3 2021-07-04 08:43:18|install|libmariadb3|3.1.13-2.1 2021-08-07 21:48:18|install|libmariadb3|3.2.3-1.1 sudo zypper install --oldpackage http://download.opensuse.org/tumbleweed/repo/oss/x86_64/libmariadb3-3.1.13-2.1.x86_64.rpm After a reboot, the first sync takes a amount of time, but everything works as before the 2021-08-07. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #12 from Antonio Rojas --- (In reply to Stefan from comment #10) > > What's your mariadb client (not server) version? > > Installed by zypper Looks like opensuse packages mariadb-connector-c separately, instead of using the bundled one in mariadb. So you'll be affected if you update mariadb-connector-c to 3.2.3, regardless of the mariadb package version. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Meinhard Ritscher changed: What|Removed |Added CC||mr203010s...@gmx.net --- Comment #11 from Meinhard Ritscher --- I was hit by this bug too. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #10 from Stefan --- > What's your mariadb client (not server) version? Installed by zypper https://software.opensuse.org/package/mariadb-client $ zypper se -s mariadb-client Repository-Daten werden geladen... Installierte Pakete werden gelesen... S | Name | Type | Version | Arch | Repository --++---+-++--- i | mariadb-client | Paket | 10.5.10-1.1 | x86_64 | Haupt-Repository (OSS) i | mariadb-client | Paket | 10.5.10-1.1 | x86_64 | openSUSE-20210604-0 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Antonio Rojas changed: What|Removed |Added CC||s.pa...@spiekerbros.com --- Comment #9 from Antonio Rojas --- *** Bug 440781 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #8 from Antonio Rojas --- (In reply to Stefan from comment #7) > Sorry, yes there are the same messages in > ~/.local/share/akonadi/Akonadi.error What's your mariadb client (not server) version? -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769
--- Comment #7 from Stefan ---
Sorry, yes there are the same messages in ~/.local/share/akonadi/Akonadi.error
2021-08-09T13:16:05 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1292"
2021-08-09T13:16:05 [CRITICAL] org.kde.pim.akonadiserver: DB error:
"Incorrect datetime value: '2021-08-09T11:16:05Z' for column
`akonadi`.`pimitemtable`.`atime` at row 1"
2021-08-09T13:16:05 [CRITICAL] org.kde.pim.akonadiserver: Error text:
"Incorrect datetime value: '2021-08-09T11:16:05Z' for column
`akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL: Die Abfrage konnte nicht
ausgeführt werden"
2021-08-09T13:16:05 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0",
QVariant(QDateTime, QDateTime(2021-08-09 11:16:05.608 UTC Qt::UTC)))(":1",
QVariant(qlonglong, 46287)))
2021-08-09T13:16:05 [CRITICAL] org.kde.pim.akonadiserver: Query: "UPDATE
PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 ) )"
2021-08-09T13:16:05 [WARN ] org.kde.pim.akonadiserver: Unable to update item
access time
2021-08-09T13:16:05 [INFO ] org.kde.pim.akonadiserver.search: Executing search
"kontact-3240686485-SearchSession"
2021-08-09T13:16:05 [INFO ] org.kde.pim.akonadiserver.search: Search
"kontact-3240686485-SearchSession" done (without remote search)
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR:
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1292"
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: DB error:
"Incorrect datetime value: '2021-08-09T11:16:08Z' for column
`akonadi`.`pimitemtable`.`atime` at row 1"
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: Error text:
"Incorrect datetime value: '2021-08-09T11:16:08Z' for column
`akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL: Die Abfrage konnte nicht
ausgeführt werden"
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0",
QVariant(int, 1))(":1", QVariant(QString, "12512"))(":10", QVariant(qlonglong,
3))(":2", QVariant(QString, ""))(":3", QVariant(QString, ""))(":4",
QVariant(qlonglong, 284))(":5", QVariant(qlonglong, 3))(":6",
QVariant(QDateTime, QDateTime(2021-07-14 08:23:39.000 CEST
Qt::LocalTime)))(":7", QVariant(QDateTime, QDateTime(2021-08-09 11:16:08.395
UTC Qt::UTC)))(":8", QVariant(bool, false))(":9", QVariant(qlonglong, 20637)))
2021-08-09T13:16:08 [CRITICAL] org.kde.pim.akonadiserver: Query: "UPDATE
PimItemTable SET rev = :0, remoteId = :1, remoteRevision = :2, gid = :3,
collectionId = :4, mimeTypeId = :5, datetime = :6, atime = :7, dirty = :8, size
= :9 WHERE ( id = :10 )"
2021-08-09T13:16:08 [WARN ] org.kde.pim.akonadiserver: Error during updating
record with id 3 in table "PimItemTable" "Incorrect datetime value:
'2021-08-09T11:16:08Z' for column `akonadi`.`pimitemtable`.`atime` at row 1
QMYSQL: Die Abfrage konnte nicht ausgeführt werden"
2021-08-09T13:16:08 [WARN ] org.kde.pim.akonadiserver: Error while handling
command CreateItem on connection akonadi_imap_resource_1 (0x55c06fcdd970)
--
You are receiving this mail because:
You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #6 from Antonio Rojas --- (In reply to Stefan from comment #5) > Is it sure that this issue is related to MariaDB 1.6? > > mysql --socket=/run/user/1000/akonadi/mysql.socket -e "SELECT @@version;" > > +-+ > | @@version | > +-+ > | 10.5.10-MariaDB | > +-+ > > Is this the current version of mariaDB what is used by akonadi? > > I am running into the same today and have no idea whats changed since > yesterday What do you mean by "the same"? The same symptoms doesn't mean it's the same issue. If you don't have the "Incorrect datetime value" in akonadi's output then your problem is a different one. -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Stefan changed: What|Removed |Added CC||menis...@gmx.net --- Comment #5 from Stefan --- Is it sure that this issue is related to MariaDB 1.6? mysql --socket=/run/user/1000/akonadi/mysql.socket -e "SELECT @@version;" +-+ | @@version | +-+ | 10.5.10-MariaDB | +-+ Is this the current version of mariaDB what is used by akonadi? I am running into the same today and have no idea whats changed since yesterday I tried Ricados suggestion with "innodb_force_recovery = 2" but after restarting akonadi, the same messages appear again and i can not send nor receives mails. Operating System: openSUSE Tumbleweed 20210806 KDE Plasma Version: 5.22.4 KDE Frameworks Version: 5.84.0 Qt Version: 5.15.2 Kernel Version: 5.13.6-1-default (64-bit) Graphics Platform: X11 Processors: 8 × Intel® Core™ i7-3770K CPU @ 3.50GHz Memory: 31.2 GiB of RAM Graphics Processor: Mesa DRI Intel® HD Graphics 4000 -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Christophe Giboudeaux changed: What|Removed |Added CC||fab...@web2.0-apps.de --- Comment #4 from Christophe Giboudeaux --- *** Bug 440772 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 --- Comment #3 from Ricardo J. Barberis --- I had already done a mysql_upgrade and akonadi's mysqld wouldn't start, so in case this helps other people with a broken akonadi, here's what I did (YMMV): - Under "[mysqld]" in ~/.local/share/akonadi/mysql.conf I added: "innodb_force_recovery = 2" - Made sure it and akonadi were not running, and started mysqld with: /usr/libexec/mysqld --defaults-file=/home/myuser/.local/share/akonadi/mysql.conf --datadir=/home/myuser/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid & - Then I backed up akonadi's DB and deleted it after: mysqldump -Q --socket=/run/user/1000/akonadi/mysql.socket --add-drop-table akonadi > akonadi.sql mysql--socket=/run/user/1000/akonadi/mysql.socket -e "DROP DATABASE akonadi" - Stoped mysql: mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown - Downgraded MariaDB 10.6.4 to 10.5.11 and started akonadi to recreate its database: akonadictl start - After a few seconds I stopped akonadi and restored the SQL dump: /usr/libexec/mysqld --defaults-file=/home/myuser/.local/share/akonadi/mysql.conf --datadir=/home/myuser/.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid & mysql --socket=/run/user/1000/akonadi/mysql.socket -e akonadi < akonadi.sql - Shut down mysql, started akonadi again: mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown akonadictl start - Started kmail and everything looks good so far! (Before trying all of this , out of caution, I made a backup of my mail folder and everything related to akonadi and kmail I found under ~/.cache/, ~/.config/ and ~/.local/) -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Antonio Rojas changed: What|Removed |Added CC||ricardo.barbe...@gmail.com --- Comment #2 from Antonio Rojas --- *** Bug 440717 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3
https://bugs.kde.org/show_bug.cgi?id=439769 Antonio Rojas changed: What|Removed |Added Resolution|--- |UPSTREAM CC||aro...@archlinux.org See Also||https://bugreports.qt.io/br ||owse/QTBUG-95071 Status|REPORTED|RESOLVED --- Comment #1 from Antonio Rojas --- Qt issue https://bugreports.qt.io/browse/QTBUG-95071 -- You are receiving this mail because: You are watching all bug changes.
