Over the last two days I have noticed a lot of crashes every time I
start kmail. The popup says:

Details: Executable: akonadi_maildir_resource PID:27916 Signal: 6 (Aborted)

This pop up keeps repeating itself with different PIDs. Eventually,
all settles and I can use kmail.

The problem has started without me updating any KDE related package (I
think) and have run lafilefixer and revdep-rebuild for good measure.

It is worth mentioning that with KDE-4.4.4 akonadi would crash
randomly when trying to launch kmail and take kmail down with it.
Restarting kmail worked on the second attempt. Unfortunately, the
multiple popups are hindering productivity and am thinking of calling
it a day on kmail.

Any ideas on what is causing this and more importantly how I could fix it?

I'm attaching the errors when I launch kmail from a terminal.

PS. While I'm at it: any other good mail clients out there (other
than T'bird) which include an address book and S/MIME, GnuPG, but do
*not* require a lorry load of gnome libs?
--
Regards,
Mick

On Wednesday 14 July 2010 18:29:58 Mick wrote:
> Over the last two days I have noticed a lot of crashes every time I
> start kmail. The popup says:
>
> Details: Executable: akonadi_maildir_resource PID:27916 Signal: 6
> (Aborted)
>
> This pop up keeps repeating itself with different PIDs. Eventually,
> all settles and I can use kmail.
>
> The problem has started without me updating any KDE related package (I
> think) and have run lafilefixer and revdep-rebuild for good measure.
>
> It is worth mentioning that with KDE-4.4.4 akonadi would crash
> randomly when trying to launch kmail and take kmail down with it.
> Restarting kmail worked on the second attempt. Unfortunately, the
> multiple popups are hindering productivity and am thinking of calling
> it a day on kmail.
>
> Any ideas on what is causing this and more importantly how I could fix it?
>
> I'm attaching the errors when I launch kmail from a terminal.
>
> PS. While I'm at it: any other good mail clients out there (other
> than T'bird) which include an address book and S/MIME, GnuPG, but do
> *not* require a lorry load of gnome libs?


Things go much easier when your erorr log is only 15k if you just in-line it.
You made an attachment which is gzipped. The effort that implies almost bad me
delete your mail and no answer as being tl;dr

So here it is:

$ kmail
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
kdeinit4: preparing to launch /usr/lib64/libkdeinit4_klauncher.so
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
kdeinit4: preparing to launch /usr/lib64/libkdeinit4_kded4.so
kdeinit4: preparing to launch /usr/lib64/libkdeinit4_kbuildsycoca4.so
kbuildsycoca4 running...
kdeinit4: preparing to launch /usr/lib64/libkdeinit4_kconf_update.so
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
kdeinit4: preparing to launch /usr/lib64/libkdeinit4_kwalletd.so
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service
files"
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"QLocalSocket::connectToServer: Invalid name"
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service
files"
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"QLocalSocket::connectToServer: Invalid name"
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"org.freedesktop.DBus.Error.ServiceUnknown - The name
org.kde.nepomuk.services.nepomukstorage was not provided by any .service
files"
"/usr/bin/kmail(12552)" Error in thread 140590807091040 :
"QLocalSocket::connectToServer: Invalid name"
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection
'initConnection' is still in use, all queries will cease to work.
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] checking table "FlagTable"
[akonadiserver] checking table "PartTable"
[akonadiserver] checking table "CollectionAttributeTable"
[akonadiserver] checking relation "PimItemFlagRelation"
[akonadiserver] checking relation "CollectionMimeTypeRelation"
[akonadiserver] checking relation "CollectionPimItemRelation"
[akonadiserver] DbInitializer::run() done
[akonadiserver] skipping update 2
[akonadiserver] skipping update 3
[akonadiserver] skipping update 4
[akonadiserver] skipping update 8
[akonadiserver] skipping update 10
[akonadiserver] skipping update 12
[akonadiserver] skipping update 13
[akonadiserver] DbUpdater: update to version: 14 mandatory: false code:
"UPDATE ResourceTable SET isVirtual = true WHERE name =
'akonadi_nepomuktag_resource';
[akonadiserver] UPDATE ResourceTable SET isVirtual = true WHERE name =
'akonadi_search_resource';"
[akonadiserver] DBUpdater: query error: "no such column: true Unable to
execute statement" " "


