[Bug] pgdump/pg_dumpall schema-only - out of memory problem after upgrade from CBDB 2.1.0 to CBDB 2.2.0 found
维护者通常 2 天内回复
还没有人认领这个 Issue。
评估
调研方向
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 内容生成。
描述
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
- I agree to follow this project's Code of Conduct.
- 主要语言
- C
- 星标
- 1.4k
- 派生
- 273
- 平均合并
- 4 天 6 小时
- 30 天内合并 PR
- 105
环境准备
- 没有 Dockerfile 或 Docker Compose 文件
- 有 Pull Request 模板
- 阅读贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
apache/cloudberry 的其他 Issue
-
isolation2 lockmodes fails on cassert builds: extra AccessShareLock on partition root可能已有人在做 @tuhaihe 今天认领。 未关闭
难度 2/5 1-3 小时 新手友好度 78/100
apache/cloudberry#2356 ·
维护者通常 2 天内回复
-
psql tab completion broken for storage servers, tags, profiles and resource groups (pre-PG15 query format)可能已有人在做 @allenvox 于 5 天前认领。 未关闭
难度 2/5 1-3 小时 新手友好度 72/100
apache/cloudberry#2316 ·
维护者通常 2 天内回复
-
[Bug] Expand fails to recognize user-defined tablespaces可能已有人在做 @nix-oss 于 92 天前认领。 未关闭type: Bug
难度 2/5 1-3 小时 新手友好度 76/100
apache/cloudberry#1885 · 2 个 reaction ·
维护者通常 2 天内回复
-
gpexpand first stage fails: 'SyncPackages' object has no attribute 'ret' (extension sync never runs; regression)可能已有人在做 @talmacschen-arch 于 153 天前认领。 未关闭
难度 2/5 1-3 小时 新手友好度 86/100
apache/cloudberry#1825 ·
维护者通常 2 天内回复
-
type: Bug
难度 4/5 3-5 天 新手友好度 53/100
apache/cloudberry#2350 · 1 个 reaction ·
维护者通常 2 天内回复
查看 apache/cloudberry 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 78/100
维护者通常 1 天内回复
-
难度 1/5 1 小时以内 新手友好度 86/100
-
难度 2/5 1-3 小时 新手友好度 66/100
wasm-micro-runtime/wasm-micro-runtime#5217 ·
维护者通常 3 天内回复
-
难度 2/5 1-3 小时 新手友好度 65/100
维护者通常 1 天内回复
-
Enhancement
难度 2/5 1-3 小时 新手友好度 68/100
HandBrake/HandBrake#8278 · 1 条评论 ·
维护者通常 1 天内回复