View Issue Details

IDProjectCategoryView StatusLast Update
0027197mantisbtbugtrackerpublic2020-09-17 16:40
ReporterHUISCO Assigned Toatrol  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
PlatformLinuxOSCentOSOS Version8
Product Version2.24.2 
Summary0027197: Processing a task takes a long time
Description

Hi guys!
The project contains about 2000 requests.
When we try to change "assigned to" in the request and click "Update Information", then the page is processed for a very long time,and sometimes we get an error as shown in the screenshot.
How can I fix this problem?
Thanks!

TagsNo tags attached.
Attached Files
изображение.png (5,980 bytes)   
изображение.png (5,980 bytes)   
изображение-2.png (14,247 bytes)   
изображение-2.png (14,247 bytes)   

Activities

HUISCO

HUISCO

2020-09-01 12:39

reporter   ~0064334

Last edited: 2020-09-01 15:08

/usr/libexec/mysqld, Version: 10.3.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0  Unix socket: /var/lib/mysql/mysql.sock
Time                Id Command  Argument
# Time: 200901 19:36:32
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.001950  Lock_time: 0.000120  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
use bugtracker;
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000489  Lock_time: 0.000319  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000499  Lock_time: 0.000308  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000685  Lock_time: 0.000074  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000305  Lock_time: 0.000176  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000269  Lock_time: 0.000200  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000388  Lock_time: 0.000213  Rows_sent: 2  Rows_examined: 6
# Rows_affected: 0  Bytes_sent: 473
SET timestamp=1598978192;
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent
                                  FROM mantis_project_mantis p
                                  LEFT JOIN mantis_project_hierarchy_mantis ph
                                    ON ph.child_id = p.id
                                  WHERE p.enabled = '1'
                                  ORDER BY p.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000280  Lock_time: 0.000185  Rows_sent: 8  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 1181
SET timestamp=1598978192;
SELECT * FROM mantis_project_version_mantis WHERE project_id IN (1,0);
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000995  Lock_time: 0.000410  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 1069
SET timestamp=1598978192;
SELECT m.*, c.*, c.id AS context_id FROM mantis_mantis_Announce_message_mantis AS m
                        JOIN mantis_mantis_Announce_context_mantis AS c ON c.message_id=m.id
                        LEFT JOIN mantis_mantis_Announce_dismissed_mantis as d ON d.context_id=c.id and d.user_id=4
                        WHERE (d.timestamp IS NULL or d.timestamp < m.timestamp)
                        AND c.location = 'header' AND (
                                (c.project_id = 0 AND c.access <= 90)
                                OR (c.project_id = 1 AND c.access <= 90) ) ORDER BY m.timestamp DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000166  Lock_time: 0.000051  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 238
SET timestamp=1598978192;
SELECT DISTINCT p.id, p.name, ph.parent_id
                                          FROM mantis_project_mantis p
                                          LEFT JOIN mantis_project_hierarchy_mantis ph
                                            ON ph.child_id = p.id
                                          WHERE p.enabled = '1' AND
                                                 ph.parent_id IS NOT NULL
                                          ORDER BY p.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000351  Lock_time: 0.000193  Rows_sent: 5  Rows_examined: 31
# Rows_affected: 0  Bytes_sent: 615
SET timestamp=1598978192;
SELECT c.*, p.name AS project_name FROM mantis_category_mantis c
                                LEFT JOIN mantis_project_mantis p
                                        ON c.project_id=p.id
                                WHERE  project_id IN ( 1, 0 )  ORDER BY c.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8  Schema: bugtracker  QC_hit: No
