Aggregate V0.71 - Released

Announcements concerning Plugins for Cacti

Moderators: Moderators, Developers

Locked
Author
Message
leonk
Posts: 4
Joined: Wed Jun 20, 2007 2:16 am

Aggregate CDEF's truncated

#91 Post by leonk » Tue Nov 10, 2009 12:19 am

Having an issue aggregating some of my graphs that use other cdef items, the _AGGREGATE cdefs that get created are truncated due to what looks like the varchar size on the 'value' field in cdef_items table;

Code: Select all

mysql> select value from cdef_items order by value DESC limit 2;
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| value                                                                                                                                                  |
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| SIMILAR_DATA_SOURCES_NODUPS,CURRENT_GRAPH_MAXIMUM_VALUE,/,100,*,8,*,CURRENT_GRAPH_MAXIMUM_VALUE,LE,SIMILAR_DATA_SOURCES_NODUPS,CURRENT_GRAPH_MAXIMUM_V |
| SIMILAR_DATA_SOURCES_NODUPS,CURRENT_GRAPH_MAXIMUM_VALUE,/,100,*,8,*,CURRENT_GRAPH_MAXIMUM_VALUE,LE,SIMILAR_DATA_SOURCES_NODUPS,CURRENT_GRAPH_MAXIMUM_V |
+--------------------------------------------------------------------------------------------------------------------------------------------------------+
Is this a bug?

I'm going to attempt to increase the column value from 150 characters to be 255 and see how it goes.
Attachments
aggregate_cdef.PNG
aggregate_cdef.PNG (11.88 KiB) Viewed 2223 times

User avatar
gandalf
Developer
Posts: 22375
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

#92 Post by gandalf » Wed Feb 17, 2010 1:47 pm

This is not a bug but a restriction. You may quite safely increate the column size
R.

Locked