Page 1 of 1

ImageMagick doesn't work on PHP when get 700K rows

Posted: 2016-01-11T16:33:27-07:00
by Robert_CA
PHP exec(convert) doesn't work if the mysql query got over 700K database rows, but it works on 400K rows.

I run it on a 1GB RMA machine. If the total of rows over 700K, convert would not export any images to disk, and returns error -1. If the total of rows around 400K, everything would be fine. I had checked the memory usage. In 700K rows, the memory has 70MB free RAM, and in 400K it has 130MB free RAM.

Can anyone help me out? Thanks.

Re: ImageMagick doesn't work on PHP when get 700K rows

Posted: 2016-01-11T17:19:27-07:00
by magick
Take a look @ php.ini. PHP typically has a conservative memory limit. Try updating the limit and see if that fixes the problem.

Re: ImageMagick doesn't work on PHP when get 700K rows

Posted: 2016-01-11T18:11:27-07:00
by Robert_CA
Thanks. The memory_limit had set to be -1 as unlimited. It doesn't solve this issue.

Re: ImageMagick doesn't work on PHP when get 700K rows

Posted: 2016-01-12T05:39:25-07:00
by magick
Ok, next up, let's reduce the memory resource requirement. You can set up a policy per viewtopic.php?f=4&t=26801. Or add -limit memory 64mb -limit map 128mb as an option to your convert command-line.

Still doesn't work? Try your command outside your PHP script directly on the command-line.

Still doesn't work? Add -debug cache to your convert command-line and post the results here so we can insight into why its failing.