gh-ost: After copying is 100%: FATAL Timeout while waiting for events up to lock

Tried running a migration on master in RDS. Seemed to work fine until the cutover phase (I assume), when it looped over and over with “ERROR Timeout while waiting for events up to lock” until eventually it became FATAL.

Command:

./gh-ost --user="historical" --password="XXXXX" --host=XXXXX.rds.amazonaws.com --assume-rbr --hooks-path=hooks --database="historical" --table="raw_post_data" --verbose --alter="modify content longtext not null" --initially-drop-ghost-table --initially-drop-old-table --max-load=Threads_running=30 --chunk-size=500 --cut-over=default --allow-on-master --exact-rowcount --execute

First lines of output:

2017-01-26 12:25:13 INFO starting gh-ost 1.0.34
2017-01-26 12:25:13 INFO Migrating `historical`.`raw_post_data`
2017-01-26 12:25:14 INFO connection validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:14 INFO User has REPLICATION CLIENT, REPLICATION SLAVE privileges, and has ALL privileges on `historical`.*
2017-01-26 12:25:14 INFO binary logs validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:14 INFO Table found. Engine=InnoDB
2017-01-26 12:25:14 INFO Estimated number of rows via EXPLAIN: 344974
2017-01-26 12:25:14 INFO Recursively searching for replication master
2017-01-26 12:25:15 INFO Master found to be XXXXX
2017-01-26 12:25:15 INFO log_slave_updates validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:15 INFO connection validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:15 INFO Registering replica at XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:15 INFO Connecting binlog streamer at mysql-bin-changelog.134366:120
2017-01-26 12:25:15 INFO connection validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:15 INFO rotate to next log name: mysql-bin-changelog.134366
2017-01-26 12:25:15 INFO connection validated on XXXXX.rds.amazonaws.com:3306
2017-01-26 12:25:15 INFO will use time_zone='UTC' on applier
2017-01-26 12:25:15 INFO Examining table structure on applier
2017-01-26 12:25:15 INFO Droppping table `historical`.`_raw_post_data_gho`
2017-01-26 12:25:15 INFO Table dropped
2017-01-26 12:25:15 INFO Droppping table `historical`.`_raw_post_data_del`
2017-01-26 12:25:15 INFO Table dropped
2017-01-26 12:25:15 INFO Droppping table `historical`.`_raw_post_data_ghc`
2017-01-26 12:25:15 INFO Table dropped
2017-01-26 12:25:15 INFO Creating changelog table `historical`.`_raw_post_data_ghc`
2017-01-26 12:25:15 INFO Changelog table created
2017-01-26 12:25:15 INFO Creating ghost table `historical`.`_raw_post_data_gho`
2017-01-26 12:25:16 INFO Ghost table created
2017-01-26 12:25:16 INFO Altering ghost table `historical`.`_raw_post_data_gho`
2017-01-26 12:25:16 INFO Ghost table altered
2017-01-26 12:25:16 INFO Intercepted changelog state GhostTableMigrated
2017-01-26 12:25:16 INFO Waiting for ghost table to be migrated. Current lag is 0s
2017-01-26 12:25:16 INFO Handled changelog state GhostTableMigrated
2017-01-26 12:25:16 INFO Chosen shared unique key is PRIMARY
2017-01-26 12:25:16 INFO Shared columns are id,content,created_at,updated_at,headers
2017-01-26 12:25:16 INFO Listening on unix socket file: /tmp/gh-ost.historical.raw_post_data.sock
2017-01-26 12:25:16 INFO As instructed, counting rows in the background; meanwhile I will use an estimated count, and will update it later on
2017-01-26 12:25:16 INFO As instructed, I'm issuing a SELECT COUNT(*) on the table. This may take a while
2017-01-26 12:25:16 INFO Migration min values: [1]
2017-01-26 12:25:16 INFO Migration max values: [351857]
2017-01-26 12:25:16 INFO Waiting for first throttle metrics to be collected
*#* Migrating `historical`.`raw_post_data`; Ghost table is `historical`.`_raw_post_data_gho`
*#* Migrating XXXXX; inspecting XXXXX; executing on XXXXX
*#* Migration started at Thu Jan 26 12:25:13 -0500 2017
*#* chunk-size: 500; max-lag-millis: 1500ms; max-load: Threads_running=30; critical-load: ; nice-ratio: 0.000000
*#* throttle-additional-flag-file: /tmp/gh-ost.throttle
*#* Serving on unix socket: /tmp/gh-ost.historical.raw_post_data.sock
Copy: 0/344974 0.0%; Applied: 0; Backlog: 0/100; Time: 3s(total), 0s(copy); streamer: mysql-bin-changelog.134366:3205; State: migrating; ETA: N/A
Copy: 0/344974 0.0%; Applied: 0; Backlog: 0/100; Time: 4s(total), 1s(copy); streamer: mysql-bin-changelog.134366:4648; State: migrating; ETA: N/A

After copying hits 100%:

Copy: 344500/344974 99.9%; Applied: 0; Backlog: 0/100; Time: 2h22m34s(total), 2h22m31s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: 11s
Copy: 344500/344974 99.9%; Applied: 0; Backlog: 0/100; Time: 2h22m33s(total), 2h22m30s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: 11s
Copy: 345500/344974 100.2%; Applied: 0; Backlog: 0/100; Time: 2h23m0s(total), 2h22m57s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
Copy: 346500/344974 100.4%; Applied: 0; Backlog: 0/100; Time: 2h23m30s(total), 2h23m27s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
Copy: 348000/344974 100.9%; Applied: 0; Backlog: 0/100; Time: 2h24m0s(total), 2h23m57s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
Copy: 349000/344974 101.2%; Applied: 0; Backlog: 0/100; Time: 2h24m30s(total), 2h24m27s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
Copy: 350000/344974 101.5%; Applied: 0; Backlog: 0/100; Time: 2h25m0s(total), 2h24m57s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
Copy: 351000/344974 101.7%; Applied: 0; Backlog: 0/100; Time: 2h25m30s(total), 2h25m27s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
2017-01-26 14:50:54 INFO Row copy complete
Copy: 351857/351857 100.0%; Applied: 0; Backlog: 0/100; Time: 2h25m40s(total), 2h25m37s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
2017-01-26 14:50:54 INFO Grabbing voluntary lock: gh-ost.5175.lock
2017-01-26 14:50:54 INFO Setting LOCK timeout as 6 seconds
2017-01-26 14:50:55 INFO Looking for magic cut-over table
2017-01-26 14:50:55 INFO Creating magic cut-over table `historical`.`_raw_post_data_del`
2017-01-26 14:50:57 INFO Magic cut-over table created
2017-01-26 14:50:57 INFO Locking `historical`.`raw_post_data`, `historical`.`_raw_post_data_del`
2017-01-26 14:50:57 INFO Tables locked
2017-01-26 14:50:57 INFO Session locking original & magic tables is 5175
2017-01-26 14:50:57 INFO Writing changelog state: AllEventsUpToLockProcessed:1485460257538913634
2017-01-26 14:50:57 INFO Waiting for events up to lock
Copy: 351857/351857 100.0%; Applied: 0; Backlog: 0/100; Time: 2h25m45s(total), 2h25m37s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
2017-01-26 14:51:00 ERROR Timeout while waiting for events up to lock
2017-01-26 14:51:00 ERROR 2017-01-26 14:51:00 ERROR Timeout while waiting for events up to lock
2017-01-26 14:51:00 INFO Looking for magic cut-over table
2017-01-26 14:51:00 INFO Will now proceed to drop magic table and unlock tables

