Problem/Motivation

When creating an annual archive that is over 2GB, there is a fatal error trying to save the size.

archive:file_99: Error: 0 SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'size' at row 1: INSERT INTO "dda_archive_field_data" ("id", "vid", "langcode", "status", "name", "archive_type", "access_level", "dataset_id", "dataset_modified", "aggregate_of", "aggregate_on", "size", "revision_translation_affected", "user_id", "created", "changed", "default_langcode") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16); Array

The size in question is 2483955165. (10 chars)

Acceptance Criteria

Can save large archives without failing

Testing steps

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

Comments

swirt created an issue. See original summary.

swirt’s picture

Limit for int is 2147483647

Will have to change to big int.
https://www.drupal.org/docs/7/api/schema-api/data-types/integer

  • swirt committed d90328f3 on 1.0.x
    [#3556827] bug: Size column is too small for 10+ digits
    
swirt’s picture

Status: Active » Fixed

This is now accepting bigger files than 2.1GB sizes.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.

swirt’s picture

Status: Fixed » Closed (fixed)

Released with 1.0.0-beta2