[Tickets #8283] Re: 2006-04-18_add_creator_and_assignee_fields.php does not run to completion

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8283
------------------------------------------------------------------------------
  Ticket             | 8283
  Updated By         | karsten.konrad at uni-graz.at
  Summary            | 2006-04-18_add_creator_and_assignee_fields.php does not
                     | run to completion
  Queue              | Nag
  Version            | 2.3.2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


karsten.konrad at uni-graz.at (2009-05-18 09:07) wrote:

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.