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

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]