Cannot clone WordPress app, get error: "Addons Error: Error restoring mysql: read ECONNRESET"
-
I'm trying to clone one my WordPress sites to a production domain so I can make some changes there.
And getting this error "Addons Error: Error restoring mysql: read ECONNRESET"
Here are the relevant logs:
Please note this is not due to mysql memory as I have enough memory in mysql.
Here is mysql log too
Please let me know what could be the reason!? How can I overcome this issue. Appreciate the help.
-
@arungurume this is most likely because of the memory limit . During a restore from backup, mysql usually requires more memory. I would suggest bumping up mysql's memory to 1GB and try again. Note that there is no risk in giving more memory, it only uses more if needed. 1GB is just an upper limit and not a pre-allocation.
-
@girish said in Cannot clone WordPress app, get error: "Addons Error: Error restoring mysql: read ECONNRESET":
is just an upper limit and not a pre-allocation.
OK Girish, let me give a try, But why this was never needed earlier and only now not sure. Anyway, let me give it a try. Thank you.
-
It cloned but then when I open the site it shows
-
Here is the log !
-
@arungurume Do you think you can paste the full logs at https://paste.cloudron.io ? The screenshots seems to show some redis logs.
- Open logs window
- Go to the app page, press refresh
- Then get the recent logs from the logs window
-
-
@girish now the main site also went down https://paste.cloudron.io/hefelekane.makefile
-
@arungurume The logs say "child pid 101 exit signal Segmentation fault (11), possible coredump in /etc/apache2".
If you go to the Updates section of the app, what package version are you using?
-
-
@girish also updated the cloudron now
-
-
@arungurume just looking into this one. Curiously, the site loads after a restart but starts crashes immediately after. Actually, apache crashes with a segfault, never seen that one before. continuing to investigate.
-
@arungurume If this site ran outside Cloudron, do you remember if you had to put in any memory limits or special apache configuration ?
-
@girish said in Cannot clone WordPress app, get error: "Addons Error: Error restoring mysql: read ECONNRESET":
Cloudron, do you remember if you had to put in any memory limits or special apache configuration ?
No, this same issue happened few days (10days) back.
-
@girish
Thu, Mar 11, 1:17 PM ET you were helping me with the same issue. -
@arungurume I have narrowed the issue down to one of the plugins. There's a lot of them so have to bisect
-
@girish oh ok, now how can we bring the site to LIVE? If I know which plugin, we can disable the same. Can you please help to make it LIVE.
Regards
Arun -
@girish Sure please take your time. This time if we can identify the issue to the core then it can be permanently solved and once live will not have the same thing happening again.
-
@girish Can you help me in sharing the dump of my DB. Then I can take it forward from there. You can email the dump to my email ID bytzoinc@gmail.com
-
@arungurume Sure, the db dumps are already on the server at
/home/yellowtent/appsdata/960eac77-c5cb-41d4-a368-56bf4e25828d/mysqldump. I narrowed down the issue to woocommerce plugin. Which is kind of a bummer because that is the essence of the site
-
@arungurume I am out of ideas. I think the best bet is to build the website step by step again to understand what is causing the crash inside woocommerce. Alternately, maybe you can ask if the woocommerce guys know about this. I suspect you will hit the same crash with PHP 7.4 on Ubuntu 20 . May I ask what version this website was developed against? Or was this developed inside Cloudron from the start?
-
@girish I recently updated the latest version of woocommerce and cloudron also to the latest version.
-
@girish yes the webiste was developed completely from Cloudon platform. The woocommerce version is 5.1.0.
-
Restoring one by one plugin, products and the files to m.allgrocery.ca.
-
Since this is from cloning, can you also reproduce this when simply relocating the app to a different subdomain/domain ? I wonder if there the location is somewhat conflicting with db values or config files, causing issue?
-
@nebulon said in Cannot clone WordPress app, get error: "Addons Error: Error restoring mysql: read ECONNRESET":
Since this is from cloning, can you also reproduce this when simply relocating the app to a different subdomain/domain ? I wonder if there the location is somewhat conflicting with db values or config files, causing issue?
no cloning did not work so, I have to install one by one. Would be great if you guys can offer me the option to clone and check, Currently the app m. im using to build from scratch and with the free plan I cannot have more than two apps.
-
@arungurume after restoring the right version you can remove the option for the third app. It would be really helpful.
-
@arungurume I've put your Cloudron temporarily in a free license so you can better debug this.
-
@nebulon Hi Nebulon, it's already a free license in which I'm able to have two apps at a time. Now that because of this issue. I completely recreated the whole site from scratch. But to debug the existing one and clone the option is not there. As free version has already occupied two apps.
-
@arungurume I think what nebulon meant is he put you on a premium plan with no charge until the issue is sorted out (and not the existing free plan).
