Contrib.social

Multiple provider_user_ids for the same email address

Open on Drupal.org →
Created on 20 September 2022, over 2 years ago
Updated 4 September 2024, 7 months ago

Problem/Motivation

I'm observing a condition where one user_id / email address has 2 (or more) different values for provider_user_id stored for the social_auth_google. I'm wondering under what conditions this might be expected to occur (and/or whether or not it is expected at all) and/or what conclusions one might draw from this observation.

Questions:

  1. Is that expected?
  2. if it is unexpected, does it signal a problem?
  3. If it is expected, under what circumstances would one expect it to occur?

Steps to reproduce

I'm not sure what conditions lead to this situation, but I used this query to identify them

        SELECT
		sa.user_id as sa_uid,
                COUNT(distinct sa.provider_user_id)
	FROM social_auth sa
	WHERE 
		sa.plugin_id = 'social_auth_google' 
	GROUP BY sa.user_id, sa.plugin_id
	HAVING count(distinct sa.provider_user_id) > 1
	ORDER BY
		count(distinct sa.provider_user_id) desc,
		sa.user_id

Proposed resolution

TBD

Remaining tasks

TBD

User interface changes

TBD

API changes

TBD

Data model changes

TBD

💬 Support request
Status

Active

Version

3.0

Component

Code

Created by

🇺🇸United States matt_paz

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment over 1 year ago →
    🇺🇸United States matt_paz

    Just a quick update on this. In the year since we originally investigated the issue, there percentage of impacted users continues to be low, but on on one of our sites, it has grown to 800 cases. One user had five different variants. In one of these cases, there there were four variants, each with a different provider_user_id all created within several milliseconds of one another.

    Impacts appear to be nominal, but I remain stumped on the underlying conditions that would result in what we're observing.

  • Comment 7 months ago →
    🇺🇸United States wells Seattle, WA
contrib.social Blog FAQ Discussions
Production build 0.71.5 2024