Page MenuHomePhabricator
Paste P2202

Most common errors in DBPerformance.log (shortened stack traces, dbnames and TRX IDs stripped)
ActivePublic

Authored by Catrope on Oct 15 2015, 4:41 AM.
$ head -n 1000000 DBPerformance.log | sed ':a;N;$!ba;s/\n/\t/g' | sed 's/\t \t/\n/g' | cut -d ' ' -f 5- | sed -r 's/connect to [0-9]+\.[0-9]+\.[0-9]+\.[0-9]+ \([A-Za-z0-9_]+\)//' | sed -r 's/TRX#[0-9a-zA-Z]+//g' | sed -r 's/(([^\t]+\t){8}).*$/\1/g' | sort | uniq -c | sort -rn > ~/dbperf2
18733 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 1956 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 354 calls CentralAuthUser->loadAttached()
7057 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() BasicDbStorage.php line 138 calls Flow\DbFactory->getDB() BasicDbStorage.php line 160 calls Flow\Data\Storage\BasicDbStorage->find()
4981 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 401 calls CentralAuthUser->loadState()
2610 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 2010 calls CentralAuthUser->loadState()
956 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 425 calls CentralAuthUser->loadState()
165 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 639 calls wfGetDB() TranslatablePage.php line 755 calls TranslatablePage->getTranslationPages()
156 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() DBAccessBase.php line 61 calls LoadBalancer->getConnection() WikiPageEntityMetaDataLookup.php line 161 calls DBAccessBase->getConnection() WikiPageEntityMetaDataLookup.php line 70 calls Wikibase\Lib\Store\Sql\WikiPageEntityMetaDataLookup->selectRevisionInformationMultiple()
115 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 2033 calls CentralAuthUser::getCentralDB() SpecialCentralAuth.php line 96 calls CentralAuthUser->queryAttached()
60 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 676 calls wfGetDB() TranslatablePage.php line 230 calls TranslatablePage->getSections()
56 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() CentralAuthHooks.php line 904 calls wfGetDB() Hooks.php line 204 calls CentralAuthHooks::onUserLoadFromSession()
49 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 676 calls wfGetDB() TranslatablePage.php line 230 calls TranslatablePage->getSections()
47 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 401 calls CentralAuthUser->loadState()
30 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: INSERT IGNORE INTO `shorturls` (su_id,su_namespace,su_title) VALUES (NULL,'X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1926 calls DatabaseBase->query() ShortUrl.utils.php line 54 calls DatabaseBase->insert() ShortUrl.hooks.php line 44 calls ShortUrlUtils::encodeTitle()
28 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() ShortUrl.utils.php line 44 calls wfGetDB() ShortUrl.hooks.php line 44 calls ShortUrlUtils::encodeTitle()
27 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() RevisionStorage.php line 118 calls Flow\DbFactory->getDB() RevisionStorage.php line 168 calls Flow\Data\Storage\RevisionStorage->findInternal()
27 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 2010 calls CentralAuthUser->loadState()
26 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 1809 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 1796 calls CentralAuthUser->doListUnattached()
20 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() BasicDbStorage.php line 138 calls Flow\DbFactory->getDB() BasicDbStorage.php line 160 calls Flow\Data\Storage\BasicDbStorage->find()
17 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: UPDATE `echo_notification` SET notification_read_timestamp = 'X' AND notification_read_timestamp IS NULL TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1992 calls DatabaseBase->query() UserNotificationGateway.php line 56 calls DatabaseBase->update() NotifUser.php line 338 calls EchoUserNotificationGateway->markRead()
17 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() RevisionStorage.php line 118 calls Flow\DbFactory->getDB() RevisionStorage.php line 168 calls Flow\Data\Storage\RevisionStorage->findInternal()
13 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 861 calls wfGetDB() TranslatablePage.php line 849 calls TranslatablePage::getTranslatablePages()
12 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 490 calls CentralAuthUser->loadState()
10 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() EchoDbFactory.php line 66 calls LoadBalancer->getConnection() UserNotificationGateway.php line 45 calls MWEchoDbFactory->getEchoDb() NotifUser.php line 338 calls EchoUserNotificationGateway->markRead()
6 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() Block.php line 245 calls wfGetDB() Block.php line 1074 calls Block->newLoad()
5 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: INSERT IGNORE INTO `category` (cat_id,cat_title) VALUES (NULL,'X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1926 calls DatabaseBase->query() Category.php line 331 calls DatabaseBase->insert() CategoryViewer.php line 717 calls Category->refreshCounts()
5 DBPerformance INFO: [GET] Expectation (readQueryTime <= 5) by MediaWiki::main not met: query: SELECT rev_id,rev_len FROM `revision` WHERE rev_id IN ('X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 204 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1565 calls DatabaseBase->query() Revision.php line 534 calls DatabaseBase->select() HistoryAction.php line 475 calls Revision::getParentLengths()
5 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() User.php line 2303 calls wfGetDB() User.php line 2316 calls User->clearSharedCache()
4 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() CategoryViewer.php line 716 calls wfGetDB() CategoryViewer.php line 442 calls CategoryViewer->getCountMessage()
2 DBPerformance INFO: [HEAD] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 401 calls CentralAuthUser->loadState()
2 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: DELETE FROM `user_newtalk` WHERE user_id = 'X' [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 2942 calls DatabaseBase->query() User.php line 2224 calls DatabaseBase->delete() User.php line 2259 calls User->deleteNewtalk()
2 DBPerformance INFO: [GET] Expectation (readQueryTime <= 5) by MediaWiki::main not met: query: SELECT log_id,log_type,log_action,log_timestamp,log_user,log_user_text,log_namespace,log_title,log_comment,log_params,log_deleted,user_id,user_name,user_editcount,(SELECT GROUP_CONCAT(ct_tag SEPARATOR 'X') ORDER BY log_timestamp DESC LIMIT N [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 204 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1565 calls DatabaseBase->query() IndexPager.php line 365 calls DatabaseBase->select() IndexPager.php line 222 calls IndexPager->reallyDoQuery()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 861 calls wfGetDB() TranslatablePage.php line 849 calls TranslatablePage::getTranslatablePages()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() TranslatablePage.php line 639 calls wfGetDB() TranslatablePage.php line 755 calls TranslatablePage->getTranslationPages()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() BasicDbStorage.php line 138 calls Flow\DbFactory->getDB() BasicDbStorage.php line 182 calls Flow\Data\Storage\BasicDbStorage->find()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() User.php line 2221 calls wfGetDB() User.php line 2259 calls User->deleteNewtalk()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() Store.php line 185 calls wfGetDB() Store.php line 133 calls SecurePoll_DBStore->getDB()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() SqlBagOStuff.php line 163 calls wfGetDB() SqlBagOStuff.php line 239 calls SqlBagOStuff->getDB()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() AbuseFilterViewEdit.php line 798 calls wfGetDB() AbuseFilterViewEdit.php line 870 calls AbuseFilterViewEdit->loadFilterData()
2 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() BasicDbStorage.php line 138 calls Flow\DbFactory->getDB() BasicDbStorage.php line 182 calls Flow\Data\Storage\BasicDbStorage->find()
1 DBPerformance INFO: [HEAD] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() CentralAuthUser.php line 91 calls LoadBalancer->getConnection() CentralAuthUser.php line 1956 calls CentralAuthUser::getCentralDB() CentralAuthUser.php line 354 calls CentralAuthUser->loadAttached()
1 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: REPLACE INTO `redirect` (rd_from,rd_namespace,rd_title,rd_fragment,rd_interwiki) VALUES ('X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 2751 calls DatabaseBase->query() DatabaseMysqlBase.php line 455 calls DatabaseBase->nativeReplace() WikiPage.php line 925 calls DatabaseMysqlBase->replace()
1 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: INSERT IGNORE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1926 calls DatabaseBase->query() MessageGroupStats.php line 474 calls DatabaseBase->insert() MessageGroupStats.php line 489 calls Closure$MessageGroupStats::queueUpdates()
1 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: INSERT IGNORE INTO `msg_resource` (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X') [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 1926 calls DatabaseBase->query() MessageBlobStore.php line 132 calls DatabaseBase->insert() MessageBlobStore.php line 89 calls MessageBlobStore->insertMessageBlob()
1 DBPerformance INFO: [GET] Expectation (writes <= 0) by MediaWiki::main not met: query-m: DELETE FROM `ipblocks` WHERE ipb_parent_block_id = 'X' [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 200 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() Database.php line 2942 calls DatabaseBase->query() Block.php line 445 calls DatabaseBase->delete() Block.php line 798 calls Block->delete()
1 DBPerformance INFO: [GET] Expectation (readQueryTime <= 5) by MediaWiki::main not met: query: SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 204 calls TransactionProfiler->reportExpectationViolated() Database.php line 999 calls TransactionProfiler->recordQueryCompletion() SpecialRecentchangeslinked.php line 214 calls DatabaseBase->query() ChangesListSpecialPage.php line 91 calls SpecialRecentChangesLinked->doMainQuery() ChangesListSpecialPage.php line 52 calls ChangesListSpecialPage->getRows()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 548 calls TransactionProfiler->recordConnection() DbFactory.php line 55 calls LoadBalancer->getConnection() RevisionStorage.php line 275 calls Flow\DbFactory->getDB() RevisionStorage.php line 226 calls Flow\Data\Storage\RevisionStorage->findRevIdReal()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() WikiPage.php line 915 calls wfGetDB() WikiPage.php line 905 calls WikiPage->insertRedirectEntry()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() SpecialPageTranslation.php line 282 calls wfGetDB() SpecialPageTranslation.php line 366 calls SpecialPageTranslation->loadPagesFromDB()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() MessageGroupStats.php line 315 calls wfGetDB() MessageGroupStats.php line 243 calls MessageGroupStats::selectRowsIdLang()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() MessageBlobStore.php line 123 calls wfGetDB() MessageBlobStore.php line 89 calls MessageBlobStore->insertMessageBlob()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() CategoryViewer.php line 716 calls wfGetDB() CategoryViewer.php line 390 calls CategoryViewer->getCountMessage()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated() LoadBalancer.php line 546 calls TransactionProfiler->recordConnection() GlobalFunctions.php line 3655 calls LoadBalancer->getConnection() Block.php line 444 calls wfGetDB() Block.php line 798 calls Block->delete()
1 DBPerformance INFO: [GET] Expectation (masterConns <= 0) by MediaWiki::main not met: [] TransactionProfiler.php line 307 calls wfBacktrace() TransactionProfiler.php line 146 calls TransactionProfiler->reportExpectationViolated()

Event Timeline

Catrope edited the content of this paste. (Show Details)Oct 15 2015, 4:41 AM
Catrope changed the title of this paste from untitled to Most common errors in DBPerformance.log (shortened stack traces, dbnames and TRX IDs stripped).
Catrope updated the paste's language from autodetect to autodetect.
Catrope added a project: Performance Issue.