ERROR 2013: Lost connection to MySQL server during query

Srikar Gondesi - UAS Database Administrator 85

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`

Oury Ba-MSFT 16,736 Reputation points Microsoft Employee

2024-02-06T01:12:58.7+00:00

@Srikar Gondesi - UAS Database Administrator
Thank you for reaching out. Are you running the query on MySQL Workbench.? Is if an Azure MYSQL database.? Regards, Oury
Srikar Gondesi - UAS Database Administrator 85 Reputation points

2024-02-06T04:45:57.4233333+00:00

@Oury Ba-MSFT
Yes, I am using MySQL Workbench to connect to Azure database for MySQL Flexible server.
Oury Ba-MSFT 16,736 Reputation points Microsoft Employee

2024-02-07T17:28:17.79+00:00

@Srikar Gondesi - UAS Database Administrator Any updates on this?
Oury Ba-MSFT 16,736 Reputation points Microsoft Employee

2024-02-08T20:01:41.5733333+00:00

@Srikar Gondesi - UAS Database Administrator Checking on the status of the issue. Have you come up with a solution. Please let me know. Regards, Oury
Srikar Gondesi - UAS Database Administrator 85 Reputation points

2024-02-09T04:42:21.9166667+00:00

@Oury Ba-MSFT apologies for the delay in response and thank you for your patience.
Same ALTER operation worked fine when I did on a different database.
Later, I increased the pricing tier of flexible server. Now I am not facing this issue on any database.

I made a note of your suggestion, I will use it in my when I face this issue again.

Thanks a lot for your time and help. cheers!

Accepted answer

Oury Ba-MSFT 16,736 Reputation points Microsoft Employee

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. Is your current resource configured with 2 Vcore GP.? If yes, could you please try increasing to a higher vcore. Regards, Oury
Please sign in to rate this answer.
Oury Ba-MSFT 16,736 Reputation points Microsoft Employee

2024-02-12T17:25:27.35+00:00

Srikar Gondesi - UAS Database Administrator Thank you for your appreciation! Please don't forget to mark as accept answer rif the reply was helpful. Regards, Oury
Sign in to comment

Share via

ERROR 2013: Lost connection to MySQL server during query

0 additional answers