Informix Error -23510: CM error: Cannot drop first chunk.
Cause and resolution
CM error: Cannot drop first chunk.
An attempt to delete the first chunk in a dbspace failed because deleting the first chunk in a dbspace is an invalid operation.
Check which chunk should be dropped. To drop the dbspace after the chunk, simply drop the dbspace.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23510 fires when deleting the first chunk in a dbspace is attempted — per the official guidance, this is an invalid operation.
- An attempt to delete a dbspace's first chunk, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check which chunk should actually be dropped, per the official guidance.
- To remove the dbspace entirely (including its first chunk), drop the dbspace itself, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond attempting to drop a dbspace's first chunk.
Diagnostic Checks
- Check whether the targeted chunk is the dbspace's first chunk, and drop the dbspace itself instead if that's the intent.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -23510 in this set yet.
A dbspace's first chunk can't be dropped individually — drop the dbspace instead.