[Bug] pgdump/pg_dumpall schema-only - out of memory problem after upgrade from CBDB 2.1.0 to CBDB 2.2.0 found

未关闭
#2,330 0 条评论 1 个 reaction 已指派 0 人 在 GitHub 查看

维护者通常 2 天内回复

还没有人认领这个 Issue。

评估

难度
4/5
预计耗时
3-5 天
新手友好度
43/100
Issue 类型
缺陷
描述清晰度
基本清楚
活跃度
活跃
技术栈
c, postgresql
领域
databases

调研方向

The failure occurs in pg_dump while reading column information for interesting tables; the payload does not identify a source file or test. Start by tracing that step in the pg_dump code and find how the reported database schema triggers the out-of-memory error. Done means pg_dump -s and pg_dumpall -s complete on the reporter’s DWH database after upgrading from CBDB 2.1.0 to 2.2.0.

由索引模型根据 Issue 内容生成。

描述

type: Bug
Apache Cloudberry version

PostgreSQL 14.10 (Apache Cloudberry 2.2.0-incubating build dev) on x86_64-pc-linux-gnu, compiled by gcc (Astra 1.8.2)

What happened

Hi,

After upgrade from CBDB 2.1.0 to CBDB 2.2.0 we found pgdump/pg_dumpall schema-only - out of memory problem

Details the next:

gpadmin@qc1:~$ /usr/cloudberry-db/bin/pg_dump -v -s -f /tmp/qwe1.sql --no-blobs ' dbname=dwh'
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined external protocols
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
out of memory

What you think should happen instead

No response

How to reproduce

Run pgdump -s or pg_dumpall -s on our database DWH

Operating System

Astra Linux 1.8.2 analog Debian 12

Anything else

No response

Are you willing to submit PR?
  • Yes, I am willing to submit a PR!
Code of Conduct
主要语言
C
星标
1.4k
派生
273
平均合并
4 天 6 小时
30 天内合并 PR
105

环境准备

从这里开始

  1. 先读完整个 Issue,再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库,在一个分支上完成修改。
  4. 提交 Pull Request,并在描述里引用这个 Issue 编号。

apache/cloudberry 的其他 Issue

查看 apache/cloudberry 的全部 Issue

相似的 Issue

更多 C Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。