So the query that gets bogged down is in CRM_Dedupe_BAO_RuleGroup.php on line 204. Note that if it goes through a similar but not identical query on line 198 the db does not get locked in the same way. It looks like all Contact profile forms end up deduping, though I'm not sure why.

I was able to replicate this in the Contact Summary Layout Major Gifts uses. When I tried to add tags, it froze and then locked up the database.

Both issues appear to be caused by the js in the selector. Unfortunately I'm trying to repair my local civi install so I can't debug. In my testing, it could find me, but if I selected another search option then tried to go back to Name, it suddenly couldn't find me.

@Ejegg have we tidied this up in civi? Otherwise we should create a separate ticket for that work.

Thanks @CCogdill_WMF!

I see a patch merged @Ejegg. Is this pending deployment?

@DStrine I don't currently have permission on the attached doc, so I'm wondering if other fr-tech engineers would.

@Ejegg what are the steps to complete this? It would be helpful to know for next year too.

@jcrespo I just returned from maternity leave and I can approve this request.

@MBeat33 Do you have any recent examples of where you've seen this? All the older examples seem to have been corrected now.

Seeing if I can catch it in a test. @Ejegg have we seen this with any other gateways?

I'm trying to dig into this a bit but struggling to find where the error would be happening now.

This is deployed.

@Ejegg @eileen I just tried to go to this CID and it seems to have timed out. This is not happening on all cids.

Put it on my calendar for Monday.

@Ejegg can we close this?

@Ejegg I'm seeing a patch merged here. Is this task Pending Deployment?

@Ejegg should we go ahead and turn this on? We'd need to add settings to donationinterface.settings.php and create the job.

To test this:

It worked end to end in my local test!

@Ejegg I'm moving this into pending deployment under the assumption that the merged patch fixes the issue.

@Ejegg What does happen when a recurring charge gets rejected? Do we have a workflow to reach out to the donor?

I created a task for the timeouts: https://phabricator.wikimedia.org/T204050

I got donations in the db locally with the script as it is. Does someone else want to test? @Ejegg? @XenoRyet? I do think the orphan slayer module could use some batching though because the paypal one times out.

This might be a good task for pairing or a tech talk.

It tunrs out that maps to this status in GlobalCollectAdapter:
"case 430354: // issuer unknown"
That error message seems misleading.

Hmm now I've got a valid visa orphan but I'm getting an error of: [debugMessage:protected] =} Mastercard third rail

Set bogus return url to create testing orphans without 3d secure.

Okay making progress, for some reason I needed to add time=0 which is a little curious because I got a bunch of orphans with that parameter and none without. I'm seeing also error messages that may be expected because I'm testing with 3d secure..

So I'm running it locally and not getting a lot of feedback. I'm going to work on adding more because it's not deleting the orphans from the smashpig db.

@Ejegg so the latest here is that I'm getting an error when I try to run the drush script "Class 'IngenicoAdapter' not found" but I can't figure out why.

It's on me to check in on this. Last I remember I had tested my patch locally and it worked but I need to retest and confirm.

I'm not sure what the latest status of this is.

@Aklapper Thanks!

@Ejegg that seems like a good fix! ^

Sent an email to our rep.

Thanks @Pcoombe! This looks pretty clear to me. @Ejegg Let's coordinate on updating the links on our end in the next couple of days.

I think @Pcoombe would know the specifics of which page should redirect where better than I would. But I am concerned that the FAQ is redirecting to the about page and that Tax Policy, Matching Gifts, Ways to Give, and cancel recurring have no redirects listed on that issue. Thanks for the quick follow up @Varnent!

Currently, donatewiki is sending all links to foundation wiki, to clarify on my above comment.

@Varnent I just checked the FAQ redirect and it just goes to the generic about page. For tonight, to be consistent with donatewiki, we are sending all these pages to the foundationwiki and will be in touch in the morning to update all the links to the appropriate new pags in the morning.

@Pcoombe so it looks like the new site launched and it broke the links because there were no redirects. We are currently updating all the links to donatewiki and the foundationwiki because we don't know how to do localization links for the new site. @Varnent could we get hard links to any pages on the new site we need to link to and how to get localization? (Example: in the old site we could link with language=$language&country=$country in the url. Also, we need there to be redirects on the new site in case people have old links.

@Pcoombe @jgleeson Just following up after vacation, what is the timeline to move to these new pages?

We have changed over the thank you page and all is working as expected.

@Pcoombe Awesome! As mentioned, I'll be gone next week but let @jgleeson know if the pages are ready for launch.

Also the thank you page is updated now.

Thanks @Pcoombe! @DStrine I'm on vacation next week so let's assign someone else before I leave.

@Pcoombe I'm noticing that the launch date is theoretically coming up. How are we feeling about switching over the other pages to donate wiki soon?

Hmm so the question is why was this cancelled. I'm seeing a few of these from that date range but haven't found a common cause.

• Separate contribution tracking ids/data from dependency on the civi cluster databases.

Current issue: reliance on Title class in defineTransactions. Solution - set in defaults and add option as in globalcollect.

@Ejegg I'm testing this locally but it's not finding the IngenicoAdapter class. I notice it's not in vendor/autoload.php but don't know why it's missing.

That was it! I'm in. Thank you @Dzahn and @Ottomata!!

Great @Pcoombe! @Ejegg let's plan for when we should do this.

@Ottomata just the LDAP login isn't working. I should be in wmf...

Oh! So it looks like when a payment is in progress, there is no status code: https://epayments-api.developer-ingenico.com/s2sapi/v1/en_US/java/statuses.html. I'll need to add handling.

Hmm this is what I see, the curl response seems to be: {"status":"IN_PROGRESS"}, which is why we can't get a status out of it.

Thanks @Dzahn!

Thank you @Dzahn! I'm currently trying to log into JupyterHub and my wikitech credentials aren't working. I just wanted to make sure I was added as a user there?

So far I can't reproduce. I'll take a closer look at the logs.

Hmm just beginning to look into this, but could it be that we're getting a different statuscode than globalcollect expects? I'll see if I can reproduce.

No problem @Pcoombe! @Ejegg @DStrine

@Pcoombe Are you comfortable with us switching to the new thank you page or should we pause on that too?

Thanks @Pcoombe! Also @DStrine for your planning ^^.

@Ejegg Let's chat today about when to deploy the settings changes for the pages that have already moved to donate wiki, and testing the new thank you page.

Thanks @Pcoombe! I emailed Greg to ask for the new urls for FAQ and Tax Deductibility.

Also I emailed Greg about redirects from the new site to donate wiki.

I notice that some of the pages in translation are missing (for example Matching Gifts in Spanish). Do we have a plan for changing those over @Pcoombe @DStrine?

@Ejegg when should we set the new thank you page on prod? Should we do for it just a little bit? Not sure if we have another way to test.

@MBeat33 Is that just for globalcollect?

• For thank you emails, need to change them in the wiki pages because they are hard-coded.

@Ejegg I'm seeing this error in the logs: