Obsolete:DB error sampling
Note: This page was created as a temporary pastebin and probably doesn't make any sense without its proper context |
Grabbed about the last week's worth of DB error log entries, stripped out basic connection errors and such. Was left with about 1064 entries, which I popped into a local DB table to do some breakdowns.
Top 10 function-errno loci
mysql> select count(*) as hits, function, errno, error from errorlog group by function, errno order by hits desc limit 10; +------+-------------------------------+-------+---------------------------------------------------------------------------------+ | hits | function | errno | error | +------+-------------------------------+-------+---------------------------------------------------------------------------------+ | 620 | Article::updateCategoryCounts | 1213 | Deadlock found when trying to get lock; Try restarting transaction (10.0.0.101) | | 240 | Article::insertOn | 1062 | Duplicate entry '0-Gentechnology' for key 2 (10.0.0.231) | | 41 | Article::doDeleteArticle | 1213 | Deadlock found when trying to get lock; Try restarting transaction (10.0.0.231) | | 26 | LinksUpdate::incrTableUpdate | 1213 | Deadlock found when trying to get lock; Try restarting transaction (10.0.0.235) | | 19 | TitleKey::prefixSearch | 1030 | Got error 28 from table handler (10.0.0.239) | | 9 | Title::invalidateCache | 1213 | Deadlock found when trying to get lock; Try restarting transaction (10.0.0.235) | | 9 | | 2013 | Lost connection to MySQL server during query (10.0.0.240) | | 8 | User::saveSettings | 1205 | Lock wait timeout exceeded; Try restarting transaction (10.0.0.101) | | 8 | TitleKey::prefixSearch | 2003 | Can't connect to MySQL server on '10.0.0.238' (4) (10.0.0.238) | | 7 | Job::pop | 1213 | Deadlock found when trying to get lock; Try restarting transaction (10.0.0.235) | +------+-------------------------------+-------+---------------------------------------------------------------------------------+