Bug #97365 Server does not start after changing max_allowed_packet parameter
Submitted: 24 Oct 2019 15:25 Modified: 24 Oct 2019 17:05
Reporter: Rajneesh Gupta Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:8.0.18 OS:Windows (10)
Assigned to: CPU Architecture:x86

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[24 Oct 2019 15:42] Rajneesh Gupta
the conf file with the change in place

Attachment: my.ini (application/octet-stream, text), 17.02 KiB.

[24 Oct 2019 16:44] Miguel Solorzano
Server start

Attachment: 97365.png (image/png, text), 88.42 KiB.

[24 Oct 2019 16:51] Miguel Solorzano
New  max_allowed_packet value

Attachment: 97365_1.png (image/png, text), 75.73 KiB.

[24 Oct 2019 16:52] Miguel Solorzano
New  max_allowed_packet value

Attachment: 97365_1.png (image/png, text), 75.73 KiB.

[24 Oct 2019 17:04] Rajneesh Gupta
server start - attempting shutdown

Attachment: mysqld.png (image/png, text), 38.70 KiB.

[24 Oct 2019 17:10] Rajneesh Gupta
After new install

Attachment: mysqld.png (image/png, text), 73.18 KiB.