cedric-anne
commented
1 year ago Hi,
Indeed, non interactive mode will block the update as schema produced by 10.0.8 update is different than expected.
CLI migration from to from GLPI 10.0.7 to GLPI 10.0.8 was certainly returning an error code. If you process updates using a script in non-interactive mode, you should probably handle error result code to detect update issues and fix them.
Anyway, we will not solve this specific case as it would require too many code, and we expect administrators to have fix the 10.0.7->10.0.8 migration issue when command tell them that there was a problem.
dani
Code of Conduct
Is there an existing issue for this?
Version
10.0.8
Bug description
I've updated my 10.0.7 instance to 10.0.8 last week, and everything was fine. Today, trying to update to 10.0.9 fails
If I run database:check_schema_integrity
It looks like the update from 10.0.7 to 10.0.8 did not create the event column in the glpi_queuednotifications table, which is now preventing further upgrades. Only uninteractive update are affected. I can upgrade the DB from the web interface (and most likely from the cli if I omit -n and validate the upgrade)
Relevant log output
No response
Page URL
No response
Steps To reproduce
Your GLPI setup information
Informations sur le système, l'installation et la configuration
Server
Operating system: Linux web1 4.18.0-477.13.1.el8_8.x86_64 #1 SMP Tue May 30 14:53:41 EDT 2023 x86_64 PHP 8.1.21 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, igbinary, imagick, imap, intl, json, ldap, libxml, mbstring, memcached, msgpack, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, session, shmop, snmp, soap, sockets, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="256M" post_max_size="100M" safe_mode="" session.save_handler="files" upload_max_filesize="100M" Software: Apache () Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Server Software: MariaDB Server Server Version: 10.6.14-MariaDB Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpi_1@db/glpi_1 Host info: db via TCP/IP PHP version (8.1.21) 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.6.14) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /opt/glpi_1/data/_cache has been validated. Write access to /opt/glpi_1/web/config has been validated. Write access to /opt/glpi_1/data/_cron has been validated. Write access to /opt/glpi_1/data/_files has been validated. Write access to /opt/glpi_1/data/_dumps has been validated. Write access to /opt/glpi_1/data/_graphs has been validated. Write access to /opt/glpi_1/data/_lock has been validated. Write access to /opt/glpi_1/data/_pictures has been validated. Write access to /opt/glpi_1/data/_plugins has been validated. Write access to /opt/glpi_1/data/_rss has been validated. Write access to /opt/glpi_1/sessions has been validated. Write access to /opt/glpi_1/tmp has been validated. Write access to /opt/glpi_1/tmp has been validated. PHP Warning (2): file_exists(): open_basedir restriction in effect. File(/usr/sbin/getenforce) is not within the allowed path(s): (/opt/glpi_1:/usr/share/pear/:/usr/share/php/:/etc/redhat-release) in /opt/glpi_1/web/src/System/Requirement/SeLinux.php at line 52 Web server root directory configuration seems safe. PHP directive "session.cookie_secure" should be set to "on" when GLPI can be accessed on HTTPS protocol. 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. Following extensions are not present: sodium. Write access to /opt/glpi_1/web/marketplace has been validated. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
LDAP directories
Server: 'dc3', Port: '389', BaseDN: 'DC=local,DC=org', Connection filter: '(&(objectClass=user)(objectCategory=person)(|(memberOf=CN=Domain Admins,OU=Groups,DC=local,DC=org)(memberOf=CN=Equipe,OU=Groups,DC=local,DC=org)))', RootDN: 'glpi@local.org', Use TLS: '1'SQL replicas
Notifications
Plugins list
mydashboard Name: Dashboard Version: 2.1.5 State: Installed / not activated Install Method: Manual tag Name: Gestion des tags Version: 2.11.2 State: Installed / not activated Install Method: ManualAnything else?
No response