IT28941: SELECTING SBLOB BSON DATA CAN RETURN -937 ERROR BSON_TO_CHAR: MI_LO_TO_BUFFER RETURNED XXX, BUT THE UDT HAD YYY BYTES

APAR status

• Closed as program error.

Error description

• This problem was reported on aix64 running 12.10.FC9.  My repro
  illustrates the problem on this
  version and I've also confirmed it reproduces on aix64 running
  12.10.FC12W1.  I have not been
  able to dupe on linux x86_64 yet and while I think it is still
  an issue there, my repro may not be
  exposing it because of 2k versus 4k sbspace page sizes and the
  size of smart blobs my bson data
  is storing.
  
  You will typically see a -937 error and a query of bson data
  will return an error like this in my repro:
  
  (U0001) - bson_to_char: mi_lo_to_buffer returned 0, but the UDT
  had 4176 bytes
  Error in line 2
  Near character position 55
  
  The customer reported similar errors:
  
  (U0001) - bson_to_char: mi_lo_to_buffer returned 4068, but the
  UDT had 8498 bytes
  
  Trapping for a -937 error on the server produces a stack like
  this:
  
  0x00000001000ac888 (oninit)afhandler
  0x00000001000ad2b8 (oninit)affail_interface
  0x00000001001b4954 (oninit)check_traperror
  0x00000001001772bc (oninit)sqerr@AF32_1
  0x0000000100173848 (oninit)sqerr1
  0x000000010017b8f4 (oninit)sqapi_sqlstate_setup
  0x000000010017b7c0 (oninit)sqapi_udr_error
  0x000000010096c6e4 (oninit)mi_db_error_raise
  0x0000000100b33c08 (oninit)bson_to_char
  0x0000000100b3103c (oninit)json_output
  0x0000000100e6f448 (oninit)udrlm_clang_execute_internal
  0x0000000100e6ef40 (oninit)udrlm_clang_execute
  0x00000001015aff18 (oninit)udrlm_exec_routine
  0x00000001005f80b4 (oninit)udr_execute
  0x000000010048d1ec (oninit)ev_udr
  0x00000001004822a0 (oninit)new_eval
  0x0000000100989964 (oninit)evalcols
  0x000000010098309c (oninit)getrow
  0x000000010098426c (oninit)fetchrow
  0x0000000100b5a1d4 (oninit)exfetch
  0x00000001007c1ca4 (oninit)sql_nfetch
  0x00000001007c1374 (oninit)sq_nfetch
  0x000000010070a00c (oninit)sqmain
  0x0000000100c65618 (oninit)listen_verify
  0x0000000100c6423c (oninit)spawn_thread
  0x0000000100ff5b20 (oninit)th_init_initgls
  0x00000001017cdba0 (oninit)startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS versions prior to 12.10.xC14.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Selecting sblob bson data can return -937 error              *
  * bson_to_char: mi_lo_to_buffer returned xxx, but the UDT had  *
  * yyy bytes.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC14.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels