failed to initialize database, got error failed to connect to `host=db user= database=`: dial error (dial tcp xxxx: connect: connection refused)

huangapple
go评论172阅读模式
英文:

failed to initialize database, got error failed to connect to `host=db user= database=`: dial error (dial tcp xxxx: connect: connection refused)

问题

每当我启动我的Docker容器服务时，都会出现“无法初始化”的错误。

  1. version: '3'
  3. services:
  4.   app:
  5.     container_name: api
  6.     build:
  7.       context: .
  8.       dockerfile: local.Dockerfile
  9.     ports:
  10.       - "9090:9090"
  11.       - "40000:40000"
  12.     security_opt:
  13.       - "seccomp:unconfined"
  14.     cap_add:
  15.       - SYS_PTRACE
  16.     restart: on-failure
  17.     environment:
  18.       PORT: 9090
  19.       DB_CONN: "postgres://admin:pass@db:5432/test?sslmode=disable"
  20.     volumes:
  21.       - .:/app
  22.     depends_on:
  23.       - db
  24.     links:
  25.       - db
  27.   db:
  28.     image: postgres
  29.     container_name: db
  30.     ports:
  31.       - "5432:5432"
  32.     environment:         
  33.       POSTGRES_USER: "admin"
  34.       POSTGRES_PASSWORD: "pass"
  35.       POSTGRES_DB: "test"
  36.       TZ: "UTC"
  37.       PGTZ: "UTC"
  38.     volumes:
  39.       - ./tmp:/var/lib/postgresql/data

我正在使用air进行实时重载，请找到air.toml文件。

  1. root="."
  2. tmp_dir="tmp"
  4. [build]
  5. cmd="go build -gcflags=\"all=-N -l\" -o ./bin/main ."
  6. bin="/app/bin"
  7. full_bin="/app/bin/main"
  8. log="air_errors.log"
  9. include_ext=["go", "yaml"]
  10. exclude_dir=["tmp"]
  11. delay=1000
  13. [log]
  14. time=true
  17. [misc]
  18. clean_on_exit=true
  1. func main() {
  2.     Instance, err = gorm.Open(postgres.Open(conn), &gorm.Config{
  3.         Logger: logger.New(
  4.             log.New(os.Stdout, "", log.LstdFlags), logger.Config{
  5.                 LogLevel: logger.Info,
  6.                 Colorful: true,
  7.             }),
  8.     })
  9.     if err != nil {
  10.         panic("Cannot connect to DB" + err.Error())
  11.     }
  12. }

如果您再次保存代码并使用air进行实时重载应用程序，则连接将建立。

英文:

I am getting the failed to initialize error whenever I start up my docker container service.

  1. version: '3'
  3. services:
  4.   app:
  5.     container_name: api
  6.     build:
  7.       context: .
  8.       dockerfile: local.Dockerfile
  9.     ports:
  10.       - "9090:9090"
  11.       - "40000:40000"
  12.     security_opt:
  13.       - "seccomp:unconfined"
  14.     cap_add:
  15.       - SYS_PTRACE
  16.     restart: on-failure
  17.     environment:
  18.       PORT: 9090
  19.       DB_CONN: "postgres://admin:pass@db:5432/test?sslmode=disable"
  20.     volumes:
  21.       - .:/app
  22.     depends_on:
  23.       - db
  24.     links:
  25.       - db
  27.   db:
  28.     image: postgres
  29.     container_name: db
  30.     ports:
  31.       - "5432:5432"
  32.     environment:         
  33.       POSTGRES_USER: "admin"
  34.       POSTGRES_PASSWORD: "pass"
  35.       POSTGRES_DB: "test"
  36.       TZ: "UTC"
  37.       PGTZ: "UTC"
  38.     volumes:
  39.       - ./tmp:/var/lib/postgresql/data

I am using air for live reload, please find the air.toml file

  1. root="."
  2. tmp_dir="tmp"
  4. [build]
  5. cmd="go build -gcflags=\"all=-N -l\" -o ./bin/main ."
  6. bin="/app/bin"
  7. full_bin="/app/bin/main"
  8. log="air_errors.log"
  9. include_ext=["go", "yaml"]
  10. exclude_dir=["tmp"]
  11. delay=1000
  13. [log]
  14. time=true
  17. [misc]
  18. clean_on_exit=true
  23. func main() {
  24.     Instance, err = gorm.Open(postgres.Open(conn), &gorm.Config{
  25.     		Logger: logger.New(
  26.     			log.New(os.Stdout, "", log.LstdFlags), logger.Config{
  27.     				LogLevel: logger.Info,
  28.     				Colorful: true,
  29.     			}),
  30.     	})
  31.     	if err != nil {
  32.     		panic("Cannot connect to DB" + err.Error())
  33.     	}
  34.     }

The connection gets established if you save the code again and air live reload the appliation

答案1

得分: 1

你需要等待postgres数据库初始化完成。

请查看https://docs.docker.com/compose/compose-file/compose-file-v3/#healthcheck

为db服务添加一个healthcheck：

  1. healthcheck:
  2.     test: ["CMD-SHELL", "pg_isready"]
  3.     interval: 10s
  4.     timeout: 5s
  5.     retries: 5

并将depend_on更改如下：

  1. depends_on:
  2.   db:
  3.     condition: service_healthy
英文:

You need to wait until the postgres database has been initialized.

Have a look at https://docs.docker.com/compose/compose-file/compose-file-v3/#healthcheck

Add a healthcheck for db service

  1. healthcheck:
  2.     test: ["CMD-SHELL", "pg_isready"]
  3.     interval: 10s
  4.     timeout: 5s
  5.     retries: 5

And change depend_on as below

  1. depends_on:
  2.   db:
  3.     condition: service_healthy

huangapple
  • 本文由 发表于 2022年12月16日 22:23:50
  • 转载请务必保留本文链接：https://go.coder-hub.com/74825752.html
  • database
  • go
  • postgresql
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定