Hello

I'm a happy Arch Linux x86_64 and KDE 4.3.1 (well, KDEmod to be completely honest) hothead I have been using different Linux distros for about 3 years now, and always with KDE on-board. I moved from 3.5.x to 4.x branch recently and still trying to familiarize myself with new environment and some interesting and also new concepts. Akonadi is one of those concepts but let's now move to the point

As far as I understand Akonadi is a server and a technique to store personal data of different applications in one convenient manner, so they could be easily accessed, right? Unfortunately Akonadi on my system isn't working as it should be. In order to make it start along with the system I've left it running on one session and restarted (the old KDE method). It seemed to work on first sight, as it's icon showed in the system tray, but when clicked it became evident, that it's not running. I am able to start it form that tray-icon but it's inconvenient, and that's the first issue. The second is showing when starting Akonadi - two pop-up windows emerge (click an image to enlarge it)





(of course those two files mentioned above, that is std.vcf and std.ics are located in my /home folder - I have configured Akonadi before I started it by pointing those two files)

Moreover when I exit KMail the second box also appears, which is quite understandable. Akonadi's test shows the box below



The text is in Polish, so I'll translate error messages for you. First one says: "MySQL server log contains errors", and the second: "Previous Akonadi server error log found". The first log contains

Code: Select all

090905 23:44:25 [Note] Plugin 'FEDERATED' is disabled.
090905 23:44:25 [Note] Plugin 'ndbcluster' is disabled.
090905 23:44:25  InnoDB: Started; log sequence number 0 181642
090905 23:44:25 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
090905 23:44:25 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090905 23:44:25 [ERROR] Cannot open mysql.db
090905 23:44:25 [ERROR] Cannot open mysql.user
090905 23:44:25 [ERROR] Cannot open mysql.event
090905 23:44:25 [ERROR] Event Scheduler: An error occurred when initializing system tables.
090905 23:44:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.37-log'  socket: '/home/zbyszek/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source distribution

and the second

Code: Select all

Control process died, committing suicide!
D-Bus session bus went down - quitting

I have already given a lot of information above, I guess, but one more thing that could be useful for someone, who will be kind enough to help me with this Below I paste parts of the Akonadi Server Self-Test Report, which didn't end with success. I decided to do so in order to make things more clear and "reader-friendly".

Code: Select all

Akonadi Server Self-Test Report
===============================
(...)
Test 4:  ERROR
--------

MySQL server log contains errors.
Details: The MySQL server error log file &apos;<a href='/home/zbyszek/.local/share/akonadi/db_data/mysql.err'>/home/zbyszek/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.

File content of '/home/zbyszek/.local/share/akonadi/db_data/mysql.err':
090905 23:44:25 [Note] Plugin 'FEDERATED' is disabled.
090905 23:44:25 [Note] Plugin 'ndbcluster' is disabled.
090905 23:44:25  InnoDB: Started; log sequence number 0 181642
090905 23:44:25 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
090905 23:44:25 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090905 23:44:25 [ERROR] Cannot open mysql.db
090905 23:44:25 [ERROR] Cannot open mysql.user
090905 23:44:25 [ERROR] Cannot open mysql.event
090905 23:44:25 [ERROR] Event Scheduler: An error occurred when initializing system tables.
090905 23:44:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.37-log'  socket: '/home/zbyszek/.local/share/akonadi/db_misc/mysql.socket'  port: 0  Source distribution
(...)
Test 6:  SKIP
--------

MySQL server custom configuration not available.
Details: The custom configuration for the MySQL server was not found but is optional.
(...)
Test 11:  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 14:  ERROR
--------

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

File content of '/home/zbyszek/.local/share/akonadi/akonadiserver.error.old':
Control process died, committing suicide!
D-Bus session bus went down - quitting
(...)

So basically there are two issues I would like to solve: 1) making Akonadi to start during system start, and 2) making it work without errors of course.
Please help me with this. If someone would need more information I would gladly give it, just tell me what and how to obtain it

Judging by the error messages, either your MySQL installation is damaged, or the Akonadi databases are severely corrupted.

