Евгений Костюк написал: На скриншоте указано в какиих журналах можно посмотреть ошибку конкретнее. А так же советую посмотреть что в логах: /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 место закончилось и как его почистить ?
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.
....
Probably out of disk space
О чем, собственно, многократно упоминается в логе ошибок.
Юрий, подобные простынки для читабельности форума желательно под кат прятать (вставить в виде спойлера).
Здравствуйте с Bitrix virtual appliance version 7.4.2 (на баорту php 7.2) до VMBitrix v7.5.х (php7.4)? Встретили ли какие-то подводные камни, есть ли инструкция?
