Stuck Long MySQL search queries

jaehdawg

HelloOccasionally, I notice that osticket fails to fetch emails and responds slowly. The only resolution is to reboot the server. What I have noticed:- running top, mysqld is taking all the CPU- logging into mysql as root and running show processlist shows there are hundreds of stuck search queries, some are repeats like someone got frustrated at a slow search and mashed search a lot of times.Has anyone else experienced this? or attempted to create sometime to kill long mysql queries?

ntozier

I've never seen this behavior.

jaehdawg

I will post the show processlist from mysql when it happens again... but the attached screenshot is what happens to the CPU..

Screen Shot 2015-12-17 at 2.23.17 PM.png

bnw

i have this problem too!

It looks like if you begin to search for a keyword and not an email address or ticket number instead!

this was also a big problem for me at a time when my tickets had a mix between numbers and letters like S233123 or C123123.

I have not found the Error yet but i can reproduce this by entering Error or something like this in the Search mask