Mailing List Archive

Data too long for column 'envelope' at row 1
Hi

may i suggest to trim or ignore such horrible data

currently i try to find out the physmessage-id from the debuglogs
to kill that message at all because it leads to errors each time
dbmail-util is running

dbmail-util[25875]: [0x7f96ed4fe200] Error:[message] dbmail_message_cache_envelope(+1922): SQLException: Data too
long for column 'envelope' at row 1
_________________

i guess 4283027 is the physmessage_id

dbmail-util[25875]: [0x7f96ed4fe200] Database:[db] db_stmt_prepare(+419): [0x7f96ed4fea00] [INSERT INTO
dbmail_envelope (physmessage_id, envelope) VALUES (?,?)]
[0x7f96ed4fe200] Database:[db] db_stmt_set_u64(+439): [0x7f96ed537bd0] 1:[4283027]
Re: Data too long for column 'envelope' at row 1 [ In reply to ]
Reindl,

The envelope field is a TEXT, do you have it like that or you have it as a varchar?

> -----Original Message-----
> From: dbmail-bounces@dbmail.org [mailto:dbmail-bounces@dbmail.org] On
> Behalf Of Reindl Harald
> Sent: segunda-feira, 16 de Junho de 2014 12:16
> To: Mailing-List dbmail
> Subject: [Dbmail] Data too long for column 'envelope' at row 1
>
> Hi
>
> may i suggest to trim or ignore such horrible data
>
> currently i try to find out the physmessage-id from the debuglogs to
> kill that message at all because it leads to errors each time dbmail-
> util is running
>
> dbmail-util[25875]: [0x7f96ed4fe200] Error:[message]
> dbmail_message_cache_envelope(+1922): SQLException: Data too long for
> column 'envelope' at row 1 _________________
>
> i guess 4283027 is the physmessage_id
>
> dbmail-util[25875]: [0x7f96ed4fe200] Database:[db]
> db_stmt_prepare(+419): [0x7f96ed4fea00] [INSERT INTO dbmail_envelope
> (physmessage_id, envelope) VALUES (?,?)] [0x7f96ed4fe200] Database:[db]
> db_stmt_set_u64(+439): [0x7f96ed537bd0] 1:[4283027]


_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: Data too long for column 'envelope' at row 1 [ In reply to ]
it is a TEXT field, the message was obviously crap
but it's annyoing trace the message from the debug
logs and kill the records manually

maybe dbmail-util could have a CLI switch to allow
automatic kill of such messages which can't be cached
and producing ongoing errors

MariaDB [dbmail]> show fields from dbmail_envelope;
+----------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+----------------+
| physmessage_id | bigint(20) unsigned | NO | UNI | 0 | |
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| envelope | text | NO | | NULL | |
+----------------+---------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

Am 16.06.2014 13:24, schrieb Jorge Bastos:
> Reindl,
>
> The envelope field is a TEXT, do you have it like that or you have it as a varchar?
>
>> -----Original Message-----
>> From: dbmail-bounces@dbmail.org [mailto:dbmail-bounces@dbmail.org] On
>> Behalf Of Reindl Harald
>> Sent: segunda-feira, 16 de Junho de 2014 12:16
>> To: Mailing-List dbmail
>> Subject: [Dbmail] Data too long for column 'envelope' at row 1
>>
>> Hi
>>
>> may i suggest to trim or ignore such horrible data
>>
>> currently i try to find out the physmessage-id from the debuglogs to
>> kill that message at all because it leads to errors each time dbmail-
>> util is running
>>
>> dbmail-util[25875]: [0x7f96ed4fe200] Error:[message]
>> dbmail_message_cache_envelope(+1922): SQLException: Data too long for
>> column 'envelope' at row 1 _________________
>>
>> i guess 4283027 is the physmessage_id
>>
>> dbmail-util[25875]: [0x7f96ed4fe200] Database:[db]
>> db_stmt_prepare(+419): [0x7f96ed4fea00] [INSERT INTO dbmail_envelope
>> (physmessage_id, envelope) VALUES (?,?)] [0x7f96ed4fe200] Database:[db]
>> db_stmt_set_u64(+439): [0x7f96ed537bd0] 1:[4283027]