This article provides a solution for when the database upload loses connection to MySQL.
AFFECTED VERSIONS AND PRODUCTS
Magento Commerce Cloud 2.2.x., 2.3.x
The database does not upload to primary/integration branches on Pro, or any branch on Starter with the symptom being the inability to connect. You see this error in the CLI.
web@ddc35c264bd89a72042f1f3e5a:~$ mysql -h database.internal -u user -p main Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "Internal error/check (Not system error)"
This is usually due to a lack of disk space for importing the database.
First, check if there is a lack of disk space. To do so run the
netcat command in the CLI against the database port 3306, there will be a disk full message if it is full:
web@ddc35c264bd89a72042f1f3e5a:~$ nc database.internal 3306
Database out of space
You will need to allocate more space for the database in your
services.yaml and deploy, if you have some space unused. For steps see Service Disk Space.
Note: On the Pro plan, you can check the allocated space on your partition by running the following command:
Expect output similar to the following output. In this example, 10GB of the 25GB allocated is used, with 15GB of MySQL space not being used.
f240jestone3wt@i-087r2a25fdac80726:~$ df -h|grep 'File\|xvd'
Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 59G 15G 42G 26% /
/dev/xvdj 25G 10G 15G 41% /data/mysql
/dev/xvdi 25G 22G 2.6G 90% /data/exports
DevDocs Manage Disk Space