Try removing ~/.local/share/akonadi if you have nothing stored in it.

Hello bcooksley

I'm not sure if I have stored anything in Akonadi databases as I've been having problems with running it form the very beginning, but the folder you've mentioned isn't empty. On the contrary, it contains plenty files and three other folders: db_data, db_misc and file_db_data, and only the last one is totally empty. Is it safe to delete all those files and folders? Will they be regenerated after I reboot my system?

Yes, it is fine. They will be automatically recreated when Akonadi is next started ( which can be done from within the System Settings Akonadi configuration module ).

Code: Select all

akonadictl stop
sleep 5s
killall -9 akonadicontrol
killall -9 akonadiserver
killall -9 mysql
rm -rf ~/.local/share/Akonadi
akonadictl start

Here's what I got

Code: Select all

bash-4.0$ su                               
Hasło:                                     
bash-4.0# akonadictl stop                 
D-Bus session bus is not available!       
"[                                         
0: akonadictl(_Z11akBacktracev+0x39) [0x40bbd9]
1: akonadictl [0x40c122]                       
2: /lib/libc.so.6 [0x7f6b57808f90]             
3: /lib/libc.so.6(gsignal+0x35) [0x7f6b57808f15]
4: /lib/libc.so.6(abort+0x180) [0x7f6b5780a340]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f6b5898e77f]
6: akonadictl(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40cc58]                 
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f6b58a18f3e]         
8: /usr/lib/libQtCore.so.4 [0x7f6b58a26cc9]                                         
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f6b58a27cf8]             
10: akonadictl(_ZN13AkApplicationC1ERiPPc+0x15b) [0x40806b]                         
11: akonadictl(main+0x2a) [0x40ddea]                                               
12: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f6b577f59ed]                         
13: akonadictl [0x407059]                                                           
]                                                                                   
"                                                                                   
bash-4.0# sleep 5s                                                                 
bash-4.0# killall -9 akonadicontrol                                                 
akonadicontrol: nie znaleziono żadnego procesu                                     
bash-4.0# killall -9 akonadiserver
bash-4.0# killall -9 mysql
mysql: nie znaleziono żadnego procesu
bash-4.0# rm -rf ~/.local/share/Akonadi
bash-4.0# akonadictl start
D-Bus session bus is not available!
"[
0: akonadictl(_Z11akBacktracev+0x39) [0x40bbd9]
1: akonadictl [0x40c122]
2: /lib/libc.so.6 [0x7f23f541ef90]
3: /lib/libc.so.6(gsignal+0x35) [0x7f23f541ef15]
4: /lib/libc.so.6(abort+0x180) [0x7f23f5420340]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f23f65a477f]
6: akonadictl(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40cc58]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f23f662ef3e]
8: /usr/lib/libQtCore.so.4 [0x7f23f663ccc9]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f23f663dcf8]
10: akonadictl(_ZN13AkApplicationC1ERiPPc+0x15b) [0x40806b]
11: akonadictl(main+0x2a) [0x40ddea]
12: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f23f540b9ed]
13: akonadictl [0x407059]
]
"


The problem still remains

Running as root is not required. These must be done as a normal user.

One more time then

Code: Select all

bash-4.0$ akonadictl stop
bash-4.0$ sleep 5s       
bash-4.0$ killall -9 akonadicontrol
akonadicontrol: nie znaleziono żadnego procesu
bash-4.0$ killall -9 akonadiserver           
akonadiserver: nie znaleziono żadnego procesu
bash-4.0$ killall -9 mysql                   
mysql: nie znaleziono żadnego procesu         
bash-4.0$ rm -rf ~/.local/share/Akonadi       
bash-4.0$ akonadictl start                   
Starting Akonadi Server...                   
   done.                                     
bash-4.0$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[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] Database "akonadi" opened using driver "QMYSQL"         
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"         
PLUGINS:  "/usr/share/akonadi/agents"                                   
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")                                                     
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource")                                                   
PLUGINS inserting:  "akonadi_distlist_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" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 1 ("Resource")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '0-akonadi_ical_resource_0' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '0-akonadi_vcard_resource_0' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"

