Moving attachement to disk fails if there's too many of them

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Barnabe42
Posts: 7
Joined: 24 Jan 2018, 15:29

Moving attachement to disk fails if there's too many of them

Post 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
Barnabe42
Posts: 7
Joined: 24 Jan 2018, 15:29

Re: Moving attachement to disk fails if there's too many of them

Post 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
C Xie
Posts: 2
Joined: 03 May 2018, 10:46

Re: Moving attachement to disk fails if there's too many of them

Post 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
Barnabe42
Posts: 7
Joined: 24 Jan 2018, 15:29

Re: Moving attachement to disk fails if there's too many of them

Post 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.
c-s
Posts: 2
Joined: 26 Jun 2018, 07:43

Re: Moving attachement to disk fails if there's too many of them

Post 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)
c-s
Posts: 2
Joined: 26 Jun 2018, 07:43

Re: Moving attachement to disk fails if there's too many of them

Post by c-s »

I could solve this problem by changing php settings (php.ini file) max_execution_time and memory_limit .
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Moving attachement to disk fails if there's too many of them

Post by atrol »

Thanks @c-s for telling the solution.
Please use Search before posting and read the Manual
Post Reply