Global Enqueue Services Deadlock导致节点重启

Global Enqueue Services Deadlock导致节点重启

日志中报错信息如下：
sun sep 02 01:29:47 2012
global enqueue services deadlock detected. more info in file
 /u01/app/11.1.0/diag/rdbms/zzbrac2/zzbrac21/trace/zzbrac21_lmd0_11802.trc.
sun sep 02 01:30:30 2012
thread 1 advanced to log sequence 16189 (lgwr switch)
  current log# 7 seq# 16189 mem# 0: +datadg/zzbrac2/onlinelog/group_7.660.791891943
  current log# 7 seq# 16189 mem# 1: +datadg/zzbrac2/onlinelog/group_7.1693.791891943
sun sep 02 01:41:28 2012
alter system set service_names='sys$sys.kupc$s_1_20120902010315.zzbrac2','zzbrac2' scope=memory sid='zzbrac21';
alter system set service_names='zzbrac2' scope=memory sid='zzbrac21';
sun sep 02 01:59:27 2012
clearing resource manager plan via parameter
sun sep 02 01:59:35 2012
thread 1 advanced to log sequence 16190 (lgwr switch)
  current log# 8 seq# 16190 mem# 0: +datadg/zzbrac2/onlinelog/group_8.3050.791891983
  current log# 8 seq# 16190 mem# 1: +datadg/zzbrac2/onlinelog/group_8.2893.791891985
thread 1 advanced to log sequence 16191 (lgwr switch)
  current log# 1 seq# 16191 mem# 0: +datadg/zzbrac2/onlinelog/group_1.264.733863259
  current log# 1 seq# 16191 mem# 1: +datadg/zzbrac2/onlinelog/group_1.265.733863261
sun sep 02 02:04:12 2012
lmon (ospid: 11800) has not called a wait for 87 secs.
sun sep 02 02:04:43 2012
lmon (ospid: 11800) has not called a wait for 118 secs.
error: lmon is not healthy and has no heartbeat.
error: lmd0 (ospid: 11802) is terminating the instance.
lmd0 (ospid: 11802): terminating the instance due to error 482
sun sep 02 02:04:43 2012
system state dump is made for local instance
system state dumped to trace file /u01/app/11.1.0/diag/rdbms/zzbrac2/zzbrac21/trace/zzbrac21_diag_11788.trc
instance terminated by lmd0, pid = 11802
 
原因分析：
01:29:47的时候，，全局队列死锁（由应用造成）
02 02:04 lmon（全局队列服务监视进程）不能被调用
                 lmon 不健康并没有心跳
                 lmd0 （全局队列服务守护进程）重启实例
 
初步判断是由应用造成死锁，导致lmon hang住，lmd0 将实例重启。

造点AI

夸克 · 造点AI

325

查看详情