- 论坛徽章:
- 0
|
本帖最后由 baiying1213 于 2011-09-01 12:57 编辑
很奇怪,同步的几百张表中唯一只有这个usertoper表经常出现这种问题。
以下是目标端replicat的discard文件信息:
[oracle@dbslave dirrpt]$ more RINImj.dsc
Current time: 2011-08-31 20:00:55
Discarded record from action ABEND on error 1403
Aborting transaction on /u01/goldengate/dirdat/mj beginning at seqno 0 rba 487982
error at seqno 0 rba 487982
Problem replicating FINANCE10.USERTOPER to FINANCE10.USERTOPER
Record not found
Mapping problem with delete record (target format)...
*
ID = ff80808131d253e20132135f4cf91d4d
*
[oracle@dbslave dirrpt]$
**********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file /u01/goldengate/dirdat/mj000000 at 2011-08-29 10:42:23
2011-08-29 13:22:27 INFO OGG-01407 Setting current schema for DDL operation to [FINANCE10].
2011-08-29 13:22:32 INFO OGG-01407 Setting current schema for DDL operation to [FINANCE10].
2011-08-29 13:22:32 INFO OGG-01408 Restoring current schema for DDL operation to [OGG].
Wildcard MAP resolved (entry FINANCE10.*):
MAP FINANCE10.TBS_TEST, TARGET finance10.TBS_TEST;
Using following columns in default map by name:
ID
Using the following key columns for target table FINANCE10.TBS_TEST: ID.
2011-08-29 13:38:37 INFO OGG-01407 Setting current schema for DDL operation to [FINANCE10].
2011-08-29 13:38:37 INFO OGG-01408 Restoring current schema for DDL operation to [OGG].
Wildcard MAP resolved (entry FINANCE10.*):
MAP FINANCE10.USERTOPER, TARGET finance10.USERTOPER;
Using following columns in default map by name:
ID, USER_ID, PERMISS_ID, BOOK_ACCOUNT, CREATE_DATE, UPDATE_DATE
Using the following key columns for target table FINANCE10.USERTOPER: ID.
2011-08-31 20:00:55 WARNING OGG-01004 Aborted grouped transaction on 'FINANCE10.USERTOPER', Database error 1403 ().
2011-08-31 20:00:55 WARNING OGG-01003 Repositioning to rba 487982 in seqno 0.
2011-08-31 20:00:55 WARNING OGG-01154 SQL error 1403 mapping FINANCE10.USERTOPER to FINANCE10.USERTOPER.
2011-08-31 20:00:55 WARNING OGG-01003 Repositioning to rba 487982 in seqno 0.
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/sganti/view_storage/sganti_core_lin64/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [take_rep_err_action]
SourceLine : [16064]
ThreadBacktrace : [8] elements
: [/u01/goldengate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5ec2e6]]
: [/u01/goldengate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e2db2]]
: [/u01/goldengate/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessageFact
ory::MessageDisposition)+0x9b) [0x5c17fb]]
: [/u01/goldengate/replicat [0x8155fa]]
: [/u01/goldengate/replicat [0x8ee350]]
: [/u01/goldengate/replicat(main+0x6cb) [0x5068ab]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x30e661d994]]
: [/u01/goldengate/replicat(__gxx_personality_v0+0x1da) [0x4e31ba]]
2011-08-31 20:00:55 ERROR OGG-01296 Error mapping from FINANCE10.USERTOPER to FINANCE10.USERTOPER.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : /u01/goldengate/dirdat/mj000000
Hdr-Ind : E (x45) Partition : . (x00)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 1181 (x049d) IO Time : 2011-08-29 13:38:32.810254
IOType : 160 (xa0) OrigNode : 0 (x00)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 0 AuditPos : 0
Continued : N (x00) RecCount : 1 (x01)
2011-08-29 13:38:32.810254 DDL OP Len 1181 RBA 486654
Name:
___________________________________________________________________
Reading /u01/goldengate/dirdat/mj000000, current RBA 487982, 1 records
Report at 2011-08-31 20:00:55 (activity since 2011-08-29 13:23:50)
From Table FINANCE10.TBS_TEST to FINANCE10.TBS_TEST:
# inserts: 1
# updates: 0
# deletes: 0
# discards: 0
From Table FINANCE10.USERTOPER to FINANCE10.USERTOPER:
# inserts: 0
# updates: 0
# deletes: 0
# discards: 1
DDL replication statistics:
Operations: 2
Mapped operations: 2
Unmapped operations: 0
Other operations: 0
Excluded operations: 0
Errors: 2
Retried errors: 1
Discarded errors: 1
Ignored errors: 0
Last log location read:
FILE: /u01/goldengate/dirdat/mj000000
SEQNO: 0
RBA: 487982
TIMESTAMP: 2011-08-31 15:39:02.408306
EOF: NO
READERR: 0
2011-08-31 20:00:55 ERROR OGG-01668 PROCESS ABENDING. |
|