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
  • 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 | Demo | Docs | Install
  1. Cloudron Forum
  2. WordPress (Managed)
  3. Wordpress failing to boot on DB upgrades

Wordpress failing to boot on DB upgrades

Scheduled Pinned Locked Moved Solved WordPress (Managed)
10 Posts 4 Posters 1.7k 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.
  • A Offline
    A Offline
    adrw
    wrote on last edited by
    #1

    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?

    girishG 1 Reply Last reply
    0
    • A adrw

      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?

      girishG Offline
      girishG Offline
      girish
      Staff
      wrote on last edited by
      #2

      @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
      0
      • girishG girish

        @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 Offline
        A Offline
        adrw
        wrote on last edited by
        #3

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

        girishG 1 Reply Last reply
        0
        • A adrw

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

          girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #4

          @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
          0
          • girishG girish

            @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 Offline
            A Offline
            adrw
            wrote on last edited by
            #5

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

            1 Reply Last reply
            0
            • girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #6

              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.

              mdreiraM 1 Reply Last reply
              0
              • girishG girish

                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.

                mdreiraM Offline
                mdreiraM Offline
                mdreira
                translator
                wrote on last edited by
                #7

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

                girishG d19dotcaD 2 Replies Last reply
                0
                • mdreiraM mdreira

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

                  girishG Offline
                  girishG Offline
                  girish
                  Staff
                  wrote on last edited by
                  #8

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

                  mdreiraM 1 Reply Last reply
                  0
                  • girishG girish

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

                    mdreiraM Offline
                    mdreiraM Offline
                    mdreira
                    translator
                    wrote on last edited by
                    #9

                    @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
                    0
                    • mdreiraM mdreira

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

                      d19dotcaD Offline
                      d19dotcaD Offline
                      d19dotca
                      wrote on last edited by
                      #10

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