Last lines of output:

2017-01-26 14:55:34 INFO Creating magic cut-over table historical._raw_post_data_del
2017-01-26 14:55:34 INFO Magic cut-over table created
2017-01-26 14:55:34 INFO Locking historical.raw_post_data, historical._raw_post_data_del
Copy: 351857/351857 100.0%; Applied: 0; Backlog: 0/100; Time: 2h30m20s(total), 2h25m37s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
2017-01-26 14:55:34 INFO Tables locked
2017-01-26 14:55:34 INFO Session locking original & magic tables is 5568
2017-01-26 14:55:34 INFO Writing changelog state: AllEventsUpToLockProcessed:1485460534390340333
2017-01-26 14:55:34 INFO Waiting for events up to lock
2017-01-26 14:55:37 ERROR Timeout while waiting for events up to lock
2017-01-26 14:55:37 ERROR 2017-01-26 14:55:37 ERROR Timeout while waiting for events up to lock
2017-01-26 14:55:37 INFO Looking for magic cut-over table
2017-01-26 14:55:37 INFO Will now proceed to drop magic table and unlock tables
2017-01-26 14:55:37 INFO Dropping magic cut-over table
2017-01-26 14:55:37 INFO Dropping magic cut-over table
2017-01-26 14:55:37 INFO Droppping table historical._raw_post_data_del
2017-01-26 14:55:37 INFO Releasing lock from historical.raw_post_data, historical._raw_post_data_del
2017-01-26 14:55:37 INFO Table dropped
2017-01-26 14:55:37 INFO Tables unlocked
2017-01-26 14:55:38 INFO Grabbing voluntary lock: gh-ost.5568.lock
2017-01-26 14:55:38 INFO Setting LOCK timeout as 6 seconds
2017-01-26 14:55:38 INFO Looking for magic cut-over table
2017-01-26 14:55:38 INFO Creating magic cut-over table historical._raw_post_data_del
2017-01-26 14:55:38 INFO Magic cut-over table created
2017-01-26 14:55:38 INFO Locking historical.raw_post_data, historical._raw_post_data_del
2017-01-26 14:55:38 INFO Tables locked
2017-01-26 14:55:38 INFO Session locking original & magic tables is 5568
2017-01-26 14:55:38 INFO Writing changelog state: AllEventsUpToLockProcessed:1485460538692532253
2017-01-26 14:55:38 INFO Waiting for events up to lock
Copy: 351857/351857 100.0%; Applied: 0; Backlog: 0/100; Time: 2h30m25s(total), 2h25m37s(copy); streamer: mysql-bin-changelog.134406:119471848; State: migrating; ETA: due
2017-01-26 14:55:41 ERROR Timeout while waiting for events up to lock
2017-01-26 14:55:41 ERROR 2017-01-26 14:55:41 ERROR Timeout while waiting for events up to lock
2017-01-26 14:55:41 INFO Looking for magic cut-over table
2017-01-26 14:55:41 INFO Will now proceed to drop magic table and unlock tables
2017-01-26 14:55:41 INFO Dropping magic cut-over table
2017-01-26 14:55:41 INFO Removing socket file: /tmp/gh-ost.historical.raw_post_data.sock
2017-01-26 14:55:41 FATAL 2017-01-26 14:55:41 ERROR Timeout while waiting for events up to lock

About this issue

  • Original URL
  • State: closed
  • Created 7 years ago
  • Comments: 57 (32 by maintainers)

Most upvoted comments

Well, I will see it later.

+3
siddontang on Feb 7, 2017

@shlomi-noach Thank you! Yes I can test it and no - POINT column is not part of PRIMARY KEY in that table.

+1
eLco on Mar 2, 2017

Done. go-mysql #109

+1
eLco on Feb 7, 2017

I can upgrade that replica to latest Percona MySQL 5.7.17 or to 5.7.14. I can’t downgrade that particular DB to 5.5, cause it’s uses 5.7 specific functionality.

+1
eLco on Feb 7, 2017

@shlomi-noach Running with --dml-batch-size=1 ends with the same error.

+1
eLco on Feb 6, 2017

grep ‘Intercepted changelog state’ screenlog.0 2017-02-06 09:33:55 INFO Intercepted changelog state GhostTableMigrated

+1
eLco on Feb 6, 2017

@shlomi-noach Same server, same software versions:

  1. Command used:
./gh-ost \
--user="xxx" \
--password="xxxx" \
--host=localhost \
--test-on-replica \
--database="test_db" \
--table="testtable" \
  --alter="engine=innodb" \
  --initially-drop-ghost-table \
  --initially-drop-old-table \
  --max-load=Threads_running=100 \
  --switch-to-rbr \
  --chunk-size=500 \
  --cut-over=default \
  --exact-rowcount \
  --concurrent-rowcount \
  --serve-socket-file=/tmp/gh-ost.test.sock \
  --panic-flag-file=/tmp/gh-ost.panic.flag \
  --assume-master-host=XXX \
