Re: [AMaViS-user] amavis corrupt db

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

This triggered me in your logfile: "The table 'quarantine' is full"
Google it and you'll find:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html

Regards,
Alrik

On Thu, Apr 29, 2010 at 12:25 AM, troxlinux <xse...@gm...> wrote:

> Hi list, I want to comment something very strange, configure a new
> server with amavisd-new 2.6.4 and mysql with mailzu, all well for a
> couple of days, then I see that some messages didn't come out and the
> server sent error in the chart msg of amavisd-new
>
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) SEND via SQL
> (DBI:mysql:database=amavisd_db;host=127.0.0.1;port=3306):
> <ja...@se...> ->
> <cg...@mi...>,<sp...@mi...>, mail_id 50035po2-Vo4
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) _WARN: [32470]
> Amavis::IO::SQL::close error: Error closing, flush: sql inserting text
> failed, sql exec: err=1114, HY000, DBD::mysql::st execute failed: The
> table 'quarantine' is full at (eval 110) line 166, <GEN14> line
> 144717. at (eval 112) line 250, <GEN14> line 144717. at (eval 112)
> line 113, <GEN14> line 144717. at (eval 112) line 88, <GEN14> line
> 144717.
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) writing mail text
> to SQL failed: print: sql inserting mail text failed, sql exec:
> err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine'
> is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112)
> line 286, <GEN14> line 144717.
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) mail_via_sql: rollback
> done
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!!)TROUBLE in
> check_mail: quar+notif FAILED: temporarily unable to quarantine: 451
> 4.5.0 Storing to sql db as mail_id 50035po2-Vo4 failed: writing mail
> text to SQL failed: print: sql inserting mail text failed, sql exec:
> err=1114, HY000, DBD::mysql::st execute failed: The table 'quarantine'
> is full at (eval 110) line 166, <GEN14> line 144717. at (eval 112)
> line 286, <GEN14> line 144717. at (eval 112) line 387, <GEN14> line
> 144717., id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> line
> 144717.
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) (!)PRESERVING
> EVIDENCE in /var/spool/amavis/tmp/amavis-20100428T105045-32470
> Apr 28 12:21:46 lentesnic amavis[32470]: (32470-16) TIMING [total 347
> ms] - SMTP greeting: 1 (0%)0, SMTP LHLO: 0 (0%)0, SMTP pre-MAIL: 0
> (0%)1, lookup_sql: 2 (0%)1, lookup_sql: 1 (0%)1, SMTP pre-DATA-flush:
> 1 (0%)1, SMTP DATA: 86 (25%)26, check_init: 0 (0%)26, digest_hdr: 1
> (0%)27, digest_body_dkim: 9 (3%)29, sql-enter: 113 (33%)62,
> mime_decode: 61 (18%)79, get-file-type3: 10 (3%)82, parts_decode: 0
> (0%)82, check_header: 1 (0%)83, AV-scan-1: 9 (3%)85, spam-wb-list: 2
> (1%)86, update_cache: 1 (0%)86, decide_mail_destiny: 1 (0%)86,
> notif-quar: 2 (0%)87, write-header: 2 (1%)88, fwd-sql: 38 (11%)99,
> SMTP pre-response: 1 (0%)99, SMTP response: 3 (1%)100, rundown: 1
> (0%)100
> Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A:
> to=<cg...@mi...>, relay=127.0.0.1[127.0.0.1]:10024,
> delay=529, delays=529/0.01/0/0.34, dsn=4.5.0, status=deferred (host
> 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16,
> quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing
> to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL
> failed: print: sql inserting mail text failed, sql exec: err=1114,
> HY000, DBD::mysql::st execute failed: The table 'quarantine' is full
> at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286,
> <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717.,
> id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e
> 144717. (in reply to end of DATA command))
> Apr 28 12:21:46 lentesnic postfix/lmtp[1851]: 3E2E677A07A:
> to=<sp...@mi...>, relay=127.0.0.1[127.0.0.1]:10024,
> delay=529, delays=529/0.01/0/0.48, dsn=4.5.0, status=deferred (host
> 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=32470-16,
> quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing
> to sql db as mail_id 50035po2-Vo4 failed: writing mail text to SQL
> failed: print: sql inserting mail text failed, sql exec: err=1114,
> HY000, DBD::mysql::st execute failed: The table 'quarantine' is full
> at (eval 110) line 166, <GEN14> line 144717. at (eval 112) line 286,
> <GEN14> line 144717. at (eval 112) line 387, <GEN14> line 144717.,
> id=32470-16 at /usr/sbin/amavisd line 12613, <GEN14> lin 451 4.5.0 e
> 144717. (in reply to end of DATA command))
> Apr 28 12:21:53 lentesnic postfix/smtpd[1770]: connect from
> ppp-203-225.21-151.libero.it[151.21.225.203]
>
> I check mysql, postfix, amavisd-new and all these services are running
> well , somebody in the list that wants to shake hands me with this
> problem, for my this problem is ignored
>
> regardss
>
>
> --
> rickygm
>
> http://gnuforever.homelinux.com
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> AMaViS-user mailing list
> AMa...@li...
> https://lists.sourceforge.net/lists/listinfo/amavis-user
>  AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
>  AMaViS-HowTos:http://www.amavis.org/howto/
>