Page 1 of 1
Moving attachement to disk fails if there's too many of them
Posted: 07 May 2018, 08:26
by Barnabe42
Hello,
I am running mantis-2.13.1-0.
I am trying to move attachments to disk for a project having 3377 attachments ( 1.5 GB ).
It worked on order project having couple of files.
The log does not say anything. Is there any way to solve this issue ?
/Eric
Re: Moving attachement to disk fails if there's too many of them
Posted: 08 May 2018, 13:15
by Barnabe42
Hi,
I just found a ticket in the issue system from 2010 ...
https://www.mantisbt.org/bugs/view.php?id=11611
Does it mean that it is still not fixed ?
Is there a way to run the move to disk 100 files at the time ?
/Eric
Re: Moving attachement to disk fails if there's too many of them
Posted: 09 May 2018, 07:49
by C Xie
Hi
Have your sort out the issue?
If you have, would you please update your method as I have similar issue.
Thanks
Re: Moving attachement to disk fails if there's too many of them
Posted: 14 May 2018, 05:10
by Barnabe42
C Xie wrote: 09 May 2018, 07:49
Hi
Have your sort out the issue?
If you have, would you please update your method as I have similar issue.
Thanks
I was able to update my test database with small sql query modification but I have to run the import at least 30 times ....
If I handle the file 100 at the time it works most of the time but not when I have a big file in the ticket the import fail so I need to get fewer files.
I will try to process the file in a loop 50 at the time, if it works I will send you the query.
Re: Moving attachement to disk fails if there's too many of them
Posted: 26 Jun 2018, 08:02
by c-s
Hello,
it seems that I have the same problem. We updated our installation to 2.15.0 and want to reduce the size of the database now. We have 14 projects. I could move the attachments for 13 projects but cannot move any of the last project. This one is the biggest one with more than 500 attachments. For some of the other projects I needed to run the tool more than once. There was no message but starting the tool again showed that the attachments were partially moved, so I started the procedure again and again.
But now with the last project nothing happens. There is no error message, except "the site is not working" or showing a blank page.
Can anybody help me? Where and how do I have to do the sql query modification? I'm using the mantisbt tool for moving the attachments (admin/system_utils.php)
Re: Moving attachement to disk fails if there's too many of them
Posted: 28 Jun 2018, 07:30
by c-s
I could solve this problem by changing php settings (php.ini file) max_execution_time and memory_limit .
Re: Moving attachement to disk fails if there's too many of them
Posted: 28 Jun 2018, 07:35
by atrol
Thanks @c-s for telling the solution.