Closed brunnersm closed 2 years ago
trasher
commented
2 years ago You probably have an agent (or more...) listed in your database with a missing itemtype; could you please check that? No idea how this has happened; maybe some other data on wrong line can help to understand.
brunnersm
commented
2 years ago SELECT FROM glpi_agents WHERE itemtype <> 'Computer' / Registros afetados: 0 Registros encontrados: 0 Avisos: 0 Duração de 1 consulta: 0,000 seg. */
trasher
commented
2 years ago This can be a still referenced agent in glpi_plugin_glpiinventory_taskjobstates that has been deleted in agents table.
This looks like a plugin issue, try with:
diff --git a/inc/agentwakeup.class.php b/inc/agentwakeup.class.php
index b0a961a2ae..35df4c5883 100644
--- a/inc/agentwakeup.class.php
+++ b/inc/agentwakeup.class.php
@@ -172,11 +172,12 @@ class PluginGlpiinventoryAgentWakeup extends CommonDBTM
if (isset($wakeupArray[$agents_id])) {
$counter++;
} else {
- $agent->getFromDB($agents_id);
- $statusAgent = $agent->requestStatus();
- if ($statusAgent['answer'] == 'waiting') {
- $wakeupArray[$agents_id] = $agents_id;
- $counter++;
+ if ($agent->getFromDB($agents_id)) {
+ $statusAgent = $agent->requestStatus();
+ if ($statusAgent['answer'] == 'waiting') {
+ $wakeupArray[$agents_id] = $agents_id;
+ $counter++;
+ }
}
}
Thanks, i run "DELETE FROM glpi_plugin_glpiinventory_taskjobstates WHERE agents_id = 0" and fix the problem. Maybe because it was FusionInventory before
trasher
commented
2 years ago Possible, yes... I close the issue for now; we'll investigate if it appears again then.
Code of Conduct
Is there an existing issue for this?
Version
10.0.1
Bug description
Return error in php-errros.log with php front/cron.php about src/Agent.php
Relevant log output
Page URL
No response
Steps To reproduce
php /var/www/html/front/cron.php &>/dev/null
Your GLPI setup information
Instruções de instalação e configuração
Server
Operating system: Linux HUCAM-VP-CAU1 4.19.0-9-amd64 #1 SMP Debian 4.19.118-2+deb10u1 (2020-06-07) x86_64 PHP 7.4.8 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: Apache/2.4.38 (Debian) (Apache/2.4.38 (Debian) Server at cau.hucam.edu.br Port 443 ) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36 Edg/101.0.1210.53 Server Software: mariadb.org binary distribution Server Version: 10.5.4-MariaDB-1:10.5.4+maria~buster Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: root@localhost/glpi Host info: Localhost via UNIX socket PHP version (7.4.8) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed. gd extension is installed. intl extension is installed. libxml extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.5.4) is supported. The log file has been created successfully. Write access to /var/www/html/files/_cache has been validated. Write access to /var/www/html/config has been validated. Write access to /var/www/html/files/_cron has been validated. Write access to /var/www/html/files has been validated. Write access to /var/www/html/files/_dumps has been validated. Write access to /var/www/html/files/_graphs has been validated. Write access to /var/www/html/files/_lock has been validated. Write access to /var/www/html/files/_pictures has been validated. Write access to /var/www/html/files/_plugins has been validated. Write access to /var/www/html/files/_rss has been validated. Write access to /var/www/html/files/_sessions has been validated. Write access to /var/www/html/files/_tmp has been validated. Write access to /var/www/html/files/_uploads has been validated. Web access to files directory is protected exif extension is installed. ldap extension is installed. openssl extension is installed. zip extension is installed. bz2 extension is installed. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /var/www/html/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: 'HU-HUCAM-VP-AD1.ebserhnet.ebserh.gov.br', Port: '389', BaseDN: 'OU=HUCAM,OU=EBSERH,DC=ebserhnet,DC=ebserh,DC=gov,DC=br', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'ebserhnet\hucamsrvc.redmine', Use TLS: noneSQL replicas
Notifications
Plugins list
fields Name: Campos adicionais Version: 1.15.3 State: Enabled accounts Name: Contas Version: 3.0.2 State: Enabled escalade Name: Escalonamento Version: 2.8.0 State: Installed / not activated formcreator Name: Form Creator Version: 2.12.5 State: Installed / not activated gappessentials Name: Gapp Essentials Version: 2.0.0 State: Enabled order Name: Gerenciamento das ordens de co Version: 2.9.0 State: Installed / not activated genericobject Name: Gerenciamento de objetos Version: 2.12.0 State: Installed / not activated glpiinventory Name: GLPI Inventory Version: 1.0.1 State: Enabled itilcategorygroups Name: Grupos ItilCategory Version: 2.5.0 State: Installed / not activated mreporting Name: Mais Relatórios Version: 1.8.0 State: Enabled consumables Name: Pedidos de consumíveis Version: 2.0.0 State: EnabledAnything else?
No response