Hello All,

I'm at a loss and all I can come up with is this:

last pid: 70373; load averages: 4.32, 3.48, 3.53

up 33+19:31:48 09:32:36
148 processes: 26 running, 122 sleeping
CPU states: 5.6% user, 0.0% nice, 94.0% system, 0.2% interrupt, 0.2% idle
Mem: 125M Active, 262M Inact, 67M Wired, 19M Cache, 61M Buf, 28M Free
Swap: 512M Total, 512M Free


PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
93447 www 18 0 15384K 13288K lockf 1 3:06 2.20% 2.20% httpd
68988 vpopmail 56 0 1376K 944K RUN 1 0:00 17.94% 1.71% vdelivermai
62048 vpopmail 55 0 1376K 944K RUN 1 0:00 14.86% 1.42% vdelivermai
65547 vpopmail 54 0 1376K 944K RUN 1 0:00 14.86% 1.42% vdelivermai
68537 vpopmail 55 0 1376K 944K RUN 1 0:00 14.86% 1.42% vdelivermai
69065 vpopmail 53 0 1376K 944K RUN 1 0:00 10.25% 0.98% vdelivermai
68932 vpopmail 53 0 1372K 940K RUN 0 0:00 9.74% 0.93% vdelivermai
68634 vpopmail 53 0 1372K 940K RUN 0 0:00 7.69% 0.73% vdelivermai
65358 vpopmail 52 0 1372K 940K RUN 0 0:00 7.18% 0.68% vdelivermai
68423 vpopmail 52 0 1372K 940K RUN 0 0:00 6.66% 0.63% vdelivermai
69546 vpopmail 53 0 1372K 940K RUN 1 0:00 6.66% 0.63% vdelivermai
69565 vpopmail 53 0 1372K 940K RUN 0 0:00 6.66% 0.63% vdelivermai
68777 vpopmail 52 0 1372K 940K RUN 0 0:00 6.15% 0.59% vdelivermai
69294 vpopmail 52 0 1372K 940K RUN 0 0:00 6.15% 0.59% vdelivermai
68841 vpopmail 52 0 1372K 940K RUN 0 0:00 5.64% 0.54% vdelivermai
70020 vpopmail 52 0 1372K 940K RUN 1 0:00 5.64% 0.54% vdelivermai
70316 vpopmail 53 0 1372K 940K RUN 1 0:00 5.13% 0.49% vdelivermai
70342 vpopmail 52 0 1372K 940K RUN 0 0:00 5.13% 0.49% vdelivermai
70136 vpopmail 52 0 1372K 940K RUN 0 0:00 4.61% 0.44% vdelivermai
70139 vpopmail 52 0 1372K 940K RUN 1 0:00 3.59% 0.34% vdelivermai
68330 vpopmail 51 0 1372K 940K RUN 0 0:00 3.08% 0.29% vdelivermai



This is a snapshot from top as I'm trying to send an email to a local ezmlm list that goes to about 50 local people.


I get 50 vdelivermails (which is fine) but they are all slow to deliver.

I've had this server for almost a year (dual 933's 512Ecc U160 drives) and it does nothing but qmail+vpopmail and a webmail client.

I have clam antivirus and spamassassin which I'm calling through qmail-scanner.

this is my tcp.rules file:

127.0.0.:allow,RELAYCLIENT="",RBLSMTPD="",QMAILQUEUE="/var/qmail/bin/qmail-scanner-queue"
192.168.1.:allow,RELAYCLIENT="",RBLSMTPD="",QMAILQUEUE="/var/qmail/bin/qmail-scanner-queue"

:allow,QMAILQUEUE="/var/qmail/bin/qmail-scanner-queue"

I'm using qmail-scanner 1.21 compiled by hand with this configure statement:

./configure  \
--admin postmaster  \
--add-dscr-hdrs yes \
--domain poklib.org \
--log-details syslog \
--skip-text-msgs yes \
--scanners clamdscan,verbose_spamassassin \
--notify sender \
--debug no \
--unzip yes \
--batch \
--install


and yesterday I was getting intermittent errors like this:


2004-04-06 09:28:48.197123500 delivery 19551: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 09:28:48.211717500 delivery 19534: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 09:28:48.232450500 delivery 19544: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/



and even after just restarting it all:


2004-04-06 11:20:58.672465500 delivery 637: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 11:20:58.675404500 delivery 620: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 12:42:10.905863500 delivery 18: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/


but so far today things have been ok.. except that vdeliver mail is *so* high..

2004-04-07 09:41:06.857760500 delivery 956: success: did_0+0+1/

This is on a FreeBSD 4.9-p3 system ( I know I have to patch to p4 )

vpopmail-5.4.0 and mysql 3.23.57 (compiled for freebsd 4.8)

Uptime: 23 hours 32 min 43 sec
Threads: 3 Questions: 18086 Slow queries: 0 Opens: 19 Flush tables: 1 Open tables: 13 Queries per second avg: 0.213


TIA

- Brian

Reply via email to