Bug #21537 Error at startup
Submitted: 9 Aug 2006 12:25 Modified: 30 Aug 2006 19:58
Reporter: Ian Meaton Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.24 OS:Novell NetWare (netware 6.5)
Assigned to: Jani Tolonen CPU Architecture:Any

[9 Aug 2006 12:25] Ian Meaton
Description:
sql will not start, error file

060809 13:16:27 [ERROR] Can't find messagefile '\mysql\bin/\mysql\bin/sys:/mysql/share/english/errmsg.sys'
060809 13:16:27 [ERROR] Aborting

Adding the basedir to my.cnf still causes mysql to terminate but it does not give an error message in server.err

server.safe
MySQL Server 5.0.24, for pc-netware (i686)

address          : 0.0.0.0
port             : 3306
daemon           : sys:/mysql/bin/mysqld
base directory   : sys:/mysql
data directory   : vol1:/mysql/data
pid file         : vol1:/mysql/data/H18.pid
error file       : vol1:/mysql/data/H18.err
log file         : vol1:/mysql/data/H18.safe

mysql started    : 09 Aug 2006 12:50:29
mysql stopped    : 09 Aug 2006 12:50:29

How to repeat:
Always happens at launch

Suggested fix:
Possible hard coding error in location files.
[9 Aug 2006 12:39] Shane Bester
I get same errors
[9 Aug 2006 13:41] Shane Bester
Workaround until this is fixed is to set a basedir like this in the sys:\etc\my.cnf file:

[mysqld]
basedir=..\..\mysql
[10 Aug 2006 8:13] Yves Roy
The workaround only works if you think to apply it to the datadir as well, wich supposes that the datadir is on the same volume.
[12 Aug 2006 13:03] Shane Bester
suspect this caused a break:

http://mysql.bkbits.net:8080/mysql-5.0/cset@1.2122.40.1

due to sys:/ not being treated as an absolute path anymore
[16 Aug 2006 10:27] Yves Roy
The workaround is insufficient : when adding "basedir" and "datadir" to ../../mysql, mysql only seems to work. In fact, some operations (like browsing a schema with mySQL Administrator, or trying to backup with mysqldump at the server's console) do not work as expected. Worse, some write operations fail. Shall we wait long for a patch ?
[16 Aug 2006 16:33] 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/10555

ChangeSet@1.2259, 2006-08-16 19:30:46+03:00, jani@ua141d10.elisa.omakaista.fi +1 -0
  Fix for bug#21537, "Error at startup"
  
  These variables must be defined for Netware, or it fails
  to recognize hard paths starting from the device.
[23 Aug 2006 10:08] 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/10751

ChangeSet@1.2236, 2006-08-23 12:08:08+02:00, joerg@trift2. +1 -0
  Fix for bug#21537, "Error at startup"
  
  These variables must be defined for Netware, or it fails
  to recognize hard paths starting from the device.
  
  (Packport of:  2006/08/16 19:30:46+03:00 jani@ua141d10.elisa.omakaista.fi  )
[24 Aug 2006 19:22] Iggy Galarza
Available in 5.1.12