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.1k stars 1.27k forks source link

Top right Search box - 10.0.5 #13285

Closed SignalsITltd closed 1 year ago

SignalsITltd commented 1 year ago

Code of Conduct

Is there an existing issue for this?

Version

10.0.5

Bug description

Hi,

Since updating from version 10.0.3 to 10.0.5, every time I use the top right Search, Glpi freezes

we have 22000 assets, all of them have pdf documents attached and 10000 tickets

I've tried changing PHP memory limit to -1 but that made no difference

Regards,

Relevant log output

No errors showing on -error.log files

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Operating system: Linux ########.####.### 5.15.0-52-generic #58-Ubuntu SMP Thu Oct 13 08:03:55 UTC 2022 x86_64 PHP 8.1.9 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, 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="600" memory_limit="1024M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: Apache/2.4.52 (Ubuntu) (Apache/2.4.52 (Ubuntu) Server at ############# Port ### ) Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.42 Server Software: Ubuntu 22.04 Server Version: 10.6.7-MariaDB-2ubuntu1.1 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpi@localhost/glpi Host info: Localhost via UNIX socket

PHP version (8.1.9) is supported.PHP version (8.1.9) is supported. Sessions configuration is OK.Sessions configuration is OK. Allocated memory is sufficient.Allocated memory is sufficient. mysqli extension is installed.mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml.Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed.curl extension is installed. gd extension is installed.gd extension is installed. intl extension is installed.intl extension is installed. libxml extension is installed.libxml extension is installed. zlib extension is installed.zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.6.7) is supported.Database engine version (10.6.7) is supported. No files from previous GLPI version detected.No files from previous GLPI version detected. The log file has been created successfully.The log file has been created successfully. Write access to /var/lib/glpi/files/_cache has been validated. Write access to /etc/glpi/ has been validated. Write access to /var/lib/glpi/files/_cron has been validated. Write access to /var/lib/glpi/files has been validated. Write access to /var/lib/glpi/files/_dumps has been validated. Write access to /var/lib/glpi/files/_graphs has been validated. Write access to /var/lib/glpi/files/_lock has been validated. Write access to /var/lib/glpi/files/_pictures has been validated. Write access to /var/lib/glpi/files/_plugins has been validated. Write access to /var/lib/glpi/files/_rss has been validated. Write access to /var/lib/glpi/files/_sessions has been validated. Write access to /var/lib/glpi/files/_tmp has been validated. Write access to /var/lib/glpi/files/_uploads has been validated.Write access to /var/lib/glpi/files/_cache has been validated. Write access to /etc/glpi/ has been validated. Write access to /var/lib/glpi/files/_cron has been validated. Write access to /var/lib/glpi/files has been validated. Write access to /var/lib/glpi/files/_dumps has been validated. Write access to /var/lib/glpi/files/_graphs has been validated. Write access to /var/lib/glpi/files/_lock has been validated. Write access to /var/lib/glpi/files/_pictures has been validated. Write access to /var/lib/glpi/files/_plugins has been validated. Write access to /var/lib/glpi/files/_rss has been validated. Write access to /var/lib/glpi/files/_sessions has been validated. Write access to /var/lib/glpi/files/_tmp has been validated. Write access to /var/lib/glpi/files/_uploads has been validated. GLPI data directories are located in a secured path.GLPI data directories are located in a secured path. Sessions configuration is secured.Sessions configuration is secured. exif extension is installed.exif extension is installed. ldap extension is installed.ldap extension is installed. openssl extension is installed.openssl extension is installed. zip extension is installed.zip extension is installed. bz2 extension is installed.bz2 extension is installed. Zend OPcache extension is installed.Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium.Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /var/www/glpi/marketplace has been validated.Write access to /var/www/glpi/marketplace has been validated. Timezones seems loaded in database.Timezones seems loaded in database.

Anything else?

No response

cconard96 commented 1 year ago

Please switch to a profile with the permission to update the configuration (super-admin for example) and enable debug mode (option is under the top-right dropdown). After performing a global search, click the bug icon in the top right to open the debug panel.

Please let us know the information from the Summary tab, and then which queries are slow (if any) under the SQL requests tab.

SignalsITltd commented 1 year ago

image

This is the only slow query, most of the others are 0.0xx Can't find a Summary tab

cedric-anne commented 1 year ago

Maybe it is not related to GLPI update itself, but to a change in fields displayed in default view of Software search page. You should try to go to Software search page, do a search, and see if you have the same issue there. Then, you would be able to remove displayed columns one by one until you get acceptable response time.

SignalsITltd commented 1 year ago

Hi,

I couldn't go on software, it just got stuck and wouldn't load, so I.ve emptied the DB table and now all works fine.

We never used the Assets software, we had quite a few items there probably added by the OCSng plugin

It wasn't getting stuck the on version 1.0.3 or earlier, maybe something went wrong with the DB upgrade

Regards,

cedric-anne commented 1 year ago

so I.ve emptied the DB table and now all works fine.

So now you probably have unexpected orphan data in some tables. Not sure it was a good idea.

SignalsITltd commented 1 year ago

yes, you were right,

I backed up the DB before messing with it

I had to recover the glpi_softwares table from the backup but it seems to be working fine now,

I can now see softwares with no issues 🤷‍♂️

cedric-anne commented 1 year ago

Maybe it was a database server issue.

As problem seems to be fixed now, I close the issue.