[dns-stats-users] Adding nodes to hedgehog
matt singh
matt.singh at centralnic.com
Wed May 20 14:41:24 UTC 2015
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
More information about the dns-stats-users
mailing list