MantisBT - TestLink
View Issue Details
0008669TestLinkTest Specificationpublic2019-05-21 11:312019-06-11 18:09
lucienbanholzer 
fman 
urgentmajoralways
closedfixed 
Linux CentOS
1.9.19 (2019 Q1) 
 
mysql Ver 15.1 Distrib 10.3.13-MariaDB, for Linux
Chrome
PHP 7.1.27
TBD
0008669: Test Case Version Operations -> New Version takes 3 minutes
When clicking on Test Case Version Operations -> New Version : the process last almost 3 minutes.

Didn't find anything in logs.
Click 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.
No tags attached.
related to 0008663assigned fman Create new test case version takes 60 seconds 
Issue History
2019-05-21 11:31lucienbanholzerNew Issue
2019-05-21 17:41fmanNote Added: 0028848
2019-05-21 17:41fmanAssigned To => fman
2019-05-21 17:41fmanStatusnew => feedback
2019-05-21 17:41fmanRelationship addedrelated to 0008663
2019-05-23 12:30lucienbanholzerNote Added: 0028851
2019-05-23 12:30lucienbanholzerStatusfeedback => assigned
2019-05-23 21:29fmanNote Added: 0028856
2019-05-23 21:30fmanNote Edited: 0028856bug_revision_view_page.php?bugnote_id=28856#r5850
2019-05-23 21:30fmanStatusassigned => feedback
2019-05-24 09:05lucienbanholzerNote Added: 0028858
2019-05-24 09:05lucienbanholzerStatusfeedback => assigned
2019-05-24 09:07lucienbanholzerNote Added: 0028859
2019-05-24 12:59fmanNote Added: 0028863
2019-06-08 13:58fmanNote Added: 0028915
2019-06-08 13:58fmanStatusassigned => feedback
2019-06-11 18:09fmanQA Team - Task Workflow Status => TBD
2019-06-11 18:09fmanNote Added: 0028927
2019-06-11 18:09fmanStatusfeedback => closed
2019-06-11 18:09fmanResolutionopen => fixed

Notes
(0028848)
fman   
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   
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   
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   
2019-05-24 09:05   
Thank you very much it works with this parameter set to FALSE.
Regards
(0028859)
lucienbanholzer   
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   
2019-05-24 12:59   
no inconsistency, you can find a rough explanation here

https://github.com/TestLinkOpenSourceTRMS/testlink-code/wiki [^]
(0028915)
fman   
2019-06-08 13:58   
do you have any feedback?
(0028927)
fman   
2019-06-11 18:09   
no more user feedback