MySQL Bugs: #2872: Post install procedure (mysql_install

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:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	4.1.1	OS:	Solaris (Solaris 8 SPARC)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
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.

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.

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.

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
ChangeSet
  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
ChangeSet
  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)
ChangeSet
  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)

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
    http://www.mysql.com/doc/en/Installing_source_tree.html

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

Regards,
Monty

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?

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.