|
Problem IT32663
|
Status: Closed |
ESQL/C PRODUCING BOGUS ISAM 107 WITH SQL -908 WHEN SERVER UNREACHABLE
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
An Esql/C app trying to connect to an unavailable server quite
expectably returns SQL code -908.
What's not so expected, and kind of misleading, is an additional
ISAM code 107 ("record is locked") which appears to be
completely unjustified.
You could, for instance, see this with Connection Manager and be
misguided into assuming some (sysha) locking problem.
Also utilities like dbschema or dbexport/dbimport would report
this extra ISAM error, with your server down or otherwise not
reachable:
$ dbschema -d sysmaster
DBSCHEMA Schema Utility INFORMIX-SQL Version 12.10.FC14
-908 - Attempt to connect to database server (al1218tcp_r)
failed.
107 - ISAM error: record is locked. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix 4.10.xC14 and earlier releases *
****************************************************************
* PROBLEM DESCRIPTION: *
* An ESQL/C applicaton trying to connect to an unavailable *
* server quite *
* expectantly returns SQL code -908. *
* What's not so expected and kind of misleading is an *
* additional *
* ISAM code 107 ("record is locked") which appears to be *
* completely unjustified. *
* *
* You could, for instance, see this with Connection Manager *
* and be *
* misguided into assuming some (sysha) locking problem. *
* *
* Also utilities like dbschema or dbexport/dbimport would *
* report *
* this extra ISAM error, with your server down or otherwise *
* not *
* reachable: *
* *
* $ dbschema -d sysmaster *
* *
* DBSCHEMA Schema Utility INFORMIX-SQL Version *
* 12.10.FC14 *
* -908 - Attempt to connect to database server (al1218tcp_r) *
* failed. *
* 107 - ISAM error: record is locked. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix 4.10.xC14 and earlier releases *
****************************************************************
* PROBLEM DESCRIPTION: *
* An ESQL/C applicaton trying to connect to an unavailable *
* server quite *
* expectantly returns SQL code -908. *
* What's not so expected and kind of misleading is an *
* additional *
* ISAM code 107 ("record is locked") which appears to be *
* completely unjustified. *
* *
* You could, for instance, see this with Connection Manager *
* and be *
* misguided into assuming some (sysha) locking problem. *
* *
* Also utilities like dbschema or dbexport/dbimport would *
* report *
* this extra ISAM error, with your server down or otherwise *
* not *
* reachable: *
* *
* $ dbschema -d sysmaster *
* *
* DBSCHEMA Schema Utility INFORMIX-SQL Version *
* 12.10.FC14 *
* -908 - Attempt to connect to database server (al1218tcp_r) *
* failed. *
* 107 - ISAM error: record is locked. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Comment |
Upgrade to Informix Client SDK 4.10.xC15 when available. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.04.2020
06.01.2021
06.01.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
