WeKnora icon indicating copy to clipboard operation
WeKnora copied to clipboard
Published 17 hours ago • verified publisher icon Tencent

[Bug]: 自定义数据库用户名和密码出现 `FATAL: database "****" does not exist`

Open Sunhill666 opened this issue 2 months ago • 2 comments

相关组件

后端服务及API

Bug 描述

在 .env 中修改数据库用户名和数据库密码，启动后 WeKnora-postgres 容器报错 FATAL: database "qyai" does not exist。已尝试使用如下命令重新启动问题依旧：

.scripts/start_all.sh --stop
make clean-db
docker volume ls -q | xargs docker volume rm
.scripts/start_all.sh

期望行为

应该不报错

相关日志

WeKnora-app  | Using configuration file: /app/config/config.yaml
WeKnora-app  | [32mINFO [0m[2025-09-28 09:09:05.364] []                      | Ollama base URL: http://host.docker.internal:11434
WeKnora-app  | [DocReader] 2025/09/28 09:09:05.891816 INFO: Creating new DocReader client connecting to docreader:50051
WeKnora-app  | [DocReader] 2025/09/28 09:09:05.891906 INFO: Successfully connected to DocReader service in 80.936µs
WeKnora-app  | [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
WeKnora-app  |  - using env:	export GIN_MODE=release
WeKnora-app  |  - using code:	gin.SetMode(gin.ReleaseMode)
WeKnora-app  | 
WeKnora-app  | [GIN-debug] GET    /health                   --> github.com/Tencent/WeKnora/internal/router.NewRouter.func1 (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/auth/register     --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).Register-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/auth/login        --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).Login-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/auth/refresh      --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).RefreshToken-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/auth/validate     --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).ValidateToken-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/auth/logout       --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).Logout-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/auth/me           --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).GetCurrentUser-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/auth/change-password --> github.com/Tencent/WeKnora/internal/handler.(*AuthHandler).ChangePassword-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/tenants           --> github.com/Tencent/WeKnora/internal/handler.(*TenantHandler).CreateTenant-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/tenants/:id       --> github.com/Tencent/WeKnora/internal/handler.(*TenantHandler).GetTenant-fm (8 handlers)
WeKnora-app  | [GIN-debug] PUT    /api/v1/tenants/:id       --> github.com/Tencent/WeKnora/internal/handler.(*TenantHandler).UpdateTenant-fm (8 handlers)
WeKnora-app  | [GIN-debug] DELETE /api/v1/tenants/:id       --> github.com/Tencent/WeKnora/internal/handler.(*TenantHandler).DeleteTenant-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/tenants           --> github.com/Tencent/WeKnora/internal/handler.(*TenantHandler).ListTenants-fm (8 handlers)
WeKnora-app  | [GIN-debug] POST   /api/v1/knowledge-bases   --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).CreateKnowledgeBase-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/knowledge-bases   --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).ListKnowledgeBases-fm (8 handlers)
WeKnora-app  | [GIN-debug] GET    /api/v1/knowledge-bases/:id --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).GetKnowledgeBase-fm (8 handlers)
WeKnora-app  | [GIN-debug] PUT    /api/v1/knowledge-bases/:id --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).UpdateKnowledgeBase-fm (8 handlers)
WeKnora-app  | [GIN-debug] DELETE /api/v1/knowledge-bases/:id --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).DeleteKnowledgeBase-fm (8 handlers)
WeKnora-docreader  | Initializing server logging
WeKnora-docreader  | 2025-09-28 01:08:59.341 [no-req-id] INFO  __main__             | Initializing OCR engine with backend: paddle
WeKnora-docreader  | 2025-09-28 01:08:59.341 [no-req-id] INFO  parser.ocr_engine    | Initializing OCR engine with backend: paddle
WeKnora-postgres   | The files belonging to this database system will be owned by user "postgres".
WeKnora-docreader  | /usr/local/lib/python3.10/site-packages/paddle/utils/cpp_extension/extension_utils.py:718: UserWarning: No ccache found. Please be aware that recompiling all source files may be required. You can download and install ccache from: https://github.com/ccache/ccache/blob/master/doc/INSTALL.md
WeKnora-docreader  |   warnings.warn(warning_message)
WeKnora-docreader  | 2025-09-28 01:09:00.079 [no-req-id] INFO  parser.ocr_engine    | PaddleOCR engine initialized successfully
WeKnora-docreader  | 2025-09-28 01:09:00.079 [no-req-id] INFO  __main__             | OCR engine initialized successfully
WeKnora-docreader  | 2025-09-28 01:09:00.079 [no-req-id] INFO  __main__             | Starting DocReader service with 4 worker threads
WeKnora-postgres   | This user must also own the server process.
WeKnora-postgres   | 
WeKnora-postgres   | The database cluster will be initialized with locale "en_US.utf8".
WeKnora-postgres   | The default database encoding has accordingly been set to "UTF8".
WeKnora-postgres   | The default text search configuration will be set to "english".
WeKnora-postgres   | 
WeKnora-docreader  | 2025-09-28 01:09:00.083 [no-req-id] INFO  __main__             | Server started on port 50051
WeKnora-app        | [GIN-debug] GET    /api/v1/knowledge-bases/:id/hybrid-search --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).HybridSearch-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/knowledge-bases/copy --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeBaseHandler).CopyKnowledgeBase-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/knowledge-bases/:id/knowledge/file --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).CreateKnowledgeFromFile-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/knowledge-bases/:id/knowledge/url --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).CreateKnowledgeFromURL-fm (8 handlers)
WeKnora-postgres   | Data page checksums are disabled.
WeKnora-docreader  | 2025-09-28 01:09:00.083 [no-req-id] INFO  __main__             | Server is ready to accept connections
WeKnora-postgres   | 
WeKnora-postgres   | fixing permissions on existing directory /var/lib/postgresql/data ... ok
WeKnora-postgres   | creating subdirectories ... ok
WeKnora-postgres   | selecting dynamic shared memory implementation ... posix
WeKnora-postgres   | selecting default "max_connections" ... 100
WeKnora-postgres   | selecting default "shared_buffers" ... 128MB
WeKnora-postgres   | selecting default time zone ... Etc/UTC
WeKnora-postgres   | creating configuration files ... ok
WeKnora-postgres   | running bootstrap script ... ok
WeKnora-postgres   | performing post-bootstrap initialization ... ok
WeKnora-postgres   | initdb: warning: enabling "trust" authentication for local connections
WeKnora-app        | [GIN-debug] GET    /api/v1/knowledge-bases/:id/knowledge --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).ListKnowledge-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/knowledge/batch   --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).GetKnowledgeBatch-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/knowledge/:id     --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).GetKnowledge-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/knowledge/:id     --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).DeleteKnowledge-fm (8 handlers)
WeKnora-app        | [GIN-debug] PUT    /api/v1/knowledge/:id     --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).UpdateKnowledge-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/knowledge/:id/download --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).DownloadKnowledgeFile-fm (8 handlers)
WeKnora-app        | [GIN-debug] PUT    /api/v1/knowledge/image/:id/:chunk_id --> github.com/Tencent/WeKnora/internal/handler.(*KnowledgeHandler).UpdateImageInfo-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/chunks/:knowledge_id --> github.com/Tencent/WeKnora/internal/handler.(*ChunkHandler).ListKnowledgeChunks-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/chunks/:knowledge_id/:id --> github.com/Tencent/WeKnora/internal/handler.(*ChunkHandler).DeleteChunk-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/chunks/:knowledge_id --> github.com/Tencent/WeKnora/internal/handler.(*ChunkHandler).DeleteChunksByKnowledgeID-fm (8 handlers)
WeKnora-postgres   | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
WeKnora-postgres   | syncing data to disk ... ok
WeKnora-postgres   | 
WeKnora-app        | [GIN-debug] PUT    /api/v1/chunks/:knowledge_id/:id --> github.com/Tencent/WeKnora/internal/handler.(*ChunkHandler).UpdateChunk-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/sessions          --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).CreateSession-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/sessions/:id      --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).GetSession-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/sessions          --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).GetSessionsByTenant-fm (8 handlers)
WeKnora-app        | [GIN-debug] PUT    /api/v1/sessions/:id      --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).UpdateSession-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/sessions/:id      --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).DeleteSession-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/sessions/:session_id/generate_title --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).GenerateTitle-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/sessions/continue-stream/:session_id --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).ContinueStream-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/knowledge-chat/:session_id --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).KnowledgeQA-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/knowledge-search  --> github.com/Tencent/WeKnora/internal/handler.(*SessionHandler).SearchKnowledge-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/messages/:session_id/load --> github.com/Tencent/WeKnora/internal/handler.(*MessageHandler).LoadMessages-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/messages/:session_id/:id --> github.com/Tencent/WeKnora/internal/handler.(*MessageHandler).DeleteMessage-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/models            --> github.com/Tencent/WeKnora/internal/handler.(*ModelHandler).CreateModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/models            --> github.com/Tencent/WeKnora/internal/handler.(*ModelHandler).ListModels-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/models/:id        --> github.com/Tencent/WeKnora/internal/handler.(*ModelHandler).GetModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] PUT    /api/v1/models/:id        --> github.com/Tencent/WeKnora/internal/handler.(*ModelHandler).UpdateModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] DELETE /api/v1/models/:id        --> github.com/Tencent/WeKnora/internal/handler.(*ModelHandler).DeleteModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/evaluation/       --> github.com/Tencent/WeKnora/internal/handler.(*EvaluationHandler).Evaluation-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/evaluation/       --> github.com/Tencent/WeKnora/internal/handler.(*EvaluationHandler).GetEvaluationResult-fm (8 handlers)
WeKnora-postgres   | 
WeKnora-postgres   | Success. You can now start the database server using:
WeKnora-postgres   | 
WeKnora-postgres   |     pg_ctl -D /var/lib/postgresql/data -l logfile start
WeKnora-postgres   | 
WeKnora-postgres   | waiting for server to start....2025-09-28 01:08:59.756 UTC [48] LOG:  starting PostgreSQL 17.6 (Debian 17.6-2.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
WeKnora-postgres   | 2025-09-28 01:08:59.761 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
WeKnora-postgres   | 2025-09-28 01:08:59.777 UTC [51] LOG:  database system was shut down at 2025-09-28 01:08:59 UTC
WeKnora-postgres   | 2025-09-28 01:08:59.784 UTC [48] LOG:  database system is ready to accept connections
WeKnora-postgres   | 2025-09-28 01:08:59.786 UTC [54] LOG:  pg_cron scheduler started
WeKnora-postgres   |  done
WeKnora-postgres   | server started
WeKnora-app        | [GIN-debug] GET    /api/v1/initialization/config/:kbId --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).GetCurrentConfigByKB-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/initialize/:kbId --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).InitializeByKB-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/initialization/ollama/status --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).CheckOllamaStatus-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/initialization/ollama/models --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).ListOllamaModels-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/ollama/models/check --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).CheckOllamaModels-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/ollama/models/download --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).DownloadOllamaModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/initialization/ollama/download/progress/:taskId --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).GetDownloadProgress-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/initialization/ollama/download/tasks --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).ListDownloadTasks-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/remote/check --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).CheckRemoteModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/embedding/test --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).TestEmbeddingModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/rerank/check --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).CheckRerankModel-fm (8 handlers)
WeKnora-app        | [GIN-debug] POST   /api/v1/initialization/multimodal/test --> github.com/Tencent/WeKnora/internal/handler.(*InitializationHandler).TestMultimodalFunction-fm (8 handlers)
WeKnora-app        | [GIN-debug] GET    /api/v1/system/info       --> github.com/Tencent/WeKnora/internal/handler.(*SystemHandler).GetSystemInfo-fm (8 handlers)
WeKnora-app        | 2025/09/28 09:09:05.893048 main.go:92: Server is running at 0.0.0.0:8080
WeKnora-app        | [32mINFO [0m[2025-09-28 09:09:09.826] []                      | [6742ad6a-51a4-428d-83de-13afe902529b] 200 |  15 |      72.715µs |             ::1 | GET /health
WeKnora-app        | [32mINFO [0m[2025-09-28 09:09:39.902] []                      | [2a77d0c3-ef90-4d3f-9308-e87d710518f4] 200 |  15 |      96.513µs |             ::1 | GET /health
WeKnora-app        | [32mINFO [0m[2025-09-28 09:10:09.964] []                      | [c65191e2-e576-43aa-aa1c-34500a3ce6b9] 200 |  15 |        33.3µs |             ::1 | GET /health
WeKnora-postgres   | CREATE DATABASE
WeKnora-app        | [32mINFO [0m[2025-09-28 09:10:40.037] []                      | [bd99e611-c86e-46df-a7b9-a11807b69b54] 200 |  15 |      37.552µs |             ::1 | GET /health
WeKnora-app        | [32mINFO [0m[2025-09-28 09:11:10.110] []                      | [b3ff33a2-226e-4f6a-a68e-14f066e01a2a] 200 |  15 |      46.133µs |             ::1 | GET /health
WeKnora-postgres   | 
WeKnora-postgres   | 
WeKnora-postgres   | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/00-init-db.sql
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | ALTER SEQUENCE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | 
WeKnora-postgres   | 
WeKnora-postgres   | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/01-migrate-to-paradedb.sql
WeKnora-postgres   |  count 
WeKnora-postgres   | -------
WeKnora-postgres   |      0
WeKnora-postgres   | (1 row)
WeKnora-postgres   | 
WeKnora-postgres   |  count 
WeKnora-postgres   | -------
WeKnora-postgres   |      0
WeKnora-postgres   | (1 row)
WeKnora-postgres   | 
WeKnora-postgres   |  count 
WeKnora-postgres   | -------
WeKnora-postgres   |      0
WeKnora-postgres   | (1 row)
WeKnora-postgres   | 
WeKnora-postgres   |  count 
WeKnora-postgres   | -------
WeKnora-postgres   |      0
WeKnora-postgres   | (1 row)
WeKnora-postgres   | 
WeKnora-postgres   | CREATE TABLE
WeKnora-postgres   | CREATE INDEX
WeKnora-postgres   | INSERT 0 5
WeKnora-postgres   | INSERT 0 1
WeKnora-postgres   | 
WeKnora-postgres   | 
WeKnora-postgres   | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/10_bootstrap_paradedb.sh
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | Loading ParadeDB extensions into template1
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | Loading ParadeDB extensions into WeKnora
WeKnora-postgres   | NOTICE:  extension "pg_search" already exists, skipping
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | NOTICE:  extension "vector" already exists, skipping
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | CREATE EXTENSION
WeKnora-postgres   | Adding 'paradedb' search_path to template1
WeKnora-postgres   | ALTER DATABASE
WeKnora-postgres   | Adding 'paradedb' search_path to WeKnora
WeKnora-postgres   | ALTER DATABASE
WeKnora-postgres   | ParadeDB bootstrap completed!
WeKnora-postgres   | 
WeKnora-postgres   | 2025-09-28 01:09:00.844 UTC [48] LOG:  received fast shutdown request
WeKnora-postgres   | waiting for server to shut down....2025-09-28 01:09:00.849 UTC [48] LOG:  aborting any active transactions
WeKnora-postgres   | 2025-09-28 01:09:00.849 UTC [54] LOG:  pg_cron scheduler shutting down
WeKnora-postgres   | 2025-09-28 01:09:00.851 UTC [48] LOG:  background worker "pg_cron launcher" (PID 54) exited with exit code 1
WeKnora-postgres   | 2025-09-28 01:09:00.851 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
WeKnora-postgres   | 2025-09-28 01:09:00.852 UTC [49] LOG:  shutting down
WeKnora-postgres   | 2025-09-28 01:09:00.856 UTC [49] LOG:  checkpoint starting: shutdown immediate
WeKnora-postgres   | .2025-09-28 01:09:02.365 UTC [49] LOG:  checkpoint complete: wrote 4106 buffers (25.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.044 s, sync=1.438 s, total=1.514 s; sync files=941, longest=0.007 s, average=0.002 s; distance=33871 kB, estimate=33871 kB; lsn=0/35F8E38, redo lsn=0/35F8E38
WeKnora-postgres   | 2025-09-28 01:09:02.380 UTC [48] LOG:  database system is shut down
WeKnora-postgres   |  done
WeKnora-postgres   | server stopped
WeKnora-postgres   | 
WeKnora-postgres   | PostgreSQL init process complete; ready for start up.
WeKnora-postgres   | 
WeKnora-postgres   | 2025-09-28 01:09:02.490 UTC [1] LOG:  starting PostgreSQL 17.6 (Debian 17.6-2.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
WeKnora-postgres   | 2025-09-28 01:09:02.490 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
WeKnora-postgres   | 2025-09-28 01:09:02.490 UTC [1] LOG:  listening on IPv6 address "::", port 5432
WeKnora-postgres   | 2025-09-28 01:09:02.501 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
WeKnora-postgres   | 2025-09-28 01:09:02.517 UTC [80] LOG:  database system was shut down at 2025-09-28 01:09:02 UTC
WeKnora-postgres   | 2025-09-28 01:09:02.533 UTC [1] LOG:  database system is ready to accept connections
WeKnora-postgres   | 2025-09-28 01:09:02.544 UTC [83] LOG:  pg_cron scheduler started
WeKnora-postgres   | 2025-09-28 01:09:04.079 UTC [92] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:09:14.143 UTC [101] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:09:24.238 UTC [110] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:09:34.333 UTC [118] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:09:44.415 UTC [127] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:09:54.507 UTC [135] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:04.598 UTC [144] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:14.675 UTC [152] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:24.786 UTC [161] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:34.892 UTC [169] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:44.977 UTC [178] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:10:55.070 UTC [186] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:11:05.170 UTC [195] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:11:15.274 UTC [203] FATAL:  database "qyai" does not exist
WeKnora-postgres   | 2025-09-28 01:11:25.360 UTC [212] FATAL:  database "qyai" does not exist

操作系统

Ubuntu 24.04.2 LTS

确认事项

  • [x] 我已经搜索了现有的 issues，确认这是一个新问题

Sunhill666 avatar Sep 28 '25 01:09 Sunhill666

使用默认值可以启动成功

Sunhill666 avatar Sep 28 '25 01:09 Sunhill666

在本地尝试未复现该问题 修改.env文件中环境变量DB_NAME=qyai 重新启动后服务正常，日志没有报错，WeKnora-postgres中存在qyai数据库

begoniezhao avatar Oct 21 '25 11:10 begoniezhao