Guest

Preview Tool

Cisco Bug: CSCvv77137 - Variable length column sort flag not turned off for Unity instance leading to DB communication error

Last Modified

Sep 21, 2020

Products (1)

  • Cisco Unity Connection

Known Affected Releases

11.5 12.5 14.0

Description (partial)

Symptom:
1- Database Communication Error while login through the UI for Publisher and Subscriber
2- While logging and running any CLI it throws error , unable to connect to ciscounity instance
3- Informix logs doesn't show any checkpoint happening in the logs and are stucked with thread suspended error shown below ,

08/21/20 01:24:30   Action: Please notify IBM Informix Technical Support.
08/21/20 01:24:30   See Also: /usr/local/cm/db/informix/tmp/af.a367687
08/21/20 01:24:32  While attempting to clean up and suspend itself, thread 1614 has
          generated too many assertions. This thread will now hang without
          completing its cleanup.
08/21/20 01:24:32  Thread ID 1614 will now be suspended.
08/21/20 01:26:11  Checkpoint Completed:  duration was 0 seconds.
08/21/20 01:26:11  Fri Aug 21 - loguniq 196, logpos 0x121a018, timestamp: 0xfc8b227 Interval: 54133

4- Informix reports core for cuc instance with below signature in informix logs pointing to issue,

06:52:51  Assert Failed: VARLEN SORT - compressed row len 25748 > srt_rowsize 980
06:52:51   Who: Session(497098, cucli@den01hc010cuc01, 25128, 0x4bef7488)
                Thread(767846, sqlexec, 4e76d5ec, 1)
                File: sqitsort.c Line: 1723
06:52:51   Results: Sort failed.
06:52:51   Action: Turn off VARLEN SORT using SQL_DEF_CTRL onconfig parameter.
06:52:51  SHM Globals and Master Pool/Master Block Adresses:

Conditions:
For 2 customers we have we have seen this condition happening when ,
- Customer running some tool or CLI session which runs below DB query found in assertion DB sessions ,

Last parsed SQL statement :
  select alias as UserID, count (*) as messages, min(arrivaltime) as
    OldestMessageTime, vw_mailbox.bytesize from vw_message, vw_mailbox,
    unitydirdb:vw_mailbox, unitydirdb:vw_user where
    vw_message.mailboxobjectid=vw_mailbox.mailboxobjectid and
    vw_mailbox.mailboxobjectid in (select mailboxid from vw_mailbox where
    unitydirdb:vw_user.objectid = unitydirdb:vw_mailbox.userobjectid) group by
    alias, vw_mailbox.bytesize order by messages desc


- Ungraceful shutdown observed just after the assertion starts to happen leading to thread for informix been suspended


Note - We are not able to reproduce the assertion in lab with aboev scenarios or combination but both customers has been recovered successfully by following the workaround confirming the issue
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.