|
Problem IT33697
|
Status: Closed |
DIRECT REMOTE SELECT TO PRI FROM LOCAL HDR / RSS WITH 4 CONNECTION MANAGERS AND SLA GROUPS MAY RESULT IN 908 / 27001
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
This reproduces with IBM Informix 12.10.FC14 and IBM Informix
CSDK 4.50.FC3
This does NOT reproduce with IBM Informix 14.10.FC3 and IBM
Informix CSDK 4.50.FC3
This reproduces with 4 Connection Managers
This does NOT reproduce with 3 Connection Managers
This reproduces when Connection Manager SLAs are placed in a "CM
SLA Group" group
This does NOT reproduce when no Connection Manager SLAs are
placed in a "CM SLA Group" group
With 3 Connection Managers running and jj1210fc14a_tcp (running
on jj-1410fc3-a) the current HDR Secondary and jj1210fc14b_tcp
(running on jj-1410fc3-b) the current HDR Primary:
==========
[informix@jj-1410fc3-a ~]$ export INFORMIXSERVER=jj1210fc14a_tcp
[informix@jj-1410fc3-a ~]$ echo "select * from
sysmaster@jj1210fc14b_tcp:sysha_type" | dbaccess sysmaster
Database selected.
ha_type 1
ha_primary jj1210fc14b_tcp
ha_secondary
1 row(s) retrieved.
==========
Starting a 4th Connection Manager and the following results
after a 60 second timeout (i.e. presuming LISTEN_TIMEOUT
reached):
==========
[informix@jj-1410fc3-a ~]$ echo "select * from
sysmaster@jj1210fc14b_tcp:sysha_type" | dbaccess sysmaster
Database selected.
908: Attempt to connect to database server (jj1210fc14b_tcp,
conerr=-27001, oserr=0) failed.
Error in line 1
Near character position 51
==========
The following may be reported in the PRIMARY online.log
==========
13:07:48 (2) soctcp_sighand failed: ASF error: -25579, errno: 0
==========
Shutting down any single Connection Manager and it works |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix 12.10.xC14 and earlier versions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* DIRECT REMOTE SELECT TO PRI FROM LOCAL HDR / RSS WITH 4 *
* CONNECTION MANAGERS AND SLA GROUPS MAY RESULT IN 908 / 27001 *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
Upgrade to 14.10 |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix 12.10.xC14 and earlier versions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* DIRECT REMOTE SELECT TO PRI FROM LOCAL HDR / RSS WITH 4 *
* CONNECTION MANAGERS AND SLA GROUPS MAY RESULT IN 908 / 27001 *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Comment |
Upgrade to Informix 12.10.xC15 or later. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.07.2020
29.12.2020
29.12.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
