In some email I received from "Jesse Norell" <[EMAIL PROTECTED]> on Tue, 10 Jun 2003 09:07:06 -0600 (MDT), wrote:
> This would make things like the "message inserted, but not yet > filtered" race condition Aaron was going to have to address a while > back easy - just insert all messages with status = 4, do whatever > processing, and update to 2 when the message is fully processed. > It would fix a race condition in the current insertion code where a > message actually changes unique_id and another where the messages > table entry exists, but messageblk entries do not yet (ie. if > messages entry was inserted, then a user checks POP3 before > messageblk is inserted, it'll hang OE waiting for data, till a > timeout period, then error). That can be fixed if we wrap it inside a transaction? except that it wont be that portable. One small thing I noticed some time ago in PgSQL part of dbmail, PQstatus() doesnt return the correct value. Basically if the daemon is dead (by some odd circumstances) __auth_query() will fail not giving the right reason, it will say "Connection ok" and it will send over the query over the dead socket, and when the query actually failes (not the db connection check) it would do the same thing again and again, until the db's is up again. have anyone noticed this? Jesse, I'm reading the UUID rfc which looks good, so i think this might be the right track to go :) Anyway I was going to add the FreeBSD part in the autoconf file but as much as i hate macro langs :P i didnt find time for it, hope I'll be able to do it sometimes in the future if someone havent done it before me:) cheers.
