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

--20cf300fab91327aa904a5714324
Content-Type: text/plain; charset=ISO-8859-1

Hello,

According to documentation,

*"When using this statement, it is important to understand that the binary
log is actually organized as a sequence of groups known as event groups.
Each event group consists of a sequence of events.

   For transactional tables, an event group corresponds to a transaction.

   For nontransactional tables, an event group corresponds to a single SQL
statement."*

*
When you use SET GLOBAL sql_slave_skip_counter to skip events and the result
is in the middle of a group, the slave continues to skip events until it
reaches the end of the group. Execution then starts with the next event
group.

**set global sql_slave_skip_counter=N;
*mean following:
*Skip N event from "event group", except situation, when skip N events from
"event group" doesn't reach end of group.
*
*
*"Event group" definition depends from binary log format.
What the replication binlog format?

1) Statement based replication.
One "event group" == "single transaction" for transactional tables.
One "event group" == "single statement" from non-transactional tables.
2) Row based repliation
One "event group" == "single transaction" for transcational tables.
One "event group" == "single row event" for non-transactional tables.
*but note*: If you have same events on the line ("Update_rows_log_event",
"Update_rows_log_event"), then this events was merged to single.
3) Mixed based replication.
Depends from format of current event.

Best regards, Oleg.

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.

--20cf300fab91327aa904a5714324--