--debug \
--execute
  1. Log output:
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19089141]..[19089809]; iteration: 24172; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19089809]..[19090395]; iteration: 24173; chunk-size: 500
Copy: 12087000/12090865 100.0%; Applied: 0; Backlog: 0/100; Time: 7m48s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 0s
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19090395]..[19090990]; iteration: 24174; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19090990]..[19091607]; iteration: 24175; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19091607]..[19092189]; iteration: 24176; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19092189]..[19092786]; iteration: 24177; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19092786]..[19093374]; iteration: 24178; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19093374]..[19093977]; iteration: 24179; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19093977]..[19094595]; iteration: 24180; chunk-size: 500
2017-02-06 08:05:21 DEBUG Issued INSERT on range: [19094595]..[19094989]; iteration: 24181; chunk-size: 500
2017-02-06 08:05:21 DEBUG Iteration complete: no further range to iterate
2017-02-06 08:05:21 INFO Row copy complete
2017-02-06 08:05:21 DEBUG Iteration complete: no further range to iterate
2017-02-06 08:05:21 DEBUG Getting nothing in the write queue. Sleeping...
Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m48s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due
2017-02-06 08:05:21 DEBUG checking for cut-over postpone
2017-02-06 08:05:21 DEBUG checking for cut-over postpone: complete
2017-02-06 08:05:21 DEBUG testing on replica. Stopping replication IO thread
2017-02-06 08:05:21 INFO Stopping replication
2017-02-06 08:05:21 INFO Replication stopped
2017-02-06 08:05:21 INFO Verifying SQL thread is stopped
2017-02-06 08:05:21 INFO SQL thread stopped
2017-02-06 08:05:21 INFO Replication IO thread at mysql-bin.001112:12843620. SQL thread is at mysql-bin.001112:12843620
2017-02-06 08:05:21 INFO Grabbing voluntary lock: gh-ost.13854752.lock
2017-02-06 08:05:21 INFO Setting LOCK timeout as 6 seconds
2017-02-06 08:05:21 INFO Looking for magic cut-over table
2017-02-06 08:05:21 INFO Creating magic cut-over table `test_db`.`_testtable_ght`
2017-02-06 08:05:21 INFO Magic cut-over table created
2017-02-06 08:05:21 INFO Locking `test_db`.`testtable`, `test_db`.`_testtable_ght`
2017-02-06 08:05:21 INFO Tables locked
2017-02-06 08:05:21 INFO Session locking original & magic tables is 13854752
2017-02-06 08:05:21 INFO Writing changelog state: AllEventsUpToLockProcessed:1486368321551907413
2017-02-06 08:05:21 INFO Waiting for events up to lock
2017-02-06 08:05:22 DEBUG Getting nothing in the write queue. Sleeping...
Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m50s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due
2017-02-06 08:05:23 DEBUG Getting nothing in the write queue. Sleeping...
2017-02-06 08:05:24 DEBUG Getting nothing in the write queue. Sleeping...
2017-02-06 08:05:24 ERROR Timeout while waiting for events up to lock
2017-02-06 08:05:24 ERROR 2017-02-06 08:05:24 ERROR Timeout while waiting for events up to lock
2017-02-06 08:05:24 INFO Looking for magic cut-over table
2017-02-06 08:05:24 INFO Will now proceed to drop magic table and unlock tables
2017-02-06 08:05:24 INFO Dropping magic cut-over table
2017-02-06 08:05:24 INFO Renaming back both tables
2017-02-06 08:05:24 INFO Releasing lock from `test_db`.`testtable`, `test_db`.`_testtable_ght`
2017-02-06 08:05:24 INFO Tables unlocked
2017-02-06 08:05:24 ERROR Error 1050: Table '_testtable_gho' already exists
2017-02-06 08:05:24 INFO Renaming back to ghost table
2017-02-06 08:05:24 ERROR Error 1050: Table '_testtable_gho' already exists
2017-02-06 08:05:24 INFO Renaming back to original table
2017-02-06 08:05:24 ERROR Error 1050: Table 'testtable' already exists
2017-02-06 08:05:24 ERROR Error 1050: Table 'testtable' already exists
2017-02-06 08:05:25 DEBUG Getting nothing in the write queue. Sleeping...
2017-02-06 08:05:25 DEBUG checking for cut-over postpone
2017-02-06 08:05:25 DEBUG checking for cut-over postpone: complete
2017-02-06 08:05:25 DEBUG testing on replica. Stopping replication IO thread
2017-02-06 08:05:25 INFO Stopping replication
2017-02-06 08:05:25 INFO Replication stopped
2017-02-06 08:05:25 INFO Verifying SQL thread is stopped
2017-02-06 08:05:25 INFO SQL thread stopped
2017-02-06 08:05:25 INFO Replication IO thread at mysql-bin.001112:12843620. SQL thread is at mysql-bin.001112:12843620
2017-02-06 08:05:25 INFO Grabbing voluntary lock: gh-ost.13854752.lock
2017-02-06 08:05:25 INFO Setting LOCK timeout as 6 seconds
2017-02-06 08:05:25 INFO Looking for magic cut-over table
2017-02-06 08:05:25 INFO Creating magic cut-over table `test_db`.`_testtable_ght`
2017-02-06 08:05:25 INFO Magic cut-over table created
2017-02-06 08:05:25 INFO Locking `test_db`.`testtable`, `test_db`.`_testtable_ght`
2017-02-06 08:05:25 INFO Tables locked
2017-02-06 08:05:25 INFO Session locking original & magic tables is 13854752
2017-02-06 08:05:25 INFO Writing changelog state: AllEventsUpToLockProcessed:1486368325569514802
2017-02-06 08:05:25 INFO Waiting for events up to lock
2017-02-06 08:05:26 DEBUG Getting nothing in the write queue. Sleeping...
2017-02-06 08:05:27 DEBUG Getting nothing in the write queue. Sleeping...
Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m55s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due
2017-02-06 08:05:28 DEBUG Getting nothing in the write queue. Sleeping...
2017-02-06 08:05:28 ERROR Timeout while waiting for events up to lock
2017-02-06 08:05:28 ERROR 2017-02-06 08:05:28 ERROR Timeout while waiting for events up to lock
  1. MySQL queries results:
mysql> select * from _testtable_ghc where id <= 255;
+----+---------------------+-----------+------------------------------------------------+
| id | last_update         | hint      | value                                          |
+----+---------------------+-----------+------------------------------------------------+
|  1 | 2017-02-06 08:09:21 | heartbeat | 2017-02-06T08:09:21.192989177Z                 |
|  2 | 2017-02-06 08:09:18 | state     | AllEventsUpToLockProcessed:1486368558259697217 |
+----+---------------------+-----------+------------------------------------------------+
2 rows in set (0.00 sec)

