Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Cannot clone WordPress app, get error: "Addons Error: Error restoring mysql: read ECONNRESET"

    WordPress (Developer)
    3
    31
    487
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      arungurume last edited by

      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:Screen Shot 2021-03-24 at 6.03.39 PM.png

      Please note this is not due to mysql memory as I have enough memory in mysql.

      Here is mysql log too
      Screen Shot 2021-03-24 at 6.02.23 PM.png
      Screen Shot 2021-03-24 at 5.53.48 PM.png

      Please let me know what could be the reason!? How can I overcome this issue. Appreciate the help.

      girish 1 Reply Last reply Reply Quote 0
      • girish
        girish Staff @arungurume last edited by girish

        @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.

        A 1 Reply Last reply Reply Quote 1
        • A
          arungurume @girish last edited by

          @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.

          A 1 Reply Last reply Reply Quote 0
          • A
            arungurume @arungurume last edited by

            It cloned but then when I open the site it shows Screen Shot 2021-03-24 at 8.01.26 PM.png

            A 1 Reply Last reply Reply Quote 0
            • A
              arungurume @arungurume last edited by

              Here is the log !

              Screen Shot 2021-03-24 at 8.04.51 PM.png

              girish 1 Reply Last reply Reply Quote 0
              • girish
                girish Staff @arungurume last edited by

                @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
                A 2 Replies Last reply Reply Quote 0
                • A
                  arungurume @girish last edited by

                  @girish https://paste.cloudron.io/zuwejomixe.rb

                  1 Reply Last reply Reply Quote 0
                  • A
                    arungurume @girish last edited by

                    @girish now the main site also went down https://paste.cloudron.io/hefelekane.makefile

                    girish 1 Reply Last reply Reply Quote 0
                    • girish
                      girish Staff @arungurume last edited by

                      @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?

                      A 3 Replies Last reply Reply Quote 0
                      • A
                        arungurume @girish last edited by

                        @girish Screen Shot 2021-03-25 at 12.28.28 PM.png

                        1 Reply Last reply Reply Quote 0
                        • A
                          arungurume @girish last edited by

                          @girish also updated the cloudron now Screen Shot 2021-03-25 at 1.42.32 PM.png

                          1 Reply Last reply Reply Quote 0
                          • A
                            arungurume @girish last edited by

                            @girish https://paste.cloudron.io/ulurobazec.rb

                            girish 2 Replies Last reply Reply Quote 0
                            • girish
                              girish Staff @arungurume last edited by girish

                              @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.

                              A 1 Reply Last reply Reply Quote 0
                              • girish
                                girish Staff @arungurume last edited by

                                @arungurume If this site ran outside Cloudron, do you remember if you had to put in any memory limits or special apache configuration ?

                                A 1 Reply Last reply Reply Quote 0
                                • A
                                  arungurume @girish last edited by

                                  @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.

                                  1 Reply Last reply Reply Quote 0
                                  • A
                                    arungurume @girish last edited by

                                    @girish
                                    Thu, Mar 11, 1:17 PM ET you were helping me with the same issue.

                                    girish 1 Reply Last reply Reply Quote 0
                                    • girish
                                      girish Staff @arungurume last edited by

                                      @arungurume I have narrowed the issue down to one of the plugins. There's a lot of them so have to bisect

                                      A 3 Replies Last reply Reply Quote 0
                                      • A
                                        arungurume @girish last edited by

                                        @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

                                        1 Reply Last reply Reply Quote 0
                                        • A
                                          arungurume @girish last edited by

                                          @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.

                                          1 Reply Last reply Reply Quote 0
                                          • A
                                            arungurume @girish last edited by

                                            @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

                                            girish 2 Replies Last reply Reply Quote 0
                                            • girish
                                              girish Staff @arungurume last edited by

                                              @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 😕

                                              1 Reply Last reply Reply Quote 0
                                              • girish
                                                girish Staff @arungurume last edited by

                                                @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?

                                                A 3 Replies Last reply Reply Quote 0
                                                • A
                                                  arungurume @girish last edited by

                                                  @girish I recently updated the latest version of woocommerce and cloudron also to the latest version.

                                                  1 Reply Last reply Reply Quote 0
                                                  • A
                                                    arungurume @girish last edited by

                                                    @girish yes the webiste was developed completely from Cloudon platform. The woocommerce version is 5.1.0.

                                                    1 Reply Last reply Reply Quote 0
                                                    • A
                                                      arungurume @girish last edited by

                                                      Restoring one by one plugin, products and the files to m.allgrocery.ca.

                                                      1 Reply Last reply Reply Quote 0
                                                      • nebulon
                                                        nebulon Staff last edited by

                                                        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?

                                                        A 1 Reply Last reply Reply Quote 0
                                                        • A
                                                          arungurume @nebulon last edited by

                                                          @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.

                                                          A 1 Reply Last reply Reply Quote 0
                                                          • A
                                                            arungurume @arungurume last edited by

                                                            @arungurume after restoring the right version you can remove the option for the third app. It would be really helpful.

                                                            nebulon 1 Reply Last reply Reply Quote 0
                                                            • nebulon
                                                              nebulon Staff @arungurume last edited by

                                                              @arungurume I've put your Cloudron temporarily in a free license so you can better debug this.

                                                              A 1 Reply Last reply Reply Quote 0
                                                              • A
                                                                arungurume @nebulon last edited by

                                                                @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.

                                                                girish 1 Reply Last reply Reply Quote 0
                                                                • girish
                                                                  girish Staff @arungurume last edited by

                                                                  @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).

                                                                  1 Reply Last reply Reply Quote 0
                                                                  • First post
                                                                    Last post
                                                                  Powered by NodeBB