[horde] DB locking issue

Steve Devine sd at msu.edu
Wed Feb 20 02:39:31 UTC 2008


We are testing horde-webmail-1.1-rc2
running it on a couple of boxes. We are using mysql and are getting DB 
locking issues.
These errors from horde.log
*******************************

Feb 19 21:23:08 HORDE [error] [kronolith] DB Error: not locked: SELECT 
datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN 
(0, 1, 1024, -21, 0, 0, 1, 0) AND group_uid = 'horde.shares.kronolith' 
ORDER BY datatree_id [nativecode=1100 ** Table 'horde_datatree' was not 
locked with LOCK TABLES] [pid 18258 on line 1292 of 
"/srv/www/ssl-htdocs/horde-webmail-1.1-rc2/kronolith/lib/Kronolith.php"]
Feb 19 21:23:08 HORDE [error] [kronolith] DB Error: not locked: UPDATE 
horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1100 ** Table 
'horde_datatree_seq' was not locked with LOCK TABLES] [pid 18258 on line 
542 of 
"/srv/www/ssl-htdocs/horde-webmail-1.1-rc2/lib/Horde/DataTree/sql.php"]
Feb 19 21:23:08 HORDE [error] [kronolith] Failed checking prefs for 
sad2: DB Error: not locked [pid 18258 on line 214 of 
"/srv/www/ssl-htdocs/horde-webmail-1.1-rc2/lib/Horde/Prefs/sql.php"]
*****************************
This error is intermittent.  It seems to happen mostly  while in 
calendar .  I believe my mysql db is setup ok as far as privileges.
We are also  using the sql box for  session management ..
Any one else running  into these types of errors?
/sd




-- 
Steve Devine
Email & Storage
Academic Computing & Network Services
Michigan State University

313 Computer Center
East Lansing, MI 48824-1042
1-517-432-7327

Baseball is ninety percent mental; the other half is physical.
- Yogi Berra



More information about the horde mailing list