'm trying to deploy a second mysql database.
Here is my fly.toml
# fly.toml file generated for marketplace-db on 2023-02-24T10:23:40-06:00
app = "marketplace-db"
kill_signal = "SIGINT"
kill_timeout = 5
processes = []
[build]
image = "mysql:8"
[env]
MYSQL_DATABASE = "marketplace-db"
MYSQL_USER = "admin"
MYSQL_PORT = "3306"
[experimental]
allowed_public_ports = []
cmd = ["--default-authentication-plugin", "mysql_native_password", "--datadir", "/data/mysql", "--performance-schema=OFF", "--innodb-buffer-pool-size", "64M"]
[[mounts]]
destination = "/data"
source = "marketplaceData"
and deploy log
fly deploy ✔
==> Verifying app config
--> Verified app config
==> Building image
Searching for image 'mysql:8' remotely...
image found: img_8y6w4zr3q32p7rn3
==> Creating release
--> release v1 created
--> You can detach the terminal anytime without stopping the deployment
==> Monitoring deployment
Logs: https://fly.io/apps/marketplace-db/monitoring
1 desired, 1 placed, 0 healthy, 1 unhealthy [restarts: 2]
Failed Instances
Failure #1
Instance
ID PROCESS VERSION REGION DESIRED STATUS HEALTH CHECKS RESTARTS CREATED
430ebc56 app 1 mia run failed 2 17s ago
Recent Events
TIMESTAMP TYPE MESSAGE
2023-02-24T16:30:33Z Received Task received by client
2023-02-24T16:30:33Z Task Setup Building Task Directory
2023-02-24T16:30:35Z Started Task started by client
2023-02-24T16:30:37Z Terminated Exit Code: 1
2023-02-24T16:30:37Z Restarting Task restarting in 1.102285328s
2023-02-24T16:30:42Z Started Task started by client
2023-02-24T16:30:44Z Terminated Exit Code: 1
2023-02-24T16:30:44Z Restarting Task restarting in 1.026598758s
2023-02-24T16:30:50Z Started Task started by client
2023-02-24T16:30:52Z Terminated Exit Code: 1
2023-02-24T16:30:52Z Not Restarting Exceeded allowed attempts 2 in interval 5m0s and mode is "fail"
2023-02-24T16:30:52Z Alloc Unhealthy Unhealthy because of failed task
2023-02-24T16:30:41Z [info]Opening encrypted volume
2023-02-24T16:30:41Z [info]Configuring firecracker
2023-02-24T16:30:41Z [info]Starting virtual machine
2023-02-24T16:30:42Z [info]Starting init (commit: 08b4c2b)...
2023-02-24T16:30:42Z [info]Mounting /dev/vdc at /data w/ uid: 0, gid: 0 and chmod 0755
2023-02-24T16:30:42Z [info]Preparing to run: `docker-entrypoint.sh --default-authentication-plugin mysql_native_password --datadir /data/mysql --performance-schema=OFF --innodb-buffer-pool-size 64M` as root
2023-02-24T16:30:42Z [info]2023/02/24 16:30:42 listening on [fdaa:1:18b8:a7b:a0:5:38e9:2]:22 (DNS: [fdaa::3]:53)
2023-02-24T16:30:42Z [info]2023-02-24 16:30:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-02-24T16:30:42Z [info]2023-02-24 16:30:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-02-24T16:30:42Z [info]2023-02-24 16:30:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-02-24T16:30:43Z [info]Starting clean up.
2023-02-24T16:30:43Z [info]Umounting /dev/vdc from /data
2023-02-24T16:30:48Z [info]Starting instance
2023-02-24T16:30:48Z [info]Configuring virtual machine
2023-02-24T16:30:48Z [info]Pulling container image
2023-02-24T16:30:49Z [info]Unpacking image
2023-02-24T16:30:49Z [info]Preparing kernel init
2023-02-24T16:30:49Z [info]Setting up volume 'marketplaceData'
2023-02-24T16:30:49Z [info]Opening encrypted volume
2023-02-24T16:30:49Z [info]Configuring firecracker
2023-02-24T16:30:50Z [info]Starting virtual machine
2023-02-24T16:30:50Z [info]Starting init (commit: 08b4c2b)...
2023-02-24T16:30:50Z [info]Mounting /dev/vdc at /data w/ uid: 0, gid: 0 and chmod 0755
2023-02-24T16:30:50Z [info]Preparing to run: `docker-entrypoint.sh --default-authentication-plugin mysql_native_password --datadir /data/mysql --performance-schema=OFF --innodb-buffer-pool-size 64M` as root
2023-02-24T16:30:50Z [info]2023/02/24 16:30:50 listening on [fdaa:1:18b8:a7b:a0:5:38e9:2]:22 (DNS: [fdaa::3]:53)
2023-02-24T16:30:50Z [info]2023-02-24 16:30:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-02-24T16:30:50Z [info]2023-02-24 16:30:50+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-02-24T16:30:50Z [info]2023-02-24 16:30:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-02-24T16:30:51Z [info]Starting clean up.
2023-02-24T16:30:51Z [info]Umounting /dev/vdc from /data
--> v1 failed - Failed due to unhealthy allocations - no stable job version to auto revert to and deploying as v2
--> Troubleshooting guide at https://fly.io/docs/getting-started/troubleshooting/
Error abort
I have already deploy a mysql database, and still works with this fly.toml
# fly.toml file generated for spcpdb on 2023-01-04T12:54:46-06:00
app = "spcpdb"
kill_signal = "SIGINT"
kill_timeout = 5
processes = []
[build]
image = "mysql:8"
[env]
MYSQL_DATABASE = "spcpdb"
MYSQL_USER = "paisa"
[experimental]
allowed_public_ports = []
cmd = ["--default-authentication-plugin", "mysql_native_password", "--datadir", "/data/mysql", "--performance-schema=OFF", "--innodb-buffer-pool-size", "64M"]
[[mounts]]
destination = "/data"
source = "mysqldata"
[[services]]
internal_port = 3306
protocol = "tcp"
[[services.ports]]
handlers = []
port = 9000
HELP PLEASE