Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
akonadi-server-1.12.1-r1 broke all kdepim
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
Vrenn
Apprentice
Apprentice


Joined: 15 Dec 2004
Posts: 286

PostPosted: Thu Oct 09, 2014 2:56 pm    Post subject: akonadi-server-1.12.1-r1 broke all kdepim Reply with quote

Hello dear Gentoo-helpers!

yesterday I upgraded akonadi-server to 1.12.1-r1 and now it is not starting anymore.
downgrade doesn't help.
rebuild of kdepim-pakages mysql and qtsql didn't help.

I'm out of ideas, please help.
akonadictl start:
Code:
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.7.3", "/usr/games/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db:  ""
Found mysqlcheck:  "/usr/bin/mysqlcheck"
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
MySQL version OK (required "5.1" , available "5.5" )
Database "akonadi" opened using driver "QMYSQL"
DbInitializer::run()
checking table  "SchemaVersionTable"
checking table  "ResourceTable"
checking table  "CollectionTable"
checking table  "MimeTypeTable"
checking table  "PimItemTable"
checking table  "FlagTable"
checking table  "PartTypeTable"
checking table  "PartTable"
"CREATE TABLE PartTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, pimItemId BIGINT NOT NULL, partTypeId BIGINT NOT NULL, data LONGBLOB, datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL DEFAULT false, FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8"
"
Sql error: Can't create table 'akonadi.parttable' (errno: -1) QMYSQL: Unable to execute query
Query: CREATE TABLE PartTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, pimItemId BIGINT NOT NULL, partTypeId BIGINT NOT NULL, data LONGBLOB, datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL DEFAULT false, FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x471944]
1: akonadiserver() [0x471d61]
2: /lib64/libc.so.6(+0x387a0) [0x7f4fbfc627a0]
3: /lib64/libc.so.6(gsignal+0x35) [0x7f4fbfc62725]
4: /lib64/libc.so.6(abort+0x148) [0x7f4fbfc63ba8]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f4fc1756254]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x473d0b]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f4fc17f5f94]
8: /usr/lib64/qt4/libQtCore.so.4(+0x124a3f) [0x7f4fc1802a3f]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f4fc180b95b]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5ec) [0x477a7c]
11: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x26e) [0x7f4fc188512e]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8e) [0x7f4fc186949e]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x21d) [0x7f4fc186caad]
14: /usr/lib64/qt4/libQtCore.so.4(+0x1bca1e) [0x7f4fc189aa1e]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x244) [0x7f4fbf7270a4]
16: /usr/lib64/libglib-2.0.so.0(+0x4b2d8) [0x7f4fbf7272d8]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x34) [0x7f4fbf727394]
18: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x7e) [0x7f4fc189abbe]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f4fc186794f]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x108) [0x7f4fc1867ba8]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x88) [0x7f4fc186db58]
22: akonadiserver(main+0x1b3) [0x46c583]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f4fbfc4edb5]
24: akonadiserver() [0x46cd21]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
Any Ideas?
_________________
With nice greetings
Vrenn
Back to top
View user's profile Send private message
massimo
Veteran
Veteran


Joined: 22 Jun 2003
Posts: 1226

PostPosted: Thu Oct 09, 2014 5:14 pm    Post subject: Reply with quote

I'm also out of ideas.
_________________
Hello 911? How are you?
Back to top
View user's profile Send private message
massimo
Veteran
Veteran


Joined: 22 Jun 2003
Posts: 1226

PostPosted: Thu Oct 09, 2014 5:32 pm    Post subject: Reply with quote

Alright, on my system Akonadi's DB table are these:
+----------------------------------+
| Tables_in_akonadi |
+----------------------------------+
| collectionattributetable |
| collectionmimetyperelation |
| collectionpimitemrelation |
| collectiontable |
| flagtable |
| mimetypetable |
| parttypetable |
| pimitemflagrelation |
| pimitemtable |
| pimitemtagrelation |
| resourcetable |
| schemaversiontable |
| tagattributetable |
| tagremoteidresourcerelationtable |
| tagtable |
+----------------------------------+


When trying to start akonadi it fails with the error message that it is unable to create the table parttable which as you can see does not exist but the corresponding files - parttable.frm and parttable.ibd - do exist in ~/.local/share/akonadi/db_data/akonadi.
_________________
Hello 911? How are you?
Back to top
View user's profile Send private message
Randy Andy
Veteran
Veteran


