New install mysql problem

[cooljack]

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?

[nebulon]

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!

[cooljack]

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

[nebulon]

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

[cooljack]

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

[cooljack]

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

[nebulon]

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 )

[cooljack]

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

[girish]

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