100% CPU load

I’m trying to move from my FreePBX 2.11.0.38 Distro (built on CentOS) with Asterisk Ver. 1.8.18.0 to the new Smooze Distro with Asterisk 11. I build a new 32 bit machine using the ISO and followed the instructions from the Wiki for Upgrade from FreePBX-Distro-1.8xx.210.58 to FreePBX-Distro-2.210.62.

Then I used rsync to move all the monitor files from the old machine to the new one, then again on the Voicemail files as instructed in the Wiki.

I didn’t have any problems until I took the old system off-line and put the new system on-line with the old system’s IP address. When it booted it went to 100% CPU load and has stayed there. Now it’s at 100% on the old IP as well.

I’ve checked the password in the cdr_mysql.conf file and they’re the same.

I installed iSymphonyV3 (because I read in one post that it was needed now) then went into the Asterisk Manager Users and clicked on the cxpanel user, submitted it (with no changes) and reloaded as instructed.

I’m not sure what to try next.

   [2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 
'from-internal-xfer' tries to include nonexistent context 
'from-internal-custom'
[2014-09-29 
18:43:22] WARNING[3048] pbx.c: Context 'from-internal-xfer' tries to 
include nonexistent context 'from-internal-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'from-internal-noxfer' tries to 
include nonexistent context 'from-internal-noxfer-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'from-internal-noxfer' tries to 
include nonexistent context 'from-internal-noxfer-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-pstn' tries to include nonexistent context 'from-pstn-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-pstn' tries to include nonexistent context 'from-pstn-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 
'from-internal-noxfer-additional' tries to include nonexistent context 
'from-internal-noxfer-additional-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 
'from-internal-noxfer-additional' tries to include nonexistent context 
'from-internal-noxfer-additional-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'from-internal-additional' tries
 to include nonexistent context 'from-internal-additional-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'from-internal-additional' tries
 to include nonexistent context 'from-internal-additional-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-dial-one' tries to include nonexistent context 'macro-dial-one-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-dial-one' tries to include nonexistent context 'macro-dial-one-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-hangupcall' tries to 
include nonexistent context 'macro-hangupcall-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-hangupcall' tries to 
include nonexistent context 'macro-hangupcall-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-check' tries to 
include nonexistent context 'macro-blkvm-check-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-check' tries to 
include nonexistent context 'macro-blkvm-check-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-clr' tries to 
include nonexistent context 'macro-blkvm-clr-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-clr' tries to 
include nonexistent context 'macro-blkvm-clr-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-set' tries to 
include nonexistent context 'macro-blkvm-set-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-set' tries to 
include nonexistent context 'macro-blkvm-set-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-setifempty' tries 
to include nonexistent context 'macro-blkvm-setifempty-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-blkvm-setifempty' tries 
to include nonexistent context 'macro-blkvm-setifempty-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-simple-dial' tries to 
include nonexistent context 'macro-simple-dial-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-simple-dial' tries to 
include nonexistent context 'macro-simple-dial-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-exten-vm' tries to include nonexistent context 'macro-exten-vm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-exten-vm' tries to include nonexistent context 'macro-exten-vm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-vm' tries to include nonexistent context 'macro-vm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-vm' tries to include nonexistent context 'macro-vm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-block-cf' tries to include nonexistent context 'macro-block-cf-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-block-cf' tries to include nonexistent context 'macro-block-cf-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-setmusic' tries to include nonexistent context 'macro-setmusic-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-setmusic' tries to include nonexistent context 'macro-setmusic-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-dial-confirm' tries to 
include nonexistent context 'macro-dial-confirm-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-dial-confirm' tries to 
include nonexistent context 'macro-dial-confirm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'vm-callme' tries to include nonexistent context 'vm-callme-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'vm-callme' tries to include nonexistent context 'vm-callme-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-dahdi' tries to include nonexistent context 'from-dahdi-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-dahdi' tries to include nonexistent context 'from-dahdi-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-zaptel' tries to include nonexistent context 'from-zaptel-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'from-zaptel' tries to include nonexistent context 'from-zaptel-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-outbound-callerid' tries 
to include nonexistent context 'macro-outbound-callerid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-outbound-callerid' tries 
to include nonexistent context 'macro-outbound-callerid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-user-callerid' tries to 
include nonexistent context 'macro-user-callerid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-user-callerid' tries to 
include nonexistent context 'macro-user-callerid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-privacy-mgr' tries to 
include nonexistent context 'macro-privacy-mgr-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-privacy-mgr' tries to 
include nonexistent context 'macro-privacy-mgr-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-dialout-trunk' tries to 
include nonexistent context 'macro-dialout-trunk-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-dialout-trunk' tries to 
include nonexistent context 'macro-dialout-trunk-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-pincheck' tries to include nonexistent context 'sub-pincheck-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-pincheck' tries to include nonexistent context 'sub-pincheck-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-auto-blkvm' tries to 
include nonexistent context 'macro-auto-blkvm-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-auto-blkvm' tries to 
include nonexistent context 'macro-auto-blkvm-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-auto-confirm' tries to 
include nonexistent context 'macro-auto-confirm-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-auto-confirm' tries to 
include nonexistent context 'macro-auto-confirm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-confirm' tries to include nonexistent context 'macro-confirm-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'macro-confirm' tries to include nonexistent context 'macro-confirm-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-presencestate-display' 
tries to include nonexistent context 'sub-presencestate-display-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-presencestate-display' 
tries to include nonexistent context 'sub-presencestate-display-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'bad-number' tries to include nonexistent context 'bad-number-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'bad-number' tries to include nonexistent context 'bad-number-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'app-blackhole' tries to include nonexistent context 'app-blackhole-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'app-blackhole' tries to include nonexistent context 'app-blackhole-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-1' tries to include nonexistent context 'outrt-1-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-1' tries to include nonexistent context 'outrt-1-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-2' tries to include nonexistent context 'outrt-2-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-2' tries to include nonexistent context 'outrt-2-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-5' tries to include nonexistent context 'outrt-5-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-5' tries to include nonexistent context 'outrt-5-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-4' tries to include nonexistent context 'outrt-4-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-4' tries to include nonexistent context 'outrt-4-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-3' tries to include nonexistent context 'outrt-3-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'outrt-3' tries to include nonexistent context 'outrt-3-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'outbound-allroutes' tries to 
include nonexistent context 'outbound-allroutes-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'outbound-allroutes' tries to 
include nonexistent context 'outbound-allroutes-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-prepend-cid' tries to 
include nonexistent context 'macro-prepend-cid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-prepend-cid' tries to 
include nonexistent context 'macro-prepend-cid-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-one-touch-record' tries 
to include nonexistent context 'macro-one-touch-record-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'macro-one-touch-record' tries 
to include nonexistent context 'macro-one-touch-record-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-record-check' tries to 
include nonexistent context 'sub-record-check-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-record-check' tries to 
include nonexistent context 'sub-record-check-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-record-cancel' tries to 
include nonexistent context 'sub-record-cancel-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'sub-record-cancel' tries to 
include nonexistent context 'sub-record-cancel-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-3' tries to include nonexistent context 'sub-flp-3-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-3' tries to include nonexistent context 'sub-flp-3-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-2' tries to include nonexistent context 'sub-flp-2-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-2' tries to include nonexistent context 'sub-flp-2-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-1' tries to include nonexistent context 'sub-flp-1-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'sub-flp-1' tries to include nonexistent context 'sub-flp-1-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'ext-did-catchall' tries to 
include nonexistent context 'ext-did-catchall-custom'
[2014-09-29
 18:43:22] WARNING[3048] pbx.c: Context 'ext-did-catchall' tries to 
include nonexistent context 'ext-did-catchall-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'ext-did' tries to include nonexistent context 'ext-did-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'ext-did' tries to include nonexistent context 'ext-did-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'ext-test' tries to include nonexistent context 'ext-test-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'ext-test' tries to include nonexistent context 'ext-test-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'app-chanspy' tries to include nonexistent context 'app-chanspy-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'app-chanspy' tries to include nonexistent context 'app-chanspy-custom'
[2014-09-29 18:43:22] WARNING[3048] pbx.c: Context 'app-zapbarge' tries to include nonexistent context 

top would actually show you which process it is thats at 100% cpu.

Can you tell why? I don’t recall any custom internal stuff. I think I’d adjusted the buffer size on my old system but that’s all I remember tweaking outside of the GUI.

I thought most of these “errors” simply meant that there was nothing in the custom-conf file so the errors could be ignored. You gave me a hint by saying the error is in the first line but my lack of experience isn’t able to tell what’s wrong. I’m not sure where the internal-custom setting is located so I can’t see what’s in it. Can I get another hint?

Where did I say anything about first line?

Do you know what “top” is? It’s a linux program to see the list of processes. I am not saying look at the top of said files, I am asking if you’ve run the command “top” to see what is taking all of your CPU.

Ah! No. Sorry but I didn’t know what top was. Sorry. I’m still learning.

Below are the first lines from the top command. Are you able to give me direction from what you see here? Thank you for the help you’ve been. I appreciate it.

1284 mysql 20 0 153m 26m 5556 S 84.5 1.8 2:17.99 mysqld
1523 asterisk 20 0 580m 223m 14m S 9.5 14.8 0:42.80 java
1992 root 20 0 155m 6484 2316 S 1.9 0.4 0:08.34 fail2ban-server
1729 asterisk 20 0 78632 28m 11m S 0.6 1.9 0:02.69 asterisk
1420 asterisk 20 0 36588 8028 2784 R 0.3 0.5 0:00.01 httpd
1 root 20 0 2900 1372 1164 S 0.0 0.1 0:00.94 init

Your mysql server is being hammered, try from bash :-

mysql -u root -prootpassword -e ‘SHOW FULL PROCESSLIST\G’

I got the GUI to work well enough to do module updates. One of them had an effect as the system has settled down to only 6% CPU. Hopefully that means my problem was resolved during one of the updates <whew!>

I did try to run the command line you gave me as it says “cannot execute binary file”. It may not matter however since the system seems to be working now.

I’ll try to do another restore after hours and see if the problem returns then. That’s when it hit me the first time.

Gotta love when folks rely on mystery and magic, it can imbue a deep feeling of knowledge and competence, perhaps not warranted :slight_smile:

I never claimed to be full of knowledge and competence on this. I don’t do this for anyone else, just my own small company. I love FreeePBX. It’s great. And I appreciate ALL the people who support it for even unimportant people like myself.
I’m much more of a Windows guy myself so yes, I’m pretty weak on the Linux side of things, but I’m learning thanks in part to people here.

“top” will now become your best friend. I came from a windows background as well (many moons ago). I always think of “top” similar to “taskmgr” on Windows.

OK, so I’m back in trouble again. The new Distro system was up and running. I did a restore using the migration backup from the old system. So far so good. I shut down the old system and enabled the trunks on the new system. Then I changed the IP in the admin. and rebooted.

When the system rebooted it came up at 100% CPU load. Thinking it might just be a startup sorta thing to rebuild the files or something I let it run for over 10 min. Still at 100%.

At that point I panicked and took the trunks offline again, changed the IP to a new IP and rebooted the “new” system. And I restarted the “old” system then enabled the trunks. The good news is the “old” system is up again and working fine.

The “new” system rebooted to the new IP with all trunks disabled but continues to run at 100% CPU load. The TOP command shows below, which still has SQL slammed at 93% CPU. Something happened when I changed the IP address and rebooted to cause the SQL to go nuts. It’s been 20 min. and still going. What’s gone wrong, and why did it only go wrong after the reboot?

PS. I did a check for module updates after the reboot to see if there were any updates since that’s what seemed to fix it the first time, but there are no updates showing.

1284 mysql 20 0 150m 25m 5428 S 94.7 1.7 13:25.76 mysqld
1523 asterisk 20 0 570m 247m 15m S 5.0 16.4 1:01.91 java
16 root 20 0 0 0 0 S 0.3 0.0 0:00.11 kblockd/0
1728 asterisk 20 0 77784 28m 11m S 0.3 1.9 0:05.94 asterisk
2907 root 20 0 2680 1104 868 R 0.3 0.1 0:00.68 top
1 root 20 0 2900 1368 1164 S 0.0 0.1 0:00.98 init

Until you can find out why mysql is jamming your system you will contimue to have that problem, if you continue to be unable to run from bash

mysql -u root (-prootpassword if you have one) -e ‘SHOW FULL PROCESSLIST\G’

then you have other problems.

Dicko, When I enter

# which bash

I get

 # /bin/bash

When I enter

/bin/bash 

I get the # prompt back
When I run

# mysql -u root -mypasswordhere -e 'SHOW FULL PROCESSLIST\G'
mysql: unknown option '-d'

# mysql -u root -mypasswordhere -e 'SHOW FULL PROCESSLIST\G  (no end quote)  

I get

>

At which point I can’t seem to enter anything and close Putty and start over.

I’m probably entering the command wrong?

If this is the FreePBX distro then just run:

mysql -u root -e 'SHOW FULL PROCESSLIST\G'

First off you are removing the “-p” part of the option on your own accord. If my password was “tango” then the CLI operator would be “-ptango”, if you just typed "-p " then it would prompt you for your password on the next line.

Secondly by not adding the ending ’ you are telling bash you have more commands. You can escape out of that by hitting “ctrl+c”

Thirdly you are already running bash, so basically you ran bash on top of bash. Nothing wrong there just informing you.

Fourthly getting rid of the “#” in your message will remove the header tags (which I already did for you)

Might be good for you to read up on some basic Linux. It would really help.

Ah. I missed that I needed -pPassword instead of -password.

I had the “#” in there to show I was at that prompt. Thank you.

I ran the mysql -u root -e ‘SHOW FULL PROCESSLIST\G’ and two things have happened. First, by CPU is now at 0%. Why? No clue. Will not have an opportunity to make this machine live again today however and not understanding why it was at 100% I don’t know what needs to be done to prevent it from doing that again next time I try.

Second is the output

[[email protected] ~]# mysql -u root -e ‘SHOW FULL PROCESSLIST\G’
*************************** 1. row ***************************
Id: 1
User: freepbxuser
Host: localhost:43897
db: asteriskcdrdb
Command: Sleep
Time: 590
State:
Info: NULL
*************************** 2. row ***************************
Id: 8
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: SHOW FULL PROCESSLIST

Yeah we will need to see the command output when it’s at 100%

Had to figure out how to capture it all as it rolled off the screen but I think I have it.

<code>
*************************** 1. row ***************************
     Id: 5
   User: freepbxuser
   Host: localhost
     db: asteriskcdrdb
Command: Sleep
   Time: 624
  State: 
   Info: NULL
*************************** 2. row ***************************
     Id: 17
   User: freepbxuser
   Host: localhost:39242
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1404739377.19450' LIMIT 1
*************************** 3. row ***************************
     Id: 18
   User: freepbxuser
   Host: localhost:39243
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1399477057.3138' LIMIT 1
*************************** 4. row ***************************
     Id: 19
   User: freepbxuser
   Host: localhost:39244
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1392044728.758' LIMIT 1
*************************** 5. row ***************************
     Id: 21
   User: freepbxuser
   Host: localhost:39246
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1405532905.22721' LIMIT 1
*************************** 6. row ***************************
     Id: 23
   User: freepbxuser
   Host: localhost:39248
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1397839010.8213' LIMIT 1
*************************** 7. row ***************************
     Id: 24
   User: freepbxuser
   Host: localhost:39249
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1410277421.10657' LIMIT 1
*************************** 8. row ***************************
     Id: 25
   User: freepbxuser
   Host: localhost:39250
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1396383575.1871' LIMIT 1
*************************** 9. row ***************************
     Id: 26
   User: freepbxuser
   Host: localhost:39251
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1406212289.25392' LIMIT 1
*************************** 10. row ***************************
     Id: 27
   User: freepbxuser
   Host: localhost:39252
     db: asteriskcdrdb
Command: Query
   Time: 4
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1396466179.2821' LIMIT 1
*************************** 11. row ***************************
     Id: 28
   User: freepbxuser
   Host: localhost:39253
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1410368408.11320' LIMIT 1
*************************** 12. row ***************************
     Id: 29
   User: freepbxuser
   Host: localhost:39254
     db: asteriskcdrdb
Command: Query
   Time: 3
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1392821665.311' LIMIT 1
*************************** 13. row ***************************
     Id: 30
   User: freepbxuser
   Host: localhost:39255
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1406232057.25698' LIMIT 1
*************************** 14. row ***************************
     Id: 31
   User: freepbxuser
   Host: localhost:39256
     db: asteriskcdrdb
Command: Query
   Time: 5
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1406657237.27031' LIMIT 1
*************************** 15. row ***************************
     Id: 32
   User: freepbxuser
   Host: localhost:39257
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1393429290.2831' LIMIT 1
*************************** 16. row ***************************
     Id: 33
   User: freepbxuser
   Host: localhost:39258
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1393341003.2638' LIMIT 1
*************************** 17. row ***************************
     Id: 34
   User: freepbxuser
   Host: localhost:39259
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409839685.9554' LIMIT 1
*************************** 18. row ***************************
     Id: 35
   User: freepbxuser
   Host: localhost:39260
     db: asteriskcdrdb
Command: Query
   Time: 5
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409682458.8906' LIMIT 1
*************************** 19. row ***************************
     Id: 36
   User: freepbxuser
   Host: localhost:39261
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409680118.8871' LIMIT 1
*************************** 20. row ***************************
     Id: 37
   User: freepbxuser
   Host: localhost:39263
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1404226029.18345' LIMIT 1
*************************** 21. row ***************************
     Id: 38
   User: freepbxuser
   Host: localhost:39264
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1392149089.1108' LIMIT 1
*************************** 22. row ***************************
     Id: 39
   User: freepbxuser
   Host: localhost:39265
     db: asteriskcdrdb
Command: Query
   Time: 3
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1398690258.13' LIMIT 1
*************************** 23. row ***************************
     Id: 40
   User: freepbxuser
   Host: localhost:39266
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1398272141.9735' LIMIT 1
*************************** 24. row ***************************
     Id: 41
   User: freepbxuser
   Host: localhost:39267
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1397489021.5833' LIMIT 1
*************************** 25. row ***************************
     Id: 42
   User: freepbxuser
   Host: localhost:39268
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1411578301.549' LIMIT 1
*************************** 26. row ***************************
     Id: 43
   User: freepbxuser
   Host: localhost:39269
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1411134447.13743' LIMIT 1
*************************** 27. row ***************************
     Id: 44
   User: freepbxuser
   Host: localhost:39270
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1396366278.1499' LIMIT 1
*************************** 28. row ***************************
     Id: 45
   User: freepbxuser
   Host: localhost:39271
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409863929.9805' LIMIT 1
*************************** 29. row ***************************
     Id: 46
   User: freepbxuser
   Host: localhost:39272
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1398881491.702' LIMIT 1
*************************** 30. row ***************************
     Id: 47
   User: freepbxuser
   Host: localhost:39273
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409775663.9447' LIMIT 1
*************************** 31. row ***************************
     Id: 48
   User: freepbxuser
   Host: localhost:39274
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409856904.9726' LIMIT 1
*************************** 32. row ***************************
     Id: 49
   User: freepbxuser
   Host: localhost:39275
     db: asteriskcdrdb
Command: Query
   Time: 4
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1397592460.6437' LIMIT 1
*************************** 33. row ***************************
     Id: 50
   User: freepbxuser
   Host: localhost:39276
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1405606511.23018' LIMIT 1
*************************** 34. row ***************************
     Id: 51
   User: freepbxuser
   Host: localhost:39277
     db: asteriskcdrdb
Command: Query
   Time: 5
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1411396811.14022' LIMIT 1
*************************** 35. row ***************************
     Id: 52
   User: freepbxuser
   Host: localhost:39278
     db: asteriskcdrdb
Command: Query
   Time: 3
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1393442632.3088' LIMIT 1
*************************** 36. row ***************************
     Id: 53
   User: freepbxuser
   Host: localhost:39279
     db: asteriskcdrdb
Command: Query
   Time: 8
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409853970.9669' LIMIT 1
*************************** 37. row ***************************
     Id: 54
   User: freepbxuser
   Host: localhost:39280
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1404843125.20386' LIMIT 1
*************************** 38. row ***************************
     Id: 55
   User: freepbxuser
   Host: localhost:39281
     db: asteriskcdrdb
Command: Query
   Time: 4
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1392922966.1707' LIMIT 1
*************************** 39. row ***************************
     Id: 56
   User: freepbxuser
   Host: localhost:39282
     db: asteriskcdrdb
Command: Query
   Time: 3
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1398788868.583' LIMIT 1
*************************** 40. row ***************************
     Id: 57
   User: freepbxuser
   Host: localhost:39283
     db: asteriskcdrdb
Command: Query
   Time: 8
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1406727526.27113' LIMIT 1
*************************** 41. row ***************************
     Id: 58
   User: freepbxuser
   Host: localhost:39284
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1411407490.14094' LIMIT 1
*************************** 42. row ***************************
     Id: 59
   User: freepbxuser
   Host: localhost:39285
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1411675463.1269' LIMIT 1
*************************** 43. row ***************************
     Id: 60
   User: freepbxuser
   Host: localhost:39286
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1412005492.1709' LIMIT 1
*************************** 44. row ***************************
     Id: 61
   User: freepbxuser
   Host: localhost:39287
     db: asteriskcdrdb
Command: Query
   Time: 3
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1393448367.3254' LIMIT 1
*************************** 45. row ***************************
     Id: 62
   User: freepbxuser
   Host: localhost:39288
     db: asteriskcdrdb
Command: Query
   Time: 4
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1405963813.24195' LIMIT 1
*************************** 46. row ***************************
     Id: 63
   User: freepbxuser
   Host: localhost:39289
     db: asteriskcdrdb
Command: Query
   Time: 6
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1397852962.8469' LIMIT 1
*************************** 47. row ***************************
     Id: 64
   User: freepbxuser
   Host: localhost:39290
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1391783316.1003' LIMIT 1
*************************** 48. row ***************************
     Id: 65
   User: freepbxuser
   Host: localhost:39291
     db: asteriskcdrdb
Command: Query
   Time: 7
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1406648595.26921' LIMIT 1
*************************** 49. row ***************************
     Id: 66
   User: freepbxuser
   Host: localhost:39292
     db: asteriskcdrdb
Command: Query
   Time: 2
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1409944327.10063' LIMIT 1
*************************** 50. row ***************************
     Id: 67
   User: freepbxuser
   Host: localhost:39293
     db: asteriskcdrdb
Command: Query
   Time: 1
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1405613998.23121' LIMIT 1
*************************** 51. row ***************************
     Id: 68
   User: freepbxuser
   Host: localhost:39295
     db: asteriskcdrdb
Command: Query
   Time: 5
  State: Sending data
   Info: SELECT * FROM cdr WHERE uniqueid = '1393012520.2039' LIMIT 1
*************************** 52. row ***************************
     Id: 119
   User: freepbxuser
   Host: localhost
     db: asterisk
Command: Sleep
   Time: 63
  State: 
   Info: NULL
*************************** 53. row ***************************
     Id: 121
   User: freepbxuser
   Host: localhost
     db: asterisk
Command: Sleep
   Time: 31
  State: 
   Info: NULL
*************************** 54. row ***************************
     Id: 125
   User: freepbxuser
   Host: localhost
     db: asterisk
Command: Sleep
   Time: 3
  State: 
   Info: NULL
*************************** 55. row ***************************
     Id: 126
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: SHOW FULL PROCESSLIST

</code>

I notice the log file shows this over and over and over

[2014-10-09 08:32:26] NOTICE[3089] manager.c: 127.0.0.1 tried to authenticate with nonexistent user ‘cxpanel’
[2014-10-09 08:32:26] NOTICE[3089] manager.c: 127.0.0.1 tried to authenticate with nonexistent user ‘cxpanel’

I see in another post someone who had that error as well. Following the suggestion there, I installed iSymphony from the modules list then opened the User Panel and hit Submit without making any entries, then I entered my name and extension and submitted again. When I returned to check the CPU now shows at 0%. Unfortunately it’s not my “live” system currently so I’ve been here before, only to have it go to 100% when making it live.