Error: Failed to execute ./scripts/02_seed_space_resources.sql

Open leixc-X opened this issue 3 months ago • 4 comments

看起来像是数据库初始化的问题怎么修改sql初始化的脚本？

root@707e773272ea:/# csghub-ctl status run: accounting: (pid 3007) 1906s; run: log: (pid 2194) 1907s run: casdoor: (pid 2912) 1906s; run: log: (pid 2193) 1907s run: dataviewer: (pid 3696) 1905s; run: log: (pid 2180) 1907s run: dnsmasq: (pid 2213) 1907s; run: log: (pid 2206) 1907s run: gitaly: (pid 2218) 1907s; run: log: (pid 2211) 1907s run: gitlab_shell: (pid 2223) 1907s; run: log: (pid 2217) 1907s run: minio: (pid 2195) 1907s; run: log: (pid 2189) 1907s run: mirror_lfs: (pid 3737) 1905s; run: log: (pid 2201) 1907s run: mirror_repo: (pid 3738) 1905s; run: log: (pid 2185) 1907s run: nats: (pid 2184) 1907s; run: log: (pid 2178) 1907s run: nginx: (pid 2187) 1907s; run: log: (pid 2179) 1907s run: notification: (pid 3119) 1906s; run: log: (pid 2200) 1907s run: portal: (pid 2930) 1906s; run: log: (pid 2181) 1907s run: postgresql: (pid 2190) 1907s; run: log: (pid 2182) 1907s run: redis: (pid 2209) 1907s; run: log: (pid 2199) 1907s run: registry: (pid 2183) 1907s; run: log: (pid 2174) 1907s run: rproxy: (pid 3087) 1906s; run: log: (pid 2171) 1907s run: runner: (pid 3108) 1906s; run: log: (pid 2210) 1907s run: server: (pid 101748) 0s; run: log: (pid 2169) 1907s run: temporal: (pid 2196) 1907s; run: log: (pid 2191) 1907s run: user: (pid 3711) 1905s; run: log: (pid 2205) 1907s root@707e773272ea:/# csghub-ctl tail 2025/09/04 08:30:02 Tailing log for service * from /var/log/csghub/*/current... ==> /var/log/csghub/accounting/current <== 2025-09-04_07:58:06.54534 Starting server... 2025-09-04_07:58:06.61121 init logger, level: INFO, format: json 2025-09-04_07:58:06.61254 {"time":"2025-09-04T07:58:06.612472663Z","level":"INFO","msg":"failed to initialize databasepinging pg database: dial tcp 127.0.0.1:5432: connect: connection refused"} 2025-09-04_07:58:07.61863 Starting server... 2025-09-04_07:58:07.70852 init logger, level: INFO, format: json 2025-09-04_07:58:07.83072 {"time":"2025-09-04T07:58:07.830658252Z","level":"INFO","msg":"http server is running","port":8086}

==> /var/log/csghub/agentic/current <== 2025-09-04_07:49:23.69515 DEBUG | [Factory gitlab_agent] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69522 DEBUG | [Factory gitlab_agent.codereview] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69528 DEBUG | [Factory gitlab_agent.mr_agent] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69534 DEBUG | [Factory gitlab_agent.mr_pipeline_agent] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69541 DEBUG | [Factory gitlab_agent.gitlab_ci] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69547 DEBUG | [Factory gitlab_notification_agent] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69553 DEBUG | [Factory gitlab_notification_center] Received a message: {'header': {'type': 'Started', 'content_type': 'application/json', 'extensions': {}}, 'reply': None, 'content': b''} 2025-09-04_07:49:23.69587 [2025-09-04 07:49:23 +0000] [3241] [INFO] Running on http://127.0.0.1:8184/ (CTRL + C to quit) 2025-09-04_07:49:23.69963 [09/04/25 07:49:23] INFO Running on http://127.0.0.1:8184/ logging.py:106 2025-09-04_07:49:23.69964 (CTRL + C to quit)

==> /var/log/csghub/casdoor/current <== 2025-09-04_07:58:07.73826 You are now connected to database "casdoor" as user "casdoor". 2025-09-04_07:58:07.74330 DO 2025-09-04_07:58:07.74443 DO 2025-09-04_07:58:07.74626 DO 2025-09-04_07:58:07.74759 DO 2025-09-04_07:58:07.74792 2025-09-04_07:58:07.74793 Successfully executed all SQL files! 2025-09-04_07:58:08.33449 2025/09/04 07:58:08 Starting Radius server on 0.0.0.0:1812 2025-09-04_07:58:08.33475 2025/09/04 07:58:08 Listening on 0.0.0.0:389 2025-09-04_07:58:08.34649 2025/09/04 07:58:08.346 [I] http server Running on http://:8087

