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 Apps using MySQL are not working

    Support
    2
    3
    628
    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.
    • girish
      girish Staff last edited by

      The mysql addon fails to start sometimes and this results in mysql based apps not working.

      First check the status of the mysql addon using docker logs -f mysql. If it says Waiting for MySQL to come up, then that is the root the problem.

      docker exec -ti mysql /bin/bash
      root@f483661487a5:/# mysqld --datadir="${MYSQL_DATA_DIR}" --user=mysql
      mysqld: error while loading shared libraries: libaio.so.1: cannot stat shared object: Permission denied
      

      This appears to be something related to docker. There are some existing bug reports/pages for this:

      • https://stackoverflow.com/questions/22473830/docker-and-mysql-libz-so-1-cannot-open-shared-object-file-permission-denied
      • https://github.com/moby/moby/issues/7512
      • https://github.com/moby/moby/issues/5430

      Not sure what caused the problem but simply recreating the addon infrastructure fixed it (this essentially recreates the docker containers). This can done by:

      • Bump up the patch version in /home/yellowtent/platformdata/INFRA_VERSION. This has to be done very carefully. Please do not do this without a complete backup.
      • systemctl restart cloudron.target
      1 Reply Last reply Reply Quote 1
      • M-arcus
        M-arcus last edited by

        Is this affecting new docker builds (cloudron build )?

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

          In another server instance hit by https://forum.cloudron.io/topic/1382/error-for-multiple-apps/12, recreating docker containers did not help. I even disabled apparmor altogether using sudo systemctl stop apparmor and sudo systemctl disable apparmor. We tried server restart as well and that didn't help either.

          After disabling apparmor, I saw that mysqld would just quit without showing any error message or log output 😞 As a final thing, I just ended up moving platformdata/mysql to mysql-old and recreated containers again. That made mysql come up and then we restored all the apps.

          Still a bit crazy/worrying that we hit this bug atleast twice now and there is no clear resolution.

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