Bug #50305 mysql_install_db "installation of system tables failed" if hostname 'localhost'

• Submitted: 13 Jan 2010 12:52
• Modified: 13 Jan 2010 16:47
• Reporter: Walter Stanish
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.84-r1
• OS: Linux (2.6.30-gentoo-r5 x86_64)
• CPU Architecture: Any
• Tags: mysql_install_db, system tables

[13 Jan 2010 12:52] Walter Stanish

Description:
The mysql_install_db script fails to execute properly, exiting with the error "installation of system tables failed" if the hostname of the machine is 'localhost', due to an attempted insert with duplicate keys.

How to repeat:
# hostname localhost
# mysql_install_db

Suggested fix:
Make mysql_install_db smart enough to avoid duplicate inserts in the case that the system hostname is 'localhost'.

[13 Jan 2010 14:17] Sveta Smirnova

Thank you for the report.

I can not repeat described behavior. Additionally version 5.0.70 is old and many bugs were fixed since. Please try current version 5.0.89 and inform us if problem still exists.

[13 Jan 2010 16:47] Walter Stanish

The latest version available on my distribution (gentoo) is 5.0.84-r1.

I have tested with this version, and verified that the issue is fixed.