M1 Pro Mac ARM架构下Docker容器运行SQLite报错求助

问题场景 #

在ARM架构的M1 Pro MacBook上，构建并运行包含SQLite的Express.js后端Docker容器时触发invalid ELF header错误，前端Dockerfile运行正常，后端通过db.js连接数据库。已尝试更换Node镜像为Alpine版本，问题未解决。

原Dockerfile #

FROM node:14

# Install system dependencies
RUN apt-get update && \
    apt-get install -y \
    python3 \
    make \
    g++ \
    && rm -rf /var/lib/apt/lists/*

# Set working directory
WORKDIR /app

# Copy package.json and package-lock.json to the working directory
COPY package*.json ./

# Install dependencies
RUN npm install

# Rebuild SQLite3 module
RUN npm rebuild keinos/sqlite3 --build-from-source

# Copy the rest of the application code
COPY . .

# Command to run the application
CMD ["node", "express.js"]

运行命令 #

docker run -d --name pizzaserver3 -p 3004:3004 pizza-server

错误日志 #

2024-06-16 23:37:26 /app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:57
2024-06-16 23:37:26       throw err;
2024-06-16 23:37:26       ^
2024-06-16 23:37:26 
2024-06-16 23:37:26 Error: /app/node_modules/sqlite3/build/Release/node_sqlite3.node: invalid ELF header
2024-06-16 23:37:26     at Object.Module._extensions..node (internal/modules/cjs/loader.js:1173:18)
2024-06-16 23:37:26     at Module.load (internal/modules/cjs/loader.js:979:32)
2024-06-16 23:37:26     at Function.Module._load (internal/modules/cjs/loader.js:819:12)
2024-06-16 23:37:26     at Module.require (internal/modules/cjs/loader.js:1003:19)
2024-06-16 23:37:26     at require (internal/modules/cjs/helpers.js:107:18)
2024-06-16 23:37:26     at bindings (/app/node_modules/bindings/bindings.js:112:48)
2024-06-16 23:37:26     at Object.<anonymous> (/app/node_modules/sqlite3/lib/sqlite3-binding.js:1:37)
2024-06-16 23:37:26     at Module._compile (internal/modules/cjs/loader.js:1114:14)
2024-06-16 23:37:26     at Object.Module._extensions..js (internal/modules/cjs/loader.js:1143:10)
2024-06-16 23:37:26     at Module.load (internal/modules/cjs/loader.js:979:32) {
2024-06-16 23:37:26   code: 'ERR_DLOPEN_FAILED'
2024-06-16 23:37:26 }
2024-06-16 23:37:35 /app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:57
2024-06-16 23:37:35       throw err;
2024-06-16 23:37:35       ^
2024-06-16 23:37:35 
2024-06-16 23:37:35 Error: /app/node_modules/sqlite3/build/Release/node_sqlite3.node: invalid ELF header
2024-06-16 23:37:35     at Object.Module._extensions..node (internal/modules/cjs/loader.js:1173:18)
2024-06-16 23:37:35     at Module.load (internal/modules/cjs/loader.js:979:32)
2024-06-16 23:37:35     at Function.Module._load (internal/modules/cjs/loader.js:819:12)
2024-06-16 23:37:35     at Module.require (internal/modules/cjs/loader.js:1003:19)
2024-06-16 23:37:35     at require (internal/modules/cjs/helpers.js:107:18)
2024-06-16 23:37:35     at bindings (/app/node_modules/bindings/bindings.js:112:48)
2024-06-16 23:37:35     at Object.<anonymous> (/app/node_modules/sqlite3/lib/sqlite3-binding.js:1:37)
2024-06-16 23:37:35     at Module._compile (internal/modules/cjs/loader.js:1114:14)
2024-06-16 23:37:35     at Object.Module._extensions..js (internal/modules/cjs/loader.js:1143:10)
2024-06-16 23:37:35     at Module.load (internal/modules/cjs/loader.js:979:32) {
2024-06-16 23:37:35   code: 'ERR_DLOPEN_FAILED'
2024-06-16 23:37:35 }

解决方案 #

错误核心原因：SQLite3的二进制模块架构不匹配——要么是本机ARM架构编译的产物被带入x86_64容器，要么是构建时镜像架构与运行容器架构不一致。以下是几种可行方案：

方案1：强制以x86_64架构构建镜像 #

在构建镜像时指定平台参数，让Docker在x86_64环境下编译依赖，配合Rosetta 2运行：

docker build --platform linux/amd64 -t pizza-server .

构建完成后直接用原命令运行容器即可。

方案2：优化Dockerfile，确保容器内编译依赖 #

修改Dockerfile，彻底避免本机依赖污染，强制在容器内编译匹配架构的SQLite3：

# 指定镜像架构为x86_64
FROM --platform=linux/amd64 node:14

# 安装编译依赖
RUN apt-get update && \
    apt-get install -y python3 make g++ && \
    rm -rf /var/lib/apt/lists/*

WORKDIR /app

# 复制依赖配置文件
COPY package*.json ./

# 清除可能存在的本机编译产物
RUN rm -rf node_modules

# 强制在容器内编译SQLite3
RUN npm install --build-from-source=sqlite3

# 复制应用代码
COPY . .

CMD ["node", "express.js"]

方案3：替换为纯JavaScript版SQLite库 #

放弃需要编译二进制的sqlite3，改用纯JS实现的库，比如sqlite：

1. 卸载原库：

npm uninstall sqlite3

2. 安装纯JS版：

npm install sqlite

3. 修改db.js中的连接代码适配新库，重新构建镜像即可。

方案4：使用ARM架构原生镜像 #

直接使用支持ARM架构的Node镜像，让容器与本机架构一致：

FROM node:14-bullseye-slim

后续步骤保持原Dockerfile内容，直接构建运行即可，无需架构模拟。

内容的提问来源于stack exchange，提问作者ramonz000