While diagnosing replication timeouts, I discovered that the /{db}/_changes query (using the relaxed module) is taking well over 30 seconds. The ChangesNormalizer isn't using the 'since' query parameter to limit results in Changes.php, which is using the default last_seq value of 0. For me, that means over 18000 results and slow replications with UI timeouts.

CommentFileSizeAuthor
#2 replication-normalizer-parameter-2888215-2.patch.patch1.54 KBpapagrande

Comments

PapaGrande created an issue. See original summary.

papagrande’s picture

papagrande
Primary language English
commented
StatusFileSize
new replication-normalizer-parameter-2888215-2.patch.patch1.54 KB

This patch adds a call to lastSeq() to use the 'since' parameter and removes unnecessary comparisons already done in /src/Changes/Changes.php.

jeqq’s picture

jeqq commented
Status: Needs review » Postponed

@PapaGrande Take a look here: https://github.com/relaxedws/drupal-replication/pull/16 - it's exactly what you need, it's a known issue. I have to add a test and then will merge it.

jeqq’s picture

jeqq commented
Assigned: Unassigned » jeqq
papagrande’s picture

papagrande
Primary language English
commented

@jeqq, thanks. Your code in the PR looks helpful.

jeqq’s picture

jeqq commented
Status: Postponed » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.