Re: Data too long for column 'envelope'
Paul J Stevens <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Harry,
did you change that column? It should be a TEXT column which means
it's width is 64KB.
If you didn't, it might be an idea to reject messages whose envelope
exceeds a certain length.
On 28-11-14 22:38, Reindl Harald wrote:
> can this please get fixed by just truncate the envelope data to
> the filed length or bounce that damned messages at LMTP level? :-(
>
> Nov 28 22:35:34 mail dbmail/maintenance[1862]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:34 mail
> dbmail/maintenance[1862]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:35 mail
> dbmail/maintenance[1875]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:35 mail
> dbmail/maintenance[1875]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:37 mail
> dbmail/maintenance[1879]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:37 mail
> dbmail/maintenance[1879]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:41 mail
> dbmail/maintenance[1896]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:41 mail
> dbmail/maintenance[1896]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:43 mail
> dbmail/maintenance[1899]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:43 mail
> dbmail/maintenance[1899]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline - Nov 28 22:35:44 mail
> dbmail/maintenance[1902]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Data too long
> for column 'envelope' at row 1 Nov 28 22:35:44 mail
> dbmail/maintenance[1902]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed
> [("Fri, 21 Nov 2014 15:55:30 +0000" "Free Application for Federal
> Student Aid (FAFSA) Deadline -
>
>
>
> _______________________________________________ DBmail mailing
> list [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
- --
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, github, linkedin
www.nfg.nl/[email protected]/+31.85.877.99.97
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iEYEARECAAYFAlSf6OEACgkQ8iITvBH4zTFcLgCdEW47vaj7nktEhWQxXgTPHlye
cI8An3mg0cLukBczhc52roqaSxM9ndVa
=Sq6j
-----END PGP SIGNATURE-----