Bug #23504 Mysql_upgrade abends
Submitted: 20 Oct 2006 14:05 Modified: 21 Dec 2006 21:58
Reporter: David Krotil Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S1 (Critical)
Version:5.0.26, 5.0.28 OS:Novell NetWare (NetWare)
Assigned to: Kent Boortz CPU Architecture:Any

[20 Oct 2006 14:05] David Krotil 
Description:
After upgrade from 4.1.x server to 5.0.25 and/or 5.0.26 on NetWare after issuing command mysql_upgrade server abends. I duplicated this issue on five NetWare servers version 6.5 SP5 with all public post patches.

How to repeat:
on NetWare system console type "mysql_upgrade"

Suggested fix:
I don´t know, I´m not developer.
[20 Oct 2006 14:13] David Krotil 
Abend.log to bug 23504

Attachment: ABEND.LOG (application/octet-stream, text), 52.83 KiB.
[22 Oct 2006 12:51] MySQL Verification Team 
Looking at the stack trace, I suspect this is a stack overflow, caused my too small a stacksize when building the binaries.  Will confirm it shortly.
[25 Oct 2006 15:05] MySQL Verification Team 
On my server which is NW65SP4, I see the following message when trying to run mysql_upgrade (but no crash):

Loading module MYSQL_UPGRADE.NLM                                       
SERVER-5.70-1948:   Module name is MYSQL_UP.NLM not MYSQL_UPGRADE.NLM  
  no description                                                       
  Version 1.00   2006 October 3                                        
  MYSQL_UPGRAD does not have any XDC data                              
  Uni-Processor NLM                                                    
Module MYSQL_UPGRADE.NLM load status OK                                
Can't find program 'sys:\mysql\bin\mysqlcheck'                         
Please restart with --basedir=mysql-install-directory

So, this is a bug anyway, since it should look for mysqlcheck.nlm
In fact, it's a reincarnation of bug #20950 for Netware.

As a workaround, please run mysqlcheck and perl mysql_fix_privilege_tables.pl manually.
[1 Dec 2006 22:09] 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/16340

ChangeSet@1.2320, 2006-12-01 23:09:14+01:00, kent@mysql.com +29 -0
  mysql_upgrade.def Makefile.am:
    Added new "mysql_upgrade.def" for Netware (bug#23504)
  *.def:
    Allocate 128K stack for all executables (bug#23504)
[21 Dec 2006 20:53] Kent Boortz 
Change is, or will be in, 5.1.14, 5.0.32 and 4.1.23
[21 Dec 2006 21:58] Paul DuBois 
Noted in 4.1.23, 5.0.32, 5.1.14 changelogs.

The stack size for NetWare binaries was increased
to 128KB to prevent problems caused by insufficient
stack size.
[7 Jun 2007 10:59] 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/28282

ChangeSet@1.2661, 2007-06-07 12:59:31+02:00, joerg@trift2. +27 -0
  netware/*.def  :  Allocate 128K stack for all executables (bug#23504)
[7 Jun 2007 15:12] Joerg Bruehe 
The above changeset is pushed into the 4.1.23 build,
so the stack sizes are increased in this version as well.

The earlier claim about a push to 4.1 was wrong.

Strictly speaking, this bug never was applicable to 4.1, 
because "mysql_upgrade" starts to exist with 5.0 -
but the stack size may be relevant with other tools.
[11 Jun 2007 11:39] Bugs System 
Pushed into 5.1.20-beta
[11 Jun 2007 11:41] Bugs System 
Pushed into 5.0.44
[11 Jun 2007 11:43] Bugs System 
Pushed into 4.1.24