Hi Yujun,
I looked in depth at you problem.
There is indeed a bug in request construction when using --filter-path
together with --top-dirs.
I wrote the bugfix. I'll push an update on github once after all
regression test have passed.
For now, you can workaround it by running "rbh-report --top-dirs | grep
/pnfs/fs/usr/test"
Thanks for reporting
Regards
On 04/22/15 16:21, Yujun Wu wrote:
Hello,
Could the Robinhood experts give me some help on this? I recently
installed Robinhood to monitor a TMPFS filesystem. It is really a
great tool to use to monitor and manage a filesystem. However,
we had some trouble to run the report under a specific direct:
[root@fndca2a ]# rbh-report --filter-path /pnfs/fs/usr/test --top-dirs
Using config file '/etc/robinhood.d/tmpfs/pnfs.conf'.
filter path: /pnfs/fs/usr/test
2015/04/22 09:17:19 [18511/1] ListMgr | SQL request parse error
2015/04/22 09:17:19 [18511/1] ListMgr | Error 7 executing query
'SELECT DISTINCT(id) FROM NAMES LEFT JOIN (SELECT parent_id, COUNT(*)
as dirattr_sort FROM NAMES GROUP BY parent_idas ds ON id=ds.parent_id
WHERE ( this_path(NAMES.parent_id,NAMES.name) LIKE BINARY
'ABA49509:3598F9BF/test' OR this_path(NAMES.parent_id,NAMES.name) LIKE
BINARY 'ABA49509:3598F9BF/test/%') ORDER BY dirattr_sort DESC LIMIT
20': You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ds ON id=ds.parent_id WHERE (
this_path(NAMES.parent_id,NAMES.name) LIKE BINARY ' at line 1
2015/04/22 09:17:19 [18511/1] Report | ERROR: Could not retrieve top
directories from database.
-----------
I tried to run the query directly on mysql and also got a error. I
further looked at the sql statement and it seems this part "GROUP BY
parent_idas ds" may caused the trouble. Should the sql statement
have a ")" something like this: "GROUP BY parent_id) as ds"?
Thanks in advance for your help on this.
Regards,
Yujun
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
