Bug #3938 Help files are not installed if my.cnf presents
Submitted: 31 May 2004 7:14 Modified: 25 Jun 2004 17:42
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.2 OS:Linux (Linux)
Assigned to: Michael Widenius CPU Architecture:Any

[31 May 2004 7:14] Peter Zaitsev
Description:
I've installed MySQL server 4.1.2 (RPM package) on SuSE 9.0 and Install Did not work well enough:

  3:MySQL-server           ########################################### [100%]
040530 22:12:17  Warning: Asked for 196608 thread stack, but got 126976
040530 22:12:18  Warning: Asked for 196608 thread stack, but got 126976
ERROR: 1153  Got a packet bigger than 'max_allowed_packet'
040530 22:12:18  Aborting

040530 22:12:18  /usr/sbin/mysqld: Shutdown Complete

WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h shrek password 'new-password'
See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

How to repeat:
As you might see Help files are not installed due to:

ERROR: 1153  Got a packet bigger than 'max_allowed_packet' error

I've removed /etc/my.cnf which was shipped with default SuSE version of MySQL
and everything worked just fine.

The strange thing is that my.cnf also has max_allowed_packet set to  1MB

Also note thread stack warnings, they came even though I was running under root.
[23 Jun 2004 16:23] 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
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

I have now fixed that mysql_install_db overrides any max_allowed_packet in any include file. Hopefull this fixes this problem

Fix will be in 4.1.3

Regards,
Monty