4paradigm / 4paradigm/OpenMLDB

When executing 'SELECT COUNT(*) FROM t', the OpenMLDB service exits directly due to being OOM (Out Of Memory) killed.

Open
#4,031 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Bug Description**

In a bank customer anti-fraud scenario, the primary table t contains 400 million records with a single replica, and the memory utilization is 52%. After executing SELECT COUNT(*) FROM t, the OpenMLDB service exits. Checking the logs reveals an "oom_kill" event.

Contributor guide

Open the contributing guide

Research direction

The issue is about an OOM kill when running SELECT COUNT(*) on a large table. Start by examining the query execution path for aggregate functions, particularly COUNT(*), in the OpenMLDB codebase. Look at memory management during full table scans and check for any known issues with memory allocation or query planning for large datasets. Review the logs for the oom_kill event details to understand the memory pressure. Testing on a smaller dataset to reproduce the memory growth pattern would be a first step.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.