MySQL Bugs: #94826: MYSQL community server fails to start leaving nothing in logs

Bug #94826	MYSQL community server fails to start leaving nothing in logs
Submitted:	29 Mar 2019 5:03	Modified:	7 Feb 2020 7:05
Reporter:	Surya Prakash	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S2 (Serious)
Version:	8.0.15	OS:	Windows (10)
Assigned to:		CPU Architecture:	Other (x64)
Tags:	no events, no log, server crash, windows

Description:
The server keeps failing to start. It leaves nothing in logs or windows event viewer. I have not tested on the other OS but similar behavior may be observed.
I was lucky to also find the reason behind it. It was crashing at startup if the location we provided for 'secure-file-priv' in my.ini file is not live. This could happen in case one updates this setting to load data from a portable device that may not be connected all the time.

In either case, this could happen if the provided location is incorrect as well. In case of crash, the server should leave behind something in logs or event viewer.

How to repeat:
1 - Connect a USB or any portable device and update its location for 'secure-file-priv' setting in my.ini file.
2 - Restart the server. It will start failing leaving no clue in logs.

Or one may simply provide an incorrect path in 'secure-file-priv'

Suggested fix:
- Ignore the path, even if it is not correct or live and bring server up anyways.
- Add a trace in logs about the path being non-existent.

How to repeat:
1.a - Remove the USB

[It was missed in the original bug report]

Hello Surya,

Thank you for the report.
Observed issue only on windows(Win7 on my test box) where as on OL observed that with --log-error-verbosity=3 error message was logged to the error log.

thanks,
Umesh

Hi Umesh,

Thank you for taking this up so quickly. Since I discovered the "cure" by chance only, it is no more blocking me :-) But the issue remains a serious one considering it may leave developers on win boxes frustrated with lot of dev time wasted.

I'll follow the issue for when it will be available in a patch. Feel free to let me know if I can be of any help.

Thank you again!

Fixed in 8.0.18 under the heading of

Bug#26336130 DISABLE SECURE FILE PRIV ABORT UNDER VERBOSE HELP