On Thu, Jul 30, 2009 at 9:44 PM, Nathan M<locu.li...@gmail.com> wrote:
> 'ins_quar' =>
> 'INSERT INTO quarantine (partition_tagBREAKME, mail_id,
> chunk_ind, mail_text)'.
> ' VALUES (?,?,?,?)',
>
One tiny edit here. In testing this worked fine; however, the above
change does no good when I'm really doing maintenance because as the
quarantine table gets locked during maintenance all INSERTs, even if
invalid (like above), still lock the full timeout before giving up.
Here's what it needs to be modified to to get around that so it never
hits the lock. Just giving it a non-existent table to insert into
works far better.
'ins_quar' =>
'INSERT INTO quarantineBREAKME (partition_tag, mail_id,
chunk_ind, mail_text)'.
' VALUES (?,?,?,?)',
Hopefully this will help somebody else if they ever have to update a
very large quarantine table someday. =)
- N
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
