[MDEV-27874] Cluster node is not updating mysql.wsrep_allowlist table on restart Created: 2022-02-17  Updated: 2022-02-21  Resolved: 2022-02-21

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Ramesh Sivaraman
Resolution: Not a Bug Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-27246 Implement a method to add IPs to allo... Closed

 Description   

Cluster node is not updating mysql.wsrep_allowlist table based on wsrep_allowlist variable in configuration file on restart

MariaDB [(none)]> select * from mysql.wsrep_allowlist;
+----------------+
| ip             |
+----------------+
| 192.168.100.10 |
| 192.168.100.20 |
| 192.168.100.30 |
+----------------+
3 rows in set (0.011 sec)
 
MariaDB [(none)]> show variables like 'wsrep_allowlist';
+-----------------+-------------------------------+
| Variable_name   | Value                         |
+-----------------+-------------------------------+
| wsrep_allowlist | 192.168.100.10,192.168.100.20 |
+-----------------+-------------------------------+
1 row in set (0.002 sec)
 
MariaDB [(none)]> \q
Bye
vagrant@node1:~$ grep wsrep_allowlist my.cnf 
wsrep_allowlist="192.168.100.10,192.168.100.20"
vagrant@node1:~$ 



 Comments   
Comment by Mario Karuza (Inactive) [ 2022-02-21 ]

Allowlist table will only be loaded from `wsrep_allowlist` if we try to bootstrap new cluster, so this is by design

Generated at Thu Feb 08 09:56:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.