Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
()W(#$ Akonadi [SOLVED ??]
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
iandoug
Apprentice
Apprentice


Joined: 11 Feb 2005
Posts: 294
Location: Cape Town, South Africa

PostPosted: Tue Oct 29, 2013 1:18 am    Post subject: ()W(#$ Akonadi [SOLVED ??] Reply with quote

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 M3A78 64, X2 6000+, PX9800 GT, 4GB Ram | Asus M4A77TD PRO, X2 245, HD4350, 4GB RAM


Last edited by iandoug on Tue Aug 05, 2014 6:27 am; edited 1 time in total
Back to top
View user's profile Send private message
eyoung100
Veteran
Veteran


Joined: 23 Jan 2004
Posts: 1411

PostPosted: Tue Oct 29, 2013 3:37 pm    Post subject: Reply with quote

See this Bug: kde-base/kdebase-startkde-4.11.2 - dbus agents not available / started twice due to typo in the declaration of XDG_DATA_DIRS in /usr/bin/startkde
_________________
The Birth and Growth of Science is the Death and Atrophy of Art -- Unknown
Registerd Linux User #363735
Adopt a Post | Strip Comments| Emerge Wrapper
Back to top
View user's profile Send private message
Goverp
Guru
Guru


Joined: 07 Mar 2007
Posts: 341

PostPosted: Wed Oct 30, 2013 10:17 am    Post subject: Reply with quote

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
View user's profile Send private message
iandoug
Apprentice
Apprentice


Joined: 11 Feb 2005
Posts: 294
Location: Cape Town, South Africa

PostPosted: Wed Oct 30, 2013 11:09 am    Post subject: Reply with quote

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 M3A78 64, X2 6000+, PX9800 GT, 4GB Ram | Asus M4A77TD PRO, X2 245, HD4350, 4GB RAM
Back to top
View user's profile Send private message
albright
Advocate
Advocate


Joined: 16 Nov 2003
Posts: 2099
Location: Near Toronto

PostPosted: Wed Oct 30, 2013 1:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
Tanktalus
Tux's lil' helper
Tux's lil' helper


Joined: 27 Apr 2005
Posts: 75

PostPosted: Tue Nov 05, 2013 6:40 pm    Post subject: Reply with quote

What kernel and video driver are you using?

If nvidia, back it off a level or two.

That resolved my issues.
Back to top
View user's profile Send private message
iandoug
Apprentice
Apprentice


Joined: 11 Feb 2005
Posts: 294
Location: Cape Town, South Africa

PostPosted: Tue Aug 05, 2014 6:26 am    Post subject: Maybe this is the solution Reply with quote

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 M3A78 64, X2 6000+, PX9800 GT, 4GB Ram | Asus M4A77TD PRO, X2 245, HD4350, 4GB RAM
Back to top
View user's profile Send private message
Desti²
Tux's lil' helper
Tux's lil' helper


Joined: 06 Sep 2003
Posts: 120

PostPosted: Sun Aug 10, 2014 4:58 pm    Post subject: Reply with quote

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
View user's profile Send private message
Desti²
Tux's lil' helper
Tux's lil' helper


Joined: 06 Sep 2003
Posts: 120

PostPosted: Sun Aug 10, 2014 6:01 pm    Post subject: Reply with quote

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
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