ORA-7445 [KWQBMSPQUEUE()+278] [SIGSEGV] Every Minute Since Upgraded To RDBMS 19c.
(Doc ID 2608649.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
RDBMS alert log filed up with following error:
2019-06-10T16:33:09.672637-04:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFE4CEBEFE0]
[PC:0x7B77876, kwqbmspqueue()+278] [flags: 0x0, count: 1]
Errors in file
/u01/app/oracle/diag/rdbms/choice/choice/trace/choice_q001_24268.trc
(incident=36538):
ORA-07445: exception encountered: core dump [kwqbmspqueue()+278] [SIGSEGV]
[ADDR:0x7FFE4CEBEFE0] [PC:0x7B77876] [Address not mapped to object] []
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFE4CEBEFE0]
[PC:0x7B77876, kwqbmspqueue()+278] [flags: 0x0, count: 1]
Errors in file
/u01/app/oracle/diag/rdbms/choice/choice/trace/choice_q001_24268.trc
(incident=36538):
ORA-07445: exception encountered: core dump [kwqbmspqueue()+278] [SIGSEGV]
[ADDR:0x7FFE4CEBEFE0] [PC:0x7B77876] [Address not mapped to object] []
The QMON (q00) background process trace file shows call stack similar to these functions:
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: ssexhd []
[03]: sslssSynchHdlr []
[04]: sslsshandler []
[05]: __sighandler []
[06]: kwqbmspqueue [AQ]<-- Signaling
[07]: kwqbmspmain_switch [AQ]
[08]: kwqbmspmain [AQ]
[09]: kwqmnslv [AQ_TM]
[10]: kwsbsmspm [AQ_BACK]
[11]: kwsbgcbkms [AQ_BACK]
[12]: ksvrdp_int [ksv_trace]
[13]: opirip [OPI]
[14]: opidrv [OPI]
[15]: sou2o []
[16]: opimai_real [OPI]
[17]: ssthrdmain []
[18]: main []
[19]: __libc_start_main []
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: ssexhd []
[03]: sslssSynchHdlr []
[04]: sslsshandler []
[05]: __sighandler []
[06]: kwqbmspqueue [AQ]<-- Signaling
[07]: kwqbmspmain_switch [AQ]
[08]: kwqbmspmain [AQ]
[09]: kwqmnslv [AQ_TM]
[10]: kwsbsmspm [AQ_BACK]
[11]: kwsbgcbkms [AQ_BACK]
[12]: ksvrdp_int [ksv_trace]
[13]: opirip [OPI]
[14]: opidrv [OPI]
[15]: sou2o []
[16]: opimai_real [OPI]
[17]: ssthrdmain []
[18]: main []
[19]: __libc_start_main []
Changes
RDBMS upgraded to 19c or a fresh install.
Using Advanced Queue, either user or system queues.
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 |