Akonadi reports: The MySQL server log contains warnings: InnoDB: The InnoDB memory heap is disabled InnoDB: use atomic builtins. 100407 9:01:29 InnoDB: Started; log sequence number 0 1438513128 100407 9:01:30 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 100407 9:01:30 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.90-log' socket: '/home/$USER/.local/share/akonadi/db_misc/mysql.socket' port: 0 Gentoo Linux mysql-5.0.90-r2 Is this a misconfiguration of Gentoo's MySQL? Reproducible: Always
(In reply to comment #0) > 100407 9:01:30 [Warning] Can't open and lock time zone table: Table > 'mysql.time_zone_leap_second' doesn't exist trying to live without them Did you run 'emerge --config dev-db/mysql' like the ebuild tells you to?
Yes, this machine was once running a dedicated MySQL server in the KDE3 days.
I tried running it again, just in case: * You have already a MySQL database in place. * (///var/lib/mysql/*) * Please rename or delete it if you wish to replace it.
(In reply to comment #1) > (In reply to comment #0) > > 100407 9:01:30 [Warning] Can't open and lock time zone table: Table > > 'mysql.time_zone_leap_second' doesn't exist trying to live without them > > Did you run 'emerge --config dev-db/mysql' like the ebuild tells you to? > That is completely irrelevant, as akaondi does *not* use a system instance of mysql, but runs mysqld itself with a data dir in ~/.local/share/akonadi (by default - and looking at the log, it still has those defaults) - in that case, the db in /var/lib/mysql isn't touched at all - so it *does not matter* what's going on there.
(In reply to comment #4) > That is completely irrelevant, as akaondi does *not* use a system instance of > mysql, but runs mysqld itself with a data dir in ~/.local/share/akonadi Pardon me. I run MySQL anyway, so I configured Akonadi to connect to it rather than start up another instance. I forgot that that is not the default behavior. So it looks like Akonadi simply doesn't initialize the time zone tables when it sets up a new MySQL instance.
Which akonadi-server version was this, and is the bug still valid?
It seems I have the same problem 101019 15:29:45 InnoDB: Started; log sequence number 0 1214821 101019 15:29:45 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 101019 15:29:45 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 101019 15:29:45 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.50-log' socket: '/home/philip/.local/share/akonadi/db_misc/mysql.socket' port: 0 Gentoo Linux mysql-5.1.50-r1
As a workaround: /usr/bin/mysql_install_db --datadir=$HOME/.local/share/akonadi/db_data This creates a database called 'mysql' in the Akonadi database. I described this issue here: http://lxer.com/module/newswire/view/144863/
nothing we can do here, try reporting upstream