Re: MariaDB: Galera wsrep provider is missing

[Thomas Klausner <wiz%NetBSD.org@localhost>]

On Fri, Jan 13, 2023 at 03:39:01PM +0000, xfalkenx%SDF.ORG@localhost wrote:
> It worked! Thank you!

Great!


> 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!

I've just imported the package.

> 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!).

I can't answer that, but I've filed a pull request for the NetBSD
changes:

https://github.com/codership/galera/pull/632

I hope they get integrated.

> Thank you again, Thomas, for your help.

You're welcome!
 Thomas


> 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