[Akonadi] [Bug 480543] New: Akonadis sqlite backend does not honor sql limits
https://bugs.kde.org/show_bug.cgi?id=480543 Bug ID: 480543 Summary: Akonadis sqlite backend does not honor sql limits Classification: Frameworks and Libraries Product: Akonadi Version: unspecified Platform: Fedora RPMs OS: Linux Status: REPORTED Severity: major Priority: NOR Component: server Assignee: kdepim-b...@kde.org Reporter: schei...@gonicus.de CC: c...@carlschwan.eu Target Milestone: --- SUMMARY This is not a crash report, but this behavior of akonadi and especially akonadis sqlite backend, renders the usability of kdepim with sqlite to useless and leads to many errors users are not expecting. In fact kdepim "feels" very laggy and slow to use. STEPS TO REPRODUCE 1. Use sqlite backend: akonadiserverrc: [%General] Driver=QSQLITE Try to delete more than one thousand mails or prune your trash folder with several thousand mails. Or open a mailbox with several thousand mails. OBSERVED RESULT Mails do not get deleted. You get an error that "deleting mails failed" (with no further information about what failed). Mailfolder do not open in an acceptable period of time, sometimes you get a timeout or nothing happens. You have to restart akonadi to get back to a usable state in that case. Kontact feels unresponsive and extremely laggy. EXPECTED RESULT Mails do get purged (i.e. trash) and mailfolders should load and show in an acceptable amount of time. Kontact/kmail should feel responsive SOFTWARE/OS VERSIONS Linux/KDE Plasma: Kontact Version: 5.24.4 (23.08.4) KDE Plasma Version: 5.27.10 KDE Frameworks Version: 5.113.0 Qt Version: 5.15.12 (kompiliert gegen 5.15.11) ADDITIONAL INFORMATION I use kontact with four mail accounts (2xIMAP, GMail and EWS plus a local mailfolder for trash) and three Calendar Sources. The overall amount of Mails is significant, but only one folder exceeds 10k Mails (the local trash folder), the other folders are quite small. LOGGING INFORMATION Every now and then while opening a mailfolder with many mails (but none of my folders carries 9 Mails!): org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "1" org.kde.pim.akonadiserver: DB error: "too many SQL variables" org.kde.pim.akonadiserver: Error text: "too many SQL variables Der Befehl konnte nicht ausgeführt werden" org.kde.pim.akonadiserver: Query: "SELECT PimItemTable.id, PimItemTable.rev, PimItemTable.remoteId, PimItemTable.remoteRevision, PimItemTable.gid, PimItemTable.collectionId, PimItemTable.mimeTypeId, PimItemTable.datetime, PimItemTable.atime, PimItemTable.dirty, PimItemTable.size FROM PimItemTable WHERE ( PimItemTable.id IN ( :0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, === (snip) :99938, :99939, :99940, :99941, :99942, :99943, :99944, :99945, :99946, :99947, :99948, :99949, :99950, :99951, :99952, :99953, :99954, :99955, :99956, :99957, :99958, :99959, :99960, :99961, :99962, :99963, :99964, :99965, :99966, :99967, :99968, :99969, :99970, :99971, :99972, :99973, :99974, :99975, :99976, :99977, :99978, :99979, :99980, :99981, :99982, :99983, :99984, :99985, :99986, :99987, :99988, :99989, :0, :1, :2, :3, :4, :5, :6, :7, :8, :9 ) )" This error comes quite often, maybe it's not related to opening a folder? I don't know. Trying to delete more than a thousand mails or expunge trash: org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY: org.kde.pim.akonadiserver: Error code: "1" org.kde.pim.akonadiserver: DB error: "Expression tree is too large (maximum depth 1000)" org.kde.pim.akonadiserver: Error text: "Expression tree is too large (maximum depth 1000) Der Befehl konnte nicht ausgeführt werden" org.kde.pim.akonadiserver: Query: "SELECT PimItemTable.id, PimItemTable.rev, PimItemTable.remoteId, PimItemTable.remoteRevision, PimItemTable.gid, PimItemTable.collectionId, PimItemTable.mimeTypeId, PimItemTable.datetime, PimItemTable.atime, PimItemTable.dirty, PimItemTable.size FROM PimItemTable WHERE ( ( ( PimItemTable.id >= :0 AND PimItemTable.id <= :1 ) OR
[kmail2] [Bug 448340] Contents of mime parts wrapped inside multipart/related are not shown
https://bugs.kde.org/show_bug.cgi?id=448340 Lars Scheiter changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |FIXED --- Comment #2 from Lars Scheiter --- With the most recent kdepim update (kontact 22.12.3 on Fedora Kinoite) the problem seems to be fixed, thank you! -- You are receiving this mail because: You are watching all bug changes.
[kmail2] [Bug 448340] Contents of mime parts wrapped inside multipart/related are not shown
https://bugs.kde.org/show_bug.cgi?id=448340 Lars Scheiter changed: What|Removed |Added CC||schei...@gonicus.de --- Comment #1 from Lars Scheiter --- This does not only affect Applemail. Thunderbird and even KMail itself can compose Mails KMail can't propperly display! I tried to reproduce this behavior and composed a HTML-Mail (richtext) and embeded a jpg. The send folder contained my composed mail. While clicking that mail and switching between HTML and cleartext view my attachment magically disappeared. In HTML-View only a broken Image Icon is displayed. Changing the Attachment view or Theme does not change this behavior. But now comes the "fun part": During my testst this only happenend when kmail was embedded into kontact. Starting kmail as a standalone app does not show this bug! (well, at least in my tests) -- You are receiving this mail because: You are watching all bug changes.
[kwin] [Bug 453147] amdgpu: GPU reset crash loop
https://bugs.kde.org/show_bug.cgi?id=453147 Lars Scheiter changed: What|Removed |Added CC||schei...@gonicus.de -- You are receiving this mail because: You are watching all bug changes.
[Akonadi] [Bug 449024] Unable to fetch google calendar events
https://bugs.kde.org/show_bug.cgi?id=449024 Lars Scheiter changed: What|Removed |Added CC|schei...@gonicus.de | -- You are receiving this mail because: You are watching all bug changes.
[plasma-nm] [Bug 389052] Desired connections run away just before clicking the "connect" button or entering password
https://bugs.kde.org/show_bug.cgi?id=389052 Lars Scheiter changed: What|Removed |Added CC|schei...@gonicus.de | -- You are receiving this mail because: You are watching all bug changes.
[konqueror] [Bug 86202] icons in html select boxes
https://bugs.kde.org/show_bug.cgi?id=86202 Lars Scheiter changed: What|Removed |Added Status|REPORTED|RESOLVED Resolution|--- |NOT A BUG -- You are receiving this mail because: You are watching all bug changes.
[print-manager] [Bug 455798] Network printer missing in the print dialog of KDE apps, while available and working in the system settings and all non-KDE apps
https://bugs.kde.org/show_bug.cgi?id=455798 --- Comment #3 from Lars Scheiter --- The print dialogue only show printers which are configured in /etc/cups/printers.conf, but no printers which are discovered by cups-browsed. My printers list: # lpstat -a blutdruck accepting requests since Mo 11 Okt 2021 16:59:27 CEST Drucker_Bueecke_mrbeeg accepting requests since Do 30 Jun 2022 07:26:29 CEST Drucker_Praxis_mrbeeg accepting requests since Do 30 Jun 2022 07:26:30 CEST Farblaser_mrbeeg accepting requests since Do 30 Jun 2022 07:26:29 CEST Kyocera_ECOSYS_M5526cdn accepting requests since Do 30 Jun 2022 07:26:31 CEST Kyocera_Lars_mrbeeg accepting requests since Do 30 Jun 2022 16:03:03 CEST nebendruck accepting requests since Mo 11 Okt 2021 16:59:27 CEST Samsung_CLX_3300_Series_SEC001599AE9E6E_ accepting requests since Do 30 Jun 2022 16:19:38 CEST Samsung_Lars_mrbeeg accepting requests since Do 30 Jun 2022 07:26:29 CEST tiefdruck accepting requests since Mo 11 Okt 2021 16:59:27 CEST turmdruck accepting requests since Mo 11 Okt 2021 16:59:27 CEST uberdruck accepting requests since Di 14 Jun 2022 09:04:13 CEST unterdruck accepting requests since Mo 11 Okt 2021 16:59:27 CEST All the printers discovered by cups have unterlines in their names (eg.: "Kyocera_ECOSYS_M5526cdn"), the others are local configured printers (eg.: unterdruck and uberdruck). The only printers shown are local configured printers (See Screenshot.png). Second screenshot is systemsettings showing all printers. -- You are receiving this mail because: You are watching all bug changes.
[print-manager] [Bug 455798] Network printer missing in the print dialog of KDE apps, while available and working in the system settings and all non-KDE apps
https://bugs.kde.org/show_bug.cgi?id=455798 --- Comment #2 from Lars Scheiter --- Created attachment 150292 --> https://bugs.kde.org/attachment.cgi?id=150292=edit Systemsettings printers Screenshot showing the systemsettings printers -- You are receiving this mail because: You are watching all bug changes.
[print-manager] [Bug 455798] Network printer missing in the print dialog of KDE apps, while available and working in the system settings and all non-KDE apps
https://bugs.kde.org/show_bug.cgi?id=455798 --- Comment #1 from Lars Scheiter --- Created attachment 150291 --> https://bugs.kde.org/attachment.cgi?id=150291=edit Printer dialogue Screenshot showing only a handfull of printers in the print dialogue -- You are receiving this mail because: You are watching all bug changes.
[print-manager] [Bug 455798] Network printer missing in the print dialog of KDE apps, while available and working in the system settings and all non-KDE apps
https://bugs.kde.org/show_bug.cgi?id=455798 Lars Scheiter changed: What|Removed |Added CC||schei...@gonicus.de -- You are receiving this mail because: You are watching all bug changes.
[plasma-nm] [Bug 389052] Desired connections run away just before clicking the "connect" button or entering password
https://bugs.kde.org/show_bug.cgi?id=389052 Lars Scheiter changed: What|Removed |Added CC||schei...@gonicus.de -- You are receiving this mail because: You are watching all bug changes.
