Moving to FOG 1.5.10

[Sebastian Roth]

@Kureebow I don’t think a running task can cause this issue! Let’s first check the disk is not full: df -h

Then check the DB status and log:

systemctl status mariadb.service
tail -n20 /var/log/mysql/*log*

[Kureebow]

@Sebastian-Roth
Filesystem Size Used Avail Use% Mounted on
devtmpfs 48G 0 48G 0% /dev
tmpfs 48G 0 48G 0% /dev/shm
tmpfs 48G 19M 48G 1% /run
tmpfs 48G 0 48G 0% /sys/fs/cgroup
/dev/mapper/centos-root 3.0T 491G 2.5T 17% /
/dev/sda2 1014M 239M 776M 24% /boot
/dev/mapper/centos-home 3.7T 579M 3.7T 1% /home
tmpfs 9.5G 100K 9.5G 1% /run/user/1000

mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2023-03-28 10:57:12 EDT; 16min ago
Process: 12321 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=1/FAILURE)
Main PID: 1989

Mar 28 10:57:11 localhost.localdomain systemd[1]: Starting MariaDB database s…
Mar 28 10:57:11 localhost.localdomain mariadb-prepare-db-dir[12321]: Socket f…
Mar 28 10:57:11 localhost.localdomain mariadb-prepare-db-dir[12321]: Is anoth…
Mar 28 10:57:11 localhost.localdomain systemd[1]: mariadb.service: control pr…
Mar 28 10:57:12 localhost.localdomain systemd[1]: Failed to start MariaDB dat…
Mar 28 10:57:12 localhost.localdomain systemd[1]: Unit mariadb.service entere…
Mar 28 10:57:12 localhost.localdomain systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

The second command returned the following

tail: cannot open ‘/var/log/mysql/log’ for reading: No such file

[Sebastian Roth]

@Kureebow You missed the * on the tail command. Well let’s check the log file exists first.

ls - al /var/log/mysql

Disk space is fine.

[Kureebow]

@Sebastian-Roth No such file or directory

[Sebastian Roth]

@Kureebow Try this:

ls -al  /var/lib/mysql/
ls -al /var/log/mysql*
ps ax | grep -i -e mysql -e maria

[Kureebow]

@Sebastian-Roth
root@localhost ~]# ls -al /var/lib/mysql/
total 28716
drwxr-xr-x. 5 mysql mysql 194 Mar 28 10:57 .
drwxr-xr-x. 61 root root 4096 Jun 3 2022 …
-rw-rw----. 1 mysql mysql 16384 Mar 28 10:57 aria_log.00000001
-rw-rw----. 1 mysql mysql 52 Mar 28 10:57 aria_log_control
drwx------. 2 mysql mysql 8192 Jun 3 2022 fog
-rw-rw----. 1 mysql mysql 18874368 Mar 28 10:57 ibdata1
-rw-rw----. 1 mysql mysql 5242880 Mar 28 10:57 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 Jun 3 2022 ib_logfile1
drwx------. 2 mysql mysql 4096 Jun 3 2022 mysql
drwx------. 2 mysql mysql 4096 Jun 3 2022 performance_schema
[root@localhost ~]#

root@localhost ~]# ls -al /var/log/mysql*
ls: cannot access /var/log/mysql*: No such file or directory
[root@localhost ~]#

root@localhost ~]# ps ax | grep -i -e mysql -e maria
13627 pts/1 S+ 0:00 grep --color=auto -i -e mysql -e maria
[root@localhost ~]#

[Sebastian Roth]

@Kureebow So there is no database running at the moment as seen from the last command, strange thing.

Try starting it: systemctl start mariadb.service

[Kureebow]

@Sebastian-Roth Didn’t get a return from that command but no error. I assume it worked.

root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]#

[Sebastian Roth]

@Kureebow Sounds good. Check with systemctl status mariadb.service again and then re-run the installer ( just the ./installfog.sh from within the right directory, no need to git clone again)

[Kureebow]

@Sebastian-Roth Perfect! We are working now. Now it is asking me to update database from ipaddress/fog/management Where do I go to do this or do I just press enter and move forward?

[Sebastian Roth]

@Kureebow Copy and paste the URL printed by the installer to your webbrowser. If it takes you to the known web UI straight away that means there are no schema updates to do. That’s OK. Then hit ENTER for the installer to finish.

[Kureebow]

@Sebastian-Roth We are up and going again. Thank you so much for your help I really appreciate it.