Problem after Database optimize Failed

14475 · 2017-03-14 16:05:16

i got the same mail.
then i started the job by myselfe.
then the the ticket problem was there.
after truncate the log table everything is working fine.

but i want to find the issue because it happens one week ago.
so i think it will happen again in one week

14475 · 2017-03-15 10:40:12

Today mornign the same Problem again.

Have someone an idea to fix it?

Now i installed glpi on a new server and exported the glpi_logs table.

On the old server i deleted it and imported the table from the new server.

I hope it works now

LaDenrée · 2017-03-15 10:55:40

it looks like a Fusion inventory problem.

if you stop Fusion inventory, do the log table still grow ?

14475 · 2017-03-15 11:05:41

No but i need Fusion.

14475 · 2017-03-15 11:06:17

can i delet the fusion folder in plugins and upload it new without lost all fusion settings?

LaDenrée · 2017-03-15 11:11:10

don't delete fusion folder.

setup>plugins>[fusioninventory]>deactivate

check log size

setup>plugins>[fusioninventory]>activate

LaDenrée · 2017-03-15 11:17:52

how manny FI agents in your database ?

(/plugins/fusioninventory/front/agent.php)

14475 · 2017-03-15 11:23:35

i deactivated FI and there are no Logs.

Now i deleted de Plugin and instaled the newest Version 9.1+1.1

I looks like there are now only 100 Lines/Minute and not like before 1000/Minute

i hope it will work.

I will take a look on it and tell you tomorow the result

14475 · 2017-03-15 11:25:40

the agent.php looks like this

<?php

/**
* FusionInventory
*
* Copyright (C) 2010-2016 by the FusionInventory Development Team.
*
* http://www.fusioninventory.org/
* https://github.com/fusioninventory/fusi … y-for-glpi
* http://forge.fusioninventory.org/
*
* ------------------------------------------------------------------------
*
* LICENSE
*
* This file is part of FusionInventory project.
*
* FusionInventory is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* FusionInventory is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with FusionInventory. If not, see <http://www.gnu.org/licenses/>.
*
* ------------------------------------------------------------------------
*
* This file is used to manage the agent search list.
*
* ------------------------------------------------------------------------
*
* @package FusionInventory
* @author David Durieux
* @copyright Copyright (c) 2010-2016 FusionInventory team
* @license AGPL License 3.0 or (at your option) any later version
* http://www.gnu.org/licenses/agpl-3.0-standalone.html
* @link http://www.fusioninventory.org/
* @link https://github.com/fusioninventory/fusi … y-for-glpi
*
*/

include ("../../../inc/includes.php");

Html::header(__('FusionInventory', 'fusioninventory'), $_SERVER["PHP_SELF"], "plugins",
"pluginfusioninventorymenu", "agent");

Session::checkRight('plugin_fusioninventory_agent', READ);

PluginFusioninventoryMenu::displayMenu("mini");

Search::show('PluginFusioninventoryAgent');

Html::footer();

?>

LaDenrée · 2017-03-15 11:33:43

sorry, i asked
plugins>fusioninventory>general>agents> how manny agents ?

14475 · 2017-03-15 12:29:06

546 Agents

14475 · 2017-03-15 15:42:55

now i have 50000 lines in the table after 5 hours. i think this is ok.
i hope it works now

14475 · 2017-03-17 10:12:42

Today the optimize Job was running and now the table is crashed again.

I have no idea what i can do now.

If i truncate the table and start the optimize job again without one entry in the table the tabel crushed.

I think the optimize Job is the Problem. but how th repair it?

GoempieK · 2017-03-31 13:20:20

My logs table has also crashed with the optimization.

14475 · 2017-04-03 10:27:34

Last Week i was out of the Office. Today i come back and same problem again.
The Log Table is crashed again.

Only way to solve the issue is to empty the logs Table. But every week when the Job is running it crashes again.
Now i stopped the Job and hope it works.

14475 · 2017-04-25 07:59:05

now it works for 3 Weeks but i disabled the optimize Job in GLPI.
I think it is the Problem.

yllen · 2017-04-25 18:39:20

Optimization in GLPI is only for very small database that is totally not used during optimization.
For others databases, prefer optimization of MySQL or MariaDB

Forum GLPI-Project

Announcement

#26 2017-03-14 16:05:16

Re: Problem after Database optimize Failed

#27 2017-03-15 10:40:12

Re: Problem after Database optimize Failed

#28 2017-03-15 10:55:40

Re: Problem after Database optimize Failed

#29 2017-03-15 11:05:41

Re: Problem after Database optimize Failed

#30 2017-03-15 11:06:17

Re: Problem after Database optimize Failed

#31 2017-03-15 11:11:10

Re: Problem after Database optimize Failed

#32 2017-03-15 11:17:52

Re: Problem after Database optimize Failed

#33 2017-03-15 11:23:35

Re: Problem after Database optimize Failed

#34 2017-03-15 11:25:40

Re: Problem after Database optimize Failed

#35 2017-03-15 11:33:43

Re: Problem after Database optimize Failed

#36 2017-03-15 12:29:06

Re: Problem after Database optimize Failed

#37 2017-03-15 15:42:55

Re: Problem after Database optimize Failed

#38 2017-03-17 10:12:42

Re: Problem after Database optimize Failed

#39 2017-03-31 13:20:20

Re: Problem after Database optimize Failed

#40 2017-04-03 10:27:34

Re: Problem after Database optimize Failed

#41 2017-04-25 07:59:05

Re: Problem after Database optimize Failed

#42 2017-04-25 18:39:20

Re: Problem after Database optimize Failed

Board footer