created_partsdir FAILED

[HoUsECAt]

hi all...

great tutorial on virtual postfix tutorial ... it all works great and mail gets delivered and scanned ....

Only even now and then a message appears in mail.log and amavisd.log like:

Apr 14 10:09:57 adam amavisd-new[18705]: (18705-07) lookup_sql: 2013, Lost connection to MySQL server during query
Apr 14 10:09:57 adam amavisd-new[18705]: (18705-07) NOTICE: Disconnected from SQL server
Apr 14 10:09:57 adam amavisd-new[18705]: (18705-07) TROUBLE in check_mail: creating_partsdir FAILED: DBD::mysql::st execute failed: Lost connection to MySQL server during query at (eval 41) line 238, <GEN16> line 2855.
Apr 14 10:09:57 adam amavisd-new[18705]: (18705-07) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060413T084946-18705

this particular mail got in the mailq and when i requed it, it got delivered. Any ideas what this can be?

[falko]

You can tryto remove all the proxy: strings in /etc/postfix/main.cf, e.g. replace

virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf

with

virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf

and do the same for all other lines with proxy:
Restart Postfix afterwards.

[HoUsECAt]

thanks.. i wil test that... can you explain to me what proxy: does?

[falko]

If you use proxy:, then Postfix uses only one persistent MySQL connection; if you don't use it, Postfix creates a new connection everytime.

[HoUsECAt]

which can't hurt much in a small business server?

[falko]

Unless you're running a high-traffic mail server, it doesn't matter at all.

[HoUsECAt]

this morning i again saw the error message again

Apr 20 08:59:23 adam amavisd-new[2374]: (02374-04) lookup_sql: 2013, Lost connection to MySQL server during query
Apr 20 08:59:23 adam amavisd-new[2374]: (02374-04) NOTICE: Disconnected from SQL server
Apr 20 08:59:23 adam amavisd-new[2374]: (02374-04) TROUBLE in check_mail: creating_partsdir FAILED: DBD::mysql::st execute failed: Lost connection to MySQL adam during query at (eval 41) line 238, <GEN16> line 2833.
Apr 20 08:59:23 adam amavisd-new[2374]: (02374-04) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060419T160329-02374

this mail also appears in the mailq, and i have to requeue it.....

any ideas?

[falko]

Seems to be a problem with amavisd. Maybe a bug?

[HoUsECAt]

alright... thanks... i will go and try to gather some information with amavisd....

will keep you posted

[HoUsECAt]

i figured out a little bit what the cause is, I haven't got a very busy mailserver and it mostly happens in the night, due the 'inactivitiy' of amavisd it loses the connection to the database. When i restart amavisd it is solved.

so i can solve this by a cron restart of amavisd, but for now i'm happy as it is