Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7754

innodb assert "array->n_elems < array->max_elems" on a huge blob update

    Details

      Description

      InnoDB and XtraDB crash on the following test case:

      a.opt

      --max-allowed-packet=128M
      --innodb-log-file-size=210M

      a.test

      source include/have_innodb.inc;
      create table foo (id varchar(37) not null, content longblob) engine=INNODB;
      insert into foo (id, content) values('xyz', '');
      update foo set content=repeat('a', 43941888) where id='xyz';

      Note that if the blob gets larger (45000000) or innodb-log-file-size gets smaller (209M) then there is no crash, instead there's an error InnoDB: The total blob data length (44999232) is greater than 10% of the total redo log size (440401920). Please increase total redo log size.

        Attachments

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              serg Sergei Golubchik
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: