Timeout when adding new banner

[shawncberg]

We're trying to add a new banner to a Revive campaign and after saving the banner we get a timeout error 22 seconds later. We've upgraded to the latest version of Revive but are still experiencing this issue. Here's our version info:

You are currently using Revive Adserver v4.0.2 running on Apache, PHP 5.5.38 and MySQL 10.1.24-MariaDB-cll-lve.

We've checked var/debug.log but only find info messages there from the maintenance process. Nothing is logged there when this happens. Our hosting provider has checked and can't find anything wrong on their end. I've also verified the permissions of all directories are what they should be (from https://documentation.revive-adserver.com/display/DOCS/Directory+Permissions). I've also found that I'm able to upload some images, but not others. The one I'm trying to upload is a JPG file. I've tried re-saving it as a JPG in Photoshop as well as saving it as a PNG but I get the same timeout in Revive with either file format. Here are the 2 files I'm not able to add:

https://www.dropbox.com/s/11c5d6h6t6646jm/WoodTeam_header398x75Date0917.jpg?dl=0
https://www.dropbox.com/s/02zx5t06de2nixs/WoodTeam_square262x247Date0917.jpg?dl=0

I've checked system requirements and can verify we're using a valid version of PHP and all required plugins are enabled.

Any idea what could be happening here? 

 

[Ian]

Hi there,

Do you have the possibility to try with PHP 5.6, or PHP 7.0 ?

[andrewatfornax]

And check the various limitations that are placed on upload sizes/timeouts in both your web server and your PHP configuration files.

[shawncberg]

On 9/15/2017 at 1:56 PM, Ian van Marwijk said:

Hi there,

Do you have the possibility to try with PHP 5.6, or PHP 7.0 ?

Yes, I've tried with 5.6 and experience the same issue. I cannot use 7.0 as the CMS installed on this same site is not compatible.

11 hours ago, andrewatfornax said:

And check the various limitations that are placed on upload sizes/timeouts in both your web server and your PHP configuration files.

Here's a screenshot of the PHP settings: https://www.dropbox.com/s/gjf6lcinjxv9xe2/PHP Settings.png?dl=0

The banners are so small that I can't imagine them exceeding any of these.

 

[andrewatfornax]

Yes, those upload options look okay to me.

I would next take a look to see if there's anything in the webserver configuration that might be suspicious re: timeouts and upload sizes.

And if that fails, I would start to take a look at where the uploaded files are supposed to be stored - that is:

• Are they stored in the database as SQL? If so, I would look at the database server load, and types of tables - are you running into issues with table level locking?
• Are they stored on the filesystem? If so, where is that filesystem, how is it formatted, and how is it mounted on the server (e.g. over a network?).