[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] New system, crashing periodically b/c MySQL Locking



Hi Everybody,

We have a (reasonably) new install that has been grinding to a halt every
week or two. When I look at 'top' on the command line (Red Hat) mysqld is
hogging 100% CPU. When I use mysqladmin processlist I can see a number of
sessions queuing behind this...

| 104558 | doras | localhost | doras | Query   | 1587 |
statistics                   | INSERT INTO `cache17312`(`pos`, `eprintid`)
SELECT @i:=@i+1, `eprintid` FROM (SELECT `eprint`.`eprin | 0.000    |

The other processes (queued) are all waiting for table level lock and look
like this...


| 105134 | doras | localhost | doras | Query   | 487  | Waiting for table
level lock | UPDATE `eprint` SET `edit_lock_user`='1037',
`edit_lock_since`='1550139932', `edit_lock_until`='1550 | 0.000    |

| 105135 | doras | localhost | doras | Query   | 486  | Waiting for table
level lock | SELECT
`eprintid`,`rev_number`,`eprint_status`,`userid`,`importid`,`source`,`dir`,`datestamp_year`,`
| 0.000


Eventually the max http processes is reached and the system crashes. The
only remedy is to restart httpd and mariadb.


Any ideas what this insert into cache is and why it's locking the the
system?

Thanks for any guidance
Fran Callaghan
Dublin City University

-- 
*

*S?anadh R?omhphoist/Email Disclaimer*

*T? an r?omhphost seo agus aon 
chomhad a sheoltar leis faoi r?n agus is lena ?s?id ag an seola? agus sin 
amh?in ?. Is f?idir tuilleadh a l?amh anseo.? 
<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww4.dcu.ie%2Fiss%2Fseanadh-riomhphoist.shtml&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=%2BTlBkCbSYNAoKBUnVBHycuQ%2BKRfmiAUJmZAhiMEu4N0%3D&amp;reserved=0>*

*This e-mail and any 
files transmitted with it are confidential and are intended solely for use 
by the addressee. Read more here. 
<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww4.dcu.ie%2Fiss%2Femail-disclaimer.shtml&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=mTI50reeEZ%2BKCkPHKpKjooHNHNGdGgA2YDISZDYmQcw%3D&amp;reserved=0>*



*

-- 

 <https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FDCU%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=84yNSETj96%2Fi80RtNfmXATYrkRd64SnHyZoT6iyyyyE%3D&amp;reserved=0> <https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FDublinCityUni&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=PDYXHMoEuJpCfPoxqvE7xtReUTA%2FBD5tOM2%2F14Xh5y0%3D&amp;reserved=0> 
<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fdublin-city-university&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=9tkCC6HcmHo3WJEWbzYTy%2BgJIttmJTAv%2FhWNGqEr5ho%3D&amp;reserved=0> 
<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fdublincityuniversity%2F%3Fhl%3Den&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=AmGoga5ajbxCPOsPChiIG1R6r3Zms1YmE9%2BFpTP6gOw%3D&amp;reserved=0> 
<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fuser%2FDublinCityUniversity&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C32d92182c10a4e6d3bda08d6928bc9e8%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=GlewKcy9a41RSzEL5sCswr9Gl4Lv%2FWwcRzhkJ2IQbQw%3D&amp;reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20190214/d6df8f51/attachment.html