akonadi is attempting to update your database structure when it starts. This
accounts for any long start-up times you are experiencing. You should try
access the db manually (with akonadi and kmail both dead) and attempt the
update. Investigate and see why it doesn't work. It's 100% bog standard sql


[akonadiserver] Query was: "UPDATE ResourceTable SET isVirtual = true WHERE
name = 'akonadi_nepomuktag_resource';
[akonadiserver] UPDATE ResourceTable SET isVirtual = true WHERE name =
'akonadi_search_resource';"
[akonadiserver] Target version was: 14
[akonadiserver] Mandatory: false
[akonadiserver] Failed to commit transaction for database update
[akonadiserver] Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] QDBusConnectionPrivate::connectSignal: received error from D-
Bus server while connecting signal to
QDBusConnectionInterface::NameOwnerChanged(QString ,QString,QString):
org.freedesktop.DBus.Error.NoMemory (Not enough memory)
[akonadiserver] Nepomuk QueryServer interface not available!
[akonadiserver] DataStore::unhideAllPimItems()
[akonadiserver] UPDATE ResourceTable SET isVirtual = true WHERE name =
'akonadi_search_resource';"
[akonadiserver] Target version was: 14
[akonadiserver] Mandatory: false
[akonadiserver] Failed to commit transaction for database update
[akonadiserver] Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
^^^^^^^

akonadi docs specifically recommend you do not use sqlite. It just is not up
to the job. I think you should just delete this database, start akonadi and
kmail and let it rebuild all the stuff it wants. This implies and lot of
starting over on your behalf.


[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] QDBusConnectionPrivate::connectSignal: received error from D-
Bus server while connecting signal to
QDBusConnectionInterface::NameOwnerChanged(QString ,QString,QString):
org.freedesktop.DBus.Error.NoMemory (Not enough memory)
^^^^^^^^^^^^^^^^^

Oops......


[akonadiserver] Nepomuk QueryServer interface not available!
[akonadiserver] DataStore::unhideAllPimItems()
PLUGINS: "/usr/share/akonadi/agents"
PLUGINS: ("birthdaysresource.desktop", "contactsresource.desktop",
"icalresource.desktop", "imapresource.desktop", "kabcresource.desktop",
"kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop",
"localbookmarksresource.desktop", "maildirresource.desktop",
"maildispatcheragent.desktop", "mboxresource.desktop", "microblog.desktop",
"mtdummyresource.desktop", "nepomukcalendarfeeder.desktop",
"nepomukcontactfeeder.desktop", "nepomuktagresource.desktop",
"nntpresource.desktop", "notesresource.desktop", "pop3resource.desktop",
"vcarddirresource.desktop", "vcardresource.desktop")
search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin",
"/usr/x86_64-pc-linux-gnu/gcc-bin/4.4.3", "/opt/ICAClient")
PLUGINS inserting: "akonadi_birthdays_resource" 1 ("Resource")
PLUGINS inserting: "akonadi_contacts_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_ical_resource" 1 ("Resource")
PLUGINS inserting: "akonadi_imap_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_kabc_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_kcal_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_kolabproxy_resource" 0 ("Resource", "Unique",
"NoConfig")
PLUGINS inserting: "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_maildir_resource" 84 ("Resource")
PLUGINS inserting: "akonadi_maildispatcher_agent" 0 ("Unique", "Autostart",
"NoConfig")
PLUGINS inserting: "akonadi_mbox_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_mailtransport_dummy_resource" 0 ("Resource",
"MailTransport")
PLUGINS inserting: "akonadi_nepomuk_calendar_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting: "akonadi_nepomuk_contact_feeder" 0 ("Unique", "Autostart",
"NoConfig")
PLUGINS inserting: "akonadi_nepomuktag_resource" 0 ("Resource", "Virtual",
"Unique", "NoConfig")
PLUGINS inserting: "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_notes_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_pop3_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting: "akonadi_vcard_resource" 1 ("Resource")
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_40(12617):
Couldn't remove lockfile "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock"
^^^^^^^^^^^^^^^^^^^^^^^^


Does this file exist?