Joined: 19 Jun 2007
Posts: 1136
Location: /dev/koelsch

PostPosted: Thu Oct 09, 2014 6:03 pm    Post subject: Reply with quote

Hi Guys.

So long ago that I was affected by this bug, that its hard to remember. ;-)
Different possible solutions could be found here:

https://forums.gentoo.org/viewtopic-t-988874-highlight-.html

Much success,

Andy.
_________________
If you want to see a Distro done right, compile it yourself!
Back to top
View user's profile Send private message
MMMMM
Tux's lil' helper
Tux's lil' helper


Joined: 13 Jun 2011
Posts: 134
Location: Berlin

PostPosted: Thu Oct 09, 2014 6:47 pm    Post subject: Reply with quote

Hi,

had same problem, solution for me was:

Downgrade to app-office/akonadi-server-1.11.0
rename dir ~/.local/share/akonadi
akonadictl start (as user)

Kmail did start again and was usable. I don't know if it would have worked without downgrade.

I don't have a recent version since I block all newer kdepim packages:
Code:

>=kde-base/akonadiconsole-4.5.50
>=kde-base/akregator-4.5.50
>=kde-base/blogilo-4.5.50
>=kde-base/kabcclient-4.5.50
>=kde-base/kaddressbook-4.5.50
>=kde-base/kalarm-4.5.50
>=kde-base/kdepim-common-libs-4.5.50
>=kde-base/kdepim-icons-4.5.50
>=kde-base/kdepim-l10n-4.5.50
>=kde-base/kdepim-kresources-4.5.50
>=kde-base/kdepim-meta-4.5.50
>=kde-base/kdepim-strigi-analyzer-4.5.50
>=kde-base/kdepim-runtime-4.5.50
>=kde-base/kdepim-wizards-4.5.50
>=kde-base/kjots-4.5.50
>=kde-base/kleopatra-4.5.50
>=kde-base/kmail-4.5.50
>=kde-base/knode-4.5.50
>=kde-base/knotes-4.5.50
>=kde-base/konsolekalendar-4.5.50
>=kde-base/kontact-4.5.50
>=kde-base/korganizer-4.5.50
>=kde-base/ktimetracker-4.5.50
>=app-office/akonadi-server-1.12.1-r1


That was long time ago when it was said newer kdepim packages won't work with nfs. Since then I did not care about that because I wanted to read and write mails instead of doing database stuff.

M
Back to top
View user's profile Send private message
Vrenn
Apprentice
Apprentice


Joined: 15 Dec 2004
Posts: 286

PostPosted: Thu Oct 09, 2014 7:13 pm    Post subject: Reply with quote

growing frustration I followed https://userbase.kde.org/KMail/FAQs_Hints_and_Tips/de#Clean_start_after_a_failed_migration
but thanks for the rename-example of just the one directory, I will test it next time (hope that akonadi gets stable sometime).
Email accounts had to be entered new
Email dirs had been added automatically as extra dirs (move them to the true inbox and other dirs...)
Add a standard Korganizer-resource and it will load the old one
Add a standard KAdressbook-resource (the .local default dir suggested if you hadn't changed it) and it will load the old one.
_________________
With nice greetings
Vrenn
Back to top
View user's profile Send private message
massimo
Veteran
Veteran


Joined: 22 Jun 2003
Posts: 1226

PostPosted: Fri Oct 10, 2014 4:55 am    Post subject: Reply with quote

I replayed the issue by restoring a backup of ~/.local/share/akonadi and running akonadictl start. The migration and update process fails at creating foreign key references on one of the new tables (e.g., parttable).

I'm thinking about dropping everything related to akonadi (even KDE's PIM etc.) and switching to something more stable - any suggestions?
_________________
Hello 911? How are you?
Back to top
View user's profile Send private message
Bloot
Tux's lil' helper
Tux's lil' helper


Joined: 10 Mar 2006
Posts: 92
Location: Barcelona

PostPosted: Fri Oct 10, 2014 8:47 am    Post subject: Reply with quote

Renaming ~/.local/share/akonadi and starting akonadi server solved the problem.
_________________
Portage 2.3.6 (python 3.4.5-final-0, default/linux/amd64/13.0/desktop/plasma, gcc-6.4.0, glibc-2.23-r4, 4.12.5-gentoo x86_64)
Back to top
View user's profile Send private message
Goverp
l33t
l33t


