Hacktoberfest 2026: as issues que os mantenedores marcaram para outubro, abertas e boas para iniciantes. Ver issues do Hacktoberfest

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

Aberta
  • Algo errado?
#2,213 4 comentários 0 reações 0 responsáveis Ver no GitHub

Mantenedores costumam responder em até 2 dias

Ninguém assumiu esta issue ainda.

Avaliação

Dificuldade
4/5
Tempo estimado
3-5 dias
Facilidade para iniciantes
35/100
Tipo de issue
Bug
Clareza
Razoavelmente clara
Status de atividade
Ativa
Stack de tecnologia
c, postgresql
Domínio
databases

Direção de pesquisa

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.

Escrita pelo modelo de indexação a partir do texto da issue.

Descrição

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.

Linguagem predominante
C
Estrelas
1.4k
Forks
265
Merge médio
3d 17h
PRs com merge (30d)
68

Preparar o ambiente

Primeiros passos

  1. Leia a issue inteira e depois o guia de contribuição do projeto.
  2. Comente na issue dizendo que vai assumir — evita que duas pessoas façam o mesmo trabalho.
  3. Faça um fork do repositório e trabalhe em uma branch.
  4. Abra um pull request que referencie o número da issue.

Mais de apache/cloudberry

Todas as issues de apache/cloudberry

Issues semelhantes

Mais issues de C

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.