- Главная Список форумов Обсуждение Open Server
- Поиск
-
- Текущее время: 16 фев 2025, 05:59
- Часовой пояс: UTC+03:00
Видимо у вас одного, у остальных только при первом запуске пока файлы не будут созданы автоматически.vasya_pupkin писал(а):Данные сообщения появляются при каждом старте/рестарте сервера.
InnoDB: Cannot open 'd:\openserver\userdata\MySQL-5.7\ib_buffer_pool' for reading: No such file or directoryFor more information, see Help and Support Center at http://www.mysql.com.действительно появляется только при первом запуске. При повторных её нет. Но есть другая
Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'For more information, see Help and Support Center at http://www.mysql.com.Вот эта ошибка появляется при каждом запуске или перезапуске сервера.
2016-03-31T22:05:04.595385Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2016-03-31T22:05:04.595385Z 0 [Note] d:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe (mysqld 5.7.11) starting as process 11092 ... 2016-03-31T22:05:04.600385Z 0 [ERROR] Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided' 2016-03-31T22:05:04.601385Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-03-31T22:05:04.601385Z 0 [Note] InnoDB: Uses event mutexes 2016-03-31T22:05:04.601385Z 0 [Note] InnoDB: Memory barrier is not used 2016-03-31T22:05:04.601385Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-03-31T22:05:04.602385Z 0 [Note] InnoDB: Number of pools: 1 2016-03-31T22:05:04.602385Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-03-31T22:05:04.646388Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2016-03-31T22:05:04.709391Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-03-31T22:05:04.768395Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-03-31T22:05:04.923404Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-03-31T22:05:04.923404Z 0 [Note] InnoDB: Setting file 'd:\openserver\userdata\MySQL-5.7\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-03-31T22:05:05.170418Z 0 [Note] InnoDB: File 'd:\openserver\userdata\MySQL-5.7\ibtmp1' size is now 12 MB. 2016-03-31T22:05:05.172418Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-03-31T22:05:05.172418Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-03-31T22:05:05.233421Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 8703593 2016-03-31T22:05:05.234421Z 0 [Note] InnoDB: Loading buffer pool(s) from d:\openserver\userdata\MySQL-5.7\ib_buffer_pool 2016-03-31T22:05:05.234421Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-03-31T22:05:05.415432Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-03-31T22:05:05.415432Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2016-03-31T22:05:05.416432Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2016-03-31T22:05:05.416432Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2016-03-31T22:05:05.529438Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160401 1:05:05 2016-03-31T22:05:05.670446Z 0 [Note] Event Scheduler: Loaded 0 events 2016-03-31T22:05:05.670446Z 0 [Note] d:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe: ready for connections. Version: '5.7.11' socket: '' port: 3306 MySQL Community Server (GPL)В конфиге MySQL-5.7_my.ini в секции [mysqld] я не нашёл ключа keyring_file_data
keyring_file_data="%dprogdir%\\userdata\\temp\\%mysql_driver%_mysql-keyring"Ошибка исчезла!
У меня при запуске ругалось на VCRUNTIME140.dll. Первый запуск выполнялся(дважды). Помогла установка Visual C++ для Visual Studio 2015. После первого запуска они не поставились. Мне только так повезло или баг?Максим писал(а):vi161, вы не выполнили установку msvc++ библиотек, т.е. первый запуск.