Informix Error -9455: Cannot access large object.
Cause and resolution
Cannot access large object.
Make sure that the default sbspace, which the SBSPACENAME configuration parameter indicates, has been created. The onspaces utility creates sbspaces.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9455 fires when a large object can't be accessed — per the official guidance.
- The default sbspace not yet created, per the official guidance — the direct, only cause.
Solutions / Resolution
- Make sure the default sbspace, named by the SBSPACENAME configuration parameter, has
been created, per the official guidance — use the
onspacesutility to create it.
Examples
Creating the default sbspace
$ onspaces -c -S sbspace1 -p /path/to/chunk -o 0 -s 100000
Diagnostic Checks
- Check SBSPACENAME in ONCONFIG and whether that sbspace actually exists
(
onstat -d), and create it withonspacesif missing.
Related Errors / Related Topics
- -9456 — "Cannot get large object length." A related large-object-access error, on length retrieval specifically rather than access generally.
- -9457 — "Cannot convert large object handle to byte[]." A related large-object-access error, on content retrieval specifically rather than access generally.
- -9458 — "Cannot start large object search." A related large-object-access error, on seek specifically rather than access generally.
- -9459 — "Large object Error: (%s)." The general large-object-access error this is a specific case of, missing the default sbspace.
A large object couldn't be accessed because the default sbspace doesn't exist — create it
with onspaces, matching SBSPACENAME.