[Mailzu-users] amavis corrupt db with mailzu

[troxlinux <xse...@gm...>]

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