Oninit
Talk to an expert →

Informix Error -12117: Smart Large Objects: Bad LO header (encountered during deletion).

Cause and resolution

Smart Large Objects: Bad LO header (encountered during deletion).

LO header read from disk is bad. Most likely sbspace is corrupt. Run oncheck -ce on the sbspace. You might need to restore the sbspace from an archive.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12117 fires when an LO header read from disk is bad, encountered while deleting the object — per the official guidance.

  1. The sbspace most likely being corrupt, per the official guidance — the direct, named cause.
Solutions / Resolution
  1. Run oncheck -ce on the sbspace, per the official guidance.
  2. Restore the sbspace from an archive if needed, per the official guidance.
Examples
Checking sbspace extent consistency
$ oncheck -ce sbspace_name
Diagnostic Checks
  1. Run oncheck -ce on the affected sbspace, and restore from archive if corruption is confirmed.
Related Errors / Related Topics
  • -12115 — "The LO header page is a wrong length - probably corrupted." The same class of corrupted-header error, specifically a wrong page length.
  • -12116 — "Smart Large Objects: Bad LO header." The same class of corrupted-header error, general rather than specifically during deletion.

An LO header read from disk was bad during a delete, most likely due to sbspace corruption — run oncheck -ce and restore from archive if needed.