Oninit
Talk to an expert →

Informix Error -32009: Routine returned with no effect and may be re-issued.

Cause and resolution

Routine returned with no effect and may be re-issued.

This error is same as XA_RETRY in the X/OPEN XA Specification Standard. For more information, refer to the "Distributed Transaction Processing: The XA Specification".

According to the X/OPEN XA Specification Standard :

In the xa_commit context, the Resource Manager is not able to commit the transaction branch at this time. This value can be returned when a blocking condition exists and TMNOWAIT was set. Note, however, that this value can also be returned even when TMNOWAIT is not set (for example, if the necessary stable storage is currently unavailable). This value cannot be returned if TMONEPHASE is set in flags. All resources held on behalf of *xid remain in a prepared state until commitment is possible. The Transaction Manager should re-issue xa_commit at a later time.

In the xa_complete context, TMNOWAIT was set in flags and no asynchronous operation has completed.

In the xa_start context, TMNOWAIT was set in flags and a blocking condition exists.

Also refer to the Resource Manager guide for more details.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32009 is the Informix representation of XA_RETRY from the X/Open XA Specification — per the official guidance, the Resource Manager isn't able to commit the transaction branch at this time.

  1. xa_commit called with TMNOWAIT set, and a blocking condition exists, per the official guidance — the first named case; can also occur even without TMNOWAIT (e.g. necessary stable storage currently unavailable). Not returnable if TMONEPHASE is set.
Solutions / Resolution
  1. Re-issue xa_commit at a later time, per the official guidance — the branch's resources remain held in a prepared state until commitment is possible.
Examples
N/A

No specific triggering statement is documented — this is a Resource-Manager-side XA return code.

Diagnostic Checks
  1. Check the Resource Manager for the blocking condition (e.g. stable-storage availability), and re-issue the commit once resolved.
Related Errors / Related Topics
  • -32007 — "The Resource Manager detected transient error." A related retryable XA condition (XA_RBTRANSIENT), which rolls back the branch rather than leaving it prepared for retry.

xa_commit couldn't complete right now and should be re-issued later (XA_RETRY) — the branch's work remains prepared, not rolled back.