MantisBT - TestLink
View Issue Details
0008798TestLinkTest Executepublic2019-11-12 06:022020-01-09 11:25
adnanrox7 
 
urgentblockalways
newopen 
Windows Server 2012
1.9.19 (2019 Q1) 
 
MySQL
Chrome
7.2.0
0008798: Fatal error: Maximum execution time of 30 seconds exceeded in Test Execution
I have changed max_execution_time=300 in php.ini and then it loads after almost a minute or more
Click on Test Execution
No tags attached.
png Capture.PNG (32,139) 2019-11-12 06:03
http://mantis.testlink.org/file_download.php?file_id=5243&type=bug
png

png Capture1.PNG (4,222) 2020-01-09 11:24
http://mantis.testlink.org/file_download.php?file_id=5274&type=bug
png
Issue History
2019-11-12 06:02adnanrox7New Issue
2019-11-12 06:03adnanrox7Note Added: 0029289
2019-11-12 06:03adnanrox7File Added: Capture.PNG
2019-11-12 16:11fmanNote Added: 0029290
2019-11-12 16:55adnanrox7Note Added: 0029291
2019-11-12 18:28fmanNote Added: 0029292
2019-11-13 04:11adnanrox7Note Added: 0029293
2019-11-13 10:07fmanNote Added: 0029294
2019-11-13 10:46adnanrox7Note Added: 0029295
2019-11-13 11:18adnanrox7Note Added: 0029296
2019-11-15 09:55adnanrox7Note Added: 0029297
2019-11-15 10:00adnanrox7Note Added: 0029298
2019-11-15 11:04fmanNote Added: 0029299
2019-11-20 08:35adnanrox7Note Added: 0029306
2020-01-02 04:15adnanrox7Note Added: 0029378
2020-01-02 12:07fmanNote Added: 0029379
2020-01-03 16:24adnanrox7Note Added: 0029385
2020-01-03 17:32fmanNote Added: 0029386
2020-01-04 02:41adnanrox7Note Added: 0029388
2020-01-04 10:37fmanNote Added: 0029390
2020-01-05 11:13adnanrox7Note Added: 0029393
2020-01-05 17:27fmanNote Added: 0029394
2020-01-09 11:24adnanrox7File Added: Capture1.PNG
2020-01-09 11:25adnanrox7Note Added: 0029397

Notes
(0029289)
adnanrox7   
2019-11-12 06:03   
Fatal error: Maximum execution time of 30 seconds exceeded in E:\xampp\htdocs\testlink\vendor\smarty\smarty\libs\Autoloader.php on line 93
(0029290)
fman   
2019-11-12 16:11   
If no details about size of your installation is near impossible to provide an answer
(0029291)
adnanrox7   
2019-11-12 16:55   
What information is required? The DB size is around 6GB
(0029292)
fman   
2019-11-12 18:28   
Size means number of test projects, number of test plans, number of executions.
Then when you have issues on executions: how is the size in test cases of the test plan?
how many builds?

With a DB of this size I can not ask you to provide it for analysis
(0029293)
adnanrox7   
2019-11-13 04:11   
Test projects - 75
Test Plans in current test specification - 11
Test cases in test execution 1000
Builds - 1

Its working ok in TestLink 1.9.8. We are trying to upgrade to the latest version
(0029294)
fman   
2019-11-13 10:07   
use branch tl1.9.19.01 from github
(0029295)
adnanrox7   
2019-11-13 10:46   
Thanks - will check and let you know
(0029296)
adnanrox7   
2019-11-13 11:18   
I have tried with tl1.9.19.01 still the issue exists
(0029297)
adnanrox7   
2019-11-15 09:55   
It seems ok in 1.9.17. Has anything changed after that and are you looking into it?
(0029298)
adnanrox7   
2019-11-15 10:00   
1.9.17 takes more time than 1.9.8 but doesn't time out
(0029299)
fman   
2019-11-15 11:04   
Please look for similar issues on this site.
(0029306)
adnanrox7   
2019-11-20 08:35   
I could find anything specific, it is due to the size of the DB and test specification and can a solution be provided?
(0029378)
adnanrox7   
2020-01-02 04:15   
This can be closed, solved by performance tuning mysql and php admin
(0029379)
fman   
2020-01-02 12:07   
Would you mind sharing the changes you have done at mysql level?
(0029385)
adnanrox7   
2020-01-03 16:24   
I will share them tomorrow.

One more thing is fine to follow the following steps and increase the TC title size to 175

https://www.embeddedsystemtesting.com/2011/11/how-to-change-test-case-title-in-test.html [^]

Any reason for keeping it 100?
(0029386)
fman   
2020-01-03 17:32   
100 is IMHO enough and to prevent users to create IMHO nonsense title, that's why is not going to change
(0029388)
adnanrox7   
2020-01-04 02:41   
Is it ok for me to change it manually?
(0029390)
fman   
2020-01-04 10:37   
1. you can do any change you want on DB Schema knowing you are going to replicare it on every testlink upgrade

2. any news about the changes you have done for performance improvements?
(0029393)
adnanrox7   
2020-01-05 11:13   
key_buffer = 1024M
max_allowed_packet = 1M
max_allowed_packet = 64M
sort_buffer_size = 512K
sort_buffer_size = 16M
net_buffer_length = 8K
net_buffer_length = 16M
read_buffer_size = 256K
read_buffer_size = 16M
read_rnd_buffer_size = 512K
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 8M
myisam_sort_buffer_size = 32M
query_cache_size= 32M
(0029394)
fman   
2020-01-05 17:27   
Thanks
(0029397)
adnanrox7   
2020-01-09 11:25   
One more thing - refer Capture1.PNG. Any idea on that error? We see it quite often.

Also does the Eevent table get cleared automatically after sometime? Is there any way to control this?

Thank you