Album size statistics recompute fails with SQLSTATE[22003] 1264 "Out of range" when an album's total size_original exceeds ~2.14 GB (2^31)

[dnouy]

Lychee version

v7.6.3

Did you check the latest Lychee version?

Yes, I did

Which PHP version are you using?

PHP 8.5

Detailed description of the problem

Importing/uploading photos into an album whose cumulative original size exceeds 2,147,483,647 bytes (2^31 - 1, ~2.14 GB) fails. The album size statistics recompute throws:

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'size_original' at row 1

It originates in App\Jobs\RecomputeAlbumSizeJob -> AlbumSizeStatistics::save() and surfaces as "ModelDBException: Updating album size statistics failed". It has persisted across several versions and is fully reproducible.

Why this is unexpected:

• The column album_size_statistics.size_original is bigint(20) unsigned (confirmed via SHOW COLUMNS), so ~2.15e9 is trivially in range.
• Running the EXACT same UPDATE manually in the DB succeeds (1 row affected, no error):
  UPDATE album_size_statistics SET size_original = 2155847859 WHERE album_id = '';
• @@sql_mode is EMPTY (not strict mode).
• PHP is 64-bit (PHP_INT_SIZE = 8), so no native PHP integer overflow.
• The underlying data is valid: summing size_variants.filesize for the album gives a correct positive total (~2,157,654,325 over 530 photos), with no negative/aberrant values.

Suspected cause: a signed 32-bit cast or incorrect parameter binding type in the recompute persistence path, triggered once the summed value crosses 2^31. The value is likely bound/cast as a signed INT and becomes negative, which MySQL rejects against an unsigned column with error 1264. This only ever fails via the recompute job, and only for the one album exceeding 2^31 bytes.

Workaround that confirms the propagation path is involved: importing into a top-level album (no parent) succeeds, then moving the photos into the target sub-album also works. Importing directly into a sub-album fails. This avoids the parent-propagation recompute that triggers the error.

Steps to reproduce the issue

1. Create an album and upload enough high-resolution originals for the album's cumulative size_original to exceed 2,147,483,647 bytes (~2.14 GB).
2. The recompute job triggered on upload fails with SQLSTATE[22003] 1264 on column size_original.
3. Running php artisan lychee:recompute-album-sizes <album_id> fails identically.

Diagnostics [REQUIRED]

