SQL error with 6.beta
Posted: Thu Oct 15, 2009 5:21 pm
Hi,
I freshly installed the 6.beta on my suse machine with java 1.6_14, mysql 5.0.67 and 20M of sortbuffersize. On the clean database I imported the shipped openemm-6.beta.sql (Hope that was the right one). Openemm starts properly. I can create mailing lists. But when I try to open the mailing overview I get the following error: Please help.
Thanks,
Jan
[/code]
I freshly installed the 6.beta on my suse machine with java 1.6_14, mysql 5.0.67 and 20M of sortbuffersize. On the clean database I imported the shipped openemm-6.beta.sql (Hope that was the right one). Openemm starts properly. I can create mailing lists. But when I try to open the mailing overview I get the following error: Please help.
Thanks,
Jan
Code: Select all
18:14:27,217 ERROR agnitas:284 - getMailingList: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLEx
ception for SQL [select count(*) from ( SELECT *, case when senddate is null then 0 else 1 end as send_null FROM ( SELECT a.mailing_id , a.shortname , a.description , min(c.
change_date) senddate, m.shortname mailinglist FROM (mailing_tbl a LEFT JOIN mailing_account_tbl c ON (a.mailing_id=c.mailing_id AND c.status_field='W')) LEFT JOIN mailinglist_
tbl m ON ( a.mailinglist_id=m.mailinglist_id AND a.company_id=m.company_id) WHERE a.company_id = 1 AND a.deleted<>1 AND a.is_template=0 AND mailing_type in (0) GROUP BY a.
mailing_id, a.shortname, a.description, m.shortname ) openemm ORDER BY send_null ASC, senddate DESC, mailing_id DESC ) agn]; SQL state [HY001]; error code [1038]; Out of sort mem
ory; increase server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory; increase server sort buffer size
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
java.util.concurrent.FutureTask.get(FutureTask.java:83)
org.agnitas.web.MailingBaseAction.execute(MailingBaseAction.java:271)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:115)