307424 - mysql_connect() error

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Ryan Flint [:rflint] (ping via IRC for reviews)]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8b4) Gecko/20050907 Firefox/1.4
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8b4) Gecko/20050907 Firefox/1.4

Over the past day or two, I've been intermittently receiving the following SQL
error while attempting to view pages on UMO: 

Warning: mysql_connect(): Too many connections in /opt/update/core/init.php on
line 61

Fatal error: MySQL Error 1040: Too many connections in /opt/update/core/init.php
on line 61

Reproducible: Sometimes

Steps to Reproduce:
1. Browse UMO


Actual Results:  
A MySQL error occured.

Expected Results:  
Normal operation.

Comment 1

[Dave Miller [:justdave]]

We can't bump max_connections up any higher than it is without burying the
database server.  However, we have multiple database servers, and spreading the
load around would easily solve this.  Unfortunately, that's an application
issue, and the existing addons app doesn't know how to do that.

The easiest fix for this is to make the app be able to query a different
database than the one it writes to.  Then the queries can be load-balanced on
multiple servers, while all the writes still go to the master.  Writes are
pretty infrequent on addons, in the grand scheme of things.

Comment 2

[Dave Miller [:justdave]]

Mike said on IRC that he was taking this

Comment 3

[Michael Morgan [:morgamic]]

Attachment: Add shadow db support for VersionCheck.php

Patch fixes "blank RDF" problem in bug 307235 and also separates out

Comment 4

[alanjstr]

Second database used for VersionCheck.php reads now.