If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

Error in loading data when we have more number of runs in testopia

UNCONFIRMED
Assigned to

Status

Testopia
General
UNCONFIRMED
2 years ago
2 years ago

People

(Reporter: Antoine, Assigned: Greg Hendricks)

Tracking

Details

Attachments

(1 attachment)

(Reporter)

Description

2 years ago
Created attachment 8686558 [details]
sceenshot_testopia.gif

User Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.80 Safari/537.36

Steps to reproduce:

Hi Team,

Bugzilla Version: 4.4.6
Testopia Version 2.5
MySQL Version: 5.6.11

When we access a plan "tr_show_plan.cgi" we are getting error

Plan ID consists of 61 test cases. These 61 test cases are belonging to 23 test plans. When we check the number of runs for these test cases is around 1,11,829.

MySQL query is SELECT DISTINCT count(run_id) FROM test_case_runs           WHERE case_id in (61 test cases id's ) ;
+---------------+
| count(run_id) |
+---------------+
|        111829 |
+---------------+
1 row in set (1.02 sec)

When we are using the filter View as "View All" or "500" it is giving error.

Attached screen shot for reference. 

Please provide your inputs how to over come from this issue.  


Actual results:

It is giving error as "There was an error loading the data: undefined"


Expected results:

It should display all the test cases in "Test Cases" Tab.

Comment 1

2 years ago
(In reply to Antoine from comment #0)
> Bugzilla Version: 4.4.6

Please do not run old software that has security vulnerabilities.

> When we access a plan "tr_show_plan.cgi" we are getting error
> It is giving error as "There was an error loading the data: undefined"

What have you tried so far yourself to solve the problem?

(Same as bug 1065253?)
(Reporter)

Comment 2

2 years ago
Tried in possible ways, but not able to do. 

Also found that when we have more than 50,000 run id's for a plan it is giving error. Is there is any limitation given in Testopia. 

Please provide your valuable suggestion.

Comment 3

2 years ago
Please describe which "possible ways" you tried exactly.
Flags: needinfo?(antovinraj)
(Reporter)

Comment 4

2 years ago
Enabled MySQL general logs and able to see all job run id's which are executing for a each test case id's. 

Sample Code snippet from MySQL general log is
                   32 Query     SELECT MAX(changed)
               FROM test_case_activity
              WHERE case_id = '104683'
                   32 Query     SELECT case_run_id
                                        FROM test_case_runs
                                        WHERE case_id = '104683'
                   32 Query     SELECT case_run_id,run_id,case_id,assignee,testedby,case_run_status_id,case_text_version,build_id,environment_id,priority_id,notes,running_date,close_date,iscurrent,sortkey FROM test_case_runs
             WHERE case_run_id = '447885'
                   32 Query     SELECT case_run_id,run_id,case_id,assignee,testedby,case_run_status_id,case_text_version,build_id,environment_id,priority_id,notes,running_date,close_date,iscurrent,sortkey FROM test_case_runs
             WHERE case_run_id = '491186'
                   32 Query     SELECT case_run_id,run_id,case_id,assignee,testedby,case_run_status_id,case_text_version,build_id,environment_id,priority_id,notes,running_date,close_date,iscurrent,sortkey FROM test_case_runs
             WHERE case_run_id = '507998'

What is the purpose of executing these SQL queries. These SQL query got interrupted before it was completed and failing to load values in GUI. Is there any limitation defined in Testopia for executing SQL query.
(Reporter)

Updated

2 years ago
Flags: needinfo?(antovinraj)
You need to log in before you can comment on or make changes to this bug.