[solved ] Issue - system works slowly ...

[rslemer]

My users dashboard is very slowly today

I found this message in httpd log

Wed Aug 14 09:42:24 2019] [error] [client 192.168.1.103] PHP Fatal error:  Uncaught WebServiceException: Erro na base de dados ao executar a opera\xc3\xa7\xc3\xa3o solicitada in /usr/share/coreBOS/corebos-master/include/Webservices/VtigerModuleOperation.php:61
Stack trace:\n#0 /usr/share/coreBOS/corebos-master/include/Webservices/Retrieve.php(59): VtigerModuleOperation->retrieve('39x978838')
#1 /usr/share/coreBOS/corebos-master/modules/com_vtiger_workflow/VTEntityCache.inc(25): vtws_retrieve('39x978838', Object(Users))
#2 /usr/share/coreBOS/corebos-master/modules/com_vtiger_workflow/VTEntityCache.inc(116): VTWorkflowEntity->__construct(Object(Users), '39x978838', false)
#3 /usr/share/coreBOS/corebos-master/modules/com_vtiger_workflow/VTEventHandler.inc(42): VTEntityCache->forId('39x978838')
#4 /usr/share/coreBOS/corebos-master/include/events/VTEventTrigger.inc(146): VTWorkflowEventHandler->handleEvent('vtiger.entity.a...', Object(VTEntityData))
#5 /usr/share/coreBOS/corebos-master/include/events/VTEventsManager.inc(114): VTEventTrigger->trigger(Object(VTEntityData))
#6 /usr/share/coreBOS/corebos in /usr/share/coreBOS/corebos-master/include/Webservices/VtigerModuleOperation.php on line 61
referer: http://xxx:5000/index.php?module=cbCalendar&action=ListView&viewname=13

This means a error in filter or in workflow?

I not change anything in workflow, but user changes a filter yesterday ...

I will try ask what kind of changes user did ...

How I can tracked and solved that?

[joebordes]

that looks like an SQL error, those usually appear in the coreBOS log file if you set the level to DEBUG, try that see if you can catch the error there, that should tell us what is going on.
Anyway, that shouldn't be the reason for the slowness. When was the last time you rebooted the server? MySQL tends to have strayed processes that never end making the system slow down after some time. We usually reboot our servers every few weeks, just to keep things clean.

[rslemer]

I will try restart a mysql server, thanks !

[rslemer]

I restart mysql server, and works

perhaps any resources is not released ...

thanks!