lnmp mysql 启动错误带错误日志 （以解决谢军哥）。急！！！

nanjingnan

aStarting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/host-163-44-149-204.pid

[ 本帖最后由 nanjingnan 于 2017-3-25 12:25 编辑 ]

licess

170322 19:05:50 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170322 19:06:06 [Warning] Disk is full writing './mysql-bin.000050' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170322 19:06:06 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170322 19:06:50 [Warning] Disk is full writing './dswnoswnzskd/pre_forum_post.TMD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170322 19:06:50 [Warning] Retry in 60 secs. Message reprinted in 600 secs
170322 19:07:06 [Warning] Disk is full writing './mysql-bin.000050' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
170322 19:07:06 [Warning] Retry in 60 secs. Message reprinted in 600 secs
.............
170322 19:10:38 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 76, event_type: 2
170322 19:10:38 [Note] Starting crash recovery...
170322 19:10:38 [Note] Crash recovery finished.
11:10:38 UTC - mysqld got signal 11 ;
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=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=500
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 = 406149 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...
stack_bottom = 0 thread_stack 0x40000
/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x76193e]
/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x41a)[0x655caa]
/lib64/libpthread.so.0(+0xf7e0)[0x7f8eb69807e0]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

应该是当前分区或磁盘空间已满，可以df -h看一下占用情况

nanjingnan

47G   15G   30G  34% /
tmpfs                 499M     0  499M   0% /dev/shm
/dev/vda1             477M   63M  389M  14% /boot

删除了20多g日志后 还是不能启动。
目前的错误提示

[ERROR]

[ 本帖最后由 nanjingnan 于 2017-3-23 10:07 编辑 ]

licess

170323  9:33:15 InnoDB: 5.5.48 started; log sequence number 1595685
/usr/local/mysql/bin/mysqld: File './mysql-bin.000052' not found (Errcode: 13)
170323  9:33:15 [ERROR] Failed to open log (file './mysql-bin.000052', errno 13)
170323  9:33:15 [ERROR] Could not open log file
170323  9:33:15 [ERROR] Can't init tc log
170323  9:33:15 [ERROR] Aborting

170323  9:33:15  InnoDB: Starting shutdown...

清空mysql-bin.index 应该就可以了

nanjingnan

数据库可以启动了。我的是discuz系统 目前出现错误。我直接把mysql-bin.index 删除了。删除后可以启动了。但是还是数据错误。是不是因为我没有正确的清楚

清空mysql-bin.index，按照网上的方法不知道怎么清除。

(144) Table './数据库名/forum_post' is marked as crashed and last (automatic?) repair failedSELECT distinct authorid as uid,author as username FROM forum_post where invisible=0 and dateline>1487674919 order by dateline DESC
PHP Debug

No.	File	Line	Code
1	forum.php	65	runhooks()
2	source/function/function_core.php	1120	hookscript(%s, %s, %s, Array, %s, %s)
3	source/function/function_core.php	1167	plugin_nimba_nge_forum->index_top(Array)
4	source/plugin/nimba_nge/hook.class.php	365	plugin_nimba_nge->nge_userlist()
5	source/plugin/nimba_nge/hook.class.php	325	discuz_database::query(%s)
6	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, false, false)
7	source/class/db/db_driver_mysql.php	153	db_driver_mysql->halt(%s, %d, %s)
8	source/class/db/db_driver_mysql.php	224	break()

尝试了修复表。在phpmyamdin 但是没有作用。。求帮忙看看。
如果还是要修复表，麻烦军哥告诉我修复的方法（linux里），我用的网上的貌似不对。
路径方面我还特地按照lnmp的路径来的。




[ 本帖最后由 nanjingnan 于 2017-3-23 20:11 编辑 ]

licess

日志和之前的是一样的

/usr/local/mysql/bin/mysql -uroot -p
use 数据库名;
repair table 表名;
修复成功的话可以输入 exit; 退出

不行的话可以cd 到数据库目录后 尝试使用 /usr/local/mysql/bin/myisamchk -o -r 表名.MYI 运行前需要先停掉mysql

也可以尝试  /usr/local/mysql/bin/mysqlcheck -r 数据库名 表名 -uroot -p 进行修复

nanjingnan

真心感谢军哥 ，我自己尝试解决了。是修复表就好了。我是停止数据库 然后强制修复的。早上弄好了。太感谢了。