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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps - Status | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. SQL error

SQL error

Scheduled Pinned Locked Moved Unsolved Support
ubuntu 20.04mysql
13 Posts 4 Posters 335 Views 4 Watching
  • 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.
  • jamesJ Offline
    jamesJ Offline
    james
    Staff
    wrote last edited by
    #3

    Hello @jcalag

    Please ssh into your server and run cloudron-support --troubleshoot and post the output here.

    1 Reply Last reply
    1
    • J Offline
      J Offline
      jcalag
      wrote last edited by
      #4

      @james sorry of the late response I tried it, and it shows these data

      root@CloudronMain:~# cloudron-support --troubleshoot
      [OK] node version is correct
      [OK] docker is running
      [OK] MySQL is running
      [OK] nginx is running
      [OK] box is running
      [OK] unbound is running
      [OK] Dashboard is reachable via domain name
      [OK] Domain elevatecalls.io is valid and has not expired
      root@CloudronMain:~#

      1 Reply Last reply
      0
      • J Offline
        J Offline
        joseph
        Staff
        wrote last edited by
        #5

        Usually, that error happens when docker became corrupt (for example, server ran out of disk space). Is that a possibility in your case? This is quite an old version of Cloudron. The recent versions of cloudron-support have --recreate-docker but I don't think it's there ins Cloudron 7 . If you write to support@cloudron.io , I can look into it.

        J 1 Reply Last reply
        1
        • J joseph

          Usually, that error happens when docker became corrupt (for example, server ran out of disk space). Is that a possibility in your case? This is quite an old version of Cloudron. The recent versions of cloudron-support have --recreate-docker but I don't think it's there ins Cloudron 7 . If you write to support@cloudron.io , I can look into it.

          J Offline
          J Offline
          jcalag
          wrote last edited by
          #6

          @joseph said in SQL error:

          support@cloudron.io

          I sent an email on support@cloudron.io please check

          1 Reply Last reply
          0
          • J Offline
            J Offline
            joseph
            Staff
            wrote last edited by
            #7

            @jcalag I think I have replied to your email.

            1 Reply Last reply
            0
            • J Offline
              J Offline
              jcalag
              wrote last edited by
              #8

              @joseph

              I’d like to inform everyone that our current backup takes approximately 3 hours and 45 minutes to complete.

              In the event that the server goes down, the full restoration process could take 8–9 hours or possibly longer, depending on the situation.

              With this in mind, I would like to ask for your recommendation on how we should proceed. Would it be better to schedule this activity over the weekend to minimize disruption to our employees and clients in case a restore is required?

              If we are confident that this will not cause any issues or downtime, we can proceed today.

              Please advise on the best course of action.

              1 Reply Last reply
              1
              • J Offline
                J Offline
                jcalag
                wrote last edited by
                #9

                also just to add, the last time this cloudron was updated was on july 2024

                1 Reply Last reply
                1
                • jamesJ Offline
                  jamesJ Offline
                  james
                  Staff
                  wrote last edited by
                  #10

                  Hello @jcalag
                  Is this still an issue?
                  Depending on your hosting provider you might be able to create a server snapshot as an alternative backup method for a fast restoration if something goes wrong.

                  J 2 Replies Last reply
                  0
                  • jamesJ james

                    Hello @jcalag
                    Is this still an issue?
                    Depending on your hosting provider you might be able to create a server snapshot as an alternative backup method for a fast restoration if something goes wrong.

                    J Offline
                    J Offline
                    jcalag
                    wrote last edited by
                    #11

                    @james Yeah, for now we can only do it in weekend because if we fcked up restoration it's gonna take around 17 hours like last time,

                    Also maybe you got something we can test or any article we can try to use in the weekend that would be helpful;

                    Last time we tried updating ubuntu to 22 but these are the error's

                    "When we update the ubuntu to 22 it shows these error and we tried to update it to 24 to see if it might fix but it still shows the same error."

                    Errors were encountered while processing:
                    nginx-core
                    nginx-common

                    [OK] node version is correct
                    Docker is down. Trying to restart docker ...
                    [OK] docker is running
                    [OK] MySQL is running
                    [OK] nginx is running
                    [FAIL] Could not load dashboard website with loopback check

                    1 Reply Last reply
                    0
                    • jamesJ james

                      Hello @jcalag
                      Is this still an issue?
                      Depending on your hosting provider you might be able to create a server snapshot as an alternative backup method for a fast restoration if something goes wrong.

                      J Offline
                      J Offline
                      jcalag
                      wrote last edited by
                      #12

                      @james maybe you got something that could help us in the weekend sorry I can't give much details because we already restored it.

                      1 Reply Last reply
                      0
                      • jamesJ Offline
                        jamesJ Offline
                        james
                        Staff
                        wrote last edited by
                        #13

                        Hello @jcalag
                        If you have an active cloudron subscription you can contact support@cloudron.io.
                        When you have a restored state, which is failing on cloudron-support --troubleshoot that is where you should send the mail so we can have a look.

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • Bookmarks
                        • Search