Bug #2276

Loose graphique of service with space in name 2.2RC2

Added by donkishoot - about 3 years ago. Updated almost 3 years ago.

Status:ClosedStart date:04/13/2011
Priority:HighDue date:
Assignee:david porte% Done:

0%

Category:CentWeb
Target version:Centreon-2.2
Resolution:fixed

Description

Hi,

I had loose all my graphics with space in name description after upgrade in 2.2RC2 from 2.1.9

Sample of name description: "GE-0/0/0 (LAN)"

I tried to rename to GE-0/0/0_(LAN) because sometimes Centreon correct himself but not today :(
It continue to not showing graph.

It seems that data are still there but Centreon seems to have bad link in his database.
This is one link HS after renaming without any effect:
https://@ip/centreon/main.php?p=4&mode=0&svc_id=RT-CBV-BGP;GE-0%2F0%2F0_%28LAN%29

This is one link HS without renaming "GE04 (SRVCBVESX1)":
https://@ip/centreon/main.php?p=4&mode=0&svc_id=SW-CBV-BLADE-1;GE04+%28SRVCBVESX1%29

How can i manually correct this bug ? (i know howto manipulate mysql database)

Regards,

History

#1 Updated by donkishoot - about 3 years ago

[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined offset: 214 in /usr/local/centreon/www/class/centreonGraph.class.php on line 754, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:36 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_name in /usr/local/centreon/www/class/centreonGraph.class.php on line 373, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc
[Wed Apr 13 11:14:37 2011] [error] [client 127.0.0.1] PHP Notice: Undefined index: ds_filled in /usr/local/centreon/www/class/centreonGraph.class.php on line 408, referer: https://127.0.0.1/centreon/main.php?p=20201&o=svc

#2 Updated by Julien Mathis about 3 years ago

  • Status changed from New to Assigned
  • Assignee set to david porte

Is it possible for you david to check all that ?

Thanks in advance :)

#3 Updated by david porte about 3 years ago

Ok

#4 Updated by david porte about 3 years ago

Hi donkishoot,

Can you check in the table 'giv_components_template' database 'centreon' if you have one line with field 'default_tpl1' set to '1'

SELECT * FROM `giv_components_template` WHERE `default_tpl1` = '1';
'default_tpl1'
1 Default_DS1 1 DS1 #1183EE #FFFFFF 0 1 1 1 1 1 NULL NULL NULL 1 NULL

This should be this line above (default)

if not can you set one of the Default_DS[1 to 4] to '1'.

#5 Updated by donkishoot - about 3 years ago

This is the result of the request

compo_id name ds_order ds_name ds_color_line ds_color_area ds_filled
1 Default_DS1 1 DS1 #1183EE #FFFFFF 0

ds_max ds_min ds_average ds_last ds_tickness ds_transparency ds_invert
1 1 1 1 1 NULL NULL

default_tpl1 comment ds_stack
1 NULL NULL

I don't understand what i could do but i observe that on my side i have :
"1 NULL NULL" at the end of the request result where you claim "NULL 1 NULL"

Is it normal ?

#6 Updated by david porte about 3 years ago

Can you write the name of your service and its metrics

#7 Updated by donkishoot - about 3 years ago

I have a lot of service in the same case.
Since the start of this ticket i use the service whose name is GE-0/0/0 (LAN)

Extract from Adm-Opt-CentStorage-Gérer :

Service
GE-0/0/0 (LAN)

Métriques
ge-0/0/0_in_error (c) - ge-0/0/0_in_discard (c) - ge-0/0/0_out_error (c) - ge-0/0/0_out_discard (c) - ge-0/0/0_in_bps - ge-0/0/0_out_bps - ge-0/0/0_in_bps - ge-0/0/0_out_bps - ge-0/0/0_in_error (c) - ge-0/0/0_in_discard (c) - ge-0/0/0_out_error (c) - ge-0/0/0_out_discard (c)

en attente de reconstruction
No

Caché
No

Verrouillé
No

Type de sauvegarde
RRDTool & MySQL

PS: Cosmétique bug "en attente de reconstruction" shouldn't start by an upper case like "E" as the other ?

#8 Updated by david porte about 3 years ago

Do you display graph in 'Views>>Graphs' & in 'Monitoring/Services [icon]' or is it just the links with space in description that does not work?

#9 Updated by donkishoot - about 3 years ago

On the services with problem, there is no more graph.
Just a navigator picture showing break picture.

I will give you a best description tomorrow because after viewing a lot of graph, finally some graph with space in her name have no problem.
I'll try to find another common param between the dead graph.

#10 Updated by david porte about 3 years ago

Ok! I'll wait your feedback.
For your information : I did not hit your bug yet, that's why I ask you a lot of questions.

#11 Updated by donkishoot - about 3 years ago

I hope you speak French, it will help me :-)

