tricky question on not properly populated db tables

[donClemens]

Hi,

maybe someone can help me on the following issue:
it seems that when creating graphs for some devices (it does not affect only one device, but also not all devices, not dure if it is dependent on what is running in the background, script or snmp queries, would need to check this..) it seems that one DB table is not properly populated (was working fine, until the deletion of some graphs)

this results in graphs being not proper displayed

not properly populated table item

notitle.PNG (10.76 KiB) Viewed 404 times

see also how the DB table looks like, first line is a graph of the same type and same device type, created some time ago, before the problem occured, the second line shows the not properly populated item

Code: Select all

mysql> select * from graph_templates_graph where local_graph_id=96323 OR local_graph_id=109480 limit 10;
+--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+
| id     | local_graph_template_graph_id | local_graph_id | graph_template_id | t_image_format_id | image_format_id | t_title | title                                                                 | title_cache                                             | t_height | height | t_width | width | t_upper_limit | upper_limit | t_lower_limit | lower_limit | t_vertical_label | vertical_label      | t_slope_mode | slope_mode | t_auto_scale | auto_scale | t_auto_scale_opts | auto_scale_opts | t_auto_scale_log | auto_scale_log | t_scale_log_units | scale_log_units | t_auto_scale_rigid | auto_scale_rigid | t_auto_padding | auto_padding | t_base_value | base_value | t_grouping | grouping | t_export | export | t_unit_value | unit_value | t_unit_exponent_value | unit_exponent_value |
+--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+
|  96889 |                         15093 |          96323 |                73 | 0                 |               1 | 0       | |host_description| answer_supervisions |query_TrkDir| |query_TrkName| | CS2k_KRPNGEUM01D answer_supervisions 2W K04BTDUS01_OG03 | 0        |    180 | 0       |   750 | 0             | 1000000     | 0             | 0           | 0                | answer supervisions | 0            | on         | 0            | on         | 0                 |               2 | 0                |                | 0                 |                 | 0                  |                  | 0              | on           | 0            |       1000 | 0          |          | 0        | 0      | 0            |            | 0                     |                     |
| 110046 |                             0 |         109480 |                73 | 0                 |               0 | 0       |                                                                       |                                                         | 0        |      0 | 0       |     0 | 0             |             | 0             |             | 0                |                     | 0            |            | 0            |            | 0                 |               0 | 0                |                | 0                 |                 | 0                  |                  | 0              |              | 0            |          0 | 0          |          | 0        |        | 0            |            | 0                     |                     |
+--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+

after inserting the proper values manually into the table, everything is working fine, and the graph is properly displayed, what lets me assume, that everything else is working fine

Code: Select all

mysql> insert into graph_templates_graph values ('110046','15093','109480','73','0','1','0','|host_description| answer_supervisions |query_TrkDir| |query_TrkName|','CS2k__VINNASUP06C answer_supervisions 2W ATV1A1CS01BW2','0','180','0','750','0','1000000','0','0','0','answer supervisions','0','on','0','on','0','2','0','','0','','0','','0','on','0','1000','0','','0','0','0','','0','');
Query OK, 1 row affected (0.00 sec)

mysql> select * from graph_templates_graph where local_graph_id=96323 OR local_graph_id=109480 limit 10;                                                                                                    +--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+
| id     | local_graph_template_graph_id | local_graph_id | graph_template_id | t_image_format_id | image_format_id | t_title | title                                                                 | title_cache                                             | t_height | height | t_width | width | t_upper_limit | upper_limit | t_lower_limit | lower_limit | t_vertical_label | vertical_label      | t_slope_mode | slope_mode | t_auto_scale | auto_scale | t_auto_scale_opts | auto_scale_opts | t_auto_scale_log | auto_scale_log | t_scale_log_units | scale_log_units | t_auto_scale_rigid | auto_scale_rigid | t_auto_padding | auto_padding | t_base_value | base_value | t_grouping | grouping | t_export | export | t_unit_value | unit_value | t_unit_exponent_value | unit_exponent_value |
+--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+
|  96889 |                         15093 |          96323 |                73 | 0                 |               1 | 0       | |host_description| answer_supervisions |query_TrkDir| |query_TrkName| | CS2k_KRPNGEUM01D answer_supervisions 2W K04BTDUS01_OG03 | 0        |    180 | 0       |   750 | 0             | 1000000     | 0             | 0           | 0                | answer supervisions | 0            | on         | 0            | on         | 0                 |               2 | 0                |                | 0                 |                 | 0                  |                  | 0              | on           | 0            |       1000 | 0          |          | 0        | 0      | 0            |            | 0                     |                     |
| 110046 |                         15093 |         109480 |                73 | 0                 |               1 | 0       | |host_description| answer_supervisions |query_TrkDir| |query_TrkName| | CS2k__VINNASUP06C answer_supervisions 2W ATV1A1CS01BW2  | 0        |    180 | 0       |   750 | 0             | 1000000     | 0             | 0           | 0                | answer supervisions | 0            | on         | 0            | on         | 0                 |               2 | 0                |                | 0                 |                 | 0                  |                  | 0              | on           | 0            |       1000 | 0          |          | 0        | 0      | 0            |            | 0                     |                     |
+--------+-------------------------------+----------------+-------------------+-------------------+-----------------+---------+-----------------------------------------------------------------------+---------------------------------------------------------+----------+--------+---------+-------+---------------+-------------+---------------+-------------+------------------+---------------------+--------------+------------+--------------+------------+-------------------+-----------------+------------------+----------------+-------------------+-----------------+--------------------+------------------+----------------+--------------+--------------+------------+------------+----------+----------+--------+--------------+------------+-----------------------+---------------------+
2 rows in set (0.00 sec)

mysql>

now after inserting the values into the db

withtitle.PNG (12.11 KiB) Viewed 404 times

ps: the first screenshot was taken from a different graph of the same device, while still testing, so dont wonder, that the graph ids do not match, every new graph is displayed like this, before manually inserting the data

this brings me to the question, what could have gone wrong, what do i have to look into?

best regards
Clemens