https://bugzilla.wikimedia.org/show_bug.cgi?id=28493
--- Comment #5 from Roan Kattouw <[email protected]> 2011-04-12 10:51:47 UTC --- Censored sample of dberror.log: Tue Apr 12 6:35:04 UTC 2011 srv254 enwiki Error connecting to 10.0.6.22: Can't connect to MySQL server on '10.0.6.22' (4) (10.0.6.22) Tue Apr 12 6:35:15 UTC 2011 srv265 dewiki User::invalidateCache 10.0.6.33 1205 Lock wait timeout exceeded; Try restarting transaction (10.0.6.33) UPDATE `user` SET user_touched = 'CENSORED' WHERE user_id = 'CENSORED' Tue Apr 12 6:51:14 UTC 2011 srv278 ruwiki GlobalUsage::insertLinks 10.0.6.41 1062 Duplicate entry 'Houston_City_Hall_from_Hermann_Square_(HDR).jpg-ruwiki-4401' for key 'PRIMARY' (10.0.6.41) INSERT INTO `globalimagelinks` (gil_wiki,gil_page,gil_page_namespace_id,gil_page_namespace,gil_page_title,gil_to) VALUES ('ruwiki','4401','0','','Заглавная_страница','Houston_City_Hall_from_Hermann_Square_(HDR).jpg') Tue Apr 12 6:52:33 UTC 2011 srv163 frwiki Job::pop 10.0.6.39 1213 Deadlock found when trying to get lock; Try restarting transaction (10.0.6.39) DELETE FROM `job` WHERE job_id = '136559964' Censored sample of grep -i fatal apache.log : Apr 12 07:13:18 10.0.8.3 apache2[6295]: PHP Fatal error: Maximum execution time of CENSORED seconds exceeded in /usr/local/apache/common-local/php-1.17/includes/parser/Parser.php on line 3202 Apr 12 07:19:48 10.0.8.2 apache2[3887]: PHP Fatal error: Allowed memory size of CENSORED bytes exhausted (tried to allocate CENSORED bytes) in /usr/local/apache/common-local/php-1.17/includes/parser/LinkHolderArray.php on line 265 Apr 12 08:48:56 10.0.8.18 apache2[14920]: PHP Fatal error: Call to a member function isRedirect() on a non-object in /usr/local/apache/common-local/php-1.17/extensions/Collection/Collection.php on line 369 As you can see the DB servers in dberror.log and the srv servers in apache.log are stored as IP addresses, so you'd need to resolve those: $ host 10.0.8.18 18.8.0.10.in-addr.arpa domain name pointer srv268.pmtpa.wmnet. I'm not sure the censoring of the limits in apache.log was necessary, but I do think we'll want to censor SQL queries before posting them to a public channel. There is code for this in MW already (censoring and generalizing SQL queries for profiling purposes), somewhere. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
