search

centreon / centreon-archived

Centreon is a network, system and application monitoring tool. Centreon is the only AIOps Platform Providing Holistic Visibility to Complex IT Workflows from Cloud to Edge.
https://www.centreon.com
GNU General Public License v2.0
575 stars 240 forks source link

MULTIPLE API REST REQUEST - CRASH MYSQL #6056

Open Jordan91 opened 6 years ago

Jordan91 commented 6 years ago

BUG REPORT INFORMATION

Centreon Web version: 2.8.17 Centreon Engine version: 1.8.1 Centreon Broker version: 3.0.12 OS: Centos 6.9 Additional environment details (AWS, VirtualBox, physical, etc.):

Steps to reproduce the issue:

  1. Multiple API REST REQUEST (*1000) 2.Waiting for global read lock | DELETE FROM ws_token WHERE generate_date < DATE_SUB(NOW(), INTERVAL 1 HOUR) |

Describe the results you received: Crash Mysql

Describe the results you expected: Better performence and no crash for MYSQL => /usr/share/centreon/www/api/index.php Additional information you think important (e.g. issue happens only occasionally):

lpinsivy commented 6 years ago

@Jordan91 each connection start with an authentication or you use token existing?

Jordan91 commented 6 years ago

Hi,

@lpinsivy Every call API requires a new Token

BR,