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
• Status: Not a Bug
• 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.