[Spce-user] mariadb 300% CPU no queries

[Jon Bonilla (Manwe)]

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.


cheers,

Jon


-- 
PekePBX, the multitenant PBX solution
https://pekepbx.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pidstat.png
Type: image/png
Size: 365587 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210203/301c4439/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: processlist.png
Type: image/png
Size: 89713 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210203/301c4439/attachment-0003.png>
-------------- 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/301c4439/attachment-0001.sig>