After adding new link I get issues when running rrd-extratstats.pl

[lostchild1981]

I have added a new link to knownlinks I have had issues with adding a new link, so I ended up deleting all rrd files (emptying whole folder). and wanted to regenerate them again.

but after running /as-stats/AS-Stats/bin/rrd-extractstats.pl /as-stats/rrd /as-stats/AS-Stats/conf/knownlinks /as-stats/stats/asstats_day.txt_

I get the following error now: DBD::SQLite::db do failed: table stats has 38 columns but 42 values were supplied at /as-stats/AS-Stats/bin/rrd-extractstats.pl line 160.

I do not see any resolution for this anywhere. Can you please let me know how to resolve this?

Thank you,

[pv2b]

I realize this is an old issue, and probably by now you'll have fixed it, but for future reference the problem you're having is that the sqlite database that summarizes per-as and per-link statistics has a mismatched schema (different column namnes). The solution is to delete your sqlite database and rrd-extractstats.pl regenerate it.

Incidentally, I have made a patch that will detect and automatically fix this exact scenario in future. (See pull request #105).