Open Bug 1224161 Opened 9 years ago Updated 9 years ago

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

Categories

(Testopia :: General, defect)

defect
Not set
normal

Tracking

(Not tracked)

UNCONFIRMED

People

(Reporter: antovinraj, Assigned: gregaryh)

Details

Attachments

(1 file)

Attached image 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.
(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?)
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.
Please describe which "possible ways" you tried exactly.
Flags: needinfo?(antovinraj)
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.
Flags: needinfo?(antovinraj)
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: