• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

MySQL dies after a while

Scheduled Pinned Locked Moved Unsolved
Linux Problems
2
4
1.4k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • W
    Wayne Workman
    last edited by Wayne Workman Sep 23, 2016, 7:41 AM Sep 23, 2016, 1:40 PM

    Server
    • FOG Version: 1.3.0 working-RC-11 Version 54
    • OS: Fedora 24 Server x64
    Description

    MySQL/MariaDB dies after a while of inactivity. Restarting it brings it back. This is my home fog setup - it’s not under any kind of load at all. This has been happening to me only on working-RC-11. I’ve not been able to put a finger on what’s causing it other than simply time passing.

    [root@fog-server ~]# mysql -D fog
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
    [root@fog-server ~]# systemctl status mysql
    ● mariadb.service - MariaDB 10.1 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
       Active: inactive (dead)
    [root@fog-server ~]# systemctl status mariadb
    ● mariadb.service - MariaDB 10.1 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
       Active: inactive (dead)
    

    0_1474637945444_Invalid DB.png

    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
    Daily Clean Installation Results:
    https://fogtesting.fogproject.us/
    FOG Reporting:
    https://fog-external-reporting-results.fogproject.us/

    T 1 Reply Last reply Sep 23, 2016, 2:05 PM Reply Quote 0
    • T
      Tom Elliott @Wayne Workman
      last edited by Sep 23, 2016, 2:05 PM

      @Wayne-Workman can you update to latest? I’ve reintroduced the persistent connections. I think there may be some cleanup on systemd that’s checking for “stale” sockets. Using persistent connections might ensure the socket doesn’t appear stale, or I don’t know. Maybe some other os update introduced something we are unaware of.

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      1 Reply Last reply Reply Quote 0
      • W
        Wayne Workman
        last edited by Wayne Workman Sep 23, 2016, 8:06 AM Sep 23, 2016, 2:05 PM

        I setup a simple shell script to monitor mariaDB’s status:

        while true; do
        date >> /root/mariadb.log
        systemctl status mariadb >> /root/mariadb.log
        sleep 60
        done
        

        And started it with the no hangup command, and backgrounded the process:
        nohup ./monitorService.sh &

        So I’ll be able to give some sort of timeframe of when this happens. Maybe there will be a pattern.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
        Daily Clean Installation Results:
        https://fogtesting.fogproject.us/
        FOG Reporting:
        https://fog-external-reporting-results.fogproject.us/

        T 1 Reply Last reply Sep 23, 2016, 2:07 PM Reply Quote 0
        • T
          Tom Elliott @Wayne Workman
          last edited by Sep 23, 2016, 2:07 PM

          @Wayne-Workman you might want to use systemctl -l status mariadb as it will give more direct errors to what caused it to die to begin with.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 1
          • 1 / 1
          1 / 1
          • First post
            2/4
            Last post

          280

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project