Re: Kmail 5.10.0: Empty message-list pane & message-body pane

On Wed, 09 Jan 2019 16:39:17 +0000, I wrote:

> Deleted ~/.local/share/akonadi (but not Baloo)  then starterd
> akonadictl.

Tried again after also deleting the Baloo directory.

Ran for hours then ground to a halt after MySQL ran 'out of memory':

-----------------------------------------------
.......
The hash has changed.
42 -> QFlags(0x2) 0
The hash has changed.
The hash has changed.
The hash has changed.
The hash has changed.
11 -> QFlags(0x2) 0
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "2008"
org.kde.pim.akonadiserver:   DB error:  "MySQL client run out of memory"
org.kde.pim.akonadiserver:   Error text: "MySQL client run out of memory 
QMYSQL3: Unable to store statement results"
The hash has changed.
The hash has changed.
The hash has changed.
The hash has changed.
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(qlonglong, 
11))(":1", QVariant(QString, "6a0bdcef-c2c1-4f2f-9efe-exp-edd146ec349a")))
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 ( collectionId = :0 AND ( ( remoteId = :1 ) ) ) FOR UPDATE"
42 -> QFlags(0x2) 0
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
The hash has changed.
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
The hash has changed.
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: "Failed to query database for item"
The hash has changed.
The hash has changed.
org.kde.pim.akonadiserver: Database error: DataStore::rollbackTransaction
org.kde.pim.akonadiserver:   Last driver error: "QMYSQL: Unable to 
rollback 
transaction"
org.kde.pim.akonadiserver:   Last database error: "Unknown MySQL error"
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Creating/updating items from the akonadi 
database 
failed: ""
org.kde.pim.akonadicore: Error during ItemSync:  "Unable to roll back 
transaction."
^C
-------------------------------

$df -k

/dev/sda5       49886066 34953474  12262512  75% /home+
  (i.e. 14.25GiB free)
  
-------------------------------

How much storage does MySQL need??!!

-- 
/\/\aurice