| Summary | 2006-04-18_add_creator_and_assignee_fields.php does not run to completion |
| Queue | Nag |
| Queue Version | 2.3.2 |
| Type | Bug |
| State | Not A Bug |
| Priority | 1. Low |
| Owners | |
| Requester | karsten.konrad (at) uni-graz (dot) at |
| Created | 05/15/2009 (5917 days ago) |
| Due | |
| Updated | 05/31/2009 (5901 days ago) |
| Assigned | 05/15/2009 (5917 days ago) |
| Resolved | 05/31/2009 (5901 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
doesn't work, then your PHP must be badly broken. You can try to
workaround this by enable persistent connections in the DB
configuration, at least while you run 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.
State ⇒ Feedback
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ 2006-04-18_add_creator_and_assignee_fields.php does not run to completion
Queue ⇒ Nag
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
/nag/scripts/upgrade/2006-04-18_add_creator_and_assignee_fields.php
fails while storing task creators after being silently busy for a while:
PHP Warning:
Nag_Driver::require_once(/var/www/html/horde/nag/lib/Driver/sql.php):
failed to open stream: Too many open files in
/var/www/html/horde/nag/lib/Driver.php on line 131
PHP Fatal error: Nag_Driver::require_once(): Failed opening required
'/var/www/html/horde/nag/lib/Driver/sql.php'
(include_path='/var/www/html/horde/lib:/var/www/html/horde/lib/../pear') in
/var/www/html/horde/nag/lib/Driver.php on line 131
<<<<
Storing task creators for johndoe ...
...
I tried to allow php to open more files with ulimit -n 64000, but the
script wont process more than 1995 tasklists (~10%).