Error: F_JD02C9 No More auto_increment Values Available for This Table

Issue

When you activate an existing HVR channel with a SingleStore target, activation fails while HVR creates its internal state tables. The following error appears:

F_JD02C9: DBMS error [No more auto_increment values available for this table.]

Environment

• HVR 6
• Target: SingleStore 8.7.38

Resolution

To resolve this issue:

1. Run the failing Data Definition Language (DDL) command directly in SingleStore.
2. If the statement fails with the same error, work with your database administrator to identify the table that has exhausted its INT-based auto_increment range.
3. Alter the affected table to use a different data type or support larger ranges.
4. Activate the channel again.

If the issue persists, contact SingleStore Support to check for cluster configuration problems or fixes available in a later SingleStore version.

Cause

This issue occurs when a keyless sharded table in SingleStore exhausts its INT-based auto_increment range. When this happens, we can't generate additional auto-incremented IDs, preventing us from creating new tables.