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 328 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.
  • robiR Offline
    robiR Offline
    robi
    wrote last edited by
    #2

    You might need some updates, friend.

    Conscious tech

    1 Reply Last reply
    2
    • 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