Hey guys, So I finally upgraded from 3.9.0-alpha2 to 3.9.1-RC1 and made some basic changes to my configuration:
- Changed my user to TEFT mode from TOE, enabled quarantine - Installed required Perl modules for quarantine to function properly (HTML::Entities) I also applied the latin1 conversions to my backend MySQL database as recommended in the upgrade notes. Now I'm hitting a bizarre issue... Yesterday, I noticed that the web interface was periodically unavailable due to excessive database connections. Further review of MySQL showed that dspam had established over 94 connections in a span of less than 10 minutes and effectively stopped working. My first workaround for this was to drop the MySQLConnectionCache value from 10 to 2. This slowed the issue, but ultimately I ended up altering the MySQL "wait_timeout" global var from 28800 sec to 300 sec. This mitigated the connection issues and all seemed well. This morning I check my server and find there are no longer excessive MySQL connections, however, there were 1,924 running dspam processes (!). I have absolutely no idea where to go from here. System details below: --------- ./configure --with-storage-driver=mysql_drv --enable-virtual-users --enable-preferences-extension --enable-daemon --with-mysql-includes=/usr/include/mysql --enable-syslog --enable-long-usernames --enable-debug --------- # mysql -V mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0 --------- Home /usr/local/var/dspam StorageDriver /usr/local/lib/dspam/libmysql_drv.so TrustedDeliveryAgent "/usr/bin/procmail" DeliveryHost 127.0.0.1 DeliveryPort 10026 DeliveryIdent localhost DeliveryProto SMTP OnFail error Trust root Trust dspam Trust apache Trust mail Trust mailnull Trust smmsp Trust daemon TrainingMode teft TestConditionalTraining on Feature whitelist Algorithm graham burton Tokenizer chain PValue bcr WebStats on Preference "spamAction=tag" Preference "signatureLocation=headers" # 'message' or 'headers' Preference "showFactors=on" Preference "spamSubject=[SPAM]" AllowOverride trainingMode AllowOverride spamAction spamSubject AllowOverride statisticalSedation AllowOverride enableBNR AllowOverride enableWhitelist AllowOverride signatureLocation AllowOverride showFactors AllowOverride optIn optOut AllowOverride whitelistThreshold MySQLServer /var/lib/mysql/mysql.sock MySQLPort MySQLUser herpaderp MySQLPass derpaderpaderp MySQLDb vmail_dspam MySQLCompress true MySQLConnectionCache 2 HashRecMax 98317 HashAutoExtend on HashMaxExtents 0 HashExtentSize 49157 HashPctIncrease 10 HashMaxSeek 10 HashConnectionCache 10 Notifications on PurgeSignatures 14 # Stale signatures PurgeNeutral 90 # Tokens with neutralish probabilities PurgeUnused 90 # Unused tokens PurgeHapaxes 30 # Tokens with less than 5 hits (hapaxes) PurgeHits1S 15 # Tokens with only 1 spam hit PurgeHits1I 15 # Tokens with only 1 innocent hit LocalMX 127.0.0.1 SystemLog on UserLog on Opt out ServerPID /var/run/dspam.pid ServerMode auto ServerParameters "--deliver=innocent" ServerIdent "uki.flargen.com" ServerDomainSocketPath "/tmp/dspam.sock" ProcessorURLContext on ProcessorBias on StripRcptDomain off --------- Any tips or thoughts would be greatly appreciated. Version 3.9.0-alpha2 had no such issues and had been running for up to a year at a time without a restart or a problem. Same build options were used when building 3.9.1-RC1. My current band-aid is a cron job running every 5 minutes to kill and re-launch dspam. Thanks guys! Campbell ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
