You are not logged in.
Bonjour,
Lorsque je tente la mise à jour de la BDD par la console, j'ai ce message :
[root@xxx glpi]# php bin/console db:update
Certains prérequis système optionnels sont manquants. Lancez "php bin/console glpi:system:check_requirements" pour plus de détails.
+------------------------------------+-----------+-------+
| | Actuel | Cible |
+------------------------------------+-----------+-------+
| Hôte de la base de données | localhost | |
| Nom de la base de données | glpi | |
| Utilisateur de la base de données | glpi | |
| Version de GLPI | 9.4.5 | 9.5.0 |
| Version de la base de données GLPI | 9.4.5 | 9.5.0 |
+------------------------------------+-----------+-------+
Voulez-vous continuer ? [Yes/no]y
====================================== Mise à jour en 9.4.6 =======================================
====================================== Mise à jour en 9.4.7 =======================================
====================================== Mise à jour en 9.5.0 =======================================
============================= Rename "AuthLdap" itemtype to "AuthLDAP" =============================
============================= Rename "Crontask" itemtype to "CronTask" =============================
============================== Rename "InfoCom" itemtype to "Infocom" ==============================
PHP Warning: mysqli::query(): MySQL server has gone away in /var/www/html/glpi/inc/dbmysql.class.php on line 298
PHP Warning: mysqli::query(): Error reading result set's header in /var/www/html/glpi/inc/dbmysql.class.php on line 298
DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 305
*** MySQL query error:
SQL: UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap'
Error: MySQL server has gone away
Backtrace :
inc/dbmysql.class.php:339
inc/migration.class.php:759 DBmysql->queryOrDie()
install/update_94_95.php:2089 Migration->executeMigration()
inc/update.class.php:475 update94to95()
inc/console/database/updatecommand.class.php:160 Update->doUpdates()
vendor/symfony/console/Command/Command.php:255 Glpi\Console\Database\UpdateCommand->execute()
vendor/symfony/console/Application.php:1000 Symfony\Component\Console\Command\Command->run()
inc/console/application.class.php:232 Symfony\Component\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:271 Glpi\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:147 Symfony\Component\Console\Application->doRun()
bin/console:102 Symfony\Component\Console\Application->run()
SQL Error "2006": MySQL server has gone away in query "UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap'"
In dbmysql.class.php line 349:
- Erreur durant l'éxecution de la requête : UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap' - L'erreur est MySQL server has gone away
glpi:database:update [-u|--allow-unstable] [-f|--force]
Pouvez vous m'aider?
Merci.
Cordialement,
Last edited by supertracteur (2020-07-15 17:37:58)
Offline
Hello,
J'ai exactement le même problème sur la même table SQL lorsque je veux mettre à jour la BDD vers 9.5.
Voici la configuration de mon serveur.
Server
Operating system: Linux support-info 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64
PHP 7.3.19-1~deb10u1 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu,
calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring,
mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem,
sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zlib)
Setup: max_execution_time="600" memory_limit="512M" post_max_size="20M" safe_mode="" session.save_handler="files"
upload_max_filesize="20M"
Software: Apache/2.4.25 (Debian) (Apache/2.4.25 (Debian) Server at support-info Port 80)
Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0
Server Software: Debian 9.1
Server Version: 10.1.26-MariaDB-0+deb9u1
Server SQL Mode:
Parameters: GLPI@localhost/glpi_db
Host info: Localhost via UNIX socket
mysqli extension is installed
ctype extension is installed
fileinfo extension is installed
json extension is installed
mbstring extension is installed
iconv extension is installed
zlib extension is installed
curl extension is installed
gd extension is installed
simplexml extension is installed
xml extension is installed
ldap extension is installed
imap extension is installed
Zend OPcache extension is installed
APCu extension is installed
xmlrpc extension is installed
CAS extension is installed
exif extension is installed
Database version seems correct (10.1.26) - Perfect!Database version seems correct (10.1.26) - Perfect!
OK/var/www/glpi/files/_log : OK
OK/var/www/glpi/config : OK
OK/var/www/glpi/files : OK
OK/var/www/glpi/files/_dumps : OK
OK/var/www/glpi/files/_sessions : OK
OK/var/www/glpi/files/_cron : OK
OK/var/www/glpi/files/_graphs : OK
OK/var/www/glpi/files/_lock : OK
OK/var/www/glpi/files/_plugins : OK
OK/var/www/glpi/files/_tmp : OK
OK/var/www/glpi/files/_cache : OK
OK/var/www/glpi/files/_rss : OK
OK/var/www/glpi/files/_uploads : OK
OK/var/www/glpi/files/_pictures : OK
Web access to files directory is protectedWeb access to files directory is protected : OK
Libraries
htmLawed version 1.2.4 in (/var/www/glpi/lib/htmlawed)
phpmailer/phpmailer version 6.0.7 in (/var/www/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.2 in (/var/www/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.2.26 in (/var/www/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/glpi/vendor/iamcal/lib_autolink)
sabre/vobject in (/var/www/glpi/vendor/sabre/vobject/lib)
zendframework/zend-cache in (/var/www/glpi/vendor/zendframework/zend-cache/src)
zendframework/zend-i18n in (/var/www/glpi/vendor/zendframework/zend-i18n/src)
zendframework/zend-serializer in (/var/www/glpi/vendor/zendframework/zend-serializer/src)
monolog/monolog in (/var/www/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/glpi/vendor/sebastian/diff/src)
elvanto/litemoji in (/var/www/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/glpi/vendor/symfony/console)
leafo/scssphp in (/var/www/glpi/vendor/leafo/scssphp/src)
phpCas version 1.3.6 in (/usr/share/php/CAS/source)
LDAP directories
Server: 'xxxx', Port: '389', BaseDN: 'DC=xxxx,DC=local', Connection filter:
'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN: 'xxxx\S_GLPI', Use
TLS: none
SQL replicas
Not active
Notifications
Way of sending emails: PHP
Mails receivers
Name: 'support-info@vss-sas.com' Active: Yes
Server: '{172.17.49.101:143/imap/novalidate-cert/notls}INBOX' Login: 'support-info' Password: Yes
Plugins list
behaviors Name: Comportements Version: 2.2.2 State: Enabled
datainjection Name: Data injection Version: 2.7.1 State: Enabled
mailanalyzer Name: Mail Analyzer Version: 1.6.1 State: Enabled
moreticket Name: More ticket Version: 1.5.1 State: Enabled
ocsinventoryng Name: OCS Inventory NG Version: 1.6.0 State: Enabled
dashboard Name: Tableau de bord Version: 0.9.8 State: Enabled
OCS Inventory NG
Host: localhost
Connection: Ok
Use the OCSNG software dictionary: No
voici l’erreur rencontrée lors de la mise à jour de la DB ....
SQL: UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap'
Error: MySQL server has gone away
Backtrace :
inc/dbmysql.class.php:339
inc/migration.class.php:759 DBmysql->queryOrDie()
install/update_94_95.php:2089 Migration->executeMigration()
inc/update.class.php:475 update94to95()
inc/console/database/updatecommand.class.php:160 Update->doUpdates()
vendor/symfony/console/Command/Command.php:255 Glpi\Console\Database\UpdateCommand->execute()
vendor/symfony/console/Application.php:1000 Symfony\Component\Console\Command\Command->run()
inc/console/application.class.php:232 Symfony\Component\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:271 Glpi\Console\Application->doRunCommand()
vendor/symfony/console/Application.php:147 Symfony\Component\Console\Application->doRun()
bin/console:102 Symfony\Component\Console\Application->run()
SQL Error "2006": MySQL server has gone away in query "UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap'"
In dbmysql.class.php line 349:
- Erreur durant l'éxecution de la requête : UPDATE `glpi_items_softwareversions` SET `it
emtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap' - L'erreur est MySQL server has gone
away
Dans le fichier de logs mysql j'ai ca :
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f453f030020): UPDATE `glpi_items_softwareversions` SET `itemtype` = 'AuthLDAP' WHERE `itemtype` = 'AuthLdap'
Connection ID (thread ID): 3
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=o n,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
The manual page at XXX contains
information that should help you find out what is causing the crash.
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: The InnoDB memory heap is disabled
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Using Linux native AIO
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Using SSE crc32 instructions
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Completed initialization of buffer pool
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Highest supported file format is Barracuda.
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: The log sequence number 19003106439 in ibdata file do not match the log sequence number 19003106519 in the ib_logfiles!
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: 128 rollback segment(s) are active.
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Waiting for purge to start
2020-07-13 16:13:17 140456899855296 [Note] InnoDB: Percona XtraDB 5.6.36-82.1 started; log sequence number 19003106519
2020-07-13 16:13:17 140456281241344 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-07-13 16:13:17 140456899855296 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-13 16:13:17 140456899855296 [Note] Recovering after a crash using tc.log
2020-07-13 16:13:17 140456899855296 [Note] Starting crash recovery...
2020-07-13 16:13:17 140456899855296 [Note] Crash recovery finished.
2020-07-13 16:13:17 140456899855296 [Note] Server socket created on IP: '127.0.0.1'.
2020-07-13 16:13:17 140456899855296 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.26-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 9.1
2020-07-13 16:16:19 140456899008256 [ERROR] Found index itemtype whose column info does not match that of MySQL.
2020-07-13 16:16:19 140456899008256 [ERROR] Build InnoDB index translation table for Table ./glpi_db/glpi_items_softwareversions failed
2020-07-13 16:16:19 140456899008256 [ERROR] Index itemtype of glpi_db/glpi_items_softwareversions has 1 columns unique inside InnoDB, but MySQL is asking statistics for 2 columns. Have you mixed up .frm files from different installations? See XXX
2020-07-13 16:16:19 140456899008256 [ERROR] Index items_id of glpi_db/glpi_items_softwareversions has 1 columns unique inside InnoDB, but MySQL is asking statistics for 2 columns. Have you mixed up .frm files from different installations? See XXX
2020-07-13 16:16:19 140456899008256 [ERROR] Index item of glpi_db/glpi_items_softwareversions has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See XXX
Merci de votre aide,
Nicolas
Last edited by nicolaay (2020-07-14 13:07:36)
Offline
Ok j'ai trouvé la solution, j'ai fais une installation propre de glpi 9.5 sur une autre VM.
Ensuite j'ai exporter la table qui posait problème avec cette commande
/home/nicolas# mysqldump --databases glpi --tables glpi_items_softwareversions > computers.sql
j'ai ensuite importé la table sur ma base de prod avec la commande
mysql glpi_db < computers.sql
Installation et migration OK.
Bon courage.
Last edited by nicolaay (2020-07-15 17:15:25)
Offline
La table au format txt
-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: glpi_db
-- ------------------------------------------------------
-- Server version 10.1.26-MariaDB-0+deb9u1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `glpi_items_softwareversions`
--
DROP TABLE IF EXISTS `glpi_items_softwareversions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `glpi_items_softwareversions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`items_id` int(11) NOT NULL DEFAULT '0',
`itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`softwareversions_id` int(11) NOT NULL DEFAULT '0',
`is_deleted_item` tinyint(1) NOT NULL DEFAULT '0',
`is_template_item` tinyint(1) NOT NULL DEFAULT '0',
`entities_id` int(11) NOT NULL DEFAULT '0',
`is_deleted` tinyint(1) NOT NULL DEFAULT '0',
`is_dynamic` tinyint(1) NOT NULL DEFAULT '0',
`date_install` date DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unicity` (`itemtype`,`items_id`,`softwareversions_id`),
KEY `items_id` (`items_id`),
KEY `itemtype` (`itemtype`),
KEY `item` (`itemtype`,`items_id`),
KEY `softwareversions_id` (`softwareversions_id`),
KEY `computers_info` (`entities_id`,`is_template_item`,`is_deleted_item`),
KEY `is_template` (`is_template_item`),
KEY `is_deleted` (`is_deleted_item`),
KEY `is_dynamic` (`is_dynamic`),
KEY `date_install` (`date_install`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `glpi_items_softwareversions`
--
LOCK TABLES `glpi_items_softwareversions` WRITE;
/*!40000 ALTER TABLE `glpi_items_softwareversions` DISABLE KEYS */;
/*!40000 ALTER TABLE `glpi_items_softwareversions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2020-07-15 2:21:48Tiens moi au courant
Nicolas
Last edited by nicolaay (2020-07-15 16:57:04)
Offline
Je ne peux pas envoyer de lien du fichier dump SQL de la table glpi_items_softwareversions, qu'il faut importer avant de lancer la mise à jour de la BDD vers 9.5.
Combine : voici le lien https, après sharepoint c'est .com | il s'agit d'un lien OneDrive.
duclot-my.sharepoint/:u:/g/personal/ntrophime_vss-sas_com/ET84A_YYc5BMtmWzRmfbu9gBNNd15LhAhgfixxyqV_NNbw?e=60QFX9
Sinon le voici en format TXT.
-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: glpi_db -- ------------------------------------------------------ -- Server version 10.1.26-MariaDB-0+deb9u1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `glpi_items_softwareversions` -- DROP TABLE IF EXISTS `glpi_items_softwareversions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `glpi_items_softwareversions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `items_id` int(11) NOT NULL DEFAULT '0', `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `softwareversions_id` int(11) NOT NULL DEFAULT '0', `is_deleted_item` tinyint(1) NOT NULL DEFAULT '0', `is_template_item` tinyint(1) NOT NULL DEFAULT '0', `entities_id` int(11) NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `is_dynamic` tinyint(1) NOT NULL DEFAULT '0', `date_install` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unicity` (`itemtype`,`items_id`,`softwareversions_id`), KEY `items_id` (`items_id`), KEY `itemtype` (`itemtype`), KEY `item` (`itemtype`,`items_id`), KEY `softwareversions_id` (`softwareversions_id`), KEY `computers_info` (`entities_id`,`is_template_item`,`is_deleted_item`), KEY `is_template` (`is_template_item`), KEY `is_deleted` (`is_deleted_item`), KEY `is_dynamic` (`is_dynamic`), KEY `date_install` (`date_install`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `glpi_items_softwareversions` -- LOCK TABLES `glpi_items_softwareversions` WRITE; /*!40000 ALTER TABLE `glpi_items_softwareversions` DISABLE KEYS */; /*!40000 ALTER TABLE `glpi_items_softwareversions` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-07-15 2:21:48Tiens moi au courant
Nicolas
Merci Nicolas.
Tu peux annuler le lien ONEDrive, le format txt est parfait pour les autres.
J'ai inséré la table en suivant tes instructions et j'ai le meme souci. Pas de souci sur mysqldump mais la mise à jour de la base coince toujours.
Cordialement,
Last edited by supertracteur (2020-07-15 16:54:56)
Offline
nicolaay wrote:Je ne peux pas envoyer de lien du fichier dump SQL de la table glpi_items_softwareversions, qu'il faut importer avant de lancer la mise à jour de la BDD vers 9.5.
Combine : voici le lien https, après sharepoint c'est .com | il s'agit d'un lien OneDrive.
duclot-my.sharepoint/:u:/g/personal/ntrophime_vss-sas_com/ET84A_YYc5BMtmWzRmfbu9gBNNd15LhAhgfixxyqV_NNbw?e=60QFX9
Sinon le voici en format TXT.
-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: glpi_db -- ------------------------------------------------------ -- Server version 10.1.26-MariaDB-0+deb9u1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `glpi_items_softwareversions` -- DROP TABLE IF EXISTS `glpi_items_softwareversions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `glpi_items_softwareversions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `items_id` int(11) NOT NULL DEFAULT '0', `itemtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `softwareversions_id` int(11) NOT NULL DEFAULT '0', `is_deleted_item` tinyint(1) NOT NULL DEFAULT '0', `is_template_item` tinyint(1) NOT NULL DEFAULT '0', `entities_id` int(11) NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `is_dynamic` tinyint(1) NOT NULL DEFAULT '0', `date_install` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unicity` (`itemtype`,`items_id`,`softwareversions_id`), KEY `items_id` (`items_id`), KEY `itemtype` (`itemtype`), KEY `item` (`itemtype`,`items_id`), KEY `softwareversions_id` (`softwareversions_id`), KEY `computers_info` (`entities_id`,`is_template_item`,`is_deleted_item`), KEY `is_template` (`is_template_item`), KEY `is_deleted` (`is_deleted_item`), KEY `is_dynamic` (`is_dynamic`), KEY `date_install` (`date_install`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `glpi_items_softwareversions` -- LOCK TABLES `glpi_items_softwareversions` WRITE; /*!40000 ALTER TABLE `glpi_items_softwareversions` DISABLE KEYS */; /*!40000 ALTER TABLE `glpi_items_softwareversions` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-07-15 2:21:48Tiens moi au courant
Nicolas
Merci Nicolas.
Tu peux annuler le lien ONEDrive, le format txt est parfait pour les autres.
J'ai inséré la table en suivant tes instructions et j'ai le meme souci. Pas de souci sur mysqldump mais la mise à jour de la base coince toujours.
Cordialement,
Je suis desolé j'ai fais une erreur dans mon précedent post c'est pour ca que ca ne fonctionne pas chez toi.
Ca me met la puce à l'oreille quand je vois ton dernier post parler de mysqldump. Il ne faut pas faire un mysqldump pour importer la table, ce n'est que pour l'exporter..
Pour l'importer fais plutôt
mysql nomdelabase < nomdufichier.sql J'ai modifié pour ceux qui vont me relire =/
Cordialement,
Nicolas
Last edited by nicolaay (2020-07-15 17:16:53)
Offline
Bonjour Nicolas,
Je ne fais plus de citations sinon le post va etre trop long ^^
en fait, le simple fait de dropper la table semble avoir fait son effet.
Le script a pu se lancer et se terminer correctement.
MariaDB [glpi]> DROP TABLE glpi_items_softwareversions;
Merci beaucoup pour ton aide.
Nous allons maintenant tester cette nouvelle version (gros changement cosmétique c'est bien).
Je mets le post en résolu.
Cordialement,
Supertracteur.
Offline