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 2017-03-14 10:40:05

14475
Member
Registered: 2017-02-08
Posts: 45

Problem after Database optimize Failed

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

#2 2017-03-14 10:58:57

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

Re: Problem after Database optimize Failed

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

#3 2017-03-14 11:01:09

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

it shows

#144 - Table './glpi/glpi_logs' is marked as crashed and last (automatic?) repair failed

Offline

#4 2017-03-14 11:04:49

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#5 2017-03-14 11:06:32

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

Re: Problem after Database optimize Failed

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

#6 2017-03-14 11:08:07

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#7 2017-03-14 11:14:02

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

Re: Problem after Database optimize Failed

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

#8 2017-03-14 11:18:04

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

I have truncate the log table and now everythin is working fine big_smile ist that solution a problem?

Offline

#9 2017-03-14 11:26:13

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

Re: Problem after Database optimize Failed

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

#10 2017-03-14 11:35:04

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

Yes but its no problem or?
can i disable the optimize job?

Last edited by 14475 (2017-03-14 11:35:50)

Offline

#11 2017-03-14 11:42:53

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

Re: Problem after Database optimize Failed

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

#12 2017-03-14 11:47:25

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#13 2017-03-14 11:50:27

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

Re: Problem after Database optimize Failed

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

#14 2017-03-14 15:23:34

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#15 2017-03-14 15:32:03

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

Re: Problem after Database optimize Failed

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

#16 2017-03-14 15:36:52

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#17 2017-03-14 15:37:40

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

600Computers 500User and 11000 Tickets

Offline

#18 2017-03-14 15:38:40

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

Re: Problem after Database optimize Failed

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

#19 2017-03-14 15:41:34

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

70% are by User_name Plugin_FusionInventory
30% are by user_name Plugin_FusionInventory (8)

Offline

#20 2017-03-14 15:45:46

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

i see that there are many same lines. only different is the id

Last edited by 14475 (2017-03-14 15:45:57)

Offline

#21 2017-03-14 15:47:55

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

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

#22 2017-03-14 15:50:15

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

Re: Problem after Database optimize Failed

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

#23 2017-03-14 15:55:06

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

Re: Problem after Database optimize Failed

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

#24 2017-03-14 15:57:46

14475
Member
Registered: 2017-02-08
Posts: 45

Re: Problem after Database optimize Failed

GLPI 9.1.2
FusionInventory 9.1+1.0
DebianJessie (8.7)
PHP Version 5.6.29-0+deb8u1

Offline

#25 2017-03-14 16:01:32

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

Re: Problem after Database optimize Failed

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

Board footer

Powered by FluxBB