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

    Solved Wordpress failing to boot on DB upgrades

    WordPress (Managed)
    4
    10
    343
    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
      adrw last edited by

      Seeing the following error in my logs when trying to boot a long running Wordpress managed app

      One or more database tables are unavailable. The database may need to be repaired.
      

      Anyone seen this before or have ideas on how to fix?

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

        @adrw do you mean it was stopped before and you tried to start it up again? or is this after a server reboot? I have seen that error message before when the some database tables are missing or some plugin was installed which changes the database table prefix. Do you recall installing any plugins recently?

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

          @girish I'd have to check with the main moderator for that site but I don't think any plugins have been updated recently. I noticed the app was broken and have tried restarting the app and it keeps failing with the same DB failure, not sure if it correlates to a recent Cloudron upgrade.

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

            @adrw I see, hard to tell really without inspecting the installation. Can you send us a mail to support@cloudron.io with ssh access and I can look into it. thanks!

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

              @girish I submitted a ticket from my Cloudron dashboard, many thanks!

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

                It seems the options table was not accessible and was failing with "MySQL table is marked as crashed and last (automatic?) repair failed". This got fixed by executing "repair table options;" from the mysql prompt.

                mdreira 1 Reply Last reply Reply Quote 0
                • mdreira
                  mdreira translator @girish last edited by

                  @girish I have deleted images from wordpress with a plugin instead of from media library and I think I have a problem in the database because of this.

                  I have seen here: https://developer.wordpress.org/cli/commands/db/repair/
                  that there is a command to repair database from wp cli.

                  Database is automatically repaired on app restart? If not, what would be the complete command to repair the database from the app's terminal with wp cli?

                  Thanks a lot.

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

                    @mdreira database is not automatically repaired on restart, no. I am not 100% sure that is safe to run all the time.

                    mdreira 1 Reply Last reply Reply Quote 0
                    • mdreira
                      mdreira translator @girish last edited by

                      @girish Thank you.

                      Then, what would be the complete command to repair the database from the app terminal with wp cli?

                      1 Reply Last reply Reply Quote 0
                      • d19dotca
                        d19dotca @mdreira last edited by

                        @mdreira said in Wordpress failing to boot on DB upgrades:

                        what would be the complete command to repair the database from the app's terminal with wp cli

                        The command would just be simply wp db repair according to the WP CLI documentation. For reference, the actual impact of that statement is documented in MySQL's documentation directly.

                        --
                        Dustin Dauncey
                        www.d19.ca

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