Board logo

标题: [求助] 惨了,升级mysql5.5,启动不了了 [打印本页]

作者: testu    时间: 2015-5-19 22:15     标题: 惨了,升级mysql5.5,启动不了了

按admin的方法,wget http://down.wdlinux.cn/in/mysql_up55.sh
sh mysql_up55.sh
然后 改写mysqld
basedir=/www/wdlinux/mysql
datadir=/www/wdlinux/mysql/var
然后
。。。。。

150519 21:47:08 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
/www/wdlinux/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
150519 21:47:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150519 21:47:08 InnoDB: The InnoDB memory heap is disabled
150519 21:47:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150519 21:47:08 InnoDB: Compressed tables use zlib 1.2.3
150519 21:47:08 InnoDB: Initializing buffer pool, size = 2.0G
150519 21:47:08 InnoDB: Completed initialization of buffer pool
150519 21:47:08  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
150519 21:47:08 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/west11237.pid ended


怎样处理呢?求大神指教
作者: testu    时间: 2015-5-20 07:37

努力抢修以后
变成这样了

150520 07:11:59 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
150520  7:11:59 InnoDB: The InnoDB memory heap is disabled
150520  7:11:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150520  7:11:59 InnoDB: Compressed tables use zlib 1.2.3
150520  7:11:59 InnoDB: Initializing buffer pool, size = 2.0G
150520  7:11:59 InnoDB: Completed initialization of buffer pool
150520  7:11:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB:150520  7:11:59  InnoDB: Error: Write to file ./ib_logfile0 failed at offset 0 0.
InnoDB: 1048576 bytes should have been written, only -1 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: Error in creating ./ib_logfile0: probably out of disk space
150520  7:11:59 [ERROR] Plugin 'InnoDB' init function returned error.
150520  7:11:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/www/wdlinux/mysql/bin/mysqld: Error writing file '/www/wdlinux/mysql/var/west11237-slow.log' (Errcode: 28)
150520  7:11:59 [ERROR] Could not use /www/wdlinux/mysql/var/west11237-slow.log for logging (error 28). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
/www/wdlinux/mysql/bin/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/www/wdlinux/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
作者: testu    时间: 2015-5-20 08:40

[root@west11237 ~]# df -h
文件系统              容量  已用  可用 挂载点
/dev/sda1             9.9G  9.7G     0 100% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sdb1             483G   62G  397G  14% /home

发现空间满了
作者: testu    时间: 2015-5-20 11:12

解决了
一个是mysql目录最好放在home里,很容易占满空间
二是/var/lib/mysql/目录权限不正确,造成sock文件无法创建
还做了几个修改,见招拆招,在服务商客服帮助下搞定了。
作者: yueyanwen    时间: 2015-5-20 18:48

楼主好样的。
作者: meinvba    时间: 2015-8-11 19:50

学习了不错




欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2