Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008669TestLinkTest Specificationpublic2019-05-21 11:312019-06-11 18:09
Reporterlucienbanholzer 
Assigned Tofman 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSLinux CentOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008669: Test Case Version Operations -> New Version takes 3 minutes
DescriptionWhen clicking on Test Case Version Operations -> New Version : the process last almost 3 minutes.

Didn't find anything in logs.
Steps To ReproduceClick on Test Specifications. Select a test case. Click the wheel then "New version" right after "Test Case Version Operations". The page is froze during 3 mins.
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysql Ver 15.1 Distrib 10.3.13-MariaDB, for Linux
BrowserChrome
PHP VersionPHP 7.1.27
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships
related to 0008663assignedfman Create new test case version takes 60 seconds 

-  Notes
(0028848)
fman (administrator)
2019-05-21 17:41

In order to do any kind of analysis the 'size' of your installation is needed.
It will be better if you can provide (in a private channel) a copy of your DATABASE in order to have a good sample.

I can not generate in a simple way a sample database that can reproduce any situation
(0028851)
lucienbanholzer (reporter)
2019-05-23 12:30

Hi.

I'm sorry but I cannot give you a dump of the database for security and policy reasons.
The dump is 2.2G.

Best regards
(0028856)
fman (administrator)
2019-05-23 21:29
edited on: 2019-05-23 21:30

without a similar db at least with data scrambled, is not easy to be able to help / to find the bottlenecks.

Please read this, and try to adjust your configuration

I think this config :
$tlCfg->reqTCLinks->freezeLinkOnNewTCVersion = TRUE;
can the reason

// @since 1.9.18
// TRUE => After a test case version has been executed 
//         attachment on test case spec can not be added/removed
//         
// FALSE  
//
// This means that at GUI Level, will not be possible:
// add a new attachment to an Executed Test Case Version
// delete an attachment from Executed Test Case Version
$tlCfg->testcase_cfg->downloadOnlyAfterExec = TRUE;

// This means that at GUI Level, will not be possible:
// add a new req version link to an Executed Test Case Version
// delete a req version link from Executed Test Case Version
$tlCfg->testcase_cfg->reqLinkingDisabledAfterExec = TRUE;

// Effects on Linked Requirements Version after 
// execution of a Test Case Version
$tlCfg->testcase_cfg->freezeReqVersionAfterExec = TRUE;


// Effects on TCVersion N when TCVersion N+1 is created 
$tlCfg->testcase_cfg->freezeTCVersionOnNewTCVersion = TRUE;
$tlCfg->testcase_cfg->freezeTCVRelationsOnNewTCVersion = TRUE;

// Because: 
// The Relation must be frozen (cannot be deleted) when 
// a new version of the test case is created.
//
// It seems confusing that relation can be added, then
// this new configuration will allow this operation
// only on latest test case version
// 
$tlCfg->testcase_cfg->addTCVRelationsOnlyOnLatestTCVersion = TRUE;

// Effects on Req Version to TCVersion LINK 
// when a new version of a linked Test Case is created
// If LINK is frozen, then this means that link can not be deleted.
// $tlCfg->reqTCLinks->freezeLinkOnNewTCVersion = FALSE;
//
// Important Notice:
// Req Version to TCVersion Link can be done ONLY TO LATEST TCV.
// 
// This means that :
// 
// on GUI on the Requirements Area on TEST CASE Specification Feature:
// this option has NO EFFECT 
//
// on GUI on the Coverage Area on REQUIREMENT Specification Feature:
// this option has EFFECT
//
// on GUI on the Assign Requirements Feature:
// this option has EFFECT
//
$tlCfg->reqTCLinks->freezeLinkOnNewTCVersion = TRUE;

// Effects on Req Version to TCVersion LINK 
// when a new version of a linked Req Version is created
$tlCfg->reqTCLinks->freezeLinkOnNewREQVersion = TRUE;


// Effects on BOTH ends of Req Version to TCVersion LINK 
// when a new version of a linked TC Version is created
$tlCfg->reqTCLinks->freezeBothEndsOnNewTCVersion = TRUE;

// Effects on BOTH ends of Req Version to TCVersion LINK 
// when a new version of a linked REQ Version is created
$tlCfg->reqTCLinks->freezeBothEndsOnNewREQVersion = TRUE;


// Effects on REQ Version N when REQ Version N+1 is created 
$tlCfg->req_cfg->freezeREQVersionOnNewREQVersion = TRUE;



(0028858)
lucienbanholzer (reporter)
2019-05-24 09:05

Thank you very much it works with this parameter set to FALSE.
Regards
(0028859)
lucienbanholzer (reporter)
2019-05-24 09:07

Could you just explain me what are the impact of setting this parameter to FALSE. Could it create inconsistencies in the data ?

Thank you in advance,

Best regards,
Lucien
(0028863)
fman (administrator)
2019-05-24 12:59

no inconsistency, you can find a rough explanation here

https://github.com/TestLinkOpenSourceTRMS/testlink-code/wiki [^]
(0028915)
fman (administrator)
2019-06-08 13:58

do you have any feedback?
(0028927)
fman (administrator)
2019-06-11 18:09

no more user feedback

- Issue History
Date Modified Username Field Change
2019-05-21 11:31 lucienbanholzer New Issue
2019-05-21 17:41 fman Note Added: 0028848
2019-05-21 17:41 fman Assigned To => fman
2019-05-21 17:41 fman Status new => feedback
2019-05-21 17:41 fman Relationship added related to 0008663
2019-05-23 12:30 lucienbanholzer Note Added: 0028851
2019-05-23 12:30 lucienbanholzer Status feedback => assigned
2019-05-23 21:29 fman Note Added: 0028856
2019-05-23 21:30 fman Note Edited: 0028856 View Revisions
2019-05-23 21:30 fman Status assigned => feedback
2019-05-24 09:05 lucienbanholzer Note Added: 0028858
2019-05-24 09:05 lucienbanholzer Status feedback => assigned
2019-05-24 09:07 lucienbanholzer Note Added: 0028859
2019-05-24 12:59 fman Note Added: 0028863
2019-06-08 13:58 fman Note Added: 0028915
2019-06-08 13:58 fman Status assigned => feedback
2019-06-11 18:09 fman QA Team - Task Workflow Status => TBD
2019-06-11 18:09 fman Note Added: 0028927
2019-06-11 18:09 fman Status feedback => closed
2019-06-11 18:09 fman Resolution open => fixed



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker