Bug 364525 - kactivitymanagerd spams .xsession-errors with QSqlError messages
Summary: kactivitymanagerd spams .xsession-errors with QSqlError messages
Status: RESOLVED FIXED
Alias: None
Product: kactivitymanagerd
Classification: Plasma
Component: general (show other bugs)
Version: unspecified
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Ivan Čukić
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-20 05:58 UTC by James Ring
Modified: 2016-07-18 19:35 UTC (History)
1 user (show)

See Also:
Latest Commit: http://commits.kde.org/kactivitymanagerd/8cd7c49424ba7c53e19eb0b3e18b75cc9beae3f5
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description James Ring 2016-06-20 05:58:07 UTC 
Hi there,

I noticed that all my disk space would be slowly eaten up. After digging, I found the culprit was kactivitymanagerd writing gigabytes of logs in a tight loop to $HOME/.xsession-errors. The error message was:

QSqlError("5", "Unable to fetch row", "database is locked")
"DELETE FROM ResourceScoreCache WHERE  usedActivity = '9181d38a-b709-4bbb-b13b-765a9a036ba2'  AND  1  AND targettedResource LIKE :targettedResource ESCAPE '\\'"

To work around, I blew away the $HOME/.local/share/kactivitymanagerd/resources/ directory and restarted KDE, after which all was OK. I don't know specific steps to reproduce, but possibly kactivitymanagerd should behave better in these circumstances.

Reproducible: Always
Comment 1 Ivan Čukić 2016-07-18 19:35:18 UTC 
Git commit 8cd7c49424ba7c53e19eb0b3e18b75cc9beae3f5 by Ivan Čukić.
Committed on 18/07/2016 at 19:34.
Pushed by ivan into branch 'master'.

Write out only first two SQL errors not to overflow the .xsession-errors

M  +3    -1    src/service/plugins/sqlite/Utils.h

http://commits.kde.org/kactivitymanagerd/8cd7c49424ba7c53e19eb0b3e18b75cc9beae3f5