MariaDB Service will not start

This forum is for topics dealing with problems with software specifically in the ARMv7h repo.

MariaDB Service will not start

Postby Chrylag » Fri Sep 02, 2016 7:04 am

Hey,

I already posted this to the Arch Linux forums, but they weren't willing to help, so I hope I might get some advises here.

Hello,
I just installed the mariadb package just like it is explained in the wiki on my Banana Pi.
Before trying to launch the service, I used the
$this->bbcode_second_pass_code('', '
mysql_db_install')
command, like it is said on the wiki.
Now when I start the service (either mariadb.service or mysqld.service, it doesn't matter) I keep getting the following error:
$this->bbcode_second_pass_code('', '
# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.')
If I run systemctl status mariadb it says
$this->bbcode_second_pass_code('', '# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor pres
Active: failed (Result: exit-code) since Do 2016-09-01 22:47:36 UTC; 7s ago
Process: 1298 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS
Process: 1245 ExecStartPre=/bin/sh -c VAR=`/usr/bin/galera_recovery`; [ $? -eq
Process: 1243 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START
Main PID: 1298 (code=exited, status=227/NO_NEW_PRIVILEGES)
# journalctl -xe
No journal files were found.
-- No entries --
')
I already deleted the /var/lib/mysql folder, deleted only the logfiles in this folder, reinstalled mariadb, rerun the database installation script.
I am totally running out of ideas what might cause the problem and on the internet I found some similar problems but not the same.
The database is the thing I need the Banana Pi the most for hmm And I really don't want to move to Ubuntu / Raspbian / Bananian or so.
Any help is highly appreciated!
Chrylag
 
Posts: 1
Joined: Fri Sep 02, 2016 6:59 am

Re: MariaDB Service will not start

Postby WarheadsSE » Fri Sep 02, 2016 4:42 pm

We don't have any official support for that board.

What kernel are you using?
Core Developer
Remember: Arch Linux ARM is entirely community donation supported!
WarheadsSE
Developer
 
Posts: 6807
Joined: Mon Oct 18, 2010 2:12 pm

Re: MariaDB Service will not start

Postby karog » Sat Sep 03, 2016 4:55 pm

$this->bbcode_second_pass_quote('Chrylag', 'H')ey,

I already posted this to the Arch Linux forums, but they weren't willing to help, so I hope I might get some advises here.

Hello,
I just installed the mariadb package just like it is explained in the wiki on my Banana Pi.


Maybe that installation method is not appropriate for Arch Linux.

You should install it according to the Arch Linux Guide: MySQL

I would undo everything you have done and start with the above link.

I run MariaDB on my odroid_xu4. I run a slightly old version 10.0.21-3 while the most recent in pacman is 10.1.17-1.

There is no mariadb.service. This version uses mysqld.service whose contents are:

$this->bbcode_second_pass_code('', '[Unit]
Description=MariaDB database server
After=syslog.target

[Service]
User=mysql
Group=mysql

ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid --log-error=xu4.err
ExecStartPost=/usr/bin/mysqld-post

Restart=always
PrivateTmp=true

[Install]
WantedBy=multi-user.target
')

Looking at your status, one sees the ExecStart line differs from the mysqld.service above indicating you are not running the desired version.

Here is my systemctl status:

$this->bbcode_second_pass_code('', '● mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2016-06-07 17:53:56 EDT; 2 months 26 days ago
Main PID: 282 (mysqld)
CGroup: /system.slice/mysqld.service
└─282 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid --log-error=xu4.err

Jun 07 17:53:54 xu4 systemd[1]: Starting MariaDB database server...
Jun 07 17:53:54 xu4 mysqld[282]: 160607 17:53:54 [Note] /usr/bin/mysqld (mysqld 10.0.21-MariaDB) starting as process 282 ...
Jun 07 17:53:56 xu4 systemd[1]: Started MariaDB database server.
')

Note that both of the above refer to MariaDB.
karog
 
Posts: 305
Joined: Thu Jan 05, 2012 7:55 pm

Re: MariaDB Service will not start

Postby WarheadsSE » Tue Sep 06, 2016 2:33 pm

$this->bbcode_second_pass_quote('WarheadsSE', '
')What kernel are you using?
Core Developer
Remember: Arch Linux ARM is entirely community donation supported!
WarheadsSE
Developer
 
Posts: 6807
Joined: Mon Oct 18, 2010 2:12 pm


Return to ARMv7h

Who is online

Users browsing this forum: No registered users and 14 guests