ORA-7445 [qsmmixFindColInQbc] Core Files Getting Generated in ORACLE_HOME/dbs (Doc ID 1946688.1)

Last updated on APRIL 08, 2015

Applies to:

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

Symptoms

- Test environment
------------------------------------------------------------------
DB1                       DB2                          DB3
11.2.0.4                  11.2.0.4                     11.2.0.3
------------------------------------------------------------------
               DB link                  DB link
table B <---------------- synonym <------------------> table A
            INSERT SELECT
------------------------------------------------------------------
 
The synonym on DB2 was created via DB link from DB2 to DB3, and synonym's base table is table A on DB3.
Run "INSERT tableB@DB1 SELECT * FROM synonym" on DB2.

Dump continued from file: /oracle/admin/CMNPROD1/diag/rdbms/cmnprod_primary/CMNPROD1/trace/CMNPROD1_ora_1092.trc
ORA-07445: exception encountered: core dump [qsmmixFindColInQbc()+25] [SIGSEGV] [ADDR:0x48] [PC:0x6060B55] [Address not mapped to object] []

 

Call stack:

========= Dump for incident 173446 (ORA 7445 [qsmmixFindColInQbc()+25]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x48] [PC:0x6060B55, qsmmixFindColInQbc()+25] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x0000000000000000 %rcx: 0x0000000000000000
%rdx: 0x0000000000000000 %rdi: 0x0000000000000000 %rsi: 0x00007fffb3db2b30
%rsp: 0x00007fffb3db2a50 %rbp: 0x00007fffb3db2a50  %r8: 0x00007fffb3db2b30
%r9: 0x00007fffb3db2a60 %r10: 0x00007fd0f66ba068 %r11: 0x00007fd0f6749b20
%r12: 0x00000000000000b0 %r13: 0x00007fd0f66bf4b0 %r14: 0x000000000000002c
%r15: 0x000000000000002c %rip: 0x0000000006060b55 %efl: 0x0000000000010206
 qsmmixFindColInQbc()+13 (0x6060b49) test %r8,%r8
 qsmmixFindColInQbc()+16 (0x6060b4c) je 0x6060b79
 qsmmixFindColInQbc()+18 (0x6060b4e) movzwl %di,%ecx
 qsmmixFindColInQbc()+21 (0x6060b51) mov 0x8(%r8),%rdx
> qsmmixFindColInQbc()+25 (0x6060b55) mov 0x48(%rdx),%r9
 qsmmixFindColInQbc()+29 (0x6060b59) movzwl 0x6(%r9),%r10d
 qsmmixFindColInQbc()+34 (0x6060b5e) cmp %ecx,%r10d
 qsmmixFindColInQbc()+37 (0x6060b61) jz 0x6060c04
 qsmmixFindColInQbc()+43 (0x6060b67) mov (%r8),%r8

----- Incident Context Dump -----
Address: 0x7fd0f6a9c888
Incident ID: 173446
Problem Key: ORA 7445 [qsmmixFindColInQbc()+25]
Error: ORA-7445 [qsmmixFindColInQbc()+25] [SIGSEGV] [ADDR:0x48] [PC:0x6060B55] [Address not mapped to object] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: __sighandler []
[05]: qsmmixFindColInQbc []<-- Signaling
[06]: qsmmixGetIdxKeyStats []
[07]: qsmmixGenFakeIdxStats []
[08]: ddfdsii []
[09]: ddfdsiin []
[10]: k2udio []
[11]: ddfnetCFull []
[12]: ddfnet2Normal []
[13]: kkmfcbrm [SQL_Semantic]
[14]: kkmpfcbk [SQL_Semantic]
[15]: qcsprfro [SQL_Parser]
[16]: qcsprfro_tree [SQL_Parser]
[17]: qcsprfro_tree [SQL_Parser]
[18]: qcspafq [SQL_Parser]
[19]: qcspqbDescendents [SQL_Parser]
[20]: qcspqb [SQL_Parser]
[21]: kkmdrv [SQL_Semantic]
[22]: opiSem []
[23]: opiDeferredSem []
[24]: opitca []
[25]: kksFullTypeCheck [cursor]
[26]: rpiswu2 []
[27]: kksLoadChild [cursor]
[28]: kxsGetRuntimeLock [cursor]
[29]: kksfbc [cursor]
[30]: kkspsc0 [cursor]
[31]: kksParseCursor [cursor]
[32]: opiosq0 []
[33]: kpooprx []
[34]: kpoal8 []
[35]: opiodr []
[36]: ttcpip []
[37]: opitsk []
[38]: opiino []
[39]: opiodr []
[40]: opidrv []
[41]: sou2o []
[42]: opimai_real []
[43]: ssthrdmain []
[44]: main []
[45]: __libc_start_main []
MD [00]: 'SID'='777.45621' (0x2)
MD [01]: 'ProcId'='72.157' (0x2)
MD [02]: 'PQ'='(0, 1416358551)' (0x6)
MD [03]: 'Client ProcId'='oracle@lnxdb-prd-758 (TNS V1-V3).1092_140535472191232' (0x0)
Impact 0:
Impact 1:
Impact 2:
Impact 3:
Derived Impact:
----- END Incident Context Dump -----

 

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