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

innodb.log_data_file_size failed in buildbot, server failed to start

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/5966/steps/test/logs/stdio
      http://buildbot.askmonty.org/buildbot/builders/win32-debug/builds/5966/steps/test/logs/mysqld.1.err.4

      innodb.log_data_file_size '4k,innodb'    w4 [ fail ]
              Test ended at 2017-10-25 23:14:18
       
      CURRENT_TEST: innodb.log_data_file_size
       
       
      Failed to start mysqld.1
      mysqltest failed but provided no output
      The result from queries just before the failure was:
      < snip >
      SET GLOBAL innodb_file_per_table=0;
      CREATE TABLE t(a INT)ENGINE=InnoDB;
      SET GLOBAL innodb_file_per_table=1;
      CREATE TABLE ibd4(a INT UNIQUE)ENGINE=InnoDB;
      CREATE TABLE ibd4f(a INT UNIQUE)ENGINE=InnoDB;
      CREATE TABLE ibd5(a INT UNIQUE, b INT UNIQUE)ENGINE=InnoDB;
      # Kill the server
      DROP TABLE t,ibd4,ibd4f,ibd5;
      

      CURRENT_TEST: innodb.log_data_file_size
      2017-10-25 23:10:36 3584 [Note] D:/win32-debug/build/sql//Debug/mysqld.exe (mysqld 10.2.10-MariaDB-debug-log) starting as process 4744 ...
      2017-10-25 23:10:36 3584 [Note] Plugin 'partition' is disabled.
      2017-10-25 23:10:36 3584 [Note] InnoDB: innodb_page_size=4096
      2017-10-25 23:10:36 3584 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2017-10-25 23:10:36 3584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2017-10-25 23:10:36 3584 [Note] InnoDB: Uses event mutexes
      2017-10-25 23:10:36 3584 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-10-25 23:10:36 3584 [Note] InnoDB: Number of pools: 1
      2017-10-25 23:10:36 3584 [Note] InnoDB: Using generic crc32 instructions
      2017-10-25 23:10:36 3584 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
      2017-10-25 23:10:36 3584 [Note] InnoDB: Completed initialization of buffer pool
      2017-10-25 23:10:36 3584 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-10-25 23:10:36 3584 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2017-10-25 23:10:36 3584 [Note] InnoDB: Creating shared tablespace for temporary tables
      2017-10-25 23:10:36 3584 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2017-10-25 23:10:36 3584 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2017-10-25 23:10:37 3584 [Note] InnoDB: Waiting for purge to start
      2017-10-25 23:10:37 3584 [Note] InnoDB: 5.7.20 started; log sequence number 730979
      2017-10-25 23:10:37 2604 [Note] InnoDB: Loading buffer pool(s) from D:\win32-debug\build\mysql-test\var\4\mysqld.1\data\ib_buffer_pool
      2017-10-25 23:10:37 3584 [Note] Plugin 'SEQUENCE' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_MUTEXES' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_CMP' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'FEEDBACK' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
      2017-10-25 23:10:37 3584 [Note] Plugin 'user_variables' is disabled.
      2017-10-25 23:10:37 2604 [Note] InnoDB: Buffer pool(s) load completed at 171025 23:10:37
      CURRENT_TEST: innodb.log_data_file_size
      2017-10-25 23:14:28 516 [Note] D:/win32-debug/build/sql//Debug/mysqld.exe (mysqld 10.2.10-MariaDB-debug-log) starting as process 3556 ...
      2017-10-25 23:14:28 516 [Note] Plugin 'partition' is disabled.
      2017-10-25 23:14:28 516 [Note] InnoDB: innodb_page_size=4096
      2017-10-25 23:14:28 516 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2017-10-25 23:14:28 516 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2017-10-25 23:14:28 516 [Note] InnoDB: Uses event mutexes
      2017-10-25 23:14:28 516 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-10-25 23:14:28 516 [Note] InnoDB: Number of pools: 1
      2017-10-25 23:14:28 516 [Note] InnoDB: Using generic crc32 instructions
      2017-10-25 23:14:28 516 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
      2017-10-25 23:14:28 516 [Note] InnoDB: Completed initialization of buffer pool
      2017-10-25 23:14:29 516 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-10-25 23:14:29 516 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2017-10-25 23:14:29 516 [Note] InnoDB: Creating shared tablespace for temporary tables
      2017-10-25 23:14:29 516 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2017-10-25 23:14:29 516 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2017-10-25 23:14:29 516 [Note] InnoDB: Waiting for purge to start
      2017-10-25 23:14:29 516 [Note] InnoDB: 5.7.20 started; log sequence number 730979
      2017-10-25 23:14:30 796 [Note] InnoDB: Loading buffer pool(s) from D:\win32-debug\build\mysql-test\var\4\mysqld.1\data\ib_buffer_pool
      2017-10-25 23:14:30 516 [Note] Plugin 'SEQUENCE' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_MUTEXES' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_CMP' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'FEEDBACK' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'user_variables' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
      2017-10-25 23:14:30 516 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
      2017-10-25 23:14:30 516 [Warning] D:/win32-debug/build/sql//Debug/mysqld.exe: unknown option '--loose-pam-debug'
      2017-10-25 23:14:30 516 [Note] Server socket created on IP: '::'.
      2017-10-25 23:14:30 796 [Note] InnoDB: Buffer pool(s) load completed at 171025 23:14:30
      2017-10-25 23:14:30 516 [Note] Reading of all Master_info entries succeded
      2017-10-25 23:14:30 516 [Note] Added new Master_info '' to hash table
      2017-10-25 23:14:30 516 [Note] D:/win32-debug/build/sql//Debug/mysqld.exe: ready for connections.
      Version: '10.2.10-MariaDB-debug-log'  socket: ''  port: 16140  Source distribution
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            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.