Re: [Perfparse-users] No output from perfparse-db-tool

[Ben C. <Be...@cl...>]

Tim Wuyts wrote:

> All,
> I've seen it a couple of times on the mailing list, and now it's happening
> to me...
> 
> The perfparse-db-tool does not do anything.
> 
> I've just compiled perfparse on a new machine (hint: could you please add a
> list of necessary libraries to the docs :) ), installed the db schema with
> the create script. Next I'm running the db-tool with the --update option. No
> output whatsoever. There is nothing in the database (I would have exepected
> the db update to enter things in the perfdata_state table).

Hi Tim,

The 'upgrade' option checks your tables are up to date.  However the 
supplied script as always kept up to date.  I would expect this tool not 
to have any effect on a new installation.


> Did some investigating:
> - when db-tool checks the version, it returns the CURRENT version if the
> perfdata_state table is empty. So the db-tool thinks all is fine, and does
> nothing (a little output in the style 'db is up to date' might come in
> handy!)
> - when you run perfparse for the first time, it complains about the db
> version NOT being correct. Before checking the version, Perfparse writes a
> new record to the perfdata_state table, which sets the version field to 0! 
> - run the db-tool again. And now it DOES update the database, because the
> version is 0, not an empty row.
> 
> Problem solved :)

It seems you have found a hole in the system...  The 'version' field in 
this table is legacy and will be moved to the 'registry' table in later 
versions, where it will be correctly updated on an 'upgrade'.  Hopefully 
solving this.  We will take your advice and be a little bit more verbose 
about what the upgrade is doing, if you believe users would benefit from 
this.

Thanks for finding this hole, please enjoy using PP :)

Ben



> 
> Happy Perf-parsing,
> Tim
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. 
> Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>