Error starting MySql

Linux Database Servers

Moderator: Moderators

walid amjad
New Member
New Member
Posts: 1
Joined: Thu Apr 10, 2014 10:06 pm

Error starting MySql

Postby walid amjad » Thu Apr 10, 2014 10:13 pm

Hello everyone, I have a problem starting MySql

I do this commands but it does not work:


Code: Select all

[root@www ~]# ps aux | grep mysql
root      2600  0.0  0.1   4164   648 pts/1    S+   14:46   0:00 grep mysql
[root@www ~]# kill -9 2600
-bash: kill: (2600) - Aucun processus de ce type
[root@www ~]# mv /etc/my.cnf /etc/my.cnf.backup
[root@www ~]#mv /var/lib/mysql/ib_logfile* /root/





and here is the file content file (/ var / lib / mysql / http://www.exemple.com.err)



Code: Select all

140409 14:24:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
2014-04-09 14:24:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use –explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-04-09 14:24:50 2291 [ERROR] Can’t read from messagefile ‘/usr/share/mysql/e
nglish/errmsg.sys’
2014-04-09 14:24:50 2291 [Note] Plugin ‘FEDERATED’ is disabled.
2014-04-09 14:24:51 2291 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-09 14:24:51 2291 [Note] InnoDB: Mutexes and rw_locks use InnoDB’s own im
plementation
2014-04-09 14:24:51 2291 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-09 14:24:51 2291 [Note] InnoDB: Using Linux native AIO
2014-04-09 14:24:51 2291 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-09 14:24:51 2291 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-09 14:24:51 2291 [Note] InnoDB: Completed initialization of buffer pool
2014-04-09 14:24:51 2291 [Note] InnoDB: Highest supported file format is Barracu
da.
2014-04-09 14:24:54 2291 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-09 14:24:54 2291 [Note] InnoDB: Waiting for purge to start
2014-04-09 14:24:54 2291 [Note] InnoDB: 5.6.12 started; log sequence number 3430
0076
2014-04-09 14:24:54 2291 [ERROR] Aborting

2014-04-09 14:24:54 2291 [Note] Binlog end
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘partition’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘BLACKHOLE’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘ARCHIVE’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD

2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_METRICS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET

2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_CMP’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_LOCKS’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘INNODB_TRX’
2014-04-09 14:24:54 2291 [Note] Shutting down plugin ‘InnoDB’
2014-04-09 14:24:54 2291 [Note] InnoDB: FTS optimize thread exiting.
2014-04-09 14:24:54 2291 [Note] InnoDB: Starting shutdown…
2014-04-09 14:24:56 2291 [Note] InnoDB: Shutdown completed; log sequence number
34300086
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘MRG_MYISAM’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘MEMORY’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘MyISAM’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘CSV’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘sha256_password’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘mysql_old_password’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘mysql_native_password’
2014-04-09 14:24:56 2291 [Note] Shutting down plugin ‘binlog’
2014-04-09 14:24:56 2291 [Note]
140409 14:24:57 mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended
140409 14:42:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/
mysql
2014-04-09 14:42:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use –explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-04-09 14:42:26 2536 [ERROR] Can’t read from messagefile ‘/usr/share/mysql/e
nglish/errmsg.sys’
2014-04-09 14:42:27 2536 [Note] Plugin ‘FEDERATED’ is disabled.
2014-04-09 14:42:27 2536 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-09 14:42:27 2536 [Note] InnoDB: Mutexes and rw_locks use InnoDB’s own im
plementation
2014-04-09 14:42:27 2536 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-09 14:42:27 2536 [Note] InnoDB: Using Linux native AIO
2014-04-09 14:42:27 2536 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-09 14:42:27 2536 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-09 14:42:27 2536 [Note] InnoDB: Completed initialization of buffer pool
2014-04-09 14:42:28 2536 [Note] InnoDB: Highest supported file format is Barracu
da.
2014-04-09 14:42:32 2536 [Note] InnoDB: 128 rollback segment(s) are active.
2014-04-09 14:42:32 2536 [Note] InnoDB: Waiting for purge to start
2014-04-09 14:42:33 2536 [Note] InnoDB: 5.6.12 started; log sequence number 3430
0086
2014-04-09 14:42:33 2536 [ERROR] Aborting

2014-04-09 14:42:33 2536 [Note] Binlog end
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘partition’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘BLACKHOLE’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘ARCHIVE’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD

2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_METRICS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET

2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_CMP’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_LOCKS’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘INNODB_TRX’
2014-04-09 14:42:33 2536 [Note] Shutting down plugin ‘InnoDB’
2014-04-09 14:42:33 2536 [Note] InnoDB: FTS optimize thread exiting.
2014-04-09 14:42:33 2536 [Note] InnoDB: Starting shutdown…
2014-04-09 14:42:34 2536 [Note] InnoDB: Shutdown completed; log sequence number
34300096
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘MRG_MYISAM’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘MEMORY’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘MyISAM’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘CSV’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘sha256_password’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘mysql_old_password’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘mysql_native_password’
2014-04-09 14:42:34 2536 [Note] Shutting down plugin ‘binlog’
2014-04-09 14:42:34 2536 [Note]
140409 14:42:35 mysqld_safe mysqld from pid file /var/lib/mysql/www.exemple.com.pid ended


thank you in advance

Return to “Linux Database Servers”

Who is online

Users browsing this forum: No registered users and 2 guests