ConfigHubPub / ConfigHubPub/ConfigHubPlatform

1.9.12 - creating Organization and/or Repo freeze - db schema errors

Open
#190 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
JavaScript
Stars
80
Forks
25
PR merge metrics
No merged PRs in 30d

Description

When running 1.9.12 app with postgres DB I constantly get freeze when creating Organization and/or Repo
I get these messages in log

2022-02-18 14:32:08,020 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper ERROR: column repository0_.cachingenabled does not exist
  Hint: Perhaps you meant to reference the column "repository0_.cachingEnabled".

lExceptionHelper SQL Error: 0, SQLState: 42703
2022-02-18 15:00:19,112 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelperERROR: column  "cachingenabled" relation "repository_audit" does not exist

and so forth

Docker app seems to be older and it at least it works

DB schema was generated by the latest [Database-Manager] 1.9.1

looks like the [Database-Manager] is outdated

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the freeze with the 1.9.12 app and PostgreSQL while creating an Organization or Repo, then inspect the logged missing-column errors. Compare the schema generated by Database-Manager 1.9.1 with the schema expected by the app. Done means these operations complete without freezing or producing the reported schema errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, postgresql
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.