Re: MariaDB: Galera wsrep provider is missing

[xfalkenx%SDF.ORG@localhost]

The provider is successfully loaded but it can not continue due to an 
invalid argument error.

It fails when the cluster is being bootstraped but also when adding the 
node to an existing cluster. The error is the same so I think it's before 
it attempts to connect to the other nodes. I checked the config file 
syntax to discard any typo there.

Note: the state file open error is because I remove it on every bootstrap. 
Anyway after dropping the error, this file remains empty.

Thank you for dedicating your time and knowledge!

XF



config:

[galera]
wsrep_on = on
wsrep_provider=/usr/pkg/lib/libgalera_smm.so
wsrep_cluster_address=gcomm://10.0.0.134,10.0.0.135,10.0.0.136
wsrep_cluster_name=gxdbc1
wsrep_node_address="10.0.0.134"
wsrep_node_name=gm11
wsrep_sst_method=rsync
wsrep_sst_auth=mmruser:pass


bootstrap log:

230112 17:53:11 mysqld_safe Starting mariadbd daemon with databases from 
/var/db/mariadb
2023-01-12 17:53:12 0 [Note] WSREP: Loading provider 
/usr/pkg/lib/libgalera_smm.so initial position: 
00000000-0000-0000-0000-000000000000:-1
2023-01-12 17:53:12 0 [Note] WSREP: wsrep_load(): loading provider library 
'/usr/pkg/lib/libgalera_smm.so'
2023-01-12 17:53:12 0 [Note] WSREP: wsrep_load(): Galera 4.13(r266dc9c613) 
by Codership Oy <info%codership.com@localhost> loaded successfully.
2023-01-12 17:53:12 0 [Note] WSREP: CRC-32C: using "slicing-by-8" 
algorithm.
2023-01-12 17:53:12 0 [Warning] WSREP: Could not open state file for 
reading: '/var/db/mariadb//grastate.dat'
2023-01-12 17:53:12 0 [Note] WSREP: Found saved state: 
00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2023-01-12 17:53:12 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 1
2023-01-12 17:53:12 0 [Note] WSREP: Skipped GCache ring buffer recovery: 
could not determine history UUID.
2023-01-12 17:53:12 0 [Note] WSREP: Passing config to GCS: base_dir = 
/var/db/mariadb/; base_host = 10.0.0.134; base_port = 4567; 
cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; 
evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = 
PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; 
evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; 
evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = 
PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; 
gcache.dir = /var/db/mariadb/; gcache.keep_pages_size = 0; gcache.mem_size 
= 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = 
yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; 
gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; 
gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle 
= 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit 
= 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; 
pc.announce_ti
2023-01-12 17:53:12 0 [Note] WSREP: Start replication
2023-01-12 17:53:12 0 [Note] WSREP: Connecting with bootstrap option: 1
2023-01-12 17:53:12 0 [Note] WSREP: Setting GCS initial position to 
00000000-0000-0000-0000-000000000000:-1
2023-01-12 17:53:12 0 [Note] WSREP: protonet asio version 0
2023-01-12 17:53:12 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-01-12 17:53:12 0 [Note] WSREP: backend: asio
2023-01-12 17:53:12 0 [ERROR] WSREP: failed to open gcomm backend 
connection: 22: Failed to set thread schedparams other:0: 22 (Invalid 
argument)
         at 
/usr/pkgsrc/wip/galera/work/galera-release_26.4.13/galerautils/src/gu_thread.cpp:thread_set_schedparam():105
2023-01-12 17:53:12 0 [ERROR] WSREP: 
/usr/pkgsrc/wip/galera/work/galera-release_26.4.13/gcs/src/gcs_core.cpp:gcs_core_open():220: 
Failed to open backend connection: -22 (Invalid argument)
2023-01-12 17:53:12 0 [ERROR] WSREP: 
/usr/pkgsrc/wip/galera/work/galera-release_26.4.13/gcs/src/gcs.cpp:gcs_open():1664: 
Failed to open channel 'dbcl2' at 
'gcomm://10.0.0.134,10.0.0.135,10.0.0.136': -22 (Invalid argument)
2023-01-12 17:53:12 0 [ERROR] WSREP: gcs connect failed: Invalid argument
2023-01-12 17:53:12 0 [ERROR] WSREP: 
wsrep::connect(gcomm://10.0.0.134,10.0.0.135,10.0.0.136) failed: 7
2023-01-12 17:53:12 0 [ERROR] Aborting






On Thu, 12 Jan 2023, Thomas Klausner wrote:

> Date: Thu, 12 Jan 2023 13:37:05 +0100
> From: Thomas Klausner <wiz%NetBSD.org@localhost>
> To: xfalkenx%SDF.ORG@localhost
> Cc: pkgsrc-users%netbsd.org@localhost
> Subject: Re: MariaDB: Galera wsrep provider is missing
>
> On Thu, Jan 12, 2023 at 08:35:01AM +0000, xfalkenx%SDF.ORG@localhost wrote:
> > 2023-01-12  8:22:06 0 [ERROR] WSREP: File preallocation failed: 45
> > (Operation not supported)
> >          at /usr/pkgsrc/wip/galera/work/galera-release_26.4.13/galerautils/src/gu_fdesc.cpp:prealloc():251
>
> I've added a patch for fixing this to wip/galera, please try again.
>
> Thanks,
> Thomas

xfalkenx%sdf.org@localhost
SDF Public Access UNIX System - https://sdf.org