"General Test Plan Metrics" stopped working [SOLVED]

[zeevikn]

Hi.

Test report "General Test Plan Metrics" stopped working (white page on the frame) for a specific test plan.
for other test plans it works as expected.
Testlink running on Ubuntu - Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.10 with Suhosin-Patch, MySQL 5.0.51a

any idea why ?
steps to debug this ?
I did not see any errors on apache logs or mysql logs

[zeevikn]

After sometime, instead of getting blank screen I got the following message:
Allowed memory size of 67108864 bytes exhausted (tried to allocate 16 bytes) in /var/www/testlink_1_9_beta6/third_party/adodb/drivers/adodb-mysql.inc.php on line 690

To solve the issue, I increased PHP mem allocation to 256M (default:64M)
vi /etc/php5/apache2/php.ini
270 memory_limit = 256M ; Maximum amount of memory a script may consume (16MB)

/etc/init.d/apache2 restart

[fman]

having info about test plan dimension (amount of test cases, amount of builds, amount of platforms) will be useful to try to understand why this amount of memory is needed

[zeevikn]

The mentioned items are not huge.
~20 test cases, 5 builds. we do not use platforms.

I guess that the main "issue" in our case is the amount of executions.
our automation ADDS executions to the test plan, even if ran on the same build. so we can have 10s and even 100s (might even get to 1000s) of executions for each per of <test case,build>
our executions table contains 3510 entries for this specific test plan.

mysql> select count(*) from executions where testplan_id=1087;
+----------+
| count(*) |
+----------+
| 3510 |
+----------+
1 row in set (0.00 sec)