-
Notifications
You must be signed in to change notification settings - Fork 246
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Sync fails with 'too many SQL variables' in select #2559
Comments
@LZRS There seems to be a current limit (999) on the size of the variables that can be passed in an IN(..) query. One way to solve this is by splitting the full query to smaller sized queries (maybe inside a utility function) and joining the results in the end. Let me know if you would like to work on the issue. |
Cool. Yes, I'd like to work on the issue |
Assigned to you. |
Describe the bug
Currently testing with for a user with many patients, sometimes sync fails with error
Component
Engine library
Additional context
Checking the LocalEntity table for our app it has around 54k tasks, it might be related to the above query failing on sync upload
Would you like to work on the issue?
Please state if this issue should be assigned to you or who you think could help to solve this issue.
The text was updated successfully, but these errors were encountered: