Out of disk space
Displays an error that the disk space has probably run out. Although in fact there is still about 40% free space. And the second question is how to archive old processes in the database. Boxing has been operating since 2018. The database in fact now weighs 134Gb. Orders until 2021, roughly speaking, are not needed, can they be somehow sent to the archive? Or do something similar. Boxed version. Or remove them altogether
Original question is available on version: ru
Answers:
Good afternoon.
There is a problem with the database on the server. An error occurs and the system restarts the database service. This is the reason for the problems.
As an example, today from 09 to 11 the database was restarted 14 times.
Aug 4 09:32:00 sale mysqld: 230804 9:31:59 [ERROR] mysqld got signal 6 ;
Aug 4 09:01:50 sale mysqld: 230804 9:01:50 [ERROR] mysqld got signal 6 ;
Aug 4 09:06:29 sale mysqld: 230804 9:06:29 [ERROR] mysqld got signal 6 ;
Aug 4 09:13:31 sale mysqld: 230804 9:13:31 [ERROR] mysqld got signal 6 ;
Aug 4 09:32:00 sale mysqld: 230804 9:31:59 [ERROR] mysqld got signal 6 ;
Aug 4 09:38:06 sale mysqld: 230804 9:38:06 [ERROR] mysqld got signal 6 ;
Aug 4 09:48:02 sale mysqld: 230804 9:48:02 [ERROR] mysqld got signal 6 ;
Aug 4 10:06:48 sale mysqld: 230804 10:06:48 [ERROR] mysqld got signal 6 ;
Aug 4 10:24:46 sale mysqld: 230804 10:24:46 [ERROR] mysqld got signal 6 ;
Aug 4 10:31:43 sale mysqld: 230804 10:31:42 [ERROR] mysqld got signal 6 ;
Aug 4 10:35:08 sale mysqld: 230804 10:35:08 [ERROR] mysqld got signal 6 ;
Aug 4 10:37:02 sale mysqld: 230804 10:37:02 [ERROR] mysqld got signal 6 ;
Aug 4 10:38:40 sale mysqld: 230804 10:38:40 [ERROR] mysqld got signal 6 ;
Aug 4 10:54:07 sale mysqld: 230804 10:54:07 [ERROR] mysqld got signal 6 ;
Aug 4 10:55:15 sale mysqld: 230804 10:55:15 [ERROR] mysqld got signal 6 ;
According to the logs, the problem started on Aug 01 01:25:15.
It is not entirely clear what caused it, perhaps a problem with the disk ....
There is a problem with the database on the server. An error occurs and the system restarts the database service. This is the reason for the problems.
As an example, today from 09 to 11 the database was restarted 14 times.
Aug 4 09:32:00 sale mysqld: 230804 9:31:59 [ERROR] mysqld got signal 6 ;
Aug 4 09:01:50 sale mysqld: 230804 9:01:50 [ERROR] mysqld got signal 6 ;
Aug 4 09:06:29 sale mysqld: 230804 9:06:29 [ERROR] mysqld got signal 6 ;
Aug 4 09:13:31 sale mysqld: 230804 9:13:31 [ERROR] mysqld got signal 6 ;
Aug 4 09:32:00 sale mysqld: 230804 9:31:59 [ERROR] mysqld got signal 6 ;
Aug 4 09:38:06 sale mysqld: 230804 9:38:06 [ERROR] mysqld got signal 6 ;
Aug 4 09:48:02 sale mysqld: 230804 9:48:02 [ERROR] mysqld got signal 6 ;
Aug 4 10:06:48 sale mysqld: 230804 10:06:48 [ERROR] mysqld got signal 6 ;
Aug 4 10:24:46 sale mysqld: 230804 10:24:46 [ERROR] mysqld got signal 6 ;
Aug 4 10:31:43 sale mysqld: 230804 10:31:42 [ERROR] mysqld got signal 6 ;
Aug 4 10:35:08 sale mysqld: 230804 10:35:08 [ERROR] mysqld got signal 6 ;
Aug 4 10:37:02 sale mysqld: 230804 10:37:02 [ERROR] mysqld got signal 6 ;
Aug 4 10:38:40 sale mysqld: 230804 10:38:40 [ERROR] mysqld got signal 6 ;
Aug 4 10:54:07 sale mysqld: 230804 10:54:07 [ERROR] mysqld got signal 6 ;
Aug 4 10:55:15 sale mysqld: 230804 10:55:15 [ERROR] mysqld got signal 6 ;
According to the logs, the problem started on Aug 01 01:25:15.
It is not entirely clear what caused it, perhaps a problem with the disk ....
04.08.2023, 12:26
Original comment available on version: ru
Sergey Vladimirovich
OneBox production wrote:
ug 4 10:55:15 sale mysqld: 230804 10:55:15 [ER
The process reaches 30 Gb of RAM and the process is killed by the system
04.08.2023, 15:58
Original comment available on version: ru
Although there is still almost 180 GB of memory
04.08.2023, 15:58
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
