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
