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.  Informix 14.10xc8 crash

    Posted Tue May 27, 2025 10:29 AM

    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



  • 2.  RE: Informix 14.10xc8 crash

    Posted Tue May 27, 2025 10:52 AM

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



  • 3.  RE: Informix 14.10xc8 crash

    Posted Tue May 27, 2025 11:55 AM

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



  • 4.  RE: Informix 14.10xc8 crash

    Posted Tue May 27, 2025 12:04 PM
    <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...





  • 5.  RE: Informix 14.10xc8 crash

    Posted Mon June 02, 2025 06:10 AM

    Hello,

     

    Thank you. We 'll try this solution.

    Do you know if this problem was fixed ?

     

    Regards

     






  • 6.  RE: Informix 14.10xc8 crash

    Posted Tue May 27, 2025 01:02 PM

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



  • 7.  RE: Informix 14.10xc8 crash

    Posted Tue May 27, 2025 11:00 AM
    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!