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','[EMAIL PROTECTED]')] : [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 >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > DBmail mailing list > [email protected] > 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 [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
