[Bug] incosistent state of pg_operator after init CB cluster
I maintainer di solito rispondono entro 2 giorni
Nessuno ha ancora preso questa issue.
Valutazione
- Difficoltà
- 4/5
- Tempo stimato
- 3-5 giorni
- Idoneità per principianti
- 45/100
Direzione di ricerca
Start by reading the GPCHECKCAT output and the cluster initialization path that populates pg_operator catalogs across the coordinator and segments; the issue does not name source files or tests. Compare oprrest and oprjoin for the listed operator OIDs after creating a cluster and running GPCHECKCAT -O DBNAME. Done means those catalog values match on the coordinator and all segments.
Scritto dal modello di indicizzazione a partire dal testo della issue.
Descrizione
Apache Cloudberry version
PostgreSQL 14.4 (Apache Cloudberry 2.1.0-incubating build dev) on x86_64-pc-linux-gnu, compiled by gcc (Astra 1.8.2) , 64-bit compiled
What happened
After we are initialyzed CBDB cluster we found some inconsistent of PG catalog by checking by run GPCHECKCAT command on main database in online mode.
We catch the next errors:
`----------------------------------------------------
Object oid: 17472
Table name: pg_operator
Name of test which found this issue: inconsistent_pg_operator
oprrest is '5040' on content -1 (qc1.local:5432)
oprrest is '1302' on all other segments
oprjoin is '5041' on content -1 (qc1.local:5432)
oprjoin is '1303' on all other segments
Object oid: 17476
Table name: pg_operator
Name of test which found this issue: inconsistent_pg_operator
oprrest is '5040' on content -1 (qc1.local:5432)
oprrest is '1302' on all other segments
oprjoin is '5041' on content -1 (qc1.local:5432)
oprjoin is '1303' on all other segments
Object oid: 17534
Table name: pg_operator
Name of test which found this issue: inconsistent_pg_operator
oprrest is '5040' on content -1 (qc1.local:5432)
oprrest is '1302' on all other segments
oprjoin is '5041' on content -1 (qc1.local:5432)
oprjoin is '1303' on all other segments
Object oid: 17477
Table name: pg_operator
Name of test which found this issue: inconsistent_pg_operator
oprrest is '5040' on content -1 (qc1.local:5432)
oprrest is '1302' on all other segments
oprjoin is '5041' on content -1 (qc1.local:5432)
oprjoin is '1303' on all other segments
Object oid: 17535
Table name: pg_operator
Name of test which found this issue: inconsistent_pg_operator
oprrest is '5040' on content -1 (qc1.local:5432)
oprrest is '1302' on all other segments
oprjoin is '5041' on content -1 (qc1.local:5432)
oprjoin is '1303' on all other segments
`
This problem was repeated every time when we are try to create CB cluster again in many times.
What you think should happen instead
Possible is was in internal cluster creating logic.
How to reproduce
After creating new Cluster try to run GPCHECKCAT -O DBNAME
Operating System
Astra 1.8.2 analog Debain 12
Anything else
Some information from PG operator on problem DB
Are you willing to submit PR?
- Yes, I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct.
- Lingua principale
- C
- Stelle
- 1.4k
- Fork
- 273
- Merge medio
- 4g 6h
- PR unite (30g)
- 105
Preparare l'ambiente
- Nessun Dockerfile né file Docker Compose
- Ha un modello di pull request
- Leggi la guida per i contributori
Come iniziare
- Leggi tutta la issue e poi la guida ai contributi del progetto.
- Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
- Fai un fork del repository e lavora su un branch.
- Apri una pull request che faccia riferimento al numero della issue.
Altre issue di apache/cloudberry
-
isolation2 lockmodes fails on cassert builds: extra AccessShareLock on partition rootForse già presa @tuhaihe l’ha presa oggi. Aperta
Difficoltà 2/5 1-3 ore Idoneità per principianti 78/100
apache/cloudberry#2356 ·
I maintainer di solito rispondono entro 2 giorni
-
psql tab completion broken for storage servers, tags, profiles and resource groups (pre-PG15 query format)Forse già presa @allenvox l’ha presa 5 giorni fa. Aperta
Difficoltà 2/5 1-3 ore Idoneità per principianti 72/100
apache/cloudberry#2316 ·
I maintainer di solito rispondono entro 2 giorni
-
[Bug] Expand fails to recognize user-defined tablespacesForse già presa @nix-oss l’ha presa 92 giorni fa. Apertatype: Bug
Difficoltà 2/5 1-3 ore Idoneità per principianti 76/100
apache/cloudberry#1885 · 2 reazioni ·
I maintainer di solito rispondono entro 2 giorni
-
gpexpand first stage fails: 'SyncPackages' object has no attribute 'ret' (extension sync never runs; regression)Forse già presa @talmacschen-arch l’ha presa 153 giorni fa. Aperta
Difficoltà 2/5 1-3 ore Idoneità per principianti 86/100
apache/cloudberry#1825 ·
I maintainer di solito rispondono entro 2 giorni
-
type: Bug
Difficoltà 4/5 3-5 giorni Idoneità per principianti 53/100
apache/cloudberry#2350 · 1 reazione ·
I maintainer di solito rispondono entro 2 giorni
Tutte le issue di apache/cloudberry
Issue simili
-
Difficoltà 2/5 1-3 ore Idoneità per principianti 78/100
I maintainer di solito rispondono entro 1 giorno
-
windows-artifacts: the win-arm64 job uses a Visual Studio generator missing from windows-11-armAperta
Difficoltà 1/5 Meno di un'ora Idoneità per principianti 86/100
-
Difficoltà 2/5 1-3 ore Idoneità per principianti 66/100
wasm-micro-runtime/wasm-micro-runtime#5217 ·
I maintainer di solito rispondono entro 3 giorni
-
Difficoltà 2/5 1-3 ore Idoneità per principianti 65/100
I maintainer di solito rispondono entro 1 giorno
-
Enhancement
Difficoltà 2/5 1-3 ore Idoneità per principianti 68/100
HandBrake/HandBrake#8278 · 1 commento ·
I maintainer di solito rispondono entro 1 giorno