MySQL Error Linux Debian menu

User Tag List

Results 1 to 5 of 5
  1. #1
    Peronomejodan's Avatar Member
    Reputation
    1
    Join Date
    Aug 2016
    Posts
    4
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Error Linux Debian

    I had a bug with the mysql service on my dedicated with Linux Debian 8.7.

    The error started in the morning when it was not connected using SQLyog to the database.
    After that I tried to start the service from the console but it gives me the following error:

    - MySQL works perfectly for 4 days since its installation.

    uSrOx9Ta.jpg

    9PBZjbgV.jpg

    NEyvysXe.jpg

    8rmJMJ1c.jpg

    I also have a vps in which MySQL works normally for almost 2 months.

    PLSS!! Help me to solve the problem, I really appreciate that

    MySQL Error Linux Debian
  2. #2
    stoneharry's Avatar Moderator Harry

    Authenticator enabled
    Reputation
    1613
    Join Date
    Sep 2007
    Posts
    4,554
    Thanks G/R
    150/146
    Trade Feedback
    0 (0%)
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Code:
    The /var/lib/mysql/aria_log_control file is open by another process and consequently, mysqld fails to start.
    
    Check who/what is currently has the file open with:
    
    
    Code:
    lsof `/var/lib/mysql/aria_log_control`
    It should list the process(es) that has it open.
    Code:
    COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF   NODE NAME
    mysqld  1506 mysql   10uW  REG  253,1       52 263948 /var/lib/mysql/aria_log_control
    If the process definitely shouldn't be running, then shut it down with:
    Code:
    sudo kill -SIGTERM <PID>
    If that fails:
    Code:
    sudo kill -SIGKILL <PID>
    Or reboot.
    This and other suggestions here: opensuse - Can&#39;t start mysql service - Unix & Linux Stack Exchange

  3. Thanks Peronomejodan (1 members gave Thanks to stoneharry for this useful post)
  4. #3
    Peronomejodan's Avatar Member
    Reputation
    1
    Join Date
    Aug 2016
    Posts
    4
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This not work for me

  5. #4
    Peronomejodan's Avatar Member
    Reputation
    1
    Join Date
    Aug 2016
    Posts
    4
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Help me pls i don't know how to solve this problem

  6. #5
    Mimmil's Avatar Member
    Reputation
    7
    Join Date
    Feb 2017
    Posts
    3
    Thanks G/R
    2/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Peronomejodan View Post
    Help me pls i don't know how to solve this problem
    Can you try running the following command;

    Code:
    mysqld_safe --log-error=/var/log/mysql.err

    If the system cannot find mysqld_safe try prepending with /usr/bin/.

    Copy-paste the results of /var/log/mysql.err to this thread so that we can see the problem.

  7. Thanks stoneharry (1 members gave Thanks to Mimmil for this useful post)

Similar Threads

  1. [Trinity] Trinity Maps error (Linux) (Debian 6.0)
    By Oversizecrazyl in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 02-24-2013, 02:43 AM
  2. Ascent/LogOnServer/MySQL - Error message - Need help!
    By Habakka in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 02-21-2008, 12:56 PM
  3. Need Help, MySQL Error
    By Maree in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 01-27-2008, 06:45 PM
  4. Replies: 2
    Last Post: 11-14-2007, 08:20 PM
  5. Mysql error & Phpmyadmin
    By msnad9833 in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 10-02-2007, 08:17 PM
All times are GMT -5. The time now is 07:59 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search