search

biigle / core

:large_blue_circle: Application core of BIIGLE
https://biigle.de
GNU General Public License v3.0
11 stars 16 forks source link

Chunk clone volume filter query #848

Closed mzur closed 2 weeks ago

mzur commented 3 weeks ago

There was this error:

number of parameters must be between 0 and 65535 (Connection: pgsql, SQL: select * from "image_annotations" where "image_annotations"."image_id" in (834986, ...

In the CloneImagesOrVideos job. I think this is because someone actually selected more then 65k images here. Update the job so the query also chunks the filtered images.

mzur commented 2 weeks ago

It is probably a different location than linked above. Here is more of the failing query:

select * from "image_annotations" where "image_annotations"."image_id" in (...) and "id" in (...