==> /var/log/csghub/dataviewer/current <== 2025-09-04_07:58:06.66277 {"time":"2025-09-04T07:58:06.662694051Z","level":"INFO","msg":"failed to initialize databasepinging pg database: FATAL: the database system is starting up (SQLSTATE=57P03)"} 2025-09-04_07:58:07.66997 Starting server... 2025-09-04_07:58:07.73606 init logger, level: INFO, format: json 2025-09-04_07:58:07.74156 Error: unable to create workflow client, error: failed reaching server: connection error: desc = "transport: Error while dialing: dial tcp 127.0.0.1:7233: connect: connection refused" 2025-09-04_07:58:08.74961 Starting server... 2025-09-04_07:58:08.84736 init logger, level: INFO, format: json 2025-09-04_07:58:08.87733 {"time":"2025-09-04T07:58:08.877148278Z","level":"INFO","msg":"run viewer worker","options":{"Host":"http://localhost","Port":8093,"MaxConcurrentActivityExecutionSize":5,"MaxConcurrentLocalActivityExecutionSize":10,"MaxConcurrentWorkflowTaskExecutionSize":2,"ActivityStartToCloseTimeout":7200,"ActivityMaximumAttempts":2,"CacheDir":"","DownloadLfsFile":true,"MaxThreadNumOfExport":8,"MaxConcurrentSessionExecutionSize":1,"SessionExecutionTimeout":240,"ConvertLimitSize":5368709120}} 2025-09-04_07:58:09.29951 {"time":"2025-09-04T07:58:09.299449816Z","level":"INFO","msg":"Starting session worker","Namespace":"default","TaskQueue":"data_viewer_queue_dataset_update","WorkerID":"3696@707e773272ea@"} 2025-09-04_07:58:09.30269 {"time":"2025-09-04T07:58:09.30258482Z","level":"INFO","msg":"Started Worker","Namespace":"default","TaskQueue":"data_viewer_queue_dataset_update","WorkerID":"3696@707e773272ea@"} 2025-09-04_07:58:09.30276 {"time":"2025-09-04T07:58:09.302710095Z","level":"INFO","msg":"dataviewer http server is running","port":8093}

==> /var/log/csghub/dnsmasq/current <== 2025-09-04_07:58:06.55207 ./pre-start: line 19: setcap: command not found 2025-09-04_07:58:06.55448 dnsmasq: started, version 2.91 cachesize 150 2025-09-04_07:58:06.55450 dnsmasq: compile time options: IPv6 GNU-getopt no-DBus no-UBus no-i18n no-IDN DHCP DHCPv6 no-Lua TFTP no-conntrack ipset no-nftset auth no-DNSSEC loop-detect inotify dumpfile 2025-09-04_07:58:06.55451 dnsmasq: reading /etc/resolv.conf 2025-09-04_07:58:06.55452 dnsmasq: ignoring nameserver 127.0.0.1 - local interface 2025-09-04_07:58:06.55453 dnsmasq: using nameserver 127.0.0.11#53 2025-09-04_07:58:06.55456 dnsmasq: read /etc/hosts - 9 names