Diagnostics
Auto-diagnostic
info
Hash: 6b1fb0abc6d2d6e1—423bca7c00678d5e
3550 files and 15242 vendor files
info
Full directory permission check is disabled
warning
Pictures that are rotated lose their metadata! Please install Imagick to avoid that.
info
Latest version of PHP is 8.5
warning
Default timezone not properly set; you might experience strange results when importing photos without explicit EXIF timezone
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 211.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 238.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 242.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 247.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 249.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 263.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 268.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 279.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 280.jpg in 1 - Nice
error
Photo without Original found -- 2026-01-31 - Mariage A+J Nice - 319.jpg in 1 - Nice
error
Photo without Original found -- mariage de Romain et Juliet (375).jpg in Mariage de Juliet et Romain
error
Photo without Original found -- mariage de Romain et Juliet (381).jpg in Mariage de Juliet et Romain
error
Photo without Original found -- mariage de Romain et Juliet (387).jpg in Mariage de Juliet et Romain
error
Photo without Original found -- mariage de Romain et Juliet (437).jpg in Mariage de Juliet et Romain
info
Found 6 small that could be generated.
You can use php artisan lychee:generate_thumbs small 6 to generate them.
info
Found 9 small2x that could be generated.
You can use php artisan lychee:generate_thumbs small2x 9 to generate them.
info
Found 9 medium that could be generated.
You can use php artisan lychee:generate_thumbs medium 9 to generate them.
info
Found 12 medium2x that could be generated.
You can use php artisan lychee:generate_thumbs medium2x 12 to generate them.
info
Found 13 placeholder images that have not been encoded.
You can use php artisan lychee:encode_placeholders 13 to encode them.
info
Found 7736 placeholders that could be generated.
You can use php artisan lychee:generate_thumbs placeholder 7736 to generate them.
info
Imagick is not enabled. Thumbs will not be created for pdf files.
Informations
Lychee Version (release): 7.6.3
DB Version: 7.6.3
Docker: false
composer install: --no-dev
APP_ENV: production
APP_DEBUG: false
APP_URL: set
APP_DIR: set
LOG_VIEWER_ENABLED: false
System: Linux
PHP Version: 8.4.21
PHP User agent: Lychee/6 (https://lycheeorg.dev/)
Timezone: UTC
Max uploaded file size: 512M
Max post size: 512M
Chunk size: 51.20 MB
Max execution time: 600
MySQL Version: 11.4.12-MariaDB
exec() Available: yes
Imagick Available: -
Imagick Enabled: yes
Imagick Version: -
GD Version: 2.3.3
Number of foreign key: 45 found.

Espace
Configuration
version: 070603
check_for_updates: 1
sorting_photos_col: taken_at
sorting_photos_order: ASC
sorting_albums_col: max_taken_at
sorting_albums_order: ASC
imagick: 1
skip_duplicates: 1
small_max_width: 0
small_max_height: 360
medium_max_width: 1920
medium_max_height: 1080
lang: fr
image_overlay_type: date
default_license: reserved
compression_quality: 90
grants_full_photo_access: 1
delete_imported: 0
mod_frame_enabled: 0
mod_frame_refresh: 30
thumb_2x: 1
small_2x: 1
medium_2x: 1
landing_page_enable: 0
search_public: 0
hide_version_number: 0
recent_age: 1
grants_download: 0
photos_wraparound: 0
map_display: 0
zip64: 1
map_display_public: 0
map_provider: OpenStreetMap.org
map_include_subalbums: 0
update_check_every_days: 1
has_exiftool: 0
share_button_visible: 0
import_via_symlink: 0
has_ffmpeg: 0
location_decoding: 0
location_decoding_timeout: 30
location_show: 1
location_show_public: 0
rss_enable: 0
rss_recent_days: 7
rss_max_items: 100
prefer_available_xmp_metadata: 0
editor_enabled: 1
lossless_optimization: 0
local_takestamp_video_formats: .avi|.mov
log_max_num_line: 1000
unlock_password_photos_with_url_param: 0
nsfw_visible: 1
nsfw_blur: 0
nsfw_warning: 0
nsfw_warning_admin: 0
nsfw_banner_override:
map_display_direction: 1
album_subtitle_type: takedate
upload_processing_limit: 4
new_photos_notification: 0
zip_deflate_level: 6
default_album_protection: private
album_decoration: layers
album_decoration_orientation: row
allow_username_change: 0
auto_fix_orientation: 1
random_album_id: highlighted
use_last_modified_date_when_no_exif_date: 0
layout: masonry
date_format_photo_thumb: M j, Y, g:i:s A e
date_format_photo_overlay: M j, Y, g:i:s A e
date_format_sidebar_uploaded: M j, Y, g:i:s A e
date_format_sidebar_taken_at: M j, Y, g:i:s A e
date_format_hero_min_max: F Y
date_format_hero_created_at: M j, Y, g:i:s A T
date_format_album_thumb: M Y
upload_chunk_size: 0
nsfw_banner_blur_backdrop: 0
search_pagination_limit: 300
search_minimum_length_required: 4
photo_layout_justified_row_height: 320
photo_layout_masonry_column_width: 300
photo_layout_grid_column_width: 250
photo_layout_square_column_width: 200
photo_layout_gap: 12
display_thumb_album_overlay: always
display_thumb_photo_overlay: hover
default_album_thumb_aspect_ratio: 1/1
use_album_compact_header: 0
back_button_enabled: 0
back_button_text: Return to Home
SA_random_thumbs: 0
login_required: 0
enable_unsorted: 1
enable_highlighted: 0
enable_recent: 0
enable_on_this_day: 0
login_required_root_only: 1
dark_mode_enabled: 1
low_quality_image_placeholder: 1
show_keybinding_help_popup: 1
show_keybinding_help_button: 1
disable_se_call_for_actions: 1
enable_se_preview: 0
slideshow_timeout: 5
keep_original_untouched: 1
timeline_photos_enabled: 1
timeline_photos_public: 0
timeline_photos_granularity: day
timeline_photos_order: taken_at
timeline_photos_layout: square
timeline_photos_pagination_limit: 200
timeline_albums_enabled: 1
timeline_albums_public: 0
timeline_albums_granularity: year
timeline_left_border_enabled: 1
timeline_photo_date_format_year: Y
timeline_photo_date_format_month: M Y
timeline_photo_date_format_day: j M Y
timeline_photo_date_format_hour: g:i
timeline_album_date_format_year: Y
timeline_album_date_format_month: M Y
timeline_album_date_format_day: j M
hide_nsfw_in_smart_albums: 1
hide_nsfw_in_frame: 1
hide_nsfw_in_map: 1
hide_nsfw_in_search: 1
search_photos_layout: square
hide_nsfw_in_rss: 1
hide_nsfw_in_timeline: 1
number_albums_per_row_mobile: 3
cache_enabled: 0
cache_ttl: 86400
low_number_of_shoots_per_day: 10
medium_number_of_shoots_per_day: 50
high_number_of_shoots_per_day: 100
maintenance_processing_limit: 5000
disable_recursive_permission_check: 1
exif_disabled_for_all: 0
file_name_hidden: 0
default_old_settings: 0
default_expert_settings: 1
default_all_settings: 0
client_side_favourite_enabled: 0
disable_thumb_download: 1
disable_thumb2x_download: 1
disable_small_download: 0
disable_small2x_download: 0
disable_medium_download: 0
disable_medium2x_download: 0
temporary_image_link_enabled: 1
temporary_image_link_when_logged_in: 0
temporary_image_link_when_admin: 1
temporary_image_link_life_in_seconds: 86400
secure_image_link_enabled: 0
SA_override_visibility: 0
TA_override_visibility: 0
enable_colour_extractions: 0
colour_extraction_driver: farzai
home_page_default: gallery
timeline_page_enabled: 1
timeline_quick_access_date_format_year: Y
timeline_quick_access_date_format_month: M
timeline_quick_access_date_format_day: j M
timeline_quick_access_date_format_hour: h M, g:i
flow_enabled: 1
flow_public: 0
flow_base:
flow_max_items: 10
flow_strategy: auto
flow_include_sub_albums: 0
flow_include_photos_from_children: 0
flow_open_album_on_click: 0
flow_display_open_album_button: 0
flow_highlight_first_picture: 1
flow_min_max_enabled: 1
flow_display_statistics: 1
flow_compact_mode_enabled: 1
flow_image_header_enabled: 1
flow_image_header_cover: cover
flow_image_header_height: 24
flow_carousel_enabled: 1
flow_carousel_height: 6
date_format_flow_published: M j, Y, g:i:s A e
date_format_flow_min_max: F Y
flow_blur_nsfw_enabled: 1
hide_nsfw_in_flow: 1
skip_duplicates_early: 1
sync_delete_missing_photos: 0
sync_delete_missing_albums: 0
sync_dry_run: 1
gallery_header_enabled: 0
gallery_header_logged_in_enabled: 0
gallery_header:
gallery_header_bar_transparent: 1
gallery_header_bar_gradient: 1
import_via_url_forbidden_localhost: 1
import_via_url_forbidden_local_ip: 1
import_via_url_require_https: 1
import_via_url_forbidden_ports: 1
details_links_enabled: 1
details_links_public: 0
is_scroll_to_navigate_photos_enabled: 1
is_swipe_vertically_to_go_back_enabled: 1
photo_thumb_tags_enabled: 0
hide_nsfw_in_tag_albums: 1
hide_nsfw_in_tag_listing: 1
sorting_pinned_albums_col: max_taken_at
sorting_pinned_albums_order: DESC
copyright_text:
watermark_enabled: 0
watermark_photo_id:
watermark_public: 1
watermark_logged_in_users_enabled: 0
renamer_enabled: 0
renamer_enforced: 0
renamer_enforced_before: 0
renamer_enforced_after: 0
renamer_photo_title_enabled: 1
renamer_album_title_enabled: 1
extract_zip_on_upload: 1
webshop_currency: EUR
webshop_default_description: No description provided.
webshop_allow_guest_checkout: 1
webshop_terms_url:
webshop_privacy_url:
webshop_default_price_cents: 0
webshop_default_license: personal
webshop_default_size: medium
enable_untagged: 1
photos_pagination_limit: 500
deduplicate_pinned_albums: 0
desktop_dock_full_transparency_enabled: 0
mobile_dock_full_transparency_enabled: 0
import_via_url_block_redirect: 1
enable_smart_album_per_owner: 0
rating_enabled: 0
rating_public: 0
rating_show_only_when_user_rated: 0
rating_show_avg_in_details: 0
rating_photo_view_mode: hover
rating_show_avg_in_photo_view: 0
rating_album_view_mode: hover
rating_show_avg_in_album_view: 0
album_layout: grid
albums_per_page: 30
albums_pagination_ui_mode: infinite_scroll
albums_infinite_scroll_threshold: 10
photos_per_page: 1500
photos_pagination_ui_mode: infinite_scroll
photos_infinite_scroll_threshold: 10
enable_propagate_unlock_option: 0
shared_albums_visibility_default: show
enable_unrated: 0
enable_1_star: 0
enable_2_stars: 0
enable_3_stars: 0
enable_4_stars: 1
enable_5_stars: 1
enable_best_pictures: 1
best_pictures_count: 100
enable_photo_details_always_open: 0
enable_my_rated_pictures: 1
enable_my_best_pictures: 1
my_best_pictures_count: 50
gps_coordinate_display: 1
gps_coordinate_display_public: 0
photos_star_visibility: editor
album_enhanced_display_enabled: 0
album_header_size: half_screen
album_header_landing_title_enabled: 0
watermark_optout_disabled: 0
raw_download_enabled: 0
contact_form_enabled: 0
contact_form_security_question:
contact_form_security_answer:
contact_form_custom_consent_required: 0
contact_form_custom_privacy_url:
contact_form_header:
contact_form_headline:
contact_form_contact_method:
contact_form_message_label:
contact_form_message_answer:
contact_form_custom_consent_text:
contact_form_custom_submit_button_text:
contact_form_thank_you_message:
landing_background_landscape_mode: static
landing_background_portrait_mode: static
search_colour_distance: 30
ai_vision_enabled: 0
ai_vision_face_enabled: 0
ai_vision_face_permission_mode: restricted
ai_vision_face_selfie_confidence_threshold: 0.8
ai_vision_face_person_is_searchable_default: 1
ai_vision_face_allow_user_claim: 1
ai_vision_face_overlay_enabled: 1
ai_vision_face_overlay_default_visibility: visible
default_user_trust_level: trusted
guest_upload_trust_level: check
download_archive_chunked: 0
download_archive_chunk_size: 300
download_archive_drop_extension_enabled: 1
is_embed_enabled: 1
use_admin_dashboard: 1
timeline_albums_root_enabled: 1
disable_swipe_effect: 0
close_upload_on_success: 0
folder_upload_enabled: 1
folder_upload_max_depth: 5
site_logo:
landing_logo:
landing_header_logo:
ai_vision_face_recognition_warning: 1

Browser & System [REQUIRED]

• Lychee: v7.6.3 (traditional install, o2switch shared hosting via Softaculous - NOT Docker)
• PHP: 8.5, 64-bit (PHP_INT_SIZE = 8)
• Database: MariaDB (shared hosting), @@sql_mode empty
• Relevant column: album_size_statistics.size_original = bigint(20) unsigned
• OS / Browser: macOS + Google Chrome / Windows 10 + Google Chrome

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I understand my bug report will be removed if I haven't met the criteria above.
• I understand that if I am requested to provide more information, I must do so within 14 days or the bug report will be closed.

[ildyria]

Hi,

I will investigate that one, thank you for the heads up.