Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13326

After several different attempts, MariaDB remains unwilling to start.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.2.7
    • N/A
    • Server
    • Linux Mint 19.2 "Soja" "multitool"VM and appliance (Alfresco, Request Tracker, SuiteCRM, etc.) running under VirtualBox on a Macintosh host.

    Description

      The question I posted on StackOverflow reads as below; my inability to start the MariaDB server (and have it be live a second later) appears to be a bug. I am attempting to quietly run the MariaDB server as a service.

      My apologies for a spotchy paste; I don't know how to avoid BLOB labels etc.

      For a particular project I wanted to have Mint (Sonja) appliance with all MariaDB and only MariaDB doing MySQL's work, without a hint of MySQL so I know I'm working with MariaDB.

      The appliance is one where I've installed multiple open source projects that power their own website (Alfresco, Request Tracker, SuiteCRM, etc.), and all of them seem to have worked either with MariaDB, or just used Postgres without interesting difficulty, and up until I tried to create a new MariaDB database to add a clone of a specific Wordpress site, MariaDB worked predictably well with no headaches on the same system. Until now, where I can't seem to find a pulse.

      The MariaDB troubleshooting page confirmed what I'd found in my investigations (in particular, a ps wwaux | grep mysql only turned up the grep process). The basic problem as I'd encountered it was when I tried to log in to create a database:

      monk@toolchest ~ $ mysql -uroot -p
      Enter password: 
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
      '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
      

      I've never gotten involved with MySQL's or MariaDB's /etc configuration files, but I looked briefly. They appeared sane to my uneducated eye.

      Neither an aptitude reinstall mariadb-server nor a service mysql start produce any changes so far as I could tell.

      For service mysql start, I got:

      # service mysql start
      Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
      The details for systemctl status mysql.service were:
       
      ● mysql.service - LSB: Start and stop the mysql database server daemon
         Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
         Active: failed (Result: exit-code) since Fri 2017-07-14 18:16:38 EEST; 1min 11s ago
           Docs: man:systemd-sysv-generator(8)
        Process: 5011 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
       
      Jul 14 18:16:38 toolchest /etc/init.d/mysql[5479]: 0 processes alive and '/usr/bin/mysql
      Jul 14 18:16:38 toolchest /etc/init.d/mysql[5479]: [61B blob data]
      Jul 14 18:16:38 toolchest /etc/init.d/mysql[5479]: error: 'Can't connect to local MySQL 
      Jul 14 18:16:38 toolchest /etc/init.d/mysql[5479]: Check that mysqld is running and that
      Jul 14 18:16:38 toolchest /etc/init.d/mysql[5479]: 
      Jul 14 18:16:38 toolchest mysql[5011]:    ...fail!
      Jul 14 18:16:38 toolchest systemd[1]: mysql.service: Control process exited, code=exited
      Jul 14 18:16:38 toolchest systemd[1]: Failed to start LSB: Start and stop the mysql data
      Jul 14 18:16:38 toolchest systemd[1]: mysql.service: Unit entered failed state.
      Jul 14 18:16:38 toolchest systemd[1]: mysql.service: Failed with result 'exit-code'.
      

      The recent (i.e. non-cronned) content of journalctl -xe ran:

      -- Defined-By: systemd
      -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
      -- 
      -- Unit mysql.service has failed.
      -- 
      -- The result is failed.
      Jul 14 18:16:38 toolchest systemd[1]: mysql.service: Unit entered failed state.
      Jul 14 18:16:38 toolchest systemd[1]: mysql.service: Failed with result 'exit-code'.
      

      /etc/mysql/mariadb.cnf and /etc/mysql/my.cnf both read (comments stripped):

      [client-server]
      !includedir /etc/mysql/conf.d/
      !includedir /etc/mysql/mariadb.conf.d/
      

      /etc/mysql/my.cnf.fallback dropps the latter !includedir. Commenting out the latter /etc/mysql/my.cnf to match the fallback file produced identical results.

      I can edit my question to include more of /etc/mysql/*, but I wanted to ask. Error messages similar to the ERROR 2002 are to be found in questions like Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38), but these appear to be MySQL rather than MariaDB, and I suspect this may be a MariaDB-specific fluke.

      Attachments

        Activity

          People

            Unassigned Unassigned
            CJSHayward C.J.S. Hayward
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.