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?
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
