Whoops, I mean "show processlist;" not select.

On Thu, Aug 4, 2016 at 11:04 AM, Colin Faber <[email protected]> wrote:

> Hi Jessica,
>
> Is the database indicating any work? (login to the db, issue: select
> processlist;)
>
> -cf
>
> On Thu, Aug 4, 2016 at 8:23 AM, Jessica Otey <[email protected]> wrote:
>
>> Hello all,
>> I just installed robinhood v3 and yesterday afternoon kicked off the
>> first scan (against a lustre 2.4.3 system).
>> The scan claims to still be running, yet it reports that it hasn't taken
>> action in many hours.
>>
>> Filesystem scan activity:
>>
>>     Last filesystem scan:
>>             status:          running
>>             start:           2016/08/03 15:59:40 (18h 19min 05s ago)
>>             last action:     2016/08/03 17:45:40 (16h 33min 05s ago)
>>
>>          Statistics:
>>             entries scanned: 21138633
>>             # threads:       2
>>             average speed:   1234.57 entries/sec
>>         >>> current speed:   1408.45 entries/sec
>>
>> Storage usage has never been checked
>>
>> Moreover, the time of the last action appears to be incorrect, judging by
>> the scan output. Between the stat dump at 23:44:40 and the one at 23:59:40,
>> suddenly it decides that it has been 6.2 hours since the last scan? This
>> seems suspicious to me.
>>
>> Any advice? Is this scan likely to complete or am I out of luck?
>>
>> Thanks,
>> Jessica
>>
>>
>> *2016/08/03 23:44:40 [31020/3] STATS | ==================== Dumping stats
>> at 2016/08/03 23:44:40 =====================*
>> 2016/08/03 23:44:40 [31020/3] STATS | ======== General statistics
>> =========
>> 2016/08/03 23:44:40 [31020/3] STATS | Daemon start time: 2016/08/03
>> 15:59:40
>> 2016/08/03 23:44:40 [31020/3] STATS | Started modules: scan
>> 2016/08/03 23:44:40 [31020/3] STATS | ======== FS scan statistics
>> =========
>> 2016/08/03 23:44:40 [31020/3] STATS | current scan interval = 18.5d
>> 2016/08/03 23:44:40 [31020/3] STATS | scan is running:
>> 2016/08/03 23:44:40 [31020/3] STATS |      started at : 2016/08/03
>> 15:59:40 (7.8h ago)
>> *2016/08/03 23:44:40 [31020/3] STATS |      last action: 2016/08/03
>> 23:44:40 (00s ago)*
>> 2016/08/03 23:44:40 [31020/3] STATS |      progress   : 21112446 entries
>> scanned (0 errors)
>> 2016/08/03 23:44:40 [31020/3] STATS |      inst. speed (potential):
>> 662.91 entries/sec (3.02 ms/entry/thread)
>> 2016/08/03 23:44:40 [31020/3] STATS |      avg. speed  (effective):
>> 756.72 entries/sec (1.62 ms/entry/thread)
>> 2016/08/03 23:44:40 [31020/3] STATS | ==== EntryProcessor Pipeline Stats
>> ===
>> 2016/08/03 23:44:40 [31020/3] STATS | Idle threads: 9
>> 2016/08/03 23:44:40 [31020/3] STATS | Id constraints count: 9252 (hash
>> min=0/max=49/avg=0.6)
>> 2016/08/03 23:44:40 [31020/3] STATS | Name constraints count: 9252 (hash
>> min=0/max=14/avg=0.6)
>> 2016/08/03 23:44:40 [31020/3] STATS | Stage              | Wait | Curr |
>> Done |     Total | ms/op |
>> 2016/08/03 23:44:40 [31020/3] STATS |  0: GET_FID        |    0 |    0
>> |    0 |    164126 |  0.72 |
>> 2016/08/03 23:44:40 [31020/3] STATS |  1: GET_INFO_DB    |    0 |    0
>> |    0 |  21112428 |  0.35 |
>> 2016/08/03 23:44:40 [31020/3] STATS |  2: GET_INFO_FS    |    0 |    0
>> |    0 |  21112428 |  0.01 |
>> 2016/08/03 23:44:40 [31020/3] STATS |  3: PRE_APPLY      |    0 |    0
>> |    0 |  21112428 |  0.00 |
>> 2016/08/03 23:44:40 [31020/3] STATS |  4: DB_APPLY       | 8252 | 1000
>> |    0 |  21103176 |  1.15 | 98.57% batched (avg batch size: 40.1)
>> 2016/08/03 23:44:40 [31020/3] STATS |  5: CHGLOG_CLR     |    0 |    0
>> |    0 |         0 |  0.00 |
>> 2016/08/03 23:44:40 [31020/3] STATS |  6: RM_OLD_ENTRIES |    0 |    0
>> |    0 |         0 |  0.00 |
>> 2016/08/03 23:44:40 [31020/3] STATS | DB ops:
>> get=0/ins=21083643/upd=19533/rm=0
>> 2016/08/03 23:44:40 [31020/3] STATS | --- Pipeline stage details ---
>> 2016/08/03 23:44:40 [31020/3] STATS | DB_APPLY      : first:
>> [0x7c8762:0x6c5a2001:0x0], status=processing
>> 2016/08/03 23:44:40 [31020/3] STATS | DB_APPLY      : last:
>> [0x7e1a17:0x1095ff13:0x0], status=waiting
>>
>>
>> *2016/08/03 23:59:40 [31020/3] STATS | ==================== Dumping stats
>> at 2016/08/03 23:59:40 =====================*
>> 2016/08/03 23:59:40 [31020/3] STATS | ======== General statistics
>> =========
>> 2016/08/03 23:59:40 [31020/3] STATS | Daemon start time: 2016/08/03
>> 15:59:40
>> 2016/08/03 23:59:40 [31020/3] STATS | Started modules: scan
>> 2016/08/03 23:59:40 [31020/3] STATS | ======== FS scan statistics
>> =========
>> 2016/08/03 23:59:40 [31020/3] STATS | current scan interval = 18.5d
>> 2016/08/03 23:59:40 [31020/3] STATS | scan is running:
>> 2016/08/03 23:59:40 [31020/3] STATS |      started at : 2016/08/03
>> 15:59:40 (8.0h ago)
>> *2016/08/03 23:59:40 [31020/3] STATS |      last action: 2016/08/03
>> 17:45:40 (6.2h ago)*
>> 2016/08/03 23:59:40 [31020/3] STATS |      progress   : 21138633 entries
>> scanned (0 errors)
>> 2016/08/03 23:59:40 [31020/3] STATS |      inst. speed (potential):
>> 1408.95 entries/sec (1.42 ms/entry/thread)
>> 2016/08/03 23:59:40 [31020/3] STATS |      avg. speed  (effective):
>> 733.98 entries/sec (1.62 ms/entry/thread)
>> 2016/08/03 23:59:40 [31020/3] STATS | ==== EntryProcessor Pipeline Stats
>> ===
>> 2016/08/03 23:59:40 [31020/3] STATS | Idle threads: 10
>> 2016/08/03 23:59:40 [31020/3] STATS | Id constraints count: 0 (hash
>> min=0/max=0/avg=0.0)
>> 2016/08/03 23:59:40 [31020/3] STATS | Name constraints count: 0 (hash
>> min=0/max=0/avg=0.0)
>> 2016/08/03 23:59:40 [31020/3] STATS | Stage              | Wait | Curr |
>> Done |     Total | ms/op |
>> 2016/08/03 23:59:40 [31020/3] STATS |  0: GET_FID        |    0 |    0
>> |    0 |    164149 |  0.72 |
>> 2016/08/03 23:59:40 [31020/3] STATS |  1: GET_INFO_DB    |    0 |    0
>> |    0 |  21138631 |  0.35 |
>> 2016/08/03 23:59:40 [31020/3] STATS |  2: GET_INFO_FS    |    0 |    0
>> |    0 |  21138631 |  0.01 |
>> 2016/08/03 23:59:40 [31020/3] STATS |  3: PRE_APPLY      |    0 |    0
>> |    0 |  21138631 |  0.00 |
>> 2016/08/03 23:59:40 [31020/3] STATS |  4: DB_APPLY       |    0 |    0
>> |    0 |  21138631 |  1.15 | 98.57% batched (avg batch size: 40.1)
>> 2016/08/03 23:59:40 [31020/3] STATS |  5: CHGLOG_CLR     |    0 |    0
>> |    0 |         0 |  0.00 |
>> 2016/08/03 23:59:40 [31020/3] STATS |  6: RM_OLD_ENTRIES |    0 |    0
>> |    0 |         0 |  0.00 |
>> 2016/08/03 23:59:40 [31020/3] STATS | DB ops:
>> get=0/ins=21119098/upd=19533/rm=0
>>
>>
>>
>> --
>> Jessica Otey
>> System Administrator II
>> North American ALMA Science Center (NAASC)
>> National Radio Astronomy Observatory (NRAO)
>> Charlottesville, Virginia (USA)
>>
>>
>> ------------------------------------------------------------
>> ------------------
>>
>> _______________________________________________
>> robinhood-support mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/robinhood-support
>>
>>
>
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support

Reply via email to