Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. DBMail>
  3. users
what's going on here?
abrancatelli at schema31
Jul 22, 2014, 3:29 AM
Post #1 of 3 (1688 views)
Permalink
Hello, can anybody help me with this output from dbmail-util -ay ?

Dbmail is 3.1.13

Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message] dbmail_message_cache_envelope(+1919): SQLException: Data too long for column 'envelope' at row 1
Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message] dbmail_message_cache_envelope(+1921): insert envelope failed [.("Wed, 25 Jun 2014 11:20:40 +0200" "Le notizie dal mondo della scuola" (("Scuola" NIL "scuola” “xxxx.xxx")) (("Scuola" NIL "scuola" "xxxx.xxx")) (("Scuola" NIL "scuola" "xxxx.xxx")) NIL ((“Xxxxx Xxxxx" NIL “xxxxx" "xxxx.xxx")("xxxx.xxx" NIL "xxxxx" "xxxx.xxx")(“xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx" NIL "xxxxx" "xxxx.xxx")("zanin_g@camera
.....Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+370): SQLException: Table 'dbmail.dbmail_messageblks' doesn't exist
Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+371): failed query [.SELECT b.messageblk, b.is_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id = 8201117 ORDER BY b.messageblk_idnr]

I blanked out the mail addresses bit they are all valid.
I’m worried both by the data to long and by the dbmail_messageblks doesn’t exist… ?

-------
Andrea Brancatelli

Attached Files:

Re: what's going on here? [ In reply to ]
h.reindl at thelounge
Jul 22, 2014, 3:35 AM
Post #2 of 3 (1667 views)
Permalink
Am 22.07.2014 12:29, schrieb Andrea Brancatelli:
> Hello, can anybody help me with this output from dbmail-util -ay ?
>
> Dbmail is 3.1.13

Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
dbmail_message_cache_envelope(+1919): SQLException: Data too long for column 'envelope' at row 1

is because a broken message, i have that also from time to time
and would like to truncate that cache data or at least have
the messageid without debug logging in the errormsg to kill
the related mail - IMHO a cosmetic bug

"dbmail_messageblks" is for sure a bug because 3.1.x should be
happy after the migration from 2.x that this table don't exist
because it's no longer needed

> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
> dbmail_message_cache_envelope(+1919): SQLException: Data too long for column 'envelope' at row 1
> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
> dbmail_message_cache_envelope(+1921): insert envelope failed [.("Wed, 25 Jun 2014 11:20:40 +0200" "Le notizie dal
> mondo della scuola" (("Scuola" NIL "scuola” “xxxx.xxx")) (("Scuola" NIL "scuola" "xxxx.xxx")) (("Scuola" NIL
> "scuola" "xxxx.xxx")) NIL ((“Xxxxx Xxxxx" NIL “xxxxx" "xxxx.xxx")("xxxx.xxx" NIL "xxxxx"
> "xxxx.xxx")(“xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("zanin_g@camera
> ....Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+370): SQLException:
> Table 'dbmail.dbmail_messageblks' doesn't exist
> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+371): failed query [SELECT
> b.messageblk, b.is <http://b.is>_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM
> dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id = 8201117 ORDER BY
> b.messageblk_idnr]
>
> I blanked out the mail addresses bit they are all valid.
> I’m worried both by the data to long and by the dbmail_messageblks doesn’t exist… ?

Attached Files:

Re: what's going on here? [ In reply to ]
abrancatelli at schema31
Aug 8, 2014, 2:54 PM
Post #3 of 3 (1640 views)
Permalink
Hello Harald

I tried to change the data type for envelope from text to longtext and the error with the insert obviously disappeared.

Now I'm wondering if such change can give problem to dbmail itself ... Maybe with any struct that allocates a fixed length for the envelope... ?

Sent from my iPad

> On 22/lug/2014, at 12:35, Reindl Harald <h.reindl@thelounge.net> wrote:
>
>
>
> Am 22.07.2014 12:29, schrieb Andrea Brancatelli:
>> Hello, can anybody help me with this output from dbmail-util -ay ?
>>
>> Dbmail is 3.1.13
>
> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
> dbmail_message_cache_envelope(+1919): SQLException: Data too long for column 'envelope' at row 1
>
> is because a broken message, i have that also from time to time
> and would like to truncate that cache data or at least have
> the messageid without debug logging in the errormsg to kill
> the related mail - IMHO a cosmetic bug
>
> "dbmail_messageblks" is for sure a bug because 3.1.x should be
> happy after the migration from 2.x that this table don't exist
> because it's no longer needed
>
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
>> dbmail_message_cache_envelope(+1919): SQLException: Data too long for column 'envelope' at row 1
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[message]
>> dbmail_message_cache_envelope(+1921): insert envelope failed [.("Wed, 25 Jun 2014 11:20:40 +0200" "Le notizie dal
>> mondo della scuola" (("Scuola" NIL "scuola” “xxxx.xxx")) (("Scuola" NIL "scuola" "xxxx.xxx")) (("Scuola" NIL
>> "scuola" "xxxx.xxx")) NIL ((“Xxxxx Xxxxx" NIL “xxxxx" "xxxx.xxx")("xxxx.xxx" NIL "xxxxx"
>> "xxxx.xxx")(“xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
>> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
>> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
>> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx"
>> "xxxx.xxx")("xxxxx@xxxxx.xxx <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("xxxxx@xxxxx.xxx
>> <mailto:xxxxx@xxxxx.xxx>" NIL "xxxxx" "xxxx.xxx")("zanin_g@camera
>> ....Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+370): SQLException:
>> Table 'dbmail.dbmail_messageblks' doesn't exist
>> Jul 22 11:49:44 rubidio.roma.sc dbmail-util[38004]: [0x805029a10] Error:[db] db_query(+371): failed query [SELECT
>> b.messageblk, b.is <http://b.is>_header, DATE_FORMAT(p.internal_date, GET_FORMAT(DATETIME,'ISO')) FROM
>> dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id = 8201117 ORDER BY
>> b.messageblk_idnr]
>>
>> I blanked out the mail addresses bit they are all valid.
>> I’m worried both by the data to long and by the dbmail_messageblks doesn’t exist… ?
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal