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

After Sporadically occurred ' [Warning] InnoDB: Allocated tablespace ID 88 for test/t, old maximum was 0 ' , mariabackup.mdev-14447 test failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.5
    • N/A
    • Backup
    • None
    • CentOS 7.4

    Description

      After Sporadically occurred ' [Warning] InnoDB: Allocated tablespace ID 88 for test/t, old maximum was 0 ' , mariabackup.mdev-14447 test failed

      run mariadb mtr test mariabackup.mdev-14447 consecutively with --repeat option
      test failed after sporadically occurred
      [Warning] InnoDB: Allocated tablespace ID 88 for test/t, old maximum was 0

      mariabackup.mdev-14447                   [ pass ]  11260
      mariabackup.mdev-14447                   [ pass ]  11573
      mariabackup.mdev-14447                   [ pass ]  11727
      mariabackup.mdev-14447                   [ pass ]  11771
      mariabackup.mdev-14447                   [ pass ]  11580
      mariabackup.mdev-14447                   [ pass ]  11691
      mariabackup.mdev-14447                   [ pass ]  11855
      mariabackup.mdev-14447                   [ pass ]  11881
      mariabackup.mdev-14447                   [ pass ]  12058
      mariabackup.mdev-14447                   [ pass ]  12220
      mariabackup.mdev-14447                   [ pass ]  12051
      mariabackup.mdev-14447                   [ pass ]  12120
      mariabackup.mdev-14447                   [ pass ]  12325
      mariabackup.mdev-14447                   [ pass ]  13292
      mariabackup.mdev-14447                   [ pass ]  13232
      mariabackup.mdev-14447                   [ pass ]  11354
      mariabackup.mdev-14447                   [ pass ]  11620
      mariabackup.mdev-14447                   [ pass ]  12218
      mariabackup.mdev-14447                   [ pass ]  12977
      mariabackup.mdev-14447                   [ pass ]  11361
      mariabackup.mdev-14447                   [ pass ]  13461
      mariabackup.mdev-14447                   [ pass ]  11909
      mariabackup.mdev-14447                   [ pass ]  13410
      mariabackup.mdev-14447                   [ pass ]  13948
      mariabackup.mdev-14447                   [ pass ]  12512
      mariabackup.mdev-14447                   [ pass ]  12877
      mariabackup.mdev-14447                   [ pass ]  13470
      mariabackup.mdev-14447                   [ pass ]  14115
      mariabackup.mdev-14447                   [ pass ]  13678
      mariabackup.mdev-14447                   [ pass ]  13124
      mariabackup.mdev-14447                   [ pass ]  14078
      mariabackup.mdev-14447                   [ pass ]  13475
      mariabackup.mdev-14447                   [ pass ]  14636
      mariabackup.mdev-14447                   [ pass ]  14248
      mariabackup.mdev-14447                   [ pass ]  13628
      mariabackup.mdev-14447                   [ pass ]  14280
      mariabackup.mdev-14447                   [ pass ]  14168
      mariabackup.mdev-14447                   [ pass ]  13639
      mariabackup.mdev-14447                   [ pass ]  14179
      mariabackup.mdev-14447                   [ pass ]  13184
      mariabackup.mdev-14447                   [ pass ]  13566
      mariabackup.mdev-14447                   [ pass ]  15727
      mariabackup.mdev-14447                   [ pass ]  14819
      mariabackup.mdev-14447                   [ pass ]  16480
      mariabackup.mdev-14447                   [ pass ]  14831
      mariabackup.mdev-14447                   [ pass ]  15355
      mariabackup.mdev-14447                   [ pass ]  14137
      mariabackup.mdev-14447                   [ pass ]  14878
      mariabackup.mdev-14447                   [ pass ]  15809
      mariabackup.mdev-14447                   [ pass ]  15089
      mariabackup.mdev-14447                   [ pass ]  15553
      mariabackup.mdev-14447                   [ pass ]  14264
      mariabackup.mdev-14447                   [ pass ]  15258
      mariabackup.mdev-14447                   [ pass ]  15464
      mariabackup.mdev-14447                   [ pass ]  14297
      mariabackup.mdev-14447                   [ pass ]  16311
      mariabackup.mdev-14447                   [ pass ]  16461
      mariabackup.mdev-14447                   [ pass ]  15944
      mariabackup.mdev-14447                   [ pass ]  15192
      mariabackup.mdev-14447                   [ pass ]  17921
      mariabackup.mdev-14447                   [ pass ]  16306
      mariabackup.mdev-14447                   [ pass ]  16215
      mariabackup.mdev-14447                   [ pass ]  15849
      mariabackup.mdev-14447                   [ pass ]  16927
      mariabackup.mdev-14447                   [ pass ]  16877
      mariabackup.mdev-14447                   [ pass ]  18100
      mariabackup.mdev-14447                   [ pass ]  17755
      mariabackup.mdev-14447                   [ pass ]  15808
      mariabackup.mdev-14447                   [ pass ]  18084
      mariabackup.mdev-14447                   [ pass ]  16844
      mariabackup.mdev-14447                   [ pass ]  17581
      mariabackup.mdev-14447                   [ pass ]  18477
      mariabackup.mdev-14447                   [ pass ]  18265
      mariabackup.mdev-14447                   [ pass ]  18410
      mariabackup.mdev-14447                   [ pass ]  17125
      mariabackup.mdev-14447                   [ pass ]  17650
      mariabackup.mdev-14447                   [ pass ]  19241
      mariabackup.mdev-14447                   [ pass ]  17524
      mariabackup.mdev-14447                   [ pass ]  17026
      mariabackup.mdev-14447                   [ pass ]  18247
      mariabackup.mdev-14447                   [ pass ]  18581
      mariabackup.mdev-14447                   [ pass ]  18078
      mariabackup.mdev-14447                   [ pass ]  18341
      mariabackup.mdev-14447                   [ fail ]
              Test ended at 2018-03-22 14:09:56
       
      CURRENT_TEST: mariabackup.mdev-14447
      180322 14:09:53 Connecting to MySQL server host: localhost, user: root, password: set, port: 16000, socket: /usr/share/mysql-test/var/tmp/mysqld.1.sock
      Using server version 10.3.5-MariaDB-log
      /usr/bin/mariabackup based on MariaDB server 10.3.5-MariaDB Linux (x86_64)
      incremental backup from 3500846409 is enabled.
      mariabackup: uses posix_fadvise().
      mariabackup: cd to /usr/share/mysql-test/var/mysqld.1/data/
      mariabackup: open files limit requested 1024, set to 1024
      mariabackup: using the following InnoDB configuration:
      mariabackup:   innodb_data_home_dir = .
      mariabackup:   innodb_data_file_path = ibdata_first:3M;ibdata_second:1M:autoextend
      mariabackup:   innodb_log_group_home_dir = ./
      2018-03-22 14:09:53 0 [Note] InnoDB: Number of pools: 1
      180322 14:09:53 >> log scanned up to (3542731032)
      mariabackup: Generating a list of tablespaces
      2018-03-22 14:09:53 0 [Warning] InnoDB: Allocated tablespace ID 88 for test/t, old maximum was 0
      mariabackup: using the full scan for incremental backup
      180322 14:09:53 [01] Copying ./ibdata_first to /usr/share/mysql-test/var/tmp/backup_inc1/ibdata_first.delta
      180322 14:09:53 [01]        ...done
      180322 14:09:53 [01] Copying ./ibdata_second to /usr/share/mysql-test/var/tmp/backup_inc1/ibdata_second.delta
      180322 14:09:54 >> log scanned up to (3542731032)
      180322 14:09:55 [01]        ...done
      180322 14:09:55 [01] Copying ./test/t.ibd to /usr/share/mysql-test/var/tmp/backup_inc1/test/t.ibd.delta
      /usr/bin/mariabackup: Error writing file '/usr/share/mysql-test/var/tmp/backup_inc1/test/t.ibd.delta' (Errcode: 28 "No space left on device")
      [01] mariabackup: Error: xtrabackup_copy_datafile() failed.
      [01] mariabackup: Error: failed to copy datafile.
      mysqltest: At line 17: exec of '/usr/bin/mariabackup --defaults-file=/usr/share/mysql-test/var/my.cnf  --backup --target-dir=/usr/share/mysql-test/var/tmp/backup_inc1 --incremental-basedir=/usr/share/mysql-test/var/tmp/backup' failed, error: 256, status: 1, errno: 11
      Output from before failure:
      count(*)
      100000
       
       
       
      The result from queries just before the failure was:
      call mtr.add_suppression("InnoDB: New log files created");
      CREATE TABLE t(a varchar(40) PRIMARY KEY, b varchar(40), c varchar(40), d varchar(40), index(b,c,d)) ENGINE INNODB;
      # Create full backup , modify table, then create incremental/differential backup
      BEGIN;
      INSERT INTO t select uuid(), uuid(), uuid(), uuid() from seq_1_to_100000;
      COMMIT;
      SELECT count(*) FROM t;
      count(*)
      100000
       
       - saving '/usr/share/mysql-test/var/log/mariabackup.mdev-14447/' to '/usr/share/mysql-test/var/log/mariabackup.mdev-14447/'
      mariabackup.mdev-14447                   [ pass ]  11901
      mariabackup.mdev-14447                   [ pass ]  11553
      mariabackup.mdev-14447                   [ pass ]  11741
      mariabackup.mdev-14447                   [ pass ]  11701
      mariabackup.mdev-14447                   [ pass ]  11749
      mariabackup.mdev-14447                   [ pass ]  11758
      mariabackup.mdev-14447                   [ pass ]  12043
      mariabackup.mdev-14447                   [ pass ]  11379
      mariabackup.mdev-14447                   [ pass ]  12032
      mariabackup.mdev-14447                   [ pass ]  12005
      mariabackup.mdev-14447                   [ pass ]  12150
      mariabackup.mdev-14447                   [ pass ]  12007
      mariabackup.mdev-14447                   [ pass ]  12230
      mariabackup.mdev-14447                   [ pass ]  12404
      mariabackup.mdev-14447                   [ pass ]  12182
      mariabackup.mdev-14447                   [ pass ]  11410
      
      

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.