The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql error

Discussion in 'Database Discussions' started by mojamoi, Jan 13, 2014.

  1. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    Hi

    What is solution for thei mysql error?

    MySQL error in file: /engine/classes/mysqli.class.php at line 52
    Error Number: 1
    The Error returned was:
    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    SQL query:



    /etc/my.cnf has following values:
    Code:
    [mysqld]
    datadir=/var/lib/mysql
    local-infile=0
    safe-show-database
    query_cache_limit=128M
    query_cache_size=128M ## 32MB for every 1GB of RAM
    query_cache_type=1
    max_user_connections=2000
    max_connections=300
    #interactive_timeout=40
    interactive_timeout=15
    #wait_timeout=40
    wait_timeout=15
    #connect_timeout=40
    connect_timeout=10
    thread_cache_size=128
    key_buffer=256M ## 128MB for every 1GB of RAM
    join_buffer=1M
    max_connect_errors=20
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M ## 1MB for every 1GB of RAM
    read_buffer_size=2M ## 1MB for every 1GB of RAM
    read_rnd_buffer_size=2M  ## 1MB for every 1GB of RAM
    thread_concurrency=8 ## Number of CPUs x 2
    myisam_sort_buffer_size=64M
    server-id=1
    collation-server=latin1_general_ci
    skip-name-resolve
    log_slow_queries = 10
    slow_query_log_file = /var/log/mysql/slow_query_log
    open_files_limit=50000
    
    
    
    
    
    innodb_file_per_table=1
    innodb_thread_concurrency =0
    open_files_limit=4162
    user        = mysql
    skip-external-locking
    













    I get this error
    root@se [/var/lib/mysql]# service mysql status
    ERROR! MySQL is not running, but lock exists
    root@se [/var/lib/mysql]#
     
    #1 mojamoi, Jan 13, 2014
    Last edited: Jan 13, 2014
  2. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    I did yum remove mysql on teh server cpanel

    what can i do to reinstall it
     
  3. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    installed it by /scripts/upcp

    but still the first issue


     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,724
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please attempt to restart MySQL and let us know the error message you see in /var/lib/mysql/$hostname.err when the restart fails.

    Thank you.
     
  5. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    Restart of mysql never fails however it always gives the error above in running state

    It always starts

    However the status shows as not running at times

    - - - Updated - - -

    Here are log files from $hostname.err

    120923 13:05:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    120923 13:05:06 [Note] Plugin 'FEDERATED' is disabled.
    120923 13:05:07 InnoDB: Initializing buffer pool, size = 8.0M
    120923 13:05:07 InnoDB: Completed initialization of buffer pool
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    120923 13:05:07 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    120923 13:05:13 InnoDB: Started; log sequence number 5 2084801700
    120923 13:05:14 [Note] Event Scheduler: Loaded 0 events
    120923 13:05:14 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.63-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed
    120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed
    120923 13:05:43 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and last (automatic?) repair failed
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,724
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Check to make sure none of your partitions are full:

    Code:
    df -h
    df -i
    If not, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page