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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

MySQL Unresponsive!

Scheduled Pinned Locked Moved Solved Support
mysql
8 Posts 2 Posters 343 Views
    • 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 Do not disturb
    girishG Do not disturb
    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
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    replied to A Former User 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
  • ? Offline
    ? Offline
    A Former User
    replied to girish 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 Do not disturb
    girishG Do not disturb
    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

  • Login

  • Don't have an account? Register

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