You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-06-29 10:48:54

leval
Member
From: Bruxelles
Registered: 2015-04-27
Posts: 5
Website

388 tables not migrated to InnoDB engine.

Hi,

I have updated my glpi to 9.3 and i have this message :

388 tables not migrated to InnoDB engine.

What should i do to fix this ?

Thanks,

Valentin.

Offline

#2 2018-06-29 11:00:13

cirtaz
Member
Registered: 2018-02-13
Posts: 25

Re: 388 tables not migrated to InnoDB engine.

Hi
Goto ./glpi/scripts/ and run "php innodb_migration.php"

Offline

#3 2018-06-29 11:22:20

leval
Member
From: Bruxelles
Registered: 2015-04-27
Posts: 5
Website

Re: 388 tables not migrated to InnoDB engine.

Ok it's work

big thanks

Offline

#4 2018-06-29 12:38:53

DimmKo
Member
Registered: 2018-04-17
Posts: 14
Website

Re: 388 tables not migrated to InnoDB engine.

Thank's for you help!

Offline

#5 2018-07-02 15:05:38

Nyctalope
Member
Registered: 2016-08-26
Posts: 8

Re: 388 tables not migrated to InnoDB engine.

Thanks for the help

Offline

#6 2018-07-03 08:10:25

nimek20
Member
Registered: 2018-07-03
Posts: 14

Re: 388 tables not migrated to InnoDB engine.

I am using the GLPI version for the WIndows system. I can not run the php innodb_migration.php script. I am trying to run in the following way: I run Firefox and type: localhost / glpi / scripts / innodb_migration.php and display the error 403

Thanks,

Mirek

Offline

#7 2018-07-03 08:50:02

orthagh
Administrator
From: TECLIB - CAEN
Registered: 2010-11-30
Posts: 662
Website

Re: 388 tables not migrated to InnoDB engine.

@nimek20
on windows you can execute the script with command line (administrator privilege)
The command is still

Goto (cd) ./glpi/scripts/ and run "php innodb_migration.php"

Maybe php.exe (it must be in path or use an absolute path)

Offline

#8 2018-07-03 10:39:42

nimek20
Member
Registered: 2018-07-03
Posts: 14

Re: 388 tables not migrated to InnoDB engine.

@Administrator

It works! Thank's for you help!

Offline

#9 2018-07-16 14:57:09

alientm
Member
Registered: 2014-07-07
Posts: 50

Re: 388 tables not migrated to InnoDB engine.

i should run http://myglpiip/glpi/scripts/innodb_migration.php in browser (linux instalation)?


GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

Offline

#10 2018-07-16 17:21:17

g.coletti
Member
From: Pineto (TE) - Italy
Registered: 2015-04-24
Posts: 5
Website

Re: 388 tables not migrated to InnoDB engine.

It works for me.
Thak's a lot!

Offline

#11 2018-07-16 20:24:32

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: 388 tables not migrated to InnoDB engine.

Hello,
See a tip at the link below. It's in Portuguese.

http://forum.glpi-project.org/viewtopic.php?id=163853


Márcio Machado
Brasília-DF / Brasil

Offline

#12 2018-07-17 10:31:07

alientm
Member
Registered: 2014-07-07
Posts: 50

Re: 388 tables not migrated to InnoDB engine.

machadomall wrote:

Hello,
See a tip at the link below. It's in Portuguese.

http://forum.glpi-project.org/viewtopic.php?id=163853

Thanks !


GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

Offline

#13 2018-08-21 15:46:27

AlexNL
Member
Registered: 2018-08-21
Posts: 1

Re: 388 tables not migrated to InnoDB engine.

Windows
1.Abrir Panel de Control de XAMPP
2.Click Shell
3.Ir a la Ruta de la Carpeta Script, Ejemplo: "Cd C:\xampp\htdocs\scripts" <sin las comillas
4.Teclear: "php innodb_migration.php" <sin las comillas
5. Esperar y Fin

Saludos

Offline

#14 2018-09-08 08:12:20

Dmitry I.
Member
Registered: 2010-02-17
Posts: 4

Re: 388 tables not migrated to InnoDB engine.

Hello,

I have updated my glpi to 9.3 and i have this message :

tables not migrated to InnoDB engine.

I try to start script like: http://forum.glpi-project.org/viewtopic.php?id=163853

But, I have a problem with exec innodb_migration.php script.

I try run command by ssh:

/public_html/scripts$ php innodb_migration.php                                                                                                           

There is an error:

PHP Parse error:  syntax error, unexpected '[' in /home/d/foldername/public_html/scripts/innodb_migration.php on line 36                                                   
artre:~/public_html/scripts$                                                                                                                                   
                                                       
How can I resolve the problem?

Offline

#15 2018-09-08 08:16:33

Dmitry I.
Member
Registered: 2010-02-17
Posts: 4

