You are not logged in.
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
Offline
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
Offline
it looks like a Fusion inventory problem.
if you stop Fusion inventory, do the log table still grow ?
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
préprod : glpi10.0.15
Offline
No but i need Fusion.
Offline
can i delet the fusion folder in plugins and upload it new without lost all fusion settings?
Offline
don't delete fusion folder.
setup>plugins>[fusioninventory]>deactivate
check log size
setup>plugins>[fusioninventory]>activate
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
préprod : glpi10.0.15
Offline
how manny FI agents in your database ?
(/plugins/fusioninventory/front/agent.php)
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
préprod : glpi10.0.15
Offline
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
Offline
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();
?>
Offline
sorry, i asked
plugins>fusioninventory>general>agents> how manny agents ?
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
préprod : glpi10.0.15
Offline
546 Agents
Offline
now i have 50000 lines in the table after 5 hours. i think this is ok.
i hope it works now
Offline
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?
Offline
My logs table has also crashed with the optimization.
Offline
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.
Offline
now it works for 3 Weeks but i disabled the optimize Job in GLPI.
I think it is the Problem.
Offline
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
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