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


Хотите сделать посильный вклад в развитие Ubuntu и русскоязычного сообщества?
Помогите нам с документацией!

Автор Тема: Не получается установить MySQL  (Прочитано 818 раз)

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

Оффлайн slava3432

  • Автор темы
  • Новичок
  • *
  • Сообщений: 2
    • Просмотр профиля
Не получается установить MySQL
« : 26 Сентябрь 2020, 22:18:41 »
Народ, помогите пожалуйта, решил поставить сервер в КС на Ubuntu, только начал с ней знакомство и при попытки создать mySql базу он выдает ошибку. Помогите пожалуйста
root@v082kat6nkekvm27i:~# sudo apt-get install mysql-server mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.4) ...
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
2020-09-26T19:14:50.239030Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
* mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: exit-code) since Sat 2020-09-26 22:14:52 MSK; 15ms ago
    Process: 5403 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
« Последнее редактирование: 26 Сентябрь 2020, 22:32:06 от slava3432 »

Оффлайн Aleksandru

  • СуперМодератор
  • Старожил
  • *
  • Сообщений: 2841
    • Просмотр профиля
Re: непон
« Ответ #1 : 26 Сентябрь 2020, 22:21:31 »
Измените название темы на более информативное, иначе тема будет закрыта:
Цитировать
Правила форума
2. На форуме ЗАПРЕЩЕНО
2.6. Создавать темы с неинформативным названием, например «Помогите», «Пара вопросов», «Настройка Интернета» и т. п.

--Aleksandru
Intel Core i3-3240 3.40GHz, GeForce GT 1030, MSI H61M-P20, 8GB RAM, KINGSTON SV300S37A240G, Kubuntu 20.04

Оффлайн kac

  • Активист
  • *
  • Сообщений: 384
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #2 : 26 Сентябрь 2020, 22:53:53 »
1. /var/log/mysql/error.log что туту?
2. mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Попробуй sudo apt-get install -f
Возможно что то не доставило.

Оффлайн slava3432

  • Автор темы
  • Новичок
  • *
  • Сообщений: 2
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #3 : 26 Сентябрь 2020, 22:58:37 »
1. /var/log/mysql/error.log что туту?
2. mysql-client is already the newest version (8.0.21-0ubuntu0.20.04.4).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.4).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Попробуй sudo apt-get install -f
Возможно что то не доставило.
2020-09-26T16:32:14.429549Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) initializing of server in progress as process 2845
2020-09-26T16:32:14.446980Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-09-26T16:32:14.531592Z 1 [Warning] [MY-012637] [InnoDB] 1048576 bytes should have been written. Only 692224 bytes written. Retrying for the remaining bytes.
2020-09-26T16:32:14.531792Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2020-09-26T16:32:14.531951Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibdata1 failed at offset 1048576, 1048576 bytes should have been written, only 692224 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.
2020-09-26T16:32:14.532076Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device'
2020-09-26T16:32:14.532308Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibdata1'. Probably out of disk space
2020-09-26T16:32:14.532452Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2020-09-26T16:32:15.024466Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:32:15.024706Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-26T16:32:15.024886Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:32:15.025709Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:32:15.655583Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 2865
2020-09-26T16:32:15.721543Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:32:15.721738Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:32:15.721884Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:32:15.727260Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:33:10.885282Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3120
2020-09-26T16:33:10.943173Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:33:10.943386Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:33:10.943531Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:33:10.954708Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T16:48:45.576647Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3375
2020-09-26T16:48:45.639754Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T16:48:45.640008Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T16:48:45.640150Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T16:48:45.649007Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:05:17.636930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3559
2020-09-26T17:05:17.735834Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:05:17.736132Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:05:17.736257Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:05:17.743304Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:46:47.981306Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3815
2020-09-26T17:46:48.020278Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:46:48.020521Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:46:48.020642Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:46:48.027316Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:47:12.892517Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3995
2020-09-26T17:47:12.939403Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:47:12.939654Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:47:12.939807Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:47:12.949035Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T17:47:55.172334Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4179
2020-09-26T17:47:55.225897Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T17:47:55.226231Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T17:47:55.226391Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T17:47:55.234828Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:07:28.351509Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4727
2020-09-26T19:07:28.406453Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:07:28.406719Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:07:28.406839Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:07:28.413808Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:08:51.606667Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 4964
2020-09-26T19:08:51.664911Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:08:51.665203Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:08:51.665336Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:08:51.671520Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:08:57.265157Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 5143
2020-09-26T19:08:57.298777Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:08:57.299021Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:08:57.299155Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:08:57.305653Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).
2020-09-26T19:14:50.200513Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 5346
2020-09-26T19:14:50.238626Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-26T19:14:50.238826Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-26T19:14:50.238948Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-26T19:14:50.245136Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4)  (Ubuntu).

Оффлайн AlexDem

  • Активист
  • *
  • Сообщений: 465
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #4 : 26 Сентябрь 2020, 22:59:56 »
Народ, помогите пожалуйта, решил поставить сервер в КС на Ubuntu, только начал с ней знакомство и при попытки создать mySql базу он выдает ошибку. Помогите пожалуйста
Если не получится поставить, то ставь MariaDB, тоже отличный MySQL сервер, я как раз на нем работаю.

Оффлайн kac

  • Активист
  • *
  • Сообщений: 384
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #5 : 26 Сентябрь 2020, 23:01:59 »
Failed to find valid data directory.
Data Dictionary initialization failed
Явно установка некорректна.
Пробуйте переустановить. Или доставить нужные пакеты.

Пользователь добавил сообщение 26 Сентябрь 2020, 23:03:00:
Если не получится поставить, то ставь MariaDB, тоже отличный MySQL
+
Тоже вариант.

Оффлайн jura12

  • Старожил
  • *
  • Сообщений: 1407
  • 20.04
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #6 : 26 Сентябрь 2020, 23:04:11 »
Цитировать
Error number 28 means 'No space left on device'
места нет. квоты мешают.
сопротивление бесполезно

Оффлайн dm999

  • Участник
  • *
  • Сообщений: 120
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #7 : 27 Сентябрь 2020, 00:30:06 »
MariaDB это теперь вроде как то же, что и MySQL

Оффлайн AlexDem

  • Активист
  • *
  • Сообщений: 465
    • Просмотр профиля
Re: Не получается установить MySQL
« Ответ #8 : 27 Сентябрь 2020, 09:57:26 »
MariaDB это теперь вроде как то же, что и MySQL
не теперь, а оно же всегда так и было

 

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