Форум русскоязычного сообщества Ubuntu


За новостями русскоязычного сообщества и Ubuntu в целом можно следить на нашей страничке в Google+

Автор Тема: после обновления до 16.04 не грузится mysql  (Прочитано 1396 раз)

0 Пользователей и 1 Гость просматривают эту тему.

Оффлайн TheExt4

  • Автор темы
  • Любитель
  • *
  • Сообщений: 78
    • Просмотр профиля
Решил обновиться до 16.04, когда он спросил, оставить ли конфиг mysql, какой именно я не запомнил, я ответил чтобы оставил старый, в результате mysql не грузится

2016-05-16T12:56:11.799554Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2016-05-16T12:56:11.799635Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2016-05-16T12:56:11.970797Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-05-16T12:56:11.971428Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-0ubuntu1) starting as process 5816 ...
2016-05-16T12:56:11.977336Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-05-16T12:56:11.977393Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-05-16T12:56:11.977402Z 0 [Note] InnoDB: Uses event mutexes
2016-05-16T12:56:11.977410Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-05-16T12:56:11.977418Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-05-16T12:56:11.977426Z 0 [Note] InnoDB: Using Linux native AIO
2016-05-16T12:56:11.977749Z 0 [Note] InnoDB: Number of pools: 1
2016-05-16T12:56:11.977881Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-16T12:56:11.989072Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-05-16T12:56:12.000951Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-05-16T12:56:12.003423Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-05-16T12:56:12.015981Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-16T12:56:12.071685Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-05-16T12:56:12.071844Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-05-16T12:56:12.317319Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-05-16T12:56:12.318307Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-05-16T12:56:12.318323Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-05-16T12:56:12.319417Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 747867787
2016-05-16T12:56:12.319754Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-05-16T12:56:12.320517Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-05-16T12:56:12.320835Z 0 [Warning] System table 'plugin' is expected to be transactional.
2016-05-16T12:56:12.320900Z 0 [ERROR] Function 'innodb' already exists
2016-05-16T12:56:12.320907Z 0 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-05-16T12:56:12.320914Z 0 [ERROR] Function 'federated' already exists
2016-05-16T12:56:12.320919Z 0 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-05-16T12:56:12.320925Z 0 [ERROR] Function 'blackhole' already exists
2016-05-16T12:56:12.320930Z 0 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-05-16T12:56:12.320936Z 0 [ERROR] Function 'archive' already exists
2016-05-16T12:56:12.320941Z 0 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-05-16T12:56:12.321060Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160516 15:56:12
2016-05-16T12:56:12.321245Z 0 [ERROR] unknown variable 'myisam-recover=BACKUP'
2016-05-16T12:56:12.321257Z 0 [ERROR] Aborting

2016-05-16T12:56:12.321265Z 0 [Note] Binlog end
2016-05-16T12:56:12.321325Z 0 [Note] Shutting down plugin 'ngram'
2016-05-16T12:56:12.321333Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-05-16T12:56:12.321338Z 0 [Note] Shutting down plugin 'partition'
2016-05-16T12:56:12.321343Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-16T12:56:12.321348Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-05-16T12:56:12.321354Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-16T12:56:12.321358Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-16T12:56:12.321363Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-16T12:56:12.321369Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-16T12:56:12.321374Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-16T12:56:12.321379Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-16T12:56:12.321383Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-16T12:56:12.321389Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-16T12:56:12.321394Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-16T12:56:12.321399Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-16T12:56:12.321404Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-16T12:56:12.321408Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-16T12:56:12.321413Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-16T12:56:12.321419Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-16T12:56:12.321423Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-16T12:56:12.321429Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-16T12:56:12.321434Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-05-16T12:56:12.321439Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-16T12:56:12.321444Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-16T12:56:12.321449Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-16T12:56:12.321453Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-16T12:56:12.321458Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-16T12:56:12.321480Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-16T12:56:12.321486Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-16T12:56:12.321491Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-16T12:56:12.321496Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-16T12:56:12.321500Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-16T12:56:12.321505Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-16T12:56:12.321510Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-16T12:56:12.321514Z 0 [Note] Shutting down plugin 'InnoDB'
2016-05-16T12:56:12.321579Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-05-16T12:56:12.321695Z 0 [Note] InnoDB: Starting shutdown...
2016-05-16T12:56:12.421867Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2016-05-16T12:56:12.422106Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160516 15:56:12
2016-05-16T12:56:14.193153Z 0 [Note] InnoDB: Shutdown completed; log sequence number 747867806
2016-05-16T12:56:14.195875Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-05-16T12:56:14.195899Z 0 [Note] Shutting down plugin 'MEMORY'
2016-05-16T12:56:14.195907Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-16T12:56:14.196017Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-16T12:56:14.196024Z 0 [Note] Shutting down plugin 'MyISAM'
2016-05-16T12:56:14.196032Z 0 [Note] Shutting down plugin 'CSV'
2016-05-16T12:56:14.196039Z 0 [Note] Shutting down plugin 'sha256_password'
2016-05-16T12:56:14.196044Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-05-16T12:56:14.196264Z 0 [Note] Shutting down plugin 'binlog'
2016-05-16T12:56:14.196429Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
« Последнее редактирование: 17 Май 2016, 20:29:09 от Azure »
Nvidia Geforce GTX 760/Intel Core i5 4670/16 Гб ОЗУ

Оффлайн AnrDaemon

  • Заслуженный пользователь
  • Старожил
  • *
  • Сообщений: 26055
    • Просмотр профиля
Re: после обновления до 16.04
« Ответ #1 : 16 Май 2016, 16:04:59 »
Попробуйте повторно запустить конвертацию БД.
/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf -s -f
Хотите получить помощь? Потрудитесь представить запрошенную информацию в полном объёме.

Прежде чем [Отправить], нажми [Просмотр] и прочти собственное сообщение. Сам-то понял, что написал?…

Оффлайн TheExt4

  • Автор темы
  • Любитель
  • *
  • Сообщений: 78
    • Просмотр профиля
Re: после обновления до 16.04
« Ответ #2 : 16 Май 2016, 16:20:30 »
пишет то что сервер не запущен (Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server)
Nvidia Geforce GTX 760/Intel Core i5 4670/16 Гб ОЗУ

Оффлайн TheExt4

  • Автор темы
  • Любитель
  • *
  • Сообщений: 78
    • Просмотр профиля
ну где люди то?!
Nvidia Geforce GTX 760/Intel Core i5 4670/16 Гб ОЗУ

Оффлайн MooSE

  • Активист
  • *
  • Сообщений: 893
    • Просмотр профиля
Оно вроде бы достаточно понятно в логе сформулировало проблему:
2016-05-16T12:56:12.321245Z 0 [ERROR] unknown variable 'myisam-recover=BACKUP'

Убрать или закомментировать в конфиге и посмотреть что будет.

 

Страница сгенерирована за 0.06 секунд. Запросов: 24.