IBM Support

IT33697: DIRECT REMOTE SELECT TO PRI FROM LOCAL HDR / RSS WITH 4 CONNECTION MANAGERS AND SLA GROUPS MAY RESULT IN 908 / 27001

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error 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
    

Local fix

  • Upgrade to 14.10
    

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:                                              *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Informix 12.10.xC15 or later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33697

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-27

  • Closed date

    2020-12-29

  • Last modified date

    2020-12-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
30 December 2020