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

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

Hello Garcia, Put it briefly, the SQL_DEF_CTR is an undocumented parameter. You are able to observe the real value on your system with 'onstat -g cfg full SQL_DEF_CTR'. I suppose if you set this parameter with this value '0x400000' (onmode -wf SQL_DEF_CTRL=0x400000), you can continue to enjoy from Informix! Have a good time!

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

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

How do you know that the 0x20 is for the VARLEN SORT? Is that something that we can find somewhere or just something that you happen to know? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------

Hello, Thank you. We 'll try this solution. Do you know if this problem was fixed ? Regards