On 08/11/2016 03:29 AM, LEIBOVICI Thomas wrote:
> Hi Jessica,
>
> I suspect a behavior change in recent versions of MySQL/MariaDB.
>
> As of now, robinhood validation process is lead with these versions
> (or above):
> mariadb-5.5.44
> mysql-5.1.73
>
> What DB version are you running?
>
> As LOG function is used for accounting, I think that a quick
> workaround is to disable it:
>
> ListManager {
> accounting = no;
> ...
> }
>
> If it works, I think I know what's wrong.
>
> Thanks for reporting,
> Thomas.
>
Yes, your hunch appears correct. We were using percona 5.7. Josh
downgraded to 5.6 and we are scanning now.
Thanks,
Jessica
> On 08/09/16 23:31, Jessica Otey wrote:
>> All,
>> Still trying to get a successful first scan on my v3 robinhood
>> installation.
>>
>> Currently I'm getting this output:
>>
>> [root@osiris ~]# robinhood --scan --once
>> Using config file '/etc/robinhood.d/naaschpc.conf'.
>> 2016/08/09 17:23:34 [11656/1] CheckFS | '/.lustre/naasc' matches mount
>> point '/.lustre/naasc', type=lustre, fs=10.7.17.8@o2ib0:/naaschpc
>> 2016/08/09 17:23:34 [11656/1] EntryProc | No fileclass defined in
>> configuration, disabling fileclass matching.
>> 2016/08/09 17:23:34 [11656/2] FS_Scan | Starting scan of /.lustre/naasc
>> 2016/08/09 17:23:35 [11656/3] ListMgr | Unhandled error 3020: default
>> conversion to DB_REQUEST_FAILED
>> 2016/08/09 17:23:35 [11656/3] ListMgr | Error 7 executing query 'INSERT
>> INTO
>> ENTRIES(id,uid,gid,size,blocks,creation_time,last_access,last_mod,last_mdchange,type,mode,nlink,md_update,invalid)
>>
>>
>> VALUES
>> ('0x6f94f7:0x2a86f03f:0x0','root','root',0,0,1422997288,1447170142,1422997288,1422997288,'file',384,1,1470777815,0)':
>>
>>
>> Invalid argument for logarithm
>> 2016/08/09 17:23:35 [11656/3] ListMgr | DB query failed in
>> ListMgr_Insert line 283: code=7:
>> 2016/08/09 17:23:35 [11656/3] EntryProc | Error 7 performing database
>> operation: request error.
>>
>> I've learned that 3020 is this error:
>>
>> [root@osiris ~]# grep 3020 /usr/local/mysql/include/mysqld_error.h
>> #define ER_INVALID_ARGUMENT_FOR_LOGARITHM 3020
>>
>> Is this a database access issue or something else? I can get to the
>> database via mysql and the perms look good to me:
>>
>> mysql> show grants;
>> +---------------------------------------------------------------------------+
>>
>>
>> | Grants for
>> robinhood@localhost |
>> +---------------------------------------------------------------------------+
>>
>>
>> | GRANT SUPER ON *.* TO
>> 'robinhood'@'localhost' |
>> | GRANT ALL PRIVILEGES ON `robinhood_naaschpc`.* TO
>> 'robinhood'@'localhost' |
>> +---------------------------------------------------------------------------+
>>
>>
>> 2 rows in set (0.00 sec)
>>
>> Any thoughts?
>>
>> Thanks,
>> Jessica
>>
--
Jessica Otey
System Administrator II
North American ALMA Science Center (NAASC)
National Radio Astronomy Observatory (NRAO)
Charlottesville, Virginia (USA)
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
