[dns-stats-users] Adding nodes to hedgehog

[matt singh]

Hello,

I have one node graphing ok.  I am looking to add another.

Into /usr/local/etc/hedgehog/nodes.csv I have added.

ns-6,Node-2,Region-1

Then run,
sudo -u hedgehog /usr/local/bin/hedgehog_database_update_nodes.sh
sudo -u hedgehog /usr/local/bin/hedgehog_database_manage_partitions.sh

sudo -u hedgehog /usr/local/bin/refile_and_grok.sh

But in the file I see an error;

/usr/local/var/hedgehog/data/ns-6/Node-2/dsc-extractor-xml-db.out

----------------------- 2015-05-20 15:08:12 BST ----------------------
*** Database connected
*** Processing server: ns_6
*** Processing node:   Node-2
*** Found:             107 .xml files to process.

2015-05-20 15:08:12 BST: Starting:  ./incoming/1432123500.dscdata.xml
Format 2 runtime error: ERROR:  relation 
"dsc.data_ns_6_pcap_stats_2015_05" does not exist
LINE 1: INSERT INTO dsc."data_ns_6_pcap_stats_2015_05" (server_id, n...

PostgreSQL log;

May 20 15:10:43 localhost postgres[30790]: [12-1] < 2015-05-20 
15:10:43.137 BST >ERROR:  relation "dsc.data_ns_6_pcap_stats_2015_05" 
does not exist at character 13

May 20 15:10:43 localhost postgres[30790]: [12-2] < 2015-05-20 
15:10:43.137 BST >STATEMENT:  INSERT INTO 
dsc."data_ns_6_pcap_stats_2015_05" (server_id, node_id, plot_id, 
starttime, key1, key2, value) values (3, 3, 20, timestamptz 'epoch' + 
1432123440 * interval '1 second', 'filter_received','bond0', 24916), (3, 
3, 20, timestamptz 'epoch' + 1432123440 * interval '1 second', 
'pkts_captured','bond0', 22875), (3, 3, 20, timestamptz 'epoch' + 
1432123440 * interval '1 second', 'kernel_dropped','bond0', 2039);

I can see "data_ns_6_pcap_stats_2015_05" is not in the database, but 
"data_ns_6_pcap_stats_2015_06" is.

I can get around this problem by dropping the entire hedgehog database 
and then initializing it again

sudo -u hedgehog /usr/local/bin/hedgehog_database_init.sh

and re-importing the data, but ideally am trying to avoid this.

I have tried running
sudo -u hedgehog /usr/local/bin/refile_and_grok.sh -s 2015-05-18T, but 
still no joy.

Any ideas what I'm overlooking here?

thanks,
matt