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

    XMLWordPrintable

    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: