myschema、mytableはそれぞれスキーマ名、テーブル名に置き換えてください。
-
Finished applying of 8774 'UPDATE (3)' cached events for table 'myschema'.'mytable' (30). (bulk_apply.c:2319)
- 前提
- DMSのレプリケーションタスクはソースDBをフルスキャンしてターゲットDBにロードするfull loadと、ソースDBのbinlogなどをよりリアルタイムに読み込んで、逐次ターゲットDBに反映していくCDC(Change Data Capture)の2段構え
- full load中にソースDBで発生した更新がバッファリングされているはず
- このメッセージの意味
- full loadが完了して、さらにその後工程の「full load中にソースDBで発生した更新の反映」も終わった
-
Stop task after all cached events were applied was triggered (replicationtask.c:1819)
- 前提
- full-load-and-cdcモードでレプリケーションタスクを起動すると、full load完了後に一旦タスクは停止される=StoppedというStatusになる。
- このメッセージの意味
- full loadとキャッシュされていた更新の反映が終わったので、あとはCDCを開始するだけ。というわけで、一旦タスクを停止し、ユーザがタスクを再開(=CDCの開始を希望)するまで待つ。
2016-11-12T03:49:26 [TASK_MANAGER ]D: Sorter last timestamp Fri, 11 Nov 2016 06:53:20 GMT (replicationtask.c:2384)
2016-11-12T03:49:32 [TASK_MANAGER ]D: Sorter last timestamp Fri, 11 Nov 2016 06:53:20 GMT (replicationtask.c:2384)
2016-11-12T03:49:37 [TARGET_APPLY ]I: Finished applying of 8774 'UPDATE (3)' cached events for table 'myschema'.'mytable' (30). (bulk_apply.c:2319)
2016-11-12T03:49:38 [TARGET_APPLY ]I: Switch back to preserve transactions mode (bulk_apply.c:1858)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Sorter last timestamp Fri, 11 Nov 2016 06:56:36 GMT (replicationtask.c:2384)
2016-11-12T03:49:38 [TASK_MANAGER ]I: Stop task after all cached events were applied was triggered (replicationtask.c:1819)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Sending control record to component st_0_3UIQICZ6SQHF3UD7ZVB6H6MPHE. Command is 'Stop', First table id is '0' (subtask.c:1867)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Stop command for component st_0_3UIQICZ6SQHF3UD7ZVB6H6MPHE (subtask.c:1872)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Sending control record to component st_0_VMMFJVRS4II4CYM5I3UJ7WVPOA. Command is 'Stop', First table id is '0' (subtask.c:1867)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Stop command for component st_0_VMMFJVRS4II4CYM5I3UJ7WVPOA (subtask.c:1872)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Sending control record to component st_0_transaction_sorter. Command is 'Stop', First table id is '0' (subtask.c:1867)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Stop command for component st_0_transaction_sorter (subtask.c:1872)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Wait for termination of the thread of 'st_0_3UIQICZ6SQHF3UD7ZVB6H6MPHE' component (subtask.c:1584)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread stopped for component st_0_transaction_sorter (subtask.c:1388)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread stopped for component st_0_3UIQICZ6SQHF3UD7ZVB6H6MPHE (subtask.c:1388)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread of 'st_0_3UIQICZ6SQHF3UD7ZVB6H6MPHE' component terminated (subtask.c:1590)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Wait for termination of the thread of 'st_0_VMMFJVRS4II4CYM5I3UJ7WVPOA' component (subtask.c:1584)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread stopped for component st_0_VMMFJVRS4II4CYM5I3UJ7WVPOA (subtask.c:1388)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread of 'st_0_VMMFJVRS4II4CYM5I3UJ7WVPOA' component terminated (subtask.c:1590)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Wait for termination of the thread of 'st_0_transaction_sorter' component (subtask.c:1584)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Thread of 'st_0_transaction_sorter' component terminated (subtask.c:1590)
2016-11-12T03:49:38 [TASK_MANAGER ]D: Join Notification Thread (replicationtask.c:3003)
2016-11-12T03:49:39 [TASK_MANAGER ]D: Notification Thread terminated (replicationtask.c:3005)
2016-11-12T03:49:39 [TASK_MANAGER ]D: Going to free subtask #0 (subtask.c:563)
2016-11-12T03:49:39 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:925)
2016-11-12T03:49:39 [TASK_MANAGER ]I: Task management thread terminated (replicationtask.c:2679)
2016-11-12T03:49:41 [TASK_MANAGER ]D: Task management thread terminated (replicationtask_cmd.c:32)