The procedure hangs and does not work out to the end and there are no messages, the transition buttons are not gray

If at some time everything is fine and at some time it is not, then most likely at night you have problems with the load on the server. Come to the server at night, see what happens with the load. If I remember everything correctly, a few weeks ago Igor wrote to you about some problems with the hardware on the server, have they been fixed?

[quote] Bodyako Dmitry Employee wrote: If at some time everything is fine and at some time it is not, then most likely at night you have problems with the load on the server. Come to the server at night, see what happens with the load. If I remember everything correctly, a few weeks ago Igor wrote to you about some problems with the hardware on the server, have they been fixed? [/quote] Yes, fixed it, everything is working fine now How can you catch what's wrong?

[quote] Bodyako Dmitry Employee wrote: Firstly, you just need to go to the server at the moment of stupidity and see what the load is in htop, then look at the results [/quote] Okay, let's try, and secondly? :)

and secondly, it will be necessary to act already depending on the results obtained)

[quote] Bodyako Dmitry Employee wrote: and secondly, it will be necessary to act already depending on the results obtained) [/quote] Now hang again Here is the process https://baza.cn.ua/admin/customorder/order/24685/edit/ I press the procedure button and everything hangs stupidly and the status buttons are gray https://prnt.sc/v2di7k Have a look, please

You really have something with iron. It was not the procedure that worked out, but I could not even enter the box, its server did not give it to the browser. At that moment, there was no load on the server itself at all

[quote] Bodyako Dmitry Employee wrote: You really have something with iron. It was not the procedure that worked out, but I could not even enter the box, its server did not give it to the browser. At that moment, there was no load on the server itself at all [/quote] Well, you still came in, and what did htop show?

It showed that there was no load on the server, but at that time the server did not give the box page. Well, I wrote, I didn’t write clearly enough, Vlad?

[quote] Bodyako Dmitry Employee wrote: It showed that there was no load on the server, but at that time the server did not give the box page. Well, I wrote, I didn’t write clearly enough, Vlad? [/quote] Here is the response from the TP hosting https://prnt.sc/v2h0uc Well, what can be done next?

Here is another answer from TP https://prnt.sc/v2hj4c As I understand it, there is a problem with the database, and as I understand it, the TP is that someone poorly configured the VPS, as an argument there is no log, although it is registered in the config. How can you help?

I can only help you with something within my competence - boxing. I don't see any boxing problems here.

[quote] Bodyako Dmitry Employee wrote: I can only help you with something within my competence - boxing. I don't see any boxing problems here. [/quote] Again there was some kind of "provison" I couldn’t go into boxing at all I wrote to the hosting so that they could see what was there Here's what they said https://prnt.sc/v30wew What can be done ?

There is nothing useful in this post. cronque.sh is a cron collector that "rebuilds" the list of crons needed to run, it cannot break anything on the server

If it was boxing that caused these freezes, then it would be not only on your server, but stupidly for everyone, it’s immediately obvious that the problem on your particular box means a jamb in the server (now everything is fine, but after half an hour everything is stupid - and the code works the same way that half an hour ago and now, it means something is happening with the server on which this code is running)

[quote] Bodyako Dmitry Employee wrote: If it was boxing that caused these freezes, then it would be not only on your server, but stupidly for everyone, it’s immediately obvious that the problem on your particular box means a jamb in the server (now everything is fine, but after half an hour everything is stupid - and the code works the same way that half an hour ago and now, it means something is happening with the server on which this code is running) [/quote] I agree with your logic How can I prove this to the hoster, they say that everything is fine with them?

Unfortunately, I do not have experience in communicating with hosters to help you with drafting an appeal to them.

[quote] Bodyako Dmitry Employee wrote: Unfortunately, I do not have experience in communicating with hosters to help you with drafting an appeal to them. [/quote] The hoster analyzed the operation of the server Here is the conclusion: Right now I see that the server has failed in swap by 1.2GB. Those. its used swap file is almost the same size as RAM. KiB Mem : 1873912 total, 168868 free, 1347888 used, 357156 buff/cache ^^^^^^^^^^^^^ KiB Swap: 2621432 total, 1399812 free, 1221620 used. 416200 availMem ^^^^^^^^^^^^^^ This is not a normal state. Ideal - when the swap file is not used. Permissible - when less than a quarter of the amount of RAM is used. Rebooted mysql - paging file usage dropped by 4/5. did # swapoff -a ; swapon The server unloaded the swap into memory, and reset it to zero. Those. top now looks like this KiB Mem : 1873912 total, 198040 free, 1049884 used, 625988 buff/cache KiB Swap: 2621432 total, 2621432 free, 0 used. 565292 availMem Conclusion - mysql is configured to work in a system where there is significantly more than 2G of RAM, and tries to keep too much information in memory (in the cache), so that the cache ends up on disk. And from this presence of a cache it only gets worse. Conclusion: It is necessary to configure mysql in the direction of reducing the size of the cache. It turns out that the server is somehow incorrectly configured, that is, the database itself 1. Why is this done and what can be done? 2. Perhaps this is somehow connected with the procedure that I run https://baza.cn.ua/admin/shop/workflow/9/procedure/49/?status=0? Since she has been working for a very long time and can it somehow influence this?

The number of operatives that the database can use for itself is configured on the server itself in the database settings. If you need our system administrator to reconfigure the database, you need a task for him, this is 1 hour.

[quote] Bodyako Dmitry Employee wrote: The number of operatives that the database can use for itself is configured on the server itself in the database settings. If you need our system administrator to reconfigure the database, you need a task for him, this is 1 hour. [/quote] The question here is whether you configured everything correctly when you last reconfigured, since the hoster claims that something is wrong there, the database is somehow greedily eating + something is not clear with the cache, or did you set everything up correctly?

One and a half GB of RAM is not greedy. On the server where our box is located, for example, the base eats about 50GB of RAM. The problem is that you only have one and a half GB of RAM.