[horde] Allowed memory exhausted

Mike Bydalek mbydalek at mobilemini.com
Fri Jul 23 16:47:25 PDT 2004


I'm seeing some strange errors which I have a feeling have to do with
Permissions.  Basically any user that is NOT an admin in conf.php can't do
anything in the system, except hang up mysql and apache.  One thing for
example is to goto the Layout or even Options.  Nothing works.

Looking at my horde.log (in DEBUG mode), I noticed at one time it just kept
repeating this:

Jul 23 16:38:01 HORDE [debug] [whups] SQL Query by
Whups_Driver_sql::getQueueUsers(): SELECT user_uid, user_uid FROM
whups_queues_users WHERE queue_id = 12 ORDER BY user_uid [on line 1074 of
"/usr/local/www/data/horde/whups/lib/Driver/sql.php"]

Over and over and over, all while apache was getting:
Allowed memory size of 134217728 bytes exhausted (tried to allocate 1680
bytes)

So my question is, what permissions should be set to resolve this issue (of
course if it is permissions in the first place)?  I tried adding 'logout'
and 'horde' and giving All Authenticated users all permissions to no avail.

What happened after that, is that these just keep getting executed over and
over, but not rapidly like before. All do have results, but I'm not DataTree
expert, so I don't know if they are correct or not.

Jul 23 16:43:25 HORDE [debug] [] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_parents FROM horde_datatree WHERE datatree_name =
'horde' AND group_uid = 'horde.perms' ORDER BY datatree_id [on line 103 of
"/usr/local/lib/php/pear/Horde/DataTree/sql.php"]
Jul 23 16:43:25 HORDE [debug] [] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE (datatree_parents LIKE ':5743%' OR datatree_id = 5743)
AND group_uid = 'horde.perms' [on line 146 of
"/usr/local/lib/php/pear/Horde/DataTree/sql.php"]
Jul 23 16:43:25 HORDE [debug] [] SQL Query by DataTree_sql::getData():
SELECT datatree_data, datatree_serialized FROM horde_datatree WHERE
datatree_id = 5743 [on line 696 of
"/usr/local/lib/php/pear/Horde/DataTree/sql.php"]
Jul 23 16:43:25 HORDE [debug] [horde] SQL Query by DataTree_sql::_load():
SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_name
= 'logout' AND group_uid = 'horde.perms' ORDER BY datatree_id [on line 103
of "/usr/local/lib/php/pear/Horde/DataTree/sql.php"]
Jul 23 16:43:25 HORDE [debug] [horde] SQL Query by DataTree_sql::_load():
SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE (datatree_parents LIKE ':5744%' OR datatree_id = 5744)
AND group_uid = 'horde.perms' [on line 146 of
"/usr/local/lib/php/pear/Horde/DataTree/sql.php"]
Jul 23 16:43:25 HORDE [debug] [horde] SQL Query by DataTree_sql::getData():
SELECT datatree_data, datatree_serialized FROM horde_datatree WHERE
datatree_id = 5744 [on line 696 of
"/usr/local/lib/php/pear/Horde/DataTree/sql.php"]

Any suggestions?

-Mike



More information about the horde mailing list