|
From: John W. <j....@rb...> - 2006-09-26 15:30:24
|
<?xml version="1.0" ?><html> <head> <title></title> </head> <body> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">Hi,</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">A few months ago, we installed the DiGIR provider to provide data to the GBIF portal.  It ran with some teething troubles relating to cache size until last week we had our first big hit on the provider, which caused a massive increase in connections to the mysql database we are using to hold the content.  We then discovered that the DiGIR provider was not releasing connections (which in turn was causing other systems to fail). As a short term measure, we then restricted the maximum number of connections mysql would permit the user to have. This prevents DiGIR from overwelming mysql but now DiGIR has used up the connections and will not query the database, presumably because the connections are being held and are not available.</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">Looking at the documentation I can't see where the maximum number of connections is set (of course, I might be looking in the wrong place!).  I'm not a php person so looking at the code isn't helping.  I've also tried to download the latest cvs snapshot from www.digir.net but every time we try it we get a corrupted file warning (tried this on 2 difference machines at work).</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">Heres the diagnostics we get from DiGIR.php:</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostics> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostic code="<b>STATUS_INTERVAL</b>" severity="<b>info</b>">600</diagnostic> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostic code="<b>STATUS_DATA</b>" severity="<b>info</b>">2,0,0</diagnostic> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostic code="<b>Unknown PHP Error [2]</b>" severity="<b>DIAG_WARNING</b>">mysql_pconnect(): User 'digir' has exceeded the 'max_connections' resource (current value: 10) (/home/www/docs/digir/lib/adodb/drivers/adodb- mysql.inc.php:251)</diagnostic> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostic code="<b>INTERNAL_DATABASE_ERROR</b>" severity="<b>error</b>">ADOdb reported error connecting to database:User 'digir' has exceeded the 'max_connections' resource (current value: 10)</diagnostic> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"><diagnostic code="<b>Unknown PHP Error [2]</b>" severity="<b>DIAG_WARNING</b>">mysql_close(): supplied argument is not a valid MySQL-Link resource (/home/www/docs/digir/lib/adodb/drivers/adodb- mysql.inc.php:370)</diagnostic> </span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt"></diagnostics></span></font></p> <p><br/> </p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">I hope you can help!</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size:12pt">John Wall</span></font></p> <div align="left"></div> </body> </html> |