Hi Thomas,

Thanks a lot for your quick fix. I was just able to retrieve it and build it 
without error. I will scan a TMPFS and try with the commands. I will report 
back to you on this.


Regards,
Yujun
________________________________
From: LEIBOVICI Thomas [[email protected]]
Sent: Monday, May 04, 2015 4:11 AM
To: Yujun Wu; [email protected]
Subject: Re: [robinhood-support] Help with a question on Robinhood

Hi Yujun,

The fix has been pushed to the robinhood source tree.
So you can retrieve and build it from the sources:
  git clone https://github.com/cea-hpc/robinhood.git
    sh autogen.sh
    ./configure
    make rpm

Regards
Thomas

On 04/24/15 23:03, Yujun Wu wrote:
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]<mailto:[email protected]>]
Sent: Friday, April 24, 2015 8:28 AM
To: Yujun Wu; 
[email protected]<mailto:[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

Reply via email to