cedric-anne
commented
8 months ago Hi,
It is probably the same bug as reported in #9913. Could you ensure that your default PHP timezone and your default MySQL timezone are identical ?
Closed pippo571 closed 8 months ago
cedric-anne
commented
8 months ago Hi,
It is probably the same bug as reported in #9913. Could you ensure that your default PHP timezone and your default MySQL timezone are identical ?
pippo571
commented
8 months ago Hello,
This indeed seems to solve the problem.
I had a difference of 1 hour between PHP and MariaDB time, both were using their default value (system timezone for MariaDB and UTC for PHP), setting PHP to my system timezone solved the issue, the tickets are now created correcty and not duplicated anymore.
Thanks :)
cedric-anne
commented
8 months ago Thanks for the feedback, I close this issue as it duplicates #9913.
Code of Conduct
Is there an existing issue for this?
Version
10.0.12
Bug description
Hello,
I have a problem with (some of) my recurring tickets after upgrading to version 10.0.12.
When a recurring ticket is created, it is then duplicated every 5 minutes until I set it to "Active : No".
This does not happen with all my recurring tickets. All the recurring tickets (impacted or not) were present before the upgrade.
All duplicated tickets are created with the same opening date, and their last update time is 1 hour before, incrementing by the duplication time, then updates the opening date after last update = opening date. Example that I reproduced today :
I also tried to create a new recurring ticket using a new ticket template with only description and title as predefined fields, same problem.
RecurrentItems automatic action is set to run in CLI mode every 5 minutes, no error in the task logs in GLPI, get "1 Action completed, fully processed" for all tickets.
Tried to move the recurring ticket to another entity, did not help. Tried to clone ticket and delete the original, same result. Tried to delete and
All recurring tickets use the same calendar. All are visible for sub entities. None have an end date. Some impacted and non-impacted tickets are in the same entity.
Relevant log output
Cannot find any relevant logs for that.
Page URL
No response
Steps To reproduce
Set the automatic action "RecurrentItems" to run in CLI mode every 5 minutes.
Set cron for GLPI in your server crontab (that must be set in the crontab of the user running your webserver):
*/5 * * * * /usr/bin/php /var/www/glpi/front/cron.php &>/dev/nullCreate a new ticket template.
Add predefined fields :
Create a recurring ticket that is active and uses the template you created at step 1 and 2.
No end date, no preliminary creation, use the default calendar.
Set periodicity to 1 hour.
Set a start date.
Wait for the ticket to be created.
Every 5 minutes after that, a duplicate should be created.
Set the recurring ticket to "Active: No" or delete it to stop the duplicates from being generated.
Your GLPI setup information
Information about system installation & configuration
Server
Operating system: Linux elrond 5.10.0-27-amd64 #1 SMP Debian 5.10.205-2 (2023-12-31) x86_64 PHP 8.3.2-1+0~20240120.16+debian11~1.gbpb43448 fpm-fcgi (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, random, 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" disable_functions="" Software: nginx/1.18.0 Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:123.0) Gecko/20100101 Firefox/123.0 Server Software: Debian 11 Server Version: 10.5.21-MariaDB-0+deb11u1 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.3.2-1+0~20240120.16+debian11~1.gbpb43448) 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.21) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /var/lib/glpi/_cache has been validated. Write access to /var/lib/glpi/_cron has been validated. Write access to /var/lib/glpi has been validated. Write access to /var/lib/glpi/_dumps has been validated. Write access to /var/lib/glpi/_graphs has been validated. Write access to /var/lib/glpi/_lock has been validated. Write access to /var/lib/glpi/_pictures has been validated. Write access to /var/lib/glpi/_plugins has been validated. Write access to /var/lib/glpi/_rss has been validated. Write access to /var/lib/glpi/_sessions has been validated. Write access to /var/lib/glpi/_tmp has been validated. Write access to /var/lib/glpi/_uploads has been validated. 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/glpi/marketplace has been validated. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
Anything else?
No response