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

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

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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

Good to know, thank you Art. Hal

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

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

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

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

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

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

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