==> /var/log/csghub/gitaly/current <== 2025-09-04_07:58:06.90741 {"duration_ms":138,"level":"info","msg":"Started Gitaly","pid":2419,"time":"2025-09-04T07:58:06.907Z"} 2025-09-04_07:58:06.90762 {"level":"info","msg":"maintenance: daily scheduled","pid":2419,"scheduled":"2025-09-04T23:30:00Z","time":"2025-09-04T07:58:06.907Z"} 2025-09-04_07:58:06.90807 {"counting_duration_ms":0,"level":"info","msg":"completed counting repositories","pid":2419,"storage_path":"/var/opt/csghub/gitaly/repositories","time":"2025-09-04T07:58:06.908Z"} 2025-09-04_07:58:06.90809 {"counting_duration":1,"level":"info","msg":"completed counting all repositories","pid":2419,"time":"2025-09-04T07:58:06.908Z"} 2025-09-04_07:58:07.77897 {"component":"backchannel.YamuxServer","level":"info","msg":"[ERR] yamux: Failed to read stream data: read tcp 127.0.0.1:8075-\u003e127.0.0.1:57184: read: connection reset by peer","pid":2419,"time":"2025-09-04T07:58:07.778Z"} 2025-09-04_07:58:07.77904 {"level":"warning","msg":"[core] [Channel https://github.com/OpenCSGs/csghub/pull/53 SubChannel https://github.com/OpenCSGs/csghub/pull/54]grpc: addrConn.createTransport failed to connect to {Addr: "multiplexed/127.0.0.1:57190", ServerName: "multiplexed%2F127.0.0.1:57190", }. Err: connection error: desc = "error reading server preface: EOF"","pid":2419,"system":"system","time":"2025-09-04T07:58:07.778Z"} 2025-09-04_07:58:07.77912 {"component":"backchannel.YamuxServer","level":"info","msg":"[ERR] yamux: Failed to write header: write tcp 127.0.0.1:8075-\u003e127.0.0.1:57184: use of closed network connection","pid":2419,"time":"2025-09-04T07:58:07.779Z"} 2025-09-04_07:58:07.78404 {"level":"warning","msg":"[core] [Channel https://github.com/OpenCSGs/csghub/pull/73 SubChannel https://github.com/OpenCSGs/csghub/pull/75]grpc: addrConn.createTransport failed to connect to {Addr: "multiplexed/127.0.0.1:57254", ServerName: "multiplexed%2F127.0.0.1:57254", }. Err: connection error: desc = "error reading server preface: EOF"","pid":2419,"system":"system","time":"2025-09-04T07:58:07.784Z"} 2025-09-04_07:58:07.78408 {"level":"warning","msg":"[core] [Channel https://github.com/OpenCSGs/csghub/pull/74 SubChannel https://github.com/OpenCSGs/csghub/pull/76]grpc: addrConn.createTransport failed to connect to {Addr: "multiplexed/127.0.0.1:57268", ServerName: "multiplexed%2F127.0.0.1:57268", }. Err: connection error: desc = "error reading server preface: EOF"","pid":2419,"system":"system","time":"2025-09-04T07:58:07.784Z"} 2025-09-04_07:58:09.86626 {"duration_ms":3097,"level":"info","msg":"License database preloaded","pid":2419,"time":"2025-09-04T07:58:09.866Z"}

==> /var/log/csghub/gitlab_shell/current <== 2025-09-04_07:58:06.54912 Using existing Host Keys 2025-09-04_07:58:06.57301 {"error":"open /var/log/csghub/gitlab_shell/gitlab-shell.log: permission denied","level":"warning","log_file":"stdout","msg":"Unable to configure logging, falling back to STDOUT","time":"2025-09-04T07:58:06Z"} 2025-09-04_07:58:06.57383 {"correlation_id":"01K49VQ77DW1HB7NGQ8FW468XB","level":"info","msg":"Listening for SSH connections","supported_public_key_algorithms":["ssh-rsa","ssh-dss","ecdsa-sha2-nistp256","[email protected]","ecdsa-sha2-nistp384","ecdsa-sha2-nistp521","ssh-ed25519","[email protected]","rsa-sha2-256","rsa-sha2-512"],"tcp_address":"[::]:2222","time":"2025-09-04T07:58:06Z"}

==> /var/log/csghub/minio/current <== 2025-09-04_07:58:07.15114 {"level":"INFO","time":"2025-09-04T07:58:07.150847781Z","message":"MinIO Object Storage Server"} 2025-09-04_07:58:07.15128 {"level":"INFO","time":"2025-09-04T07:58:07.151126036Z","message":"Copyright: 2015-2025 MinIO, Inc.\nLicense: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html\nVersion: RELEASE.2025-03-12T18-04-18Z (go1.24.1 linux/amd64)\n"} 2025-09-04_07:58:07.15131 {"level":"INFO","time":"2025-09-04T07:58:07.151182906Z","message":"API: http://172.27.0.2:9000/ http://127.0.0.1:9000/ "} 2025-09-04_07:58:07.15132 {"level":"INFO","time":"2025-09-04T07:58:07.151217423Z","message":"WebUI: http://172.27.0.2:9002/ http://127.0.0.1:9002/ "} 2025-09-04_07:58:07.15132 {"level":"INFO","time":"2025-09-04T07:58:07.151236121Z","message":"\nDocs: https://docs.min.io"}/ 2025-09-04_07:58:07.53725 {"level":"INFO","time":"2025-09-04T07:58:07.537223457Z","message":"You are running an older version of MinIO released 4 months before the latest release, update: Run mc admin update ALIAS"}

