You are not logged in.
I become a mail that the Job optimize is on error.
i stoped it and restarted the job.
No i can not acces to tickets or inventory.
Offline
Hi,
GLPI version ?
check glpi_logs table. (phpmyadmin)
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
it shows
#144 - Table './glpi/glpi_logs' is marked as crashed and last (automatic?) repair failed
Offline
it is possible to create tickets.
but as a technic User or admin i can not take a look in the tickets. i see the ticket list but its not able to open the tickets
Offline
first of all :
backup your database !
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
i have done a bakup now.
but the last one was 1 week ago and when i reset it ther will missing many Tickets
Offline
KEEP COOL, have a deep breath.
what i have allready done once in this case :
restore database on a test server.
import glpi_logs table from test server to glpiserver
you only will miss history for these last days.
it should work for you.
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
I have truncate the log table and now everythin is working fine ist that solution a problem?
Offline
have a look to "log" TAB in ticket : some informations are missing .
i think this TAB is empty , am I right ?
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
Yes but its no problem or?
can i disable the optimize job?
Last edited by 14475 (2017-03-14 11:35:50)
Offline
Yes but its no problem or?
this is not a problem for GLPI, it will work fine.
This could be a problem for you, if you want to know what happened yesterday on a ticket
can i disable the optimize job?
I guess this could lead to slow GLPI when glpi_logs will grow up, but i'm not an expert....
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
ok so the Optimize Job only delet the log table?
I dont know this infos from a ticket. I only ned the followups and tasks.
Offline
I dont know this infos from a ticket. I only ned the followups and tasks.
then no problem for you.
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
i have found the Problem.
the glpi_logs Table is to big.
I truncated it and after one Hour it hast 400.000 Lines.
How can i disable the logs so that the table dont grow up?
Offline
400.000 ? really ?
something is gone wrong :
I have 4.000.000 lines after 7 years 50.000 tickets, 2000 users(post only) 25 technicians, 1500 computers (fusion inventory)....
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
I do a new Truncate
ID1 2017-03-14 14:22:44
after 10 Minutes
ID 26212 2017-03-14 14:32:48
The Inventory is set to every 24 Hours
Offline
600Computers 500User and 11000 Tickets
Offline
can you see if most of these line are generated by inventory ?
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
70% are by User_name Plugin_FusionInventory
30% are by user_name Plugin_FusionInventory (8)
Offline
i see that there are many same lines. only different is the id
Last edited by 14475 (2017-03-14 15:45:57)
Offline
2443 Computer 6649 SoftwareVersion 4 Plugin_FusionInventory 2017-03-14 14:42:27 0 Yahoo Search Set - (4130)
11186 Computer 6420 SoftwareVersion 4 Plugin_FusionInventory 2017-03-14 14:43:25 0 Yahoo Search Set - (4130)
Offline
sorry, I can not help, no idea left.
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
GLPI version ?
fusion inventory version ?
Server : windows ? unix ?
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
GLPI 9.1.2
FusionInventory 9.1+1.0
DebianJessie (8.7)
PHP Version 5.6.29-0+deb8u1
Offline
very strange : I just got a mail "the Job optimize is on error." ! (GLPI 9.1.2)
automatic action "optimize (frequency 1 week)" was stucked since yesterday.
never happened before !
what a coincidence.
then i dump my DB and stop task : it works, no dammages...
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