Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
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
|
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
- blocks
-
MDEV-7172 Fix buildbot failures in 10.1 tree
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Component/s | Storage Engine - XtraDB [ 10135 ] |
| Summary | innodb.innodb-page_compression_zip fails in buildbot on Windows | innodb.innodb-page_compression_zip fails in buildbot |
| Description |
http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6563/steps/test/logs/stdio {noformat} 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 {noformat} |
http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6563/steps/test/logs/stdio {noformat} 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 {noformat} http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/861/steps/test/logs/stdio {noformat} 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] {noformat} |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.1.2 [ 15801 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.0.15-FusionIO [ 15401 ] |
| Workflow | MariaDB v2 [ 58651 ] | MariaDB v3 [ 62454 ] |
| Workflow | MariaDB v3 [ 62454 ] | MariaDB v4 [ 148514 ] |
commit 1a05bb4010aed7c8353f5d75be0b1cfc520e87cc
Author: Jan Lindström <jan.lindstrom@skysql.com>
Date: Mon Nov 24 10:01:49 2014 +0200
MDEV-7166: innodb.innodb-page_compression_zip fails in buildbotAnalysis: If innodb_use_trim is not enabled or system does not
support fallocate to make persistent trim, we should always
write full page not only partial pages.