apache / apache/cloudberry

[Bug] auvacuum worker worked in loop and it is caused to High CPU usage

Open
#1,850 10 comments 0 reactions 0 assignees View on GitHub
type: Bug
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

### Apache Cloudberry version

We are trying to test Apache Cloudberry 2.1.0 on Astra Linux 1.8.1 (Debian 12 based)

### What happened

Hello,
We found the next problem with auvacuum worker using not correct logic and trying to vacuum PXF foreghn tables located on Hadoop.
It is caused to high CPU usage by autovacuum workers on database with high coung of PXF tables

Image

In Cloudberry master log we can see many messages by the next screenshoot we can see

Image

When we can run vacuum on problem database, vacuum crashed by the next error

Image

And we can identify this object as PXF foreighn table

Image

### What you think should happen instead

And i think correct about vacuum logic can not work with foreighn tables and in Greenplum logic means not use PXF tables too in this mechanizm.

### How to reproduce

I think need to create couple of PXF tables on clean DB.

### Operating System

Astra Linux 1.8.1 (Debian 12 based)

### Anything else

Every time.

### Are you willing to submit PR?

- [ ] Yes, I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the loop on a clean database with a couple of PXF foreign tables, then inspect the auvacuum worker logs and the vacuum failure shown in the report. Done means vacuum no longer processes these foreign tables, the worker stops looping, and high CPU usage is eliminated.

Written by the indexing model from the issue text.

Assessment

Tech stack
hadoop
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.