Bug #119027 Error 2013: Lost Connection to MySQL server during query

• Submitted: 17 Sep 20:51
• Modified: 11 Oct 3:23
• Reporter: Ayus Mitra
• Status: Open
• Category: MySQL Server
• Severity: S7 (Test Cases)
• Version: 8.0.43
• OS: Windows (Microsoft Windows 10 Enterprise)
• CPU Architecture: Any
• Tags: WBBugReporter

[17 Sep 20:51] Ayus Mitra

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\48679025\AppData\Roaming\MySQL\Workbench\log\wb.log]

I am running the following code,

`Use employees;
COMMIT;
DELIMITER $$

CREATE TRIGGER before_salaries_insert
BEFORE INSERT ON salaries
FOR EACH ROW
BEGIN
    IF NEW.salary < 0 THEN
       SET NEW.salary = 0;
    END IF;
END$$

DELIMITER ;`

The query looks okay but when I run it, it takes 30 secs and then the error is displayed. I tried changing the timeout limit but nothing changed.

How to repeat:
CREATE TRIGGER before_salaries_insert
BEFORE INSERT ON salaries
FOR EACH ROW
BEGIN
    IF NEW.salary < 0 THEN
       SET NEW.salary = 0;
    END IF;
END$$

DELIMITER ;`

The query looks okay but when I run it, it takes 30 secs and then the error is displayed. I tried changing the timeout limit but nothing changed.

[19 Sep 16:10] MySQL Verification Team

There is not enough data to reproduce this issue.
Can you please too upload the mysql server log files as this might be that your mysql server crashed.