LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Slackware (https://www.linuxquestions.org/questions/slackware-14/)
-   -   running mariadb on current (https://www.linuxquestions.org/questions/slackware-14/running-mariadb-on-current-4175693369/)

Tshane 04-08-2021 09:47 PM

running mariadb on current
 
Hey y'all

Is anyone running the latest up to date -current, running in an active way mariadb, successfully?

I've read other threads and googled which is reported it fails, and strangely Pat has never addressed those folk about it, and google shows on mariadb bug tracker mariadb devs pointing finger at slackware being at fault, and well I see the changelog says maybe close to beta - although I'm sure we saw that a year or two ago as well, but anyways, I'm gonna make the plunge this weekend, but first I'm hoping to see people are successfully running it in production, unlike some I dont have 50 servers to play with, I have one, its personal and business mail/web/blog/forums all in one, so you see I cant afford to have it all drop dead on me for 12 hours whilst I reinstall an rsync backup on 14.0 (yeh yeh, my bad for running oldie verz)

anyways, hope you guys can give me some good news or pointers that Pat is trying to fix why it dont work?

Oh please please please dont comment it works, if you do not as I said earlier, run it doing real stuff 24/7 yourself, third party hear say is no good to me, or anyone.

TIA

RadicalDreamer 04-08-2021 10:17 PM

This what you are referring to https://jira.mariadb.org/browse/MDEV...Y%20due%20DESC ?

MDEV-24922 and MDEV-24745 are this year.

bassmadrigal 04-08-2021 10:38 PM

Why don't you try it in a VM before installing it on bare hardware. That will allow you to see for yourself whether mariadb is working properly or not without sacrificing the reliability of your system.

bw42 04-08-2021 10:39 PM

So, it appears you are wanting to know if an issue is fixed, without saying what the actual issue is.
Some info on the specific issue you are asking about would be helpful.


It also sounds like you are planning on doing a major upgrade from a 9 year old distro to a current development branch.
I really recommend you don't upgrade to -current for a production system, especially not an in place upgrade from such an old distro.
I would highly recommend setting up a test system first, and waiting until the stable 15.0 release comes out before attempting your plans.

walecha 04-08-2021 11:35 PM

What is the problem? Yes I am using glibc multilib from AlienBOB, but again, what is the problem?

- mariadb-10.5.9-x86_64-1
- glibc-2.33_multilib-x86_64-2alien

Code:

210409 11:31:55 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
2021-04-09 11:31:55 0 [Note] /usr/libexec/mariadbd (mysqld 10.5.9-MariaDB) starting as process 13905 ...
2021-04-09 11:31:55 0 [ERROR] mariadbd: Can't open shared library '/usr/lib64/mysql/plugin/ha_tokudb.so' (errno: 22, cannot open shared object file: No such file or directory)
2021-04-09 11:31:55 0 [ERROR] Couldn't load plugins from 'ha_tokudb.so'.
2021-04-09 11:31:55 0 [Note] InnoDB: Uses event mutexes
2021-04-09 11:31:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-09 11:31:55 0 [Note] InnoDB: Number of pools: 1
2021-04-09 11:31:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-04-09 11:31:55 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-04-09 11:31:55 0 [Note] InnoDB: Using Linux native AIO
2021-04-09 11:31:55 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2021-04-09 11:31:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-09 11:31:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-04-09 11:31:55 0 [Note] InnoDB: 128 rollback segments are active.
2021-04-09 11:31:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-09 11:31:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-09 11:31:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-04-09 11:31:55 0 [Note] InnoDB: 10.5.9 started; log sequence number 155762558; transaction id 10267
2021-04-09 11:31:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-04-09 11:31:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-09 11:31:55 0 [Note] Reading of all Master_info entries succeeded
2021-04-09 11:31:55 0 [Note] Added new Master_info '' to hash table
2021-04-09 11:31:55 0 [Note] /usr/libexec/mariadbd: ready for connections.
Version: '10.5.9-MariaDB'  socket: '/var/run/mysql/mysql.sock'  port: 0  MariaDB Server
2021-04-09 11:31:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210409 11:31:55


Nobby6 04-09-2021 01:16 AM

Quote:

Originally Posted by RadicalDreamer (Post 6238813)
This what you are referring to https://jira.mariadb.org/browse/MDEV...Y%20due%20DESC ?

MDEV-24922 and MDEV-24745 are this year.


As one of the two jira reporters, I can confirm the issue is not resolved, as the responses in Charlie's ticket eludes to, it appears limited in failure to those using Pentium CPU's, in particular older CPU's, or at least that's all we know about at this time.

I can't recall if I made comment on it on here or not, but others have and have pretty much been ignored, so I might have not for also fear of being labelled a troll like Pat did one already.

In the dev world this results in " I got no clue it only affect X people I can count on one hand so I will pretend I dont see it " in years gone by with projects I was involved in, I too am guilty of such offences :P

Nobby6 04-09-2021 01:17 AM

Quote:

Originally Posted by bw42 (Post 6238819)
So, it appears you are wanting to know if an issue is fixed, without saying what the actual issue is.
Some info on the specific issue you are asking about would be helpful.


It also sounds like you are planning on doing a major upgrade from a 9 year old distro to a current development branch.
I really recommend you don't upgrade to -current for a production system, especially not an in place upgrade from such an old distro.
I would highly recommend setting up a test system first, and waiting until the stable 15.0 release comes out before attempting your plans.


looking to increase your post count?

I read that as he was wanting replies from anyone successfully running it, that pretty much leaves a yes or no response, replies like yours are not what OP was asking for.

Petri Kaukasoina 04-09-2021 01:58 AM

Quote:

Originally Posted by RadicalDreamer (Post 6238813)

In the last comment by Marko Mäkelä for MDEV-24745, he offers to debug it if someone with the problem gives him a remote access.

RadicalDreamer 04-09-2021 02:08 AM

Quote:

Originally Posted by Nobby6 (Post 6238858)
As one of the two jira reporters, I can confirm the issue is not resolved, as the responses in Charlie's ticket eludes to, it appears limited in failure to those using Pentium CPU's, in particular older CPU's, or at least that's all we know about at this time.

I can't recall if I made comment on it on here or not, but others have and have pretty much been ignored, so I might have not for also fear of being labelled a troll like Pat did one already.

In the dev world this results in " I got no clue it only affect X people I can count on one hand so I will pretend I dont see it " in years gone by with projects I was involved in, I too am guilty of such offences :P

Pat checks the forum so he probably saw problems people have but that doesn't mean he can do anything about them. The only people I've seen Pat have issues with are those that deserved it because of their bad attitude. No one wants to listen to a spoiled entitled brat that is spamming threads. People need to start a thread about their issues and share the information they have on it. If someone comes up with a solution, Pat may incorporate it into Slackware. He may even downgrade a particular piece of software if it can be shown that it is more stable.

ponce 04-09-2021 02:13 AM

Quote:

Originally Posted by Tshane (Post 6238809)
Hey y'all

Is anyone running the latest up to date -current, running in an active way mariadb, successfully?

[...]

Oh please please please dont comment it works, if you do not as I said earlier, run it doing real stuff 24/7 yourself, third party hear say is no good to me, or anyone.

I do, I run always the latest version of it on current in production on multiple hosts serving a lot of different stuff since four years with no hiccups.

Quote:

Originally Posted by Nobby6 (Post 6238858)
As one of the two jira reporters, I can confirm the issue is not resolved, as the responses in Charlie's ticket eludes to, it appears limited in failure to those using Pentium CPU's, in particular older CPU's, or at least that's all we know about at this time.

if this is something CPU-specific personally I cannot see anywhere else than upstream to fix this: the build options that Slackware uses doesn't seem to involve any particular optimization.
In the other report a developer explained that if you don't debug it in the same environment with a build with debug symbols on it's nearly impossible to understand what's happening, so it's no use to blame X or Y.

EDIT: Petri has been faster!

bw42 04-09-2021 02:24 AM

Quote:

Originally Posted by Nobby6 (Post 6238859)
looking to increase your post count?

I read that as he was wanting replies from anyone successfully running it, that pretty much leaves a yes or no response, replies like yours are not what OP was asking for.

He said multiple things about an issue without specifying what issue he was talking about.
And said he was going to upgrade his server from 14.0 to -current, which I recommended against doing.

Tshane 04-09-2021 09:18 PM

Quote:

Originally Posted by ponce (Post 6238867)
I do, I run always the latest version of it on current in production on multiple hosts serving a lot of different stuff since four years with no hiccups.



great, thank you ponce, sounds like their problem wont be mine, I'll be do a full backup of os and databases are backed up hourly anyway.

I'll take the plunge sunday

Tshane 04-09-2021 09:21 PM

Quote:

Originally Posted by bw42 (Post 6238871)
He said multiple things about an issue without specifying what issue he was talking about.
And said he was going to upgrade his server from 14.0 to -current, which I recommended against doing.

my question was as clear as crystal as ponce deduced by replying with yes it works, not 500 questions, nobby6 was right you're just trolling my thread, now go away

Tshane 04-09-2021 09:28 PM

Quote:

Originally Posted by bassmadrigal (Post 6238818)
Why don't you try it in a VM before installing it on bare hardware. That will allow you to see for yourself whether mariadb is working properly or not without sacrificing the reliability of your system.

another one who did not read my post

this is my first time posting on lq but I have been a long time reader, so I should have expected usual suspects to troll

Tshane 04-09-2021 09:33 PM

Quote:

Originally Posted by Nobby6 (Post 6238859)
looking to increase your post count?

I read that as he was wanting replies from anyone successfully running it, that pretty much leaves a yes or no response, replies like yours are not what OP was asking for.

like most the regular posters here they just cant help themselves, they are incapable of reading properly, nor answering with what a OP was asking. they call that trolling.

maybe its my fault, maybe rather than say "dont reply it works unless you actually running it full time" to dont reply unless your actually running it and it works" /me sighs


All times are GMT -5. The time now is 03:49 PM.