A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=854 
====================================================================== 
Reported By:                simonlange
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   854
Category:                   Command-Line programs (dbmail-users, dbmail-util)
Reproducibility:            unable to reproduce
Severity:                   trivial
Priority:                   normal
Status:                     acknowledged
target:                      
====================================================================== 
Date Submitted:             20-Aug-10 13:03 CEST
Last Modified:              20-Aug-10 17:05 CEST
====================================================================== 
Summary:                    DBMAIL-UTIL DOES NOT FIX NULL MESSAGES
Description: 
Although already 2005 reported
http://www.mail-archive.com/dbm...@dbmail.org/msg06073.html

This bug is still there in dbmail 2.2.16

Usually dbmail-util should fix them but instead it just sets status to 6
of each message. Status 6 is not recognized by any cleanup processes of
dbmail. Thats why null messages do stay in the database.

a manual sql statemente (delete) removes them and fixes the error.

this whole issues was discussed already in 2005 (5 years ago!)

wonder noone else stumbled over it the past 5 years.

Wharever, thats why i write this bug report.
====================================================================== 

---------------------------------------------------------------------- 
 (0003088) paul (administrator) - 20-Aug-10 14:26
 http://www.dbmail.org/mantis/view.php?id=854#c3088 
---------------------------------------------------------------------- 
Simon,

Took you long enough to file the bug then :-)

It seems to me that these null message are an indication of a problem that
arises elsewhere. I for one never see them, and they should not appear
under normal circumstances. 

There may be a problem with your schema, or you maybe using non-dbmail
tools to talk to and write into the dbmail database. 

---------------------------------------------------------------------- 
 (0003089) simonlange (reporter) - 20-Aug-10 17:05
 http://www.dbmail.org/mantis/view.php?id=854#c3089 
---------------------------------------------------------------------- 
Paul,

Its not MY schema. Its DBMAIL's schema. ;)
Im using only dbmail-tools.
its a fresh installation.
database' health is fine.

and the question is how it gets status6 if the util should remove nulls.
and why the heck the util does not remove them anyway? says repaired but
in fact it did nothing to remove them.

so? its def a bug.

my workaround i posted 5years ago still works. but its not the best way.
better the util handles this, not a manual sql-statement. ;)

regards 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
20-Aug-10 13:03  simonlange     New Issue                                    
20-Aug-10 14:26  paul           Note Added: 0003088                          
20-Aug-10 14:27  paul           Severity                 major => trivial    
20-Aug-10 14:27  paul           Reproducibility          always => unable to
reproduce
20-Aug-10 14:27  paul           Status                   new => acknowledged 
20-Aug-10 17:05  simonlange     Note Added: 0003089                          
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Reply via email to