Hi,
We are working with Mantis v. 1.2.16 and we are having the problem that
when the users create/delete a new issue in Mantis they have to wait up to 1 min to get the control back.
I've chekced the threads on this but did not find a solution to my Problem. The table mantis_email_table is empty und the recipient list contains 10 users. We are not using the crontab (the variable $g_email_send_using_cronjob doesn't appear in the config file)
In the log I've noticed that the following lines:
15.09.2016 13:05 CEST filtering START NEW FILTER QUERY
15.09.2016 13:05 CEST filtering Simple Filter
15.09.2016 13:05 CEST filtering project_ids = @P61
15.09.2016 13:05 CEST filtering include sub-projects = 1
15.09.2016 13:05 CEST filtering Getting sub-projects for project id @P61
15.09.2016 13:05 CEST filtering project_ids after including sub-projects = @P61
15.09.2016 13:05 CEST filtering project_ids (with public/private access) = @P61
15.09.2016 13:05 CEST filtering project_ids (with public access) = @P
15.09.2016 13:05 CEST filtering project query = ( mantis_bug_table.project_id = 61 )
15.09.2016 13:05 CEST filtering no view_state query
15.09.2016 13:05 CEST filtering no reporter query
15.09.2016 13:05 CEST filtering handler query = ( mantis_bug_table.handler_id=0 )
15.09.2016 13:05 CEST filtering Join operator : AND
are repeated up to 10 times per second, forever. A restart of the Server as well as a restart of MySQL did not help.
Can anybody help on this?
Thanks in Advance
Paolo
Bad performance when creating an issue
Moderators: Developer, Contributor
Re: Bad performance when creating an issue
Hi atrol,
thank you for your reply.
It looks like disabling the email notification solves the problem... although the email Queue was empty... what could then be the reason behind the Problem?
And the Repetition of the lines
15.09.2016 13:05 CEST filtering START NEW FILTER QUERY
15.09.2016 13:05 CEST filtering Simple Filter
...
is normal?
Thanks and regards
Paolo
thank you for your reply.
It looks like disabling the email notification solves the problem... although the email Queue was empty... what could then be the reason behind the Problem?
And the Repetition of the lines
15.09.2016 13:05 CEST filtering START NEW FILTER QUERY
15.09.2016 13:05 CEST filtering Simple Filter
...
is normal?
Thanks and regards
Paolo
Re: Bad performance when creating an issue
Using $g_email_send_using_cronjob will solve your problem, but does not explain why it is that slow at the moment.
It's hard to say anything, as you did provide not that much about your installation, your operating environment and configuration.
Concerning CEST filtering ....
I am not sure what you are asking for.
You have enabled logging for filters in log settings (LOG_FILTERING), that's why you see those line.
I don't know why you activated this logging.
It's hard to say anything, as you did provide not that much about your installation, your operating environment and configuration.
Concerning CEST filtering ....
I am not sure what you are asking for.
You have enabled logging for filters in log settings (LOG_FILTERING), that's why you see those line.
I don't know why you activated this logging.
Re: Bad performance when creating an issue
Thank you atrol,
I'll try to use cronjob and will disable the logging for filters.
Thanks again for your support
Paolo
I'll try to use cronjob and will disable the logging for filters.
Thanks again for your support
Paolo
-
- Posts: 3
- Joined: 17 Jul 2017, 10:55
Re: Bad performance when creating an issue
Hi.
I think I have the same problem.
Please tell me where I can "temporarely deactivate email notification?"
Thank You.
I think I have the same problem.
Please tell me where I can "temporarely deactivate email notification?"
Thank You.
Re: Bad performance when creating an issue
There is a configuration option $g_enable_email_notification
https://www.mantisbt.org/docs/master/en ... nfig.email
https://www.mantisbt.org/docs/master/en ... nfig.email
-
- Posts: 3
- Joined: 17 Jul 2017, 10:55
Re: Bad performance when creating an issue
Thank You.
When I set
$g_enable_email_notification = OFF;
insead of
$g_enable_email_notification = ON;
it speeds up.
But as pbassi said:
"the variable $g_email_send_using_cronjob doesn't appear in the config file".
So now I set back to:
$g_enable_email_notification = ON;
and put the variable in a config file and set it to ON like this:
$g_email_send_using_cronjob = ON;
, riht?
Łukasz.
When I set
$g_enable_email_notification = OFF;
insead of
$g_enable_email_notification = ON;
it speeds up.
But as pbassi said:
"the variable $g_email_send_using_cronjob doesn't appear in the config file".
So now I set back to:
$g_enable_email_notification = ON;
and put the variable in a config file and set it to ON like this:
$g_email_send_using_cronjob = ON;
, riht?
Łukasz.