Forum GLPI-Project

stepand

Member

Registered: 2016-08-04

Posts: 24

Problem after upgrade from glpi 9.4.6 to 9.5.7 - ticket.form.php

Hi,
after upgrading to a new version, I have a speed problem by loading the form request form in the Technician role. When loading the form for entering a request in the technician role, the browser waits for about 1 minute before displaying the form. Waiting browser points to processing ticket.form.php - wating (TTFB)

https://glpi/ajax/common.tabs.php?_target=/tupgrade/front/ticket.form.php&_itemtype=Ticket&_glpi_tab=Ticket$main&id=0

This only happens when entering a request as a Technician. by entering ticket as a Self-Service is the loading speed of form OK.

Some idea?

Thanks

---

########################
GLPI 9.5.13 /Ubuntu 20.04 LTS
Apache/2.4.41 - PHP 7.4.33 - MariaDB: 10.5.20
Certificate ITILv3-2011

stepand

Member

Registered: 2016-08-04

Posts: 24

Re: Problem after upgrade from glpi 9.4.6 to 9.5.7 - ticket.form.php

Configuration of my server

GLPI 9.5.7 /Ubuntu 20.04 LTS
Apache/ 2.4.41 - PHP 7.4.30 - MariaDB: 10.5.16

It hapens after the migration column types in DB from datetime to timestamp

---

########################
GLPI 9.5.13 /Ubuntu 20.04 LTS
Apache/2.4.41 - PHP 7.4.33 - MariaDB: 10.5.20
Certificate ITILv3-2011

stepand

Member

Registered: 2016-08-04

Posts: 24

Re: Problem after upgrade from glpi 9.4.6 to 9.5.7 - ticket.form.php

Hi,
I identified one slow sql query

SELECT DISTINCT `glpi_softwareversions`.`name` AS `version`, `glpi_softwares`.`name` AS `name`, `glpi_softwares`.`id`
FROM `glpi_items_softwareversions`
LEFT JOIN `glpi_softwareversions` ON (`glpi_items_softwareversions`.`softwareversions_id` = `glpi_softwareversions`.`id`)
LEFT JOIN `glpi_softwares` ON (`glpi_softwareversions`.`softwares_id` = `glpi_softwares`.`id`)
WHERE `glpi_items_softwareversions`.`items_id` IN ('481', '1344', '670', '211', '1771', '1041') AND `glpi_items_softwareversions`.`itemtype` = 'Computer' AND `glpi_softwares`.`is_helpdesk_visible` = '1' AND (`glpi_softwares`.`entities_id` = '0')
ORDER BY `glpi_softwares`.`name`;

this query was 72,31s long. Is some posibility to fast this query?

---

########################
GLPI 9.5.13 /Ubuntu 20.04 LTS
Apache/2.4.41 - PHP 7.4.33 - MariaDB: 10.5.20
Certificate ITILv3-2011

stepand

Member

Registered: 2016-08-04

Posts: 24

Re: Problem after upgrade from glpi 9.4.6 to 9.5.7 - ticket.form.php

Hi,
I solved the problem.
The problem was with indexes in table glpi_softwareversions. After the change data types in the table by the script, the indexes have been corrupted. The solution is export the ntire database and then import in the empty database. The indexes fixed.

---

########################
GLPI 9.5.13 /Ubuntu 20.04 LTS
Apache/2.4.41 - PHP 7.4.33 - MariaDB: 10.5.20
Certificate ITILv3-2011