[/usr/bin/akonadi_maildir_resource] terminate called after throwing an
instance of 'std::bad_alloc'
[/usr/bin/akonadi_maildir_resource] what(): std::bad_alloc
[/usr/bin/akonadi_maildir_resource] KCrash: Application
'akonadi_maildir_resource' crashing...
kdeinit4: preparing to launch /usr/lib64/kde4/libexec/drkonqi
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_32(12604): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_35(12610): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_33(12607): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_39(12615): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_4(12616): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_43(12623): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_38(12614): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_36(12611): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_41(12619): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_37(12613): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] qUncompress: Input data is corrupted
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_36(12611): stream
is bad :-( status= 1
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_50(12633): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_54(12637): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 2
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_43(12623): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_51(12634): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 1
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] qUncompress: Input data is corrupted
kmail(12552)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
[/usr/bin/akonadi_maildir_resource] qUncompress: Input data is corrupted
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_36(12611): stream
is bad :-( status= 1
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_58(12643): stream
is bad :-( status= 1
kmail(12552): Couldn't remove lockfile "/var/tmp/kdecache-michael/kpc/kde-
icon-cache.lock"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
opened using driver "QSQLITE"
[/usr/bin/akonadi_maildir_resource] akonadi_maildir_resource_56(12640): Failed
to lock file "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock" , last result
= 2
kmail(12552)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:



I must be honest that on the whole I'm left with an overwhelming feeling that
you simply did not bother to read the errors.

This is a bad habit for a gentoo user. Very bad indeed.


--
alan dot mckinnon at gmail dot com

On Wednesday 14 July 2010 21:25:10 Alan McKinnon wrote:
> On Wednesday 14 July 2010 18:29:58 Mick wrote:

> akonadi is attempting to update your database structure when it starts.
> This accounts for any long start-up times you are experiencing. You should
> try access the db manually (with akonadi and kmail both dead) and attempt
> the update. Investigate and see why it doesn't work. It's 100% bog
> standard sql

I am almost sure that this was not the case with KDE-4.3 or if it was, then
this update did not take longer than a second.


> [akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
> opened using driver "QSQLITE"
> ^^^^^^^
>
> akonadi docs specifically recommend you do not use sqlite. It just is not
> up to the job. I think you should just delete this database, start akonadi
> and kmail and let it rebuild all the stuff it wants. This implies and lot
> of starting over on your behalf.

Yes, SQLITE is not recommended, however it worked alright up until now.

Thanks for the suggestion, I will mv the db and try starting it again. How
does one start akonadi? It's no longer listed in systemsettings in KDE-4.4.

> [akonadiserver] Database "/home/michael/.local/share/akonadi/akonadi.db"
> opened using driver "QSQLITE"
> [akonadiserver] QDBusConnectionPrivate::connectSignal: received error from
> D- Bus server while connecting signal to
> QDBusConnectionInterface::NameOwnerChanged(QString ,QString,QString):
> org.freedesktop.DBus.Error.NoMemory (Not enough memory)
> ^^^^^^^^^^^^^^^^^
>
> Oops......

What does that mean? Why did it run out of memory - there's still plenty of
RAM.


> Couldn't remove lockfile
> "/var/tmp/kdecache-michael/kpc/kde-icon-cache.lock"
> ^^^^^^^^^^^^^^^^^^^^^^^^
>
>
> Does this file exist?

No, that's what got me confused and I had to ask here for suggestions. Why
would it be trying to access a lockfile which is not there?


> I must be honest that on the whole I'm left with an overwhelming feeling
> that you simply did not bother to read the errors.
>
> This is a bad habit for a gentoo user. Very bad indeed.

Alan, thank you for your help. I did read the errors although somewhat in a
rush.

I couldn't find the lock file akonadi referred to and I couldn't understand
why it was trying to access a file that was not there. I thought of blowing
the db and starting KDE or kmail, but just to be sure I asked here first. I
didn't want to risk losing access to my mail or address book.
--
Regards,
Mick

On 15 July 2010 06:53, Mick <michaelkintzios@gmail.com> wrote:

OK, the plot thickens ... I think more things have gone amiss with my
system. Some sort of corruption perhaps.

I moved the akonadi database and the next time I logged in and started
kmail the akonadi did its tests and the came up with this error (see
Test 10):
===========================


Akonadi Server Self-Test Report
===============================

Test 1: SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QSQLITE' is required by your current
Akonadi server configuration and was found on your system.

File content of '/home/michael/.config/akonadi/akonadiserverrc':
[%General]
Driver=QSQLITE
SizeThreshold=4096
ExternalPayload=false

[QSQLITE]
Name=/home/michael/.local/share/akonadi/akonadi.db
User=
Password=
Options=
StartServer=false
Host=

[Debug]
Tracer=null

[QMYSQL]
StartServer=true
ServerPath=/usr/bin/sqlite3
Name=akonadi
Host=
User=
Password=
Options=


Test 2: SKIP
--------

MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.

Test 3: SKIP
--------

MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.

Test 4: SKIP
--------

MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.

Test 5: SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi
server was found and could be executed successfully.
Result:
Akonadi 1.3.1


Test 6: ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 7: ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 8: ERROR
--------

Nepomuk search service not registered at D-Bus.
Details: The Nepomuk search service is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 9: SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to
check if the protocol version meets the requirements.

Test 10: ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable
without at least one. This usually means that no resource agents are
installed or that there is a setup problem. The following paths have
been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS
environment variable is set to '/usr/local/share:/usr/share', make
sure this includes all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/local/share:/usr/share'

Test 11: ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server did report error during startup into <a
href='/home/michael/.local/share/akonadi/akonadiserver.error'>/home/michael/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/michael/.local/share/akonadi/akonadiserver.error':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x40b9b9]
1: akonadiserver() [0x40bf02]
2: /lib/libc.so.6(+0x32230) [0x7fbe8374a230]
3: /lib/libc.so.6(gsignal+0x35) [0x7fbe8374a1b5]
4: /lib/libc.so.6(abort+0x180) [0x7fbe8374b5e0]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x74)
[0x7fbe8562b444]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+ 0xa8) [0x40d008]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7fbe856b9b17]
8: /usr/lib64/qt4/libQtCore.so.4(+0x1111b9) [0x7fbe856cb1b9]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7fbe856cc3a9]
10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x407559]
11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC 1EP7QObject+0x5f4)
[0x7fbe85a9b0a4]
12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8 instanceEv+0x4a)
[0x7fbe85a9be4a]
13: akonadiserver(main+0x3aa) [0x406bea]
14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fbe83736bbd]
15: akonadiserver() [0x406749]
]
"


