Hello Thomas,
Thanks a lot for looking into it and the fix. Yes, your workaround works. I
look forward to trying your new update when it is out.
Regards,
Yujun
________________________________
From: LEIBOVICI Thomas [[email protected]]
Sent: Friday, April 24, 2015 8:28 AM
To: Yujun Wu; [email protected]
Subject: Re: [robinhood-support] Help with a question on Robinhood
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]<mailto:[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
