Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what operations will cause the following errors in active standby pair??

581561Aug 30 2008 — edited Sep 3 2008
hi, chirs:
Our system found the standby host filesystem full because of the log files. when we see the reason, the message information has override, so we can not analyse the them. Can we ask whether you had met this situation. and sometimes we may alter the replication table when the replication agent is running, does it has influence?? Can I ask the right step about alter a replication table in business system?? thank you very much...
the master log like these:
2008-08-30 12:29:35.61 Info: REP: 18471: OCSDATA:repagent.c(1166): TT16025: Thread 'TRANSMITTER' (context 60000000003e3ff0) starting
2008-08-30 12:29:35.65 Info: REP: 18471: OCSDATA:transmitter.c(1018): TT16114: Attempting to connect to OCSDATA on CX_PDSCP1 (192.168.11.1); port: 52407
2008-08-30 12:29:35.65 Info: REP: 18471: OCSDATA:transmitter.c(1031): TT16115: Connected to CX_PDSCP1 (192.168.11.1); socket: 10; port: 52407
2008-08-30 12:29:35.66 Info: REP: 18471: OCSDATA:transmitter.c(5955): TT16129: Starting log read at LSN 5329/45016672(caller line: 7174)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.CUST_PRICE_PLAN (9 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.DEDUCT_LIST (12 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.SCP_QUERY_TIMEO_LIST (10 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.BALANCE_ACCT_ITEM (14 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.LOCKED_BALANCE_ITEM (10 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.CUMULATE_ACCT_ITEM (8 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(4936): TT16136: Sending definition for table OCSUSER.SESSIONSTATE (13 columns)
2008-08-30 12:29:35.67 Info: REP: 18471: OCSDATA:transmitter.c(5072): TT16251: Sending definition for sequence OCSUSER.SEQ_BILL_RECORD_ID
2008-08-30 12:29:35.68 Warn: REP: 18471: OCSDATA:transmitter.c(4476): TT16060: Failed to read data from the network. select() timed out
2008-08-30 12:29:35.68 Err : REP: 18471: OCSDATA:transmitter.c(2500): TT16121: Failed to flush transaction queue. Restarting log read loop

the standby log like these:
2008-08-30 12:36:02.41 Info: REP: 5763: OCSDATA:repagent.c(1166): TT16025: Thread 'RECEIVER' (context 6000000000503ff0) starting
2008-08-30 12:36:02.41 Err : REP: 5763: OCSDATA:meta.c(4203): TT16064: Failed to execute prepared command in metaSetPeerProtocol1()
2008-08-30 12:36:02.41 Err : REP: 5763: OCSDATA:meta.c(4203): TT778: TT0778: Log write failed because filesystem is full -- file "logbuf.c", lineno 2997, procedure "sbLogBufInsertSmall"
2008-08-30 12:36:02.42 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.CUST_PRICE_PLAN
2008-08-30 12:36:02.42 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.CUST_PRICE_PLAN ptn 0: srcoff 0, destoff 0, length 72
2008-08-30 12:36:02.42 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.CUST_PRICE_PLAN ptn 1: srcoff 72, destoff 80, length 9
2008-08-30 12:36:02.42 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.CUST_PRICE_PLAN
2008-08-30 12:36:02.42 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.DEDUCT_LIST
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.DEDUCT_LIST ptn 0: srcoff 0, destoff 0, length 392
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.DEDUCT_LIST
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.SCP_QUERY_TIMEO_LIST
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.SCP_QUERY_TIMEO_LIST ptn 0: srcoff 0, destoff 0, length 728
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.SCP_QUERY_TIMEO_LIST
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.BALANCE_ACCT_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.BALANCE_ACCT_ITEM ptn 0: srcoff 0, destoff 0, length 176
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.BALANCE_ACCT_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.LOCKED_BALANCE_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.LOCKED_BALANCE_ITEM ptn 0: srcoff 0, destoff 0, length 80
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.LOCKED_BALANCE_ITEM ptn 1: srcoff 80, destoff 80, length 9
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.LOCKED_BALANCE_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.CUMULATE_ACCT_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.CUMULATE_ACCT_ITEM ptn 0: srcoff 0, destoff 0, length 56
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.CUMULATE_ACCT_ITEM ptn 1: srcoff 56, destoff 56, length 24
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.CUMULATE_ACCT_ITEM ptn 2: srcoff 80, destoff 80, length 9
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.CUMULATE_ACCT_ITEM
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(5928): TT16193: Adding definition for table: OCSUSER.SESSIONSTATE
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.SESSIONSTATE ptn 0: srcoff 0, destoff 0, length 192
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:meta.c(5584):OCSUSER.SESSIONSTATE ptn 1: srcoff 192, destoff 192, length 40
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6337): TT16203: Passed extended comparison for table OCSUSER.SESSIONSTATE
2008-08-30 12:36:02.43 Info: REP: 5763: OCSDATA:receiver.c(6477): TT16245: Adding definition for sequence: OCSUSER.SEQ_BILL_RECORD_ID
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(9357): TT16084: Table: OCSUSER.SESSIONSTATE. Failed to insert row for 'insert'
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(9357): TT778: TT0778: Log write failed because filesystem is full -- file "logbuf.c", lineno 2997, procedure "sbLogBufInsertSmall"
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(10555): TT16049: Failed to update CTN for peer 'OCSDATA'
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(10555): TT778: TT0778: Log write failed because filesystem is full -- file "logbuf.c", lineno 2997, procedure "sbLogBufInsertSmall"
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(5002): TT16187: Transaction 1219325043/103098056; Error: transient 0, permanent 1
2008-08-30 12:36:02.43 Err : REP: 5763: OCSDATA:receiver.c(5012): TT16188: rxCommitTx() failed to commit

the repschemes is :
Replication Scheme Active Standby:

Master Store: OCSDATA on CX_PDSCP2
Master Store: OCSDATA on CX_PDSCP1
Master Return Service: Return Twosafe


Excluded Tables:
None

Excluded Cache Groups:
None

Excluded sequences:
None

Store: OCSDATA on CX_PDSCP1
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
Return Service Wait Time: 10 seconds
Return Service on Replication Stop: Disabled
Twosafe Local Commit Action on Timeout: Commit
Return Service Failure Policy: Disable All Subscribers
Return Service Failure Timeout Count: 1
Return Service Commit Policy on Failure: Durable Commit Off

Store: OCSDATA on CX_PDSCP2
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
Return Service Wait Time: 10 seconds
Return Service on Replication Stop: Disabled
Twosafe Local Commit Action on Timeout: Commit
Return Service Failure Policy: Disable All Subscribers
Return Service Failure Timeout Count: 1
Return Service Commit Policy on Failure: Durable Commit Off

1 replication scheme found.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2008
Added on Aug 30 2008
#database-key-features, #timesten-in-memory-database
3 comments
1,294 views