cid:5c0fb3e45b38e1114 missing file - frequent timeout

[Cris00]

Hello,

In the last days we encounter long timeouts of Espo and today we looked in the server logs and it appears that there are some missing files like:

2021-02-08 08:18:39.198822 [INFO] [302413] [66.249.81.231:44927#APVH_WEBSITE.ro:443] File not found [/home/WEBSITEro/public_html/crm/cid:5c0fb3e45b38e1114]

2021-02-08 07:56:46.919205 [INFO] [7836] [84.232.202.77:61478:HTTP2-1#APVH_WEBSITE.ro:443] File not found [/home/WEBSITEro/public_html/crm/cid:57d287b54875c4ea4]


Do you have any ideas about this error and how can we fix it?

Thank you!

[Cris00]

After talking with the hosting support they also told me that the CRM uses way too much resources. I do not know if this is related.

[item]

Hello,
Yes that can.. certainly.
You can give you shared hosting configuration ?
php ? ram ? hdd type ? processor ? linux version ? mysql version ?
Have you many record ?
we have 6500000 record on one table with 10 related table for each record, but we have asked for a SSD, more ram, last php, and tunning some nginx config, ...

[Cris00]

Hello,
Yes that can.. certainly.
You can give you shared hosting configuration ?
php ? ram ? hdd type ? processor ? linux version ? mysql version ?
Have you many record ?
we have 6500000 record on one table with 10 related table for each record, but we have asked for a SSD, more ram, last php, and tunning some nginx config, ...

Thanks for the reply. The hosting has 2 CPU x 2 GB ram with 50 entry processes. They say that the CRM seems it needs 3-4 CORE cpu. Input/Output, of 40MB/s. We have around 100-200 email/day and we use it for several years now.

[murugappan]

From your configuration, sounds way too small. Also you need to fine tune the MySQL/MariaDB instance. I went through a few cycles fine tuning before i got the cloud provider to configure correctly.

[item]

Hello,
email is really i think the more consumpting ressource (many many relation) .
so what you give as information :
you need ask to have SSD hardDisk (or more fast). (we from HDD to SSD => win 4x time)
we are on 4GB ram ..

after need some tunning => nginx/apache .. mysql .. add some index .. do the trick

here you can see how SSD change speed. I have make many post in forum with this issue, you can search .. (provider have installed custom app for see .. )
https://forum.espocrm.com/forum/gene...-speed-espocrm

[esforim]

Is it only an issue that you notice in EspoCRM v6.1? or even before then?

If it 6.1 or higher, there is quite a few user that experience terrible speed (including myself) at the moment. Discussion is mostly in the v6.1 thread and a few post got split off with murugappan issue. See this thread here to keep up to date: https://forum.espocrm.com/forum/inst...data-truncated

Various discussion was posted in the v6.1 thread: https://forum.espocrm.com/forum/anno...-1-0-released/

[item]

Hello,

juste for sample .. my server :

Manufacturer
Supermicro
Model
Super Server
CPU
20 CPUs x Intel(R) Xeon(R) Silver 4114T CPU @ 2.20GHz
Memory
127.51 GB

I have many VM.. windows, centos7, centos8, debian ... many applications..

Yes, for a CRM .. you need a good server.

For problem, it's easy to put in some file $log->('sql') and see what's append... i have always do that because i have full control of all.
Whitout information about your environment, nobody can responds ..

And yes, i have epsoCRM 5.9.x and 6.1.x

edit : https://www.exabytes.com/hosting/vps-hosting
VPS with 0,5Gb ram !? it's a joke (and not forget, it's shared .. not dedicaced)

[Cris00]

Hello,
email is really i think the more consumpting ressource (many many relation) .
so what you give as information :
you need ask to have SSD hardDisk (or more fast). (we from HDD to SSD => win 4x time)
we are on 4GB ram ..

after need some tunning => nginx/apache .. mysql .. add some index .. do the trick

here you can see how SSD change speed. I have make many post in forum with this issue, you can search .. (provider have installed custom app for see .. )
https://forum.espocrm.com/forum/gene...-speed-espocrm

Thanks. We have SSD.

[Cris00]

Is it only an issue that you notice in EspoCRM v6.1? or even before then?

If it 6.1 or higher, there is quite a few user that experience terrible speed (including myself) at the moment. Discussion is mostly in the v6.1 thread and a few post got split off with murugappan issue. See this thread here to keep up to date: https://forum.espocrm.com/forum/inst...data-truncated

Various discussion was posted in the v6.1 thread: https://forum.espocrm.com/forum/anno...-1-0-released/

Thanks. We have 5.9.4.

[item]

https://forum.espocrm.com/forum/announcements/66733-espocrm-6-1-0-released?p=67358#post67358

[esforim]

v5.9.4 worked great for me so I don't have much experience in relation to the slowdown, there was one time where there were too much process at one time and it hit my server capacity so I had to upgrade to a higher package though (we use shared hosting)

[Cris00]

https://forum.espocrm.com/forum/anno...7358#post67358

Should this apply to our version too?

[murugappan]

Cris00 if it is regarding the collation and if you had created your instance of espocrm before version 6.0.8 (i guess), then, yes, it applies to your version as well.

[Cris00]

Cris00 if it is regarding the collation and if you had created your instance of espocrm before version 6.0.8 (i guess), then, yes, it applies to your version as well.

Should all be modified? Or only part of them?

[murugappan]

It will be best you do it on all those entities that you have created in your instances of Espocrm. I did that. It works fine now.