sql server 2016 replication to AWS EC2 VM sql server error

Discussion in 'Replication' started by steven, Aug 4, 2020.

  1. steven

    steven

    Joined:
    Aug 4, 2020
    Messages:
    1
    Likes Received:
    0
    Hello Replication experts there,

    I have a strange replication issue between my on premises SQL server 2016 and AWS EC2 VM sql server 2016 express. Almost hourly I got something like this:

    Date 2020-06-12 10:30:47 AM
    Log Job History (<Job>)

    Step ID 2
    Server MySQLServer
    Job Name <Job>
    Step Name Run agent.
    Duration 52.11:52:43
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Time to Apply Cmds (ms) : 5514 Cmds/Sec : 19.04
    Time Spent on Schema Changes (ms) : 0
    Time Cmd Queue Empty (ms) : 164456 Empty Q Waits > 10ms: 10
    Total Time Request Blk(ms): 3019580
    P2P Work Time (ms) : 0 P2P Cmds Skipped : 0

    Reader Thread Stats
    Calls to Retrieve Cmds : 582
    Time to Retrieve Cmds (ms): 94 Cmds/Sec : 1117.02
    Time Cmd Queue Full (ms) : 0 Full Q Waits > 10ms : 0

    Article Level Parameterized Command Stats
    Article Id: 1510
    Number of Inserts: 0, time (ms): 0
    Number of Updates: 9, time (ms): 0
    Number of Deletes: 0, time (ms): 0
    Number of Other Cmds (e.g. custom commands): 0, time (ms): 0
    Article Id: 1515
    Number of Inserts: 48, time (ms): 0
    Number of Updates: 0, time (ms): 0
    Number of Deletes: 48, time (ms): 0
    Number of Other Cmds (e.g. custom commands): 0, time (ms): 0
    *******************************************************************************

    2020-08-04 05:14:11.862 <stats state="1" work="5" idle="2855"><reader fetch="0" wait="0"/><writer write="5" wait="164"/><sincelaststats elapsedtime="300" work="0" cmds="0" cmdspersec="0.000000"><reader fetch="0" wait="0"/><writer write="0" wait="15"/></sincelaststats><message>Normal events that describe both the reader and writer thread performance.</message></stats>
    2020-08-04 05:15:10.612 No replicated transactions are available.
    2020-08-04 05:15:37.503 1 transaction(s) with 1 command(s) were delivered.
    2020-08-04 05:15:43.128 2 transaction(s) with 2 command(s) were delivered.
    2020-08-04 05:16:46.894 No replicated transactions are available.
    2020-08-04 05:17:50.769 No replicated transactions are available.
    2020-08-04 05:18:54.566 No replicated transactions are available.
    ************************ STATISTICS SINCE AGENT STARTED ***********************
    08-03-2020 22:19:15

    Total Run Time (ms) : 3331000 Total Work Time : 6607
    Total Num Trans : 63 Num Trans/Sec : 9.54
    Total Num Cmds : 108 Num Cmds/Sec : 16.35
    Total Skipped Cmds : 0
    Total Idle Time : 3140124

    Writer Thread Stats
    Total Number of Retries : 0
    Time Spent on Exec : 937
    Time Spent on Commits (ms): 45207 Commits/Sec : 86.88
    Time to Apply Cmds (ms) : 6607 Cmds/Sec : 16.35
    Time Spent on Schema Changes (ms) : 0
    Time Cmd Queue Empty (ms) : 182003 Empty Q Waits > 10ms: 12
    Total Time Request Blk(ms): 3322127
    P2P Work Time (ms) : 0 P2P Cmds Skipped : 0

    Reader Thread Stats
    Calls to Retrieve Cmds : 641
    Time to Retrieve Cmds (ms): 94 Cmds/Sec : 1148.94
    Time Cmd Queue Full (ms) : 0 Full Q Waits > 10ms : 0

    Article Level Parameterized Command Stats
    Article Id: 1510
    Number of Inserts: 0, time (ms): 0
    Number of Updates: 12, time (ms): 0
    Number of Deletes: 0, time (ms): 0
    Number of Other Cmds (e.g. custom commands): 0, time (ms): 0
    Article Id: 1515
    Number of Inserts: 48, time (ms): 0
    Number of Updates: 0, time (ms): 0
    Number of Deletes: 48, time (ms): 0
    Number of Other Cmds (e.g. custom commands): 0, time (ms): 0
    *******************************************************************************

    2020-08-04 05:19:15.503 <stats state="1" work="6" idle="3140"><reader fetch="0" wait="0"/><writer write="6" wait="182"/><sincelaststats elapsedtime="303" work="1" cmds="3" cmdspersec="2.000000"><reader fetch="0" wait="0"/><writer write="1" wait="17"/></sincelaststats><message>Normal events that describe both the reader and writer thread performance.</message></stats>
    2020-08-04 05:19:58.316 No replicated transactions are available.
    2020-08-04 05:21:02.113 No replicated transactions are available.
    2020-08-04 05:21:34.550 1 transaction(s) with 1 command(s) were delivered.
    2020-08-04 05:21:45.504 18 transaction(s) with 33 command(s) were delivered.
    2020-08-04 05:22:48.707 Agent message code 20046. The agent failed with a 'Retry' status. Try to run the agent at a later time.


    The strange error message at the end of log:

    2020-08-04 05:22:48.707 Agent message code 20046. The agent failed with a 'Retry' status. Try to run the agent at a later time.

    Could anybody give me a clue of what this mean? the transactions were successfully replicated to AWS EC2 VM sql serve

    Thank you for help in advance!

    Steven
     
    steven, Aug 4, 2020
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.