[kde-freebsd] Akonadi/mysqld problems

Mel Flynn rflynn at acsalaska.net
Wed Jun 13 23:38:39 UTC 2012


On 14-6-2012 1:25, Alberto Villa wrote:
> On Thu, Jun 14, 2012 at 1:18 AM, Mel Flynn <rflynn at acsalaska.net> wrote:
>> mysql> select * from collectiontable where (queryLanguage = ( :0 ));
>> ERROR 1064 (42000): You have an error in your SQL syntax; check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near ':0 ))' at line 1
> 
> Good point. Would you be able to check if other queries have the same ":0"?

:0 is $DISPLAY. But only failed queries end up in .xsession-errors and a
lot of this:
% grep 'Error during' ./.xsession-errors|wc -l
   44803

which is:
Error during selection of all records from table "CollectionTable"
"MySQL server has gone away QMYSQL: Unable to execute query"

One each second. Except now it doesn't cause high load. Sometimes it
does. No other queries available in .xsession-errors.

>> Also, all queryLanguage fields are NULL, so I don't understand the WHERE
>> clause. Do you have one where it is not null?
> 
> Apparently, no, but that might be there for several reasons.
> 
> Also, are you on IRC?

Nope and going to sleep.
-- 
Mel


More information about the kde-freebsd mailing list