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

innodb.innodb-page_compression_zip fails in buildbot

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6563/steps/test/logs/stdio

      innodb.innodb-page_compression_zip 'innodb_plugin' [ fail ]
              Test ended at 2014-11-22 12:29:52
       
      CURRENT_TEST: innodb.innodb-page_compression_zip
      mysqltest: At line 98: query 'update innodb_page_compressed5 set c1 = c1 + 1' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      < snip >
      show create table innodb_normal;
      Table	Create Table
      innodb_normal	CREATE TABLE `innodb_normal` (
        `c1` int(11) DEFAULT NULL,
        `b` char(20) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`=1 `page_compression_level`=8
      alter table innodb_compressed row_format=default page_compressed=1 page_compression_level=8 key_block_size=0;
      show warnings;
      Level	Code	Message
      show create table innodb_compressed;
      Table	Create Table
      innodb_compressed	CREATE TABLE `innodb_compressed` (
        `c1` int(11) DEFAULT NULL,
        `b` char(20) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `page_compressed`=1 `page_compression_level`=8
      update innodb_page_compressed1 set c1 = c1 + 1;
      update innodb_page_compressed2 set c1 = c1 + 1;
      update innodb_page_compressed3 set c1 = c1 + 1;
      update innodb_page_compressed4 set c1 = c1 + 1;
      update innodb_page_compressed5 set c1 = c1 + 1;
       
      More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\innodb-page_compression_zip.log
       
       
      Server [mysqld.1 - pid: 331236, winpid: 331236, exit: 256] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      141122 12:29:23 [Note] Plugin 'XTRADB_READ_VIEW' is disabled.
      141122 12:29:23 [Note] Plugin 'XTRADB_INTERNAL_HASH_TABLES' is disabled.
      141122 12:29:23 [Note] Plugin 'XTRADB_RSEG' is disabled.
      141122 12:29:23 [Note] Plugin 'FEEDBACK' is disabled.
      141122 12:29:23 [Note] Plugin 'partition' is disabled.
      141122 12:29:23 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      141122 12:29:23 [Note] InnoDB: The InnoDB memory heap is disabled
      141122 12:29:23 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      141122 12:29:23 [Note] InnoDB: Memory barrier is not used
      141122 12:29:23 [Note] InnoDB: Compressed tables use zlib 1.2.3
      141122 12:29:23 [Note] InnoDB: Not using CPU crc32 instructions
      141122 12:29:23 [Note] InnoDB: Initializing buffer pool, size = 8.0M
      141122 12:29:23 [Note] InnoDB: Completed initialization of buffer pool
      2014-11-22 12:29:23 50e00 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
      2014-11-22 12:29:23 50e00 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
      InnoDB: Note: File system for file .\ibdata1 has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\ibdata1
      InnoDB: Note: File system for file .\ib_logfile0 has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\ib_logfile0
      InnoDB: Note: File system for file .\ib_logfile1 has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\ib_logfile1
      141122 12:29:23 [Note] InnoDB: Highest supported file format is Barracuda.
      141122 12:29:25 [Note] InnoDB: 128 rollback segment(s) are active.
      141122 12:29:25 [Note] InnoDB: Waiting for purge to start
      141122 12:29:25 [Note] InnoDB: 5.6.20 started; log sequence number 1629473
      141122 12:29:25 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
      141122 12:29:25 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
      141122 12:29:25 [Warning] C:/bzr/bb-win32/win32-debug2/build/sql//Debug/mysqld.exe: unknown option '--loose-skip-plugin-innodb-changed-pages'
      141122 12:29:25 [Note] Server socket created on IP: '::'.
      141122 12:29:25 [Note] Event Scheduler: Loaded 0 events
      141122 12:29:25 [Note] C:/bzr/bb-win32/win32-debug2/build/sql//Debug/mysqld.exe: ready for connections.
      Version: '10.1.2-MariaDB-debug-log'  socket: ''  port: 16000  Source distribution
      InnoDB: Note: File system for file .\mysql\innodb_index_stats.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\mysql\innodb_index_stats.ibd
      InnoDB: Note: File system for file .\mysql\innodb_table_stats.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\mysql\innodb_table_stats.ibd
      InnoDB: Note: File system for file .\test\innodb_compressed.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_compressed.ibd
      InnoDB: Note: File system for file .\test\innodb_normal.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_normal.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed1.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed1.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed2.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed2.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed3.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed3.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed4.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed4.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed5.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed5.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed6.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed6.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed7.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed7.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed8.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed8.ibd
      InnoDB: Note: File system for file .\test\innodb_page_compressed9.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\innodb_page_compressed9.ibd
      InnoDB: Note: File system for file .\test\#sql-50e00_3.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\#sql-50e00_3.ibd
      InnoDB: Note: File system for file .\test\#sql-50e00_3.ibd has file block size 0 not supported for page_size 16384
      InnoDB: Note: Using file block size 512 for file .\test\#sql-50e00_3.ibd
      141122 12:29:52 [ERROR] InnoDB: File .\test\innodb_page_compressed1.ibd: 'Windows aio' returned OS error 0. Cannot continue operation
       InnoDB: Operation Windows aio to file C:\bzr\bb-win32\win32-debug2\build\storage\innobase\os\os0file.cc and at line 5268

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/861/steps/test/logs/stdio

      innodb.innodb-page_compression_zip 'innodb_plugin' w4 [ fail ]
              Test ended at 2014-11-23 07:25:12
       
      CURRENT_TEST: innodb.innodb-page_compression_tables
      mysqltest: At line 72: query 'update innodb_compact set c1 = c1 + 1' failed: 2013: Lost connection to MySQL server during query
       
      ...
       
      /lib64/libpthread.so.0[0x2ba9fd89e4c0]
      /lib64/libc.so.6(gsignal+0x35)[0x2ba9fe8a6215]
      /lib64/libc.so.6(abort+0x110)[0x2ba9fe8a7cc0]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab00d65]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2d35]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2ef1]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2f73]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab35225]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab36cdd]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab3b71f]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab95a5a]
      sql/handler.cc:2520(handler::ha_open(TABLE*, char const*, int, unsigned int))[0x7449fe]
      sql/table.cc:2864(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool))[0x64df26]
      sql/sql_base.cc:2465(open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*))[0x55c45e]
      sql/sql_base.cc:3936(open_and_process_table)[0x55dbea]
      sql/sql_update.cc:286(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x63caf1]
      sql/sql_parse.cc:3672(mysql_execute_command(THD*))[0x5a5bc9]
      sql/sql_parse.cc:7049(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5a813a]
      sql/sql_parse.cc:1466(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5aad85]
      sql/sql_parse.cc:1097(do_command(THD*))[0x5ab027]
      sql/sql_connect.cc:1351(do_handle_one_connection(THD*))[0x675540]
      sql/sql_connect.cc:1264(handle_one_connection)[0x675752]
      perfschema/pfs.cc:1863(pfs_spawn_thread)[0xaa2459]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: