Forum GLPI-Project

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

glpi10.0.10 + agent fusioninventory : sql warning

Suite à la migration en version 10.0.10 mes agents fusion commencent à remonter des machines et j'ai régulièrement ces messages dans mes journaux de log.
j'ai mis 'otherserial' en verrou global sur tous mes ordinateurs.

je vais passer  sur la version agent GLPI 1.6  mais ça va prendre un peu de temps.

[2023-12-07 12:24:48] glpisqllog.WARNING: DBmysql::query() in /var/www/glpi/src/DBmysql.php line 419
  *** MySQL query warnings:
  SQL: SELECT * FROM `glpi_lockedfields` WHERE `itemtype` = 'Item_DeviceDrive' AND ((`items_id` = '' OR `is_global` = '1'))
  Warnings: 
1292: Truncated incorrect DECIMAL value: ''
  Backtrace :
  src/DBmysqlIterator.php:112                        
  src/DBmysql.php:1078                               DBmysqlIterator->execute()
  src/Lockedfield.php:185                            DBmysql->request()
  src/Lockedfield.php:158                            Lockedfield->getLocks()
  src/Inventory/Asset/InventoryAsset.php:433         Lockedfield->getLockedNames()
  src/Inventory/Asset/Device.php:175                 Glpi\Inventory\Asset\InventoryAsset->handleInput()
  src/Inventory/Asset/Drive.php:118                  Glpi\Inventory\Asset\Device->handle()
  src/Inventory/Asset/MainAsset.php:937              Glpi\Inventory\Asset\Drive->handle()
  src/Inventory/Asset/MainAsset.php:852              Glpi\Inventory\Asset\MainAsset->handleAssets()
  src/RuleImportAsset.php:969                        Glpi\Inventory\Asset\MainAsset->rulepassed()
  src/Rule.php:1533                                  RuleImportAsset->executeActions()
  src/RuleCollection.php:1640                        Rule->process()
  src/Inventory/Asset/MainAsset.php:574              RuleCollection->processAllRules()
  src/Inventory/Inventory.php:722                    Glpi\Inventory\Asset\MainAsset->handle()
  src/Inventory/Inventory.php:353                    Glpi\Inventory\Inventory->handleItem()
  src/Inventory/Request.php:360                      Glpi\Inventory\Inventory->doInventory()
  src/Inventory/Request.php:90                       Glpi\Inventory\Request->inventory()
  src/Agent/Communication/AbstractRequest.php:332    Glpi\Inventory\Request->handleAction()
  src/Agent/Communication/AbstractRequest.php:269    Glpi\Agent\Communication\AbstractRequest->handleXMLRequest()
  front/inventory.php:94                             Glpi\Agent\Communication\AbstractRequest->handleRequest()
  index.php:93                                       include_once()

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9