[Dbmail-dev] [DBMail 0000772]: Database Error - value too long for type character varying(100) when insterting into dbmail_replycache
The following issue has been SUBMITTED.
==
http://www.dbmail.org/mantis/view.php?id=772
==
Reported By:yavo
Assigned To:
==
Project:DBMail
Issue ID: 772
Category: Database layer
Reproducibility:have not tried
Severity: minor
Priority: normal
Status: new
target:
==
Date Submitted: 25-Feb-09 15:34 CET
Last Modified: 25-Feb-09 15:34 CET
==
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('em...@example.com','em...@example.com','Text longer than
100 characters', CURRENT_TIMESTAMP)
==
Issue History
Date ModifiedUsername FieldChange
==
25-Feb-09 15:34 yavo New Issue
==
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
[Dbmail-dev] [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:
==
Project:DBMail
Issue ID: 772
Category: Database layer
Reproducibility:have not tried
Severity: minor
Priority: normal
Status: new
target:
==
Date Submitted: 25-Feb-09 15:34 CET
Last Modified: 25-Feb-09 15:40 CET
==
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('em...@example.com','em...@example.com','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.
Issue History
Date ModifiedUsername FieldChange
==
25-Feb-09 15:34 yavo New Issue
25-Feb-09 15:40 yavo Note Added: 0002796
==
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
[Dbmail-dev] [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('em...@example.com','em...@example.com','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 ModifiedUsername FieldChange
==
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@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
