You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-05-20 10:09:36

squale323
Member
Registered: 2017-06-21
Posts: 26

erreur mysql et php, serveur à genou

Bonjour,

depuis quelques temps déja, vmware nous reporte que notre serveur GLPI monte à 100% d'utilisation CPU, grosso modo toutes les 2 heures.
aprés avoir jeter un coup d'oeil au log, j'ai ces 2 erreurs récurentes :

dans le fichier php-error.log, 2 fois par minutes cette erreur :

[2020-05-20 09:50:25] glpiphplog.ERROR: Toolbox::userErrorHandlerNormal() in /var/www/glpi/inc/toolbox.class.php line 683
  *** PHP Warning(2): mkdir(): No such file or directory
  Backtrace :
  :                                                 
  plugins/fusioninventory/inc/toolbox.class.php:316  mkdir()
  ...ry/inc/inventorycomputerinventory.class.php:585 PluginFusioninventoryToolbox::writeXML()
  ...inventory/inc/inventoryruleimport.class.php:966 PluginFusioninventoryInventoryComputerInventory->rulepassed()
  inc/rule.class.php:1435                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc/rulecollection.class.php:1539                  Rule->process()
  ...ry/inc/inventorycomputerinventory.class.php:341 RuleCollection->processAllRules()
  ...ry/inc/inventorycomputerinventory.class.php:102 PluginFusioninventoryInventoryComputerInventory->sendCriteria()
  ...fusioninventory/inc/communication.class.php:229 PluginFusioninventoryInventoryComputerInventory->import()
  ...fusioninventory/inc/communication.class.php:461 PluginFusioninventoryCommunication->import()
  plugins/fusioninventory/front/communication.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:59               include_once()
  {"user":"226@SRV-GLPI-VM"}

dans le fichier sql-errors.log, idem plusieurs fois par minutes (les VALUES sont différentes quasiment a chaque fois) :

glpisqllog.ERROR: DBmysql::query() in /var/www/glpi/inc/dbmysql.class.php line 188
  *** MySQL query error:
  SQL: INSERT INTO `glpi_networkports_networkports` (`networkports_id_1`, `networkports_id_2`) VALUES ('80803', '34494')
  Error: Duplicate entry '80803-34494' for key 'unicity'
  Backtrace :
  inc/dbmysql.class.php:833                         
  inc/commondbtm.class.php:669                       DBmysql->insert()
  inc/commondbtm.class.php:1148                      CommonDBTM->addToDB()
  .../inc/inventorynetworkequipmentlib.class.php:446 CommonDBTM->add()
  .../inc/inventorynetworkequipmentlib.class.php:342 PluginFusioninventoryInventoryNetworkEquipmentLib->importConnectionLLDP()
  .../inc/inventorynetworkequipmentlib.class.php:163 PluginFusioninventoryInventoryNetworkEquipmentLib->importPorts()
  ...inc/communicationnetworkinventory.class.php:319 PluginFusioninventoryInventoryNetworkEquipmentLib->updateNetworkEquipment()
  ...inc/communicationnetworkinventory.class.php:550 PluginFusioninventoryCommunicationNetworkInventory->importDevice()
  ...inventory/inc/inventoryruleimport.class.php:966 PluginFusioninventoryCommunicationNetworkInventory->rulepassed()
  inc/rule.class.php:1435                            PluginFusioninventoryInventoryRuleImport->executeActions()
  inc/rulecollection.class.php:1539                  Rule->process()
  ...inc/communicationnetworkinventory.class.php:393 RuleCollection->processAllRules()
  ...inc/communicationnetworkinventory.class.php:229 PluginFusioninventoryCommunicationNetworkInventory->sendCriteria()
  ...inc/communicationnetworkinventory.class.php:125 PluginFusioninventoryCommunicationNetworkInventory->importContent()
  ...fusioninventory/inc/communication.class.php:229 PluginFusioninventoryCommunicationNetworkInventory->import()
  ...fusioninventory/inc/communication.class.php:461 PluginFusioninventoryCommunication->import()
  plugins/fusioninventory/front/communication.php:93 PluginFusioninventoryCommunication->handleOCSCommunication()
  plugins/fusioninventory/index.php:59               include_once()
  {"user":"226@SRV-GLPI-VM","mem_usage":"0.002\", 13.46Mio)"}

quelqu'un aurait une idée svp ?


Debian 8.11
PHP 5.6 MySql 5.6
Glpi 9.4.6
FI 9.4+2.4

Offline

#2 2020-05-25 15:45:16

squale323
Member
Registered: 2017-06-21
Posts: 26

Re: erreur mysql et php, serveur à genou

up svp :-)


Debian 8.11
PHP 5.6 MySql 5.6
Glpi 9.4.6
FI 9.4+2.4

Offline

Board footer

Powered by FluxBB