After the last command I did see the pop-up windows, which I described in my first post

Unfortunately I do not know much regarding Akonadi's SQL database, perhaps Anda_Skoa will know more.

So no one knows how to solve this?

More info. Here's what happens when I try to start Akonadi from console...

Code: Select all

bash-4.0$ akonadictl start                             
Starting Akonadi Server...                             
   done.                                               
bash-4.0$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[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] Database "akonadi" opened using driver "QMYSQL"         
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"         
PLUGINS:  "/usr/share/akonadi/agents"                                   
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")                     
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource")             
PLUGINS inserting:  "akonadi_distlist_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" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 1 ("Resource")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '0-akonadi_ical_resource_0' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '0-akonadi_vcard_resource_0' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"

Hi ! (sorry for my bad english)

same problem under kubuntu 9.04 on KDE 4.3.1 (akonadi 1.2.1) :

Code: Select all

kxkb: Fatal IO error: client killed
kdeinit4: Fatal IO error: client killed
kdeinit4: sending SIGHUP to children.
*** KMail got signal 1 (Exiting)
*** KMail got signal 11 (Crashing)
Fatal Error: Accessed global static 'QList<KMainWindow*> *sMemberList()' after destruction. Defined at /build/buildd/kde4libs-4.3.1/kdeui/widgets/kmainwindow.cpp:213
kdeinit4: sending SIGTERM to children.
kdeinit4: Exit.
klauncher: Exiting on signal 15
klauncher: Exiting on signal 1
QProcess: Destroyed while process is still running.
[akonadiserver] Control process died, committing suicide!
[akonadiserver] terminating service threads
Unexpected response from KInit (response = 0).
startkde: Could not start ksmserver. Check your installation.
[akonadiserver] terminating connection threads
kded4: Fatal IO error: client killed
[akonadiserver] stopping db process
kglobalaccel: Fatal IO error: client killed
Qt-subapplication: Fatal IO error: client killed
nepomukserver: Fatal IO error: client killed
kdeinit4: Fatal IO error: client killed
kdeinit4: sending SIGHUP to children.
[/usr/bin/akonadi_ical_resource] ICE default IO error handler doing an exit(), pid = 20837, errno = 11
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: Fatal IO error: client killed
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: Fatal IO error: client killed
ProcessControl: Application '/usr/bin/akonadi_ical_resource' returned with exit code 1 (Unknown error)
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
kdeinit4: sending SIGTERM to children.
kdeinit4: Exit.
[/usr/bin/akonadi_ical_resource] No protocol specified
[/usr/bin/akonadi_ical_resource] akonadi_ical_resource: cannot connect to X server :0
[/usr/bin/akonadi_vcard_resource] No protocol specified
ProcessControl: Application '/usr/bin/akonadi_ical_resource' returned with exit code 1 (Unknown error)
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
[/usr/bin/akonadi_vcard_resource] No protocol specified
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
[/usr/bin/akonadi_ical_resource] No protocol specified
[/usr/bin/akonadi_vcard_resource] No protocol specified
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
[/usr/bin/akonadi_ical_resource] akonadi_ical_resource: cannot connect to X server :0
[/usr/bin/akonadi_vcard_resource] No protocol specified
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
ProcessControl: Application '/usr/bin/akonadi_ical_resource' returned with exit code 1 (Unknown error)
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
[/usr/bin/akonadi_vcard_resource] No protocol specified
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
"/usr/bin/akonadi_vcard_resource" crashed too often and will not be restarted!
[/usr/bin/akonadi_vcard_resource] No protocol specified
[/usr/bin/akonadi_vcard_resource] akonadi_vcard_resource: cannot connect to X server :0
ProcessControl: Application '/usr/bin/akonadi_vcard_resource' returned with exit code 1 (Unknown error)
"/usr/bin/akonadi_vcard_resource" crashed too often and will not be restarted!
[/usr/bin/akonadi_ical_resource] No protocol specified
[/usr/bin/akonadi_ical_resource] akonadi_ical_resource: cannot connect to X server :0
ProcessControl: Application '/usr/bin/akonadi_ical_resource' returned with exit code 1 (Unknown error)
"/usr/bin/akonadi_ical_resource" crashed too often and will not be restarted!
Application 'akonadiserver' exited normally...
QIODevice::putChar: Closed device
D-Bus session bus went down - quitting

