Unknown system variable sql_slave_statement_skip_counter

[Adam Wróbel]

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+-----------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------+
| innodb_version | 1.1.8-20.1 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.16-55-log |
| version_comment | Percona Server (GPL), Release rel22.0, Revision 189 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+-----------------------------------------------------+
7 rows in set (0.00 sec)

mysql> set global sql_slave_statement_skip_counter=1;
ERROR 1193 (HY000): Unknown system variable 'sql_slave_statement_skip_counter'

http://www.percona.com/doc/percona-server/5.5/flexibility/replication_skip_single_statement.html?id=percona-server:features:replication_skip_single_statement&redirect=1#sql_slave_statement_skip_counter

This variable doesn't work?

I have enable:
server-id=2
relay-log=mysqld-relay-bin
plugin-load=rpl_semi_sync_master=semisync_master.so
plugin-load=rpl_semi_sync_slave=semisync_slave.so
rpl_semi_sync_master_enabled=1
rpl_semi_sync_slave_enabled=1
binlog_format=row

log-bin = /var/mysql/mysql_binlog/bin.log
log-slave-updates
log-bin-index = /var/mysql/mysql_binlog/log-bin.index

[Oleg Tsarev (tsarev)]

This is a variable from separated source-tree. We looks for posibility to include this patch to main Percona tree.

[Adam Wróbel (shark)]

when this will be available in the 5.5 series? This feature is critical for replication.

[Oleg Tsarev (tsarev)]

This is really dangerous feature with really rarely usage.
Can you please describe the use-case where you REALLY requires this?
May be I omited some usefull scenarios, but from my point of view this
feature not very usefull and better to include another or RBR features
(and so spend time to it instead of this feature).

On Wed, Nov 2, 2011 at 9:25 AM, Adam Wróbel <email address hidden> wrote:
> when this will be available in the 5.5 series? This  feature is critical
> for replication.
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https://bugs.launchpad.net/bugs/882988
>
> Title:
>  Unknown system variable sql_slave_statement_skip_counter
>
> Status in Percona Server with XtraDB:
>  New
>
> Bug description:
>  mysql> SHOW VARIABLES LIKE "%version%";
>  +-------------------------+-----------------------------------------------------+
>  | Variable_name           | Value                                               |
>  +-------------------------+-----------------------------------------------------+
>  | innodb_version          | 1.1.8-20.1                                          |
>  | protocol_version        | 10                                                  |
>  | slave_type_conversions  |                                                     |
>  | version                 | 5.5.16-55-log                                       |
>  | version_comment         | Percona Server (GPL), Release rel22.0, Revision 189 |
>  | version_compile_machine | x86_64                                              |
>  | version_compile_os      | Linux                                               |
>  +-------------------------+-----------------------------------------------------+
>  7 rows in set (0.00 sec)
>
>
>  mysql> set global sql_slave_statement_skip_counter=1;
>  ERROR 1193 (HY000): Unknown system variable 'sql_slave_statement_skip_counter'
>
>  http://www.percona.com/doc/percona-
>  server/5.5/flexibility/replication_skip_single_statement.html?id
>  =percona-
>  server:features:replication_skip_single_statement&redirect=1#sql_slave_statement_skip_counter
>
>  This variable doesn't work?
>
>  I have enable:
>  server-id=2
>  relay-log=mysqld-relay-bin
>  plugin-load=rpl_semi_sync_master=semisync_master.so
>  plugin-load=rpl_semi_sync_slave=semisync_slave.so
>  rpl_semi_sync_master_enabled=1
>  rpl_semi_sync_slave_enabled=1
>  binlog_format=row
>
>  log-bin = /var/mysql/mysql_binlog/bin.log
>  log-slave-updates
>  log-bin-index = /var/mysql/mysql_binlog/log-bin.index
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/882988/+subscriptions
>

--
Oleg Tsarev, Software Engineer, Percona Inc.

[Alexey Kopytov (akopytov)]

See also bug #848078. We can keep this bug open as a request to port replication_skip_single_statement.patch from rnt-5.1 to 5.5.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2364