Summary: | app-office/akonadi-server: MySQL server log contains warnings | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Dennis Schridde <dschridde+gentoobugs> |
Component: | [OLD] KDE | Assignee: | Gentoo KDE team <kde> |
Status: | RESOLVED CANTFIX | ||
Severity: | minor | CC: | gentoo, tomas |
Priority: | High | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Dennis Schridde
2010-04-07 07:05:59 UTC
(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 |