LEIBOVICI Thomas <[email protected]> writes:
> On 09/12/16 13:24, Loris Bennett wrote:
>> LEIBOVICI Thomas <[email protected]> writes:
>>
>>> On 09/12/16 10:56, Loris Bennett wrote:
>>>> [pid 15380] read(29, <unfinished ...>
>>>> [pid 15367] read(30, <unfinished ...>
>>> These may wait replies from the database.
>>>
>>> Unfortunatly the output is too short to see when (and if) they end.
>>> Tracking only pids 15380 and 15367 may give more info.
>> Both seem to go into an endless loop of:
>>
>> [pid 15331] rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
>> [pid 15331] rt_sigaction(SIGCHLD, NULL, {SIG_DFL, [], 0}, 8) = 0
>> [pid 15331] rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
>> [pid 15331] nanosleep({1, 0}, 0x7fffacfb5110) = 0
>>
>>> You can also check running mysql requests:
>>>
>>> mysql <dbname>
>>>
>>> > SHOW PROCESSLIST;
>> I've deleted some of the boring columns:
>>
>> +--------+---------+--------+------------+------------------------------------------------------------------------------------------------------+
>> | Id | Command | Time | State | Info
>> |
>> +--------+---------+--------+------------+------------------------------------------------------------------------------------------------------+
>> | 135246 | Query | 572858 | NULL | SELECT parent_id, name INTO pid,
>> n from NAMES where id= NAME_CONST('pid',_latin1'63BBC16B:29F8000' C |
>> | 135251 | Query | 572858 | Locked | UPDATE ENTRIES SET
>> owner='bob12',gr_name='smith123',size=60645,blocks=120,last_access=1472802557,las
>> |
>> | 136583 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82904F' |
>> | 136584 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829043' |
>> | 136585 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829039' |
>> | 136586 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82903E' |
>> | 136587 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82903C' |
>> | 136588 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829050' |
>> | 136589 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82904E' |
>> | 136590 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829048' |
>> | 136591 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829045' |
>> | 136592 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829049' |
>> | 136593 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829052' |
>> | 136594 | Query | 572858 | Locked | INSERT INTO
>> ENTRIES(id,owner,gr_name,size,blocks,last_access,last_mod,type,mode,nlink,md_update,inva
>> |
>> | 136595 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82904C' |
>> | 136596 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829040' |
>> | 136597 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C82904A' |
>> | 136598 | Query | 572858 | Locked | SELECT release_class FROM ENTRIES
>> WHERE ENTRIES.id='63BBC16B:C829053' |
>> | 143740 | Query | 362996 | Locked | SELECT size,blocks,type FROM
>> ENTRIES WHERE ENTRIES.id='63BBC16B:D7060' |
>> | 144670 | Query | 335560 | Locked | SELECT size,blocks,type FROM
>> ENTRIES WHERE ENTRIES.id='63BBC16B:D7060' |
>> | 144848 | Query | 331848 | Locked | SELECT id FROM ENTRIES WHERE
>> (ENTRIES.invalid=0 OR ENTRIES.invalid IS NULL) AND ENTRIES.type<>'dir' |
>> | 144849 | Query | 331848 | Locked | SELECT COUNT(*) FROM ENTRIES
>> |
>> | 145931 | Query | 271904 | Locked | SELECT COUNT(*) FROM ENTRIES
>> |
>> | 145932 | Query | 271904 | Locked | SELECT id FROM ENTRIES WHERE
>> (ENTRIES.invalid=0 OR ENTRIES.invalid IS NULL) AND ENTRIES.type<>'dir' |
>> | 146013 | Query | 271369 | Locked | SELECT id FROM ENTRIES WHERE
>> ENTRIES.type<>'dir' AND (ENTRIES.release_class<>'@ignore@' OR ENTRIES.r |
>> | 147134 | Query | 206037 | Locked | SELECT id FROM ENTRIES WHERE
>> ENTRIES.type='file' AND (ENTRIES.last_access<1470880922 OR ENTRIES.last |
>> | 150453 | Query | 13699 | Locked | SELECT id FROM ENTRIES WHERE
>> (ENTRIES.invalid=0 OR ENTRIES.invalid IS NULL) AND ENTRIES.type<>'dir' |
>> | 150454 | Query | 13699 | Locked | SELECT COUNT(*) FROM ENTRIES
>> |
>> | 150751 | Query | 0 | NULL | show processlist
>> |
>> +--------+---------+--------+------------+------------------------------------------------------------------------------------------------------+
>>
>> So is it the first SELECT:
>>
>> SELECT parent_id, name INTO pid, n from NAMES where id=
>> NAME_CONST('pid',_latin1'63BBC16B:29F8000' COLLATE 'latin1_swedish_ci')
>>
>> which is causing the problem?
> State "NULL" looks suspicious.
>
> I suggest you run "kill 135246" in a mysql shell.
This seemed to help. However, the scan is still running very slowly:
+--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
| Id | Command | Time | State | Info
|
+--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
| 150429 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447782' |
| 150430 | Query | 58372 | Locked | INSERT INTO
NAMES(id,parent_id,name,path_update,pkn) VALUES
('63BBC16B:2FFC5E3','63BBC16B:2FFC27C',' |
| 150431 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447787' |
| 150432 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447781' |
| 150433 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447780' |
| 150434 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447785' |
| 150435 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447734' |
| 150436 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:2FFF03D' |
| 150437 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:2FFF03C' |
| 150438 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447788' |
| 150439 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447784' |
| 150440 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:2FFF03A' |
| 150441 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447786' |
| 150442 | Query | 58372 | Locked | SELECT id FROM ENTRIES WHERE
id='63BBC16B:2FFC27C' |
| 150443 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447789' |
| 150444 | Query | 58372 | Locked | SELECT release_class FROM ENTRIES
WHERE ENTRIES.id='63BBC16B:9447783' |
| 150446 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641783,last_mod=13736
|
| 150447 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641793,last_mod=13736
|
| 150448 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641786,last_mod=13736
|
| 150449 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641793,last_mod=13736
|
| 150450 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641783,last_mod=13736
|
| 150451 | Query | 58372 | Locked | UPDATE ENTRIES SET
owner='root',gr_name='root',size=0,blocks=0,last_access=1373641784,last_mod=13736
|
| 150452 | Sleep | 57 | | NULL
|
| 150453 | Query | 58372 | statistics | SELECT parent_id, name INTO pid,
n from NAMES where id= NAME_CONST('pid',_latin1'63BBC16B:2AA1015' C |
| 150481 | Sleep | 33 | | NULL
|
| 152540 | Query | 7 | Sorting result | SELECT id FROM ENTRIES WHERE
(ENTRIES.invalid=0 OR ENTRIES.invalid IS NULL) AND ENTRIES.type<>'dir' |
| 152541 | Sleep | 7 | | NULL
|
| 152542 | Sleep | 7 | | NULL
|
| 152543 | Sleep | 7 | | NULL
|
| 152544 | Sleep | 7 | | NULL
|
| 152545 | Sleep | 7 | | NULL
|
| 152546 | Sleep | 7 | | NULL
|
| 153052 | Query | 0 | NULL | show processlist
|
+--------+---------+-------+----------------+------------------------------------------------------------------------------------------------------+
As a lot of files has been deleted, I think I may need to look at
OPTIMIZE TABLE. Would 'ENTRIES' be the most relevant table to optimise?
Cheers,
Loris
--
Dr. Loris Bennett (Mr.)
ZEDAT, Freie Universität Berlin Email [email protected]
------------------------------------------------------------------------------
_______________________________________________
robinhood-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/robinhood-support
