Re: Replication began to work not always, not right away
Date: April 07, 2012 03:57PM
The Host (in the PROCESSLIST) is NULL ??? Please describe the topology of your Master and Slave -- same or separate machines? TCP/IP connection? Other?
(I don't know what to make of that. I hope the Master and Slave are not on the same machine.)
SHOW MASTER STATUS; -- on Master
SHOW SLAVE STATUS \G -- on Slave
(I'm fishing for binlog/replicate-do/ignore and anything else out of the ordinary.)
Check the clocks on the two machines; the seem to be at least 8 seconds apart.
(I don't think this could cause the trouble, but you probably should fix it.)
> `ip` varchar(20) NOT NULL,
Overkill for IPv4; inadequate for IPv6.
(Unrelated issue.)
Please do these on both machines:
CHECK TABLE ibf__uag_banlist;
CHECK TABLE ibf__uag_gvars;
(Since you are using MyISAM, a REPAIR may be needed.)
|
Replication began to work not always, not right away
|
827 |
Dan Mor |
03/31/2012 02:47PM |
|
Re: Replication began to work not always, not right away
|
379 |
Rick James |
04/01/2012 05:37AM |
|
Re: Replication began to work not always, not right away
|
457 |
Dan Mor |
04/02/2012 12:47PM |
|
Re: Replication began to work not always, not right away
|
355 |
Rick James |
04/03/2012 08:58AM |
|
Re: Replication began to work not always, not right away
|
354 |
Dan Mor |
04/04/2012 02:26PM |
|
Re: Replication began to work not always, not right away
|
352 |
Rick James |
04/05/2012 07:36PM |
|
Re: Replication began to work not always, not right away
|
343 |
Dan Mor |
04/06/2012 07:33PM |
|
Re: Replication began to work not always, not right away |
352 |
Rick James |
04/07/2012 03:57PM |
|
Re: Replication began to work not always, not right away
|
560 |
Dan Mor |
04/07/2012 08:08PM |
|
Re: Replication began to work not always, not right away
|
341 |
Rick James |
04/08/2012 03:41PM |
|
Re: Replication began to work not always, not right away
|
418 |
Dan Mor |
04/14/2012 11:14AM |
|
Re: Replication began to work not always, not right away
|
370 |
Rick James |
04/15/2012 11:47PM |
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.