Joined: 07 Mar 2007
Posts: 668

PostPosted: Fri Oct 10, 2014 8:54 am    Post subject: Reply with quote

I spent yesterday on exactly the same problem, and found exactly the same solution - delete the .local/share/akonadi directory, and akonadi_server rebuilds it. It is, after all, only a cache. I found I had to click on "Update folder" in kmail, kontact and so forth, though perhaps they'd have updated themselves if I'd waited. I have lost my spam filter settings too.
_________________
Greybeard
Back to top
View user's profile Send private message
massimo
Veteran
Veteran


Joined: 22 Jun 2003
Posts: 1226

PostPosted: Fri Oct 10, 2014 8:59 am    Post subject: Reply with quote

When I did a reset of ~/.local/share/akonadi and started kmail all my folders/filters etc. were gone.
_________________
Hello 911? How are you?
Back to top
View user's profile Send private message
MMMMM
Tux's lil' helper
Tux's lil' helper


Joined: 13 Jun 2011
Posts: 134
Location: Berlin

PostPosted: Fri Oct 10, 2014 1:00 pm    Post subject: kmail1 vs. kmail2 Reply with quote

For me as a user of kmail1 resetting of ~/.local/share/akonadi worked well.

When I read all the comments on kmail2 its not likely that I ever switch to kmail2.

M
Back to top
View user's profile Send private message
steveL
Watchman
Watchman


Joined: 13 Sep 2006
Posts: 5153
Location: The Peanut Gallery

PostPosted: Sun Oct 12, 2014 1:08 am    Post subject: Reply with quote

massimo wrote:
I'm thinking about dropping everything related to akonadi (even KDE's PIM etc.) and switching to something more stable - any suggestions?

Well if you can give up KMail, you can lose all the semantic-craptop stuff. I documented switching from KMail to mutt (with procmail, which was fun to learn :) It's a tiny bit tricky, because of how KMail hides its subfolders (which would apply whatever you changed to.)

Personally I found it really hard to give up KMail after 15-odd years using it. It took me ages to get over it (the anguish;) so i didn't actually look at anything else for a while. Then mutt took ages to work out as well; I switched to that as nothing I found on the GUI side dealt with Maildir properly, and I wasn't prepared to give that up (nor to convert all my mail to mbox, which is a much less robust format.)
I'd used pine many years ago, so wasn't afraid of a curses ui.

It's worked out really well: it's incredibly quick to startup in yakuake, and multiple instances are ofc no problem; nor is shutting down with them running. nntp works well, and procmail handles every filter I had in KMail, plus has a great deal more power I haven't explored.

If you've done that, and want to go further toward a lean and stable machine, I recommend disabling nubkit and using PAM instead of polkit for auth (though you don't have to use either, ofc, and can use both.) Had to give up k3b for that, but hadn't used it in over 2 years, and will use the command-line utils discussed there (or ask on the forums) when I do need to burn again.

