On 15 July 2010 06:53, Mick <michaelkintz...@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(_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