It’s sound like a MySQL issue, but the MODX instance is installed on a new server and MySQL working well, even during and after Commerce installation.
The server is not overloaded, has free memory etc…
Worse : Commerce looks installed on the Menu Extensions but if I try to use it, it’s obviously tell me some tables are missing on the MODX log :
[2019-02-19 10:56:21] (ERROR in xPDO::getService @ /home/HDA/web/dev.cookooling.com/public_html/core/xpdo/xpdo.class.php : 1234) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2019-02-19 10:56:21] (ERROR in modRestCurlClient::__construct @ /home/HDA/web/dev.mydomain.com/public_html/core/model/modx/rest/modrestcurlclient.class.php : 26) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2019-02-19 10:57:32] (ERROR @ /home/HDA/web/dev.mydomain.com/public_html/core/xpdo/xpdo.class.php : 644) Could not load class: Commerce from commerce.
[2019-02-19 10:57:32] (ERROR @ /home/HDA/web/dev.mydomain.com/public_html/core/xpdo/xpdo.class.php : 1247) Problem getting service commerce, instance of class Commerce, from path /home/HDA/web/dev.mydomain.com/public_html/core/components/commerce/model/commerce/
[2019-02-19 10:59:33] (ERROR @ /home/HDA/web/dev.mydomain.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error HY000 executing statement:
[2019-02-19 12:26:21] (ERROR @ /home/HDA/web/dev.mydomain.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S02 executing statement:
Array
(
[0] => 42S02
[1] => 1146
[2] => Table 'HDA_domain.modx_commerce_tax_group' doesn't exist
)
Okay so that does look like it’s losing connection with the database after handling the files:
Could not create table `modx_commerce_address` SQL: CREATE TABLE ... ERROR: Array (
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away )
This has happened before to someone else, and as a result of that I changed the order in which our package is installed in 0.12. Can you try installing v0.12 by opting-in to the pre-release that’s currently available? That should work better for you.
You’re going to need to install updates in the future too, so this is not a problem that can be worked around like that.
The last time something like this happened, the problem was that the file unpacking/preserving took longer than the mysql query/idle timeout. That was fixed with 0.12 by changing the order in which certain things happen in the package. Basically, that made it a little faster.
This error suggests some issue communicating with the MySQL server after which the connection is dropped:
PHP warning: Error while sending QUERY packet. PID=2723
The log doesn’t say why though.
Does it consistently have that error? Can you look at mysql logs for that PID?
I still have the error, after several trying.
My server is a VPS so I tryied to boost it with higher resources (RAM, CPU…) but nothing change.
About your last question : the indicated PID is apache, not mysql.
The apache log during the commerce install process is not relevant :
