User merge failed, corrupted database entries due to third party plugin

support
21

OK fetching that… I have connectivity issues. I’ll check with safe_mode to see if it works.
Safe-mode does not help…

hooks:
  after_code:
    - exec:
        cd: $home/plugins
        cmd:
          - git clone https://github.com/discourse/docker_manager.git
          - git clone https://github.com/discourse/discourse-assign.git
          - git clone https://github.com/discourse/discourse-bbb.git
          - git clone https://github.com/discourse/discourse-calendar.git
          - git clone https://github.com/discourse/discourse-canned-replies.git
          - git clone https://github.com/discourse/discourse-checklist.git
          - git clone https://github.com/discourse/discourse-code-review.git
          - git clone https://github.com/discourse/discourse-footnote.git
          - git clone https://github.com/discourse/discourse-github.git
          - git clone https://github.com/discourse/discourse-graphviz.git
          - git clone https://github.com/discourse/discourse-math.git
          - git clone https://github.com/discourse/discourse-policy.git
          - git clone https://github.com/discourse/discourse-prometheus.git
          - git clone https://github.com/discourse/discourse-prometheus-alert-receiver.git
          - git clone https://github.com/discourse/discourse-push-notifications.git
          - git clone https://github.com/discourse/discourse-saved-searches.git
          - git clone https://github.com/discourse/discourse-solved.git
          - git clone https://github.com/discourse/discourse-spoiler-alert.git
          - git clone https://github.com/discourse/discourse-voting.git
          - git clone https://github.com/discourse/discourse-yearly-review.git
          - git clone https://github.com/angusmcleod/discourse-events.git
          - git clone https://github.com/angusmcleod/discourse-locations.git
          - git clone https://github.com/davidtaylorhq/discourse-whos-online.git

I see already that I can upgrade the URL for the last ones. (but the rebuild can only happen tonight UTC like midnight)
Maybe ping @angus or @merefield for events and locations.

22

It might be the discourse-assign plugin as it seems to be the only plugin in your list that modifies the TopicQuery class. And I suspect that’s where the error occurs.

Can you verify my suspicion by disabling the plugin and checking if the category works? You can re-enable it afterwards. Also, it would be interesting to know if any of the topic’s custom fields references the merged user in some way or another. Can you check that out as well please?

./launcher enter app
rails c

id_of_problematic_topic = 123
Topic.find(id_of_problematic_topic).custom_fields
3 Likes
23

After disabling discourse-assign:

  • latest works
  • top fails
  • /t/951 still fails

Running the query… Ah! You nailed it!

 {"event_start"=>1601748000, "event_end"=>1601749800, "event_all_day"=>false, "event_timezone"=>"Etc/UTC", "event_rsvp"=>true, "event_going_max"=>100, "event_version"=>1, "event_going"=>[36, 50]}

Apparently the events plugin is skipped during merging. But that might be as well because it’s an older version we’re running. Tell me if I can help you test this case.

Thank you for solving this @gerhard!

1 Like
24

You can update the custom field of that topic and remove the non-existent ID. @angus might want to add support for user merging to his plugin.

2 Likes
25

For the record:

tcf = TopicCustomField.where(topic_id: problematic_topic_id)
c = tcf.last # in my case, YMMV
c.value = "[295,50]"
c.save
3 Likes
26

For posterity, in case that topic has multiple custom fields you should use:

tcf = TopicCustomField.where(plugin_name: 'discourse-events', topic_id: problematic_topic_id)
c = tcf.first
c.value = "[295,50]"
c.save

@hellekin I would migrate to 🗓 Discourse Event.

In fact, perhaps you could work with @fzngagan on a migration script from Events to Discourse Events? It’d be good to have a real case to work with there. Faiz, we should prioritise this, I’d like to formally deprecate Events.

3 Likes
27

@angus, @fzngagan: do you think I can change the plugin line in the container configuration, rebuild, and then take care of running the script? Since I also need to change the git repositories for who’s who and wizards, I could do it at once. OTOH we’re in the middle of a hackathon and if the problem is solved I can as well wait for a week.

1 Like
28

@hellekin
I recently fixed a similar issue where deleting a user was causing problems.

I love the idea of migrating to 🗓 Discourse Event . The question then is, do you wish to retain expired events, and how many upcoming events do you have?

29

@fzngagan @hellekin You can move the convo here to figure out the details: Create a migration script from Events to Discourse Events - Open Source - Pavilion

2 Likes
30

I’ll throw my hat in the ring for working on a migration script.

I’m a heavy user of Events. My Plugin for schools with children with behavioural difficulties creates 7 topics a day for 10+ children across multiple sites and has been running for over two years. Each topic represents a period of their school day and I need to be able to query by topic event date so I hope Discourse Events stores its data in a sympathetic place.

I’ll jump on the discussion you mentioned below.

1 Like
31

Great to see this wonderful cooperation. I love Discourse for that! Thanks everyone for all your efforts and involvement :heart:

2 Likes
32

Yes, we’d like to keep past events since they’re related to topics, especially the current ones related to the (still ongoing) ActivityPub conference 2020 – this week is the hackathon.
Apart from those we do not have many events, but will read about the migration – probably next week since this week is already more than full. Cheers! And what @aschrijver said: the Discourse community rocks!

2 Likes
33

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.