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. Support
  3. MySQL Unresponsive!

MySQL Unresponsive!

Scheduled Pinned Locked Moved Solved Support
mysql
8 Posts 2 Posters 1.5k Views 2 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.
    • ? Offline
      ? Offline
      A Former User
      wrote on last edited by girish
      #1

      32474338-d9ef-42b2-a766-24e870d76c78-image.png

      This appeared to happen after a restart. SSHing in and restarting both mysql and box don't seem to help. I restarted the machine as well, no luck 😧

      I leave for my honeymoon (2 weeks) tomorrow and was made aware of this issue just now.

      I've been a bit of a bother with support lately but am hoping @staff can save the day. Thanks in advance guys! (also SSH access is up and I sent in a ticket)

      1 Reply Last reply
      0
      • ? Offline
        ? Offline
        A Former User
        wrote on last edited by
        #2

        My guess is its corrupted. Not entirely sure how this would have happened but I can try a fresh install of cloudron and restoring. I also just tried the steps from the troubleshooting guide in the docs and its seemingly still an issue. At a loss and in a panic !_!

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

          The exact error seems to be :

          2021-09-30T21:51:49.217687Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 12
          2021-09-30T21:51:49.222399Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
          2021-09-30T21:51:49.608795Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for reading partial data failed.
          2021-09-30T21:51:49.608911Z 1 [ERROR] [MY-012642] [InnoDB] Tried to read 1024 bytes at offset 0, but was only able to read 0
          2021-09-30T21:51:49.608981Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 5 in a file operation.
          2021-09-30T21:51:49.609050Z 1 [ERROR] [MY-012596] [InnoDB] Error number 5 means 'Input/output error'
          2021-09-30T21:51:49.609185Z 1 [ERROR] [MY-012646] [InnoDB] File cache_messages.ibd: 'read' returned OS error 105. Cannot continue operation
          2021-09-30T21:51:49.609259Z 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
          
          
          1 Reply Last reply
          0
          • ? Offline
            ? Offline
            A Former User
            wrote on last edited by
            #4

            Oh my... I interpret that as part of the DB is definitely corrupted. I also noticed some weird permissions issues trying to initialize the db while following the Recover MySQL guide. I just ended up backtracking the steps I did take to get back to where I was originally

            girishG 1 Reply Last reply
            0
            • ? A Former User

              Oh my... I interpret that as part of the DB is definitely corrupted. I also noticed some weird permissions issues trying to initialize the db while following the Recover MySQL guide. I just ended up backtracking the steps I did take to get back to where I was originally

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

              @atridad indeed, it seems two of the databases/apps are corrupt. I just restored them from a backup and they are running again now. Can you please check?

              ? 1 Reply Last reply
              0
              • girishG girish

                @atridad indeed, it seems two of the databases/apps are corrupt. I just restored them from a backup and they are running again now. Can you please check?

                ? Offline
                ? Offline
                A Former User
                wrote on last edited by
                #6

                @girish I just sent this via email but its worth having here if anyone else runs into this. They both seem to work now, thank you!

                As for the addon, how did you end up getting that going?

                Also, would you suggest I test a reboot to see how things come back up or would you advise against tempting fate this way?

                1 Reply Last reply
                0
                • ? Offline
                  ? Offline
                  A Former User
                  wrote on last edited by
                  #7

                  Update: a restart worked just fine without issues. I'm going to make sure I start a backup now

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

                    I put some docs on how to fix the mysql addon here - https://docs.cloudron.io/troubleshooting/#mysql-addon . It's not "complete" but it's very hard to write those docs since there's a lot of things that can go wrong with mysql....

                    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