They would be generated again when you restart mysql #service mysql stopĬheck your mysql server service and it is probably up and running service mysql status Then, do not forget to remove the mysql corrupted log files afterwards. So, had to clean up cache and files that were not needed: #apt-get clean And I thought on either migrating or increasing the virtual drive, but I decided to remove unnecessary files first. dev/mapper/server1-osticket-vg-root 8.3G 7.9G 0 100% /įrom here, I could see that there was not enough space left on the virtual server /dev/mapper/server1-osticket-vg-root 8.3G 7.9G 0 100% /. df -hįilesystem Size Used Avail Use% Mounted on T05:25:29.519145Z 0 InnoDB: Error number 28 means 'No space left on device' ibtmp1failed at offset 3145728, 1048576 bytes should have been written, only 704512 were writt$ cnf file 0 26214400 bytes!ġ40425 12:49:05 Plugin 'InnoDB' init function returned error.ġ40425 12:49:05 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.ġ40425 12:49:05 /usr/sbin/mysqld: unknown variable 'record_buffer=64M'ġ40425 12:49:05 /usr/sbin/mysqld: Shutdown completeįrom /var/log/mysql/error.log I got some hints from two lines: T05:25:29.519139Z 0 InnoDB: Write to file. ib_logfile0 is of different size 0 5242880 bytes Please use the full name instead.ġ40425 12:49:05 Plugin 'FEDERATED' is disabled.ġ40425 12:49:05 InnoDB: The InnoDB memory heap is disabledġ40425 12:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtinsġ40425 12:49:05 InnoDB: Compressed tables use zlib 1.2.8ġ40425 12:49:05 InnoDB: Using Linux native AIOġ40425 12:49:05 InnoDB: Initializing buffer pool, size = 3.0Gġ40425 12:49:05 InnoDB: Completed initialization of buffer pool var/log/mysql/mysql.log and /var/log/mysql/mysql.err files are empty.īut /var/log/error.log shows following information: 140425 12:49:05 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. I then tried to restart mysql server using service mysql startīut,the start process failed in all 3 cases. On executing ps aux | grep mysql command,I realized that mysql server was not running. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)īut mysqld.sock file doesn't exist inside /var/run/mysqld folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |