PostgreSQL SQL 迁移在 g0 上导致致命错误：morestack

Golang小白一枚，正在不断学习积累知识，现将学习到的知识记录一下，也是将我的所得分享给大家！而今天这篇文章《PostgreSQL SQL 迁移在 g0 上导致致命错误：morestack》带大家来了解一下##content_title##，希望对大家的知识积累有所帮助，从而弥补自己的不足，助力实战开发！

我尝试在我的 docker 容器内运行迁移，但在尝试运行迁移命令时出现以下错误

当我在没有迁移命令的情况下运行 docker compose up 时

/app/migrate -path  /app/migration -database "$db_source" -verbose up

应用程序构建良好，我的数据库源是

db_source = "postgresql://root:secret@localhost:5432/simple_bank?sslmode=disable"

simplebank-api-1       | run db migration 
simplebank-api-1       | fatal: morestack on g0
simplebank-api-1       | sigtrap: trace trap
simplebank-api-1       | pc=0x80a8242 m=1 sigcode=128
simplebank-api-1       | 
simplebank-api-1       | goroutine 0 [idle]:
simplebank-api-1       | runtime.abort()
simplebank-api-1       |    runtime/asm_386.s:847 +0x2
simplebank-api-1       | runtime.morestack()
simplebank-api-1       |    runtime/asm_386.s:422 +0x24
simplebank-api-1       | 
simplebank-api-1       | goroutine 1 [running, locked to thread]:
simplebank-api-1       |    goroutine running on other thread; stack unavailable
simplebank-api-1       | 
simplebank-api-1       | eax    0x17
simplebank-api-1       | ebx    0x2
simplebank-api-1       | ecx    0x8fabf6f
simplebank-api-1       | edx    0x17
simplebank-api-1       | edi    0x955cd6f
simplebank-api-1       | esi    0x9c003c0
simplebank-api-1       | ebp    0x98232c0
simplebank-api-1       | esp    0x9c4a630
simplebank-api-1       | eip    0x80a8242
simplebank-api-1       | eflags 0x206
simplebank-api-1       | cs     0x23
simplebank-api-1       | fs     0x0
simplebank-api-1       | gs     0x33
simplebank-api-1 exited with code 2

我的 docker 文件如下：

from golang:1.20-alpine3.16 as builder

workdir /app

copy . .

run go build -o main main.go
run apk add curl
run curl -l https://github.com/golang-migrate/migrate/releases/download/v4.15.2/migrate.linux-386.tar.gz   | tar xvz

#run

from alpine:3.16

workdir /app

copy --from=builder /app/main .
copy --from=builder /app/migrate ./migrate
copy app.env .
copy start.sh .
copy wait.sh .
copy db/migration ./migration

expose 8080

cmd ["/app/main"]
entrypoint ["/app/start.sh"]

我的start.sh是

#!/bin/sh
set -e
echo "run db migration "

/app/migrate -path  /app/migration -database "$db_source" -verbose up


echo "start the app"
exec  "$@"

并且 docker-compose.yaml 如下

version: "3.9"
services:
  postgres:
    image: postgres:15.2-alpine
    environment:
      - POSTGRES_USER=root
      - POSTGRES_PASSWORD=secret
      - POSTGRES_DB=simple_bank
  api:
    build:
      context: .
      dockerfile: Dockerfile
    ports:
        - "8080:8080"
    environment:
      - DB_SOURCE=postgresql://root:secret@postgres:5432/simple_bank?sslmode=disable
    depends_on:
      - postgres
    entrypoint: ["/app/wait.sh","postgres:5432" , "--", "/app/start.sh"]
    command: ["/app/main"]

正确答案

使用 migrate.linux-amd64.tar.gz 而不是 迁移.linux-386.tar.gz

文中关于的知识介绍，希望对你的学习有所帮助！若是受益匪浅，那就动动鼠标收藏这篇《PostgreSQL SQL 迁移在 g0 上导致致命错误：morestack》文章吧，也可关注golang学习网公众号了解相关技术文章。