# Query_time: 0.000394  Lock_time: 0.000297  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 184
SET timestamp=1598978192;
SELECT CFP.project_id, CF.id FROM mantis_custom_field_mantis CF  JOIN mantis_custom_field_project_mantis CFP ON CFP.field_id = CF.id WHERE CFP.project_id IN (1)  ORDER BY sequence ASC, name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.001117  Lock_time: 0.000194  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.000268  Lock_time: 0.000081  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.000192  Lock_time: 0.000044  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.000812  Lock_time: 0.000105  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.000250  Lock_time: 0.000039  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 9  Schema: bugtracker  QC_hit: No
# Query_time: 0.000088  Lock_time: 0.000033  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000626  Lock_time: 0.000079  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000126  Lock_time: 0.000035  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000117  Lock_time: 0.000027  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000529  Lock_time: 0.000045  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000153  Lock_time: 0.000021  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 10  Schema: bugtracker  QC_hit: No
# Query_time: 0.000081  Lock_time: 0.000030  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000527  Lock_time: 0.000050  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000124  Lock_time: 0.000032  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000114  Lock_time: 0.000028  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000509  Lock_time: 0.000049  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000146  Lock_time: 0.000021  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 11  Schema: bugtracker  QC_hit: No
# Query_time: 0.000083  Lock_time: 0.000033  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000543  Lock_time: 0.000063  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000140  Lock_time: 0.000041  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000122  Lock_time: 0.000030  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000504  Lock_time: 0.000053  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000165  Lock_time: 0.000025  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 12  Schema: bugtracker  QC_hit: No
# Query_time: 0.000086  Lock_time: 0.000032  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000567  Lock_time: 0.000064  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000135  Lock_time: 0.000035  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000143  Lock_time: 0.000046  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000478  Lock_time: 0.000051  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000153  Lock_time: 0.000022  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 13  Schema: bugtracker  QC_hit: No
# Query_time: 0.000085  Lock_time: 0.000031  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# Time: 200901 19:36:37
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.001050  Lock_time: 0.000123  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978197;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000304  Lock_time: 0.000086  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978197;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000282  Lock_time: 0.000049  Rows_sent: 1  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3537
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000895  Lock_time: 0.000098  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978197;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000287  Lock_time: 0.000045  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978197;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000087  Lock_time: 0.000033  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 0  Bytes_sent: 11
SET timestamp=1598978197;
DELETE FROM mantis_tokens_mantis WHERE 1598978197 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000155  Lock_time: 0.000044  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 184
SET timestamp=1598978197;
SELECT CFP.project_id, CF.id FROM mantis_custom_field_mantis CF  JOIN mantis_custom_field_project_mantis CFP ON CFP.field_id = CF.id WHERE CFP.project_id IN (1)  ORDER BY sequence ASC, name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000139  Lock_time: 0.000031  Rows_sent: 6  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3951
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (7,8,14,15,21,31) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000104  Lock_time: 0.000026  Rows_sent: 0  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 3455
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4,7,8,14,15,21,31) AND project_id = 1;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.001423  Lock_time: 0.000571  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0  Bytes_sent: 503
SET timestamp=1598978197;
SELECT f.name, f.type, f.access_level_r, f.default_value, s.value, s.text
                        FROM mantis_custom_field_project_mantis p
                                INNER JOIN mantis_custom_field_mantis f ON f.id = p.field_id
                                LEFT JOIN mantis_custom_field_string_mantis s
                                        ON s.field_id = p.field_id AND s.bug_id = 2066
                        WHERE p.project_id = 1
                        ORDER BY p.sequence ASC, f.name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 14  Schema: bugtracker  QC_hit: No
# Query_time: 0.000078  Lock_time: 0.000022  Rows_sent: 9  Rows_examined: 9
# Rows_affected: 0  Bytes_sent: 203
SET timestamp=1598978197;
SELECT email_id FROM mantis_email_mantis ORDER BY email_id ASC;
# Time: 200901 19:37:01
# User@Host: root[root] @ localhost []
# Thread_id: 15  Schema: bugtracker  QC_hit: No
# Query_time: 0.000649  Lock_time: 0.000089  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978221;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 15  Schema: bugtracker  QC_hit: No
# Query_time: 0.000171  Lock_time: 0.000050  Rows_sent: 16  Rows_examined: 32
# Rows_affected: 0  Bytes_sent: 652
SET timestamp=1598978221;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 15  Schema: bugtracker  QC_hit: No
# Query_time: 0.000536  Lock_time: 0.000062  Rows_sent: 44  Rows_examined: 44
# Rows_affected: 0  Bytes_sent: 1725
SET timestamp=1598978221;
SELECT
                        TABLE_NAME,
                        CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
                FROM INFORMATION_SCHEMA.TABLES
                WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 15  Schema: bugtracker  QC_hit: No
# Query_time: 0.000194  Lock_time: 0.000028  Rows_sent: 73  Rows_examined: 73
# Rows_affected: 0  Bytes_sent: 9769
SET timestamp=1598978221;
SELECT config_id, user_id, project_id, type,  value, access_reqd FROM mantis_config_mantis;
atrol

atrol

2020-09-01 15:20

developer   ~0064335

I suspect there is a problem sending emails.
Check entries in mantis_email_mantis database table and try to find out why those emails get not sent.

HUISCO,

This is not a bug or feature request for MantisBT (you are asking for help on how to deal with performance issues). I am therefore resolving this issue as "no change required".

Please use the forums to get support on customizing and using MantisBT (refer to http://www.mantisbt.org/support.php for links and further details).