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=1
>
>
--
Oleg Tsarev, Software Engineer, Percona Inc.
