Too many logins from ClusterController into cluster nodes

Follow

Alain Egho

• September 02, 2016 09:53

Recently I am facing too many logins on the nodes coming from the clustercontroller .

As a result I am facing a high cpu usage due to the accounts-daemon process.

This is becomming annoying.

Any idea how clustercontroler gets his statistics data from the nodes?

Is this issue related to the polling of these info?

 

 

0

• Official comment

  

  Johan

  • September 02, 2016 10:18

  Hi,

   

  Can you send a 

  "SHOW PROCESSLIST" 
  or

  select * from information_schema.processlist where user='cmon';
  
  From one of the affected db nodes?

  Also what cmon version are you using?

   

  BR
  johan

  Comment actions Permalink
• 

  Alain Egho

  • September 02, 2016 10:51

  on an affected node:

  3250, 'cmon', '192.168.255.143:54914', 'information_schema', 'Sleep', 0, '', '', 115.361, 0, 0, 0.000, 67408, 0, 117062, '', 26803

  3249, 'cmon', '192.168.255.143:54864', 'information_schema', 'Sleep', 2, '', '', 2443.765, 0, 0, 0.000, 67408, 0, 117040, '', 29626

   

  cmon version:

  cmon, version 1.3.2.1391

   

  Thank You

  Alan

  0

  Comment actions Permalink
• 

  Johan

  • September 02, 2016 11:09

  Hi,

  Also please checkout this one (re: accounts-daemon):

  http://severalnines.com/blog/clustercontrol-tips-tricks-wtmp-log-rotation-settings-sudo-user

  A large wtmp file will cause the accounts daemon to act up b/c the accounts daemon is buggy and will try and re-read the wtmp fully as soon as a login / logout happens. If this then is a big file then the accounts daemon will eat cpu.

  This in turn could lead to connection issues.

  
  BR
  johan

  1

  Comment actions Permalink
• 

  Alain Egho

  • September 02, 2016 11:48

   hey guys after decreasing wtmp file size the accounts-deamon process cpu usage decreased!

   Use Log rotation for wtmp

  /var/log/wtmp {

      monthly

      create 0664 root utmp

      minsize 1M

      rotate 1

  }

   

  Regards,

  Alain

   

  0

  Comment actions Permalink
• 

  Johan

  • September 02, 2016 12:41

  Hi,

  Is the system then working for you again?

  BR
  johan

  1

  Comment actions Permalink
• 

  Alain Egho

  • September 02, 2016 12:47

  Hey

  cpu load droped dramatically after rotating logs

  I've been monitoring the process the logs are getting big quickly ,I Guess I should rotate logs every hour.

   

  0

  Comment actions Permalink
• 

  Tenuun

  • August 14, 2019 12:36

  now we can apt-ger remove accounts-daemon ? is it needed on DB only host ?

  1

  Comment actions Permalink

Please sign in to leave a comment.