Display of files in a job stays "processing" forever

[ccbaxter]

I'm using Safari 6.0.4 and Firefox 21.0 with bacula 5.2.12 and apache2.

Sometimes when I try to display the files inside a job the page stays "processing" and nothing shows up. I think it doesn't depends on the number of files of the job however when there are only a few files ( < 20 ) it works without problems.

Here is the string in the apache access log file:

"GET /datatables/sEcho=1&iColumns=5&sColumns=path.path%3Bfilename.name%2C%2C%2 C%2C&iDisplayStart=0&iDisplayLength=50&mDataProp_0=filename&mDataProp_1=size &mDataProp_2=mode&mDataProp_3=uid&mDataProp_4=gid&sSearch=&bRegex=false& sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSea rchable_1=false&sSearch_2=&bRegex_2=false&bSearchable_2=false&sSearch_3=&bRe gex_3=false&bSearchable_3=false&sSearch_4=&bRegex_4=false&bSearchable_4=false &iSortingCols=1&iSortCol_0=0&sSortDir_0=asc&bSortable_0=true&bSortable_1=false&b Sortable_2=false&bSortable_3=false&bSortable4=false&referrer=%2Fjob%2F215%2F&c ontext=files&=1370950571107 HTTP/1.1" 500 341 "http://almir.mydomain.com/job/215/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/536.29.13 (KHTML, like Gecko) Version/6.0.4 Safari/536.29.13"

If I do the query inside bconsole I get the results instantly.

[domenkozar]

This is because bacula has terrible design of tables for files. I'll try to take a look and see what can be done, thank for reporting this one!