Bug #19905 Mysqld can't create pid-file if computer name is reserved word (like COM4)

Submitted: 18 May 2006 9:59 Modified: 2 Nov 2006 16:11
Reporter: Michael Livach Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:suggest 4.1.16/5.0/5.1 OS:Windows (Windows XP)
Assigned to: Iggy Galarza CPU Architecture:Any

[18 May 2006 9:59] Michael Livach
Description:
It seems similar to bugs:
http://bugs.mysql.com/bug.php?id=9147
http://bugs.mysql.com/bug.php?id=9148

The source the problem that Windows allow to name computer by reserved word and a name (without extension) of pid-file equal to computer name.

I suggest that another versions of Windows have this problem too.

How to repeat:
1) Rename computer to COM4
2) Restart (if it needs)
3) Try to run MySQL Server (from command line. I use only this way)
[18 May 2006 12:22] MySQL Verification Team
Thank you for the bug report.

Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

c:\mysql\bin>mysqld-nt --standalone --console
060517  9:10:40  InnoDB: Started; log sequence number 0 30213690
060517  9:10:40 [ERROR] mysqld-nt: Can't create/write to file 'c:\mysql\data\COM4.pid' (Errcode: 2)
Can't start server: can't create PID file: No such file or directory
[2 Nov 2006 16:11] Iggy Galarza
Windows will not allows a file beginning with a reserved word to be created. For example:

C:\>echo "Test" > test.txt

C:\>type test.txt
"Test"

C:\>echo "Test" > com4.txt
The system cannot find the file specified.

C:\>echo "Test" > lpt1.txt
The system cannot find the file specified.

An alternative pid-file can be specified by starting the server with the --pid-file= command line option (http://dev.mysql.com/doc/refman/4.1/en/server-options.html) and should be used in this case.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.