Page 1 of 1

Move attachments from db to disk not working, big size of DB

Posted: 22 Jan 2014, 11:26
by enid
Hello, I am facing an issue regarding the move 2 db script , I have all the attachments on db but I want to move them to disk instead, I changed the config_defaults_inc.php to

# $g_allow_reporter_upload
$g_allow_file_upload = ON;

# Upload destination: specify actual location in project settings
# DISK, DATABASE, or FTP.
$g_file_upload_method = DISK;

and when I try to the page system_utils.php to Move attachments to disk it says : No attachments need to be moved,

Is this related with the large table mantis_bug_file_table which is ~9GB?

Mantis version is 1.1.6

Thank you,
Regards

Re: Move attachments from db to disk not working, big size o

Posted: 24 Jan 2014, 07:23
by atrol
enid wrote: Is this related with the large table mantis_bug_file_table which is ~9GB?
Check your webserver logs, maybe there is some error message.

Re: Move attachments from db to disk not working, big size o

Posted: 27 Jan 2014, 13:36
by enid
On the error log it shows this line when I try to execute the script:
^GOut of memory (Needed 3388060 bytes)

I tried to increase memory_limit on php.ini to 256MB, 512MB but the same thing,

On a link I saw someone suggestion to add to httpd.conf this line:
RLimitMEM 1073741824 2147483648

and after that the execution of move_db2disk.php took more time in execution but this line appeared on errorlog:
[Fri Jan 24 12:19:33 2014] [warn] mod_fcgid: process 3488 graceful kill fail, sending SIGKILL

Re: Move attachments from db to disk not working, big size o

Posted: 26 Jul 2017, 06:21
by fyk0722
Hello, I have the same problem, I do not know if you have successfully transferred, can you help me, thank you!