paul at nfg
Apr 25, 2008, 2:02 AM
Post #3 of 4
(209 views)
Permalink
|
Marc Dirix wrote:
> Any thoughts about this?
where is the log from the query that is actually causing the aborted transaction?
The only cache fields that would be affected by very long To headers would be
_headervalue.headervalue and _envelope.envelope, but I'm guessing since the logs
are incomplete.
But the _envelope.envelope field doesn't have an index, and
_headervalue.headervalue only has a partial index on the first 255 chars.
So what is going on here?
>
> On Tue, Apr 22, 2008 at 04:41:41PM +0200, Marc Dirix wrote:
>> Hi,
>>
>> Today I found this error in my log:
>> (dbmail 2.2.10).
>>
>> [.ERROR: index row size 4504 exceeds btree maximum, 2712 HINT: Values
>> larger than 1/3 of a buffer page cannot be indexed. Consider a function
>> index of an MD5 hash of the value, or use full text indexing. ]
>> Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[message]
>> dbmail-message.c,_header_cache(+1038): insert headervalue failed
>> Apr 22 11:55:37 gamma dbmail/lmtpd[7004]: Error:[sql]
>> dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_tofield
>> (physmessage_id, toname, toaddr) VALUES
>> (145324,'Bauws-Dettmann','scrambled[at]t-online.de')] : [.ERROR:
>> current transaction is aborted, commands ignored until end of
>> transaction block ]
>>
>> The message seems to have a lott of emailaddressess in the "TO" field.
>> I think dbmail should check size of the field before inserting?
>>
>>
>> Marc
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmail[at]dbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