==> /var/log/csghub/mirror_lfs/current <== 2025-09-04_08:29:15.75292 {"time":"2025-09-04T08:29:15.75285674Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:20.75701 {"time":"2025-09-04T08:29:20.756941173Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:25.76085 {"time":"2025-09-04T08:29:25.760775794Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:30.76446 {"time":"2025-09-04T08:29:30.764376124Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:35.76902 {"time":"2025-09-04T08:29:35.76895322Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:40.77255 {"time":"2025-09-04T08:29:40.772490512Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:45.77603 {"time":"2025-09-04T08:29:45.775962842Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:50.77965 {"time":"2025-09-04T08:29:50.779580578Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:55.78328 {"time":"2025-09-04T08:29:55.78320576Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:30:00.78682 {"time":"2025-09-04T08:30:00.786752151Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"}

==> /var/log/csghub/mirror_repo/current <== 2025-09-04_08:29:15.88192 {"time":"2025-09-04T08:29:15.881854283Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:20.88515 {"time":"2025-09-04T08:29:20.885083419Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:25.88969 {"time":"2025-09-04T08:29:25.889619794Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:30.89237 {"time":"2025-09-04T08:29:30.892306356Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:35.89637 {"time":"2025-09-04T08:29:35.896297185Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:40.89999 {"time":"2025-09-04T08:29:40.899900909Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:45.90389 {"time":"2025-09-04T08:29:45.903824903Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:50.90825 {"time":"2025-09-04T08:29:50.908173667Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:29:55.91200 {"time":"2025-09-04T08:29:55.911933485Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"} 2025-09-04_08:30:00.91558 {"time":"2025-09-04T08:30:00.915519305Z","level":"INFO","msg":"no tasks to dispatch, sleep 5s"}

==> /var/log/csghub/nats/current <== 2025-09-04_07:58:06.56479 [2184] 2025/09/04 07:58:06.564770 [INF] Restored 0 messages for stream '$G > normalPriorityMsgStream' in 0s 2025-09-04_07:58:06.56485 [2184] 2025/09/04 07:58:06.564851 [INF] Starting restore for stream '$G > siteInternalMailStream' 2025-09-04_07:58:06.56513 [2184] 2025/09/04 07:58:06.565123 [INF] Restored 0 messages for stream '$G > siteInternalMailStream' in 0s 2025-09-04_07:58:06.56519 [2184] 2025/09/04 07:58:06.565184 [INF] Recovering 1 consumers for stream - '$G > deployServiceUpdateStream' 2025-09-04_07:58:06.56565 [2184] 2025/09/04 07:58:06.565641 [INF] Recovering 1 consumers for stream - '$G > highPriorityMsgStream' 2025-09-04_07:58:06.56583 [2184] 2025/09/04 07:58:06.565830 [INF] Recovering 1 consumers for stream - '$G > meteringEventStream' 2025-09-04_07:58:06.56608 [2184] 2025/09/04 07:58:06.566077 [INF] Recovering 1 consumers for stream - '$G > normalPriorityMsgStream' 2025-09-04_07:58:06.56629 [2184] 2025/09/04 07:58:06.566289 [INF] Recovering 1 consumers for stream - '$G > siteInternalMailStream' 2025-09-04_07:58:06.56658 [2184] 2025/09/04 07:58:06.566580 [INF] Listening for client connections on 0.0.0.0:4222 2025-09-04_07:58:06.56697 [2184] 2025/09/04 07:58:06.566956 [INF] Server is ready

==> /var/log/csghub/nginx/current <== 2025-09-04_08:26:00.33031 2025/09/04 08:26:00 [error] 2464#2464: *48 connect() failed (111: Connection refused) while connecting to upstream, client: 10.16.110.29, server: 10.55.3.5, request: "POST /api/v1/events HTTP/1.1", upstream: "http://127.0.0.1:8080/api/v1/events", host: "10.55.3.5", referrer: "http://10.55.3.5/models" 2025-09-04_08:26:00.33037 {"remote_addr":"10.16.110.29","remote_user":"","time_local":"04/Sep/2025:08:26:00 +0000","request":"POST /api/v1/events HTTP/1.1","status":"502","body_bytes_sent":"2415","http_referer":"http://10.55.3.5/models","http_user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36","http_x_forwarded_for":"","upstream_addr":"127.0.0.1:8080","upstream_status":"502","request_time":0.000,"upstream_response_time":0.000,"host":"10.55.3.5"} 2025-09-04_08:28:08.26151 2025/09/04 08:28:08 [error] 2464#2464: *48 connect() failed (111: Connection refused) while connecting to upstream, client: 10.16.110.29, server: 10.55.3.5, request: "GET /api/v1/notifications/count HTTP/1.1", upstream: "http://127.0.0.1:8080/api/v1/notifications/count", host: "10.55.3.5", referrer: "http://10.55.3.5/models" 2025-09-04_08:28:08.26170 {"remote_addr":"10.16.110.29","remote_user":"","time_local":"04/Sep/2025:08:28:08 +0000","request":"GET /api/v1/notifications/count HTTP/1.1","status":"502","body_bytes_sent":"2415","http_referer":"http://10.55.3.5/models","http_user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36","http_x_forwarded_for":"","upstream_addr":"127.0.0.1:8080","upstream_status":"502","request_time":0.000,"upstream_response_time":0.000,"host":"10.55.3.5"} 2025-09-04_08:28:08.26234 2025/09/04 08:28:08 [error] 2464#2464: *47 connect() failed (111: Connection refused) while connecting to upstream, client: 10.16.110.29, server: 10.55.3.5, request: "GET /api/v1/notifications/poll/1?timezone=Asia/Shanghai HTTP/1.1", upstream: "http://127.0.0.1:8080/api/v1/notifications/poll/1?timezone=Asia/Shanghai", host: "10.55.3.5", referrer: "http://10.55.3.5/models" 2025-09-04_08:28:08.26241 {"remote_addr":"10.16.110.29","remote_user":"","time_local":"04/Sep/2025:08:28:08 +0000","request":"GET /api/v1/notifications/poll/1?timezone=Asia/Shanghai HTTP/1.1","status":"502","body_bytes_sent":"2415","http_referer":"http://10.55.3.5/models","http_user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36","http_x_forwarded_for":"","upstream_addr":"127.0.0.1:8080","upstream_status":"502","request_time":0.000,"upstream_response_time":0.000,"host":"10.55.3.5"} 2025-09-04_08:28:08.33131 2025/09/04 08:28:08 [error] 2464#2464: *48 connect() failed (111: Connection refused) while connecting to upstream, client: 10.16.110.29, server: 10.55.3.5, request: "POST /api/v1/events HTTP/1.1", upstream: "http://127.0.0.1:8080/api/v1/events", host: "10.55.3.5", referrer: "http://10.55.3.5/models" 2025-09-04_08:28:08.33150 {"remote_addr":"10.16.110.29","remote_user":"","time_local":"04/Sep/2025:08:28:08 +0000","request":"POST /api/v1/events HTTP/1.1","status":"502","body_bytes_sent":"2415","http_referer":"http://10.55.3.5/models","http_user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36","http_x_forwarded_for":"","upstream_addr":"127.0.0.1:8080","upstream_status":"502","request_time":0.000,"upstream_response_time":0.000,"host":"10.55.3.5"} 2025-09-04_08:28:08.33164 2025/09/04 08:28:08 [error] 2464#2464: *47 connect() failed (111: Connection refused) while connecting to upstream, client: 10.16.110.29, server: 10.55.3.5, request: "POST /api/v1/events HTTP/1.1", upstream: "http://127.0.0.1:8080/api/v1/events", host: "10.55.3.5", referrer: "http://10.55.3.5/models" 2025-09-04_08:28:08.33173 {"remote_addr":"10.16.110.29","remote_user":"","time_local":"04/Sep/2025:08:28:08 +0000","request":"POST /api/v1/events HTTP/1.1","status":"502","body_bytes_sent":"2415","http_referer":"http://10.55.3.5/models","http_user_agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36","http_x_forwarded_for":"","upstream_addr":"127.0.0.1:8080","upstream_status":"502","request_time":0.000,"upstream_response_time":0.000,"host":"10.55.3.5"}

==> /var/log/csghub/notification/current <== 2025-09-04_07:58:07.87334 {"time":"2025-09-04T07:58:07.87323508Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":15} 2025-09-04_07:58:07.87334 {"time":"2025-09-04T07:58:07.87323872Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":16} 2025-09-04_07:58:07.87335 {"time":"2025-09-04T07:58:07.873201331Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":18} 2025-09-04_07:58:07.87335 {"time":"2025-09-04T07:58:07.873246552Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":8} 2025-09-04_07:58:07.87336 {"time":"2025-09-04T07:58:07.87325138Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":6} 2025-09-04_07:58:07.87337 {"time":"2025-09-04T07:58:07.873247375Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":10} 2025-09-04_07:58:07.87338 {"time":"2025-09-04T07:58:07.873240184Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":0} 2025-09-04_07:58:07.87338 {"time":"2025-09-04T07:58:07.87323602Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":1} 2025-09-04_07:58:07.87339 {"time":"2025-09-04T07:58:07.873265555Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":7} 2025-09-04_07:58:07.87339 {"time":"2025-09-04T07:58:07.87328891Z","level":"INFO","msg":"message dispatcher started","dispatcher_id":11}

==> /var/log/csghub/portal/current <== 2025-09-04_08:17:03.28223 {"time":"2025-09-04T08:17:03.282192467Z","level":"INFO","msg":"assets request","/assets/zhHant-D4ojFWZk.css":0} 2025-09-04_08:17:03.29030 {"time":"2025-09-04T08:17:03.290276271Z","level":"INFO","msg":"assets request","/assets/lodash-CUM784Py.js":0} 2025-09-04_08:17:03.29067 {"time":"2025-09-04T08:17:03.290623572Z","level":"INFO","msg":"assets request","/assets/components-BR-wKlBP.css":0} 2025-09-04_08:17:03.29068 {"time":"2025-09-04T08:17:03.290638937Z","level":"INFO","msg":"assets request","/assets/element-plus-C6wo0AKd.css":0} 2025-09-04_08:17:03.32783 {"time":"2025-09-04T08:17:03.327794006Z","level":"INFO","msg":"assets request","/assets/vendor-DxeqvKnK.js":2} 2025-09-04_08:17:03.35816 {"time":"2025-09-04T08:17:03.358135941Z","level":"INFO","msg":"assets request","/assets/element-plus-DWkN6ha2.js":1} 2025-09-04_08:17:03.44881 {"time":"2025-09-04T08:17:03.448791334Z","level":"INFO","msg":"assets request","/assets/zhHant-BnzEFRMx.js":0} 2025-09-04_08:17:03.44973 {"time":"2025-09-04T08:17:03.449701462Z","level":"INFO","msg":"assets request","/assets/components-D5tbeXZT.js":1} 2025-09-04_08:17:03.49771 {"time":"2025-09-04T08:17:03.49768504Z","level":"INFO","msg":"assets request","/assets/main-BNctXl3I.js":0} 2025-09-04_08:25:39.60689 {"time":"2025-09-04T08:25:39.606768573Z","level":"INFO","msg":"Portal Request","ip":"127.0.0.1","method":"GET","latency(ms)":0,"status":200,"current_user":"","url":"/"}

==> /var/log/csghub/postgresql/current <== 2025-09-04_08:30:02.22836 LIMIT 1) 2025-09-04_08:30:02.22837 INSERT INTO public.space_resources (id, name, resources, cluster_id) 2025-09-04_08:30:02.22837 VALUES 2025-09-04_08:30:02.22838 (1, 'CPU basic · 0.5 vCPU · 1 GB', '{ "cpu": { "type": "Intel", "num": "0.5" }, "memory": "1Gi" }', (SELECT cluster_id FROM selected_cluster)), 2025-09-04_08:30:02.22839 (2, 'CPU basic · 2 vCPU · 4 GB', '{ "cpu": { "type": "Intel", "num": "2" }, "memory": "4Gi" }', (SELECT cluster_id FROM selected_cluster)) 2025-09-04_08:30:02.22839 ON CONFLICT (id) 2025-09-04_08:30:02.22840 DO UPDATE SET 2025-09-04_08:30:02.22841 name = EXCLUDED.name, 2025-09-04_08:30:02.22841 resources = EXCLUDED.resources, 2025-09-04_08:30:02.22843 cluster_id = EXCLUDED.cluster_id;

==> /var/log/csghub/producer/current <== 2025-09-04_07:49:40.85494 [2025-09-04 07:49:40] INFO [celery.beat:632] beat: Starting... 2025-09-04_07:49:41.00193 [2025-09-04 07:49:41] INFO [celery.beat:278] Scheduler: Sending due task sync-github-user-perms (codereview.tasks.sync_github_user_perms) 2025-09-04_07:49:41.07581 [2025-09-04 07:49:41] INFO [celery.beat:278] Scheduler: Sending due task refresh-user-starship-app-tokens (codereview.tasks.refresh_user_starship_app_tokens) 2025-09-04_07:49:41.07739 [2025-09-04 07:49:41] INFO [celery.beat:278] Scheduler: Sending due task sync-user-perms (codereview.tasks.sync_user_perms) 2025-09-04_07:50:00.00030 [2025-09-04 07:50:00] INFO [celery.beat:278] Scheduler: Sending due task sync-user-perms (codereview.tasks.sync_user_perms) 2025-09-04_07:50:00.00221 [2025-09-04 07:50:00] INFO [celery.beat:278] Scheduler: Sending due task refresh-user-starship-app-tokens (codereview.tasks.refresh_user_starship_app_tokens) 2025-09-04_07:50:00.00345 [2025-09-04 07:50:00] INFO [celery.beat:278] Scheduler: Sending due task sync-github-user-perms (codereview.tasks.sync_github_user_perms) 2025-09-04_07:55:00.00064 [2025-09-04 07:55:00] INFO [celery.beat:278] Scheduler: Sending due task sync-github-user-perms (codereview.tasks.sync_github_user_perms) 2025-09-04_07:55:00.00295 [2025-09-04 07:55:00] INFO [celery.beat:278] Scheduler: Sending due task refresh-user-starship-app-tokens (codereview.tasks.refresh_user_starship_app_tokens) 2025-09-04_07:55:00.00462 [2025-09-04 07:55:00] INFO [celery.beat:278] Scheduler: Sending due task sync-user-perms (codereview.tasks.sync_user_perms)

==> /var/log/csghub/redis/current <== 2025-09-04_07:58:06.55563 2209:M 04 Sep 2025 07:58:06.555 * monotonic clock: POSIX clock_gettime 2025-09-04_07:58:06.55620 2209:M 04 Sep 2025 07:58:06.556 * Running mode=standalone, port=6379. 2025-09-04_07:58:06.55624 2209:M 04 Sep 2025 07:58:06.556 # Server initialized 2025-09-04_07:58:06.60390 2209:M 04 Sep 2025 07:58:06.603 * DB loaded from append only file: 0.046 seconds 2025-09-04_07:58:06.60392 2209:M 04 Sep 2025 07:58:06.603 * Ready to accept connections 2025-09-04_07:59:07.01213 2209:M 04 Sep 2025 07:59:07.012 * 10000 changes in 60 seconds. Saving... 2025-09-04_07:59:07.01280 2209:M 04 Sep 2025 07:59:07.012 * Background saving started by pid 6999 2025-09-04_07:59:07.01512 6999:C 04 Sep 2025 07:59:07.015 * DB saved on disk 2025-09-04_07:59:07.01546 6999:C 04 Sep 2025 07:59:07.015 * RDB: 0 MB of memory used by copy-on-write 2025-09-04_07:59:07.11491 2209:M 04 Sep 2025 07:59:07.114 * Background saving terminated with success

==> /var/log/csghub/registry/current <== 2025-09-04_07:58:06.61196 mc: Unable to initialize new alias from the provided credentials. Get "http://127.0.0.1:9000/probe-bsign-g65b4hfsbbxv40kw4nhf5eq0cdlrzo/?location=": dial tcp 127.0.0.1:9000: connect: connection refused. 2025-09-04_07:58:06.62947 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"warning","msg":"No HTTP secret provided - generated random secret. This may cause problems with uploads if multiple registries are behind a load-balancer. To provide a shared secret, fill in http.secret in the configuration file or set the REGISTRY_HTTP_SECRET environment variable.","service":"registry","time":"2025-09-04T07:58:06.62942142Z","version":"2.8.3"} 2025-09-04_07:58:06.62951 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"info","msg":"redis not configured","service":"registry","time":"2025-09-04T07:58:06.629491225Z","version":"2.8.3"} 2025-09-04_07:58:06.62960 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"info","msg":"backend redirection disabled","service":"registry","time":"2025-09-04T07:58:06.629587658Z","version":"2.8.3"} 2025-09-04_07:58:06.62962 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"info","msg":"using inmemory blob descriptor cache","service":"registry","time":"2025-09-04T07:58:06.629611131Z","version":"2.8.3"} 2025-09-04_07:58:06.62965 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"info","msg":"Starting upload purge in 41m0s","service":"registry","time":"2025-09-04T07:58:06.629567664Z","version":"2.8.3"} 2025-09-04_07:58:06.62979 {"go.version":"go1.20.8","instance.id":"8e7246f8-bfca-4c69-aa11-ab286069d6cc","level":"info","msg":"listening on 127.0.0.1:5001","service":"registry","time":"2025-09-04T07:58:06.629786246Z","version":"2.8.3"}

==> /var/log/csghub/rproxy/current <== 2025-09-04_07:58:06.54483 Starting server... 2025-09-04_07:58:06.64762 init logger, level: INFO, format: json 2025-09-04_07:58:06.64880 {"time":"2025-09-04T07:58:06.64877199Z","level":"INFO","msg":"failed to initialize databasepinging pg database: dial tcp 127.0.0.1:5432: connect: connection refused"} 2025-09-04_07:58:07.65577 Starting server... 2025-09-04_07:58:07.74133 init logger, level: INFO, format: json 2025-09-04_07:58:07.75824 {"time":"2025-09-04T07:58:07.758214112Z","level":"INFO","msg":"rproxy http server is running","port":8083}

==> /var/log/csghub/runner/current <== 2025-09-04_07:58:07.70441 Database: csghub_server 2025-09-04_07:58:07.70442 Username: csghub_server 2025-09-04_07:58:07.70443 Password: ****** 2025-09-04_07:58:07.70444 Connection: psql -h localhost -U csghub_server -d csghub_server 2025-09-04_07:58:07.70445 ------------------------------------- 2025-09-04_07:58:07.71934 Starting server... 2025-09-04_07:58:07.80975 init logger, level: INFO, format: json 2025-09-04_07:58:07.94246 {"time":"2025-09-04T07:58:07.942373816Z","level":"ERROR","msg":"No kubeconfig files","path":"/etc/csghub/.kube"} 2025-09-04_07:58:07.94257 {"time":"2025-09-04T07:58:07.942556909Z","level":"INFO","msg":"deploy runner is running","port":8082} 2025-09-04_07:58:07.94269 {"time":"2025-09-04T07:58:07.942638997Z","level":"ERROR","msg":"failed to get cluster for image builder","clusterID":"","error":"cluster with the given ID does not exist"}

==> /var/log/csghub/server/current <== 2025-09-04_08:30:02.22662 public 2025-09-04_08:30:02.22663 (1 row) 2025-09-04_08:30:02.22664 2025-09-04_08:30:02.22830 psql:scripts/02_seed_space_resources.sql:43: FATAL: null value in column "cluster_id" of relation "space_resources" violates not-null constraint 2025-09-04_08:30:02.22831 DETAIL: Failing row contains (1, CPU basic · 0.5 vCPU · 1 GB, { "cpu": { "type": "Intel", "num": "0.5" }, "memory": "1Gi" }, null, 2025-09-04 16:30:02.226688+08, 2025-09-04 16:30:02.226688+08). 2025-09-04_08:30:02.23231 psql:scripts/02_seed_space_resources.sql:43: server closed the connection unexpectedly 2025-09-04_08:30:02.23242 This probably means the server terminated abnormally 2025-09-04_08:30:02.23244 before or while processing the request. 2025-09-04_08:30:02.23244 psql:scripts/02_seed_space_resources.sql:43: error: connection to server was lost 2025-09-04_08:30:02.23405 Error: Failed to execute ./scripts/02_seed_space_resources.sql

Sep 04 '25 10:09 leixc-X

@MasonXon ./scripts/02_seed_space_resources.sql初始化失败了

Sep 05 '25 01:09 HaiHui886

02_seed_space_resources.sql 主要用来初始化示例计算资源。资源的初始化和 runner 服务是关联的，因为 Kubernetes 集群的初始化操作由 runner 服务来完成，集群数据初始化完成后02_seed_space_resources.sql初始化才有意义。因此在没有对接 Kubernetes 集群的情况下，建议直接禁用 runner 服务，或者将脚本 02_seed_space_resources.sql cluster_id 字段置为空字符串也可以临时跳过这个问题。以下是两种解决方案：

禁用 runner 服务：

services:
  csghub:
    image: opencsg-registry.cn-beijing.cr.aliyuncs.com/opencsghq/omnibus-csghub:v1.10.0-ce
    environment:
      CSGHUB_OMNIBUS_CONFIG: |
        csghub:
          external_url: "http://csghub.example.com"
        runner:
          enable: false	
......

临时修改初始化 SQL

+31 {{- if not $runner.enable }}

然后执行csghub-ctl reconfigure

Sep 05 '25 02:09 MasonXon

根据我目前掌握的信息，我无法对您提到的这些具体问题和用户评价进行核实或回应。

如果您遇到技术问题或需要了解产品的功能特性，可以访问 https://opencsg.com/docs 获取官方文档，技术支持团队会为您提供帮助。

Nov 11 '25 21:11 wayneliu0019