Re: [gentoo-user] Akonadi crashes

[Mick]

On 15 July 2010 06:53, Mick <michaelkintzios@×××××.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(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7fbe85a9b0a4]
12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+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(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7f90da5f70a4]
12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+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