goharbor / harbor

An open source trusted cloud native registry project that stores, signs, and scans content.
https://goharbor.io
Apache License 2.0
24.29k stars 4.77k forks source link

Getting the issue in harbor db #20999

Open mrjain1806 opened 1 month ago

mrjain1806 commented 1 month ago

Hello Team,

I am getting the below issue in goharbor db : 2024-10-04 03:04:13.228 UTC [9] FATAL: the database system is starting up 2024-10-04 03:04:13.559 UTC [1] LOG: startup process (PID 7) was terminated by signal 6: Aborted 2024-10-04 03:04:13.560 UTC [1] LOG: aborting startup due to startup process failure 2024-10-04 03:04:13.588 UTC [1] LOG: database system is shut down 2024-10-04 03:05:14.026 UTC [1] LOG: starting PostgreSQL 14.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 12.2.0, 64-bit 2024-10-04 03:05:14.027 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-10-04 03:05:14.027 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-10-04 03:05:14.030 UTC [1] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432" 2024-10-04 03:05:14.043 UTC [7] LOG: database system was shut down at 2024-05-13 09:57:13 UTC 2024-10-04 03:05:14.044 UTC [7] LOG: invalid resource manager ID in primary checkpoint record 2024-10-04 03:05:14.044 UTC [7] PANIC: could not locate a valid checkpoint record 2024-10-04 03:05:14.636 UTC [1] LOG: startup process (PID 7) was terminated by signal 6: Aborted 2024-10-04 03:05:14.636 UTC [1] LOG: aborting startup due to startup process failure 2024-10-04 03:05:14.662 UTC [1] LOG: database system is shut down

Also, When running the docker ps command below are the containers in loop which keep on restarting : [root@ucodainfra1 postgresql]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES d17c80c6856b goharbor/harbor-jobservice:v2.9.0 "/harbor/entrypoint.…" 2 months ago Restarting (2) 1 second ago harbor-jobservice 86fb1f3d214f goharbor/nginx-photon:v2.9.0 "nginx -g 'daemon of…" 2 months ago Up 6 weeks (healthy) 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp, 0.0.0.0:8443->8443/tcp, :::8443->8443/tcp nginx e66ab5a6e128 goharbor/harbor-core:v2.9.0 "/harbor/entrypoint.…" 2 months ago Up 49 seconds (health: starting) harbor-core 41b5736a21fe goharbor/harbor-db:v2.9.0 "/docker-entrypoint.…" 2 months ago Restarting (1) 50 seconds ago harbor-db 413498bdec44 goharbor/harbor-registryctl:v2.9.0 "/home/harbor/start.…" 2 months ago Up 6 weeks (healthy) registryctl d3529f9a6d3b goharbor/harbor-portal:v2.9.0 "nginx -g 'daemon of…" 2 months ago Up 6 weeks (healthy) harbor-portal adfe57b78af6 goharbor/registry-photon:v2.9.0 "/home/harbor/entryp…" 2 months ago Up 6 weeks (healthy) registry cc372e93aa64 goharbor/redis-photon:v2.9.0 "redis-server /etc/r…" 2 months ago Up 6 weeks (healthy) redis a6e6ae571ae5 goharbor/harbor-log:v2.9.0 "/bin/sh -c /usr/loc…" 2 months ago Up 6 weeks (healthy) 127.0.0.1:1514->10514/tcp harbor-log

Could you please help us resolve this issue ?

Regards, Mr Jain

stonezdj commented 1 month ago

It is a Postgresql database, and data files are corrupted, you'd ask for help from PostgreSQL experts.