原 GreenPlum启用资源组后，gpcc不能启动，GP也查询报错
👉 本文共约124个字，系统预计阅读时间或需1分钟。
现象
-- 启用资源组后，gpcc不能启动，GP也查询报错
分析：/var/log/messages 发现很多的OOM错误
1 2 3 4 5 6 7 8 9 10 11 12 13 | Dec 25 23:26:56 gpdb7 kernel: Task in /gpdb/6437 killed as a result of limit of /gpdb/6437 Dec 25 23:26:56 gpdb7 kernel: memory: usage 0kB, limit 0kB, failcnt 135604 Dec 25 23:26:56 gpdb7 kernel: memory+swap: usage 0kB, limit 0kB, failcnt 0 Dec 25 23:26:56 gpdb7 kernel: kmem: usage 0kB, limit 9007199254740988kB, failcnt 0 Dec 25 23:26:56 gpdb7 kernel: Memory cgroup stats for /gpdb/6437: cache:0KB rss:0KB rss_huge:0KB mapped_file:0KB swap:0KB inactive_anon:0KB active_anon:0KB inactive_file:0KB active_file:0KB unevictable:0KB Dec 25 23:26:56 gpdb7 kernel: [ pid ] uid tgid total_vm rss nr_ptes swapents oom_score_adj name Dec 25 23:26:56 gpdb7 kernel: [469940] 530 469940 143909 3116 91 0 0 postgres Dec 25 23:26:56 gpdb7 kernel: Memory cgroup out of memory: Kill process 469941 (postgres) score 3207000 or sacrifice child Dec 25 23:26:56 gpdb7 kernel: Killed process 469940 (postgres), UID 530, total-vm:575636kB, anon-rss:3952kB, file-rss:3356kB, shmem-rss:5156kB Dec 25 23:26:56 gpdb7 kernel: postgres invoked oom-killer: gfp_mask=0xd0, order=0, oom_score_adj=0 Dec 25 23:26:56 gpdb7 kernel: postgres cpuset=1 mems_allowed=0 Dec 25 23:26:56 gpdb7 kernel: CPU: 21 PID: 470045 Comm: postgres Kdump: loaded Tainted: G ------------ T 3.10.0-1160.95.1.el7.x86_64 #1 Dec 25 23:26:56 gpdb7 kernel: Hardware name: Bochs Bochs, BIOS 1.13.0-20201211_142035 04/01/2014 |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
