Hang when pulling up a Test result Matrix in 1.9.5

[euphxenos]

If I look under "Test Reports and Metrics", then click on "Test result matrix", it hangs. The broswer sits there trying to load the page, but never finishes. I've tried waiting as much as 40 minutes without getting a page back. When I look at the Mysql server, I see that mysqld gets very busy (it starts consuming 99% of the cpu on the database host), so it's clearly trying to do something. I've tried this under 1.9.5, 1.9.6, and 1.9.7, and have seen the same behavior in all three. We're using Testlink on Debian Wheezy, with its mysql 5.5.28 database hosted on a second machine (also running Debian Wheezy).

Are there any known issues that can cause this? Is there a particular table I should look at to see if we've passed some scalability limit, and perhaps consider discarding old data? When I do a mysqldump of the table, it's only about 20 megs, but perhaps we just have too much of something.


thanks,
--Andrew

[fman]

Unfortunately you are not provided any indication about amount of test cases, executions and builds that have to build up the matrix.
In this way there is no way to help.

Providing a db backup in order to do some test is necessary => contact francisco.mancardi@gmail.com


>> Are there any known issues that can cause this? Is there a particular table I should look at to
mantis is the place to look for.

[euphxenos]

Unfortunately you are not provided any indication about amount of test cases, executions and builds that have to build up the matrix.
In this way there is no way to help.

Providing a db backup in order to do some test is necessary => contact francisco.mancardi@gmail.com


>> Are there any known issues that can cause this? Is there a particular table I should look at to
mantis is the place to look for.

When I check the database directly, I see 917 rows in builds, 3505 rows in tcases_active, and 87,152 rows in executions. I'm not sure where to pull up these numbers from within Testlink, since it's the reporting pages that I'm having difficulty accessing. If there's some other information I can pull out of the database that would be of interest, please let me know what it is. I'll check to see if it's okay to send you a copy of the database and send you an email.

[fman]

It seems that the bigest test plan has more than 700 builds, as you can understand this means lot of info.
The query to get the info for test matrix has a big issue with this amount of builds.
The query need to be refactored to understand how to improve it.
Please next time you post a topic like this do not forget that context is critic, and on your initial post context was completely missed