Out of space? - My server is breaking
Ok. First of all I would like to mention that I have just registered on this site and I will like to apologize if I may have used the wrong section or so, but I feel like this is the place where I could get the most help as fast as possible.
Now I would like to give out some information about my server and what is going on with it. - My dedicated server is hosted at OVH in Quebec if I'm correct - On my server I run a minecraft server, Teamspeak3 server and a website running SMF (SimpleMachines Forum) + I got to setup a Mysql server which I use both for the website and for the Minecraft server - Now this is my first time that I was setting up and working in the Linux enviroment, even though I don't have much knowledge in scripting and proggraming either way and I just did most of the work following tutorials so everything could work. But looks like always something has to go wrong :/ Now this is my situation when I login with putty: http://i.imgur.com/YYkxdSD.png And here is my website which has been down for some time now, cause I really do not know how to fix it. http://mc.brutalcraft.org However the Minecraft server is still working. I know I probably sound like a joke and your best advice for me from most of you would probably be to just give up cause I don't know what the f* I'm doing, but there's actually a great community I have created in this "more than a year" lasting Minecraft server and I would really like to keep it going and running. Once again apologizes if I'm asking for too much help here, but I'm lost and stuck at the point where I really need somebody else more experienced with me to help me solve this issues. I do not know if this is the best website to post about this kind of issues, but I definetly feel like it's worth trying, cause hey, can't get much worse. If you have any questions or if you would like me to execute some commands for you and tell you the results go ahead. You can also add me on skype: gajsak636 Thanks for reading, in case you made it this far :D |
Quote:
Code:
mount; df -mh; du -mhs /var/* |
Quote:
Code:
root@ns4008415:~# mount; df -mh; du -mhs /var/* |
At first glance I'd say you should either attach storage or re-distribute space as your /home partition apparently doesn't require that much free space:
Quote:
Quote:
Code:
du -mhs /var/lib/* |
Quote:
Code:
root@ns4008415:~# du -mhs /var/lib/* |
*First ensure you have backups off site (like you should with valuable data).
0) Stop the web server and the MySQL service 1) Ensure nothing is accessing the source directory or stop those services first: Code:
lsof -Pwln -a +D/var/lib/mysql Code:
\cp --sparse=auto --no-clobber --preserve=all --recursive /var/lib/mysql /home Code:
mv /var/lib/mysql /var/lib/mysql_old Code:
mkdir /var/lib/mysql && mount --bind /home/mysql /var/lib/mysql 6) If no errors are logged and the web site is working then adjust /etc/fstab to reflect the changes: Code:
echo '/home/mysql /var/lib/mysql none bind' >> /etc/fstab Code:
rm -rf /var/lib/mysql_old |
I ran all of the commands successfully, but when attempting to start mysql I got the following - http://imgur.com/iObY0Sk
|
step #5: ...and check their log files for any errors.
|
140216 15:39:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140216 15:39:38 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140216 15:39:38 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140216 15:39:38 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 140216 15:39:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140216 15:39:38 InnoDB: The InnoDB memory heap is disabled 140216 15:39:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140216 15:39:38 InnoDB: Compressed tables use zlib 1.2.8 140216 15:39:38 InnoDB: Using Linux native AIO 140216 15:39:38 InnoDB: Initializing buffer pool, size = 128.0M 140216 15:39:38 InnoDB: Completed initialization of buffer pool 140216 15:39:38 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. 140216 15:39:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140216 15:44:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140216 15:44:54 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140216 15:44:54 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140216 15:44:54 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 140216 15:44:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140216 15:44:54 InnoDB: The InnoDB memory heap is disabled 140216 15:44:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140216 15:44:54 InnoDB: Compressed tables use zlib 1.2.8 140216 15:44:54 InnoDB: Using Linux native AIO 140216 15:44:54 InnoDB: Initializing buffer pool, size = 128.0M 140216 15:44:54 InnoDB: Completed initialization of buffer pool 140216 15:44:54 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. 140216 15:44:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended |
Quote:
Code:
umount /var/lib/mysql |
This is the new error
Quote:
|
Please don't use [QUOTE]text[/QUOTE] but [CODE]text[/CODE] tags for log lines.
Quote:
Code:
pgrep mysqld && { pkill -15 -f mysqld; sleep 5s; pkill -9 -f mysqld; } |
Mysql is working fine now, thank you so much for that. My memory has gone to this - http://imgur.com/HRfOrTu
|
Quote:
Code:
rm -rf /var/lib/mysql Code:
rm -rf /var/lib/mysql_old |
Quote:
Code:
rm -rf /var/lib/mysql_old |
All times are GMT -5. The time now is 02:57 AM. |