View previous topic :: View next topic |
Author |
Message |
iandoug l33t
Joined: 11 Feb 2005 Posts: 816 Location: Cape Town, South Africa
|
Posted: Tue Oct 29, 2013 1:18 am Post subject: ()W(#$ Akonadi [SOLVED ??] |
|
|
Hi
Been fighting for a few hours and getting nowhere except going round in circles.
Kmail was working fine this morning. I put my PC off, and later restarted, whereupon the troubles started.
Akonadi was not happy and would not start.
There were assorted errors, starting with "Errors in log file".
Much searching of the web produced many people with similar issues but few solutions.
I eventually decided to folllow the advice here: https://bbs.archlinux.org/viewtopic.php?pid=695037#p695037
which went smoothly until this step:
mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/
which did not work. For the record, I use MariaDB rather then MySql.
So then I decided I would fix that by reinstalling akonadi-server.
Which put me into the circles of hell.... the 1.10.2 I have no longer exists, and 1.10.3 is not happy with the qt environment and I have all sorts of slot clashes.
Re-syncing did not help, nor did revdep-rebuild.
I now see that Akonadi is happy with the missing log file, and is now complaining about it's process not being registered at D-Bus.
Let me try rebooting (again) and see if that helps now ...
(forums need a 'draft' command..)
Okay... kmail now starts, after a few false starts and complaints..
BUT
some folders (including my main WORK email folders) have been wiped. Others are still there and populated.
I can't see any pattern as to which were saved and which were wiped.
This is naturally a major disaster and I am not impressed. I really wish the KDE devs would take more care with the whole PIM subsystem.
I ran updatedb and tried a search for some of the mail, all gone
nothing in Lost+Found either.
Does anyone have any ideas on how to find/recover my mail?
I thought Akonadi's databases only stored meta-data, so why would my maildirs get wiped? This is most distressing and puts me in a terrible situation work-wise.
Thanks, Ian _________________ Asus X570-PRO, Ryzen 7 5800X, GeForce GTX 1650, 32 GB RAM | Asus Sabertooth P990, AMD FX-8150, GeForce GTX 560, 16GB Ram
Last edited by iandoug on Tue Aug 05, 2014 6:27 am; edited 1 time in total |
|
Back to top |
|
|
eyoung100 Veteran
Joined: 23 Jan 2004 Posts: 1428
|
|
Back to top |
|
|
Goverp Veteran
Joined: 07 Mar 2007 Posts: 1972
|
Posted: Wed Oct 30, 2013 10:17 am Post subject: |
|
|
Have you looked for your mail in ~/.local/share/.local-mail.directory ? (note that the third level directory is ALSO hidden) It's not exactly well-documented, but that's where kmail keeps the mail, irrespective of anything in akonadi. _________________ Greybeard |
|
Back to top |
|
|
iandoug l33t
Joined: 11 Feb 2005 Posts: 816 Location: Cape Town, South Africa
|
Posted: Wed Oct 30, 2013 11:09 am Post subject: |
|
|
Goverp wrote: | Have you looked for your mail in ~/.local/share/.local-mail.directory ? (note that the third level directory is ALSO hidden) It's not exactly well-documented, but that's where kmail keeps the mail, irrespective of anything in akonadi. |
Yes, I did look there. I have multiple accounts, each with their own folder structure, and for some reason it appears as though my two main work-related accounts got wiped. One was the default account on the box. Other accounts APPEAR to be okay, although the filtering in kmail was all screwed up and messages were being redirected to folders in other accounts.
I've also done things like 'locate /tmp' etc which finds the tmp accounts in each maildir setup, but not for the two accounts that disappeared.
At present I suspect that when I followed the instructions linked to in my message above, and did "rm -r ~/.local/share/akonadi/db_data", and failed to rebuild the database with the "mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data/", then when I rebooted and akonadi restarted, it found no data for those accounts and tried to bring the mail folders into line by deleting them.
I know this is not entirely logical (why some but not all, and does Akonadi even work that way?), but the only alternative I can think of is malicious (ie virus/whatever) which is even more illogical....
I specifically use Kmail (as opposed to Thunderbird/Evolution) because I want maildir because I consider it safer (and I don't like Claws).
Kmail used to be sane and keep things in ~/Mail, have no idea why that was considered 'no good'. I sometimes wish the KDE devs would stop adding bells and whistles and get the platform rock solid first. (disclaimer: I am on ~AMD64 because that branch has some bugfixes that I thought would make it more stable, especially the PIM side).
My calendar with birthdays etc is also missing, I may be able to find those files somewhere, although locate does not find any .cal files...
Thanks for trying to help. _________________ Asus X570-PRO, Ryzen 7 5800X, GeForce GTX 1650, 32 GB RAM | Asus Sabertooth P990, AMD FX-8150, GeForce GTX 560, 16GB Ram |
|
Back to top |
|
|
albright Advocate
Joined: 16 Nov 2003 Posts: 2588 Location: Near Toronto
|
Posted: Wed Oct 30, 2013 1:32 pm Post subject: |
|
|
kmail is a right pain ... but I keep using it
one safety measure is to use offlineimap, which keeps
a local backup of imap mail. This can be run as a cron
job so your mail is just regularly stored locally. You can
then integrate the offlineimap directories with your
regular system backup (I use snapback2 e.g.) _________________ .... there is nothing - absolutely nothing - half so much worth
doing as simply messing about with Linux ...
(apologies to Kenneth Graeme) |
|
Back to top |
|
|
Tanktalus Tux's lil' helper
Joined: 27 Apr 2005 Posts: 86
|
Posted: Tue Nov 05, 2013 6:40 pm Post subject: |
|
|
What kernel and video driver are you using?
If nvidia, back it off a level or two.
That resolved my issues. |
|
Back to top |
|
|
iandoug l33t
Joined: 11 Feb 2005 Posts: 816 Location: Cape Town, South Africa
|
Posted: Tue Aug 05, 2014 6:26 am Post subject: Maybe this is the solution |
|
|
Hi
Had similar issues again with Kmail refusing to start, and complaining about errors in the MySQL log file, after doing a rather large update last night, which included upgrading MySQL and MariaDB.
After poking around on the net, I found advice which suggested:
1. mysql_upgrade --password=your mysql root password ... you might need to run this as root as well
2. deleting the mysql log files... in my case the only ones left were at
/home/ian/.local/share/akonadi/db_data/
so I rm ib_logfile1 and rm ib_logfile0
and rebooted
and that appears to fix the problem
Hope this helps someone else...
Suggestion: should emerging mysql not auto-do the mysql_upgrade? Or at least print a suitable message when all is done (doing it right after the emerge won't help, since not many people will see it...)
cheers, Ian _________________ Asus X570-PRO, Ryzen 7 5800X, GeForce GTX 1650, 32 GB RAM | Asus Sabertooth P990, AMD FX-8150, GeForce GTX 560, 16GB Ram |
|
Back to top |
|
|
Desti² Tux's lil' helper
Joined: 06 Sep 2003 Posts: 127
|
Posted: Sun Aug 10, 2014 4:58 pm Post subject: |
|
|
Now run into the same mysql issue after mysql 5.5 upgrade. Have run mysql-upgrade with no errors, but still doesn't work and akonadi server says it can not find mysql_install_db
Code: | search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.8.3", "/usr/lib64/subversion/bin", "/usr/games/bin", "/opt/cuda/bin", "/opt/cuda/libnvvp", "/opt/ekopath/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"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL3 QMYSQL
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file /var/tmp/portage/app-office/akonadi-server-1.13.0/work/akonadi-1.13.0/server/src/storage/dbconfigmysql.cpp, line 172
"[
0: akonadiserver(_Z11akBacktracev+0x38) [0x46bc78]
1: akonadiserver() [0x46bedc]
2: /lib64/libc.so.6(+0x38cd0) [0x7f6fa1086cd0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f6fa1086c39]
4: /lib64/libc.so.6(abort+0x147) [0x7f6fa10881c7]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f6fa2898044]
6: /usr/lib64/qt4/libQtCore.so.4(+0x781d9) [0x7f6fa28981d9]
7: /usr/lib64/qt4/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7f6fa2898a14]
8: akonadiserver(_ZN7Akonadi6Server13DbConfigMysql19startInternalServerEv+0x1714) [0x4d4b54]
9: akonadiserver(_ZN7Akonadi6Server13AkonadiServer20startDatabaseProcessEv+0xd7) [0x46eaf7]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0xa5) [0x471145]
11: akonadiserver() [0x539554]
12: /usr/lib64/qt4/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x246) [0x7f6fa29c02c6]
13: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6c) [0x7f6fa29a796c]
14: /usr/lib64/qt4/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1e3) [0x7f6fa29aaaa3]
15: /usr/lib64/qt4/libQtCore.so.4(+0x1b5e5e) [0x7f6fa29d5e5e]
16: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x26b) [0x7f6fa0b4360b]
17: /usr/lib64/libglib-2.0.so.0(+0x4d828) [0x7f6fa0b43828]
18: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f6fa0b438ec]
19: /usr/lib64/qt4/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x7c) [0x7f6fa29d55bc]
20: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f6fa29a64cf]
21: /usr/lib64/qt4/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x16d) [0x7f6fa29a680d]
22: /usr/lib64/qt4/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7f6fa29abb09]
23: akonadiserver(main+0x1dd) [0x465edd]
24: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f6fa1072dd5]
25: akonadiserver() [0x466741]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted! |
mysql.err in .local/share/akonadi/db_data/
Code: | 140810 19:10:09 InnoDB: The InnoDB memory heap is disabled
140810 19:10:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140810 19:10:09 InnoDB: Compressed tables use zlib 1.2.8
140810 19:10:09 InnoDB: Using Linux native AIO
140810 19:10:09 InnoDB: Initializing buffer pool, size = 80.0M
140810 19:10:09 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
140810 19:10:09 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files. |
_________________ Linux Users Everywhere @ climateprediction.net |
|
Back to top |
|
|
Desti² Tux's lil' helper
Joined: 06 Sep 2003 Posts: 127
|
Posted: Sun Aug 10, 2014 6:01 pm Post subject: |
|
|
OK, I recompiled akonadi-server with USE="sqlite mysql postgres" because I wanted to check out the other dbs, and deleted .local/share/akonadi and it's working again, but had to reconfigure kmail settings ect. _________________ Linux Users Everywhere @ climateprediction.net |
|
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
|
|