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

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

    Posted 12/13/19 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 12/13/19 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------

    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


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

    Posted 12/13/19 10:27 AM
    Good to know, thank you Art.

    Hal


    ------Original Message------

    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.






    #Informix


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

    Posted 12/13/19 10:39 AM

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

     

    Cheers

    Paul

     



    ------Original Message------

    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


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

    Posted 12/13/19 11:43 AM

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

     

    Hal

     



    ------Original Message------

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

     

    Cheers

    Paul

     




    #Informix


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

    Posted 12/13/19 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------
    >
    > If you can onmode ???I 245 and see what is happening at the time ??
    >
    > Cheers
    > Paul
    >
    >
    >
    >
    >
    > Reply to Sender :
    > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&SenderKey=9cf0d1e1-65c9-4a99-9e66-4b2e41ac4a38&MID=39952&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved
    >
    > Reply to Discussion :
    > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=39952&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved
    >
    >
    >
    > You are subscribed to "Informix" as paul@oninit.com. To change your
    > subscriptions, go to
    > http://community.ibm.com/community/user/preferences?section=Subscriptions&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved.
    > To unsubscribe from this community discussion, go to
    > http://community.ibm.com/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved&GroupKey=60eb97a2-57c0-4130-9b6d-57174f97d5a8.


    --
    Paul Watson
    Tel: +1 913-674-0360
    Mob: +1 913-387-7529
    Web: www.oninit.com

    Oninit? is a registered trademark of Oninit LLC

    Failure is not as frightening as regret.
    If you want to improve, be content to be thought foolish and stupid.
    What this country needs are more unemployed politicians

    ------Original Message------

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

     

    Hal

     




    #Informix


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

    Posted 12/16/19 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------
    >
    > If you can onmode ???I 245 and see what is happening at the time ??
    >
    > Cheers
    > Paul
    >
    >
    >
    >
    >
    > Reply to Sender :
    > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&SenderKey=9cf0d1e1-65c9-4a99-9e66-4b2e41ac4a38&MID=39952&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved
    >
    > Reply to Discussion :
    > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=39952&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved
    >
    >
    >
    > You are subscribed to "Informix" as paul@oninit.com. To change your
    > subscriptions, go to
    > http://community.ibm.com/community/user/preferences?section=Subscriptions&MDATE=756%253e467468&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved.
    > To unsubscribe from this community discussion, go to
    > http://community.ibm.com/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved&GroupKey=60eb97a2-57c0-4130-9b6d-57174f97d5a8.


    --
    Paul Watson
    Tel: +1 913-674-0360
    Mob: +1 913-387-7529
    Web: www.oninit.com

    Oninit? is a registered trademark of Oninit LLC

    Failure is not as frightening as regret.
    If you want to improve, be content to be thought foolish and stupid.
    What this country needs are more unemployed politicians

    ------Original Message------

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

     

    Hal

     




    #Informix


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

    Posted 12/17/19 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
    ------------------------------



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

    Posted 12/17/19 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 12/17/19 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------

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

    #Informix


Related Content