Bug #2872 Post install procedure (mysql_install_db) error
Submitted: 18 Feb 2004 8:41 Modified: 11 Oct 2004 10:49
Reporter: Andrea Bernardon Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:4.1.1 OS:Solaris (Solaris 8 SPARC)
Assigned to: Bugs System CPU Architecture:Any

[18 Feb 2004 8:41] Andrea Bernardon
I'm using a MySQL Max 4.1.1 Solaris 8 SPARC release : the postinstall (scripts/mysql_install_db) procedure doesn't complete due to the following error:

Installing all prepared tables
ERROR: 1064  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax
Installation of grant tables failed!

The syntax error is in the support-files/fill_help_tables.sql file.

How to repeat:
Follow the installation guide in the Mysql Manual

Suggested fix:
Check the support-files/fill_help_tables.sql file.
[16 Mar 2004 13:10] Timothy Smith
I downloaded mysql-max-4.1.1-alpha-sun-solaris2.8-sparc-64bit.tar.gz, then:

$ gzip -cd mysql-max-* | tar xf -
$ cd mysql-max-*
$ ./scripts/mysql_install_db --datadir=$PWD/data

It did install the tables without error.
[2 Apr 2004 10:31] Timothy Smith
I got this info from our developer.

I reproduced this bug yesterday on our sunfire280 and later on my Linux
box. Sun was mysql-max-4.1.1-alpha-sun-solaris2.9-sparc binary.
The bug sits in the 10th line of fill_help_tables.sql.  vva is
working on that problem.
[4 Apr 2004 11:26] Victor Vagin
Actually the reason of bug was in cutting the lines in fill_help_tables.sql 
by length of net_buffer_length=2K

to fix the bug I offer next changes:

1. for producing more informative messages on stage of using fill_help_tables.sql in mysql_install_db

subj: bk commit - 4.1 tree (vva:1.1766) BUG#2872
  1.1766 04/04/05 02:06:33 vva@eagle.mysql.r18.ru +2 -0
  provide more correct error messages when used fill_help_tables.sql
  (changed bootstrap handling and mysql_install_db.sh)
  as part of fix for 
  bug #2872 "Post install procedure (mysql_install_db) error"

2. for catching too long lines on stage of generating fill_help_tables.sql

subj: bk commit - 4.1 tree (vva:1.1764) BUG#2874
  1.1764 04/04/04 01:38:09 vva@eagle.mysql.r18.ru +1 -0
  added extra error messages to scripts/fill_help_tables.sh
  for checking maximum length of line in output
  (as part of fix for 
   BUG #2874 "Post install procedure (mysql_install_db) error")

3. for avoiding too long help topics in manual

subj: bk commit - mysqldoc tree (vva:1.1427)
  1.1427 04/04/04 22:43:37 vva@eagle.mysql.r18.ru +1 -0
  repair some extra tags to produce correct help tables
  (made topics shorter and without unnecessary parts)
[29 Apr 2004 18:32] Michael Widenius
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at

Additional info:

As Victor was not around, I took his patches and have now pushed them into the 4.1 source tree for inclusion in 4.1.2

[30 Sep 2004 4:34] Luis Bernardo
From the Progress Log discussion is seems that this issue was fixed. However I am having the same problem with version 5.0.0-alpha on a Fedora Core 2. Could it be that this is not part of the release code yet?
[11 Oct 2004 10:49] Sergei Golubchik
It is part of the release code.

But according to http://dev.mysql.com/doc/mysql/en/index.html
5.0.0-alpha was released on 22 Dec 2003.

Pcik any version released after the day when the bug was fixed.