Query is Causing ORA-7445 [LPXFSMSAXSE()+504] Error
(Doc ID 1631399.1)
Last updated on JULY 20, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |