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: [email protected] [mailto:[email protected]] 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]
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
