Topics

1

Kloxo-MR Technical Helps / mysql doesn't start

« on: 2016-09-05, 15:35:57 »

Hi.
I need a really critical and emergency HELP

mysql doesn't start:

Code: [Select]

#sh /script/restart-mysql

*** Process for MYSQL/MARIADB service ***
Starting MySQL. ERROR!
  - Process: restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR!
-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'


it's my last *.err:

Code: [Select]

160905  6:12:25 [ERROR] mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905  6:12:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905 06:12:25 mysqld_safe mysqld from pid file /var/lib/mysql/srv18558.screweb.com.pid ended
160905 06:12:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160905  6:12:34 [Note] /usr/sbin/mysqld (mysqld 10.0.27-MariaDB) starting as process 24707 ...
160905  6:12:34 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160905  6:12:34 [Note] InnoDB: The InnoDB memory heap is disabled
160905  6:12:34 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160905  6:12:34 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
160905  6:12:34 [Note] InnoDB: Compressed tables use zlib 1.2.3
160905  6:12:34 [Note] InnoDB: Not using CPU crc32 instructions
160905  6:12:34 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160905  6:12:34 [Note] InnoDB: Completed initialization of buffer pool
160905  6:12:34 [Note] InnoDB: Highest supported file format is Barracuda.
160905  6:12:34 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2752155884
160905  6:12:34 [Note] InnoDB: Database was not shutdown normally!
160905  6:12:34 [Note] InnoDB: Starting crash recovery.
160905  6:12:34 [Note] InnoDB: Reading tablespace information from the .ibd files...
160905  6:12:34 [Note] InnoDB: Restoring possible half-written data pages
160905  6:12:34 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2752155894
160905  6:12:34 [Note] InnoDB: 128 rollback segment(s) are active.
160905  6:12:34 [Note] InnoDB: Waiting for purge to start
160905  6:12:34 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 2752155894
160905  6:12:34 [Note] Plugin 'FEEDBACK' is disabled.
160905  6:12:34 [Note] Server socket created on IP: '::'.
160905  6:12:34 [ERROR] mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905  6:12:34 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905 06:12:34 mysqld_safe mysqld from pid file /var/lib/mysql/srv18558.screweb.com.pid ended

and it's my server.cnf content:

Code: [Select]

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
performance_schema=on
default-storage-engine=innodb
;###123###skip-innodb
#OpenVZ AIO bug fix
innodb_use_native_aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]

I tired many things but none of them did not resolve the problem
what can I do 

thanks for your future helps (specially Mustafa Ramadhan)