From: Oleg Tsarev
Date: June 11 2011 3:44pm
Subject: Re: cannot reset replication error
List-Archive: http://lists.mysql.com/replication/2102
Message-Id: <BANLkTimrrdydMWKWHnTYgzRqkASNAi54hA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0023547c895d78957404a57192a3

--0023547c895d78957404a57192a3
Content-Type: text/plain; charset=ISO-8859-1

Sorry, I missread in first look.
What the version of mysql used?

2011/6/11 Tim Dunphy <bluethundr@stripped>

> hello!
>
>  I am attempting to reset the error message on a slave. however when I try
> to do this using the SET GLOBAL sql_slave_skip_counter = N command it is
> having no effect. Replication is not broken on the slave and the binlog
> pointer is keeping pace with the master.
>
>
>
>
> ## still seeing resolved replication errors
>
>      Slave_IO_State: Waiting for master to send event
>
>
>  Last_Errno: 1146
>                   Last_Error: Error 'Table 'jfwiki.site_stats' doesn't
> exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
> SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
> ss_total_views=ss_total_views+1'
>                 Skip_Counter: 0
>          Exec_Master_Log_Pos: 41551
>              Relay_Log_Space: 452249
>              Until_Condition: None
>
>            Last_SQL_Errno: 1146
>               Last_SQL_Error: Error 'Table 'jfwiki.site_stats' doesn't
> exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
> SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
> ss_total_views=ss_total_views+1'
>  Replicate_Ignore_Server_Ids:
>
>
> ## trying to reset the error
>
> mysql> stop slave;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> SET GLOBAL sql_slave_skip_counter = 1;
> Query OK, 0 rows affected (0.00 sec)
>
>
> mysql> start slave;
> Query OK, 0 rows affected (0.00 sec)
>
>
> ## error remains
>
>
>      Slave_IO_State: Waiting for master to send event
>
>
>  Last_Errno: 1146
>                   Last_Error: Error 'Table 'jfwiki.site_stats' doesn't
> exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
> SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
> ss_total_views=ss_total_views+1'
>                 Skip_Counter: 0
>          Exec_Master_Log_Pos: 41551
>              Relay_Log_Space: 452249
>              Until_Condition: None
>
>            Last_SQL_Errno: 1146
>               Last_SQL_Error: Error 'Table 'jfwiki.site_stats' doesn't
> exist' on query. Default database: 'jfwiki'. Query: 'UPDATE /*
> SiteStatsUpdate::doUpdate 192.168.1.24 */ `site_stats` SET
> ss_total_views=ss_total_views+1'
>  Replicate_Ignore_Server_Ids:
>
>
> ## binlog pointer is keeping pace with the master
>
>        File: mysqld-bin.000002
>        Position: 665042
>
>  ---------------------------------
>        Read_Master_Log_Pos: 665042
>
>
> Thank you for any tips you might be able to share on this!
>
> tim
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=oleg.tsarev@stripped
>
>


-- 
Oleg Tsarev, Software Engineer, Percona Inc.

--0023547c895d78957404a57192a3--