[prelude-user] DB error in prewikka when deleting records

adjete wilson wilsadjete at gmail.com
Thu Oct 16 05:39:32 CEST 2008


Whenever I tried to delete recors as low as 50, I get the error. According
to my research, It has to do with a mysql variable size. Any ideas how I can
fix this, or determine where the bottleneck is?  Thanks in advance.
Prewikka internal error
*The total number of locks exceeds the lock table size*

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/prewikka/Core.py", line 333, in
process
    getattr(view_object, view["handler"])()
  File "/usr/lib/python2.4/site-packages/prewikka/views/alertlisting.py",
line 1084, in render
    self._deleteMessages()
  File "/usr/lib/python2.4/site-packages/prewikka/views/messagelisting.py",
line 358, in _deleteMessages
    self._deleteMessage(idents)
  File "/usr/lib/python2.4/site-packages/prewikka/views/alertlisting.py",
line 713, in _deleteMessage
    self.env.idmef_db.deleteAlert(ident)
  File "/usr/lib/python2.4/site-packages/prewikka/IDMEFDatabase.py", line
429, in deleteAlert
    preludedb_delete_alert_from_list(self._db, list(identlst))
PreludeDBError: The total number of locks exceeds the lock table size


-- 
Adjete Wilson
Security Analyst
Omaha, NE


More information about the Prelude-user mailing list