Test 12: ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous
startup into <a
href='/home/michael/.local/share/akonadi/akonadiserver.error.old'>/home/michael/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/michael/.local/share/akonadi/akonadiserver.error.old':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x40b9b9]
1: akonadiserver() [0x40bf02]
2: /lib/libc.so.6(+0x32230) [0x7f90d82a6230]
3: /lib/libc.so.6(gsignal+0x35) [0x7f90d82a61b5]
4: /lib/libc.so.6(abort+0x180) [0x7f90d82a75e0]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x74)
[0x7f90da187444]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+ 0xa8) [0x40d008]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7f90da215b17]
8: /usr/lib64/qt4/libQtCore.so.4(+0x1111b9) [0x7f90da2271b9]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f90da2283a9]
10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x407559]
11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC 1EP7QObject+0x5f4)
[0x7f90da5f70a4]
12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8 instanceEv+0x4a)
[0x7f90da5f7e4a]
13: akonadiserver(main+0x3aa) [0x406bea]
14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f90d8292bbd]
15: akonadiserver() [0x406749]
]
"


Test 13: SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during
its current startup.

Test 14: SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during
its previous startup.
===========================

As the results of test 10 say it seems that something has gone
sideways with the resource agents. Is this an environment problem?
This is what I have under /usr/share/akonadi/agents, which akonadi
tells me that is has searched:

