linux内核异常分析ecp,Time Since Chkpt异常

最新推荐文章于 2022-12-02 21:16:50 发布
最新推荐文章于 2022-12-02 21:16:50 发布
阅读量184 收藏
点赞数
文章标签： linux内核异常分析ecp

1、异常现象

[oracle@localhost

~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version

11.1.1.0.0 Build 078

Linux,

x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All

rights reserved.

GGSCI

(localhost.localdomain) 1> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

00:00:00      unknown

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

2、尝试关闭异常进程重启

GGSCI

(localhost.localdomain) 2> stop *

Sending

STOP request to EXTRACT EXT-ECP ...

ERROR: sending message to EXTRACT EXT-ECP (Timeout waiting for message).

Sending

STOP request to EXTRACT EXT-EDS ...

ERROR: sending message to EXTRACT EXT-EDS (Timeout waiting for message).

Sending

STOP request to EXTRACT EXT-XZ ...

ERROR: sending message to EXTRACT EXT-XZ (Timeout waiting for message).

Sending

STOP request to EXTRACT P-EDS ...

ERROR: sending message to EXTRACT P-EDS (Timeout waiting for message).

Sending

STOP request to EXTRACT P-XZ ...

ERROR: sending message to EXTRACT P-XZ (Timeout waiting for message).

Sending

STOP request to REPLICAT REP-BOS ...

ERROR: sending message to REPLICAT REP-BOS (Timeout waiting

for message).

GGSCI

(localhost.localdomain) 3> stop mgr!

Sending

STOP request to MANAGER ...

Request

processed.

Manager

stopped.

GGSCI

(localhost.localdomain) 4> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

STOPPED

EXTRACT

RUNNING     EXT-ECP

00:00:00      unknown

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

GGSCI (localhost.localdomain) 5> kill EXT-ECP

ERROR:

Manager not currently running.

GGSCI (localhost.localdomain) 6> kill EXT-EDS

ERROR:

Manager not currently running.

GGSCI

(localhost.localdomain) 7> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

STOPPED

EXTRACT

RUNNING     EXT-ECP

00:00:00      unknown

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

GGSCI (localhost.localdomain) 8> exit

--使用stop 进程，stop

mgr，kill 进程都不能正常关闭这些进程

3、系统系统级别kill相关ogg进程

[oracle@localhost OGG]$ ps -ef|grep /opt/OGG

oracle    7479

1  0 Nov10 ?        00:03:31

/opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-ecp.prm REPORTFILE

/opt/OGG/dirrpt/EXT-ECP.rpt PROCESSID EXT-ECP USESUBDIRS

oracle    7480

1  0 Nov10 ?        00:02:30

/opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-eds.prm REPORTFILE

/opt/OGG/dirrpt/EXT-EDS.rpt PROCESSID EXT-EDS USESUBDIRS

oracle    7482

1  0 Nov10 ?        00:03:07

/opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-xz.prm REPORTFILE

/opt/OGG/dirrpt/EXT-XZ.rpt PROCESSID EXT-XZ USESUBDIRS

oracle    7483

1  0 Nov10 ?        00:00:01

/opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-eds.prm REPORTFILE

/opt/OGG/dirrpt/P-EDS.rpt PROCESSID P-EDS USESUBDIRS

oracle    7485

1  0 Nov10 ?        00:00:03

/opt/OGG/replicat PARAMFILE /opt/OGG/dirprm/rep-bos.prm REPORTFILE

/opt/OGG/dirrpt/REP-BOS.rpt PROCESSID REP-BOS USESUBDIRS

oracle    7518

1  0 Nov10 ?        00:00:01 ./server -p 7847 -k -l

/opt/OGG/ggserr.log

oracle    7677

1  0 Nov10 ?        00:00:15

/opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-xz.prm REPORTFILE

/opt/OGG/dirrpt/P-XZ.rpt PROCESSID P-XZ USESUBDIRS

oracle   25261 25112  0 12:48 pts/1    00:00:00

grep /opt/OGG

[oracle@localhost OGG]$ kill -9 7479 7480 7482 7483

7485  7518 7677

[oracle@localhost OGG]$ ps -ef|grep /opt/OGG

oracle   25264 25112  0 12:48 pts/1    00:00:00

grep /opt/OGG

4、重启所有ogg进程

[oracle@localhost

OGG]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version

11.1.1.0.0 Build 078

Linux,

x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All

rights reserved.

GGSCI

(localhost.localdomain) 1> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

STOPPED

EXTRACT

ABENDED     EXT-ECP

00:00:00      unknown

EXTRACT

ABENDED     EXT-EDS

00:00:00      unknown

EXTRACT

ABENDED     EXT-XZ

00:00:00      unknown

EXTRACT

ABENDED     P-EDS

00:00:00      unknown

EXTRACT

ABENDED     P-XZ

00:00:00      unknown

REPLICAT

ABENDED     REP-BOS

00:00:00      unknown

--进程状态还是异常

GGSCI

(localhost.localdomain) 2> start mgr

Manager

started.

GGSCI

(localhost.localdomain) 3> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

00:00:00      unknown

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

--进程起来了，但是Time Since Chkpt还是不正确

GGSCI

(localhost.localdomain) 4> stop ext-ecp

Sending

STOP request to EXTRACT EXT-ECP ...

Request

processed.

GGSCI

(localhost.localdomain) 5> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

STOPPED     EXT-ECP

unknown       00:00:02

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

--关闭EXT-ECP测试，状态正常

GGSCI

(localhost.localdomain) 6> start ext-ecp

Sending

START request to MANAGER ...

EXTRACT

EXT-ECP starting

GGSCI

(localhost.localdomain) 7> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

unknown       00:00:14

EXTRACT

RUNNING     EXT-EDS

00:00:00      unknown

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

--Lag异常，等待恢复

GGSCI

(localhost.localdomain) 8> stop ext-eds

Sending

STOP request to EXTRACT EXT-EDS ...

Recovery

is not complete.  This normal stop will wait and checkpoint recovery's

work

when recovery has finished. To force Extract to stop now,

use the SEND EXTRACT EXT-EDS, FORCESTOP command.

--因为恢复没有完成导致该提示，可以忽略，等待

GGSCI

(localhost.localdomain) 9> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

unknown       00:00:02

EXTRACT

STOPPED     EXT-EDS

01:51:12      00:00:01

EXTRACT

RUNNING     EXT-IM

00:00:00      1059:44:26

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      unknown

GGSCI

(localhost.localdomain) 10> start ext-eds

Sending

START request to MANAGER ...

EXTRACT

EXT-EDS starting

GGSCI

(localhost.localdomain) 11> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

99:53:02      00:00:01

EXTRACT

RUNNING     EXT-EDS

01:51:12      00:00:10

EXTRACT

RUNNING     EXT-XZ

00:00:00      unknown

EXTRACT

RUNNING     P-EDS

00:00:00      unknown

EXTRACT

RUNNING     P-XZ

00:00:00      unknown

REPLICAT

RUNNING     REP-BOS

00:00:00      00:00:00

GGSCI

(localhost.localdomain) 12> stop ext-xz

Sending

STOP request to EXTRACT EXT-XZ ...

Request

processed.

GGSCI

(localhost.localdomain) 13> start ext-xz

Sending

START request to MANAGER ...

EXTRACT

EXT-XZ starting

GGSCI

(localhost.localdomain) 15> stop p-eds

Sending

STOP request to EXTRACT P-EDS ...

Request

processed.

GGSCI

(localhost.localdomain) 16> start p-eds

Sending

START request to MANAGER ...

EXTRACT

P-EDS starting

GGSCI

(localhost.localdomain) 17> stop p-xz

Sending

STOP request to EXTRACT P-XZ ...

Request

processed.

GGSCI

(localhost.localdomain) 18> start p-xz

Sending

START request to MANAGER ...

EXTRACT

P-XZ starting

GGSCI

(localhost.localdomain) 19> info all

Program

Status      Group

Lag           Time Since

Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING     EXT-ECP

00:00:00      00:00:01

EXTRACT

RUNNING     EXT-EDS

00:00:00      00:00:10

EXTRACT

RUNNING     EXT-IM

00:00:00      1059:45:28

EXTRACT

RUNNING     EXT-XZ

00:00:00      00:00:07

EXTRACT

RUNNING     P-EDS

00:00:00      00:00:04

EXTRACT

RUNNING     P-XZ

00:00:00      00:00:05

REPLICAT

RUNNING     REP-BOS

00:00:00      00:00:05

--重启所有异常进程，ogg工作正常

GGSCI

(localhost.localdomain) 20>

胡吃海
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
OGG中 Lag at Chkpt Time Since Chkpt
jnrjian的博客
04-04 2513
1.Lag at Chkpt extract中为什么会出现lag， 正常情况，系统繁忙基本不会出现，但是如果就一个session在运行，很长时间没有commit，那么上一次commit的时间和现在系统时间的差距就是Lag at Chkpt 的值。或者extract hang住了，停在了上一个checkpoint点，也就有了差值。 2.Lag at Chkpt replicat中为什么会出现lag，如果处理某一个trail文件，源trail文件中两次checkpoint时间很长，那么处理完上一...
Time Since Chkpt异常
ciyu405667的专栏
04-03 871
1、异常现象 [oracle@localhost ~]$ ggsci Oracle GoldenGate Command Interpreter for Oracle ...
ogg 通过 info 查询 Lag at Chkpt／Time Since Chkpt 说明
cuimijie1971的博客
07-28 2267
diff b/w Lag at Chkpt and Time Since Chkpt https://community.oracle.com/thread/3948669 例如： ...
记一次OGG的P进程Time Since Chkpt的时间不断增长
不积跬步无以至千里
09-26 6984
1、现象，如图红色箭头所示的时间一直增长。而且，整个OGG没有任何报错信息（现已经解决了） 2、尝试问题解决过程，试过重新从当前时间开始P进程。命令：alterEXTRACTPN_W begin now 但是问题依然存在。尝试重新删除P进程然后重建P进程发现问题还是存在。 注意：上述操作都是在非工作时间（即没有业务数据产生的情况下，或者关闭生成系统的情况下）进行。 3、上述问题维持...
nvmalloc_chkpt
07-07
标题中的“nvmalloc_chkpt”很可能是一个与非易失性内存（Non-Volatile Memory，简称NVM）管理相关的项目或者工具，它可能涉及到内存分配、持久化存储以及检查点（checkpoint）等概念。在描述中，我们看到一系列用于...
【OGG】Rac管理OGG高可用.pdf
02-13
通过本文档，可以完成通过集群软件管理ogg的...Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING TESTEXT 00:00:00 00:00:08 EXTRACT RUNNING TESTPUMP 00:00:00 00:00:05
attention-is-all-you-need-pytorch_pytorch_transformer_attention_
10-01
标题中的"attention-is-all-you-need-pytorch_pytorch_transformer_attention_"暗示了我们要讨论的是一个基于PyTorch实现的Transformer模型，这是论文《Attention is All You Need》中提出的一种深度学习模型，主要...
sybase日志问题知识普及
03-08
SYBASE SQL Server 的每一个数据库，无论是系统...或者开放数据库选项trunc log on chkpt，数据库会每隔一段间隔自动清除log。管理好数据库log是用户操作数据库必须考虑的一面。 下面就几个方面谈谈log及其管理：
sql2005 日志清理 SQL2005压缩清除日志的方法
12-15
打开查询分析器，输入命令DUMP TRANSACTION 数据库名 WITH NO_LOG2. 再打开企业管理器–右键你要压缩的数据库–所有任务–收缩数据库–收缩文件–选择日志文件–在 收缩方式里选择收缩至XXM, 这里会给出一个允许收缩...
【ogg】Time Since Chkpt太大怎么办
viviliving的专栏
12-16 1869
参考截图： GGSCI (wxdb1) 11> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EDLZJB...
＞＞技术应用：OGG 通过 info 查询 Lag at Chkpt／Time Since Chkpt以及相关说明（一）
Lycos
06-18 1656
定义理解 关于Oracle GoldenGate （简称OGG）的 Lag at Chkpt和Time Since Chkpt的理解，前提需要理解OGG的每个进程都有它自己的checkpoint file。每当一个进程看到在事务的commit时，检查点文件中就将产生一个检查点。OGG的恢复进程总是以检查点作为起点。而OGG是通过监控的checkpoint和Lag at Chkpt和Time Since Chkpt这2个指标来衡量数据同步延迟时效的。 问题出现 最近新上一批OGG数据抽取和投递服务器，原采
OGG中Time Since Chkpt状态为UNKNOWN解决方法
kevin_LCC的专栏
12-05 2518
 数据库服务器异常关机，重启后启动OGG后，Time Since Chkpt状态为UNKNOWN 此时只需要重启进程即可： GGSCI>stop *              ------如果关闭不了  用  kill -9 进程   杀掉 GGSCI>stop mgr GGSCI>start mgr GGSCI>start * 如果还是不行，那么就检查下操作系统上的OGG进程是
oracle 状态unknown,ogg中Time Since Chkpt显示unknown解决方法
weixin_34749183的博客
04-05 735
1、异常现象[oracle@localhost ~]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.1.1.0.0 Build 078Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11Copyright (C) 1995, 2010, O...
linux内核异常分析ecp,内核异常分析方法
weixin_42525005的博客
04-30 910
=============================================================内核异常分析方法=============================================================-------------------------------------------------------------1 总体方法---...
MessagingTimeout: Timed out waiting for a reply to message ID
热门推荐
cxg的专栏
02-25 1万+
l3中出现大量消息超时错误，对网络的操作各种异常。 报错如下： 2016-02-25 05:54:59.886 15110 ERROR neutron.agent.l3.agent [req-db9207e6-9270-4f23-8c19-0d91d20cc6fb ] Failed synchronizing routers due to RPC error 2016-02-25 05:54
linux常用命令----后端部署项目必备
qq_38716929的博客
12-02 551
安装linux后，首先查看ip地址，使用以下命令ip addr安装完后的linux需要设置网卡(以centos7为例)，使用下列命令修改参数。
IE11: selenium.common.exceptions.TimeoutException: Message: Timed out waiting for page to load
yiluoseraph的技术博客
12-04 2353
https://www.selenium.dev/documentation/en/driver_idiosyncrasies/driver_specific_capabilities/ from selenium import webdriver options = webdriver.IeOptions() options.ignore_protected_mode_settings = True driver = webdriver.Ie(options=options) .
time since chkpt
最新发布
06-10
“chkpt”通常指的是checkpoint，是在机器学习训练过程中保存模型参数的一种方式。如果您想知道距离上一次保存checkpoint的时间，您需要查看模型训练的日志或代码中的相关参数设置。如果您无法查找到这些信息，您...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值