Error in replication

Hi,

I am getting this error in replication:

Slave: query 'drop table adv.xScenario,adv.xTrackEvent' partially
completed on the master and was aborted. There is a chance that your
master is inconsistent at this point. If you are sure that your master
is ok, run this query manually on the slave and then restart the slave
with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START;

The adv.xScenario and adv.xTrackEvent are temporary tables. The issue is,
even if I skip this drop, next queries are dependent on these temporary
tables and hence can't be ignored. Is this message typically for DROP
command or is there is something wrong going on?

Regards,

Chandra

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Error in replication

Shukla, Chandra writes:
> Hi,
>
> I am getting this error in replication:
>
> Slave: query 'drop table adv.xScenario,adv.xTrackEvent' partially
> completed on the master and was aborted. There is a chance that your
> master is inconsistent at this point. If you are sure that your master
> is ok, run this query manually on the slave and then restart the slave
> with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START;
>
> The adv.xScenario and adv.xTrackEvent are temporary tables. The issue is,
> even if I skip this drop, next queries are dependent on these temporary
> tables and hence can't be ignored. Is this message typically for DROP
> command or is there is something wrong going on?
>
> Regards,
>
> Chandra
>

Hi!

The above is not a repolication bug.

That is a warning message that due to the error on master replication
is out of sync.

A true cause of error is in that drop command.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org