替换Portal的镜像，重新部署temporal报错

[lxx181]

Portal部分在本地运行，服务可以起来，然后打成镜像上传到docker hub上了，最后使用docker compose部署的时候将CSGHub Portal的镜像替换成了我自己的，但是部署的时候 temporal就一直报错

[samchen8008]

请把报错信息或者截屏放入。

[lxx181]

ubuntu@ip-172-26-6-201:~/csghub$ sudo docker logs csghub-temporal-1 TEMPORAL_ADDRESS is not set, setting it to 192.171.100.122:7233 2025/08/18 13:02:41 Loading config; env=docker,zone=,configDir=config 2025/08/18 13:02:41 Loading config files=[config/docker.yaml] {"level":"info","ts":"2025-08-18T13:02:41.357Z","msg":"Build info.","git-time":"2024-10-10T20:14:19.000Z","git-revision":"5d99e200cc66bb22a0e78e69763422fb9441a0eb","git-modified":false,"go-arch":"amd64","go-os":"linux","go-version":"go1.22.3","cgo-enabled":false,"server-version":"1.25.1","debug-mode":false,"logging-call-at":"/home/runner/work/docker-builds/docker-builds/temporal/cmd/server/main.go:176"} {"level":"info","ts":"2025-08-18T13:02:41.358Z","msg":"Updated dynamic config","logging-call-at":"/home/runner/work/docker-builds/docker-builds/temporal/common/dynamicconfig/file_based_client.go:208"} {"level":"warn","ts":"2025-08-18T13:02:41.358Z","msg":"Not using any authorizer and flag `--allow-no-auth` not detected. Future versions will require using the flag `--allow-no-auth` if you do not want to set an authorizer.","logging-call-at":"/home/runner/work/docker-builds/docker-builds/temporal/cmd/server/main.go:206"} [Fx] PROVIDE fx.Lifecycle <= go.uber.org/fx.New.func1() [Fx] PROVIDE fx.Shutdowner <= go.uber.org/fx.(*App).shutdowner-fm() [Fx] PROVIDE fx.DotGraph <= go.uber.org/fx.(*App).dotGraph-fm() [Fx] PROVIDE *temporal.ServerImpl <= go.temporal.io/server/temporal.NewServerFxImpl() [Fx] PROVIDE *temporal.serverOptions <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE chan interface {} <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE temporal.synchronizationModeParams <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE *config.Config <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE *config.PProf <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE log.Config <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE resource.ServiceNames <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE resource.NamespaceLogger <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE resolver.ServiceResolver <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE client.AbstractDataStoreFactory <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE visibility.VisibilityStoreFactory <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE searchattribute.Mapper <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE []grpc.UnaryServerInterceptor <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE authorization.Authorizer <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE authorization.ClaimMapper <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE authorization.JWTAudienceMapper <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE map[primitives.ServiceName]static.Hosts <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE log.Logger <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE client.FactoryProvider <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE dynamicconfig.Client <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE encryption.TLSConfigProvider <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE *client.Config <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE client.Client <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE metrics.Handler <= go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] PROVIDE archiver.ArchivalMetadata <= go.temporal.io/server/common/resource.ArchivalMetadataProvider() [Fx] PROVIDE tasks.TaskCategoryRegistry <= go.temporal.io/server/temporal.TaskCategoryRegistryProvider() [Fx] PROVIDE client.FactoryProviderFn <= go.temporal.io/server/temporal.PersistenceFactoryProvider() [Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.HistoryServiceProvider() [Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.MatchingServiceProvider() [Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.FrontendServiceProvider() [Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.InternalFrontendServiceProvider() [Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.WorkerServiceProvider() [Fx] PROVIDE *cluster.Config <= go.temporal.io/server/temporal.ApplyClusterMetadataConfigProvider() [Fx] PROVIDE config.Persistence <= go.temporal.io/server/temporal.ApplyClusterMetadataConfigProvider() [Fx] PROVIDE *dynamicconfig.Collection <= go.temporal.io/server/common/dynamicconfig.init.func1() [Fx] PROVIDE pingable.Pingable[group = "deadlockDetectorRoots"] <= fx.Annotate(go.temporal.io/server/common/dynamicconfig.init.func2(), fx.ResultTags(["group:\"deadlockDetectorRoots\""]) [Fx] PROVIDE *pprof.PProfInitializerImpl <= go.temporal.io/server/common/pprof.NewInitializer() [Fx] PROVIDE []trace.SpanExporter <= go.temporal.io/server/temporal.init.func2() [Fx] SUPPLY []temporal.ServerOption [Fx] RUN supply: stub([]temporal.ServerOption) [Fx] RUN provide: go.temporal.io/server/temporal.ServerOptionsProvider() [Fx] Error returned: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider /home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184: sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found [Fx] ERROR Failed to initialize custom logger: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2 /home/runner/go/pkg/mod/go.uber.org/fx@v1.22.0/module.go:292: failed to build fxevent.Logger: could not build arguments for function "go.temporal.io/server/temporal".init.func8 /home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:1004: failed to build log.Logger: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider /home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184: sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found Unable to create server. Error: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2 (/home/runner/go/pkg/mod/go.uber.org/fx@v1.22.0/module.go:292): failed to build fxevent.Logger: could not build arguments for function "go.temporal.io/server/temporal".init.func8 (/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:1004): failed to build log.Logger: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider (/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184): sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found. ubuntu@ip-172-26-6-201:~/csghub$

[samchen8008]

貌似数据库没起来。

[samchen8008]

@Rader @KinglyWayne 辛苦看看

[lxx181]

ubuntu@ip-172-26-6-201:~/csghub$ sudo docker ps | grep postgres
a5c4de34d5d5 opencsg-registry.cn-beijing.cr.aliyuncs.com/opencsg_public/csghub/postgres:15.10 "docker-entrypoint.s…" 19 minutes ago Up 18 minutes (healthy) 5432/tcp csghub-postgres-1
数据起来了，但是Temporal 容器一致无法连接数据库

[Rader]

@lxx181 看日志temporal服务未识别到postgres数据库。

请贴一下docker compose配置文件里 csghub-postgres和csghub-temporal这两个服务的完整配置

[lxx181]

postgres:
image: ${CSGHUB_IMAGE_PREFIX}/csghub/postgres:15.10
depends_on:
fluentd:
condition: service_healthy
environment:
POSTGRES_USER: "$POSTGRES_USER"
POSTGRES_PASSWORD: "$POSTGRES_PASSWORD"
POSTGRES_MULTIPLE_DATABASES: "csghub_server,csghub_portal,casdoor,temporal"
volumes:
- ./data/postgresql/data:/var/lib/postgresql/data
restart: always
privileged: true
healthcheck:
test: [ "CMD", "pg_isready", "-U", "$POSTGRES_USER", "-h", "127.0.0.1"]
interval: 5s
deploy:
replicas: ${POSTGRES_ENABLED:-1}
logging:
driver: fluentd
options:
fluentd-address: localhost:24224
tag: postgres
networks:
opencsg:
ipv4_address: 192.171.100.104

temporal:
image: ${CSGHUB_IMAGE_PREFIX}/temporalio/auto-setup:1.25.1
depends_on:
postgres:
condition: service_healthy
restart: true
environment:
DB: "postgres12"
POSTGRES_SEEDS: "$POSTGRES_HOST"
DB_PORT: "$POSTGRES_PORT"
POSTGRES_USER: "$POSTGRES_USER"
POSTGRES_PASSWORD: "$POSTGRES_PASSWORD"
DEFAULT_NAMESPACE_RETENTION: "7d"
command: >
sh -c "
while ! ping -c 1 -W 1 postgres; do
echo 'Waiting for PostgreSQL...';
sleep 2;
done;
temporal-sql-tool --ep postgres -u csghub --pw 'Csghub@2025!' -p 5432 --db temporal --pl postgres setup-schema -v 0.0;
temporal-sql-tool --ep postgres -u csghub --pw 'Csghub@2025!' -p 5432 --db temporal --pl postgres setup-schema -v 1.0;
exec temporal-server start --env docker --cluster default
"
user: "root"
healthcheck:
test: [ "CMD-SHELL", "nc -z temporal 7233" ]
interval: 10s
timeout: 30s
retries: 30
logging:
driver: fluentd
options:
fluentd-address: localhost:24224
tag: temporal
networks:
opencsg:
ipv4_address: 192.171.100.122

[Rader]

POSTGRES_HOST 的值配置是什么？

[lxx181]

postgres

[MasonXon]

你是自定义了 temporal 的 entrypoint 是吗？替换掉了原有的 entrypoint.sh 的脚本？可以进入到 temporal 数据库看下\dt有什么内容吗?

[lxx181]

之前替换过entrypoint.sh，但是没解决问题。现在是将所有的容器清除，重新部署的，你看一下entrypoint.sh有问题吗？
ubuntu@ip-172-26-6-201:~/csghub$ sudo docker run -it --rm \

--volumes-from 625697b897b9
--name temp-temporal-debug
opencsg-registry.cn-beijing.cr.aliyuncs.com/opencsg_public/temporalio/auto-setup:1.25.1
bash
TEMPORAL_ADDRESS is not set, setting it to 172.17.0.5:7233
6286914ae925:/etc/temporal$ cat /etc/temporal/entrypoint.sh
#!/bin/bash

set -eu -o pipefail

: "${BIND_ON_IP:=$(getent hosts "$(hostname)" | awk '{print $1;}')}"
export BIND_ON_IP

if [[ "${BIND_ON_IP}" == "0.0.0.0" ]]; then
: "${TEMPORAL_BROADCAST_ADDRESS:=$(getent hosts "$(hostname)" | awk '{print $1;}')}"
export TEMPORAL_BROADCAST_ADDRESS
fi

check TEMPORAL_ADDRESS is not empty

if [[ -z "${TEMPORAL_ADDRESS:-}" ]]; then
echo "TEMPORAL_ADDRESS is not set, setting it to ${BIND_ON_IP}:7233"

if [[ "${BIND_ON_IP}" =~ ":" ]]; then
    # ipv6
    export TEMPORAL_ADDRESS="[${BIND_ON_IP}]:7233"
else
    # ipv4
    export TEMPORAL_ADDRESS="${BIND_ON_IP}:7233"
fi

fi

Support TEMPORAL_CLI_ADDRESS for backwards compatibility.

TEMPORAL_CLI_ADDRESS is deprecated and support for it will be removed in the future release.

if [[ -z "${TEMPORAL_CLI_ADDRESS:-}" ]]; then
export TEMPORAL_CLI_ADDRESS="${TEMPORAL_ADDRESS}"
fi

dockerize -template /etc/temporal/config/config_template.yaml:/etc/temporal/config/docker.yaml

Automatically setup Temporal Server (databases, Elasticsearch, default namespace) if "autosetup" is passed as an argument.

for arg; do
if [[ ${arg} == autosetup ]]; then
/etc/temporal/auto-setup.sh
break
fi
done

Setup Temporal Server in development mode if "develop" is passed as an argument.

for arg; do
if [[ ${arg} == develop ]]; then
/etc/temporal/setup-develop.sh
break
fi
done

Run bash instead of Temporal Server if "bash" is passed as an argument (convenient to debug docker image).

for arg; do
if [[ ${arg} == bash ]]; then
bash
exit 0
fi
done

exec /etc/temporal/start-temporal.sh
6286914ae925:/etc/temporal$

temporal 数据库是空的
ubuntu@ip-172-26-6-201:~/csghub$ sudo docker exec -it csghub-postgres-1 bash
root@a5c4de34d5d5:/# psql -U csghub -d temporal -W
Password:
psql (15.10 (Debian 15.10-1.pgdg120+1))
Type "help" for help.

temporal=# \dt
Did not find any relations.
temporal=#

[MasonXon]

temporal 的 entrypoint.sh 是否可以保持默认，看起来是 temporal 并没有做数据库初始化

[lxx181]

我清除了之前所有的文件，想在重新部署，现在应该是默认的

[lxx181]

好像核心问题不是数据库未初始化，而是 Temporal 容器根本无法建立数据库连接
ubuntu@ip-172-26-6-201:/csghub$ sudo docker logs csghub-temporal-1 | grep -i "error|fail"
2025/08/18 13:02:41 Loading config; env=docker,zone=,configDir=config
2025/08/18 13:02:41 Loading config files=[config/docker.yaml]
[Fx] PROVIDE fx.Lifecycle <= go.uber.org/fx.New.func1()
[Fx] PROVIDE fx.Shutdowner <= go.uber.org/fx.(*App).shutdowner-fm()
[Fx] PROVIDE fx.DotGraph <= go.uber.org/fx.(*App).dotGraph-fm()
[Fx] PROVIDE *temporal.ServerImpl <= go.temporal.io/server/temporal.NewServerFxImpl()
[Fx] PROVIDE *temporal.serverOptions <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE chan interface {} <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE temporal.synchronizationModeParams <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE *config.Config <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE *config.PProf <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE log.Config <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE resource.ServiceNames <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE resource.NamespaceLogger <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE resolver.ServiceResolver <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE client.AbstractDataStoreFactory <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE visibility.VisibilityStoreFactory <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE searchattribute.Mapper <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE []grpc.UnaryServerInterceptor <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE authorization.Authorizer <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE authorization.ClaimMapper <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE authorization.JWTAudienceMapper <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE map[primitives.ServiceName]static.Hosts <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE log.Logger <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE client.FactoryProvider <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE dynamicconfig.Client <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE encryption.TLSConfigProvider <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE *client.Config <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE client.Client <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE metrics.Handler <= go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] PROVIDE archiver.ArchivalMetadata <= go.temporal.io/server/common/resource.ArchivalMetadataProvider()
[Fx] PROVIDE tasks.TaskCategoryRegistry <= go.temporal.io/server/temporal.TaskCategoryRegistryProvider()
[Fx] PROVIDE client.FactoryProviderFn <= go.temporal.io/server/temporal.PersistenceFactoryProvider()
[Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.HistoryServiceProvider()
[Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.MatchingServiceProvider()
[Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.FrontendServiceProvider()
[Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.InternalFrontendServiceProvider()
[Fx] PROVIDE *temporal.ServicesMetadata[group = "services"] <= go.temporal.io/server/temporal.WorkerServiceProvider()
[Fx] PROVIDE *cluster.Config <= go.temporal.io/server/temporal.ApplyClusterMetadataConfigProvider()
[Fx] PROVIDE config.Persistence <= go.temporal.io/server/temporal.ApplyClusterMetadataConfigProvider()
[Fx] PROVIDE *dynamicconfig.Collection <= go.temporal.io/server/common/dynamicconfig.init.func1()
[Fx] PROVIDE pingable.Pingable[group = "deadlockDetectorRoots"] <= fx.Annotate(go.temporal.io/server/common/dynamicconfig.init.func2(), fx.ResultTags(["group:"deadlockDetectorRoots""])
[Fx] PROVIDE *pprof.PProfInitializerImpl <= go.temporal.io/server/common/pprof.NewInitializer()
[Fx] PROVIDE []trace.SpanExporter <= go.temporal.io/server/temporal.init.func2()
[Fx] SUPPLY []temporal.ServerOption
[Fx] RUN supply: stub([]temporal.ServerOption)
[Fx] RUN provide: go.temporal.io/server/temporal.ServerOptionsProvider()
[Fx] Error returned: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider
/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found
[Fx] ERROR Failed to initialize custom logger: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2
/home/runner/go/pkg/mod/go.uber.org/fx@v1.22.0/module.go:292:
failed to build fxevent.Logger:
could not build arguments for function "go.temporal.io/server/temporal".init.func8
/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:1004:
failed to build log.Logger:
received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider
/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184:
sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found
Unable to create server. Error: could not build arguments for function "go.uber.org/fx".(*module).constructCustomLogger.func2 (/home/runner/go/pkg/mod/go.uber.org/fx@v1.22.0/module.go:292): failed to build fxevent.Logger: could not build arguments for function "go.temporal.io/server/temporal".init.func8 (/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:1004): failed to build log.Logger: received non-nil error from function "go.temporal.io/server/temporal".ServerOptionsProvider (/home/runner/work/docker-builds/docker-builds/temporal/temporal/fx.go:184): sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found.
ubuntu@ip-172-26-6-201:/csghub$

[MasonXon]

你可以手动测试下 temporal 的数据库配置是否可以连接上数据库