HTTP ERROR 500
Unable to access CRM. HTTP ERROR 500
Original question is available on version: ru
Answers:
Good afternoon.
Judging by the errors, you are running out of space on the server. After that, it was overloaded, several times.
All this led to the fact that the database was damaged:
170404 0:11:12 [ERROR] mysqld: Table './db_ultraalfashi/searchproduct' is marked as crashed and should be repaired
170404 0:11:12 [Warning] Checking table: './db_ultraalfashi/searchproduct'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchorder' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchorder'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchbrand' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchbrand'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchcategory' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchcategory'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchstandard' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchstandard'
You need to restore the database.
We can restore - 1 hour.
So that the logs do not grow, I propose to set up the rotation of the logs,
logs will be compressed and stored for the last 20 days, older ones will be deleted
We can set up - 1 hour.
Judging by the errors, you are running out of space on the server. After that, it was overloaded, several times.
All this led to the fact that the database was damaged:
170404 0:11:12 [ERROR] mysqld: Table './db_ultraalfashi/searchproduct' is marked as crashed and should be repaired
170404 0:11:12 [Warning] Checking table: './db_ultraalfashi/searchproduct'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchorder' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchorder'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchbrand' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchbrand'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchcategory' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchcategory'
170404 1:01:11 [ERROR] mysqld: Table './db_ultraalfashi/searchstandard' is marked as crashed and should be repaired
170404 1:01:11 [Warning] Checking table: './db_ultraalfashi/searchstandard'
You need to restore the database.
We can restore - 1 hour.
So that the logs do not grow, I propose to set up the rotation of the logs,
logs will be compressed and stored for the last 20 days, older ones will be deleted
We can set up - 1 hour.
30.11.2020, 12:05
Original comment available on version: ru
Thanks for the answer! Let's do it urgently. And restoration and setup of dens. Ready to pay.
30.11.2020, 12:20
Original comment available on version: ru
Is it also possible to configure the deletion of old prices (we have automatic rules for loading suppliers' prices) from the system, apparently, they also accumulate and take up a lot of space
30.11.2020, 12:21
Original comment available on version: ru
Good afternoon.
The database is restored, the box is working.
Log rotation is configured, log files for the last 20 days will remain.
Updated server software to the latest version.
Shevelev Ivan
Client wrote:
Is it possible to also configure the removal of old price lists
Removed 230,000 import files, leaving files from the last 18 days.
Every day, the import files will be deleted, the files from the last 20 days will remain.
The database is restored, the box is working.
Log rotation is configured, log files for the last 20 days will remain.
Updated server software to the latest version.
Shevelev Ivan
Client wrote:
Is it possible to also configure the removal of old price lists
Removed 230,000 import files, leaving files from the last 18 days.
Every day, the import files will be deleted, the files from the last 20 days will remain.
30.11.2020, 14:57
Original comment available on version: ru
Good day!
Today the same problem has arisen!
Help to solve the terminology with the problem!
Dyakuyu!
Today the same problem has arisen!
Help to solve the terminology with the problem!
Dyakuyu!
10.12.2020, 14:38
Original comment available on version: ru
Dovganovsky Vadim Petrovich
Client wrote:
Good day!
Today the same problem has arisen!
Help to solve the terminology with the problem!
Dyakuyu!
already working, as it turned out they were updating the system.
You know the food.
10.12.2020, 14:52
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
