【ogg实战】STOP rep出现request pending end-of-transaction
回到未来望过去 于 2019-10-28 08:29:53 发布 1991 收藏
版权
GGSCI (LZSB-3850-ZB) 14> stop rlzsi
Sending STOP request to REPLICAT RLZSI ...
STOP request pending end-of-transaction (47621 records so far)..
GGSCI (LZSB-3850-ZB) 15> stop rlzsi
Sending STOP request to REPLICAT RLZSI ...
STOP request pending end-of-transaction (47633 records so far)..
GGSCI (LZSB-3850-ZB) 16> stop rlzsi
Sending STOP request to REPLICAT RLZSI ...
STOP request pending end-of-transaction (47642 records so far)..
GGSCI (LZSB-3850-ZB) 368> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED LDFZ1 00:00:00 81:28:04
REPLICAT STOPPED RDLZJB 00:00:00 07:18:29
REPLICAT STOPPED RLZBK 00:00:00 07:18:27
REPLICAT STOPPED RLZKZ 00:00:00 07:18:25
REPLICAT STOPPED RLZRE 00:00:00 07:18:24
REPLICAT RUNNING RLZSI 53:32:55 05:41:48
查看info已经hang住5个小时了，网上有哥们说杀了，先别杀，看看这是个什么东东
GGSCI (LZSB-3850-ZB) 18> send rlzsi,status
Sending STATUS request to REPLICAT RLZSI ...
Current status: Processing data
Sequence #: 1436
RBA: 189718656
48272 records in current transaction
PENDING
STOP request pending end-of-transaction (48272 records so far)
查长事务
with ltr as (
select to_char(sysdate,'YYYYMMDDHH24MISS') TM,
s.sid,
s.sql_id,
s.sql_child_number,
s.prev_sql_id,
xid,
to_char(t.start_date,'YYYYMMDDHH24MISS') start_time,
e.TYPE,e.block,
e.ctime,
decode(e.CTIME, 0, (sysdate - t.start_date) * 3600*24, e.ctime) el_second
-- q.sql_text
from v$transaction t, v$session s,v$transaction_enqueue e
where t.start_date <= sysdate - interval '100' second /*查询开始多少秒的事务*/
and t.addr = s.taddr
--and s.sql_child_number = q.CHILD_NUMBER(+)
--and s.sql_id = q.sql_id(+) and s.prev_sql_id = q.sql_id(+)
and t.addr = e.addr(+) )
select ltr.* , (select q1.sql_text from v$sql q1 where ltr.prev_sql_id = q1.sql_id(+)
and rownum = 1) prev_sql_text ,
(select q1.sql_text from v$sql q1 where ltr.sql_id = q1.sql_id(+)
and ltr.sql_child_number = q1.CHILD_NUMBER(+)) sql_text
from ltr ltr;
1 20191026092931 449 707rdgbvyk6x1 0 707rdgbvyk6x1 16001B00669A0900 20191026034542 TX 0 20629 20629 UPDATE "ZB_LZJBSI"."H008" SET "INPRICE_01" = :a45,"TRANSACTIONCODES" = :a46,"CREATEDATE" = :a47,"INPRICE_02" = :a48,"INPRICE_03" = :a49,"INPRICE_04" = :a50,"INPRICE_05" = :a51,"INPRICE_06" = :a52,"INPRICE_07" = :a53,"INPRICE_08" = :a54,"INPRICE_09" = :a55,"INPRICE_10" = :a56,"INPRICE_11" = :a57,"INPRICE_12" = :a58,"INPRICE_13" = :a59,"INPRICE_14" = :a60,"INPRICE_15" = :a61,"INPRICE_16" = :a62,"INPRICE_17" = :a63,"INPRICE_18" = :a64,"INPRICE_19" = :a65,"INPRICE_20" = :a66,"INPRICE_21" = :a67,"INPRICE_22" = :a68,"INPRICE_23" = :a69,"INPRICE_24" = :a70,"INPRICE_25" = :a71,"INPRICE_26" = :a72,"INPRICE_27" = :a73,"INPRICE_28" = :a74,"INPRICE_29" = :a75,"INPRICE_30" = :a76,"INPRICE_31" = :a77,"INPRICE_32" = :a78,"INPRICE_33" = :a79,"INPRICE_34" = :a80,"INPRICE_35" = :a81,"INPRICE_36" = :a82,"INPRICE_37" = :a83,"SENDFLAG" = :a84,"SENDMESSAGE" = :a85,"SENDTIME" = :a86,"AKB020" = :a87,"JLBH" = :a88,"BKC380" = :a89 WHERE "INPRICE_01" = :b0 AND "TRANSACTIONCODES" = :b1 AND "CREATEDATE" = :b2 AND UPDATE "ZB_LZJBSI"."H008" SET "INPRICE_01" = :a45,"TRANSACTIONCODES" = :a46,"CREATEDATE" = :a47,"INPRICE_02" = :a48,"INPRICE_03" = :a49,"INPRICE_04" = :a50,"INPRICE_05" = :a51,"INPRICE_06" = :a52,"INPRICE_07" = :a53,"INPRICE_08" = :a54,"INPRICE_09" = :a55,"INPRICE_10" = :a56,"INPRICE_11" = :a57,"INPRICE_12" = :a58,"INPRICE_13" = :a59,"INPRICE_14" = :a60,"INPRICE_15" = :a61,"INPRICE_16" = :a62,"INPRICE_17" = :a63,"INPRICE_18" = :a64,"INPRICE_19" = :a65,"INPRICE_20" = :a66,"INPRICE_21" = :a67,"INPRICE_22" = :a68,"INPRICE_23" = :a69,"INPRICE_24" = :a70,"INPRICE_25" = :a71,"INPRICE_26" = :a72,"INPRICE_27" = :a73,"INPRICE_28" = :a74,"INPRICE_29" = :a75,"INPRICE_30" = :a76,"INPRICE_31" = :a77,"INPRICE_32" = :a78,"INPRICE_33" = :a79,"INPRICE_34" = :a80,"INPRICE_35" = :a81,"INPRICE_36" = :a82,"INPRICE_37" = :a83,"SENDFLAG" = :a84,"SENDMESSAGE" = :a85,"SENDTIME" = :a86,"AKB020" = :a87,"JLBH" = :a88,"BKC380" = :a89 WHERE "INPRICE_01" = :b0 AND "TRANSACTIONCODES" = :b1 AND "CREATEDATE" = :b2 AND
发现sql内容
UPDATE "ZB_LZJBSI"."H008" SET "INPRICE_01" = :a45,"TRANSACTIONCODES" = :a46,"CREATEDATE" = :a47,"INPRICE_02" = :a48,"INPRICE_03" = :a49,"INPRICE_04" = :a50,"INPRICE_05" = :a51,"INPRICE_06" = :a52,"INPRICE_07" = :a53,"INPRICE_08" = :a54,"INPRICE_09" = :a55,"INPRICE_10" = :a56,"INPRICE_11" = :a57,"INPRICE_12" = :a58,"INPRICE_13" = :a59,"INPRICE_14" = :a60,"INPRICE_15" = :a61,"INPRICE_16" = :a62,"INPRICE_17" = :a63,"INPRICE_18" = :a64,"INPRICE_19" = :a65,"INPRICE_20" = :a66,"INPRICE_21" = :a67,"INPRICE_22" = :a68,"INPRICE_23" = :a69,"INPRICE_24" = :a70,"INPRICE_25" = :a71,"INPRICE_26" = :a72,"INPRICE_27" = :a73,"INPRICE_28" = :a74,"INPRICE_29" = :a75,"INPRICE_30" = :a76,"INPRICE_31" = :a77,"INPRICE_32" = :a78,"INPRICE_33" = :a79,"INPRICE_34" = :a80,"INPRICE_35" = :a81,"INPRICE_36" = :a82,"INPRICE_37" = :a83,"SENDFLAG" = :a84,"SENDMESSAGE" = :a85,"SENDTIME" = :a86,"AKB020" = :a87,"JLBH" = :a88,"BKC380" = :a89 WHERE "INPRICE_01" = :b0 AND "TRANSACTIONCODES" = :b1 AND "CREATEDATE" = :b2 AND
在更是一个无主键的表，再鄙视一下开发
查死锁也没有，看来是sql问题
放心干掉吧，参数文件增加跳过这个垃圾表
GGSCI (LZSB-3850-ZB) 369> kill rlzsi
Sending KILL request to MANAGER ...
Killed process (22297) for REPLICAT RLZSI
GGSCI (LZSB-3850-ZB) 370> infl rlzsi
ERROR: Invalid command.
GGSCI (LZSB-3850-ZB) 371> info rlzsi
REPLICAT RLZSI Last Started 2019-10-26 03:42 Status ABENDED
Checkpoint Lag 53:32:55 (updated 05:47:20 ago)
Log Read Checkpoint File ./dirdat/si001436
2019-10-23 22:12:47.523391 RBA 96077061
GGSCI (LZSB-3850-ZB) 372> start rlzsi
Sending START request to MANAGER ...
REPLICAT RLZSI starting
GGSCI (LZSB-3850-ZB) 373> info rlzsi
REPLICAT RLZSI Last Started 2019-10-26 09:33 Status RUNNING
Checkpoint Lag 53:32:55 (updated 05:48:01 ago)
Log Read Checkpoint File ./dirdat/si001436
2019-10-23 22:12:47.523391 RBA 96077061
start rlzsi
还是这个命令看的好send rlzsi,status，简单明了，又开始动了，期待着ogg再次hang住或者abended，学习中期待大量的错误促进我的成长，暴风雨来的更猛烈些吧
GGSCI (LZSB-3850-ZB) 380> send rlzsi,status
Sending STATUS request to REPLICAT RLZSI ...
Current status: Processing data
Sequence #: 1439
RBA: 81838123
155 records in current transaction
GGSCI (LZSB-3850-ZB) 381> send rlzsi,status
Sending STATUS request to REPLICAT RLZSI ...
Current status: Processing data
Sequence #: 1439
RBA: 82424713
621 records in current transaction
GGSCI (LZSB-3850-ZB) 382> send rlzsi,status
Sending STATUS request to REPLICAT RLZSI ...
Current status: Processing data
Sequence #: 1439
RBA: 83052533
182 records in current transaction
————————————————
版权声明：本文为CSDN博主「回到未来望过去」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/viviliving/article/details/102753187