You might get some issues with qtsql and the mysql flag; I had:
Code:
dev-qt/qtsql postgres -mysql
in package.use but the profile was forcing mysql on. See man portage for the various files you can override (in this case you'd want: /etc/portage/profile/package.use.force with the negated -mysql setting.) However I have a feeling that was corrected, since I don't have the "unforced" setting any more.

For me, however, konvi is now demanding akonadi. I'm quite a bit behind though; I'd see what creaker says (first link.) I realise I haven't posted to that thread for ages; as I said I'm behind the tree (due to update --toolchain colliding with perl ABI blockage.)

In any case, creaker knows more about the KDE ebuilds than I do.

HTH,
steveL
Back to top
View user's profile Send private message
balo2k
n00b
n00b


Joined: 05 Feb 2007
Posts: 12
Location: Rancagua

PostPosted: Sun Oct 12, 2014 5:01 am    Post subject: Reply with quote

This worked for me (for akonadi database running on external MySQL server).

Short version:

If you have your akonadi database on external MySQL server, don't touch .local/share/akonadi directory and just drop the tables (not the database), then restart the akonadi server (please make a backup of your db before doing this just in case).


Long version:

I have akonadi on external MySQL server, when starting akonadi it crashed with:
Code:
Can't create table 'akonadidb.TagRemoteIdResourceRelationTable' (errno: 150)


followed this kdepim bug https://bugs.kde.org/show_bug.cgi?id=333736

Quote:
--- Comment #9 from Daniel Vrátil <dvratil@xxxxxxxxxx> ---
Hmm, there's the problem. You are running on MyISAM, which is not a supported
configuration (I'm not sure if it was in the past, but I doubt it). I'm not
sure how that could happened. Anyway, Akonadi requires InnoDB, because it
depends on FOREIGN KEYS to function properly.

I recommend converting all tables to InnoDB manually, then restarting Akonadi.
It should automatically create all missing indexes and foreign keys.


My tables were on MyISAM, I converted them to InnoDB and then it starts to migrate the database but it hits other snag:

Code:
Sql error: Cannot add or update a child row: a foreign key constraint fails akonadi


Then I claudicate and dropped all the tables, started the akonadi server and the database reconstructed OK (I didn't rename the .local/share/akonadi directory). :o


The only loss was the favorites folders that get corrupted (changed for other folders) and the order of the mailboxes.


To convert the tables from MyISAM to InnoDB this post was very usefull http://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb

EDIT: put "EXTERNAL MySQL server" instead of MySQL


Last edited by balo2k on Sun Oct 12, 2014 12:14 pm; edited 1 time in total
Back to top
View user's profile Send private message
Goverp
l33t
l33t


Joined: 07 Mar 2007
Posts: 668

PostPosted: Sun Oct 12, 2014 8:03 am    Post subject: Reply with quote

balo2k wrote:
This worked for me (for akonadi database running on MySQL).

Short version:

If you have your akonadi database on MySQL, don't touch .local/share/akonadi directory and just drop the tables (not the database), then restart the akonadi server (please make a backup of your db before doing this just in case).
...

You mean, for akonadi database running on external MySQL server. Depends on your configuration. Akonadi will also run on an internal MySQL server, and I think that's the Gentoo default. The internal database is what's in the .local/share/akonadi directory, which is why deleting it gets KDEPIM to rebuild the database. AFAIR akonadi was originally shipped with SQLite support, but I think that's deprecated now.

It would be interesting to compare external and internal databases - external makes the maintenance and management explicit, which is probably good, and it might be better for performance (one DB engine shared across several applications), but it's all a bit moot, as with KDE 4.13 (?) the nepomuk storage engine used by akonadi gets replaced with baloo, and that's back to SQLite. (Wonder how long before they decide to migrate that to MySQL or similar?)
_________________
Greybeard
Back to top
View user's profile Send private message
steveL
Watchman
Watchman


Joined: 13 Sep 2006
Posts: 5153
Location: The Peanut Gallery

PostPosted: Sun Oct 12, 2014 8:33 am    Post subject: Reply with quote

Goverp wrote:
Depends on your configuration. Akonadi will also run on an internal MySQL server, and I think that's the Gentoo default. The internal database is what's in the .local/share/akonadi directory, which is why deleting it gets KDEPIM to rebuild the database. AFAIR akonadi was originally shipped with SQLite support, but I think that's deprecated now.

Yeah i tried to get along with that; it was rubbish.
Quote:
It would be interesting to compare external and internal databases - external makes the maintenance and management explicit, which is probably good, and it might be better for performance (one DB engine shared across several applications), but it's all a bit moot, as with KDE 4.13 (?) the nepomuk storage engine used by akonadi gets replaced with baloo, and that's back to SQLite. (Wonder how long before they decide to migrate that to MySQL or similar?)

Lul; plus ca change.. ;-)

Wait, do you mean an internal db is always per-app? Makes sense I guess as sqlite and threading don't get on very well, afair.

Anyhow, I just wanted to get off the tractor, and go back to the train. I certainly don't have the spare cycles, nor the inclination, for some process to be churning my hard-drive. Each to their own, of course (that's the Gentoo way, after all.)
Back to top
View user's profile Send private message
massimo
Veteran
Veteran


Joined: 22 Jun 2003
Posts: 1226

PostPosted: Mon Oct 13, 2014 12:19 pm    Post subject: Reply with quote

I switched to Thunderbird for now and put my emails on a locally running IMAP server (dovecot).
_________________
Hello 911? How are you?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum