[Solved] MySQL service not starting – Job for mariadb.service failed because the control process exited with error code. journalctl -xe

Issue / Error:-

[[email protected] ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

MySQL error logs:-

[[email protected] ~]# cat /var/lib/mysql/server.the-d2.com.err
2019-10-20 10:12:56 1220654356911872 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-20 10:12:56 1220656458905792 [Note] InnoDB: Highest supported file format is Barracuda.
2019-10-20 10:12:56 1220656458905792 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-20 10:12:56 1220656458905792 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-20 10:12:56 1220656458905792 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2019-10-20 10:12:56 1220656458905792 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
2019-10-20 10:12:56 1220656458905792 [ERROR] InnoDB: Could not set the file size of ‘./ibtmp1’. Probably out of disk space
2019-10-20 10:12:56 1220656458905792 [ERROR] InnoDB: Unable to create the shared innodb_temporary
2019-10-20 10:12:56 1220656458905792 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-10-20 10:13:01 1220656458905792 [Note] InnoDB: Starting shutdown…
2019-10-20 10:13:01 1220656458905792 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2019-10-20 10:13:01 1220656458905792 [ERROR] Plugin ‘InnoDB’ init function returned error.
2019-10-20 10:13:01 1220656458905792 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2019-10-20 10:13:01 1220656458905792 [Note] Plugin ‘FEEDBACK’ is disabled.
2019-10-20 10:13:01 1220656458905792 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-10-20 10:13:01 1220656458905792 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-20 10:13:01 1220656458905792 [ERROR] Aborting

Solution:-

Disk was full, deleted some data and mysql service started without any issue.

[[email protected] ~]# df -h
Filesystem – Size – Used – Avail – Use% Mounted on
devtmpfs – – 3.9G – 0 – 3.9G – 0% /dev
tmpfs – 3.9G – 0 – 3.9G – 0% /sys/fs/cgroup
/dev/xvda1 – 99G – 99G – 78M – 100% /
tmpfs – 783M – 0 – 783M – 0% /run/user/1000

[[email protected] ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
[[email protected] ~]#

 

Get BaseURLs from Database via CLI – Magento

Login to MySQL root or limited user, then use the database:-

use the-d2.com_db;

MariaDB > select * from core_config_data where path like '%base%url%';
+-----------+---------+----------+-----------------------------+------------------------------------------+
| config_id | scope | scope_id | path | value |
+-----------+---------+----------+-----------------------------+------------------------------------------+
| 52 | default | 0 | web/unsecure/base_url | https://www.the-d2.com/ |
| 53 | default | 0 | web/unsecure/base_link_url | {{unsecure_base_url}} |
| 54 | default | 0 | web/unsecure/base_skin_url | {{unsecure_base_url}}skin/ |
| 55 | default | 0 | web/unsecure/base_media_url | {{unsecure_base_url}}media/ |
| 56 | default | 0 | web/unsecure/base_js_url | {{unsecure_base_url}}js/ |
| 57 | default | 0 | web/secure/base_url | https://www.the-d2.com/ |
| 58 | default | 0 | web/secure/base_link_url | {{secure_base_url}} |
| 59 | default | 0 | web/secure/base_skin_url | https://the-d2.com/the-d2image/skin/ |
| 60 | default | 0 | web/secure/base_media_url | https://the-d2.com/the-d2image/media/ |
| 61 | default | 0 | web/secure/base_js_url | https://the-d2.com/the-d2image/js/ |
| 855 | default | 0 | system/mgt_base/feed_url | https://www.the-d2.com/feed |
+-----------+---------+----------+-----------------------------+------------------------------------------+
11 rows in set (0.00 sec)