LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 06-25-2020, 01:29 AM   #1
teoberi
Member
 
Registered: Jan 2018
Location: Romania
Distribution: Slackware64-current (servers) / Ubuntu (workstations)
Posts: 185

Rep: Reputation: 118Reputation: 118
MariaDB version 10.5.4 changes


I think we have a problem with the startup script for MariaDB.
https://mariadb.com/kb/en/mysqld_safe/
https://mariadb.com/kb/en/mysqlserver/
If I start with the rc.mysqld script I can no longer stop the service.
Code:
/etc/rc.d/rc.mysqld start
Quote:
200625 09:18:10 mysqld_safe Logging to '/var/lib/mysql/mail.err'.
200625 09:18:10 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
Code:
/etc/rc.d/rc.mysqld stop
Quote:
mysqld: no process found
WARNING: Gave up waiting for mysqld to exit!
If I use:
Code:
/usr/share/mysql/mysql.server start
Quote:
Starting MariaDB.200625 09:24:01 mysqld_safe Logging to '/var/lib/mysql/mail.err'.
200625 09:24:01 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
SUCCESS!
Code:
/usr/share/mysql/mysql.server stop
Quote:
Shutting down MariaDB.. SUCCESS!
Again about systemd!

And that's not all!
From the log:
Quote:
2020-06-25 9:37:39 0 [ERROR] mariadbd: Can't open shared library 'ha_s3.so' (errno: 1, Loading of alpha plugin S3 is prohibited by --plugin-maturity=gamma)
2020-06-25 9:37:39 0 [ERROR] Couldn't load plugins from 'ha_s3.so'.

Last edited by teoberi; 06-25-2020 at 02:08 AM.
 
Old 06-25-2020, 01:55 AM   #2
3rensho
Member
 
Registered: Mar 2008
Location: Switzerland
Distribution: Slackware64-current
Posts: 421

Rep: Reputation: 106Reputation: 106
Tried it and see the same thing that you report.
 
1 members found this post helpful.
Old 06-25-2020, 02:47 AM   #3
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 182

Rep: Reputation: 107Reputation: 107
I can confirm problem, but solution is easy.
Mariadb daemon has no longer name "mysqld" only "mariadbd". Change ~61 line in /etc/rc.d/rc.mysql from "killall mysqld" to "killall mariadbd", or apply this patch:
Code:
--- rc.mysqld<->2020-06-25 09:44:36.063446186 +0200
+++ rc.mysqld.new<----->2020-06-25 09:44:44.262445625 +0200
@@ -58,7 +58,7 @@
 mysqld_stop() {
   # If there is no PID file, ignore this request...
   if [ -r /var/run/mysql/mysql.pid ]; then
-    killall mysqld
+    killall mariadbd
     # Wait at least one minute for it to exit, as we don't know how big the DB is...
     for second in 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 \
       0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 60 ; do
 
2 members found this post helpful.
Old 06-25-2020, 03:19 AM   #4
teoberi
Member
 
Registered: Jan 2018
Location: Romania
Distribution: Slackware64-current (servers) / Ubuntu (workstations)
Posts: 185

Original Poster
Rep: Reputation: 118Reputation: 118
Quote:
Originally Posted by Labinnah View Post
I can confirm problem, but solution is easy.
Mariadb daemon has no longer name "mysqld" only "mariadbd". Change ~61 line in /etc/rc.d/rc.mysql from "killall mysqld" to "killall mariadbd", or apply this patch:
...
I do not agree with your solution, although it works.
Code:
/etc/rc.d/rc.mysqld --help
Quote:
usage /etc/rc.d/rc.mysqld start|stop|restart
Code:
/usr/share/mysql/mysql.server --help
Quote:
Usage: mysql.server {start|stop|restart|reload|force-reload|status|configtest|bootstrap} [ MariaDB server options ]
I think we should use the mysql.server script.

There is already a patch proposal to avoid terminating other mysql instances at:
https://www.linuxquestions.org/quest...ml#post6137742

I also recommend the following when migrating to a major version for MariaDB:
1. backup to databases;
2. uninstall previous version;
3. cleaning the remaining folders/files;
4. install the new version;
5. configuration
mysql_install_db --user = mysql
/usr/bin/mysql_secure_installation
6. test
mysql -u root -p

Last edited by teoberi; 06-25-2020 at 04:28 AM.
 
3 members found this post helpful.
Old 06-29-2020, 05:09 AM   #5
teoberi
Member
 
Registered: Jan 2018
Location: Romania
Distribution: Slackware64-current (servers) / Ubuntu (workstations)
Posts: 185

Original Poster
Rep: Reputation: 118Reputation: 118
And that's not all!
From the log:
Quote:
2020-06-25 9:37:39 0 [ERROR] mariadbd: Can't open shared library 'ha_s3.so' (errno: 1, Loading of alpha plugin S3 is prohibited by --plugin-maturity=gamma)
2020-06-25 9:37:39 0 [ERROR] Couldn't load plugins from 'ha_s3.so'.
The problem is known by developers.
https://github.com/MariaDB/server/pull/1611
 
1 members found this post helpful.
Old 06-29-2020, 05:22 AM   #6
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 182

Rep: Reputation: 107Reputation: 107
See https://mariadb.com/kb/en/using-the-s3-storage-engine/

Its probably good that it not load...

To get rid of it hash in "plugin-load-add=ha_s3" line /etc/my.cnf.d/s3.cnf
 
Old 06-29-2020, 05:39 AM   #7
teoberi
Member
 
Registered: Jan 2018
Location: Romania
Distribution: Slackware64-current (servers) / Ubuntu (workstations)
Posts: 185

Original Poster
Rep: Reputation: 118Reputation: 118
So MariaDB 10.5.4, comment on that line in /etc/my.cnf.d/s3.cnf and change the daemon name from "mysqld" to "mariadbd" in rc.mysqld?
Or maybe we stick to mariadb-10.4.13-x86_64-3 for now?
 
Old 06-29-2020, 05:46 AM   #8
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 182

Rep: Reputation: 107Reputation: 107
Quote:
Originally Posted by teoberi View Post
Or maybe we stick to mariadb-10.4.13-x86_64-3 for now?
Why?

Change daemon name is Slackware issue and error with not loading "alpha quality" plugin is IMHO harmless.
 
1 members found this post helpful.
Old 06-29-2020, 05:59 AM   #9
teoberi
Member
 
Registered: Jan 2018
Location: Romania
Distribution: Slackware64-current (servers) / Ubuntu (workstations)
Posts: 185

Original Poster
Rep: Reputation: 118Reputation: 118
Quote:
Originally Posted by Labinnah View Post
Why?

Change daemon name is Slackware issue and error with not loading "alpha quality" plugin is IMHO harmless.
This time I'm just asking, it's not up to me.
I installed the new version on the test server but not yet on the production one.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
LXer: Technology Changes Us, Changes Society, and Changes Governments LXer Syndicated Linux News 0 10-10-2016 02:00 PM
Intercept frequency changes and C states changes klub Linux - Kernel 1 03-25-2011 04:43 PM
Changes to /etc files revert changes after reboot yeahya Linux - General 2 11-22-2010 08:42 PM
alsamixer changes emu10k1 levels everytime xmms changes songs sulzla Linux - Software 0 06-29-2003 11:05 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 08:04 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration