Page MenuHomePhabricator

MySQL errors for erwin85 relatedchanges, random article, and categorycount
Open, Needs TriagePublic

Description

"Database query failed" trying to use some tools like related changes, random article, or categorycount.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 16 2017, 8:32 PM

I see:

Access denied for user 's51362'@'%' to database 's51362__erwin85'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'INSERT command denied to user 's51362'@'10.64.37.14' for table 'sc_nlwiki_p'

These tools had a cache for the category tree which was used in the queries. TheDJ already talked to me that there was an expectation this would happen. The fix is probably a complete rewrite.

JJMC89 added a subscriber: JJMC89.Dec 17 2017, 12:31 AM

This is related to T142807: Migrate all users to new Wiki Replica cluster and decommission old hardware. s51362__erwin85 is on c3.labsdb, which is now readonly.

Thanks for helping me

Multichill renamed this task from MySQL errors to MySQL errors for erwin85 relatedchanges and random article.Dec 23 2017, 1:19 PM
JJMC89 renamed this task from MySQL errors for erwin85 relatedchanges and random article to MySQL errors for erwin85 relatedchanges, random article, and categorycount.Feb 12 2018, 3:05 PM
JJMC89 updated the task description. (Show Details)