This bug seems to be fixed a while back from this post. Custom_fields simultaneous save with json becomes an array Unfortunately, I am now dealing with simultaneous endpoints being called that update the user custom_fields at the same time, making the values set by me as :text to turn into arrays. [3 endpoints called and setting custom_field to array instead of string] Any help? This blocks my entire project right now… Running into this problem on 2.5.0.beta7 in local development. Is there any way I can make a lock on the db until the values are saved, in this situation?

Could this be the issue i’m facing ? Differences between transactions and locking - makandra dev Note that when two transaction run concurrently in two threads, each thread doesn’t see the other transaction’s changes until they are committed successfully. It does however see its own changes (this is a dumbed-down explanation, reality is much more complicated).

def self.cast_custom_field(key, value, types, return_array = true) Shows normal values, which makes me think multiple rows were created.

[图片] Inconsistent behaviour in UserUpdater class Development Ok, so this one is merged. This should have fixed it. It was a long standing bug.

Yes I saw it :frowning: Unfortunately I am now faced with updating sensitive data potentially at the same time. I think this happens because I am doing it via endpoints, but this is the only way I can do it and I do no have control over the calls. It can be 1 call, it can be 10. I can try to minimize the calls from the app and bulk send some data, the problem is there are 2 sources for the calls: mobile and external services. Payment data is involved :frowning:

This sounds like the existing behaviour of custom fields and not a regression. There are a few ways to fix it: You can add a unique index on the custom field (name, user_id) You can surround your code with a DistributedMutex You can use a table design rather than custom fields

something like this? Seems to work. DistributedMutex.synchronize("user_data_update_#{user.id}") do user.save_custom_fields(true) end

On top of this, I will change the logic to run the calls one by one instead of all at once, hopefully preventing any issues. Thanks guys @eviltrout @fzngagan

Custom_fields 更新同步导致值转为数组

开发

fzngagan (Faizaan Gagan) 2020 年8 月 25 日 16:09 4

这应该已经修复了。这是一个长期存在的 bug。

话题		回复	浏览量
Custom_fields simultaneous save with json becomes an array Bug	3	1261	2017 年11 月 17 日
Custom fields concurrency issue Development	0	99	2025 年5 月 6 日
Inconsistent behaviour in UserUpdater class Development	4	923	2020 年8 月 25 日
[API] data loss caused by changed behaviour of custom user_field update Bug	2	847	2017 年12 月 20 日
Custom field casting affected by recent update? Development	5	1305	2020 年8 月 25 日

Custom_fields 更新同步导致值转为数组

相关话题