$ ls -la /usr/share/akonadi/agents
total 92
drwxr-xr-x 2 root root 24 Jun 25 13:04 .
drwxr-xr-x 3 root root 3 Jun 9 22:54 ..
-rw-r--r-- 1 root root 6595 May 28 10:43 birthdaysresource.desktop
-rw-r--r-- 1 root root 3277 May 28 10:43 contactsresource.desktop
-rw-r--r-- 1 root root 3715 Feb 26 18:34 icalresource.desktop
-rw-r--r-- 1 root root 3303 Apr 29 20:57 imapresource.desktop
-rw-r--r-- 1 root root 4728 Apr 29 20:57 kabcresource.desktop
-rw-r--r-- 1 root root 4775 Feb 26 18:34 kcalresource.desktop
-rw-r--r-- 1 root root 2656 Feb 26 18:34 knutresource.desktop
-rw-r--r-- 1 root root 5811 Apr 29 20:57 kolabproxyresource.desktop
-rw-r--r-- 1 root root 3907 Mar 26 17:29 localbookmarksresource.desktop
-rw-r--r-- 1 root root 3341 Jan 19 23:22 maildirresource.desktop
-rw-r--r-- 1 root root 1476 Apr 29 20:57 maildispatcheragent.desktop
-rw-r--r-- 1 root root 2837 May 28 10:43 mboxresource.desktop
-rw-r--r-- 1 root root 4673 Apr 29 20:57 microblog.desktop
-rw-r--r-- 1 root root 4050 Apr 29 20:57 mtdummyresource.desktop
-rw-r--r-- 1 root root 4401 Apr 29 20:57 nepomukcalendarfeeder.desktop
-rw-r--r-- 1 root root 4132 Feb 4 09:33 nepomukcontactfeeder.desktop
-rw-r--r-- 1 root root 5253 Feb 26 18:34 nepomuktagresource.desktop
-rw-r--r-- 1 root root 4416 Feb 26 18:34 nntpresource.desktop
-rw-r--r-- 1 root root 3552 Mar 26 17:29 notesresource.desktop
-rw-r--r-- 1 root root 2495 May 28 10:43 pop3resource.desktop
-rw-r--r-- 1 root root 3629 Feb 26 18:34 vcarddirresource.desktop
-rw-r--r-- 1 root root 3129 Feb 26 18:34 vcardresource.desktop

Now kmail crashes immediately after I acknowledge the akonadi self
test popup, so I can't use my mail. :-(

Any ideas?
--
Regards,
Mick

Dumb question: Is dbus running?




----- Original Message ----
From: Mick <michaelkintzios@gmail.com>
To: gentoo-user@lists.gentoo.org
Sent: Thu, July 15, 2010 10:04:08 AM
Subject: Re: [gentoo-user] Akonadi crashes

On 15 July 2010 06:53, Mick <michaelkintzios@gmail.com> wrote:

OK, the plot thickens ... I think more things have gone amiss with my
system. Some sort of corruption perhaps.

I moved the akonadi database and the next time I logged in and started
kmail the akonadi did its tests and the came up with this error (see
Test 10):
===========================


Akonadi Server Self-Test Report
===============================

Test 1: SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QSQLITE' is required by your current
Akonadi server configuration and was found on your system.

File content of '/home/michael/.config/akonadi/akonadiserverrc':
[%General]
Driver=QSQLITE
SizeThreshold=4096
ExternalPayload=false

[QSQLITE]
Name=/home/michael/.local/share/akonadi/akonadi.db
User=
Password=
Options=
StartServer=false
Host=

[Debug]
Tracer=null

[QMYSQL]
StartServer=true
ServerPath=/usr/bin/sqlite3
Name=akonadi
Host=
User=
Password=
Options=


Test 2: SKIP
--------

MySQL server executable not tested.
Details: The current configuration does not require an internal MySQL server.

Test 3: SKIP
--------

MySQL server error log not tested.
Details: The current configuration does not require an internal MySQL server.

Test 4: SKIP
--------

MySQL server configuration not tested.
Details: The current configuration does not require an internal MySQL server.

Test 5: SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi
server was found and could be executed successfully.
Result:
Akonadi 1.3.1


Test 6: ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 7: ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 8: ERROR
--------

Nepomuk search service not registered at D-Bus.
Details: The Nepomuk search service is not registered at D-Bus which
typically means it was not started or encountered a fatal error during
startup.

Test 9: SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to
check if the protocol version meets the requirements.

Test 10: ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable
without at least one. This usually means that no resource agents are
installed or that there is a setup problem. The following paths have
been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS
environment variable is set to '/usr/local/share:/usr/share', make
sure this includes all paths where Akonadi agents are installed to.