Re: 388 tables not migrated to InnoDB engine.

For information:
In line 36 there is text in file:

$args = [];

---------------------
One more - part of code in the file:

-----------------------------------------------------------
// Ensure current directory when run from crontab
chdir(__DIR__);

$args = [];
if (isset($_SERVER['argv'])) {
   for ($i=1; $i<count($_SERVER['argv']); $i++) {
      $it           = explode("=", $argv[$i], 2);
      $it[0]        = preg_replace('/^--/', '', $it[0]);
      $args[$it[0]] = (isset($it[1]) ? $it[1] : true);
   }
}
------------------------------------------------------------

What is the reason of problem?

Last edited by Dmitry I. (2018-09-08 08:27:57)

Offline

#16 2018-10-19 16:50:41

willianmgrocha
Member
From: Brazil
Registered: 2014-10-22
Posts: 75

Re: 388 tables not migrated to InnoDB engine.

machadomall wrote:

Hello,
See a tip at the link below. It's in Portuguese.

http://forum.glpi-project.org/viewtopic.php?id=163853

Hi Everyone,

Someone could help in this case? I run this command to migrate all tables, but locked in the table glpi_logs and report an error that I am describing below:

Note: the table size is 9gigs

[root@serverscripts]# php innodb_migration.php
Tables found: 250
Migrating glpi_logs...DBmysql::query() in /var/www/html/glpi/inc/dbmysql.class.php line 177
  *** MySQL query error:
  SQL: ALTER TABLE glpi_logs ENGINE = InnoDB
  Error: The table '#sql-7e95_26c' is full
  Backtrace :
  inc/dbmysql.class.php:206
  scripts/innodb_migration.php:56                    DBmysql->queryOrDie()
PHP Fatal error:  Uncaught RuntimeException:  - Error during the database query: ALTER TABLE glpi_logs ENGINE = InnoDB - Error is The table '#sql-7e95_26c' is full in /var/www/html/glpi/inc/dbmysql.class.php:216
Stack trace:
#0 /var/www/html/glpi/scripts/innodb_migration.php(56): DBmysql->queryOrDie('ALTER TABLE glp...')
#1 {main}
  thrown in /var/www/html/glpi/inc/dbmysql.class.php on line 216

Offline

#17 2018-10-22 14:34:59

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: 388 tables not migrated to InnoDB engine.

Have you free space on your database system?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#18 2018-10-24 14:18:58

willianmgrocha
Member
From: Brazil
Registered: 2014-10-22
Posts: 75

Re: 388 tables not migrated to InnoDB engine.

yllen wrote:

Have you free space on your database system?

Hi Thanks for help, the problem was space on disk.

The table glpi_logs has 9gigs, but after migration stay with 21gigs. Do you know if it is normal?
how can I do the shrink in this database?

Thanks in advance

Willian Rocha

Offline

#19 2018-11-06 12:21:25

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: 388 tables not migrated to InnoDB engine.

In tools directory (https://github.com/glpi-project/glpi/tr … ixes/tools) you have a script to clean glpi_logs in your database (cleanhistory.php)
You have example of code at the beginning of the file


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#20 2019-03-04 21:43:05

MigelSan
Member
Registered: 2019-03-04
Posts: 1

Re: 388 tables not migrated to InnoDB engine.

I have a same problem for my glpi to 9.4.

305 tables not migrated to InnoDB engine.
But don't have in the folder of this file "innodb_migration.php"

"/glpi/scripts/innodb_migration.php was not found on this server"

What should i do to fix this ?

Thanks,

Last edited by MigelSan (2019-03-04 21:43:19)

Offline

#21 2019-03-04 22:48:13

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,146

Re: 388 tables not migrated to InnoDB engine.


Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Offline

#22 2019-03-14 10:14:24

cleomar
Member
Registered: 2019-03-14
Posts: 7

Re: 388 tables not migrated to InnoDB engine.

I have also the same problem when upgrading 9.3 to 9.4
i cant find also ./glpi/scripts/php innodb_migration.php

Offline

#23 2019-03-14 11:13:33

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,146

Re: 388 tables not migrated to InnoDB engine.

@cleomar :read this
https://glpi-install.readthedocs.io/en/ … -line.html

same problem=> same solution


Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Offline

#24 2019-03-14 11:35:20

ashilov
Member
Registered: 2019-03-13
Posts: 3

Re: 388 tables not migrated to InnoDB engine.

For 9.4 working bin/console glpi:migration:myisam_to_innodb. Checked.

Offline

#25 2019-04-04 13:34:10

madsonbraz
Member
Registered: 2018-05-14
Posts: 1

Re: 388 tables not migrated to InnoDB engine.

LaDenrée wrote:

@cleomar :read this
https://glpi-install.readthedocs.io/en/ … -line.html

same problem=> same solution

Solved my problem. Tks.

Offline

Board footer

Powered by FluxBB