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. New install mysql problem

New install mysql problem

Scheduled Pinned Locked Moved Solved Support
9 Posts 3 Posters 1.5k Views 3 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.
  • C Offline
    C Offline
    cooljack
    wrote on last edited by
    #1

    i get the errors:
    startMysql (stderr): null
    2023-08-08T10:11:37.370Z box:services Waiting for mysql
    2023-08-08T10:11:37.384Z box:services Attempt 1 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000

    2023-08-08T10:11:52.389Z box:services Attempt 2 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:12:07.396Z box:services Attempt 3 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:12:22.402Z box:services Attempt 4 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:12:37.408Z box:services Attempt 5 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:12:52.412Z box:services Attempt 6 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:13:07.418Z box:services Attempt 7 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    2023-08-08T10:13:22.420Z box:services Attempt 8 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
    and so on
    any idea how to fix this?

    1 Reply Last reply
    0
    • nebulonN Offline
      nebulonN Offline
      nebulon
      Staff
      wrote on last edited by
      #2

      When did this happen? Like after an update or so?

      Is the mysql service up and running? In this case this refers to the addon/service not the mysql instance on the host itself. There is also a troubleshooting guide if there was possible disk corruption https://docs.cloudron.io/troubleshooting/#mysql-addon

      Make sure to have backups though to restore the apps!

      1 Reply Last reply
      0
      • nebulonN nebulon marked this topic as a question on
      • C Offline
        C Offline
        cooljack
        wrote on last edited by
        #3

        Its a new fresh install.
        here is the main log:
        at /home/yellowtent/box/src/services.js:585:33
        at async Array.<anonymous> (/home/yellowtent/box/src/cloudron.js:133:9)
        at async Object.start (/home/yellowtent/box/src/platform.js:68:13)
        at async Object.startServices (/home/yellowtent/box/src/services.js:803:9)
        at async onActivated (/home/yellowtent/box/src/cloudron.js:81:5)
        at async promiseRetry (/home/yellowtent/box/src/promise-retry.js:17:20)
        at async startMysql (/home/yellowtent/box/src/services.js:1157:9)
        at async waitForContainer (/home/yellowtent/box/src/services.js:580:5)
        at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
        Aug 08 12:18:54 box:shell stopTurn exec: docker stop turn || true
        Aug 08 12:18:54 box:shell removeTurn exec: docker rm -f turn || true
        Aug 08 12:18:54 box:shell stopTurn (stderr): Error response from daemon: No such container: turn
        Aug 08 12:18:54 box:shell stopTurn (stdout): null
        Aug 08 12:18:54 box:shell removeTurn (stderr): Error response from daemon: No such container: turn
        Aug 08 12:18:54 box:shell removeTurn (stdout): null
        Aug 08 12:18:54 box:shell startTurn exec: docker run --restart=always -d --name="turn" --hostname turn --net host --log-driver syslog --log-opt syslog-address=udp://127.0.0.1:2514 --log-opt syslog-format=rfc5424 --log-opt tag=turn -m 187695104 --memory-swap 268435456 --dns 172.18.0.1 --dns-search=. -e CLOUDRON_TURN_SECRET="a23f9f094d3047583a979d67b8d42ae" -e CLOUDRON_REALM="my.hudb.de" --label isCloudronManaged=true --read-only -v /tmp -v /run "cloudron/turn:1.5.0@sha256:c59a6da9ea55073ede1ba6329739fca72eddf64c3a3c10280bcc5b7fb8197865"
        Aug 08 12:18:57 box:shell startTurn (stderr): null
        Aug 08 12:18:57 box:shell startTurn (stdout): 706b4c3c0978685780130ff390ffaf512723fd852d8cea7f573171958ee85ecb
        Aug 08 12:18:57 box:shell stopMysql exec: docker stop mysql || true
        Aug 08 12:18:57 box:shell stopMysql (stderr): Error response from daemon: No such container: mysql
        Aug 08 12:18:57 box:shell stopMysql (stdout): null
        Aug 08 12:18:57 box:shell removeMysql exec: docker rm -f mysql || true
        Aug 08 12:18:57 box:shell removeMysql (stderr): Error response from daemon: No such container: mysql
        Aug 08 12:18:57 box:shell removeMysql (stdout): null
        Aug 08 12:18:57 box:shell startMysql exec: docker run --restart=always -d --name="mysql" --hostname mysql --net cloudron --net-alias mysql --log-driver syslog --log-opt syslog-address=udp://127.0.0.1:2514 --log-opt syslog-format=rfc5424 --log-opt tag=mysql --dns 172.18.0.1 --dns-search=. --ip 172.18.30.1 -e CLOUDRON_MYSQL_TOKEN=b98dc0c0679cba99d9e36182e0899e3700368615f220e84719a3614d338f8eb01907c75fbf905f0d9514957b83290309f2bdbb0b17a53b60fd30b9c38985ec81e983705aee2cc5f5a65e2b631c95a0134d03b64d98efcaa42c604432293b7d08b3799bdb205bc6a60eefb565f73021a57256c9cd01635428713f26be6b7dd069 -e CLOUDRON_MYSQL_ROOT_HOST=172.18.0.1 -e CLOUDRON_MYSQL_ROOT_PASSWORD=81eb4790f2184a506a194ed1a3c15e0cc7b2c99e2bc07eebc26803f222c8123112bf2bc47843a16bc60712e5f0d876bee87c0f520a17c3a72154f7d0a93fbff80de2c839c56a118a8a5e7baad8d38086ccb12c68d986198671952e6465e5c039e8f809b617dcd1904f44c32c81420a84be09a0ca4be0b01192691839fda7efab -v "/home/yellowtent/platformdata/mysql:/var/lib/mysql" --label isCloudronManaged=true --cap-add SYS_NICE --read-only -v /tmp -v /run "cloudron/mysql:3.3.7@sha256:5c8fe784859a5bc8c839712d8b52427247a54bce9126fb2d50ca2535e6330647"
        Aug 08 12:19:05 box:services Waiting for mysql
        Aug 08 12:19:05 box:shell startMysql (stderr): null
        Aug 08 12:19:05 box:shell startMysql (stdout): bc055caab2337b2ccd5ef62d34d2ed553bab259d9aecf4faf98419293a3ea558
        Aug 08 12:19:05 box:services Attempt 1 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:19:20 box:services Attempt 2 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:19:35 box:services Attempt 3 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:19:50 box:services Attempt 4 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:20:05 box:services Attempt 5 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:20:20 box:services Attempt 6 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:20:35 box:services Attempt 7 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:20:50 box:services Attempt 8 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:21:05 box:services Attempt 9 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:21:20 box:services Attempt 10 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:21:35 box:services Attempt 11 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:21:50 box:services Attempt 12 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:22:05 box:services Attempt 13 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:22:20 box:services Attempt 14 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:22:35 box:services Attempt 15 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:22:50 box:services Attempt 16 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:23:05 box:services Attempt 17 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:23:20 box:services Attempt 18 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:23:28 box:locker Lock unreleased platform_start
        Aug 08 12:23:35 box:services Attempt 19 failed. Will retry: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:23:50 box:platform Failed to start services. retry=false (attempt 0): Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:23:50 box:cloudron Startup task at index 2 failed: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000 BoxError: Network error waiting for mysql: connect ECONNREFUSED 172.18.30.1:3000
        Aug 08 12:28:28 box:locker Lock unreleased platform_start
        Aug 08 12:33:28 box:locker Lock unreleased platform_start
        Aug 08 12:38:28 box:locker Lock unreleased platform_start
        Aug 08 12:43:28 box:locker Lock unreleased platform_start
        Aug 08 12:48:28 box:locker Lock unreleased platform_start
        Aug 08 12:53:28 box:locker Lock unreleased platform_start
        mysql log:
        tail -f /var/log/mysql/error.log
        2023-08-08T10:18:15.196709Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 11 user: 'root'.
        2023-08-08T10:18:15.198382Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 12 user: 'root'.
        2023-08-08T10:18:16.896393Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.22.04.4) (Ubuntu).
        2023-08-08T10:18:17.231319Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.4) starting as process 4661
        2023-08-08T10:18:17.245177Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
        2023-08-08T10:18:21.573735Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
        2023-08-08T10:18:25.821813Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
        2023-08-08T10:18:25.821924Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
        2023-08-08T10:18:25.883762Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
        2023-08-08T10:18:25.883889Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.33-0ubuntu0.22.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).

        1 Reply Last reply
        0
        • nebulonN Offline
          nebulonN Offline
          nebulon
          Staff
          wrote on last edited by
          #4

          Can you maybe look into /home/yellowtent/platformdata/logs/mysql/app.log to see why the mysql container didn't start?

          1 Reply Last reply
          0
          • C Offline
            C Offline
            cooljack
            wrote on last edited by
            #5

            sure here:
            2023-08-08T05:09:57.000Z Creating new installation
            2023-08-08T05:09:57.000Z Setting up MySql db at /var/lib/mysql
            2023-08-08T05:18:01.000Z Detected existing installation
            2023-08-08T05:18:01.000Z Resetting root password to 3111249da49d1a786c82a03aa510181bac3cd707af7b360013f1b470b3a733ddc34a0a691f4c2c9323075ee89f3dacb471dfe07173dba236c7955ebedd78140a4c224f78891dd585237499520f22a25bc3433547d9f2e2784aaaabc67283b5961a5fde445e4d3d96e556c9a801c85c2a146d00d6ec8e238738912bbd411c4544
            2023-08-08T05:18:01.000Z Waiting with password
            2023-08-08T05:18:01.000Z Waiting for MySQL to come up
            2023-08-08T05:18:02.000Z Waiting for MySQL to come up
            2023-08-08T05:18:03.000Z Waiting for MySQL to come up
            2023-08-08T05:18:04.000Z Waiting for MySQL to come up
            2023-08-08T05:18:05.000Z Waiting for MySQL to come up
            2023-08-08T05:18:06.000Z Waiting for MySQL to come up
            2023-08-08T05:18:07.000Z Waiting for MySQL to come up
            2023-08-08T05:18:09.000Z Waiting for MySQL to come up
            2023-08-08T05:18:10.000Z Waiting for MySQL to come up
            2023-08-08T05:18:11.000Z Waiting for MySQL to come up
            2023-08-08T05:18:12.000Z Waiting for MySQL to come up
            2023-08-08T05:18:13.000Z Waiting for MySQL to come up
            2023-08-08T05:18:14.000Z Waiting for MySQL to come up
            2023-08-08T05:18:15.000Z Waiting for MySQL to come up
            2023-08-08T05:18:16.000Z Waiting for MySQL to come up
            2023-08-08T05:18:17.000Z Waiting for MySQL to come up
            2023-08-08T05:18:18.000Z Waiting for MySQL to come up
            2023-08-08T05:18:19.000Z Waiting for MySQL to come up
            2023-08-08T05:18:20.000Z Waiting for MySQL to come up
            2023-08-08T05:18:21.000Z Waiting for MySQL to come up
            2023-08-08T05:18:22.000Z Waiting for MySQL to come up
            2023-08-08T05:18:23.000Z Waiting for MySQL to come up
            2023-08-08T05:18:24.000Z Waiting for MySQL to come up
            2023-08-08T05:18:25.000Z Waiting for MySQL to come up
            2023-08-08T05:18:26.000Z Waiting for MySQL to come up
            2023-08-08T05:18:27.000Z Waiting for MySQL to come up
            2023-08-08T05:18:28.000Z Waiting for MySQL to come up
            2023-08-08T05:18:29.000Z Waiting for MySQL to come up
            2023-08-08T05:18:30.000Z Waiting for MySQL to come up
            2023-08-08T05:18:31.000Z Waiting for MySQL to come up
            2023-08-08T05:18:32.000Z Waiting for MySQL to come up
            2023-08-08T05:18:33.000Z Waiting for MySQL to come up
            2023-08-08T05:18:34.000Z Waiting for MySQL to come up
            2023-08-08T05:18:35.000Z Waiting for MySQL to come up
            2023-08-08T05:18:36.000Z Waiting for MySQL to come up
            2023-08-08T05:18:37.000Z Waiting for MySQL to come up
            2023-08-08T05:18:38.000Z Waiting for MySQL to come up
            2023-08-08T05:18:39.000Z Waiting for MySQL to come up
            2023-08-08T05:18:40.000Z Waiting for MySQL to come up
            2023-08-08T05:18:41.000Z Waiting for MySQL to come up
            2023-08-08T05:18:42.000Z Waiting for MySQL to come up
            2023-08-08T05:18:43.000Z Waiting for MySQL to come up
            2023-08-08T05:18:44.000Z Waiting for MySQL to come up
            2023-08-08T05:18:45.000Z Waiting for MySQL to come up
            2023-08-08T05:18:46.000Z Waiting for MySQL to come up
            2023-08-08T05:18:47.000Z Waiting for MySQL to come up
            2023-08-08T05:18:48.000Z Waiting for MySQL to come up
            2023-08-08T05:18:49.000Z Waiting for MySQL to come up
            2023-08-08T05:18:50.000Z Waiting for MySQL to come up
            2023-08-08T05:18:51.000Z Waiting for MySQL to come up
            2023-08-08T05:18:52.000Z Waiting for MySQL to come up
            2023-08-08T05:18:53.000Z Waiting for MySQL to come up
            2023-08-08T05:18:54.000Z Waiting for MySQL to come up
            2023-08-08T05:18:55.000Z Waiting for MySQL to come up
            2023-08-08T05:18:56.000Z Waiting for MySQL to come up
            2023-08-08T05:18:57.000Z Waiting for MySQL to come up
            2023-08-08T05:18:58.000Z Waiting for MySQL to come up
            2023-08-08T05:18:59.000Z Waiting for MySQL to come up
            2023-08-08T05:19:00.000Z Waiting for MySQL to come up
            2023-08-08T05:19:01.000Z Waiting for MySQL to come up
            2023-08-08T05:19:02.000Z Waiting for MySQL to come up
            2023-08-08T05:19:03.000Z Waiting for MySQL to come up
            2023-08-08T05:19:04.000Z Waiting for MySQL to come up
            2023-08-08T05:19:05.000Z Waiting for MySQL to come up
            2023-08-08T05:19:06.000Z Waiting for MySQL to come up
            2023-08-08T05:19:07.000Z Waiting for MySQL to come up
            2023-08-08T05:19:08.000Z Waiting for MySQL to come up
            2023-08-08T05:19:09.000Z Waiting for MySQL to come up
            2023-08-08T05:19:10.000Z Waiting for MySQL to come up
            2023-08-08T05:19:11.000Z Waiting for MySQL to come up
            2023-08-08T05:19:12.000Z Waiting for MySQL to come up
            2023-08-08T05:19:13.000Z Waiting for MySQL to come up
            2023-08-08T05:19:14.000Z Waiting for MySQL to come up
            2023-08-08T05:19:15.000Z Waiting for MySQL to come up
            2023-08-08T05:19:16.000Z Waiting for MySQL to come up
            2023-08-08T05:19:17.000Z Waiting for MySQL to come up
            2023-08-08T05:19:18.000Z Waiting for MySQL to come up
            2023-08-08T05:19:19.000Z Waiting for MySQL to come up
            2023-08-08T05:19:20.000Z Waiting for MySQL to come up
            2023-08-08T05:19:21.000Z Waiting for MySQL to come up
            2023-08-08T05:19:22.000Z Waiting for MySQL to come up
            2023-08-08T05:19:23.000Z Waiting for MySQL to come up
            2023-08-08T05:19:24.000Z Waiting for MySQL to come up
            2023-08-08T05:19:25.000Z Waiting for MySQL to come up
            2023-08-08T05:19:26.000Z Waiting for MySQL to come up
            2023-08-08T05:19:27.000Z Waiting for MySQL to come up
            2023-08-08T05:19:28.000Z Waiting for MySQL to come up
            2023-08-08T05:19:30.000Z Waiting for MySQL to come up
            2023-08-08T05:19:31.000Z Waiting for MySQL to come up
            2023-08-08T05:19:32.000Z Waiting for MySQL to come up
            2023-08-08T05:19:33.000Z Waiting for MySQL to come up
            2023-08-08T05:19:34.000Z Waiting for MySQL to come up
            2023-08-08T05:19:35.000Z Waiting for MySQL to come up
            2023-08-08T05:19:36.000Z Waiting for MySQL to come up
            2023-08-08T05:19:37.000Z Waiting for MySQL to come up
            2023-08-08T05:19:38.000Z Waiting for MySQL to come up
            2023-08-08T05:19:39.000Z Waiting for MySQL to come up
            2023-08-08T05:19:40.000Z Waiting for MySQL to come up
            2023-08-08T05:19:41.000Z Waiting for MySQL to come up
            2023-08-08T05:19:42.000Z Waiting for MySQL to come up
            2023-08-08T05:19:43.000Z Waiting for MySQL to come up
            2023-08-08T05:19:44.000Z Waiting for MySQL to come up
            2023-08-08T05:19:45.000Z Waiting for MySQL to come up
            2023-08-08T05:19:46.000Z Waiting for MySQL to come up
            2023-08-08T05:19:47.000Z Waiting for MySQL to come up
            2023-08-08T05:19:48.000Z Waiting for MySQL to come up
            2023-08-08T05:19:49.000Z Waiting for MySQL to come up
            2023-08-08T05:19:50.000Z Waiting for MySQL to come up
            2023-08-08T05:19:51.000Z Waiting for MySQL to come up
            2023-08-08T05:19:52.000Z Waiting for MySQL to come up
            2023-08-08T05:19:53.000Z Waiting for MySQL to come up
            2023-08-08T05:19:54.000Z Waiting for MySQL to come up
            2023-08-08T05:19:55.000Z Waiting for MySQL to come up
            2023-08-08T05:19:56.000Z Waiting for MySQL to come up
            2023-08-08T05:19:57.000Z Waiting for MySQL to come up
            2023-08-08T05:19:58.000Z Waiting for MySQL to come up
            2023-08-08T05:19:59.000Z Waiting for MySQL to come up
            2023-08-08T05:20:00.000Z Waiting for MySQL to come up
            2023-08-08T05:20:01.000Z Waiting for MySQL to come up
            2023-08-08T05:20:02.000Z Waiting for MySQL to come up
            2023-08-08T05:20:03.000Z Waiting for MySQL to come up
            2023-08-08T05:20:04.000Z Waiting for MySQL to come up
            2023-08-08T05:20:05.000Z Waiting for MySQL to come up
            2023-08-08T05:20:06.000Z Waiting for MySQL to come up
            2023-08-08T05:20:07.000Z Waiting for MySQL to come up
            2023-08-08T05:20:08.000Z Waiting for MySQL to come up
            2023-08-08T05:20:09.000Z Waiting for MySQL to come up
            2023-08-08T05:20:10.000Z Waiting for MySQL to come up
            2023-08-08T05:20:11.000Z Waiting for MySQL to come up
            2023-08-08T05:20:12.000Z Waiting for MySQL to come up
            2023-08-08T05:20:13.000Z Waiting for MySQL to come up
            2023-08-08T05:20:14.000Z Waiting for MySQL to come up
            2023-08-08T05:20:15.000Z Waiting for MySQL to come up
            2023-08-08T05:20:16.000Z Waiting for MySQL to come up
            2023-08-08T05:20:17.000Z Waiting for MySQL to come up
            2023-08-08T05:20:18.000Z Waiting for MySQL to come up
            2023-08-08T05:20:19.000Z Waiting for MySQL to come up
            2023-08-08T05:20:20.000Z Waiting for MySQL to come up
            2023-08-08T05:20:21.000Z Waiting for MySQL to come up
            2023-08-08T05:20:22.000Z Waiting for MySQL to come up
            2023-08-08T05:20:23.000Z Waiting for MySQL to come up
            2023-08-08T05:20:24.000Z Waiting for MySQL to come up
            2023-08-08T05:20:25.000Z Waiting for MySQL to come up
            2023-08-08T05:20:26.000Z Waiting for MySQL to come up
            2023-08-08T05:20:27.000Z Waiting for MySQL to come up
            2023-08-08T05:20:28.000Z Waiting for MySQL to come up
            2023-08-08T05:20:29.000Z Waiting for MySQL to come up
            2023-08-08T05:20:30.000Z Waiting for MySQL to come up
            2023-08-08T05:20:31.000Z Waiting for MySQL to come up
            2023-08-08T05:20:32.000Z Waiting for MySQL to come up
            2023-08-08T05:20:33.000Z Waiting for MySQL to come up
            2023-08-08T05:20:34.000Z Waiting for MySQL to come up
            2023-08-08T05:20:35.000Z Waiting for MySQL to come up
            2023-08-08T05:20:36.000Z Waiting for MySQL to come up
            2023-08-08T05:20:37.000Z Waiting for MySQL to come up
            2023-08-08T05:20:38.000Z Waiting for MySQL to come up
            2023-08-08T05:20:39.000Z Waiting for MySQL to come up
            2023-08-08T05:20:40.000Z Waiting for MySQL to come up
            2023-08-08T05:20:41.000Z Waiting for MySQL to come up
            2023-08-08T05:20:42.000Z Waiting for MySQL to come up
            2023-08-08T05:20:43.000Z Waiting for MySQL to come up
            2023-08-08T05:20:44.000Z Waiting for MySQL to come up
            2023-08-08T05:20:45.000Z Waiting for MySQL to come up
            2023-08-08T05:20:46.000Z Waiting for MySQL to come up
            2023-08-08T05:20:47.000Z Waiting for MySQL to come up
            2023-08-08T05:20:48.000Z Waiting for MySQL to come up
            2023-08-08T05:20:49.000Z Waiting for MySQL to come up
            2023-08-08T05:20:51.000Z Waiting for MySQL to come up
            2023-08-08T05:20:52.000Z Waiting for MySQL to come up
            2023-08-08T05:20:53.000Z Waiting for MySQL to come up
            2023-08-08T05:20:54.000Z Waiting for MySQL to come up
            2023-08-08T05:20:55.000Z Waiting for MySQL to come up
            2023-08-08T05:20:56.000Z Waiting for MySQL to come up
            2023-08-08T05:20:57.000Z Waiting for MySQL to come up
            2023-08-08T05:20:58.000Z Waiting for MySQL to come up
            2023-08-08T05:20:59.000Z Waiting for MySQL to come up
            2023-08-08T05:21:00.000Z Waiting for MySQL to come up
            2023-08-08T05:21:01.000Z Waiting for MySQL to come up
            2023-08-08T05:21:02.000Z Waiting for MySQL to come up
            2023-08-08T05:21:03.000Z Waiting for MySQL to come up
            2023-08-08T05:21:04.000Z Waiting for MySQL to come up
            2023-08-08T05:21:05.000Z Waiting for MySQL to come up
            2023-08-08T05:21:06.000Z Waiting for MySQL to come up
            2023-08-08T05:21:07.000Z Waiting for MySQL to come up
            2023-08-08T05:21:08.000Z Waiting for MySQL to come up
            2023-08-08T05:21:09.000Z Waiting for MySQL to come up
            2023-08-08T05:21:10.000Z Waiting for MySQL to come up
            2023-08-08T05:21:11.000Z Waiting for MySQL to come up
            2023-08-08T05:21:12.000Z Waiting for MySQL to come up
            2023-08-08T05:21:13.000Z Waiting for MySQL to come up
            2023-08-08T05:21:14.000Z Waiting for MySQL to come up
            2023-08-08T05:21:15.000Z Waiting for MySQL to come up
            2023-08-08T05:21:16.000Z Waiting for MySQL to come up
            2023-08-08T05:21:17.000Z Waiting for MySQL to come up
            2023-08-08T05:21:18.000Z Waiting for MySQL to come up
            2023-08-08T05:21:19.000Z Waiting for MySQL to come up
            2023-08-08T05:21:20.000Z Waiting for MySQL to come up
            2023-08-08T05:21:21.000Z Waiting for MySQL to come up
            2023-08-08T05:21:22.000Z Waiting for MySQL to come up
            2023-08-08T05:21:23.000Z Waiting for MySQL to come up
            2023-08-08T05:21:24.000Z Waiting for MySQL to come up
            2023-08-08T05:21:25.000Z Waiting for MySQL to come up
            2023-08-08T05:21:26.000Z Waiting for MySQL to come up
            2023-08-08T05:21:27.000Z Waiting for MySQL to come up
            2023-08-08T05:21:28.000Z Waiting for MySQL to come up
            2023-08-08T05:21:29.000Z Waiting for MySQL to come up
            2023-08-08T05:21:30.000Z Waiting for MySQL to come up
            2023-08-08T05:21:31.000Z Waiting for MySQL to come up
            2023-08-08T05:21:32.000Z Waiting for MySQL to come up
            2023-08-08T05:21:33.000Z Waiting for MySQL to come up
            2023-08-08T05:21:34.000Z Waiting for MySQL to come up
            2023-08-08T05:21:35.000Z Waiting for MySQL to come up
            2023-08-08T05:21:36.000Z Waiting for MySQL to come up
            2023-08-08T05:21:37.000Z Waiting for MySQL to come up
            2023-08-08T05:21:38.000Z Waiting for MySQL to come up
            2023-08-08T05:21:39.000Z Waiting for MySQL to come up
            2023-08-08T05:21:40.000Z Waiting for MySQL to come up
            2023-08-08T05:21:41.000Z Waiting for MySQL to come up
            2023-08-08T05:21:42.000Z Waiting for MySQL to come up
            2023-08-08T05:21:43.000Z Waiting for MySQL to come up
            2023-08-08T05:21:44.000Z Waiting for MySQL to come up
            2023-08-08T05:21:45.000Z Waiting for MySQL to come up
            2023-08-08T05:21:46.000Z Waiting for MySQL to come up
            2023-08-08T05:21:47.000Z Waiting for MySQL to come up
            2023-08-08T05:21:48.000Z Waiting for MySQL to come up
            2023-08-08T05:21:49.000Z Waiting for MySQL to come up
            2023-08-08T05:21:50.000Z Waiting for MySQL to come up
            2023-08-08T05:21:51.000Z Waiting for MySQL to come up
            2023-08-08T05:21:52.000Z Waiting for MySQL to come up
            2023-08-08T05:21:53.000Z Waiting for MySQL to come up
            2023-08-08T05:21:54.000Z Waiting for MySQL to come up
            2023-08-08T05:21:55.000Z Waiting for MySQL to come up
            2023-08-08T05:21:56.000Z Waiting for MySQL to come up
            2023-08-08T05:21:57.000Z Waiting for MySQL to come up
            2023-08-08T05:21:58.000Z Waiting for MySQL to come up
            2023-08-08T05:21:59.000Z Waiting for MySQL to come up
            2023-08-08T05:22:00.000Z Waiting for MySQL to come up
            2023-08-08T05:22:01.000Z Waiting for MySQL to come up
            2023-08-08T05:22:02.000Z Waiting for MySQL to come up
            2023-08-08T05:22:03.000Z Waiting for MySQL to come up
            2023-08-08T05:22:04.000Z Waiting for MySQL to come up
            2023-08-08T05:22:05.000Z Waiting for MySQL to come up
            2023-08-08T05:22:06.000Z Waiting for MySQL to come up
            2023-08-08T05:22:07.000Z Waiting for MySQL to come up
            2023-08-08T05:22:08.000Z Waiting for MySQL to come up
            2023-08-08T05:22:09.000Z Waiting for MySQL to come up
            2023-08-08T05:22:10.000Z Waiting for MySQL to come up
            2023-08-08T05:22:11.000Z Waiting for MySQL to come up
            2023-08-08T05:22:12.000Z Waiting for MySQL to come up
            2023-08-08T05:22:14.000Z Waiting for MySQL to come up
            2023-08-08T05:22:15.000Z Waiting for MySQL to come up
            2023-08-08T05:22:16.000Z Waiting for MySQL to come up
            2023-08-08T05:22:17.000Z Waiting for MySQL to come up
            2023-08-08T05:22:18.000Z Waiting for MySQL to come up
            2023-08-08T05:22:19.000Z Waiting for MySQL to come up
            2023-08-08T05:22:20.000Z Waiting for MySQL to come up
            2023-08-08T05:22:21.000Z Waiting for MySQL to come up
            2023-08-08T05:22:22.000Z Waiting for MySQL to come up
            2023-08-08T05:22:23.000Z Waiting for MySQL to come up
            2023-08-08T05:22:24.000Z Waiting for MySQL to come up
            2023-08-08T05:22:25.000Z Waiting for MySQL to come up
            2023-08-08T05:22:26.000Z Waiting for MySQL to come up
            2023-08-08T05:22:27.000Z Waiting for MySQL to come up
            2023-08-08T05:22:28.000Z Waiting for MySQL to come up
            2023-08-08T05:22:29.000Z Waiting for MySQL to come up
            2023-08-08T05:22:30.000Z Waiting for MySQL to come up
            2023-08-08T05:22:31.000Z Waiting for MySQL to come up
            2023-08-08T05:22:32.000Z Waiting for MySQL to come up
            2023-08-08T05:22:33.000Z Waiting for MySQL to come up
            2023-08-08T05:22:34.000Z Waiting for MySQL to come up
            2023-08-08T05:22:35.000Z Waiting for MySQL to come up
            2023-08-08T05:22:36.000Z Waiting for MySQL to come up
            2023-08-08T05:22:37.000Z Waiting for MySQL to come up
            2023-08-08T05:22:38.000Z Waiting for MySQL to come up
            2023-08-08T05:22:39.000Z Waiting for MySQL to come up
            2023-08-08T05:22:40.000Z Waiting for MySQL to come up
            2023-08-08T05:22:41.000Z Waiting for MySQL to come up
            2023-08-08T05:22:42.000Z Waiting for MySQL to come up
            2023-08-08T05:22:43.000Z Waiting for MySQL to come up
            2023-08-08T05:22:44.000Z Waiting for MySQL to come up
            2023-08-08T05:22:45.000Z Waiting for MySQL to come up
            2023-08-08T05:22:46.000Z Waiting for MySQL to come up
            2023-08-08T16:21:57.000Z Waiting for MySQL to come up
            2023-08-08T16:21:58.000Z Waiting for MySQL to come up
            2023-08-08T16:21:59.000Z Waiting for MySQL to come up
            2023-08-08T16:36:51.000Z Waiting for MySQL to come up
            2023-08-08T16:36:52.000Z Waiting for MySQL to come up

            1 Reply Last reply
            0
            • C Offline
              C Offline
              cooljack
              wrote on last edited by
              #6

              uh maybe here is something hidden:
              sudo docker exec -ti mysql /bin/bash
              root@mysql:/app/code# tail -f /tmp/mysqld.err
              2023-08-08T16:41:00.492374Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
              2023-08-08T16:41:00.492506Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
              2023-08-08T16:41:00.492539Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.22.04.2) starting as process 12
              2023-08-08T16:41:00.507545Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
              2023-08-08T16:41:00.622306Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
              2023-08-08T16:41:01.072718Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
              2023-08-08T16:41:01.073066Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
              2023-08-08T16:41:01.073110Z 0 [ERROR] [MY-010119] [Server] Aborting
              2023-08-08T16:41:01.074101Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.22.04.2) (Ubuntu).

              1 Reply Last reply
              0
              • nebulonN Offline
                nebulonN Offline
                nebulon
                Staff
                wrote on last edited by
                #7

                If this is a fresh instance, then there is nothing in that database so you can nuke potentially corrupted files:

                rm -rf /home/yellowtent/platformdata/mysql
                mkdir /home/yellowtent/platformdata/mysql
                

                (essentially from https://docs.cloudron.io/troubleshooting/#mysql-addon )

                1 Reply Last reply
                0
                • C Offline
                  C Offline
                  cooljack
                  wrote on last edited by
                  #8

                  i tried but i get the same error again.
                  i reset my vm and start over. 🙂

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

                    @cooljack Can you give more information about your VM? Is this a public cloud provider or something else?

                    If you can give us access to vm, we can look it this as well. Have to say never seen initialization of MySQL fail...

                    1 Reply Last reply
                    0
                    • girishG girish has marked this topic as solved on
                    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