Hi, You need to set the current month in the call to /usr/local/bin/hedgehog_database_manage_partitions.sh. Like this /usr/local/bin/hedgehog_database_manage_partitions.sh -p 2015-05 By default that script is designed to run from cron to create next months tables before the end of the current month. John
On 20 May 2015, at 15:41, matt singh <matt.singh@centralnic.com> wrote:
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
_______________________________________________ dns-stats-users mailing list dns-stats-users@dns-stats.org https://mm.dns-stats.org/mailman/listinfo/dns-stats-users