Forum GLPI-Project

It_from_med

Member

Registered: 2022-01-25

Posts: 10

glpi:migration:timestamps failed on glpi_logs error 1206

Hello everyone,

I am trying to update a glpi 9.2.3 to 9.5.7. All went well for the update of the data base except when I play the command PHP glpi:migration:timestamps. I have this error message which appears after 1h30!

      DBmysql::query() in /var/www/glpi/inc/dbmysql.class.php line 335
        *** MySQL query error:
        SQL: ALTER TABLE `glpi_logs`
               MODIFY COLUMN `date_mod` TIMESTAMP NULL DEFAULT NULL;

        Error: The total number of locks exceeds the lock table size
        Backtrace :
        ...nsole/migration/timestampscommand.class.php:203
        vendor/symfony/console/Command/Command.php:255     Glpi\Console\Migration\TimestampsCommand->execute()
        vendor/symfony/console/Application.php:1000        Symfony\Component\Console\Command\Command->run()
        inc/console/application.class.php:249              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 "1206": The total number of locks exceeds the lock table size in query "ALTER TABLE `glpi_logs`
               MODIFY COLUMN `date_mod` TIMESTAMP NULL DEFAULT NULL;
      "
      Mise à jour de  `glpi_logs` échouée avec le message "(1206) The total number of locks exceeds the lock table size".

I searched on the internet, some say to increase the variable "innodb_buffer_pool_size" so I went to modify my file /etc/mysql/conf.d/mysql.cnf by adding first "=1G" then "=10G" (yes I played it twice) with no difference in the result. Would you have an idea ?

Thanks

Last edited by It_from_med (2023-02-11 14:42:34)