mariadb not starting

[oki_one]

Hi,
I install mariadb with ;

pacman -S mariadb

Just then start mysqld service with;

systemctl start mysqld

i got this;

Code: Select all

[root@alarmpi ~]# systemctl start mysqld
Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.
[root@alarmpi ~]#

systemctl status mysqld

Code: Select all

[root@alarmpi ~]# systemctl status mysqld
* mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
   Active: activating (start-post) (Result: exit-code) since Wed 2014-09-03 14:5             2:55 MDT; 43s ago
  Process: 32322 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (co             de=exited, status=1/FAILURE)
 Main PID: 32322 (code=exited, status=1/FAILURE);         : 32323 (mysqld-post)
   CGroup: /system.slice/mysqld.service
           `-control
             |- 1367 /bin/sh /usr/bin/mysqld-post
             |- 1368 /usr/bin/mysqladmin -uUNKNOWN_USER ping
             `-32323 /bin/sh /usr/bin/mysqld-post

Sep 03 14:52:55 alarmpi mysqld[32322]: InnoDB: mmap(135987200 bytes) failed...12
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] InnoDB: Cann...ol
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] Plugin 'Inno...r.
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] Plugin 'Inno...d.
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [Note] Plugin 'FEEDB...d.
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] Can't open t...t.
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] Unknown/unsu...DB
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [ERROR] Aborting
Sep 03 14:52:55 alarmpi systemd[1]: mysqld.service: main process exited, co...RE
Sep 03 14:52:55 alarmpi mysqld[32322]: 140903 14:52:55 [Note] /usr/bin/mysq...te
Hint: Some lines were ellipsized, use -l to show in full.

Do you have any idea what's going on?

[sdjf]

follow the instructions to add -l, your output was cut off without full information.

if the full output does not tell you, another approach is to install strace and use it to start mysqld and see what is going wrong using the output. strace shows all the system calls for the desired command.

I do not have mariadb or mysql on my Pi, but it looks like you should be reading the mysql man page to see what an exit code of 1 means. That will hopefully tell you a lot.

EDIT: why are you posting output from mysqldb when your subject is mariadb? Have you tried just running mariadb since that is what you installed?

[pepedog]

https://www.archlinux.org/news/mariadb- ... ositories/