View previous topic :: View next topic |
Author |
Message |
Vrenn Guru
Joined: 15 Dec 2004 Posts: 318
|
Posted: Thu Oct 09, 2014 2:56 pm Post subject: akonadi-server-1.12.1-r1 broke all kdepim |
|
|
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 |
|
|
massimo Veteran
Joined: 22 Jun 2003 Posts: 1226
|
Posted: Thu Oct 09, 2014 5:14 pm Post subject: |
|
|
I'm also out of ideas. _________________ Hello 911? How are you? |
|
Back to top |
|
|
massimo Veteran
Joined: 22 Jun 2003 Posts: 1226
|
Posted: Thu Oct 09, 2014 5:32 pm Post subject: |
|
|
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 |
|
|
Randy Andy Veteran
Joined: 19 Jun 2007 Posts: 1148 Location: /dev/koelsch
|
Posted: Thu Oct 09, 2014 6:03 pm Post subject: |
|
|
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 |
|
|
MMMMM Tux's lil' helper
Joined: 13 Jun 2011 Posts: 141 Location: Berlin
|
Posted: Thu Oct 09, 2014 6:47 pm Post subject: |
|
|
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 |
|
|
Vrenn Guru
Joined: 15 Dec 2004 Posts: 318
|
Posted: Thu Oct 09, 2014 7:13 pm Post subject: |
|
|
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 |
|
|
massimo Veteran
Joined: 22 Jun 2003 Posts: 1226
|
Posted: Fri Oct 10, 2014 4:55 am Post subject: |
|
|
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 |
|
|
Bloot Tux's lil' helper
Joined: 10 Mar 2006 Posts: 99 Location: Barcelona
|
Posted: Fri Oct 10, 2014 8:47 am Post subject: |
|
|
Renaming ~/.local/share/akonadi and starting akonadi server solved the problem. |
|
Back to top |
|
|
Goverp Veteran
Joined: 07 Mar 2007 Posts: 1997
|
Posted: Fri Oct 10, 2014 8:54 am Post subject: |
|
|
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 |
|
|
massimo Veteran
Joined: 22 Jun 2003 Posts: 1226
|
Posted: Fri Oct 10, 2014 8:59 am Post subject: |
|
|
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 |
|
|
MMMMM Tux's lil' helper
Joined: 13 Jun 2011 Posts: 141 Location: Berlin
|
Posted: Fri Oct 10, 2014 1:00 pm Post subject: kmail1 vs. kmail2 |
|
|
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 |
|
|
steveL Watchman
Joined: 13 Sep 2006 Posts: 5153 Location: The Peanut Gallery
|
Posted: Sun Oct 12, 2014 1:08 am Post subject: |
|
|
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 |
|
|
balo2k n00b
Joined: 05 Feb 2007 Posts: 14 Location: Rancagua
|
Posted: Sun Oct 12, 2014 5:01 am Post subject: |
|
|
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).
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 |
|
|
Goverp Veteran
Joined: 07 Mar 2007 Posts: 1997
|
Posted: Sun Oct 12, 2014 8:03 am Post subject: |
|
|
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 |
|
|
steveL Watchman
Joined: 13 Sep 2006 Posts: 5153 Location: The Peanut Gallery
|
Posted: Sun Oct 12, 2014 8:33 am Post subject: |
|
|
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 |
|
|
massimo Veteran
Joined: 22 Jun 2003 Posts: 1226
|
Posted: Mon Oct 13, 2014 12:19 pm Post subject: |
|
|
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 |
|
|
|
|
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
|
|