Bug #20413 sql_slave_skip_counter is not shown in show variables
| Submitted: | 13 Jun 2006 6:31 | Modified: | 8 Mar 2010 1:43 |
|---|---|---|---|
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.0.23-BK, 5.0.22 | OS: | Any (any) |
| Assigned to: | CPU Architecture: | Any |
[13 Jun 2006 6:31]
Oli Sennhauser
[13 Jun 2006 9:49]
Valeriy Kravchuk
Thank you for a problem report. Verified just as described with 5.0.23-BK on Linux: openxs@suse:~/dbs/5.0> bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.23 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like '%slave%'; +---------------------------+-------+ | Variable_name | Value | +---------------------------+-------+ | init_slave | | | log_slave_updates | OFF | | slave_compressed_protocol | OFF | | slave_load_tmpdir | /tmp/ | | slave_net_timeout | 3600 | | slave_skip_errors | OFF | | slave_transaction_retries | 10 | +---------------------------+-------+ 7 rows in set (0.01 sec) mysql> show variables like 'sql%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | sql_big_selects | ON | | sql_mode | | | sql_notes | ON | | sql_warnings | OFF | +-----------------+-------+ 4 rows in set (0.00 sec)
[4 Jun 2008 21:14]
Sveta Smirnova
Now it is shown, but reflects no value. See bug #37187 also.
[30 Sep 2009 18:04]
Sergei Golubchik
note that it is shown in SHOW VARIABLES and INFORMATION_SCHEMA.GLOBAL_VARIABLES but it cannot be read as @@global.sql_slave_skip_counter, which is inconsistent
[6 Mar 2010 11:03]
Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@fedora12-20091225154921-x25a5pyw1pxiwobv) (merge vers: 5.5.99) (pib:16)
[8 Mar 2010 1:43]
Paul DuBois
Noted in 5.5.3 changelog. The value of sql_slave_skip_counter was empty when displayed by SHOW VARIABLES or INFORMATION_SCHEMA.GLOBAL_VARIABLES.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.