debugging kmail crash

[jos at vandenoever.info]

On 16.12.2018 03:03, Pablo Sanchez wrote:
> [ Comments below, in-line ]
> 
> 
> On Sun, 16 Dec 2018 01:12:09 +0100, Jos wrote:
> 
>> When trying to run a query on the database, (select * from 
>> collectiontable;) I get
>> 
>> Failed to connect to database: Can't connect to local MySQL server 
>> through socket '/tmp/akonadi-oever.0b6D91/mysql.socket' (2) QMYSQL: 
>> Unable to connect
> 
> 
> Hi,
> 
> Please see below.  I used a Live CD to do the test.
> 
> kubuntu at kubuntu:~$ ps -ef|fgrep mysql
> kubuntu   4143  4054  0 01:57 ?        00:00:00 /usr/sbin/mysqld
> --defaults-file=/home/kubuntu/.local/share/akonadi/mysql.conf
> --datadir=/home/kubuntu/.local/share/akonadi/db_data/
> --socket=/tmp/akonadi-kubuntu.NCN4OQ/mysql.socket
> --pid-file=/tmp/akonadi-kubuntu.NCN4OQ/mysql.pid
> kubuntu   4383  4029  0 02:00 pts/1    00:00:00 grep -F --color=auto 
> mysql
> kubuntu at kubuntu:~$ mysql 
> --socket=/tmp/akonadi-kubuntu.NCN4OQ/mysql.socket
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 29
> Server version: 5.7.23-2ubuntu1 (Ubuntu)
> 
> Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights 
> reserved.
> 
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input 
> statement.
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | akonadi            |
> | mysql              |
> | performance_schema |
> | sys                |
> +--------------------+
> 5 rows in set (0.00 sec)

This query outputs the folder paths:

mysql -D akonadi -e 'with recursive cte (id, parentId, box, path) as ( 
select id, parentId, remoteId as box, if (parentId is null, "", 
remoteId) as path from collectiontable where parentId is null and 
remoteId is not null union all select p.id, p.parentId, cte.box, 
concat(cte.path,p.remoteId,"/") as path from collectiontable p inner 
join cte on p.parentId = cte.id) select id, box, path from cte;' 
--socket=/tmp/akonadi-oever.T0Nuho/mysql.socket

Formatted version of this query:

with recursive cte (id, parentId, box, path) as (
     select id,
            parentId,
            remoteId as box,
            if (parentId is null, "", remoteId) as path
     from collectiontable
     where parentId is null and remoteId is not null
     union all
     select p.id,
            p.parentId,
            cte.box,
            concat(cte.path, p.remoteId, "/") as path
     from collectiontable p
     inner join cte on p.parentId = cte.id
) select id, box, path from cte;