Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Error 245/system error 144 Key lock caused by onmode -c block?
Answered: amber (hollow confidence) — Best lead is Ben's suggestion of APAR IT27165 (lock wait not honoured with collection subquery), which he says is independent of onmode -c block; the asker said he would check but never confirmed.
Hal Maner on 12.10.FC7 had a 4GL program with SET LOCK MODE TO WAIT fail with error 245/144, possibly near an onmode -c block/unblock for an external backup. Art Kagel had not seen it. Paul Watson suggested onmode -I 245 to capture an AF file. Benjamin Thompson pointed to defect IT27165 (no lock wait with collection subquery), unrelated to onmode -c block. Hal planned to check his program against it.
💣 This thread may describe something risky to do carelessly
Suggests onmode -I flags that can hang the entire engine, an undocumented diagnostic procedure unsafe on a busy production server.
onmode -I 245
Advisory only — not a substitute for testing in a non-production environment first.
Hal Maner — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to Hal Maner
Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum
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.
↪ replying to Art Kagel
Hal Maner — source: IBM Community (ConnectedCommunity.org) Informix forum
Good to know, thank you Art.
Hal
↪ replying to Hal Maner
Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum
If you can onmode –I 245 and see what is happening at the time ??
Cheers
Paul
↪ replying to Paul Watson
Hal Maner — source: IBM Community (ConnectedCommunity.org) Informix forum
Thanks Paul. You probably mean onlog? Good suggestion – I will see if I can locate something using that.
Hal
↪ replying to Hal Maner
Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum
Benjamin Thompson — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
↪ replying to Benjamin Thompson
Benjamin Thompson — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
↪ replying to Benjamin Thompson
Hal Maner — source: IBM Community (ConnectedCommunity.org) Informix forum
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.