[MDEV-27263] Cluster bootstrap node shows duplicate wsrep allowlist IP warning messages on each restart. Created: 2021-12-15  Updated: 2022-08-02  Resolved: 2021-12-16

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.8
Fix Version/s: 10.8.0

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

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

 Description   

Cluster bootstrap node shows duplicate wsrep allowlist IPs entry warning messages while rewriting wsrep allowlist IPs to mysql.wsrep_allowlist table on each restart.

my.cnf

wsrep_allowlist="172.20.2.30,172.20.2.34,172.20.2.35"

Error log

2021-12-15  7:01:59 0 [Note] Server socket created on IP: '0.0.0.0'.
2021-12-15  7:01:59 0 [Warning] 'user' entry 'root@ax3-galera1' ignored in --skip-name-resolve mode.
2021-12-15  7:01:59 0 [Warning] 'proxies_priv' entry '@% root@ax3-galera1' ignored in --skip-name-resolve mode.
2021-12-15  7:01:59 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate key found when writing into mysql.wsrep_allowlist
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate entry (172.20.2.30) found in `wsrep_allowlist` list
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate key found when writing into mysql.wsrep_allowlist
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate entry (172.20.2.34) found in `wsrep_allowlist` list
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate key found when writing into mysql.wsrep_allowlist
2021-12-15  7:02:00 4 [Warning] WSREP: Duplicate entry (172.20.2.35) found in `wsrep_allowlist` list
2021-12-15  7:02:00 0 [Note] WSREP: Server initialized


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