Je viens de faire le tour de tous mes graphs et j'ai relevé tous les graphs HS.
J'ai rebuildé toutes les RRD à travers Centreon pour voir.
Ce qui m'en a remis 1 ou 2 sur pieds (je n'ai pas été étonné puisque ces services ne correspondaient pas du tout aux critères de tous les autres HS).

Voici les points communs :
- Il s'agit tous de service qui check les débits des interfaces (check_snmp_int).

Les exceptions :
- Les firewalls ont été préservé pour une raison inconnu

Observation/Hypothèse n°1: les noms des firewalls commencent par FW- hors les routeurs par RT- et les switchs par SW-
Si une boucle quelconque lors de l'upgrade parcourait une chaine, il passerait probablement par les FW- avant d'arriver aux RT- puis aux SW-

- Toutes les interfaces agréger (port-channel ou ae) sur switchs et routeurs n'ont pas eu de soucies.

- Les services dont les interfaces sont de types Fast-Ethernet n'ont pas était impacté.

- Le meilleur pour la fin, le seul qui aurait du être HS mais fonctionne est le "GE-0/0/4 (RB-CBV)" sur SW-CBV-PROD

J'ai une feuille excel avec tous les services HS (Index - host_name - service_description) si cela peut t'avancer mais je doute finalement que cela est rapport avec des espaces dans les noms des services :(

Un accès temporaire à mon Centreon t'aiderait peut-être ?
Il me faudrait juste ton ip publique par MP à travers le forum par exemple.

#12 Updated by donkishoot - about 3 years ago

J'ai vidé 4 services pour voir (tant pis pour l'historique)
Mais les ds ne se recrée pas.
Dans centstorage.log j'ai des trucs pas propre :

18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2329.rrd at 1303012946 -> 1795 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2330.rrd at 1303012946 -> 1779 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2331.rrd at 1303012946 -> 0 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2332.rrd at 1303012946 -> 0 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2333.rrd at 1303012946 -> 0 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/metrics/2334.rrd at 1303012946 -> 0 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - ERROR while updating /var/lib/centreon/status/326.rrd at 1303012946 -> 100 : illegal attempt to update using time 1303012946 when last update time is 1303012946 (minimum one second step)
18/4/2011 16:57:53 - Directory name empty...
18/4/2011 16:57:53 - Data droped....

18/4/2011 16:57:53 - Directory name empty...
18/4/2011 16:57:53 - Data droped....

18/4/2011 16:57:53 - Directory name empty...
18/4/2011 16:57:53 - Data droped....

Can't use string ("AP-VIL-3") as a HASH ref while "strict refs" in use at /usr/local/centreon/bin/centstorage line 440, <PFDT> line 26.

#13 Updated by donkishoot - about 3 years ago

J'ai tout purger et je n'ai plus aucun graphique qui se crée.

#14 Updated by donkishoot - about 3 years ago

Il ne découvre qu'une moitié de metrics.

Tu sais ou centstorage trouve ce host car il n'existe plus:

Can't use string ("AP-VIL-3") as a HASH ref while "strict refs" in use at /usr/local/centreon/bin/centstorage line 440, <PFDT> line 26.

#15 Updated by donkishoot - about 3 years ago

J'ai supprimé un fichier perfdata_read sur lequel il semblait bloquer.
Je n'ai plus l'erreur Can't use string ("AP-VIL-3") as a HASH ref while "strict refs" in use at /usr/local/centreon/bin/centstorage line 440, <PFDT> line 26

#16 Updated by donkishoot - about 3 years ago

Est-ce que centstorage fork ? Je demande car il y a 2 process quand je fais top

Et quand je fais "/etc/init.d/centstorage stop" il y en a un qui reste actif

#17 Updated by donkishoot - about 3 years ago

Bon ba cela semble repartie mais je ne sais trop ce qui a fait effet le plus.

Je pense que je devais avoir un perfdata_read corrompu mais est ce que cela expliquerait tout ou partie de mes symptomes (marche à moitié, si tu purges marche plus du tout :d).

Est-ce que si j'avais été un gros béta et lancé la mise à jour sans couper correctement les services de centreon cela aurait pu générer un perfdata_read corrompu ?

#18 Updated by donkishoot - almost 3 years ago

Je pense que mes problèmes sont définitivement réglé.
J'ai certainement tout purgé pour rien mais bon je n'avais pas envie de mettre le nez dans la ligne de commande alors que j'ai fini par le faire :(

Je pense que l'on peut clore ce bug et peut-être créer un Enhancement pour qu'au moment de l'install ou de l'upgrade l'installeur de centreon stop les services qui pourraient corrompre l'installation ou au minimum le suggérer à l'administrateur un peu tête en l'aire car tout le monde n'a pas de preprod ou de qualif et bosse peut-être directement sur la prod.

Ou top du top, si centstorage detecte un fichier perfdata_read corrompu alors il drop l'enregistrement en défaut tout seul comme un grand.

#19 Updated by Sylvestre Ho almost 3 years ago

  • Status changed from Assigned to Closed
  • Resolution set to fixed

Also available in: Atom PDF