Tickets :: Comment on [#8283] 2006-04-18_add_creator_and_assignee

* Your Email Address
* Spam protection	Enter the letters below: . .. ..__. ..__. \|__\|\|\/\|\| \| \|\| \| \| \|\| \|\|__\|\__\|\|__\
Comment	> The Script > nag/scripts/upgrades/2006-04-18_add_creator_and_assignee_fields.php > gets a list of all 22k shares from $nag_shares->listAllShares(); and > then tries to get the actual tasks for each tasklist. $tasks = > Nag::listTasks(null, null, null, $tasklist, 1); fails at the latest > after 16382 calls (changed code to log into the horde.log file): > > > > May 18 10:37:33 HORDE [emergency] [nag] The Tasks backend is not > currently available: DB Error: connect failed [pid 16275 on line 79 > of > "/var/www/html/horde/nag/scripts/upgrades/2006-04-18_add_creator_and_assignee_fields.php"] > > > > It appears to me that for some reason db conncections are not closed > correctly at some point as the number of processed tasklists is > dependant on the maximal number of allowed open connections on the > mysql server side. Unfortunately MySQL versions below 5.1.17 do not > allow more than 16k connections by design, so the script fails before > all shrares are processed. (see: > http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections) > > > > I run the script with various sql settings in hope to get less > connections, mainly $GLOBALS['conf']['sql']['phptype']=mysql/mysqli > > $GLOBALS['conf']['sql']['phptype']=true/false > > > > System is CentOS 5.3, MySQL 5.0.45, PHP 5.1.6, PEAR Modules shipped > with Horde Webmail 1.2.3. > >
Attachment
Watch this ticket

Saved Queries