google-code-export / redmine-dmsf

Automatically exported from code.google.com/p/redmine-dmsf
1 stars 1 forks source link

DMSF Crashes redmine due to recursive query #208

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Open DMSF
2. Large number of Files
3.

What is the expected output? What do you see instead?
Just to open DMSF should show me all the files. But there are a large number of 
files (>8GB total) and the recursive wuery to show all the info crashes redmine.

What version of the DMSF and Redmine are you using? On what browser and
operating
system?

DMSF 1.2.2
redmine 1.2.1
Ubuntu 10.04

Please provide any additional information below.

Aparrentately, DMSF executes the query to check files revision. But the query  
(which is recursive) is taking forever and crashes redmine. 

Original issue reported on code.google.com by lcgu...@gmail.com on 19 Jul 2012 at 4:46

GoogleCodeExporter commented 9 years ago
Just addind information. The crash is caused by a query that is consecutively 
called (probably by each file): 

   SELECT * FROM `dmsf_file_revisions` WHERE (`dmsf_file_revisions`.dmsf_file_id = 5655 AND (`dmsf_file_revisions`.`deleted` = 0)) ORDER BY major_version DESC, minor_version DESC, updated_at DESC LIMIT 1

Original comment by lcgu...@gmail.com on 19 Jul 2012 at 4:53