Hacktoberfest 2026 : les issues que les mainteneurs ont marquées pour octobre, ouvertes et accessibles aux débutants. Parcourir les issues Hacktoberfest

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

Ouverte
  • Quelque chose ne va pas ?
#2,213 5 commentaires 0 réactions 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 2 jours

Personne n'a encore pris cette issue.

Évaluation

Difficulté
4/5
Temps estimé
3-5 jours
Accessibilité débutants
35/100
Type d'issue
Bug
Clarté
Plutôt claire
Activité
Active
Stack technique
c, postgresql
Domaine
databases

Piste de recherche

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.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

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.

Langage dominant
C
Étoiles
1.4k
Forks
265
Merge moyen
4 j 15 min
PR mergées (30 j)
68

Préparer son environnement

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de apache/cloudberry

Toutes les issues de apache/cloudberry

Issues similaires

Plus d'issues C

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.