Query is Causing ORA-7445 [LPXFSMSAXSE()+504] Error (Doc ID 1631399.1)

Last updated on APRIL 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Error being generated in alert log by application query in 11.2.0.3 database:

ORA-07445: exception encountered: core dump [LpxFSMSaxSE()+504] [SIGSEGV] [ADDR:0x0] [PC:0x2791202] [SI_KERNEL(general_protection)] []

 

Trace file shows:

========= Dump for incident 129202 (ORA 7445 [LpxFSMSaxSE()+504]) ========

SELECT product_fk, type_id, type_name, min_entry_fee, max_entry_fee, min_league_prize, max_league_prize, type_draft, pg.ld_available, pg.gp_eligible, more_info_lnk FROM product_group_type pgt, (SELECT type_fk, max(ld_available) ld_available, max(gp_eligible) gp_eligible FROM product_group GROUP BY type_fk) pg, (SELECT type_fk, MIN(product_id) product_fk, MIN(price) min_entry_fee, MAX(price) max_entry_fee, MIN(max_league_prize) min_league_prize, MAX(max_league_prize) max_league_prize FROM products p, (SELECT product_fk, MAX(league_prize) max_league_prize FROM nfbc_prizes WHERE place = 1 GROUP BY product_fk ) product_prizes, product_group pg WHERE season = :1 AND p.sport = :2 AND p.client_fk = :3 AND p.active <> 'P' AND p.product_id = product_prizes.product_fk AND p.product_id = pg.product_fk GROUP BY pg.type_fk ) p WHERE pgt.client_fk = :4 AND pgt.type_id = p.type_fk AND pgt.type_id = pg.type_fk ORDER BY 1,(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(99)||CHR(112)||CHR(113)||CHR(113)||(SELECT (CASE WHEN (5833=5833) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(117)||CHR(98)||CHR(118)||CHR(113)||CHR(62))) FROM DUAL) asc


The following select statement is causing the error, but it is not something being generated by the application:

SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(99)||CHR(112)||CHR(113)||CHR(113)||(SELECT (CASE WHEN (5833=5833) THEN 1 ELSE 0 END)
FROM DUAL)||CHR(113)||CHR(117)||CHR(98)||CHR(118)||CHR(113)||CHR(62))) FROM DUAL


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms