[MXS-3027] Galera nodes are declared usable too soon Created: 2020-06-05  Updated: 2020-10-19  Resolved: 2020-10-19

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: 2.2.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Florin Andrei Assignee: markus makela
Resolution: Cannot Reproduce Votes: 0
Labels: need_feedback


 Description   

MaxScale 2.2.5, MariaDB 10.4.11. Everything runs in containers.

[X.Y.Z.K]
type=server
address=X.Y.Z.K
port=3306
protocol=MariaDBBackend

[Galera-Monitor]
type=monitor
module=galeramon
servers=${IP_LIST}
user=${MAXSCALE_USER}
passwd=${MAXSCALE_PASSWORD}
monitor_interval=2000

[Read-Write-Service]
type=service
router=readconnroute
servers=${LIST_OF_IPS}
user=${MAXSCALE_USER}
passwd=${MAXSCALE_PASSWORD}

MaxScale seems to handle well the situations where I restart DB nodes. I test it by running DROP TABLE ...; CREATE TABLE ...; INSERT INTO ...; in a loop, and then I run SELECT * FROM ... with another client, also in a loop. The DB node is restarted, it comes back up, it rejoins the cluster. All fine so far.

But for a brief while, I get these errors:

ERROR 1047 (08S01) at line 1: WSREP has not yet prepared node for application use

It would be beneficial if MaxScale could make sure that WSREP is ready for use before marking it as a valid node.



 Comments   
Comment by markus makela [ 2020-07-03 ]

Does this still happen with the latest 2.4 release?

Comment by Florin Andrei [ 2020-07-03 ]

I haven't tried 2.4 yet. If I do, I'll let you know. Thank you!

Florin Andrei
http://florin.myip.org/

On Thu, Jul 2, 2020 at 10:33 PM markus makela (Jira) <jira@mariadb.org>

Comment by markus makela [ 2020-08-31 ]

Florin Andrei any updates?

Comment by markus makela [ 2020-10-19 ]

If you can reproduce this with the latest MaxScale releases, please let us know. 2.2 is EOL now.

Generated at Thu Feb 08 04:18:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.