Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: relation "properties" does not exist at character 15 #20686

Open
gjrtimmer opened this issue Jul 2, 2024 · 1 comment
Open

ERROR: relation "properties" does not exist at character 15 #20686

gjrtimmer opened this issue Jul 2, 2024 · 1 comment
Assignees

Comments

@gjrtimmer
Copy link

Expected behavior and actual behavior:

New fresh install of v2.11.0, core container refuses to start.

Brand new data directory.

Anybody any clue where this problem comes from ?

Steps to reproduce the problem:

unknown

Versions:

  • harbor version: 2.11.0
  • docker engine version: 20.10.3
  • docker-compose version: 1.28.5

Additional context:

Core Logging

2024-07-02T13:54:37Z [INFO] [/core/controllers/base.go:159]: Config path: /etc/core/app.conf
2024-07-02T13:54:37Z [INFO] [/core/main.go:145]: initializing cache ...
2024-07-02T13:54:37Z [INFO] [/core/main.go:164]: initializing configurations...
2024-07-02T13:54:37Z [INFO] [/lib/config/systemconfig.go:178]: key path: /etc/core/key
2024-07-02T13:54:37Z [INFO] [/lib/config/config.go:92]: init secret store
2024-07-02T13:54:37Z [INFO] [/core/main.go:166]: configurations initialization completed
2024-07-02T13:54:37Z [INFO] [/lib/metric/server.go:37]: Prometheus metric server running on port 9090
2024-07-02T13:54:37Z [INFO] [/common/dao/base.go:67]: Registering database: type-PostgreSQL host-postgresql port-5432 database-registry sslmode-"disable"
2024-07-02T13:54:37Z [INFO] [/common/dao/base.go:72]: Register database completed
2024-07-02T13:54:37Z [INFO] [/common/dao/pgsql.go:135]: Upgrading schema for pgsql ...
2024-07-02T13:54:37Z [INFO] [/common/dao/pgsql.go:138]: No change in schema, skip.
2024-07-02T13:54:37Z [INFO] [/core/main.go:204]: The database has been migrated successfully
2024-07-02T13:54:37Z [FATAL] [/core/main.go:209]: failed to load config: ERROR: relation "properties" does not exist (SQLSTATE 42P01)

DB Logging

2024-07-02 13:49:00.073 UTC [153] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:00.073 UTC [153] STATEMENT:  select * from properties
2024-07-02 13:49:06.101 UTC [169] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:06.101 UTC [169] STATEMENT:  select * from properties
2024-07-02 13:49:15.701 UTC [173] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:15.701 UTC [173] STATEMENT:  select * from properties
2024-07-02 13:49:21.348 UTC [177] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:21.348 UTC [177] STATEMENT:  select * from properties
2024-07-02 13:49:25.900 UTC [181] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:25.900 UTC [181] STATEMENT:  select * from properties
2024-07-02 13:49:30.779 UTC [185] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:30.779 UTC [185] STATEMENT:  select * from properties
2024-07-02 13:49:37.312 UTC [200] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:37.312 UTC [200] STATEMENT:  select * from properties
2024-07-02 13:49:46.441 UTC [204] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:49:46.441 UTC [204] STATEMENT:  select * from properties
2024-07-02 13:50:03.650 UTC [209] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:50:03.650 UTC [209] STATEMENT:  select * from properties
2024-07-02 13:50:32.643 UTC [226] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:50:32.643 UTC [226] STATEMENT:  select * from properties
2024-07-02 13:51:26.898 UTC [257] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:51:26.898 UTC [257] STATEMENT:  select * from properties
2024-07-02 13:52:29.928 UTC [285] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:52:29.928 UTC [285] STATEMENT:  select * from properties
2024-07-02 13:53:33.730 UTC [315] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:53:33.730 UTC [315] STATEMENT:  select * from properties
2024-07-02 13:54:37.532 UTC [342] ERROR:  relation "properties" does not exist at character 15
2024-07-02 13:54:37.532 UTC [342] STATEMENT:  select * from properties
@stonezdj
Copy link
Contributor

stonezdj commented Jul 8, 2024

Try to clean the rm -rf /data/database/* and restart Harbor?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
2 participants