Bug 491176 – =dev-db/mysql-5.5.32 - emerge --config: ERROR 1062 (23000) at line 320485: Duplicate entry 'posix/posix/posix/posix/posix/posix/posix/America/Argentina/San_' for key 'PRIMARY'

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Martin Mokrejš 2013-11-13 16:00:45 UTC]

# emerge --config =dev-db/mysql-5.5.32

Configuring pkg...

 * Command: '/usr/share/mysql/scripts/mysql_install_db' '--basedir=/usr' --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-innodb --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Starting mysqld ...
 * Command //usr/sbin/mysqld            --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-innodb --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql           --user=mysql          --log-warnings=0                 --basedir=//usr                 --datadir=///var/lib/mysql              --max_allowed_packet=8M                 --net_buffer_length=16K                 --default-storage-engine=MyISAM                --socket=//var/run/mysqld/mysqld1136.sock               --pid-file=//var/run/mysqld/mysqld3927.pid                                                               [ ok ]
 * Setting root password ...                                                                                                                                                                    [ ok ]
 * Loading "zoneinfo", this step may require a few seconds ... ...
ERROR 1062 (23000) at line 320485: Duplicate entry 'posix/posix/posix/posix/posix/posix/posix/America/Argentina/San_' for key 'PRIMARY'                                                         [ ok ]
 * Failed to load zoneinfo!
 * Stopping the server ...
 * Done

[Comment 1 Kobboi 2014-04-06 21:41:55 UTC]

Same here

[Comment 2 Brian Evans (RETIRED) 2014-04-10 15:36:51 UTC]

Patch added to mysql extras (backported from mariadb).
Overlay ebuilds should utilize it.
The next round to portage should as well

[Comment 3 Jorge Manuel B. S. Vicetto (RETIRED) 2014-04-25 00:45:00 UTC]

Closing now that the work in the overlay was pushed into the tree.