Михаил Турунов написал: Обновлена виртуальная машина до 7,5,0SQL 8.0перестал работать поиск по КПпо какой-то непонятной причине система потребовала переиндексацию сайтапосле переиндексации всех сайтов поиск заработалоднако наблюдаю такое сообщение пока переключил Полнотекстовый поиск на Битриксаналогичная проблема на второй также обновленной машине.на одной из машин удалил Sphinks и более не смог его установить, ошибки, пришлось откатыватьсякак решать эту проблему?
Поддерживаю, тоже такая же ошибка на 7,5,0SQL 8 Sphinks не работает после удаления не ставиться
Дмитрий Смольский написал: не стартует Mysql 8[Bitrix\Main\DB\ConnectionException] Mysql connect error [localhost]: (2002) Connection refused (400)/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection .php:65#0: Bitrix\Main\DB\MysqliConnection->connectInternal() /home/bitrix/www/bitrix/modules/main/lib/data/connection.php:53...Была подобна хрень. Начало кода такое же. Просто у меня после обновления до 8й версии мускул не запустился сам, стартанул службу вручную (подозрительно долго запускалась, около 2 минут) и все заработало, после перегрузил сервер что бы убедиться в работе - все нормально.Единственное, тормоза начались в загрузке страниц портала после обновления до php 7.4 и mysql 8. Частично решил их очисткой кэша, после пошло быстрее, но в любом случае ранее до обновления было быстрее. Возможно еще что-то изменить нужно.
в моем случае закончилось место в /dev/mapper/centos-root , увеличил раздел перегрузил Mysql 8 и все заработало
Евгений Костюк написал: На скриншоте указано в какиих журналах можно посмотреть ошибку конкретнее. А так же советую посмотреть что в логах: /var/log/mysql/error.log
Скрытый текст
2021-04-05T16:47:08.494730Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 11534336, 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. 2021-04-05T16:47:08.495001Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T16:47:08.495498Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T16:47:08.495741Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T16:47:08.496018Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T16:47:12.786440Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T16:47:12.787106Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T16:47:12.787951Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T16:47:12.789947Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f. 2021-04-05T17:16:37.172750Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:16:37.172763Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:16:37.430543Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T17:16:37.432356Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 6505 2021-04-05T17:16:37.434099Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T17:16:37.434136Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2021-04-05T17:16:37.449331Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-04-05T17:16:41.347729Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed. 2021-04-05T17:16:41.348011Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed 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. 2021-04-05T17:16:41.348346Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T17:16:41.348858Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T17:16:41.349161Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T17:16:41.349437Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T17:16:45.595019Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T17:16:45.595713Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T17:16:45.596658Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T17:16:45.597893Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f. 2021-04-05T17:19:38.660846Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:19:38.660860Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:19:38.907477Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be 2021-04-05T17:22:05.139752Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:22:05.139773Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:22:05.444925Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T17:22:05.446913Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 1374 2021-04-05T17:22:05.451011Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T17:22:05.451550Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2021-04-05T17:22:05.479545Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-04-05T17:22:10.535907Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed. 2021-04-05T17:22:10.536497Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 1048576, 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. 2021-04-05T17:22:10.536769Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T17:22:10.537223Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T17:22:10.537458Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T17:22:10.537729Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T17:22:14.788476Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T17:22:14.789015Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T17:22:14.789529Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T17:22:14.791456Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f. 2021-04-05T17:29:02.220487Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:29:02.220508Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:29:02.503845Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T17:29:02.507363Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 1366 2021-04-05T17:29:02.513127Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T17:29:02.513767Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2021-04-05T17:29:02.555108Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-04-05T17:29:07.427563Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed. 2021-04-05T17:29:07.428062Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed at offset 1048576, 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. 2021-04-05T17:29:07.428324Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T17:29:07.428850Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T17:29:07.429100Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T17:29:07.429360Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T17:29:11.728484Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T17:29:11.729446Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T17:29:11.730439Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T17:29:11.733849Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f. 2021-04-05T17:38:47.152733Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:38:47.152747Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:38:47.393542Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T17:38:47.395748Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 2981 2021-04-05T17:38:47.397401Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T17:38:47.397442Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2021-04-05T17:38:47.411262Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-04-05T17:38:51.138226Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed. 2021-04-05T17:38:51.138504Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed 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. 2021-04-05T17:38:51.138783Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T17:38:51.139256Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T17:38:51.139521Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T17:38:51.139808Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T17:38:55.446430Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T17:38:55.446906Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T17:38:55.447477Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T17:38:55.448605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f. 2021-04-05T17:43:13.185158Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T17:43:13.185172Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T17:43:13.425715Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T17:43:13.427822Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 3295 2021-04-05T17:43:13.429366Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T17:43:13.429417Z 0 [Warning]2021-04-05T18:32:55.479220Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 28767) 2021-04-05T18:32:55.479244Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 4952 (requested 14336) 2021-04-05T18:32:55.765496Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2021-04-05T18:32:55.767676Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-13) starting as process 1356 2021-04-05T18:32:55.775466Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2021-04-05T18:32:55.775948Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2021-04-05T18:32:55.812649Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2021-04-05T18:33:00.911662Z 1 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed. 2021-04-05T18:33:00.912193Z 1 [ERROR] [MY-012639] [InnoDB] Write to file ./ibtmp1 failed 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. 2021-04-05T18:33:00.912488Z 1 [ERROR] [MY-012640] [InnoDB] Error number 28 means 'No space left on device' 2021-04-05T18:33:00.913083Z 1 [ERROR] [MY-012267] [InnoDB] Could not set the file size of './ibtmp1'. Probably out of disk space 2021-04-05T18:33:00.913330Z 1 [ERROR] [MY-012926] [InnoDB] Unable to create the shared innodb_temporary. 2021-04-05T18:33:00.913610Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2021-04-05T18:33:05.198875Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2021-04-05T18:33:05.199378Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2021-04-05T18:33:05.200118Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-05T18:33:05.202008Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-13) Percona Server (GPL), Release 13, Revision 6f7822f.
Ошибка записи в файл ./ibtmp1 место закончилось и как его почистить ?
Олег Зайцев написал: Обновил в начале php до 7.4, MySQL осталась 5.7, производительность конфигурации выросла с 25-28, до 38-40. Затем обновил MySQL до 8, производительность упала до 10 и База данных MySQL (запись) с 5700 до 140.В файл /etc/mysql/conf.d/z_bx_custom.cnf добавил запись sync_binlog = 0Производительность поднялась до 30, База данных MySQL (запись) до 3040Так же добавил туда же запись transaction-isolation = READ-COMMITTED, но Монитор производительности: сервер БД так и показывает красным что значение transaction-isolation пусто.
Алексей Шафранский написал: Цитата Юрий Коренюк написал:обновился до 7.5 что с этим делать подскажите скрин Юрий Коренюк , наКодerror: file /etc/ansible/roles/mysql/tasks/upgrade_mysql.yml: No such file or directoryне обращать внимания, нет такого файла больше) по двум другим у себя не видел такого) наверно тоже, простить и отпустить))
Mikrotik RB952UI-5AC2ND hAP ac lite не пробрасывается 443 порт, Думаю это очень хороший модем для сервера Mikrotik RB952UI-5AC2ND hAP ac lite, 2.4GHz b/g/n, 5GHz a/n/ac, CPU 650MHz, 64MB DDR R, но настроить 443 порт никак не могу!
Ваш процессор работает в режиме сохранения энергии, то есть он все время понижает частоту процессора, что бы он якобы не сильно грелся и зря не расходовал энергию.
Режимы бывают
powersave — энергосберегающий (вообще всё тормозит, всегда. Часто та постоянно внизу.)
ondemand — меняет частоту по требованию
performance — максимальная частота всегда.
Если что-то подобное в BitrixENV ? и если да то в какой директории править эти параметры.
Centos 6.8 + BitrixENV низкая производительность на SSD
Успешно 2018-Mar-30 09:14:45 Отправка почты (check_mail): Warning Замечание. Отправлено. Время отправки: 1.04 сек. 2018-Mar-30 09:14:47 Отправка почтового сообщения больше 64Кб (check_mail_big): Fail Ошибка! Не работает 2018-Mar-30 09:14:47 Проверка на наличие неотправленных сообщений (check_mail_b_event): Ok
BitrixVM 7.2.2 не отправляются сообщения больше 64Кб