Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1
-
Fix Version/s: 10.0.15-FusionIO, 10.1.2
-
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB, Tests
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]
Gliffy Diagrams
Attachments
Issue Links
- blocks
-
MDEV-7172 Fix buildbot failures in 10.1 tree
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.