On Tue, 08 Feb 2011 15:08:48 +0000, Hugo Monteiro <hugo.monte...@fct.unl.pt> wrote: > On 02/08/2011 02:29 PM, Campbell Krueger wrote: >> 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 >> > > > Hello Campbell, > > Do you get any messages get any error messages telling you about corrupt > tables? I had an issue like that a while ago and it turned out to be > corrupt indexes. > Try repairing the database tables. > > Regards, > > Hugo Monteiro. > >
Hugo, Thanks for the reply! Sadly enough, no database/table corruption issues have been reported in any logs. Looks like mysqlcheck came back clean as well: [root@uki log]# mysqlcheck vmail_dspam vmail_dspam.dspam_preferences OK vmail_dspam.dspam_signature_data OK vmail_dspam.dspam_stats OK vmail_dspam.dspam_token_data OK vmail_dspam.dspam_virtual_uids OK Any other tips? 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
