A BUGNOTE has been added to this bug.
======================================================================
http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000091
======================================================================
Reported By: xing
Assigned To:
======================================================================
Project: DBMail
Bug ID: 91
Category: Database layer
Reproducibility: N/A
Severity: major
Priority: normal
Status: new
======================================================================
Date Submitted: 15-Sep-04 20:33 CEST
Last Modified: 15-Sep-04 20:42 CEST
======================================================================
Summary: Possible infinite loop within either POP3/IMAP
code,
Description:
I noticed my dbmail server's mysql CPU avergaing 75%+ which is out of the
normal by a landslide. After investigation I noticed a infinite loop type
query sent from likely the DBMAIL pop3/imap process by looking at the db
login name and query.
The following mysql query is executed in a infinite loop by a dbmail
process (again I don't know which one).
----------------------------
UPDATE messages set
status=17794368026245745520 WHERE message_idnr=17794367648288623384 AND
status<2
----------------------------
======================================================================
----------------------------------------------------------------------
xing - 15-Sep-04 20:42 CEST
----------------------------------------------------------------------
Confirmed dbmail POP3 daemon as the origin of the queries.
Killing all imapd processes had no effect.
Killing all pop3d processes stopped the infinite loop query.
Bug History
Date Modified Username Field Change
======================================================================
15-Sep-04 20:33xing New Bug
15-Sep-04 20:42xing Bugnote Added: 0000264
======================================================================
