[Spce-user] mariadb 300% CPU no queries

[Jon Bonilla (Manwe)]

El Wed, 3 Feb 2021 16:55:37 +0100
"Jon Bonilla (Manwe)" <manwe at sipdoc.net> escribió:

> Hi all
> 
> I had a clean 7.5.6 CE install. Did initial configuration and realized that
> 7.5.7 was out. Run ngcp-upgrade. 
> 
> After the upgrade mysql was using 300% CPU. Nothing in the processlist. 
> 
> Checking with pidstat the threadid  of the 4 threads eating CPU are not listed
> in the processlist. 
> 
> Stopped kamailio-proxy,mediator,rateomat... everything. Enabled general_log...
> there's nothing running queries and CPU 300%. 
> 
> Repeated the same procedure in another server and 300% CPU again.
> 
> I have no idea how to debug this. 
> 
> Attached pidstat and mysql processlist capture.
> 


Answering myself, after some long long time it stops. I did
ngcp-initial-configuration in another pristine server and I have the 300% CPU. 

If I restart mysql in the one upgraded I have the 300% issue back again. Will
try to measure how long it takes to stop.





-- 
PekePBX, the multitenant PBX solution
https://pekepbx.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 833 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210203/0243c0f2/attachment-0002.sig>