Bad performance when creating an issue

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
pbassi
Posts: 9
Joined: 15 Sep 2016, 11:21

Bad performance when creating an issue

Post by pbassi »

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
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Bad performance when creating an issue

Post by atrol »

Is it also that slow if you temporarely deactivate email notification?
Please use Search before posting and read the Manual
pbassi
Posts: 9
Joined: 15 Sep 2016, 11:21

Re: Bad performance when creating an issue

Post by pbassi »

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
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Bad performance when creating an issue

Post by atrol »

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.
Please use Search before posting and read the Manual
pbassi
Posts: 9
Joined: 15 Sep 2016, 11:21

Re: Bad performance when creating an issue

Post by pbassi »

Thank you atrol,

I'll try to use cronjob and will disable the logging for filters.

Thanks again for your support
Paolo
lukasz.dippel
Posts: 3
Joined: 17 Jul 2017, 10:55

Re: Bad performance when creating an issue

Post by lukasz.dippel »

Hi.
I think I have the same problem.
Please tell me where I can "temporarely deactivate email notification?"
Thank You.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Bad performance when creating an issue

Post by atrol »

There is a configuration option $g_enable_email_notification
https://www.mantisbt.org/docs/master/en ... nfig.email
Please use Search before posting and read the Manual
lukasz.dippel
Posts: 3
Joined: 17 Jul 2017, 10:55

Re: Bad performance when creating an issue

Post by lukasz.dippel »

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.
Post Reply