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

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.

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)