MySql service that is not starting
Budget: $10 – $30 USD
After emptying mysqld.log file Mysql server is not starting.
Need a expert to immediately fix Mysql starting problem.
Magento website shows this: SQLSTATE[HY000] [2002] No such file or directory
[root]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mysqld.log
2021-07-10 11:17:12 11255 [Note] Plugin 'FEDERATED' is disabled.
2021-07-10 11:17:12 11255 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-07-10 11:17:12 11255 [Note] InnoDB: The InnoDB memory heap is disabled
2021-07-10 11:17:12 11255 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-10 11:17:12 11255 [Note] InnoDB: Memory barrier is not used
2021-07-10 11:17:12 11255 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-07-10 11:17:12 11255 [Note] InnoDB: Using Linux native AIO
2021-07-10 11:17:12 11255 [Note] InnoDB: Using CPU crc32 instructions
2021-07-10 11:17:12 11255 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-07-10 11:17:12 11255 [Note] InnoDB: Completed initialization of buffer pool
2021-07-10 11:17:12 11255 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-10 11:17:12 11255 [Note] InnoDB: The log sequence numbers 215140364129 and 215140364129 in ibdata files do not match the log sequence number 437491656444 in the ib_logfiles!
2021-07-10 11:17:12 11255 [Note] InnoDB: Database was not shutdown normally!
2021-07-10 11:17:12 11255 [Note] InnoDB: Starting crash recovery.
2021-07-10 11:17:12 11255 [Note] InnoDB: Reading tablespace information from the .ibd files...
2021-07-10 11:17:12 11255 [ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 0.
2021-07-10 11:17:12 7f9f036ed740 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2021-07-10 11:17:12 11255 [ERROR] InnoDB: File (unknown): 'read' returned OS error 71. Cannot continue operation
210710 11:17:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
210710 11:27:12 mysqld_safe Logging to '/var/log/mysqld.log'.
210710 11:27:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2021-07-10 11:27:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-10 11:27:13 0 [Note] /usr/sbin/mysqld (mysqld 5.6.38) starting as process 13515 ...
2021-07-10 11:27:13 13515 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2021-07-10 11:27:13 13515 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
Need a expert to immediately fix Mysql starting problem.
Magento website shows this: SQLSTATE[HY000] [2002] No such file or directory
[root]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mysqld.log
2021-07-10 11:17:12 11255 [Note] Plugin 'FEDERATED' is disabled.
2021-07-10 11:17:12 11255 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-07-10 11:17:12 11255 [Note] InnoDB: The InnoDB memory heap is disabled
2021-07-10 11:17:12 11255 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-10 11:17:12 11255 [Note] InnoDB: Memory barrier is not used
2021-07-10 11:17:12 11255 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-07-10 11:17:12 11255 [Note] InnoDB: Using Linux native AIO
2021-07-10 11:17:12 11255 [Note] InnoDB: Using CPU crc32 instructions
2021-07-10 11:17:12 11255 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-07-10 11:17:12 11255 [Note] InnoDB: Completed initialization of buffer pool
2021-07-10 11:17:12 11255 [Note] InnoDB: Highest supported file format is Barracuda.
2021-07-10 11:17:12 11255 [Note] InnoDB: The log sequence numbers 215140364129 and 215140364129 in ibdata files do not match the log sequence number 437491656444 in the ib_logfiles!
2021-07-10 11:17:12 11255 [Note] InnoDB: Database was not shutdown normally!
2021-07-10 11:17:12 11255 [Note] InnoDB: Starting crash recovery.
2021-07-10 11:17:12 11255 [Note] InnoDB: Reading tablespace information from the .ibd files...
2021-07-10 11:17:12 11255 [ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 0.
2021-07-10 11:17:12 7f9f036ed740 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2021-07-10 11:17:12 11255 [ERROR] InnoDB: File (unknown): 'read' returned OS error 71. Cannot continue operation
210710 11:17:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
210710 11:27:12 mysqld_safe Logging to '/var/log/mysqld.log'.
210710 11:27:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2021-07-10 11:27:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-07-10 11:27:13 0 [Note] /usr/sbin/mysqld (mysqld 5.6.38) starting as process 13515 ...
2021-07-10 11:27:13 13515 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2021-07-10 11:27:13 13515 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)