Warning in memory tracker

[sykp241095]

Original author: Fredrik_Jonsson
Original time: 2025-06-09 07:54:37.187271
Original ID/Slug: 10502 / warning-in-memory-tracker

v8.5.1 self hosted
Production

[2025/06/09 07:34:17.297 +00:00] [WARN] [agg_hash_executor.go:212] [“Memory tracker’s counter is invalid”] [counter=-34354]

Is this a bug? What can I do to assist in resolving this?

[sykp241095]

Original author: Hazel
Original time: 2025-06-09 09:03:43.880769

Fredrik_Jonsson:

v8.5.1 self hosted
Production

[2025/06/09 07:34:17.297 +00:00] [WARN] [agg_hash_executor.go:212] [“Memory tracker’s counter is invalid”] [counter=-34354]

Is this a bug? What can I do to assist in resolving this?

Hi @Fredrik_Jonsson , this is a known bug, and it has already been fixed on the master branch. You can safely ignore this log, it doesn’t affect correctness.

  <a href="https://github.com/pingcap/tidb/issues/58822" target="_blank" rel="noopener">github.com/pingcap/tidb</a>

many error log "Memory tracker's counter is invalid"

<div class="github-info">
  <div class="date">
    opened <span class="discourse-local-date" data-format="ll" data-date="2025-01-09" data-time="07:34:05" data-timezone="UTC">07:34AM - 09 Jan 25 UTC</span>
  </div>

    <div class="date">
      closed <span class="discourse-local-date" data-format="ll" data-date="2025-05-21" data-time="05:04:44" data-timezone="UTC">05:04AM - 21 May 25 UTC</span>
    </div>

  <div class="user">
    <a href="https://github.com/lance6716" target="_blank" rel="noopener">
      <img alt="" src="https://raw.githubusercontent.com/pingcap-inc/ask.pingcap.com-uploads/main/default/original/2X/d/d24ba294888a581e1996dc54ba54bb94c12ff4b4.png" class="onebox-avatar-inline" width="20" height="20" data-dominant-color="4A4F60">
      lance6716
    </a>
  </div>
</div>

<div class="labels">
    <span style="display:inline-block;margin-top:2px;background-color: #B8B8B8;padding: 2px;border-radius: 4px;color: #fff;margin-left: 3px;">
      type/bug
    </span>
    <span style="display:inline-block;margin-top:2px;background-color: #B8B8B8;padding: 2px;border-radius: 4px;color: #fff;margin-left: 3px;">
      sig/execution
    </span>
    <span style="display:inline-block;margin-top:2px;background-color: #B8B8B8;padding: 2px;border-radius: 4px;color: #fff;margin-left: 3px;">
      severity/major
    </span>
    <span style="display:inline-block;margin-top:2px;background-color: #B8B8B8;padding: 2px;border-radius: 4px;color: #fff;margin-left: 3px;">
      affects-8.5
    </span>
</div>

## Bug Report

Please answer these questions before submitting your issue. Thank…s!

1. Minimal reproduce step (Required)

This is an internal test, https://tcms.pingcap.net/api/v1/artifact-files/ks3/archive/endless-ha-test-import-into-tps-7802999-1-56/2025-01-08T19:20:13Z/tc-tidb-0

2. What did you expect to see? (Required)

3. What did you see instead (Required)

[2025/01/08 18:18:00.504 +08:00] [WARN] [agg_hash_executor.go:212] ["Memory tracker's counter is invalid"] [counter=-94434]
[2025/01/08 18:18:00.557 +08:00] [WARN] [agg_hash_executor.go:212] ["Memory tracker's counter is invalid"] [counter=-129664]
[2025/01/08 18:18:00.572 +08:00] [WARN] [agg_hash_executor.go:212] ["Memory tracker's counter is invalid"] [counter=-136404]
[2025/01/08 18:18:00.576 +08:00] [WARN] [agg_hash_executor.go:212] ["Memory tracker's counter is invalid"] [counter=-123952]
[2025/01/08 18:18:00.647 +08:00] [WARN] [agg_hash_executor.go:212] ["Memory tracker's counter is invalid"] [counter=-116892]

4. What is your TiDB version? (Required)

6c9ee36

[sykp241095]

Original author: Fredrik_Jonsson
Original time: 2025-06-09 10:23:19.566833

Thanks you for quick reply.

[sykp241095]

Original author: TiDB-AI-Assistant
Original time: 2025-06-09 10:25:39.307795

---

Comprehensive Response: Addressing “Memory Tracker’s Counter is Invalid” in TiDB 8.5.1

1. Confirmation of Known Bug

This is a known issue related to TiDB’s memory tracking subsystem. Similar bugs (e.g., memory leaks due to improper memTracker cleanup) were resolved in earlier versions like 7.5.3 and 8.1.1. The master branch includes further refinements to prevent invalid counter states.

---

2. Explanation & Impact

• What It Means: The warning indicates a mismatch between actual memory usage and TiDB’s internal accounting. This occurs when memory allocations are not properly tracked (e.g., a component fails to release or update its memory counter).
• Impact:
  • No Data Corruption: Queries and transactions remain correct.
  • Operational Risks:
    • Over/under-estimation of memory usage, potentially leading to unnecessary query cancellations or delayed OOM errors.
    • Minor performance degradation if memory recycling is inefficient.

---

3. Reassurance on Stability

Your system’s correctness and stability are unaffected. This is a non-critical, non-deterministic logging issue—not a data integrity flaw. Production clusters with this warning have operated safely while awaiting patches.

---

4. Recommended Immediate Actions

• Monitor Memory Metrics:
  • Track Process Memory Usage and Goroutines in Grafana.
  • Check for spikes in tidb_server_maxprocs or frequent memory exceeds quota logs.
• Limit Workarounds:
  • Avoid adjusting tidb_mem_quota_query unless OOMs occur.
  • Restart TiDB nodes only if memory grows uncontrollably.
• Log Analysis:
  • Use grep "Memory tracker's counter is invalid" tidb.log to gauge frequency.
  • If rare (<1/hour), no urgent action is needed.

---

5. Permanent Fix via Upgrade

• Target Version: Upgrade to a release containing the master branch fix (e.g., future 8.5.2+ or 8.6.0).
• Upgrade Steps:
  1. Test in Staging: Validate the fix in a non-production environment.
  2. Use TiUP: Follow the rolling upgrade guide to minimize downtime.
  3. Post-Upgrade: Verify resolution via tidb.log and monitor for 24 hours.

---

6. Monitoring Recommendations

• Key Metrics:
  • TiDB Memory Usage (Grafana dashboard).
  • Process Resident Memory per TiDB instance.
  • Query duration outliers (Sudden increases may indicate memory pressure).
• Alerts:
  • Trigger alerts if memory usage exceeds 80% of system capacity.
  • Flag repeated invalid counter warnings (>10/hour).

---

Summary

This warning is a harmless accounting glitch in TiDB 8.5.1. While no immediate action is required, plan an upgrade to a patched version for long-term resolution. Monitor memory metrics closely, and rest assured that your data remains safe. For urgent concerns, contact PingCAP Support with logs and Grafana snapshots.