Instance crashes as LMS0 (ospid: ) has not moved for nnn sec with huge trace after KCL: A59: no lock elements (Doc ID 2119642.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Instance crashed with the error: LMON (ospid: 25741): terminating the instance due to error 481

LMS process was stuck with high waits for "buffer cache"

There was a big trace file generated by the LMS0 process.

Tue Jan 26 13:22:42 2016
LMON (ospid: 25741): terminating the instance due to error 481
Tue Jan 26 13:22:42 2016
System state dump requested by (instance=1, osid=25741 (LMON)),
summary=[abnormal instance termination].
System State dumped to trace file
/oracle/admin/TS1RAO/diag/rdbms/ts1rao/TS1RAO1/trace/TS1RAO1_diag_25729_201601
26132242.trc
Tue Jan 26 13:22:42 2016
opiodr aborting process unknown ospid (16876) as a result of ORA-1092
Tue Jan 26 13:22:47 2016
ORA-1092 : opitsk aborting process
........
Tue Jan 26 13:22:49 2016
Instance terminated by LMON, pid = 25741 <<<<<<<<

LMHB trace files
================
*** 2016-01-26 13:22:23.314
==============================
LMS0 (ospid: 25747) has not moved for 310 sec (1453843342.1453843032)

Short stack dump:
ksedsts()+244<-ksdxfstk()+58<-ksdxcb()+918<-sspuser()+224<-__sighandler()<-wri
te()+16<-sdbgrfwf_write_file()+64<-dbgtfdFileWrite()+674<-dbgtfdFileAccessCbk(
)+357<-dbgtfPutStr()+592<-dbktPri()+149<-ksdwrf()+551<-ksdwrfn()+187<-kcldlei(
)+635<-kcldle()+29<-kcbw_dump_granule_les()+114<-kmgsdpgl()+120<-kmgsdpg()+66<
-kcl_no_le_diag()+1116<-kclexpand()+238<-kclexpandlock()+3115<-kjbmprlst()+152
49<-kjbmchkretryreq()+371<-kjmsm()+11196<-ksbrdp()+1068<-opirip()+1488<-opidrv
()+616<-sou2o()+145<-opimai_real()+270<-ssthrdmain()+412<-main()+236<-__libc_s
tart_main()+253

 

We see there are more buffers in the buffer cache, than lock elements in LMS trace file:

KCL: A59: no lock elements <<
cache size 57656
le locks 37043

 

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