enterprise-support team mailing list archive

[Nilnandan Joshi <nilnandan.joshi@xxxxxxxxxxx>]

Confirmed with upstream version MySQL 5.6.19 too  and make sure semi-
sync plugin is properly installed. It seems a bug.


While running mysql_install_db, it fails to recognize rpl_semi_sync_slave_enabled option when semi sync plugin is already installed and we can able to set that variable from command line. 

mysql> show global variables like 'rpl_semi_sync_slave%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| rpl_semi_sync_slave_enabled     | OFF   |
| rpl_semi_sync_slave_trace_level | 32    |
+---------------------------------+-------+
2 rows in set (0.01 sec)

mysql> SET GLOBAL rpl_semi_sync_slave_enabled = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'rpl_semi_sync_slave%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| rpl_semi_sync_slave_enabled     | ON    |
| rpl_semi_sync_slave_trace_level | 32    |
+---------------------------------+-------+
2 rows in set (0.01 sec)

mysql>

How to repeat:

[root@centos65 nilnandan]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.19 MySQL Community Server (GPL)

...

mysql> 
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.01 sec)

mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
Query OK, 0 rows affected (0.01 sec)

mysql> show plugins;
+----------------------------+----------+--------------------+--------------------+---------+
| Name                       | Status   | Type               | Library            | License |
+----------------------------+----------+--------------------+--------------------+---------+
| binlog                     | ACTIVE   | STORAGE ENGINE     | NULL               | GPL     |

...
| partition                  | ACTIVE   | STORAGE ENGINE     | NULL               | GPL     |
| rpl_semi_sync_master       | ACTIVE   | REPLICATION        | semisync_master.so | GPL     |
| rpl_semi_sync_slave        | ACTIVE   | REPLICATION        | semisync_slave.so  | GPL     |
+----------------------------+----------+--------------------+--------------------+---------+
44 rows in set (0.01 sec)

[root@centos65 nilnandan]# mysql_install_db --no-defaults --rpl_semi_sync_slave_enabled=ON
Installing MySQL system tables...2014-06-11 15:26:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-11 15:26:52 2685 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-11 15:26:52 2685 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-11 15:26:52 2685 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-06-11 15:26:52 2685 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-11 15:26:52 2685 [Note] InnoDB: Using Linux native AIO
2014-06-11 15:26:52 2685 [Note] InnoDB: Not using CPU crc32 instructions
2014-06-11 15:26:52 2685 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-11 15:26:52 2685 [Note] InnoDB: Completed initialization of buffer pool
2014-06-11 15:26:52 2685 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-11 15:26:52 2685 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-11 15:26:52 2685 [Note] InnoDB: Waiting for purge to start
2014-06-11 15:26:52 2685 [Note] InnoDB: 5.6.19 started; log sequence number 1688649
2014-06-11 15:26:52 2685 [ERROR] /usr/sbin/mysqld: unknown variable 'rpl_semi_sync_slave_enabled=ON'
2014-06-11 15:26:52 2685 [ERROR] Aborting

2014-06-11 15:26:52 2685 [Note] Binlog end
2014-06-11 15:26:52 2685 [Note] InnoDB: FTS optimize thread exiting.
2014-06-11 15:26:52 2685 [Note] InnoDB: Starting shutdown...
2014-06-11 15:26:54 2685 [Note] InnoDB: Shutdown completed; log sequence number 1688659
2014-06-11 15:26:54 2685 [Note] /usr/sbin/mysqld: Shutdown complete

[root@centos65 nilnandan]#


** Changed in: percona-server/5.6
       Status: Incomplete => Confirmed

** Bug watch added: MySQL Bug System #72955
   http://bugs.mysql.com/bug.php?id=72955

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=72955
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1298361

Title:
  mysql_install_db fails to recognize some options

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1298361/+subscriptions