Directory listing of '/usr/share/akonadi/agents':
birthdaysresource.desktop
contactsresource.desktop
icalresource.desktop
imapresource.desktop
kabcresource.desktop
kcalresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mboxresource.desktop
microblog.desktop
mtdummyresource.desktop
nepomukcalendarfeeder.desktop
nepomukcontactfeeder.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to '/usr/local/share:/usr/share'

Test 11: ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server did report error during startup into <a
href='/home/michael/.local/share/akonadi/akonadiserver.error'>/home/michael/.local/share/akonadi/akonadiserver.error</a>.


File content of '/home/michael/.local/share/akonadi/akonadiserver.error':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x40b9b9]
1: akonadiserver() [0x40bf02]
2: /lib/libc.so.6(+0x32230) [0x7fbe8374a230]
3: /lib/libc.so.6(gsignal+0x35) [0x7fbe8374a1b5]
4: /lib/libc.so.6(abort+0x180) [0x7fbe8374b5e0]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x74)
[0x7fbe8562b444]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+ 0xa8) [0x40d008]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7fbe856b9b17]
8: /usr/lib64/qt4/libQtCore.so.4(+0x1111b9) [0x7fbe856cb1b9]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7fbe856cc3a9]
10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x407559]
11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC 1EP7QObject+0x5f4)
[0x7fbe85a9b0a4]
12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8 instanceEv+0x4a)
[0x7fbe85a9be4a]
13: akonadiserver(main+0x3aa) [0x406bea]
14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fbe83736bbd]
15: akonadiserver() [0x406749]
]
"


Test 12: ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server did report error during its previous
startup into <a
href='/home/michael/.local/share/akonadi/akonadiserver.error.old'>/home/michael/.local/share/akonadi/akonadiserver.error.old</a>.


File content of '/home/michael/.local/share/akonadi/akonadiserver.error.old':
"Unable to add initial data to table 'ResourceTable'.
Query error: 'no such column: true Unable to execute statement'
Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x39) [0x40b9b9]
1: akonadiserver() [0x40bf02]
2: /lib/libc.so.6(+0x32230) [0x7f90d82a6230]
3: /lib/libc.so.6(gsignal+0x35) [0x7f90d82a61b5]
4: /lib/libc.so.6(abort+0x180) [0x7f90d82a75e0]
5: /usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+ 0x74)
[0x7f90da187444]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+ 0xa8) [0x40d008]
7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77) [0x7f90da215b17]
8: /usr/lib64/qt4/libQtCore.so.4(+0x1111b9) [0x7f90da2271b9]
9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f90da2283a9]
10: akonadiserver(_ZN6QDebugD1Ev+0x49) [0x407559]
11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC 1EP7QObject+0x5f4)
[0x7f90da5f70a4]
12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8 instanceEv+0x4a)
[0x7f90da5f7e4a]
13: akonadiserver(main+0x3aa) [0x406bea]
14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f90d8292bbd]
15: akonadiserver() [0x406749]
]
"


Test 13: SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during
its current startup.

Test 14: SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during
its previous startup.
===========================

As the results of test 10 say it seems that something has gone
sideways with the resource agents. Is this an environment problem?
This is what I have under /usr/share/akonadi/agents, which akonadi
tells me that is has searched:

