Hacktoberfest 2026: le issue che i maintainer hanno segnato per ottobre, aperte e adatte ai principianti. Sfoglia le issue Hacktoberfest

cbcopy migration from Greenplum 6.21.0 to Apache Cloudberry 2.1.0 fails with COPY errors

Aperta
  • Qualcosa non va?
#2,213 4 commenti 0 reazioni 0 assegnatari Vedi su GitHub

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
35/100
Tipo di issue
Bug
Chiarezza
Abbastanza chiara
Stato di attività
Attiva
Stack tecnologico
c, postgresql
Ambito
databases

Direzione di ricerca

Start by reviewing the cbcopy migration logs and the COPY failures reported for affected tables; the issue does not name source files or tests. Compare the source and target row counts and investigate the Broken pipe errors using the provided Greenplum 6.21.0 and Cloudberry 2.1.0 environment details. Done means identifying a reproducible cause and documenting a resolution or retry approach; detailed logs and commands are still needed.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

Hi Apache Cloudberry Team,

We are migrating a large database from Greenplum Database 6.21.0 to Apache Cloudberry 2.1.0-incubating using the cbcopy utility.

During the migration, we encountered multiple table copy failures. The migration process reports errors such as:

could not write to COPY program: Broken pipe

Copy to affected rows X are not equal to copy from affected rows 0

Several tables failed to copy successfully.

We would appreciate your help in identifying the root cause and recommended resolution.

Environment:

Source database: Greenplum 6.21.0
Source os: CentOS 7

Target database: Apache Cloudberry 2.1.0-incubating

Source database size: Approximately 2 TB

Target OS: Oracle Linux 9.8

Migration utility: cbcopy

Steps to reproduce:

Configure the source Greenplum and target Cloudberry clusters.

Configure the required network connectivity and authentication.

Execute the cbcopy migration utility.

Observe the migration logs.

Expected behavior:

The cbcopy utility should copy all supported database objects and data successfully from Greenplum to Cloudberry.

Actual behavior:

Multiple tables fail during the COPY operation. Some tables report a mismatch between the number of rows copied from the source and the number of rows inserted into the target.

Questions:

What are the possible causes of the Broken pipe errors during cbcopy?

Is there a known issue with cbcopy in Cloudberry 2.1.0-incubating?

Are there any recommended configuration changes or patches?

Is there a recommended way to resume or retry failed table copies without restarting the entire migration?

We can provide the detailed logs, configuration files, and migration commands for further investigation.

Thank you.

Lingua principale
C
Stelle
1.4k
Fork
265
Merge medio
3g 17h
PR unite (30g)
68

Preparare l'ambiente

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di apache/cloudberry

Tutte le issue di apache/cloudberry

Issue simili

Altre issue su C

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.