Page MenuHomePhabricator

"The database is read-only until replication lag decreases" when saving preferences on beta
Closed, ResolvedPublic

Description

I changed my preferences (enabled a gadget) at https://commons.wikimedia.beta.wmflabs.org/wiki/Special:Preferences.

Expected:

  1. I click save
  2. My preferences are saved
  3. I am returned to Special:Preferences

What happen:

  1. I click save
  2. My preferences are saved (yes, they are)
  3. Database locked The database is currently locked to new entries and other modifications, probably for routine database maintenance, after which it will be back to normal. The system administrator who locked it offered this explanation: The database is read-only until replication lag decreases. Return to Special:MyLanguage/Main Page.

This happened to me more than once.

Event Timeline

replication looks up:

root@deployment-db06:~# mysql -S $(find /tmp -name mysql.sock) -e 'show slave status \G'
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: deployment-db05
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: deployment-db05-bin.000050
          Read_Master_Log_Pos: 218772876
               Relay_Log_File: deployment-db06-relay-bin.000142
                Relay_Log_Pos: 218773174
        Relay_Master_Log_File: deployment-db05-bin.000050
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes