Share via

ERROR 2013: Lost connection to MySQL server during query

Srikar Gondesi - UAS Database Administrator 85 Reputation points
2024-02-05T12:56:46.8733333+00:00

I am able to run select and create statements. but facing below error only when I try to run an ALTER command. increased connection timeout values, no luck.

Operation failed: There was an error while applying the SQL script to the database.
ERROR 2013: Lost connection to MySQL server during query
SQL Statement:
ALTER TABLE `uas-tms`.`countries` 
ADD COLUMN `isAPISEnabled` TINYINT(1) NULL DEFAULT 0 AFTER `COVIDTesting`
Azure Database for MySQL
Answer accepted by question author
  1. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2024-02-06T21:08:11.28+00:00

    @Srikar Gondesi - UAS Database Administrator
    Could you please perform the below actions to see if that will resolve the issue. Please increase the value of net_write_timeout from server parameters in the Azure Portal and, from Workbench side. User's image Is your current resource configured with 2 Vcore GP.? If yes, could you please try increasing to a higher vcore. Regards, Oury

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.