MySQL Forums
Forum List  »  Replication

Re: Issue with Replication using MySQL 5.7.19 on Windows 2012
Posted by: Ankur Tyagi
Date: June 14, 2019 11:10AM

====================logs===========================
2019-06-13T13:54:29.857924Z 36 [Note] Start binlog_dump to master_thread_id(36) slave_server(101), pos(mysql-bin.000011, 154)
2019-06-13T13:54:33.917210Z 37 [Note] While initializing dump thread for slave with UUID <bacb0be6-8de2-11e9-a78d-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(36).
2019-06-13T13:54:33.918207Z 37 [Note] Start binlog_dump to master_thread_id(37) slave_server(101), pos(mysql-bin.000011, 154)
2019-06-13T13:55:02.151187Z 38 [Note] While initializing dump thread for slave with UUID <bacb0be6-8de2-11e9-a78d-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(37).
2019-06-13T13:55:02.152187Z 38 [Note] Start binlog_dump to master_thread_id(38) slave_server(101), pos(mysql-bin.000011, 154)
2019-06-13T14:03:46.346942Z 39 [Note] Access denied for user 'replication'@'localhost' (using password: NO)
2019-06-14T05:46:04.024560Z 38 [Note] Aborted connection 38 to db: 'unconnected' user: 'replication' host: '10-43-97-42' (failed on flush_net())
2019-06-14T07:03:57.232234Z 48 [Note] Start binlog_dump to master_thread_id(48) slave_server(101), pos(mysql-bin.000012, 154)
2019-06-14T07:04:01.403526Z 49 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(48).
2019-06-14T07:04:01.404523Z 49 [Note] Start binlog_dump to master_thread_id(49) slave_server(101), pos(mysql-bin.000012, 154)
2019-06-14T07:04:29.433492Z 50 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(49).
2019-06-14T07:04:29.434489Z 50 [Note] Start binlog_dump to master_thread_id(50) slave_server(101), pos(mysql-bin.000012, 154)
2019-06-14T10:30:44.303177Z 51 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(50).
2019-06-14T10:30:44.304173Z 51 [Note] Start binlog_dump to master_thread_id(51) slave_server(101), pos(mysql-bin.000012, 684)
2019-06-14T14:51:27.389266Z 42 [Note] Aborted connection 42 to db: 'replication' user: 'replication' host: 'localhost' (Got timeout reading communication packets)
2019-06-14T14:53:56.195683Z 45 [Note] Aborted connection 45 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets)
2019-06-14T15:17:32.818010Z 52 [Note] Start binlog_dump to master_thread_id(52) slave_server(101), pos(, 4)
2019-06-14T15:18:12.929827Z 53 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(52).
2019-06-14T15:18:12.929827Z 53 [Note] Start binlog_dump to master_thread_id(53) slave_server(101), pos(, 4)
2019-06-14T15:19:45.203295Z 54 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(53).
2019-06-14T15:19:45.204293Z 54 [Note] Start binlog_dump to master_thread_id(54) slave_server(101), pos(, 4)
2019-06-14T15:24:04.114445Z 55 [Note] While initializing dump thread for slave with UUID <8b0ef160-8e72-11e9-9887-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(54).
2019-06-14T15:24:04.114445Z 55 [Note] Start binlog_dump to master_thread_id(55) slave_server(101), pos(mysql-bin.000001, 419)
2019-06-14T15:27:17.280991Z 55 [Note] Aborted connection 55 to db: 'unconnected' user: 'replication' host: '10-43-97-42' (failed on flush_net())
2019-06-14T16:26:30.827156Z 59 [Note] Start binlog_dump to master_thread_id(59) slave_server(101), pos(mysql-bin.000004, 154)
2019-06-14T16:26:34.573420Z 60 [Note] While initializing dump thread for slave with UUID <2319b48e-8ec1-11e9-930d-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(59).
2019-06-14T16:26:34.574417Z 60 [Note] Start binlog_dump to master_thread_id(60) slave_server(101), pos(mysql-bin.000004, 154)
2019-06-14T16:26:59.467161Z 61 [Note] While initializing dump thread for slave with UUID <2319b48e-8ec1-11e9-930d-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(60).
2019-06-14T16:26:59.467161Z 61 [Note] Start binlog_dump to master_thread_id(61) slave_server(101), pos(mysql-bin.000004, 154)
2019-06-14T16:32:30.715390Z 62 [Note] While initializing dump thread for slave with UUID <2319b48e-8ec1-11e9-930d-02dc030030ab>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(61).
2019-06-14T16:32:30.716388Z 62 [Note] Start binlog_dump to master_thread_id(62) slave_server(101), pos(, 4)
2019-06-14T16:33:13.693401Z 63 [Note] Start binlog_dump to master_thread_id(63) slave_server(101), pos(, 4)
2019-06-14T16:45:43.721996Z 63 [Note] Aborted connection 63 to db: 'unconnected' user: 'replication' host: '10-43-97-42' (failed on flush_net())
2019-06-14T16:46:06.278577Z 64 [Note] Start binlog_dump to master_thread_id(64) slave_server(101), pos(mysql-bin.000001, 154)
======================================================

The earlier state was just after starting the slave, when I verified again it shows 'Yes'
> Slave_IO_Running: Yes

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.