SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Messages Manual—523730-004
18-14
SQL 25303
Where version1 is the plan version of the affected query.
Where node is the name of the node that detects the incompatibility.
Where version2 is the MXV of the node that detects the incompatibility.
Cause. You attempted to execute a query plan fragment with a plan version that is
later than the MXV of the node that executes the plan or plan fragment.
Effect. Either:
•
Automatic recompilation is attempted (if allowed) with a downrev compiler that
produces plans with a plan version that is compatible with version2. If the
recompilation succeeds, this message is returned as a warning, and the query is
reexecuted.
•
Automatic recompilation is not supported, or failed, and the message is returned as
an error. The operation fails.
Recovery. Recompile the plan or module with a supported version compiler that
generates plans that are compatible with all involved nodes.
SQL 25304
Where version1 is the version of the required compiler.
Where node is the node on which the compiler was started.
Where version2 is the version of the compiler that returns the message.
Cause. The query references one or more remote nodes with an MXV earlier than the
current compiler’s current plan version.
Effect. There are several possibilities:
•
For automatic recompilations and dynamic SQL, the executor automatically starts a
compiler process of the required version and retries the operation. If that strategy
succeeds, this message is returned as a warning. If it does not succeed, the
operation fails.
25303 The query plan version is version1; node node does not
support query plan versions higher than version2.
25304 A compiler of version version1 was automatically
started on node to recompile the query. The current compiler
version is version2.
Note. As of the ABU SPR, this message is no longer generated.