Akonadi MySql problems

Discussions Regarding Software

Moderator: Moderators

Post Reply
sjieke
Technological Hen
Posts: 321
Joined: Thu Mar 01, 2007 10:46
Location: Maldegem, Belgium

Akonadi MySql problems

Post by sjieke » Thu Oct 22, 2009 7:30

I spent the last days figuring out why I couldn't use akonadi resources in Kontact. Using the akonadiconsole also didn't work.
After a long time I found the existens of akonadictl.
Using akonadictl to restart the akonadi server resulted in some nice output on the command line. Looking through it, I found sql insert errors. Something in the line of can't insert into collection table. So finally I found the possible cullprit, the database driver (qt-sql) or the mysql server.

Reinstalling (using equo) all related packages didn't solve anything, so I made a fresh sabayon 5 install in virtualbox. Updated it. The same problem exists there (as expected).
I added the limbo repository to my virtualbox install. Performed all available updates, restarted akonadi again and bingo it worked.

I spent some time looking at the package versions trying to determine which one fixed it. And my conclusion was a newer version of mysql. So I went to my main box, installed that same mysql version using portage and my problem was fixed :)

I didn't want the limbo repo in my main system, that's why I used portage.
I hope this helps someone as I think it affects everyone that uses Sabayon 5.o KDE and doesn't want the limbo repository.

@ the devs: Is it possible to update the mysql version in the main sabayon repo (branch 5) to the one in the limbo repository?

Odysseus
Simple Hen
Posts: 44
Joined: Wed Aug 26, 2009 2:37
Location: Miami, FL (homesick for SF,CA)

Re: Akonadi MySql problems

Post by Odysseus » Sun Oct 25, 2009 19:26

Thanks for the post! I was having the same issues. I just followed your advice and installed from portage and viola!! It works!! I too don't want to be running limbo on my only machine. So this is a great finding/ post.

Ciao

sjieke
Technological Hen
Posts: 321
Joined: Thu Mar 01, 2007 10:46
Location: Maldegem, Belgium

Re: Akonadi MySql problems

Post by sjieke » Mon Oct 26, 2009 8:05

I'm glad I could help someone. Now I'm just waiting till the devs update the package in entropy, but maybe I should make a bug report or package request to make that happen.

Fitzcarraldo
Sagely Hen
Posts: 8200
Joined: Sat Mar 10, 2007 5:40
Location: United Kingdom
Contact:

Re: Akonadi MySql problems

Post by Fitzcarraldo » Mon Oct 26, 2009 10:15

Which precise version of MySQL did you install, sjieke?

Code: Select all

$ eix -I mysql
[U] dev-db/mysql
     Available versions:  [M]*3.23.58-r1 [M]4.0.27-r1 [M]4.1.22-r1 [M]5.0.26-r2 [M](~)5.0.32 [M](~)5.0.34 [M]5.0.38 [M]5.0.40 [M]5.0.42 [M](~)5.0.44 [M]5.0.44-r1 [M]5.0.44-r2 [M]5.0.54 [M](~)5.0.56 [M](~)5.0.60 5.0.60-r1 5.0.70 5.0.70-r1 (~)5.0.72 (~)5.0.72-r1 (~)5.0.76 (~)5.0.76-r1 (~)5.0.83 (~)5.0.84 (~)5.0.84-r1 {berkdb big-tables cluster +community debug embedded extraengine innodb latin1 max-idx-128 minimal (+)perl profiling raid readline selinux ssl static tcpd}
     Installed versions:  5.0.83(14:54:50 12/10/09)(community embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal -profiling -selinux -static)
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server.

[I] dev-db/mysql-init-scripts
     Available versions:  1.2
     Installed versions:  1.2(14:54:50 12/10/09)
     Homepage:            http://www.gentoo.org/
     Description:         Gentoo MySQL init scripts.

[I] dev-perl/DBD-mysql
     Available versions:  2.9007 4.00.5 (~)4.01.2
     Installed versions:  4.01.2(14:54:52 12/10/09)
     Homepage:            http://search.cpan.org/dist/DBD-mysql
     Description:         The Perl DBD:mysql Module

[I] virtual/mysql
     Available versions:  [M]4.0 [M]4.1 5.0 [M](~)5.1
     Installed versions:  5.0(14:55:14 12/10/09)
     Homepage:            http://dev.mysql.com
     Description:         Virtual for MySQL client or database

Found 4 matches.

sjieke
Technological Hen
Posts: 321
Joined: Thu Mar 01, 2007 10:46
Location: Maldegem, Belgium

Re: Akonadi MySql problems

Post by sjieke » Mon Oct 26, 2009 12:58

I'm not at my machine right now. I will post the eix output as soon as I'm home. But as far as I can remember correctly it was version 5.0.84 (I'm not 100% sure at the moment...)

Another thing I found during my search was that it is best to disable the debug flag for mysql, but I think this is the default on sabayon. More info can be found here Gentoo Assert

sjieke
Technological Hen
Posts: 321
Joined: Thu Mar 01, 2007 10:46
Location: Maldegem, Belgium

Re: Akonadi MySql problems

Post by sjieke » Mon Oct 26, 2009 20:20

Ok, here is my eix output

Code: Select all

[email protected] ~ $ eix -I mysql
[I] dev-db/mysql                 
     Available versions:  [M]3.23.58-r1 [M]4.0.27-r1 [M]4.1.22-r1 [M]5.0.26-r2 [M](~)5.0.32 [M](~)5.0.34 [M]5.0.38 [M]5.0.40 [M]5.0.42 [M]5.0.44 [M]5.0.44-r1 [M]5.0.44-r2 [M]5.0.54 [M](~)5.0.56 [M](~)5.0.60 5.0.60-r1 5.0.70 5.0.70-r1 (~)5.0.72 (~)5.0.72-r1 (~)5.0.76 (~)5.0.76-r1 (~)5.0.83 (~)5.0.84 (~)5.0.84-r1 {berkdb big-tables cluster community debug embedded extraengine innodb latin1 max-idx-128 minimal perl profiling raid readline selinux ssl static tcpd}                   
     Installed versions:  5.0.84-r1(11:06:47 PM 10/20/2009)(community embedded perl ssl -berkdb -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal -profiling -selinux -static)
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server.

[I] dev-db/mysql-gui-tools
     Available versions:  (~)5.0_p12-r2 {administrator nls query-browser}
     Installed versions:  5.0_p12-r2(08:44:05 PM 10/20/2009)(administrator nls query-browser)
     Homepage:            http://www.mysql.com/products/tools/
     Description:         MySQL GUI Tools

[I] dev-db/mysql-init-scripts
     Available versions:  1.2
     Installed versions:  1.2(08:21:13 PM 10/20/2009)
     Homepage:            http://www.gentoo.org/
     Description:         Gentoo MySQL init scripts.

[I] dev-perl/DBD-mysql
     Available versions:  2.9007 4.00.5 (~)4.01.2
     Installed versions:  4.01.2(08:21:20 PM 10/20/2009)
     Homepage:            http://search.cpan.org/dist/DBD-mysql
     Description:         The Perl DBD:mysql Module

[I] virtual/mysql
     Available versions:  [M]4.0 [M]4.1 5.0 [M](~)5.1
     Installed versions:  5.0(08:21:30 PM 10/20/2009)
     Homepage:            http://dev.mysql.com
     Description:         Virtual for MySQL client or database

Found 5 matches.

Post Reply