IBM Support

JR40602: IMPLICIT ROLLBACK CAUSES SERVER FLUSH WHICH MAY CAUSE DB2 CRASH.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Implicitly rollback after DDL operation may lead server deleted
    which may cause DB2 instance crash with below call stack:
    
    
    ================================================================
    -------Frame------ ------Function + Offset------
    0x0900000005B46AA8
    sqlqg_build_FMP_Request__F22sqlqg_FMP_Request_TypeP24sqlqg_FMP_R
    untime_ObjectPP17sqlqg_FMP_Request + 0x6F4
    0x09000000033ACFF4 sqlqgFedStart__FP14UnfencedServerc + 0x630
    0x0900000004F035E0 sqlqgClose__FP12sqlri_rquerys + 0x6FC
    0x0900000004F02B20 sqlqgClose__FP12sqlri_rquerys@glue84E + 0x78
    0x0900000004444294
    sqlricjpInfrequent__FP8sqlrr_cbPP12sqlri_opparml + 0x18C
    0x0900000006DB411C sqlricjp__FP8sqlrr_cbP12sqlri_opparmilT4 +
    0x428
    0x0900000006DA3EF4 sqlricls_complex__FP8sqlrr_cbilN23 + 0x570
    0x0900000006DA009C sqlricls_complex__FP8sqlrr_cbilN23@glue858 +
    0x78
    0x0900000006E6ED44
    @88@158562@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_
    siblingiN63 + 0xC4
    0x0900000006E6F1A0
    sqlra_close_sections_on_finalcmt_rollback__FP8sqlrr_cb + 0x60
    0x0900000006D836F0 sqlra_close_sections__FP8sqlrr_cbUiT2 + 0x10
    0x0900000006D84FD4
    sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x32C
    0x0900000006EB447C sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO +
    0x36C
    0x0900000006EB3DAC sqlrr_rollback__FP14db2UCinterface + 0x19C
    0x0900000006F1B268
    sqljsRollbackBeforeConnectReset__FP14db2UCconHandle + 0x14C
    0x0900000006F1B734
    @64@sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x410
    0x0900000006F19594
    @64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2C0
    0x0900000006F18F58 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0xEC
    0x0900000006C0E314 RunEDU__8sqeAgentFv + 0x238
    0x0900000006C0FF10 EDUDriver__9sqzEDUObjFv + 0xDC
    0x0900000006C0A3CC sqloEDUEntry + 0x260
    
    OR
    0x090000008237D068 lockHash__FPUc + 0xC8
    0x090000008237F6DC sqlqgValidateServer__FPUcPvPP11Server_InfoT2
    + 0x13C
    0x0900000082356C60
    sqlqgFindServer__FPUc12Sqlqg_OpTypePP14UnfencedServerUi + 0x420
    0x090000008235E578
    sqlqgFindUser__FPUc12Sqlqg_OpTypePP19UnfencedRemote_UserPbUib +
    0x198
    0x090000008229BAB8
    find_current_remote_user__14UnfencedServerFPP19UnfencedRemote_Us
    erPb12Sqlqg_OpType + 0x198
    0x0900000082605438
    sqlqg_build_FMP_Request__F22sqlqg_FMP_Request_TypeP24sqlqg_FMP_R
    untime_ObjectPP17sqlqg_FMP_Request + 0xF58
    0x0900000082711B18 sqlqgFedStart__FP14UnfencedServerc + 0xA18
    0x090000008233C9A8 sqlqgFetch__FP12sqlri_rquery + 0x2C8
    0x090000008248EC18 sqlri_djx_rta__FP8sqlrr_cb + 0xCD8
    0x0900000080A04BE4 sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm +
    0x584
    0x0900000080A0575C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x4DC
    0x0900000081D97728
    sqlrr_process_fetch_request__FP14db2UCinterface + 0xE48
    0x0900000081D9E220
    sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xD60
    
    The trap can be recreated with blew steps:
    There are two connections which operate the same federated
    server.
    
    => db2 get db cfg for feddb | grep -i lock
     Lock timeout (sec)                        (LOCKTIMEOUT) = 10
    
    UOW1
    |  UOW2
    db2 +c
    |  db2 +c
    declare c1 cursor with hold for select * from n1   |
    open c1
    |
    commit
    |
    
    |  select * from n1
    
    |  commit
    
    |  DDL(create another nickname/drop server...)
    
    |  force application
    close c1/fetch c1 -- DB2 crash!                             |
    

Local fix

Problem summary

  • User affected:
      Users of the Federation Server DDL in InfoSphere Federation
    Server
    Problem description and summay:
      See error description
    

Problem conclusion

  • Problem was fistly fixed in Version 9.7, FixPak 6. This
    fix should be applied on the federation Server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR40602

  • Reported component name

    WS FED SVR INST

  • Reported component ID

    5724N9701

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-08

  • Closed date

    2012-06-10

  • Last modified date

    2012-06-10

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

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

    JR41575

Fix information

  • Fixed component name

    WS FED SVR INST

  • Fixed component ID

    5724N9701

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Installation

Software version: 9.7

Reference #: JR40602

Modified date: 10 June 2012