IT35581: SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N.

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• The segv/trap occurs when:
  The XML search condition includes an empty string e.g.
  /book[price=""]
  /book[price>""]
  /book[price/text()!=""]
  
  An XML index with DOUBLE data type exists on the expression used
  in the predicate e.g. CREATE INDEX <indname> ON
  bookstore(bookdetails) GENERATE KEY USING XMLPATTERN
  '/book/price' AS SQL double;
  XML histogram statistics exist for the expression used in the
  predicate and the index. XML statistics are not visible in the
  system catalog views so db2cat must be used to display them.
  
  
  The trap is sustainable. The application will receive:
  
  SQL1224N The database manager is not able to accept new
  requests,
  has terminated all requests in progress, or has terminated the
  specified
  request because of an error or a forced interrupt.
  SQLSTATE=55032
  
  The stack trace will include
  sqlno_xml_stats_interface11convLiteral
  

Local fix

• Either of these approaches will avoid the trap:
  - Exclude XML statistics by issuing RUNSTATS with the EXCLUDING
  XML COLUMNS clause
  - Drop the index on the XML expression
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The segv/trap occurs when:                                   *
  * The XML search condition includes an empty string e.g.       *
  * /book[price=""]                                              *
  * /book[price>""]                                              *
  * /book[price/text()!=""]                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2_v111m4fp7 or v11.5(already fixed).            *
  ****************************************************************
  

Problem conclusion

• First fixed in db2_v111m4fp7
  

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

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP