On 07/15/15 14:28, Loris Bennett wrote:
> Hi Thomas,
>
> LEIBOVICI Thomas <[email protected]> writes:
>
>> Hi Loris,
>>
>> Thank you for reporting. I confirm this is a bug in rbh-diff command.
>>
>> As a workaround you can run:
>>
>>   > robinhood --scan=/mnt/lustre/foo --diff=all
>>
>> this is functionally equivalent to: "rbh-diff --scan=/mnt/lustre/foo
>> --apply=db"
>>
>> This will display the detected changes, however this will also update
>> robinhood DB (which may not be what you want).
> Could I avoid the actual update by doing a dry-run, e.g
>
> rbh-diff --scan=/mnt/lustre/foo  --apply=db --dry-run
I think will fail like "rbh-diff --scan=/mnt/lustre/foo" did.

And "robinhood --scan=/mnt/lustre/foo --diff=all --dry-run" doesn't have 
the same meaning (for robinhood command, dry-run avopid performing real 
policy actions, but still impact the DB).
>> Anyhow, I'll keep you updated about fix of partial scan with "rbh-diff".
> OK, thanks.
I have a fix. Validation tests are currently running, so the fix should 
be available soon.

>
> Cheers,
>
> Loris
>
>> Thomas
>>
>> On 07/14/15 08:34, Loris Bennett wrote:
>>> "Loris Bennett" <[email protected]>
>>> writes:
>>>
>>>> Hi,
>>>>
>>>> I'm calling rbh-diff (version 2.5.5-1) like this:
>>>>
>>>> rbh-diff --scan=/scratch/loris 
>>>> --config-file=/etc/robinhood.d/tmpfs/scratch.conf --log-level=FULL
>>>>
>>>> and getting the following error:
>>>>
>>>> 2015/07/08 10:08:45 [7570/1] ListMgr | SQL query: CREATE TABLE 
>>>> TAG_DIFF_7570 (id VARCHAR(64) PRIMARY KEY) AS SELECT (null).id as id FROM  
>>>> WHERE ????
>>>> 2015/07/08 10:08:45 [7570/1] ListMgr | SQL request parse error
>>>> 2015/07/08 10:08:45 [7570/1] ListMgr | Error 7 executing query 'CREATE 
>>>> TABLE TAG_DIFF_7570 (id VARCHAR(64) PRIMARY KEY) AS SELECT (null).id as id 
>>>> FROM  WHERE ????': 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 '.id as id FROM  WHERE ????' at line 1
>>>>
>>>> The parameters for the SELECT-part of the SQL query are obviously
>>>> missing.  Am I doing something wrong?
>>>>
>>>> Cheers,
>>>>
>>>> Loris
>>> If I call
>>>
>>> rbh-diff --config-file=/etc/robinhood.d/tmpfs/scratch.conf --log-level=FULL
>>>
>>> i.e. without the 'scan' option, the SELECT statement is fine and there is 
>>> no error:
>>>
>>> 2015/07/14 08:31:01 [20432/1] ListMgr | SQL query: CREATE TABLE 
>>> TAG_DIFF_20432 (id VARCHAR(64) PRIMARY KEY) AS SELECT id FROM ENTRIES
>>>
>>> Any thoughts?
>>>
>>> Cheers,
>>>
>>> Loris
>>>
>>
>> ------------------------------------------------------------------------------
>> Don't Limit Your Business. Reach for the Cloud.
>> GigeNET's Cloud Solutions provide you with the tools and support that
>> you need to offload your IT needs and focus on growing your business.
>> Configured For All Businesses. Start Your Cloud Today.
>> https://www.gigenetcloud.com/


------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support

Reply via email to