Dirty Database Error with Harbor 2.10.2

[kushal2705]

Deployed harbor-helm with below detail using ArgoCD , observing harbor-core pod sometimes in CrashLoopBackOff due to Dirty database version 91 error. Kindly suggest possible solution for the issue
helm chart version : harbor-helm-1.14.2
harbor version: 2.10.2

harbor-core logs

2024/08/21 00:05:37.318 [D]  init global config instance failed. If you do not use this, just ignore it.  open conf/app.conf: no such file or directory
2024-08-21T00:05:37Z [INFO] [/controller/artifact/annotation/parser.go:85]: the annotation parser to parser artifact annotation version v1alpha1 registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.cncf.helm.config.v1+json registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.cnab.manifest.v1 registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.oci.image.index.v1+json registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.docker.distribution.manifest.list.v2+json registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.docker.distribution.manifest.v1+prettyjws registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.oci.image.config.v1+json registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.docker.container.image.v1+json registered
2024-08-21T00:05:37Z [INFO] [/controller/artifact/processor/processor.go:59]: the processor to process media type application/vnd.wasm.config.v1+json registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/native/adapter.go:36]: the factory for adapter docker-registry registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/aliacr/adapter.go:44]: the factory for adapter ali-acr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/awsecr/adapter.go:44]: the factory for adapter aws-ecr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/azurecr/adapter.go:29]: Factory for adapter azure-acr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/dockerhub/adapter.go:40]: Factory for adapter docker-hub registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/dtr/adapter.go:36]: the factory of dtr adapter was registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/githubcr/adapter.go:43]: the factory for adapter github-ghcr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/gitlab/adapter.go:33]: the factory for adapter gitlab registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/googlegcr/adapter.go:37]: the factory for adapter google-gcr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/huawei/huawei_adapter.go:40]: the factory of Huawei adapter was registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/jfrog/adapter.go:42]: the factory of jfrog artifactory adapter was registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/quay/adapter.go:53]: the factory of Quay adapter was registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/tencentcr/adapter.go:55]: the factory for adapter tencent-tcr registered
2024-08-21T00:05:37Z [INFO] [/pkg/reg/adapter/harbor/adaper.go:31]: the factory for adapter harbor registered
2024-08-21T00:05:37Z [INFO] [/core/controllers/base.go:159]: Config path: /etc/core/app.conf
2024-08-21T00:05:37Z [INFO] [/core/main.go:142]: initializing cache ...
2024-08-21T00:05:37Z [INFO] [/core/main.go:161]: initializing configurations...
2024-08-21T00:05:37Z [INFO] [/lib/config/systemconfig.go:178]: key path: /etc/core/key
2024-08-21T00:05:37Z [INFO] [/lib/config/config.go:92]: init secret store
2024-08-21T00:05:37Z [INFO] [/core/main.go:163]: configurations initialization completed
2024-08-21T00:05:37Z [INFO] [/common/dao/base.go:67]: Registering database: type-PostgreSQL host-harbor-oci-database port-5432 database-registry sslmode-"disable"
2024-08-21T00:05:37Z [INFO] [/common/dao/base.go:72]: Register database completed
2024-08-21T00:05:37Z [INFO] [/common/dao/pgsql.go:135]: Upgrading schema for pgsql ...
2024-08-21T00:05:37Z [ERROR] [/common/dao/pgsql.go:140]: Failed to upgrade schema, error: "Dirty database version 91. Fix and force version."
2024-08-21T00:05:37Z [FATAL] [/core/main.go:198]: failed to migrate the database, error: Dirty database version 91. Fix and force version.

[MinerYang]

Please kindly refer the page for fixing the dirty db manually. https://github.com/goharbor/harbor/wiki/Harbor-FAQs#upgrade

[github-actions]

This issue is being marked stale due to a period of inactivity. If this issue is still relevant, please comment or remove the stale label. Otherwise, this issue will close in 30 days.