Re: MariaDB: Galera wsrep provider is missing

[xfalkenx%SDF.ORG@localhost]

It worked! Thank you!


2023-01-13 15:29:43 2 [Note] WSREP: Server status change joined -> synced
2023-01-13 15:29:43 2 [Note] WSREP: Synchronized with group, ready for 
connections


Now let's populate it from wip to pkgsrc/databases!

Seriously, do you believe it's reasonable to implement a production level 
cluster with this package? I am willing to use NetBSD on this project but 
I'd like to know if it's too risky to depend on this implementation of 
Galera provider and not fall into an eventually bit-rot situation. (that's 
why I'd like to see it as an official pkgsrc package!).

Thank you again, Thomas, for your help.

Now I'm finishing the cluster setup, proper tuning and testing Percona 
with it.

X. F.



On Fri, 13 Jan 2023, Thomas Klausner wrote:

> Date: Fri, 13 Jan 2023 12:03:18 +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 06:06:55PM +0000, xfalkenx%SDF.ORG@localhost wrote:
> > 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
>
> I think this fails because it calls pthread_setschedparam with
> SCHED_OTHER and a priority != PRI_NONE, which is not supported on
> NetBSD since 2008 (and supposedly not on Linux either).
>
> I've added a patch to work around this, please try again.
>
> Thanks for testing, btw!
> Thomas

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