search

glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.33k stars 1.3k forks source link

[9.5] createinquest automatic action last a long time for nothing! #9137

Closed tomolimo closed 3 years ago

tomolimo commented 3 years ago

Hello,

Describe the bug

A picture is sometimes better than a long speech: image

Expected behavior

I expect that it takes less than 10 seconds to execute when there is nothing to do!

Logs

No error in log files

Your GLPI setup (you can find it in Setup > General menu, System tab)

[code]

GLPI 9.5.5 ( => L:\inetpub\wwwroot\glpi9.5)
Installation mode: TARBALL

Server

Operating system: Windows NT  6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
PHP 7.4.20 cgi-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype,
    curl, date, dom, exif, fileinfo, filter, gd, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl,
    pcre, readline, session, soap, sodium, standard, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="300" memory_limit="1G" post_max_size="80M" safe_mode="" session.save_handler="files"
    upload_max_filesize="10M" 
Software: Microsoft-IIS/8.5
    Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36
Server Software: MySQL Community Server (GPL)
    Server Version: 5.7.17-log
    Server SQL Mode: 
    Parameters: @127.0.0.1
    Host info: 127.0.0.1 via TCP/IP

PHP version is at least 7.2.0 - Perfect!PHP version is at least 7.2.0 - Perfect!
Sessions support is available - Perfect!Sessions support is available - Perfect!
Allocated memory > 64 Mio - Perfect!Allocated memory > 64 Mio - Perfect!
mysqli extension is installedmysqli extension is installed
ctype extension is installedctype extension is installed
fileinfo extension is installedfileinfo extension is installed
json extension is installedjson extension is installed
mbstring extension is installedmbstring extension is installed
iconv extension is installediconv extension is installed
zlib extension is installedzlib extension is installed
curl extension is installedcurl extension is installed
gd extension is installedgd extension is installed
simplexml extension is installedsimplexml extension is installed
intl extension is installedintl extension is installed
ldap extension is installedldap extension is installed
apcu extension is installedapcu extension is installed
Zend OPcache extension is installedZend OPcache extension is installed
xmlrpc extension is installedxmlrpc extension is installed
CAS extension is not presentCAS extension is not present
exif extension is installedexif extension is installed
zip extension is installedzip extension is installed
bz2 extension is installedbz2 extension is installed
sodium extension is installedsodium extension is installed
Database version seems correct (5.7.17) - Perfect!Database version seems correct (5.7.17) - Perfect!
Timezones seems loaded in databaseTimezones seems loaded in database
The log file has been created successfully.The log file has been created successfully.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_cache has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_cache has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/config has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/config has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_cron has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_cron has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_dumps has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_dumps has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_graphs has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_graphs has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_lock has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_lock has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_pictures has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_pictures has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_plugins has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_plugins has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_rss has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_rss has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_sessions has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_sessions has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_tmp has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_tmp has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/files/_uploads has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/files/_uploads has been validated.
Write access to L:\inetpub\wwwroot\glpi9.5/marketplace has been validated.Write access to L:\inetpub\wwwroot\glpi9.5/marketplace has been validated.
Web access to the files directory should not be allowed but this cannot be checked automatically on this instance. Make sure access to error log file (/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration.Web access to the files directory should not be allowed but this cannot be checked automatically on this instance.
Make sure access to error log file (/files/_log/php-errors.log) is forbidden; otherwise review .htaccess file and web server configuration.

GLPI constants

GLPI_ROOT: L:\inetpub\wwwroot\glpi9.5
GLPI_CONFIG_DIR: L:\inetpub\wwwroot\glpi9.5/config
GLPI_VAR_DIR: L:\inetpub\wwwroot\glpi9.5/files
GLPI_MARKETPLACE_DIR: L:\inetpub\wwwroot\glpi9.5/marketplace
GLPI_USE_CSRF_CHECK: 1
GLPI_CSRF_EXPIRES: 7200
GLPI_CSRF_MAX_TOKENS: 100
GLPI_USE_IDOR_CHECK: 1
GLPI_IDOR_EXPIRES: 7200
GLPI_ALLOW_IFRAME_IN_RICH_TEXT: 
GLPI_TELEMETRY_URI: https://telemetry.glpi-project.org
GLPI_INSTALL_MODE: TARBALL
GLPI_NETWORK_MAIL: glpi@teclib.com
GLPI_NETWORK_SERVICES: https://services.glpi-network.com
GLPI_MARKETPLACE_PRERELEASES: 
GLPI_MARKETPLACE_ALLOW_OVERRIDE: 1
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: 1
GLPI_USER_AGENT_EXTRA_COMMENTS: 
GLPI_AJAX_DASHBOARD: 1
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: 0
GLPI_FORCE_EMPTY_SQL_MODE: 1
GLPI_DOC_DIR: L:\inetpub\wwwroot\glpi9.5/files
GLPI_CACHE_DIR: L:\inetpub\wwwroot\glpi9.5/files/_cache
GLPI_CRON_DIR: L:\inetpub\wwwroot\glpi9.5/files/_cron
GLPI_DUMP_DIR: L:\inetpub\wwwroot\glpi9.5/files/_dumps
GLPI_GRAPH_DIR: L:\inetpub\wwwroot\glpi9.5/files/_graphs
GLPI_LOCAL_I18N_DIR: L:\inetpub\wwwroot\glpi9.5/files/_locales
GLPI_LOCK_DIR: L:\inetpub\wwwroot\glpi9.5/files/_lock
GLPI_LOG_DIR: L:\inetpub\wwwroot\glpi9.5/files/_log
GLPI_PICTURE_DIR: L:\inetpub\wwwroot\glpi9.5/files/_pictures
GLPI_PLUGIN_DOC_DIR: L:\inetpub\wwwroot\glpi9.5/files/_plugins
GLPI_RSS_DIR: L:\inetpub\wwwroot\glpi9.5/files/_rss
GLPI_SESSION_DIR: L:\inetpub\wwwroot\glpi9.5/files/_sessions
GLPI_TMP_DIR: L:\inetpub\wwwroot\glpi9.5/files/_tmp
GLPI_UPLOAD_DIR: L:\inetpub\wwwroot\glpi9.5/files/_uploads
GLPI_NETWORK_REGISTRATION_API_URL: https://services.glpi-network.com/api/registration/
GLPI_MARKETPLACE_PLUGINS_API_URI: https://services.glpi-network.com/api/glpi-plugins/
GLPI_I18N_DIR: L:\inetpub\wwwroot\glpi9.5/locales
GLPI_VERSION: 9.5.5
GLPI_SCHEMA_VERSION: 9.5.5
GLPI_MIN_PHP: 7.2.0
GLPI_YEAR: 2021

Libraries

htmlawed/htmlawed version 1.2.5 in (L:\inetpub\wwwroot\glpi9.5\vendor\htmlawed\htmlawed)
phpmailer/phpmailer version 6.1.6 in (L:\inetpub\wwwroot\glpi9.5\vendor\phpmailer\phpmailer\src)
simplepie/simplepie version 1.5.6 in (L:\inetpub\wwwroot\glpi9.5\vendor\simplepie\simplepie\library)
tecnickcom/tcpdf version 6.3.5 in (L:\inetpub\wwwroot\glpi9.5\vendor\tecnickcom\tcpdf)
michelf/php-markdown in (L:\inetpub\wwwroot\glpi9.5\vendor\michelf\php-markdown\Michelf)
true/punycode in (L:\inetpub\wwwroot\glpi9.5\vendor\true\punycode\src)
iamcal/lib_autolink in (L:\inetpub\wwwroot\glpi9.5\vendor\iamcal\lib_autolink)
sabre/dav in (L:\inetpub\wwwroot\glpi9.5\vendor\sabre\dav\lib\DAV)
sabre/http in (L:\inetpub\wwwroot\glpi9.5\vendor\sabre\http\lib)
sabre/uri in (L:\inetpub\wwwroot\glpi9.5\vendor\sabre\uri\lib)
sabre/vobject in (L:\inetpub\wwwroot\glpi9.5\vendor\sabre\vobject\lib)
laminas/laminas-cache in (L:\inetpub\wwwroot\glpi9.5\vendor\laminas\laminas-cache\src)
laminas/laminas-i18n in (L:\inetpub\wwwroot\glpi9.5\vendor\laminas\laminas-i18n\src)
laminas/laminas-serializer in (L:\inetpub\wwwroot\glpi9.5\vendor\laminas\laminas-serializer\src)
monolog/monolog in (L:\inetpub\wwwroot\glpi9.5\vendor\monolog\monolog\src\Monolog)
sebastian/diff in (L:\inetpub\wwwroot\glpi9.5\vendor\sebastian\diff\src)
elvanto/litemoji in (L:\inetpub\wwwroot\glpi9.5\vendor\elvanto\litemoji\src)
symfony/console in (L:\inetpub\wwwroot\glpi9.5\vendor\symfony\console)
scssphp/scssphp in (L:\inetpub\wwwroot\glpi9.5\vendor\scssphp\scssphp\src)
laminas/laminas-mail in (L:\inetpub\wwwroot\glpi9.5\vendor\laminas\laminas-mail\src\Protocol)
laminas/laminas-mime in (L:\inetpub\wwwroot\glpi9.5\vendor\laminas\laminas-mime\src)
rlanvin/php-rrule in (L:\inetpub\wwwroot\glpi9.5\vendor\rlanvin\php-rrule\src)
blueimp/jquery-file-upload in (L:\inetpub\wwwroot\glpi9.5\vendor\blueimp\jquery-file-upload\server\php)
ramsey/uuid in (L:\inetpub\wwwroot\glpi9.5\vendor\ramsey\uuid\src)
psr/log in (L:\inetpub\wwwroot\glpi9.5\vendor\psr\log\Psr\Log)
psr/simple-cache in (L:\inetpub\wwwroot\glpi9.5\vendor\psr\simple-cache\src)
mexitek/phpcolors in (L:\inetpub\wwwroot\glpi9.5\vendor\mexitek\phpcolors\src\Mexitek\PHPColors)
guzzlehttp/guzzle in (L:\inetpub\wwwroot\glpi9.5\plugins\oauthimap\vendor\guzzlehttp\guzzle\src)
guzzlehttp/psr7 in (L:\inetpub\wwwroot\glpi9.5\plugins\oauthimap\vendor\guzzlehttp\psr7\src)
wapmorgan/unified-archive in (L:\inetpub\wwwroot\glpi9.5\vendor\wapmorgan\unified-archive\src)
paragonie/sodium_compat in (L:\inetpub\wwwroot\glpi9.5\vendor\paragonie\sodium_compat\src)

LDAP directories

SQL replicas

Not active

Notifications

Way of sending emails: SMTP (@127.0.0.1)

Mails receivers

Plugins list

    accounts             Name: Accounts                       Version: 2.6.0      State: Enabled
    fields               Name: Additionnal fields             Version: 1.12.6.1   State: Enabled
    advancedplanning     Name: advancedplanning               Version: 0.2.0      State: Enabled
    appliances           Name: Appliances                     Version: 3.1.1      State: Enabled
    arsimplifiedchange   Name: AR Simplified Change           Version: 2.0.12     State: Enabled
    arsurveys            Name: AR Surveys                     Version: 3.0.1      State: Enabled
    arbehaviours         Name: ARaymond Behaviours            Version: 2.0.7      State: Enabled
    cleanarchivedemails  Name: Archived eMail clean           Version: 2.0.0      State: Enabled
    arlocations          Name: ARLocations                    Version: 0.2.9      State: Enabled
    impacts              Name: Asset impacts                  Version: 2.0.3      State: Enabled
    behaviors            Name: Behaviours                     Version: 2.4.1      State: Enabled
    chgmeridian          Name: CHG-Meridian                   Version: 2.1.0      State: Enabled
    colresize            Name: Colresize                      Version: 1.3.1      State: Enabled
    datainjection        Name: Data injection                 Version: 2.9.0      State: Enabled
    docversions          Name: Document Versions              Version: 0.1.0      State: Not installed
    formvalidation       Name: Form Validation                Version: 1.0.7      State: Enabled
    mailanalyzer         Name: Mail Analyzer                  Version: 2.0.1      State: Enabled
    mailbehaviours       Name: Mail Behaviours                Version: 1.0.3      State: Enabled
    mask                 Name: Mask                           Version: 3.0.1      State: Enabled
    mreporting           Name: More Reporting                 Version: 1.7.2      State: Enabled
    msurveys             Name: More Surveys                   Version: 2.1.1      State: Enabled
    oauthimap            Name: Oauth IMAP                     Version: 1.1.0      State: Enabled
    ocsinventoryng       Name: OCS Inventory NG               Version: 1.7.3      State: Enabled
    officeonline         Name: Office Online                  Version: 2.0.2      State: Enabled
    order                Name: Orders management              Version: 2.6.0      State: Enabled
    pdf                  Name: Print to pdf                   Version: 1.7.0.1    State: Enabled
    processmaker         Name: Process Maker                  Version: 4.0.3      State: Enabled
    rayusermanagementtic Name: RayUserManagementTicket        Version: 2.0.0      State: Enabled
    reports              Name: Reports                        Version: 1.14.1     State: Enabled
    simcard              Name: Sim cards management           Version: 1.4.2.7    State: Enabled
    manufacturersimports Name: Suppliers imports              Version: 2.3.0      State: Enabled
    ticketcleaner        Name: Ticket Cleaner                 Version: 3.0.0      State: Enabled
    timezones            Name: Timezones                      Version: 3.0.1      State: Enabled
    watermark            Name: Watermark                      Version: 1.0.0      State: Enabled

OCS Inventory NG
Host: 
Connection: Ok
Use the OCSNG software dictionary: No
[/code]

This issue could be linked to the fact that we have more than 6000 entities in our GLPI instance. With up to 6 levels. And all entities are inheriting from the root entity.

Thank you Regards,

Tomolimo

cedric-anne commented 3 years ago

This issue could be linked to the fact that we have more than 6000 entities in our GLPI instance. With up to 6 levels. And all entities are inheriting from the root entity.

Indeed, inquest uses many config values and each are retrieved, for each entity, whenever there is no created inquest. IMHO we may improve this kind of cases by adding a global caching logic on entities configuration (but it may require some refactoring).

github-actions[bot] commented 3 years ago

There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.

If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.