Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Language specific forums Russian (Русский) Сервер баз данных
  • Search

После перезапуска сервера перестал работать Mysql сервер

Вопросы по работе Сервера баз данных
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
RoDGeR
Posts: 40
Joined: Wed Aug 14, 2013 6:01 am
Contact:
Contact RoDGeR
Website

После перезапуска сервера перестал работать Mysql сервер
  • Quote

Post by RoDGeR » Thu Jul 21, 2016 8:15 am

После того как перезагрузил сервер, перестал стартовать сервер мускула!
Лог:
SpoilerShow

Code: Select all

160721 11:06:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160721 11:06:47 [Note] /usr/sbin/mysqld (mysqld 5.5.49-0+deb7u1) starting as process 10785 ...
160721 11:06:47 [Note] Plugin 'FEDERATED' is disabled.
160721 11:06:47 InnoDB: The InnoDB memory heap is disabled
160721 11:06:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160721 11:06:47 InnoDB: Compressed tables use zlib 1.2.7
160721 11:06:47 InnoDB: Using Linux native AIO
160721 11:06:47 InnoDB: Initializing buffer pool, size = 128.0M
160721 11:06:47 InnoDB: Completed initialization of buffer pool
160721 11:06:47 InnoDB: highest supported file format is Barracuda.
InnoDB: Error: tried to read 16384 bytes at offset 0 4915200.
InnoDB: Was only able to read 4096.
InnoDB: Fatal error: cannot read from file. OS error number 17.
160721 11:08:01  InnoDB: Assertion failure in thread 140190950213408 in file os0file.c line 2549
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
08:08:01 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=134217728
read_buffer_size=1048576
max_used_connections=0
max_threads=100
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337025 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: После перезапуска сервера перестал работать Mysql сервер
  • Quote

Post by skurudo » Thu Jul 21, 2016 10:27 am

Эка вы лихо перезагрузились.

Code: Select all

InnoDB: Error: tried to read 16384 bytes at offset 0 4915200.
InnoDB: Was only able to read 4096.
InnoDB: Fatal error: cannot read from file. OS error number 17.
Обычно предлагают такое решение:

Code: Select all

mv /var/lib/mysql/ib* /root/

Code: Select all

service mysql restart
Само собой не помешало бы диск проверить.
Top


Post Reply
  • Print view

2 posts • Page 1 of 1

Return to “Сервер баз данных”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password