Проблема с mysql - не запускается

318
26 июня 2017, 18:53

Уже 2 часа пробую решить ошибку mysql

 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Все, что нашел в интернете - не помогло. Система - Debian 8

Логи

2017-06-24T04:23:37.576309Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-06-24T04:23:37.576314Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-06-24T04:23:37.576319Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-06-24T04:23:37.576324Z 0 [Note] Shutting down plugin 'MyISAM'                                                     
2017-06-24T04:23:37.576387Z 0 [Note] MyISAM: FTS optimize thread exiting.
2017-06-24T04:23:37.576547Z 0 [Note] MyISAM: Starting shutdown...
2017-06-24T04:23:37.676775Z 0 [Note] MyISAM: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool   2017-06-24T04:23:37.676987Z 0 [Note] MyISAM: Buffer pool(s) dump completed at 170624  7:23:37
2017-06-24T04:23:39.825952Z 0 [Note] MyISAM: Shutdown completed; log sequence number 17836936
2017-06-24T04:23:39.827904Z 0 [Note] MyISAM: Removed temporary tablespace data file: "ibtmp1"
2017-06-24T04:23:39.827919Z 0 [Note] Shutting down plugin 'MEMORY'                                         
2017-06-24T04:23:39.827925Z 0 [Note] Shutting down plugin 'CSV'
2017-06-24T04:23:39.827930Z 0 [Note] Shutting down plugin 'sha256_password'
2017-06-24T04:23:39.827934Z 0 [Note] Shutting down plugin 'mysql_native_password'                      2017-06-24T04:23:39.828062Z 0 [Note] Shutting down plugin 'binlog'                                         
2017-06-24T04:23:39.851737Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-06-24T04:23:45.221628Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)          2017-06-24T04:23:45.372375Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).                 2017-06-24T04:23:45.373344Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-1) starting as process 14769 ...
2017-06-24T04:23:45.477615Z 0 [Note] MyISAM: PUNCH HOLE support available
2017-06-24T04:23:45.477634Z 0 [Note] MyISAM: Mutexes and rw_locks use GCC atomic builtins
2017-06-24T04:23:45.477638Z 0 [Note] MyISAM: Uses event mutexes
2017-06-24T04:23:45.477642Z 0 [Note] MyISAM: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-06-24T04:23:45.477645Z 0 [Note] MyISAM: Compressed tables use zlib 1.2.8
2017-06-24T04:23:45.477648Z 0 [Note] MyISAM: Using Linux native AIO
2017-06-24T04:23:45.477801Z 0 [Note] MyISAM: Number of pools: 1
2017-06-24T04:23:45.477864Z 0 [Note] MyISAM: Using CPU crc32 instructions
2017-06-24T04:23:45.478683Z 0 [Note] MyISAM: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2017-06-24T04:23:45.620033Z 0 [Note] MyISAM: Completed initialization of buffer pool
2017-06-24T04:23:45.643278Z 0 [Note] MyISAM: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-06-24T04:23:45.654335Z 0 [Note] MyISAM: Highest supported file format is Barracuda.
2017-06-24T04:24:00.181754Z 0 [Note] MyISAM: Creating shared tablespace for temporary tables
2017-06-24T04:24:00.181820Z 0 [Note] MyISAM: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-06-24T04:24:00.182216Z 0 [Warning] MyISAM: Retry attempts for writing partial data failed.
2017-06-24T04:24:00.182233Z 0 [ERROR] MyISAM: Write to file ./ibtmp1failed at offset 0, 1048576 bytes should have been written, only 0 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2017-06-24T04:24:00.182244Z 0 [ERROR] MyISAM: Error number 28 means 'No space left on device'
2017-06-24T04:24:00.182251Z 0 [Note] MyISAM: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2017-06-24T04:24:00.182258Z 0 [ERROR] MyISAM: Could not set the file size of './ibtmp1'. Probably out of disk space
2017-06-24T04:24:00.182265Z 0 [ERROR] MyISAM: Unable to create the shared innodb_temporary
2017-06-24T04:24:00.182271Z 0 [ERROR] MyISAM: Plugin initialization aborted with error Generic error
2017-06-24T04:24:00.782916Z 0 [Note] MyISAM: Removed temporary tablespace data file: "ibtmp1"
2017-06-24T04:24:00.782944Z 0 [ERROR] Plugin 'MyISAM' init function returned error.
2017-06-24T04:24:00.782953Z 0 [ERROR] Plugin 'MyISAM' registration as a STORAGE ENGINE failed.
2017-06-24T04:24:00.782961Z 0 [ERROR] Failed to initialize plugins.
2017-06-24T04:24:00.782967Z 0 [ERROR] Aborting
2017-06-24T04:24:00.782976Z 0 [Note] Binlog end
2017-06-24T04:24:00.783033Z 0 [Note] Shutting down plugin 'CSV'
READ ALSO
Как приостановить или задать паузу, пока не будет выполнен другой поток?

Как приостановить или задать паузу, пока не будет выполнен другой поток?

Нужно, чтобы приложение не отвечало до тех пор, пока созданный поток недовыполнит свою задачуНу например:

195
JSON java android. Поменять значения

JSON java android. Поменять значения

Всем приветЕсть ли способ поменять значения в JSON файле? Не считая способа получить все данные, поменять нужные и записать все снова

216
удаление элемента LinkedList

удаление элемента LinkedList

у меня есть класс

379