Bug #33192 mysql_install_db bad merge, corrupt code == appears to succeed but does nothing
Submitted: 13 Dec 2007 1:22 Modified: 4 Feb 2008 13:34
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S1 (Critical)
Version:5.1.23-bk, 6.0.5-bk OS:Any
Assigned to: Timothy Smith CPU Architecture:Any
Tags: mysql_install_db

[13 Dec 2007 1:22] Timothy Smith 
Description:
This bug is in unreleased code.

A recent merge of changes in mysql_install_db.sh resulted in a corrupted program.  At least one variable assignment was lost, and a few lines were not correctly updated.

The resulting symptom is that mysql_install_db appears to work correctly, but in fact does not install the databases.

How to repeat:
Build MySQL 5.1 from a recent BK, e.g. using BUILD/compile-pentium-debug.  Install it.  cd to the install directory, then:

mkdir data
./bin/mysql_install_db --no-defaults --datadir=$PWD/data
find data -type f -print

There are no actual files in the data directory.

Suggested fix:
Plan is to manually redo the bad merge.  Start from a copy of the pre-merge file, and manually apply the other patches.  Since this is a fairly recent problem, there are only a few patches that need this.  This should ensure that no changes are lost.
[13 Dec 2007 2:15] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/39849

ChangeSet@1.2639, 2007-12-12 19:14:28-07:00, tsmith@ramayana.hindu.god +1 -0
  Bug #33192: mysql_install_db bad merge, corrupt code == appears to succeed but does nothing
  
  Repair a bad merge that made mysql_install_db silently fail, doing nothing.
[13 Dec 2007 15:24] Daniel Fischer 
Showstopper, since it's a regression.
[14 Dec 2007 11:32] Timothy Smith 
Queued to 5.1- and 6.0-build.
[18 Dec 2007 11:08] Daniel Fischer 
Bug#33309 was marked as a duplicate of this bug.
[22 Dec 2007 14:26] Bugs System 
Pushed into 6.0.5-alpha
[22 Dec 2007 14:32] Bugs System 
Pushed into 5.1.23-rc
[8 Jan 2008 17:38] Paul DuBois 
Does not appear in any released version.
No changelog entry needed.
[28 Jan 2008 20:20] Sveta Smirnova 
Bug still exists in mysql-6.0-falcon tree
[28 Jan 2008 21:44] Sveta Smirnova 
Patch has not been pushed into mysql-6.0-falcon-team tree as well.
[4 Feb 2008 13:34] Sveta Smirnova 
Re-closed as bug exists in team tree only.
[12 Mar 2008 23:02] Bugs System 
Pushed into 6.0.4-alpha