> > The company I work for has dbmail running on duel processor SuSE amd64 > > machines. For the most part we have had great success with dbmail, but > > every once in a great while it seems as if there is something that > > pushes dbmail to 100% of one of the processors completely blocking it. > > Yes I had that once too, dbmail queried the database in an endless loop.
Great I can respond to myself. I got that loop with current cvs now. These queries ran: SELECT message_idnr FROM messages WHERE mailbox_idnr = '30' AND status<2 AND unique_id!='' AND deleted_flag=0 -- the following two queries repeated with changing ids SELECT messageblk FROM messageblks WHERE physmessage_id = '67895' ORDER BY messageblk_idnr SELECT physmessage_id FROM messages WHERE message_idnr = '76181' mailbox_idnr 30 is a subfolder below INBOX so that must have happend when the user opened the folder I think. Unfortunately I have no logs. Thomas -- http://www.tmueller.com for pgp key (95702B3B)