$ ls -la /usr/share/akonadi/agents
total 92
drwxr-xr-x 2 root root 24 Jun 25 13:04 .
drwxr-xr-x 3 root root 3 Jun 9 22:54 ..
-rw-r--r-- 1 root root 6595 May 28 10:43 birthdaysresource.desktop
-rw-r--r-- 1 root root 3277 May 28 10:43 contactsresource.desktop
-rw-r--r-- 1 root root 3715 Feb 26 18:34 icalresource.desktop
-rw-r--r-- 1 root root 3303 Apr 29 20:57 imapresource.desktop
-rw-r--r-- 1 root root 4728 Apr 29 20:57 kabcresource.desktop
-rw-r--r-- 1 root root 4775 Feb 26 18:34 kcalresource.desktop
-rw-r--r-- 1 root root 2656 Feb 26 18:34 knutresource.desktop
-rw-r--r-- 1 root root 5811 Apr 29 20:57 kolabproxyresource.desktop
-rw-r--r-- 1 root root 3907 Mar 26 17:29 localbookmarksresource.desktop
-rw-r--r-- 1 root root 3341 Jan 19 23:22 maildirresource.desktop
-rw-r--r-- 1 root root 1476 Apr 29 20:57 maildispatcheragent.desktop
-rw-r--r-- 1 root root 2837 May 28 10:43 mboxresource.desktop
-rw-r--r-- 1 root root 4673 Apr 29 20:57 microblog.desktop
-rw-r--r-- 1 root root 4050 Apr 29 20:57 mtdummyresource.desktop
-rw-r--r-- 1 root root 4401 Apr 29 20:57 nepomukcalendarfeeder.desktop
-rw-r--r-- 1 root root 4132 Feb 4 09:33 nepomukcontactfeeder.desktop
-rw-r--r-- 1 root root 5253 Feb 26 18:34 nepomuktagresource.desktop
-rw-r--r-- 1 root root 4416 Feb 26 18:34 nntpresource.desktop
-rw-r--r-- 1 root root 3552 Mar 26 17:29 notesresource.desktop
-rw-r--r-- 1 root root 2495 May 28 10:43 pop3resource.desktop
-rw-r--r-- 1 root root 3629 Feb 26 18:34 vcarddirresource.desktop
-rw-r--r-- 1 root root 3129 Feb 26 18:34 vcardresource.desktop

Now kmail crashes immediately after I acknowledge the akonadi self
test popup, so I can't use my mail. :-(

Any ideas?
--
Regards,
Mick

On Thursday 15 July 2010 20:57:20 Martin DiViaio wrote:
> Dumb question: Is dbus running?

Yes it is.

I think that the problem is with me using sqlite instead of mysql, as Alan
already suggested. On the basis that kmail was launching fine (albeit there
was the occasional akonadi crash) since I installed kde-4.4.4 I assumed that
akonadi was just a bit temperamental. However, it seems that with kde-4.4.4
sqlite is less compatible that it was with previous versions.

Deleting the akonadi.db causes sqlite to fail next time akonadi tries to
start:

http://www.mail-archive.com/kdepim-bugs@kde.org/msg27225.html

This is the reason that I could not start kmail at all after I deleted
akonadi.db

I have now restored akonadi.db from a back up and akonadi starts without
drama, however, my addressbook looks empty! I also restored this from a back
up, so I know it is not empty - also, when I start typing an address it
autocompletes.

I also tried to run:

INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource','true')

as the above link recommends, but it complains:

Error: no such table: ResourceTable

Any idea what the stanza should be?

Clearly kde-4.4.4 is a bit problematic for me because unlike kde devs I do not
need/want to run mysql just for less than 20 addresses or so, that I may have
in my address book.

It may be time to give claws-mail a spin.
--
Regards,
Mick

On 15 July 2010 22:25, Mick <michaelkintzios@gmail.com> wrote:

> Deleting the akonadi.db causes sqlite to fail next time akonadi tries to
> start:
>
> http://www.mail-archive.com/kdepim-bugs@kde.org/msg27225.html
>
> This is the reason that I could not start kmail at all after I deleted
> akonadi.db
>
> I have now restored akonadi.db from a back up and akonadi starts without
> drama, however, my addressbook looks empty! *I also restored this from a back
> up, so I know it is not empty - also, when I start typing an address it
> autocompletes.
>
> I also tried to run:
>
> *INSERT INTO ResourceTable (name,isVirtual) VALUES
> ('akonadi_search_resource','true')
>
> as the above link recommends, but it complains:
>
> Error: no such table: ResourceTable

OK, I found why this was - I needed to attach the akonadi.db first! Doh!

It now works and can launch kmail fine. :-)

The only problem seems to be that my kaddressbook is empty. This
could be because I am using the old kabc/std.vcf file instead of the
new .local/share/contacts directory format - although I tried the
latter and I got an address book listed, but no contacts in it are
shown in the GUI.

Will have to wait for the next version of KDE as advised on the KDE
akonadi pages.

> It may be time to give claws-mail a spin.

I did try it and can categorically say that it is not for me.
Managing messages with the keyboard, the way it integrates with Gmail,
its GbuPG and S/MIME plugins, are just not as convenient or smooth
flowing for me as is kmail.
--
Regards,
Mick