388 tables not migrated to InnoDB engine.

leval · 2018-06-29 10:48:54

Hi,

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

What should i do to fix this ?

Thanks,

Valentin.

cirtaz · 2018-06-29 11:00:13

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

leval · 2018-06-29 11:22:20

Ok it's work

big thanks

DimmKo · 2018-06-29 12:38:53

Thank's for you help!

Nyctalope · 2018-07-02 15:05:38

Thanks for the help

nimek20 · 2018-07-03 08:10:25

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

orthagh · 2018-07-03 08:50:02

@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)

nimek20 · 2018-07-03 10:39:42

@Administrator

It works! Thank's for you help!

alientm · 2018-07-16 14:57:09

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

g.coletti · 2018-07-16 17:21:17

It works for me.
Thak's a lot!

machadomall · 2018-07-16 20:24:32

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

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

alientm · 2018-07-17 10:31:07

machadomall wrote:

Hello,
See a tip at the link below. It's in Portuguese.
http://forum.glpi-project.org/viewtopic.php?id=163853

Thanks !

AlexNL · 2018-08-21 15:46:27

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

Dmitry I. · 2018-09-08 08:12:20

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?

Dmitry I. · 2018-09-08 08:16:33

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)

willianmgrocha · 2018-10-19 16:50:41

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

yllen · 2018-10-22 14:34:59

Have you free space on your database system?

willianmgrocha · 2018-10-24 14:18:58

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

yllen · 2018-11-06 12:21:25

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

MigelSan · 2019-03-04 21:43:05

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)

LaDenrée · 2019-03-04 22:48:13

@miguelSan : read this :

https://glpi-install.readthedocs.io/en/ … -line.html

cleomar · 2019-03-14 10:14:24

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

LaDenrée · 2019-03-14 11:13:33

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

same problem=> same solution

ashilov · 2019-03-14 11:35:20

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

madsonbraz · 2019-04-04 13:34:10

LaDenrée wrote:

@cleomar :read this
https://glpi-install.readthedocs.io/en/ … -line.html
same problem=> same solution

Solved my problem. Tks.

Forum GLPI-Project

Announcement

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

388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

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

Re: 388 tables not migrated to InnoDB engine.

Board footer