Hello,
Thank you. We 'll try this solution.
Do you know if this problem was fixed ?
Regards
Original Message:
Sent: 5/27/2025 12:04:00 PM
From: Paul Watson
Subject: RE: Informix 14.10xc8 crash
<quote>
If you blindly set all active bits 0 you don't know what all functionality you're impacting (I don't either).
</quote>
God help us if you don't know :)
On 5/27/2025 10:54 AM, Andreas Legner via IBM TechXchange Community wrote:
0100019712742e32-1d5956bb-a0a9-4b5c-b3f8-d23f7cf0dee4-000000@email.amazonses.com"> Careful with simply setting this 0. It's a bit field with a couple of bits on by default, one of them being the "VARLEN SORT" one (0x20). If...
Original Message:
Sent: 5/27/2025 11:55:00 AM
From: Andreas Legner
Subject: RE: Informix 14.10xc8 crash
Careful with simply setting this 0. It's a bit field with a couple of bits on by default, one of them being the "VARLEN SORT" one (0x20).
If you blindly set all active bits 0 you don't know what all functionality you're impacting (I don't either).
So to only disable this particular flag, first get the current setting using "onstat -g cfg SQL_DEF_CTRL". In my version it defaults to 0x44004b0.
Now remove 0x20 from this value -> 0x4400490
This is what you want to set the parameter to now: onmode -wf SQL_DEF_CTRL=0x4400490
HTH,
Andreas
------------------------------
Andreas Legner
Informix Dev
HCL Software
------------------------------
Original Message:
Sent: Tue May 27, 2025 10:52 AM
From: Mike Walker
Subject: Informix 14.10xc8 crash
It looks like the issues described here: Cisco Bug: CSCvv77137 - Variable length column sort flag not turned off for Unity instance leading to DB communication error
I don't see a resolution to this in particular, but the message suggests modifying SQL_DEF_CTRL. If it's not in you onconfig already, you can add it and set it to 0, and/or use onmode -wf SQL_DEF_CTRL=0. This can be used to control certain behaviors within informix, so there is probably a value that only disables the VAR_LEN_SORT functionality, but because it's undocumented, then you will likely need to reach out to IBM. It may be fixed in a later version, and support can find that out for you.
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
Original Message:
Sent: Tue May 27, 2025 10:28 AM
From: Garcia Benjamin
Subject: Informix 14.10xc8 crash
Hello,
Anybody has facing this situation ?
20:14:49
20:14:49 IBM Informix Dynamic Server Version 14.10.FC8AEE
20:14:49 Assert Failed: VARLEN SORT - compressed row len 32754 > srt_rowsize 3870
20:14:49 Who: Session(******************, 1336024, 0x4c0a6b28)
Thread(673511, sqlexec, 4c081b28, 9)
File: sqitsort.c Line: 1667
20:14:49 Results: Sort failed.
20:14:49 Action: Turn off VARLEN SORT using SQL_DEF_CTRL onconfig parameter.
onconfig sql-def-ctrl ?
known bug ?
after this assertion then this assertion and informix crash
20:15:35 IBM Informix Dynamic Server Version 14.10.FC8AEE
20:15:35 Assert Failed: No Exception Handler
20:15:35 Who: Session(751879, *********, 0x4c0ad0a8)
Thread(752689, noname, 4c06ce28, 8)
File: mtex.c Line: 569
20:15:35 Results: Exception Caught. Type: MT_EX_OS, Context: mem
20:15:35 Action: Please notify IBM Informix Technical Support.
Any help would be welcome
thanks
Benjamin