[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep

[Ricardo J. Barberis]

https://bugs.kde.org/show_bug.cgi?id=452958

--- Comment #1 from Ricardo J. Barberis <ricardo.barberis at gmail.com> ---
Process list after resume from sleep:

$ mysqladmin --socket=/run/user/1000/akonadi/mysql.socket processlist -v
+----+-----------+-----------+---------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| Id | User      | Host      | db      | Command | Time | State        | Info  
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                      | Progress |
+----+-----------+-----------+---------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
| 5  | <MY_USER> | localhost | akonadi | Sleep   | 1207 |              |       
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                      | 0.000    |
| 6  | <MY_USER> | localhost | akonadi | Execute | 290  | Sending data | SELECT
PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data,
PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable INNER
JOIN PimItemTable ON ( pimItemId = PimItemTable.id ) INNER JOIN PartTypeTable
ON ( PartTable.partTypeId = PartTypeTable.id ) WHERE (
PimItemTable.collectionId = ? AND PimItemTable.atime < ? AND PartTable.data IS
NOT NULL AND PartTypeTable.ns = ? AND PimItemTable.dirty = ? AND
PartTypeTable.name <> ? ) | 0.000    |
| 7  | <MY_USER> | localhost | akonadi | Sleep   | 1204 |              |       
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                      | 0.000    |
| 8  | <MY_USER> | localhost | akonadi | Sleep   | 1204 |              |       
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                      | 0.000    |
| 62 | root      | localhost |         | Query   | 0    | starting     | show
full processlist                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                        | 0.000    |
+----+-----------+-----------+---------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+

-- 
You are receiving this mail because:
You are the assignee for the bug.