trasher
commented
1 month ago This issue is related to a plugin, please report it plugin side.
Closed elmotofan closed 1 month ago
trasher
commented
1 month ago This issue is related to a plugin, please report it plugin side.
elmotofan
commented
1 month ago Hi, In the repo of plugin GenericObject says that only can be reported security issues. To get support need to have a suscription to Teclib. That is correct?
cedric-anne
commented
1 month ago Hi, In the repo of plugin GenericObject says that only can be reported security issues. To get support need to have a suscription to Teclib. That is correct?
You can get community support on forums.
Code of Conduct
Is there an existing issue for this?
Version
10.0.15
Bug description
Hi, We are using GenericObject plugin as part of Biomedical Inventory. So, we have 150 types of different medical equipments. but we found a very slow performance in dashboards pages like inventory, personal view, global view, or tickets with minidash enabled.
After enabled bug mode, we saw too many request with these queries:
SELECT * FROM
glpi_plugin_genericobject_typefamiliesWHEREglpi_plugin_genericobject_typefamilies.id= '7' LIMIT 1SELECT
glpi_plugin_genericobject_typefamilies.*, '' AStransname, '' AStranscommentFROMglpi_plugin_genericobject_typefamiliesWHEREglpi_plugin_genericobject_typefamilies.id= '7'and we believe that is causing the slow performance. If we deactivate the plug-in, that’s request are no present while we browse in pages of GLPi menus.
With plugin enabled:
Without plug-in
Is there some reason that make that’s queries? All items in the plug-in has all integrations enabled (service, reserve, history)
Relevant log output
No response
Page URL
https://glpi_url/front/central.php
Steps To reproduce
1-access GLPI base url 2- navigate on dashboard, personal view, global view
Your GLPI setup information
Información sobre la instalación y configuración del sistema
Server
Operating system: Linux ITARMGLPI01 5.14.0-427.16.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Wed May 8 17:48:14 UTC 2024 x86_64 PHP 8.3.7 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, igbinary, intl, json, ldap, libxml, mbstring, msgpack, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, random, redis, session, sockets, sodium, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="360" memory_limit="8092M" post_max_size="64M" safe_mode="" session.save_handler="files" upload_max_filesize="64M" disable_functions="" Software: Apache/2.4.57 (Rocky Linux) OpenSSL/3.0.7 () Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1 Server Software: MariaDB Server Server Version: 10.5.22-MariaDB-log Server SQL Mode: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION Parameters: adminglpi@localhost/glpi_prd Host info: Localhost via UNIX socket PHP version (8.3.7) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.5.22) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/www/HIprd/glpi/../files/_cache has been validated. Write access to /var/www/HIprd/glpi/../files/_cron has been validated. Write access to /var/www/HIprd/glpi/../files has been validated. Write access to /var/www/HIprd/glpi/../files/_dumps has been validated. Write access to /var/www/HIprd/glpi/../files/_graphs has been validated. Write access to /var/www/HIprd/glpi/../files/_lock has been validated. Write access to /var/www/HIprd/glpi/../files/_pictures has been validated. Write access to /var/www/HIprd/glpi/../files/_plugins has been validated. Write access to /var/www/HIprd/glpi/../files/_rss has been validated. Write access to /var/www/HIprd/glpi/../files/_sessions has been validated. Write access to /var/www/HIprd/glpi/../files/_tmp has been validated. Write access to /var/www/HIprd/glpi/../files/_uploads has been validated. SELinux configuration is OK. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /var/www/HIprd/glpi/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: '192.168.250.22', Port: '389', BaseDN: 'ou=hospital-italiano,dc=hospital-italiano,dc=local', Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'cn=administrador,cn=users,dc=hospital-italiano,dc=local', Use TLS: noneSQL replicas
Notifications
Plugins list
fields Name: Additional fields Version: 1.21.8 State: Enabled Install Method: Manual genericobject Name: Administración de Objetos Version: 2.14.10 State: Installed / not activated Install Method: Marketplace advanceddashboard Name: advanceddashboard Version: 1.5.1 State: Enabled Install Method: Manual advancedplanning Name: advancedplanning Version: 1.1.0 State: Enabled Install Method: Marketplace barcode Name: Barcode Version: 2.7.1 State: Installed / not activated Install Method: Marketplace branding Name: Branding Version: 1.4.0 State: Enabled Install Method: Manual camerainput Name: Camera Input Version: 2.1.0 State: Installed / not activated Install Method: Marketplace printercounters Name: Contador de impresion Version: 2.0.1 State: Enabled Install Method: Marketplace escalade Name: Escalation Version: 2.9.8 State: Enabled Install Method: Marketplace formcreator Name: Form Creator Version: 2.13.9 State: Enabled Install Method: Manual datainjection Name: Inyección de datos Version: 2.13.5 State: Not installed Install Method: Marketplace satisfaction Name: More satisfaction Version: 1.6.2 State: Enabled Install Method: Marketplace localeoverride Name: Rename GLPI strings Version: 1.1.7 State: Enabled Install Method: ManualAnything else?
No response