mysql> select * from _testtable_ghc order by id desc limit 200;
+-----+---------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id  | last_update         | hint                               | value                                                                                                                                                         |
+-----+---------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 541 | 2017-02-06 08:09:18 | copy iteration 24182 at 1486368558 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m45s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 540 | 2017-02-06 08:09:18 | state at 1486368558260398130       | AllEventsUpToLockProcessed:1486368558259697217                                                                                                                |
| 539 | 2017-02-06 08:09:14 | state at 1486368554252201503       | AllEventsUpToLockProcessed:1486368554251448886                                                                                                                |
| 538 | 2017-02-06 08:09:13 | copy iteration 24182 at 1486368553 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m40s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 537 | 2017-02-06 08:09:10 | state at 1486368550244642421       | AllEventsUpToLockProcessed:1486368550243950882                                                                                                                |
| 536 | 2017-02-06 08:09:08 | copy iteration 24182 at 1486368548 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m35s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 535 | 2017-02-06 08:09:06 | state at 1486368546237298609       | AllEventsUpToLockProcessed:1486368546236556867                                                                                                                |
| 534 | 2017-02-06 08:09:03 | copy iteration 24182 at 1486368543 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m30s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 533 | 2017-02-06 08:09:02 | state at 1486368542229287395       | AllEventsUpToLockProcessed:1486368542228587534                                                                                                                |
| 532 | 2017-02-06 08:08:58 | copy iteration 24182 at 1486368538 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m25s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 531 | 2017-02-06 08:08:58 | state at 1486368538221186409       | AllEventsUpToLockProcessed:1486368538220489130                                                                                                                |
| 530 | 2017-02-06 08:08:54 | state at 1486368534213227576       | AllEventsUpToLockProcessed:1486368534212496103                                                                                                                |
| 529 | 2017-02-06 08:08:53 | copy iteration 24182 at 1486368533 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m20s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 528 | 2017-02-06 08:08:50 | state at 1486368530204207276       | AllEventsUpToLockProcessed:1486368530203487306                                                                                                                |
| 527 | 2017-02-06 08:08:48 | copy iteration 24182 at 1486368528 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m15s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 526 | 2017-02-06 08:08:46 | state at 1486368526198384122       | AllEventsUpToLockProcessed:1486368526195984264                                                                                                                |
| 525 | 2017-02-06 08:08:43 | copy iteration 24182 at 1486368523 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m10s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 524 | 2017-02-06 08:08:42 | state at 1486368522181751729       | AllEventsUpToLockProcessed:1486368522180572975                                                                                                                |
| 523 | 2017-02-06 08:08:38 | copy iteration 24182 at 1486368518 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m5s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 522 | 2017-02-06 08:08:38 | state at 1486368518112433472       | AllEventsUpToLockProcessed:1486368518111745462                                                                                                                |
| 521 | 2017-02-06 08:08:34 | state at 1486368514104800791       | AllEventsUpToLockProcessed:1486368514104107618                                                                                                                |
| 520 | 2017-02-06 08:08:33 | copy iteration 24182 at 1486368513 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 11m0s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 519 | 2017-02-06 08:08:30 | state at 1486368510094490952       | AllEventsUpToLockProcessed:1486368510093207705                                                                                                                |
| 518 | 2017-02-06 08:08:28 | copy iteration 24182 at 1486368508 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m55s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 517 | 2017-02-06 08:08:26 | state at 1486368506086258472       | AllEventsUpToLockProcessed:1486368506085529796                                                                                                                |
| 516 | 2017-02-06 08:08:23 | copy iteration 24182 at 1486368503 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m50s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 515 | 2017-02-06 08:08:22 | state at 1486368502077791968       | AllEventsUpToLockProcessed:1486368502077080682                                                                                                                |
| 514 | 2017-02-06 08:08:18 | copy iteration 24182 at 1486368498 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m45s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 513 | 2017-02-06 08:08:18 | state at 1486368498069324036       | AllEventsUpToLockProcessed:1486368498068652502                                                                                                                |
| 512 | 2017-02-06 08:08:14 | state at 1486368494061598235       | AllEventsUpToLockProcessed:1486368494060814872                                                                                                                |
| 511 | 2017-02-06 08:08:13 | copy iteration 24182 at 1486368493 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m40s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 510 | 2017-02-06 08:08:10 | state at 1486368490052813751       | AllEventsUpToLockProcessed:1486368490052134535                                                                                                                |
| 509 | 2017-02-06 08:08:08 | copy iteration 24182 at 1486368488 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m35s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 508 | 2017-02-06 08:08:06 | state at 1486368486044588813       | AllEventsUpToLockProcessed:1486368486043716965                                                                                                                |
| 507 | 2017-02-06 08:08:03 | copy iteration 24182 at 1486368483 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m30s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 506 | 2017-02-06 08:08:02 | state at 1486368482036481342       | AllEventsUpToLockProcessed:1486368482035799249                                                                                                                |
| 505 | 2017-02-06 08:07:58 | copy iteration 24182 at 1486368478 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m25s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 504 | 2017-02-06 08:07:58 | state at 1486368478026206323       | AllEventsUpToLockProcessed:1486368478025534742                                                                                                                |
| 503 | 2017-02-06 08:07:54 | state at 1486368474018286959       | AllEventsUpToLockProcessed:1486368474017571636                                                                                                                |
| 502 | 2017-02-06 08:07:53 | copy iteration 24182 at 1486368473 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m20s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 501 | 2017-02-06 08:07:50 | state at 1486368470009585283       | AllEventsUpToLockProcessed:1486368470008859770                                                                                                                |
| 500 | 2017-02-06 08:07:48 | copy iteration 24182 at 1486368468 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m15s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 499 | 2017-02-06 08:07:46 | state at 1486368466001691839       | AllEventsUpToLockProcessed:1486368466000781665                                                                                                                |
| 498 | 2017-02-06 08:07:43 | copy iteration 24182 at 1486368463 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m10s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due |
| 497 | 2017-02-06 08:07:41 | state at 1486368461992649550       | AllEventsUpToLockProcessed:1486368461991833027                                                                                                                |
| 496 | 2017-02-06 08:07:38 | copy iteration 24182 at 1486368458 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m5s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 495 | 2017-02-06 08:07:37 | state at 1486368457982487583       | AllEventsUpToLockProcessed:1486368457981830014                                                                                                                |
| 494 | 2017-02-06 08:07:33 | state at 1486368453974644777       | AllEventsUpToLockProcessed:1486368453973920285                                                                                                                |
| 493 | 2017-02-06 08:07:33 | copy iteration 24182 at 1486368453 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 10m0s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 492 | 2017-02-06 08:07:29 | state at 1486368449965413734       | AllEventsUpToLockProcessed:1486368449964730357                                                                                                                |
| 491 | 2017-02-06 08:07:28 | copy iteration 24182 at 1486368448 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m55s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 490 | 2017-02-06 08:07:25 | state at 1486368445957255406       | AllEventsUpToLockProcessed:1486368445956545714                                                                                                                |
| 489 | 2017-02-06 08:07:23 | copy iteration 24182 at 1486368443 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m50s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 488 | 2017-02-06 08:07:21 | state at 1486368441949363720       | AllEventsUpToLockProcessed:1486368441948619833                                                                                                                |
| 487 | 2017-02-06 08:07:18 | copy iteration 24182 at 1486368438 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m45s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 486 | 2017-02-06 08:07:17 | state at 1486368437939837334       | AllEventsUpToLockProcessed:1486368437939101152                                                                                                                |
| 485 | 2017-02-06 08:07:13 | state at 1486368433932134519       | AllEventsUpToLockProcessed:1486368433931330714                                                                                                                |
| 484 | 2017-02-06 08:07:13 | copy iteration 24182 at 1486368433 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m40s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 483 | 2017-02-06 08:07:09 | state at 1486368429923773512       | AllEventsUpToLockProcessed:1486368429922925634                                                                                                                |
| 482 | 2017-02-06 08:07:08 | copy iteration 24182 at 1486368428 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m35s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 481 | 2017-02-06 08:07:05 | state at 1486368425914814631       | AllEventsUpToLockProcessed:1486368425914072962                                                                                                                |
| 480 | 2017-02-06 08:07:03 | copy iteration 24182 at 1486368423 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m30s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 479 | 2017-02-06 08:07:01 | state at 1486368421906994380       | AllEventsUpToLockProcessed:1486368421906167784                                                                                                                |
| 478 | 2017-02-06 08:06:58 | copy iteration 24182 at 1486368418 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m25s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 477 | 2017-02-06 08:06:57 | state at 1486368417891001945       | AllEventsUpToLockProcessed:1486368417890302469                                                                                                                |
| 476 | 2017-02-06 08:06:53 | state at 1486368413879419845       | AllEventsUpToLockProcessed:1486368413878733006                                                                                                                |
| 475 | 2017-02-06 08:06:53 | copy iteration 24182 at 1486368413 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m20s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 474 | 2017-02-06 08:06:49 | state at 1486368409867216220       | AllEventsUpToLockProcessed:1486368409866549357                                                                                                                |
| 473 | 2017-02-06 08:06:48 | copy iteration 24182 at 1486368408 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m15s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 472 | 2017-02-06 08:06:45 | state at 1486368405857786998       | AllEventsUpToLockProcessed:1486368405857103532                                                                                                                |
| 471 | 2017-02-06 08:06:43 | copy iteration 24182 at 1486368403 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m10s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 470 | 2017-02-06 08:06:41 | state at 1486368401849454767       | AllEventsUpToLockProcessed:1486368401848634807                                                                                                                |
| 469 | 2017-02-06 08:06:38 | copy iteration 24182 at 1486368398 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m5s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due   |
| 468 | 2017-02-06 08:06:37 | state at 1486368397829510166       | AllEventsUpToLockProcessed:1486368397828769756                                                                                                                |
| 467 | 2017-02-06 08:06:33 | state at 1486368393813341054       | AllEventsUpToLockProcessed:1486368393812411538                                                                                                                |
| 466 | 2017-02-06 08:06:33 | copy iteration 24182 at 1486368393 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 9m0s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due   |
| 465 | 2017-02-06 08:06:29 | state at 1486368389804520866       | AllEventsUpToLockProcessed:1486368389803639939                                                                                                                |
| 464 | 2017-02-06 08:06:28 | copy iteration 24182 at 1486368388 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m55s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 463 | 2017-02-06 08:06:25 | state at 1486368385795162759       | AllEventsUpToLockProcessed:1486368385794232980                                                                                                                |
| 462 | 2017-02-06 08:06:23 | copy iteration 24182 at 1486368383 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m50s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 461 | 2017-02-06 08:06:21 | state at 1486368381784882111       | AllEventsUpToLockProcessed:1486368381784154930                                                                                                                |
| 460 | 2017-02-06 08:06:18 | copy iteration 24182 at 1486368378 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m45s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 459 | 2017-02-06 08:06:17 | state at 1486368377763063580       | AllEventsUpToLockProcessed:1486368377762290549                                                                                                                |
| 458 | 2017-02-06 08:06:13 | state at 1486368373753719702       | AllEventsUpToLockProcessed:1486368373753048591                                                                                                                |
| 457 | 2017-02-06 08:06:13 | copy iteration 24182 at 1486368373 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m40s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 456 | 2017-02-06 08:06:09 | state at 1486368369743748968       | AllEventsUpToLockProcessed:1486368369743030858                                                                                                                |
| 455 | 2017-02-06 08:06:08 | copy iteration 24182 at 1486368368 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m35s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 454 | 2017-02-06 08:06:05 | state at 1486368365731660190       | AllEventsUpToLockProcessed:1486368365730911124                                                                                                                |
| 453 | 2017-02-06 08:06:03 | copy iteration 24182 at 1486368363 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m30s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 452 | 2017-02-06 08:06:01 | state at 1486368361721468930       | AllEventsUpToLockProcessed:1486368361720830210                                                                                                                |
| 451 | 2017-02-06 08:05:58 | copy iteration 24182 at 1486368358 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m25s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 450 | 2017-02-06 08:05:57 | state at 1486368357710856478       | AllEventsUpToLockProcessed:1486368357710081523                                                                                                                |
| 449 | 2017-02-06 08:05:53 | state at 1486368353700829304       | AllEventsUpToLockProcessed:1486368353700007594                                                                                                                |
| 448 | 2017-02-06 08:05:53 | copy iteration 24182 at 1486368353 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m20s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 447 | 2017-02-06 08:05:49 | state at 1486368349690281171       | AllEventsUpToLockProcessed:1486368349689419435                                                                                                                |
| 446 | 2017-02-06 08:05:48 | copy iteration 24182 at 1486368348 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m15s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 445 | 2017-02-06 08:05:45 | state at 1486368345676150033       | AllEventsUpToLockProcessed:1486368345675303891                                                                                                                |
| 444 | 2017-02-06 08:05:43 | copy iteration 24182 at 1486368343 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m10s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 443 | 2017-02-06 08:05:41 | state at 1486368341618363176       | AllEventsUpToLockProcessed:1486368341617646508                                                                                                                |
| 442 | 2017-02-06 08:05:38 | copy iteration 24182 at 1486368338 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m5s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due   |
| 441 | 2017-02-06 08:05:37 | state at 1486368337606827958       | AllEventsUpToLockProcessed:1486368337606156741                                                                                                                |
| 440 | 2017-02-06 08:05:33 | state at 1486368333596276467       | AllEventsUpToLockProcessed:1486368333595379880                                                                                                                |
| 439 | 2017-02-06 08:05:33 | copy iteration 24182 at 1486368333 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 8m0s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due   |
| 438 | 2017-02-06 08:05:29 | state at 1486368329583116087       | AllEventsUpToLockProcessed:1486368329581359598                                                                                                                |
| 437 | 2017-02-06 08:05:28 | copy iteration 24182 at 1486368328 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m55s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 436 | 2017-02-06 08:05:25 | state at 1486368325570270063       | AllEventsUpToLockProcessed:1486368325569514802                                                                                                                |
| 435 | 2017-02-06 08:05:23 | copy iteration 24182 at 1486368323 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m50s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 434 | 2017-02-06 08:05:21 | state at 1486368321552671686       | AllEventsUpToLockProcessed:1486368321551907413                                                                                                                |
| 433 | 2017-02-06 08:05:21 | copy iteration 24182 at 1486368321 | Copy: 12090837/12090837 100.0%; Applied: 0; Backlog: 0/100; Time: 7m48s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: due  |
| 432 | 2017-02-06 08:05:21 | copy iteration 24174 at 1486368321 | Copy: 12087000/12090865 100.0%; Applied: 0; Backlog: 0/100; Time: 7m48s(total), 7m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 0s   |
| 431 | 2017-02-06 08:05:20 | copy iteration 24123 at 1486368320 | Copy: 12061500/12090865 99.8%; Applied: 0; Backlog: 0/100; Time: 7m47s(total), 7m47s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1s    |
| 430 | 2017-02-06 08:05:19 | copy iteration 24074 at 1486368319 | Copy: 12037000/12090865 99.6%; Applied: 0; Backlog: 0/100; Time: 7m46s(total), 7m46s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2s    |
| 429 | 2017-02-06 08:05:18 | copy iteration 24027 at 1486368318 | Copy: 12013500/12090865 99.4%; Applied: 0; Backlog: 0/100; Time: 7m45s(total), 7m45s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2s    |
| 428 | 2017-02-06 08:05:17 | copy iteration 23980 at 1486368317 | Copy: 11990000/12090865 99.2%; Applied: 0; Backlog: 0/100; Time: 7m44s(total), 7m44s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 3s    |
| 427 | 2017-02-06 08:05:16 | copy iteration 23930 at 1486368316 | Copy: 11965000/12090865 99.0%; Applied: 0; Backlog: 0/100; Time: 7m43s(total), 7m43s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 4s    |
| 426 | 2017-02-06 08:05:15 | copy iteration 23879 at 1486368315 | Copy: 11939500/12090865 98.7%; Applied: 0; Backlog: 0/100; Time: 7m42s(total), 7m42s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 5s    |
| 425 | 2017-02-06 08:05:14 | copy iteration 23830 at 1486368314 | Copy: 11915000/12090865 98.5%; Applied: 0; Backlog: 0/100; Time: 7m41s(total), 7m41s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 6s    |
| 424 | 2017-02-06 08:05:13 | copy iteration 23781 at 1486368313 | Copy: 11890500/12090865 98.3%; Applied: 0; Backlog: 0/100; Time: 7m40s(total), 7m40s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 7s    |
| 423 | 2017-02-06 08:05:12 | copy iteration 23731 at 1486368312 | Copy: 11865500/12090865 98.1%; Applied: 0; Backlog: 0/100; Time: 7m39s(total), 7m39s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 8s    |
| 422 | 2017-02-06 08:05:11 | copy iteration 23683 at 1486368311 | Copy: 11841500/12090865 97.9%; Applied: 0; Backlog: 0/100; Time: 7m38s(total), 7m38s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 9s    |
| 421 | 2017-02-06 08:05:10 | copy iteration 23637 at 1486368310 | Copy: 11818500/12090865 97.7%; Applied: 0; Backlog: 0/100; Time: 7m37s(total), 7m37s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 10s   |
| 420 | 2017-02-06 08:05:09 | copy iteration 23589 at 1486368309 | Copy: 11794500/12090865 97.5%; Applied: 0; Backlog: 0/100; Time: 7m36s(total), 7m36s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 11s   |
| 419 | 2017-02-06 08:05:08 | copy iteration 23536 at 1486368308 | Copy: 11768000/12090865 97.3%; Applied: 0; Backlog: 0/100; Time: 7m35s(total), 7m35s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 12s   |
| 418 | 2017-02-06 08:05:07 | copy iteration 23490 at 1486368307 | Copy: 11745000/12090865 97.1%; Applied: 0; Backlog: 0/100; Time: 7m34s(total), 7m34s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 13s   |
| 417 | 2017-02-06 08:05:06 | copy iteration 23440 at 1486368306 | Copy: 11720000/12090865 96.9%; Applied: 0; Backlog: 0/100; Time: 7m33s(total), 7m33s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 14s   |
| 416 | 2017-02-06 08:05:05 | copy iteration 23391 at 1486368305 | Copy: 11695500/12090865 96.7%; Applied: 0; Backlog: 0/100; Time: 7m32s(total), 7m32s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 15s   |
| 415 | 2017-02-06 08:05:04 | copy iteration 23337 at 1486368304 | Copy: 11668500/12090865 96.5%; Applied: 0; Backlog: 0/100; Time: 7m31s(total), 7m31s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 16s   |
| 414 | 2017-02-06 08:05:03 | copy iteration 23283 at 1486368303 | Copy: 11641500/12090865 96.3%; Applied: 0; Backlog: 0/100; Time: 7m30s(total), 7m30s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 17s   |
| 413 | 2017-02-06 08:05:02 | copy iteration 23235 at 1486368302 | Copy: 11617500/12090865 96.1%; Applied: 0; Backlog: 0/100; Time: 7m29s(total), 7m29s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 18s   |
| 412 | 2017-02-06 08:05:01 | copy iteration 23214 at 1486368301 | Copy: 11607000/12090865 96.0%; Applied: 0; Backlog: 0/100; Time: 7m28s(total), 7m28s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 18s   |
| 411 | 2017-02-06 08:05:00 | copy iteration 23162 at 1486368300 | Copy: 11581000/12090865 95.8%; Applied: 0; Backlog: 0/100; Time: 7m27s(total), 7m27s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 19s   |
| 410 | 2017-02-06 08:04:59 | copy iteration 23110 at 1486368299 | Copy: 11555000/12090865 95.6%; Applied: 0; Backlog: 0/100; Time: 7m26s(total), 7m26s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 20s   |
| 409 | 2017-02-06 08:04:58 | copy iteration 23062 at 1486368298 | Copy: 11531000/12090865 95.4%; Applied: 0; Backlog: 0/100; Time: 7m25s(total), 7m25s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 21s   |
| 408 | 2017-02-06 08:04:57 | copy iteration 23012 at 1486368297 | Copy: 11506000/12090865 95.2%; Applied: 0; Backlog: 0/100; Time: 7m24s(total), 7m24s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 22s   |
| 407 | 2017-02-06 08:04:56 | copy iteration 22965 at 1486368296 | Copy: 11482500/12090865 95.0%; Applied: 0; Backlog: 0/100; Time: 7m23s(total), 7m23s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 23s   |
| 406 | 2017-02-06 08:04:55 | copy iteration 22915 at 1486368295 | Copy: 11457500/12090865 94.8%; Applied: 0; Backlog: 0/100; Time: 7m22s(total), 7m22s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 24s   |
| 405 | 2017-02-06 08:04:54 | copy iteration 22863 at 1486368294 | Copy: 11431500/12090865 94.5%; Applied: 0; Backlog: 0/100; Time: 7m21s(total), 7m21s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 25s   |
| 404 | 2017-02-06 08:04:53 | copy iteration 22810 at 1486368293 | Copy: 11405000/12090865 94.3%; Applied: 0; Backlog: 0/100; Time: 7m20s(total), 7m20s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 26s   |
| 403 | 2017-02-06 08:04:52 | copy iteration 22760 at 1486368292 | Copy: 11380000/12090865 94.1%; Applied: 0; Backlog: 0/100; Time: 7m19s(total), 7m19s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 27s   |
| 402 | 2017-02-06 08:04:51 | copy iteration 22710 at 1486368291 | Copy: 11355000/12090865 93.9%; Applied: 0; Backlog: 0/100; Time: 7m18s(total), 7m18s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 28s   |
| 401 | 2017-02-06 08:04:50 | copy iteration 22658 at 1486368290 | Copy: 11329000/12090865 93.7%; Applied: 0; Backlog: 0/100; Time: 7m17s(total), 7m17s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 29s   |
| 400 | 2017-02-06 08:04:49 | copy iteration 22606 at 1486368289 | Copy: 11303000/12090865 93.5%; Applied: 0; Backlog: 0/100; Time: 7m16s(total), 7m16s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 30s   |
| 399 | 2017-02-06 08:04:48 | copy iteration 22556 at 1486368288 | Copy: 11278000/12090865 93.3%; Applied: 0; Backlog: 0/100; Time: 7m15s(total), 7m15s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 31s   |
| 398 | 2017-02-06 08:04:47 | copy iteration 22502 at 1486368287 | Copy: 11251000/12090865 93.1%; Applied: 0; Backlog: 0/100; Time: 7m14s(total), 7m14s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 32s   |
| 397 | 2017-02-06 08:04:46 | copy iteration 22452 at 1486368286 | Copy: 11226000/12090865 92.8%; Applied: 0; Backlog: 0/100; Time: 7m13s(total), 7m13s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 33s   |
| 396 | 2017-02-06 08:04:45 | copy iteration 22401 at 1486368285 | Copy: 11200500/12090865 92.6%; Applied: 0; Backlog: 0/100; Time: 7m12s(total), 7m12s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 34s   |
| 395 | 2017-02-06 08:04:44 | copy iteration 22351 at 1486368284 | Copy: 11175500/12090865 92.4%; Applied: 0; Backlog: 0/100; Time: 7m11s(total), 7m11s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 35s   |
| 394 | 2017-02-06 08:04:43 | copy iteration 22299 at 1486368283 | Copy: 11149500/12090865 92.2%; Applied: 0; Backlog: 0/100; Time: 7m10s(total), 7m10s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 36s   |
| 393 | 2017-02-06 08:04:42 | copy iteration 22250 at 1486368282 | Copy: 11125000/12090865 92.0%; Applied: 0; Backlog: 0/100; Time: 7m9s(total), 7m9s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 37s     |
| 392 | 2017-02-06 08:04:41 | copy iteration 22201 at 1486368281 | Copy: 11100500/12090865 91.8%; Applied: 0; Backlog: 0/100; Time: 7m8s(total), 7m8s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 38s     |
| 391 | 2017-02-06 08:04:40 | copy iteration 22150 at 1486368280 | Copy: 11075000/12090865 91.6%; Applied: 0; Backlog: 0/100; Time: 7m7s(total), 7m7s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 39s     |
| 390 | 2017-02-06 08:04:39 | copy iteration 22098 at 1486368279 | Copy: 11049000/12090865 91.4%; Applied: 0; Backlog: 0/100; Time: 7m6s(total), 7m6s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 40s     |
| 389 | 2017-02-06 08:04:38 | copy iteration 22046 at 1486368278 | Copy: 11023000/12090865 91.2%; Applied: 0; Backlog: 0/100; Time: 7m5s(total), 7m5s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 41s     |
| 388 | 2017-02-06 08:04:37 | copy iteration 21998 at 1486368277 | Copy: 10999000/12090865 91.0%; Applied: 0; Backlog: 0/100; Time: 7m4s(total), 7m4s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 42s     |
| 387 | 2017-02-06 08:04:36 | copy iteration 21946 at 1486368276 | Copy: 10973000/12090865 90.8%; Applied: 0; Backlog: 0/100; Time: 7m3s(total), 7m3s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 43s     |
| 386 | 2017-02-06 08:04:35 | copy iteration 21900 at 1486368275 | Copy: 10950000/12090865 90.6%; Applied: 0; Backlog: 0/100; Time: 7m2s(total), 7m2s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 43s     |
| 385 | 2017-02-06 08:04:34 | copy iteration 21848 at 1486368274 | Copy: 10924000/12090865 90.3%; Applied: 0; Backlog: 0/100; Time: 7m1s(total), 7m1s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 44s     |
| 384 | 2017-02-06 08:04:33 | copy iteration 21803 at 1486368273 | Copy: 10901500/12090865 90.2%; Applied: 0; Backlog: 0/100; Time: 7m0s(total), 7m0s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 45s     |
| 383 | 2017-02-06 08:04:32 | copy iteration 21751 at 1486368272 | Copy: 10875500/12090865 89.9%; Applied: 0; Backlog: 0/100; Time: 6m59s(total), 6m59s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 46s   |
| 382 | 2017-02-06 08:04:31 | copy iteration 21702 at 1486368271 | Copy: 10851000/12090865 89.7%; Applied: 0; Backlog: 0/100; Time: 6m58s(total), 6m58s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 47s   |
| 381 | 2017-02-06 08:04:30 | copy iteration 21653 at 1486368270 | Copy: 10826500/12090865 89.5%; Applied: 0; Backlog: 0/100; Time: 6m57s(total), 6m57s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 48s   |
| 380 | 2017-02-06 08:04:29 | copy iteration 21604 at 1486368269 | Copy: 10802000/12090865 89.3%; Applied: 0; Backlog: 0/100; Time: 6m56s(total), 6m56s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 49s   |
| 379 | 2017-02-06 08:04:28 | copy iteration 21554 at 1486368268 | Copy: 10777000/12090865 89.1%; Applied: 0; Backlog: 0/100; Time: 6m55s(total), 6m55s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 50s   |
| 378 | 2017-02-06 08:04:27 | copy iteration 21501 at 1486368267 | Copy: 10750500/12090865 88.9%; Applied: 0; Backlog: 0/100; Time: 6m54s(total), 6m54s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 51s   |
| 377 | 2017-02-06 08:04:26 | copy iteration 21450 at 1486368266 | Copy: 10725000/12090865 88.7%; Applied: 0; Backlog: 0/100; Time: 6m53s(total), 6m53s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 52s   |
| 376 | 2017-02-06 08:04:25 | copy iteration 21401 at 1486368265 | Copy: 10700500/12090865 88.5%; Applied: 0; Backlog: 0/100; Time: 6m52s(total), 6m52s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 53s   |
| 375 | 2017-02-06 08:04:24 | copy iteration 21348 at 1486368264 | Copy: 10674000/12090865 88.3%; Applied: 0; Backlog: 0/100; Time: 6m51s(total), 6m51s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 54s   |
| 374 | 2017-02-06 08:04:23 | copy iteration 21296 at 1486368263 | Copy: 10648000/12090865 88.1%; Applied: 0; Backlog: 0/100; Time: 6m50s(total), 6m50s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 55s   |
| 373 | 2017-02-06 08:04:22 | copy iteration 21247 at 1486368262 | Copy: 10623500/12090865 87.9%; Applied: 0; Backlog: 0/100; Time: 6m49s(total), 6m49s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 56s   |
| 372 | 2017-02-06 08:04:21 | copy iteration 21199 at 1486368261 | Copy: 10599500/12090865 87.7%; Applied: 0; Backlog: 0/100; Time: 6m48s(total), 6m48s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 57s   |
| 371 | 2017-02-06 08:04:20 | copy iteration 21147 at 1486368260 | Copy: 10573500/12090865 87.5%; Applied: 0; Backlog: 0/100; Time: 6m47s(total), 6m47s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 58s   |
| 370 | 2017-02-06 08:04:19 | copy iteration 21096 at 1486368259 | Copy: 10548000/12090865 87.2%; Applied: 0; Backlog: 0/100; Time: 6m46s(total), 6m46s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 59s   |
| 369 | 2017-02-06 08:04:18 | copy iteration 21044 at 1486368258 | Copy: 10522000/12090865 87.0%; Applied: 0; Backlog: 0/100; Time: 6m45s(total), 6m45s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m0s  |
| 368 | 2017-02-06 08:04:13 | copy iteration 20792 at 1486368253 | Copy: 10396000/12090865 86.0%; Applied: 0; Backlog: 0/100; Time: 6m40s(total), 6m40s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m5s  |
| 367 | 2017-02-06 08:04:08 | copy iteration 20538 at 1486368248 | Copy: 10269000/12090865 84.9%; Applied: 0; Backlog: 0/100; Time: 6m35s(total), 6m35s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m10s |
| 366 | 2017-02-06 08:04:03 | copy iteration 20280 at 1486368243 | Copy: 10140000/12090865 83.9%; Applied: 0; Backlog: 0/100; Time: 6m30s(total), 6m30s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m15s |
| 365 | 2017-02-06 08:03:58 | copy iteration 20033 at 1486368238 | Copy: 10016500/12090865 82.8%; Applied: 0; Backlog: 0/100; Time: 6m25s(total), 6m25s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m19s |
| 364 | 2017-02-06 08:03:53 | copy iteration 19782 at 1486368233 | Copy: 9891000/12090865 81.8%; Applied: 0; Backlog: 0/100; Time: 6m20s(total), 6m20s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m24s  |
| 363 | 2017-02-06 08:03:48 | copy iteration 19530 at 1486368228 | Copy: 9765000/12090865 80.8%; Applied: 0; Backlog: 0/100; Time: 6m15s(total), 6m15s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m29s  |
| 362 | 2017-02-06 08:03:43 | copy iteration 19265 at 1486368223 | Copy: 9632500/12090865 79.7%; Applied: 0; Backlog: 0/100; Time: 6m10s(total), 6m10s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m34s  |
| 361 | 2017-02-06 08:03:38 | copy iteration 19001 at 1486368218 | Copy: 9500500/12090865 78.6%; Applied: 0; Backlog: 0/100; Time: 6m5s(total), 6m5s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m39s    |
| 360 | 2017-02-06 08:03:33 | copy iteration 18747 at 1486368213 | Copy: 9373500/12090865 77.5%; Applied: 0; Backlog: 0/100; Time: 6m0s(total), 6m0s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m44s    |
| 359 | 2017-02-06 08:03:28 | copy iteration 18490 at 1486368208 | Copy: 9245000/12090865 76.5%; Applied: 0; Backlog: 0/100; Time: 5m55s(total), 5m55s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m49s  |
| 358 | 2017-02-06 08:03:23 | copy iteration 18229 at 1486368203 | Copy: 9114500/12090865 75.4%; Applied: 0; Backlog: 0/100; Time: 5m50s(total), 5m50s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m54s  |
| 357 | 2017-02-06 08:03:18 | copy iteration 17979 at 1486368198 | Copy: 8989500/12090865 74.3%; Applied: 0; Backlog: 0/100; Time: 5m45s(total), 5m45s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 1m59s  |
| 356 | 2017-02-06 08:03:13 | copy iteration 17714 at 1486368193 | Copy: 8857000/12090865 73.3%; Applied: 0; Backlog: 0/100; Time: 5m40s(total), 5m40s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m4s   |
| 355 | 2017-02-06 08:03:08 | copy iteration 17459 at 1486368188 | Copy: 8729500/12090865 72.2%; Applied: 0; Backlog: 0/100; Time: 5m35s(total), 5m35s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m8s   |
| 354 | 2017-02-06 08:03:03 | copy iteration 17199 at 1486368183 | Copy: 8599500/12090865 71.1%; Applied: 0; Backlog: 0/100; Time: 5m30s(total), 5m30s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m13s  |
| 353 | 2017-02-06 08:02:58 | copy iteration 16944 at 1486368178 | Copy: 8472000/12090865 70.1%; Applied: 0; Backlog: 0/100; Time: 5m25s(total), 5m25s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m18s  |
| 352 | 2017-02-06 08:02:53 | copy iteration 16695 at 1486368173 | Copy: 8347500/12090865 69.0%; Applied: 0; Backlog: 0/100; Time: 5m20s(total), 5m20s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m23s  |
| 351 | 2017-02-06 08:02:48 | copy iteration 16437 at 1486368168 | Copy: 8218500/12090865 68.0%; Applied: 0; Backlog: 0/100; Time: 5m15s(total), 5m15s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m28s  |
| 350 | 2017-02-06 08:02:43 | copy iteration 16184 at 1486368163 | Copy: 8092000/12090865 66.9%; Applied: 0; Backlog: 0/100; Time: 5m10s(total), 5m10s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m33s  |
| 349 | 2017-02-06 08:02:38 | copy iteration 15917 at 1486368158 | Copy: 7958500/12090865 65.8%; Applied: 0; Backlog: 0/100; Time: 5m5s(total), 5m5s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m38s    |
| 348 | 2017-02-06 08:02:33 | copy iteration 15653 at 1486368153 | Copy: 7826500/12090865 64.7%; Applied: 0; Backlog: 0/100; Time: 5m0s(total), 5m0s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m43s    |
| 347 | 2017-02-06 08:02:28 | copy iteration 15394 at 1486368148 | Copy: 7697000/12090865 63.7%; Applied: 0; Backlog: 0/100; Time: 4m55s(total), 4m55s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m48s  |
| 346 | 2017-02-06 08:02:23 | copy iteration 15130 at 1486368143 | Copy: 7565000/12090865 62.6%; Applied: 0; Backlog: 0/100; Time: 4m50s(total), 4m50s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m53s  |
| 345 | 2017-02-06 08:02:18 | copy iteration 14862 at 1486368138 | Copy: 7431000/12090865 61.5%; Applied: 0; Backlog: 0/100; Time: 4m45s(total), 4m45s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 2m58s  |
| 344 | 2017-02-06 08:02:03 | copy iteration 14086 at 1486368123 | Copy: 7043000/12090865 58.3%; Applied: 0; Backlog: 0/100; Time: 4m30s(total), 4m30s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 3m13s  |
| 343 | 2017-02-06 08:01:33 | copy iteration 12519 at 1486368093 | Copy: 6259500/12090865 51.8%; Applied: 0; Backlog: 0/100; Time: 4m0s(total), 4m0s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 3m43s    |
| 342 | 2017-02-06 08:01:03 | copy iteration 10948 at 1486368063 | Copy: 5474000/12090865 45.3%; Applied: 0; Backlog: 0/100; Time: 3m30s(total), 3m30s(copy); streamer: mysql-bin.001106:46132783; State: migrating; ETA: 4m13s  |
+-----+---------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
200 rows in set (0.00 sec)
+1
eLco on Feb 6, 2017
Read more comments on GitHub
← Unity: Unzipped resources cannot be directly moved between drives
gh-ost: ERROR Timeout while waiting for events up to lock →