@jajaX: that is caused by the KDE session failing to start up. Please check your installation, in particular that all of kdebase-runtime is installed and up to date.

ok sorry.


My KDE is unstable it's right. I wait kamric for make new clean installation.

Hello

I have the same problem on Kubuntu Karmic, migrated from Jaunty. Thus, I had to install the meta-package mysql-server to force the MySQL server update from 5.0 to 5.1 that was preventing Akonadi to start.

No it starts but I get this :

Code: Select all

Test 4:  ERROR
--------

MySQL server log contains errors.
Details: The MySQL server error log file &apos;<a href='/home/stephan/.local/share/akonadi/db_data/mysql.err'>/home/stephan/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.

File content of '/home/stephan/.local/share/akonadi/db_data/mysql.err':
091029 22:12:37 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
091029 22:12:37  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
091029 22:12:38  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 64 MB
InnoDB: Database physically writes the file full: wait...
091029 22:12:41  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 64 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
091029 22:12:45  InnoDB: Started; log sequence number 0 0
091029 22:12:45 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
091029 22:12:45 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
091029 22:12:45 [ERROR] Cannot open mysql.db
091029 22:12:45 [ERROR] Cannot open mysql.user
091029 22:12:45 [ERROR] Cannot open mysql.event
091029 22:12:45 [ERROR] Event Scheduler: An error occurred when initializing system tables.
091029 22:12:45 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.37-1ubuntu5-log'  socket: '/home/stephan/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)


So I deleted ~/.local/share/akonadi and restart the Akonadi server, but I get the exact same error message above.

In the [TEST 1] section, I see there's a debug entry where Tracer=null.
Maybe a smart value would give more valuable information ?

EDIT :
As the MySQL Server has been upgraded, the database(s) must also be.
Thus, the command mysql_upgrade (mysql_fix_privilege_tables is deprecated) must be issued eventualy with the MySQL root password

sudo mysql_upgrade --password=foobar

But... I think the MySQL databases in /var/lib are upgraded, not Akonadi's
as I still have the error above.
Still searching...

Akonadi's MySQL database is stored in ~/.local/share/akonadi and its settings in ~/.config/akonadi

You need to check the contents of ~/.config/akonadi/akonadiserverrc and find the "Options" line in the "QMYSQL" section.

You can use that socket setting to access its database when it is running.

Thanks for your help. But there's still something I'm missing.

here's what I did and that failed :

Code: Select all

stephan@orthos:~/.config/akonadi$ mysql_upgrade --socket=/home/stephan/.local/share/akonadi/db_misc/mysql.socket
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/stephan/.local/share/akonadi/db_misc/mysql.socket'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/stephan/.local/share/akonadi/db_misc/mysql.socket' (111) when trying to connect
FATAL ERROR: Upgrade failed

Of course, /home/stephan/.local/share/akonadi/db_misc/mysql.socket is the socket defined in the ~/.config/akonadi/akonadiserverrc

Thanks for your help

Edit :
By the way, as I deleted ~/.local/akonadi/* after upgrading to mysql 5.1 and tried to re-run Akonadi, the current akonadi database has been created from scratch by akonadi itself. Thus, the DB should be all right, with no table missing.
BUT tables are missing. Wouldn't that mean that Kubuntu 9.10 packages a damage akonadi package with some out-of-date SQL file for generating the DB ?

reEDIT :

Code: Select all

mysql> show tables ;
+----------------------------+
| Tables_in_akonadi          |
+----------------------------+
| collectionattributetable   |
| collectionmimetyperelation |
| collectionpimitemrelation  |
| collectiontable            |
| flagtable                  |
| mimetypetable              |
| parttable                  |
| pimitemflagrelation        |
| pimitemtable               |
| resourcetable              |
| schemaversiontable         |
+----------------------------+


Code: Select all

mysql> show tables ;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
+---------------------------------------+