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. > > Cheers, > > Loris > ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
