Informix Error -934

Reasons / Common Causes

-934 fires when a statement uses data from another computer system, but the connection to it has since been lost — per the official guidance, this is a mid-operation connection loss, distinct from -930's initial-connection-attempt failure.

1. A network interruption partway through a distributed operation, per the official guidance — the connection was valid when the operation started but dropped before it completed.
2. The remote site's database server stopping or restarting while a connection to it was still in use locally.

Solutions / Resolution

1. Roll back the transaction, per the official guidance — the documented, required first step, since the operation can't be assumed to have completed successfully.
2. Reestablish the connection, per the official guidance, before retrying.
3. Try again after the connection is reestablished, per the official guidance.

Examples

Rollback, reconnect, retry

ROLLBACK WORK;
-- reestablish the connection to the remote site
DATABASE sales@remote_server;
-- retry the original operation

Diagnostic Checks

1. Confirm the transaction was rolled back before attempting any further work.
2. Check the remote site's current reachability before retrying.

Related Errors / Related Topics

• -930 — "Cannot connect to database server servername." A related connectivity error, at the initial connection-attempt stage rather than a connection lost mid-operation.
• -912 — "Network error - Could not write to database server." A related network-failure error, at the individual read/write level rather than the connection as a whole being deemed invalid.
• -913 — "Network error - Could not read from database server." Same family, read-side.

Roll back first, reestablish the connection, then retry — don't assume the operation completed before the connection dropped.