[PHPBB3-14838] feeds.attachments_base - server 500 error for large attachment tables

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 3.1.10, 3.2.0-RC1
Fix Version/s: 3.1.11-RC1, 3.2.0
Component/s: Other
Labels:
- feeds
Environment:

Hide
Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-42-generic x86_64)
PHP version: 5.6.26-2+deb.sury.org~xenial+1
Server software: nginx/1.10.0
PHP operating system: Linux
MariaDB 10.1.18

/includes/constants.php version: 3.1.10
prosilver version: 3.1.10

Show
Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-42-generic x86_64) PHP version: 5.6.26-2+deb.sury.org~xenial+1 Server software: nginx/1.10.0 PHP operating system: Linux MariaDB 10.1.18 /includes/constants.php version: 3.1.10 prosilver version: 3.1.10

Description

Function: feeds.attachments_base.fetch_attachments
The sql query pulls all attachments from the attachments table. For phpBB installations with large attachment tables, this causes memory overload/server 500 issues.

The sql query needs to be time boxed based on the a.filetime of the oldest post.post_time.

For my temporary work around:
https://www.phpbb.com/community/viewtopic.php?f=466&t=2390801&p=14544781#p14544781

Attachments

Activity

People

Assignee:: Marc

Reporter:: jcocking [X] (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 23/Oct/16 9:39 PM

Updated:: 22/Jan/17 4:03 PM

Resolved:: 04/Jan/17 4:45 PM