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 Does Not Start

Discussion in 'Database Discussions' started by jca2, Sep 17, 2014.

  1. jca2

    jca2 Member

    Joined:
    Sep 17, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    MySQL does not start, I get the following error message:

    Code:
    Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/site.mcstartup.net.pid).
    This is the output in the .err file in /var/lib/mysql

    Code:
    140917 14:08:41 mysqld_safe mysqld from pid file /var/lib/mysql/site.mcstartup.net.pid ended
    140917 14:24:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2014-09-17 14:24:46 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2014-09-17 14:24:46 0 [Warning] Using unique option prefix join_buffer instead of join_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2014-09-17 14:24:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2014-09-17 14:24:46 16128 [Note] Plugin 'FEDERATED' is disabled.
    2014-09-17 14:24:46 16128 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2014-09-17 14:24:46 16128 [Note] InnoDB: The InnoDB memory heap is disabled
    2014-09-17 14:24:46 16128 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2014-09-17 14:24:46 16128 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2014-09-17 14:24:46 16128 [Note] InnoDB: Using Linux native AIO
    2014-09-17 14:24:46 16128 [Note] InnoDB: Using CPU crc32 instructions
    /usr/sbin/mysqld: Can't create/write to file '/tmp/ibMJAjsh' (Errcode: 28 - No space left on device)
    2014-09-17 14:24:46 7f226fb9b720  InnoDB: Error: unable to create temporary file; errno: 28
    2014-09-17 14:24:46 16128 [ERROR] Plugin 'InnoDB' init function returned error.
    2014-09-17 14:24:46 16128 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2014-09-17 14:24:46 16128 [ERROR] Unknown/unsupported storage engine: InnoDB
    2014-09-17 14:24:46 16128 [ERROR] Aborting
    
    2014-09-17 14:24:46 16128 [Note] Binlog end
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'partition'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'ARCHIVE'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_METRICS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_CMP'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_LOCKS'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'INNODB_TRX'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'BLACKHOLE'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'MRG_MYISAM'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'CSV'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'MEMORY'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'MyISAM'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'sha256_password'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'mysql_old_password'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'mysql_native_password'
    2014-09-17 14:24:46 16128 [Note] Shutting down plugin 'binlog'
    2014-09-17 14:24:46 16128 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140917 14:24:46 mysqld_safe mysqld from pid file /var/lib/mysql/site.mcstartup.net.pid ended
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    I noticed the following in the output you provided:

    Please ensure the /tmp partition and any other partition on your system is not at it's disk space limit.

    Thank you.
     
  3. jca2

    jca2 Member

    Joined:
    Sep 17, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    /tmp/ and /var/tmp both have 400M space available, is that too little?
     
  4. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hey,

    Are there lots of files in /tmp ? Check if clearing unnecessary files could help this issue ! I have seen a case
    when there was enough disk space in /tmp yet lotta files in /tmp preventing the startup !
     
  5. jca2

    jca2 Member

    Joined:
    Sep 17, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    there is several files, though I'm not able to distinguish which ones are important or not.

    there are several hudnred sess_##### files.

    - - - Updated - - -

    I actually deleted all of the sess files and was able to start my database, thanks.
     
  6. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    Hey,

    Yes the sess files can be removed safely.

    Glad to know that your MySQL is back working :)
     
  7. arunanson

    arunanson Registered

    Joined:
    Dec 4, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Trivandrum, India, India
    cPanel Access Level:
    Root Administrator
    Code:
    2014-12-04 18:40:40 9407 [Note] InnoDB: Highest supported file format is Barracuda.
    2014-12-04 18:40:40 9407 [Note] InnoDB: The log sequence numbers 6952730092 and 6952730092 in ibdata files do not match the log sequence number 7297651529 in the ib_logfiles!
    2014-12-04 18:40:40 9407 [Note] InnoDB: Database was not shutdown normally!
    2014-12-04 18:40:40 9407 [Note] InnoDB: Starting crash recovery.
    2014-12-04 18:40:40 9407 [Note] InnoDB: Reading tablespace information from the .ibd files...
    2014-12-04 18:40:41 9407 [Note] InnoDB: Restoring possible half-written data pages 
    2014-12-04 18:40:41 9407 [Note] InnoDB: from the doublewrite buffer...
    2014-12-04 18:40:41 9407 [Note] InnoDB: 128 rollback segment(s) are active.
    2014-12-04 18:40:41 9407 [Note] InnoDB: Waiting for purge to start
    2014-12-04 18:40:41 9407 [Note] InnoDB: 5.6.21 started; log sequence number 7297651529
    2014-12-04 18:40:41 9407 [Note] Server hostname (bind-address): '*'; port: 3306
    2014-12-04 18:40:41 9407 [Note] IPv6 is available.
    2014-12-04 18:40:41 9407 [Note]   - '::' resolves to '::';
    2014-12-04 18:40:41 9407 [Note] Server socket created on IP: '::'.
    2014-12-04 18:40:41 9407 [ERROR] /usr/sbin/mysqld: Error writing file '/var/lib/mysql/newweb.cloudamaze.com.pid' (Errcode: 28 - No space left on device)
    2014-12-04 18:40:41 9407 [ERROR] Can't start server: can't create PID file: No space left on device
    141204 18:40:41 mysqld_safe Number of processes running now: 0
    141204 18:40:41 mysqld_safe mysqld restarted
    My .err shows the above. Also the file is 15MB of size. I cleared the file after downloading it locally. My httpd works only after manually issuing a service httpd restart command.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  9. arunanson

    arunanson Registered

    Joined:
    Dec 4, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Trivandrum, India, India
    cPanel Access Level:
    Root Administrator
    Filesystem Size Used Avail Use% Mounted on
    /dev/xvda 94G 93G 0 100% /
    tmpfs 2.0G 108K 2.0G 1% /dev/shm
    /usr/tmpDSK 2.6G 5.7M 2.4G 1% /tmp

    this is the reply. What should i do?
     
  10. arunanson

    arunanson Registered

    Joined:
    Dec 4, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Trivandrum, India, India
    cPanel Access Level:
    Root Administrator
    Got it ok. I deleted the 'backups' folder content since i have a backup from my server provider. Now it makes space. :)
    Had to issue a manual httpd restart.
    WOrks fine. Thanks for the help anyway.
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page