Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008798TestLinkTest Executepublic2019-11-12 06:022020-01-09 11:25
Reporteradnanrox7 
Assigned To 
PriorityurgentSeverityblockReproducibilityalways
StatusnewResolutionopen 
PlatformWindows Server 2012OSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008798: Fatal error: Maximum execution time of 30 seconds exceeded in Test Execution
DescriptionI have changed max_execution_time=300 in php.ini and then it loads after almost a minute or more
Steps To ReproduceClick on Test Execution
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
BrowserChrome
PHP Version7.2.0
TestCaseID
QA Team - Task Workflow Status
Attached Filespng file icon Capture.PNG [^] (32,139 bytes) 2019-11-12 06:03


png file icon Capture1.PNG [^] (4,222 bytes) 2020-01-09 11:24

- Relationships

-  Notes
(0029289)
adnanrox7 (reporter)
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 (administrator)
2019-11-12 16:11

If no details about size of your installation is near impossible to provide an answer
(0029291)
adnanrox7 (reporter)
2019-11-12 16:55

What information is required? The DB size is around 6GB
(0029292)
fman (administrator)
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 (reporter)
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 (administrator)
2019-11-13 10:07

use branch tl1.9.19.01 from github
(0029295)
adnanrox7 (reporter)
2019-11-13 10:46

Thanks - will check and let you know
(0029296)
adnanrox7 (reporter)
2019-11-13 11:18

I have tried with tl1.9.19.01 still the issue exists
(0029297)
adnanrox7 (reporter)
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 (reporter)
2019-11-15 10:00

1.9.17 takes more time than 1.9.8 but doesn't time out
(0029299)
fman (administrator)
2019-11-15 11:04

Please look for similar issues on this site.
(0029306)
adnanrox7 (reporter)
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 (reporter)
2020-01-02 04:15

This can be closed, solved by performance tuning mysql and php admin
(0029379)
fman (administrator)
2020-01-02 12:07

Would you mind sharing the changes you have done at mysql level?
(0029385)
adnanrox7 (reporter)
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 (administrator)
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 (reporter)
2020-01-04 02:41

Is it ok for me to change it manually?
(0029390)
fman (administrator)
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 (reporter)
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 (administrator)
2020-01-05 17:27

Thanks
(0029397)
adnanrox7 (reporter)
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

- Issue History
Date Modified Username Field Change
2019-11-12 06:02 adnanrox7 New Issue
2019-11-12 06:03 adnanrox7 Note Added: 0029289
2019-11-12 06:03 adnanrox7 File Added: Capture.PNG
2019-11-12 16:11 fman Note Added: 0029290
2019-11-12 16:55 adnanrox7 Note Added: 0029291
2019-11-12 18:28 fman Note Added: 0029292
2019-11-13 04:11 adnanrox7 Note Added: 0029293
2019-11-13 10:07 fman Note Added: 0029294
2019-11-13 10:46 adnanrox7 Note Added: 0029295
2019-11-13 11:18 adnanrox7 Note Added: 0029296
2019-11-15 09:55 adnanrox7 Note Added: 0029297
2019-11-15 10:00 adnanrox7 Note Added: 0029298
2019-11-15 11:04 fman Note Added: 0029299
2019-11-20 08:35 adnanrox7 Note Added: 0029306
2020-01-02 04:15 adnanrox7 Note Added: 0029378
2020-01-02 12:07 fman Note Added: 0029379
2020-01-03 16:24 adnanrox7 Note Added: 0029385
2020-01-03 17:32 fman Note Added: 0029386
2020-01-04 02:41 adnanrox7 Note Added: 0029388
2020-01-04 10:37 fman Note Added: 0029390
2020-01-05 11:13 adnanrox7 Note Added: 0029393
2020-01-05 17:27 fman Note Added: 0029394
2020-01-09 11:24 adnanrox7 File Added: Capture1.PNG
2020-01-09 11:25 adnanrox7 Note Added: 0029397



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker