Value is out of range for type integer #26

New Issue

pendulum · 2020-12-30T02:41:02Z

pendulum commented

2020-12-30 02:41:02 +00:00

insert into "media" ("comment", "credit", "entropy", "hash", "height", "id", "index", "lazy", "mime", "path", "scraper", "sharpness", "size", "s
ource", "source_page", "thumbnail", "width") values (DEFAULT, DEFAULT, DEFAULT, $1, DEFAULT, $2 ...) RETURNING *; - value "5016694989" is out of range for type integer

``` insert into "media" ("comment", "credit", "entropy", "hash", "height", "id", "index", "lazy", "mime", "path", "scraper", "sharpness", "size", "s ource", "source_page", "thumbnail", "width") values (DEFAULT, DEFAULT, DEFAULT, $1, DEFAULT, $2 ...) RETURNING *; - value "5016694989" is out of range for type integer ```

pendulum added the

bug

label 2020-12-30 02:41:02 +00:00

pendulum commented

2021-01-01 02:38:25 +00:00

size column in media was an integer limited to a maximum positive value of 2147483647. Kelly Madison websites were hosting a full scene instead of trailers, which was 5GB or 5016694989 bytes in size, overflowing the field.

The size column is now a bigint, and further measures should probably be taken to limit the size of media files that can be scraped, in order to save on storage space.

`size` column in `media` was an `integer` limited to a maximum positive value of `2147483647`. Kelly Madison websites were hosting a full scene instead of trailers, which was 5GB or `5016694989` bytes in size, overflowing the field. The `size` column is now a `bigint`, and further measures should probably be taken to limit the size of media files that can be scraped, in order to save on storage space.

pendulum closed this issue

2021-01-01 02:38:27 +00:00

Sign in to join this conversation.