Tomcat goes wild when sending mails

[mokarram]

Hi All,

When I send a large mailing, after some time the tomcat server goes down and my subscribers can't click on any link.
The catalina.out file has the following entry:

Code: Select all

SEVERE: The web application [/openemm] appears to have started a thread named [MySQL Statement Cancellation Timer] but has failed to stop it. This is very likely to create a memory leak.

This happens only during mailing......

Any ideas would be greatly appreciated.

[unhuman]

I have also noticed these messages in the log. You could try increasing the amount of memory available to the JVM and see how that goes.

A quick google turns up many articles like:
http://stackoverflow.com/questions/2294 ... jvm-memory

Probably won't stop those messages, but I think those messages are a symptom of normal processing (and perhaps would require a restart over time) but probably coincidental to your issue.

-H

[mokarram]

Some more insight into the issue,

Basically, I cannot connect via Tomcat and the errors are somehow related to the redirection configuration on the actual openemm server. I have not yet tried to adjust the memory in JVM because my gut feeling is that this is something to do with the way the mysql database is generating urls....what do you think? My mailing was 36,000 divided in steps of 500 every 5 minutes.

I noticed a LOT of entires (5.7 Mb) in catalina.out, here is a section:

Code: Select all

Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select trackablel0_.url_id as url1_11_, trackablel0_.company_id as company2_11_, trackablel0_.mailing_id as mailing3_11_, trackablel0_.action_id as action4_11_, trackablel0_.measure_type as measure5_11_, trackablel0_.relevance as relevance11_, trackablel0_.shortname as shortname11_, trackablel0_.full_url as full8_11_ from rdir_url_tbl trackablel0_ where trackablel0_.url_id=? and trackablel0_.company_id=? 2012-02-15 07:13:40,455: ERROR [http-8080-10] org.agnitas - getDefaultValue: Can't find resource for bundle java.util.PropertyResourceBundle, key redirection.status Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? Hibernate: select company0_.company_id as company1_1_, company0_.creator_company_id as creator2_1_, company0_.shortname as shortname1_, company0_.description as descript4_1_, company0_.xor_key as xor5_1_, company0_.rdir_domain as rdir6_1_, company0_.mailloop_domain as mailloop7_1_, company0_.status as status1_, company0_.mailtracking as mailtrac9_1_, company0_.max_login_fails as max10_1_, company0_.login_block_time as login11_1_, company0_.uid_version as uid12_1_ from company_tbl company0_ where company0_.company_id=? 

[maschoff]

This is log output of the Hibernate O/R mapper framework - no reason to worry.

[mokarram]

Thanks for clearing that up.