bugtrack at dbmail
Jul 30, 2009, 3:51 PM
Post #1 of 1
(898 views)
Permalink
|
|
[DBMail 0000772]: Database Error - value too long for type character varying(100) when insterting into dbmail_replycache
|
|
A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=772
======================================================================
Reported By: yavo
Assigned To: paul
======================================================================
Project: DBMail
Issue ID: 772
Category: Database layer
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: feedback
target:
======================================================================
Date Submitted: 25-Feb-09 15:34 CET
Last Modified: 31-Jul-09 00:51 CEST
======================================================================
Summary: Database Error - value too long for type character
varying(100) when insterting into dbmail_replycache
Description:
I get the above message in my postgres logs when an auto reply is sent.
ERROR: value too long for type character varying(100)
STATEMENT: INSERT INTO dbmail_replycache (to_addr, from_addr, handle,
lastseen) VALUES('email [at] example','email [at] example','Text longer than
100 characters', CURRENT_TIMESTAMP)
======================================================================
----------------------------------------------------------------------
(0002796) yavo (reporter) - 25-Feb-09 15:40
http://www.dbmail.org/mantis/view.php?id=772#c2796
----------------------------------------------------------------------
After inspecting my database, this seems to have been introduced by
upgrading to 2.2.11
Before a random hash was being placed in the handle, now it appears that
the email body is placed there.
----------------------------------------------------------------------
(0002811) paul (administrator) - 08-Mar-09 17:31
http://www.dbmail.org/mantis/view.php?id=772#c2811
----------------------------------------------------------------------
The 'hash' is not random, but a md5 hash of the combined
messagebody+subject. It could also be determined by the sieve script.
If you can please post a level=5 trace of a delivery that leads to the
mentioned failure, and plz include the sieve script involved.
----------------------------------------------------------------------
(0002889) netvulture (developer) - 31-Jul-09 00:51
http://www.dbmail.org/mantis/view.php?id=772#c2889
----------------------------------------------------------------------
I have a patch for 2.3.x that addresses this. Will need to backport to
2.2.x
Issue History
Date Modified Username Field Change
======================================================================
25-Feb-09 15:34 yavo New Issue
25-Feb-09 15:40 yavo Note Added: 0002796
08-Mar-09 17:31 paul Note Added: 0002811
08-Mar-09 17:31 paul Assigned To => paul
08-Mar-09 17:31 paul Status new => feedback
31-Jul-09 00:51 netvulture Issue Monitored: netvulture
31-Jul-09 00:51 netvulture Note Added: 0002889
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
|
