我有一个容器组，由数据库（MySQL），客户端应用程序（SSR，SvelteKit与节点适配器）和反向代理（Caddy，用于启用自动HTTPS）组成。
数据库的Dockerfile：

FROM mysql:8.2.0
COPY init-prod.sql /docker-entrypoint-initdb.d/init.sql
EXPOSE 3306

字符串
数据库Dockerfile中提到的init-prod.sql：

GRANT ALL PRIVILEGES ON <database_name>.* TO '<database_user>'@'%';
-- Required for Prisma Migrate
GRANT CREATE, ALTER, DROP, REFERENCES ON *.* TO '<database_user>'@'%';
-- Flush privileges to apply changes
FLUSH PRIVILEGES;

型
SvelteKit应用程序的Dockerfile。我试图执行npx prisma migrate deploy的容器就是从这个镜像创建的。

FROM node:18.19.0 as build
WORKDIR /app
COPY . .
RUN npm ci --omit dev
RUN npm run build

FROM node:18.19.0
COPY --from=build /app/package.json .
COPY --from=build /app/.env.production .env
COPY --from=build /app/node_modules node_modules
COPY --from=build /app/prisma prisma
COPY --from=build /app/build .
CMD ["npm", "run", "prod"]

型
成功部署到容器服务器后，我尝试使用以下Azure CLI命令运行迁移：

az container exec --resource-group <resource_group> --name <container_group> --container-name app --exec-command "npx --yes prisma migrate deploy"

型
命令输出：

Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": MySQL database "txtsummprod" at "db:3306"

Error: P1001: Can't reach database server at `db`:`3306`

Please make sure your database server is running at `db`:`3306`.

型
Prisma DATABASE_URL env变量的格式如下：
mysql://<database_user>:<database_password>@db:3306/<database_name>?connect_timeout=300个
我试过了：
1.将?connect_timeout=300添加到DATABASE_URLper this answer
1.更改节点映像版本per this answer
本地迁移应用得很好，只有当我试图在部署到容器服务器的容器中执行npx prisma migrate deploy时，问题才会出现
根据Azure容器服务器的db容器日志，一切似乎正常，数据库已准备好接受连接：

2024-01-03 22:34:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2024-01-03 22:34:01+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-01-03 22:34:01+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
ln: failed to create symbolic link '/var/lib/mysql/mysql.sock': Operation not supported
2024-01-03T22:34:03.057381Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-01-03T22:34:03.348494Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-01-03T22:34:03.377157Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 150
2024-01-03T22:34:03.526733Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-01-03T22:34:03.537967Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-01-03T22:34:03.543031Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 328cd822-aa88-11ee-8f84-00155d592a61.
2024-01-03T22:34:03.623222Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-03T22:34:10.269749Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-03T22:34:11.972853Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-03T22:34:11.977611Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-03T22:34:12.071977Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-01-03T22:34:12.168356Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-01-03T22:34:12.168448Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.2.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.

型
用于部署到Azure容器的YAML看起来像这样：

apiVersion: 2021-10-01
location: eastus
name: txt-summ
properties:
  containers:
    - name: reverse-proxy
      properties:
        image: summacr.azurecr.io/reverse-proxy:latest
        ports:
          - port: 80
            protocol: TCP
          - port: 443
            protocol: TCP
        resources:
          requests:
            memoryInGB: 1.0
            cpu: 1.0
          limits:
            memoryInGB: 1.0
            cpu: 1.0
        volumeMounts:
          - name: proxy-data
            mountPath: /data
          - name: proxy-config
            mountPath: /config
    - name: app
      properties:
        image: summacr.azurecr.io/app:latest
        resources:
          requests:
            cpu: 1.5
            memoryInGB: 1.5
        ports:
          - port: 3000
            protocol: TCP
    - name: db
      properties:
        image: summacr.azurecr.io/db:latest
        resources:
          requests:
            cpu: 1.0
            memoryInGB: 1.0
        volumeMounts:
          - name: db-data
            mountPath: /var/lib/mysql
        environmentVariables:
          - name: MYSQL_USER
            value: $DB_USER
          - name: MYSQL_PASSWORD
            value: $DB_PASSWORD
          - name: MYSQL_ROOT_PASSWORD
            value: $DB_ROOT_PASSWORD
          - name: MYSQL_DATABASE
            value: $DB_NAME
        ports:
          - port: 3306
            protocol: TCP
  ipAddress:
    dnsNameLabel: txt-summ
    ports:
      - port: 80
        protocol: TCP
      - port: 443
        protocol: TCP
    type: Public
  imageRegistryCredentials:
    - server: $ACR_LOGIN_SERVER
      username: $ACR_USERNAME
      password: $ACR_PASSWORD
  volumes:
    - name: proxy-data
      azureFile:
        shareName: $PROXY_DATA_FILE_SHARE_NAME
        storageAccountName: $STORAGE_ACCOUNT_NAME
        storageAccountKey: $STORAGE_ACCOUNT_KEY
    - name: proxy-config
      azureFile:
        shareName: $PROXY_CONFIG_FILE_SHARE_NAME
        storageAccountName: $STORAGE_ACCOUNT_NAME
        storageAccountKey: $STORAGE_ACCOUNT_KEY
    - name: db-data
      azureFile:
        shareName: $DB_DATA_FILE_SHARE_NAME
        storageAccountName: $STORAGE_ACCOUNT_NAME
        storageAccountKey: $STORAGE_ACCOUNT_KEY
  osType: Linux
type: Microsoft.ContainerInstance/containerGroups

型