Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Error 245/system error 144 Key lock caused by onmode -c block?

  • 1.  Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 10:20 AM

    Hello everyone,

     

    Wanted to get opinions/see if anyone has run into this before.

     

    12.10.FC7 on Linux.

     

    4GL program running on a busy engine, has "SET LOCK MODE TO WAIT" (indefinitely) yet errors out with error 245/system error 144 during a foreach loop.

     

    USELASTCOMMITTED is set to ALL in onconfig.

     

    All indications are such that this program should *not* have errored out with 245/144, yet it did.

     

    Only clue/suspicion I have is that there was a scheduled onmode -c block/onmode -c unblock running about the same time the error occurred.   This is done to take an external backup of the engine and only took eight seconds according to the online log.

     

    Is there a bug/weakness with relation to onmode -c block/unblock and lock handling?   Any other thoughts?

     

    Thank you,

     

    Hal

     

    Hal Maner

    M Systems International, Inc.

    Phone: +1 (919) 493-6012 ext.4009

    hmaner@msystemsintl.com

    www.msystemsintl.com

     


    #Informix


  • 2.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 10:25 AM
    Good question Hal. I have not seen that, but recently a chunk extension failed during an onmode -c block for an external snapshot backup. That's the only thing I have seen that's similar.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.






    Original Message


  • 3.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 10:27 AM
    Good to know, thank you Art.

    Hal



    Original Message


  • 4.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 10:39 AM

    If you can onmode –I 245 and see what is happening at the time ??

     

    Cheers

    Paul

     




    Original Message


  • 5.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 11:43 AM

    Thanks Paul.   You probably mean onlog?   Good suggestion – I will see if I can locate something using that.

     

    Hal

     




    Original Message


  • 6.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Fri December 13, 2019 09:03 PM
    Nope onmode -I - it will dump an af file when error is encountered and you
    can see what is happening.

    If you set the correct flags, I don't have handy, you can hang the entire
    engine and have a nose around

    Cheers
    Paul

    > Thanks Paul. You probably mean onlog? Good suggestion ??? I will see
    > if I can locate something using that.
    >
    > Hal
    >
    >
    >
    >
    Original Message


  • 7.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Mon December 16, 2019 08:18 AM
    Nope onmode -I - it will dump an af file when error is encountered and you
    can see what is happening.

    If you set the correct flags, I don't have handy, you can hang the entire
    engine and have a nose around

    Cheers
    Paul

    > Thanks Paul. You probably mean onlog? Good suggestion ??? I will see
    > if I can locate something using that.
    >
    > Hal
    >
    >
    >
    >
    Original Message


  • 8.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Tue December 17, 2019 04:59 AM
    Hi Hal,

    This is a bit of a guess but could you be running into this?

    IT27165: NOT WAITING ON A LOCK WITH COLLECTION SUBQUERY AND PARENT QUERY'S WHERE CLAUSE ALLOWING MULTIPLE VALUES
    https://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1IT27165

    Ben.

    ------------------------------
    Benjamin Thompson
    ------------------------------

    Original Message


  • 9.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Tue December 17, 2019 05:11 AM
    Probably I should elaborate my reply a bit more as we reported this defect and worked the case with support. I remember a similar thought process to yours when dealing with this baffling defect:

    1. -245/-144 occurs.
    2. Lock mode for the session set to something large or "wait".
    3. "All indications are such that this program should *not* have errorred out with 245/144, yet it did.".

    Finding that the locking mechanism does not work is not something you expect since it is fundamental.

    If this defect is the cause, it has nothing to do with "onmode -c block", at least not directly.

    Ben.

    ------------------------------
    Benjamin Thompson
    ------------------------------

    Original Message


  • 10.  RE: Error 245/system error 144 Key lock caused by onmode -c block?

    Posted Tue December 17, 2019 12:28 PM

    Thank you very much Ben.   I will take a closer look at the program that errored out to see if it matches this scenario.  Very nicely documented in the link you provided.

     

    Hal

     




    Original Message


Related Content