Obsolete:DB error sampling

From Wikitech

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) | 
+------+-------------------------------+-------+---------------------------------------------------------------------------------+