Не могу установить - mysql start failed

[finnster]

Здравствуйте. Нужна помощь. Пытаюсь установить Vesta CP на VPS. ОС - Debian 7 64b. Многократно пытаюсь)
В одном и том же месте происходит ошибка.

Code: Select all

Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h servonets password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

 System start/stop links for /etc/init.d/mysql already exist.
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Error: mysql start failed

Собственно, установка обрывается. Как с этим бороться? Буду благодарен за помощь.

[prodimon]

тоже самое и у меня
устанавливал на чистых OC debian
с разным RAM от 128 до 512
виртуализация openvz

кто то рекомендовал в файле my.cnf прописать
innodb_use_native_aio=0
но оно не помогает.

проверьте пожалуйста да исправьте косяк.

лог ошибок

Code: Select all

141117 12:26:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141117 12:26:38 [Note] Plugin 'FEDERATED' is disabled.
141117 12:26:38 InnoDB: The InnoDB memory heap is disabled
141117 12:26:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141117 12:26:38 InnoDB: Compressed tables use zlib 1.2.7
141117 12:26:38 InnoDB: Using Linux native AIO
141117 12:26:38 InnoDB: Initializing buffer pool, size = 128.0M
141117 12:26:38 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
141117 12:26:39 InnoDB: Could not open or create data files.
141117 12:26:39 InnoDB: If you tried to add new data files, and it failed here,
141117 12:26:39 InnoDB: you should now edit innodb_data_file_path in my.cnf back
141117 12:26:39 InnoDB: to what it was, and remove the new ibdata files InnoDB created
141117 12:26:39 InnoDB: in this failed attempt. InnoDB only wrote those files full of
141117 12:26:39 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
141117 12:26:39 InnoDB: remove old data files which contain your precious data!
141117 12:26:39 [ERROR] Plugin 'InnoDB' init function returned error.
141117 12:26:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141117 12:26:39 [ERROR] Unknown/unsupported storage engine: InnoDB
141117 12:26:39 [ERROR] Aborting

141117 12:26:39 [Note] /usr/sbin/mysqld: Shutdown complete

141117 12:26:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[imperio]

Проверю

PS:
Не воспроизводится. На тестовой машине с Debian 7 x64 установка прошла успешно.

[keyoff]

есть глюк...
воспроизводится на vps c заниженным fs.aio-max-nr который поменять не всегда получается из-за политики хоста на котром крутятся vps

решение:

1. ручками выкачать vst-install-debian.sh
2. пропатчить vst-install-debian.sh
добавить

Code: Select all

read -p "waiting my.conf..."  

после

Code: Select all

service mysql stop > /dev/null 2>&1 

это гдето в районе 615 строки

3. запустить vst-install-debian.sh
4. на паузе с сообщением "waiting my.conf..." добавить в раздел [mysqld] файла /etc/mysql/my.cnf
строку

Code: Select all

innodb_use_native_aio = 0 

5. нажать ентер в консоли выполнения vst-install-debian.sh